DOI: 10.7910/dvn/4eajoa
title: Global Experiment: CRSP Central Data Base Restored Files

description: Dataset contains recovered and restored data from the CRSP Central Database presented in two file formats: SQL and TAB. The original CSV files were converted to TAB on file upload by Dataverse. You can download the original CSV files by clicking the Download button and selecting "Original File Format (Comma Separated Values)." Data may not have been recovered completely. The entirety of the Central Data Base had been maintained on servers at Oregon State University (USA) and the Asian Institute of Technology (Thailand) that were decommissioned over a decade ago. Recovery involved accessing data files available from the archived PD/A CRSP website; it is uncertain whether those files were the most recently updated files from the Central Data Base. Metadata publications (loaded in the dataset) contain specific experimental protocols, analytical methods, instructions to data collectors for data entry, data entry protocols, and other metadata for each experimental cycle at each research location in Asia, Africa, and Central America. This dataset contains 117 files.
&lt;br&gt;
description: Data Submission Instructions are described in the PD/A CRSP Aquaculture Database
Data Submission Manual. All submitted data were accompanied by a Project Specification Form and sent to the CRSP Database Manager shortly after collection. This form included names and affiliations for research personnel, references for research publications, site and facility descriptions, and experiment specifications. Names and affiliations were required for citations of datasets extracted by Database users, analogous to scientific journal citations. Publication references (CRSP and non-CRSP) that describe materials and methods and/or report research results were required to link datasets to supporting literature. Unfortunately, when both the Oregon State University (USA) and Asian Institute of Technology (Thailand) servers hosting the Global Experiment Database (GED) lost the Central Data Base in the late-1990s to the mid-2000s, these metadata were also lost. While great attempts were made afterwards to reconstruct the data, and are presented here in this Dataverse, the above mentioned forms were not found. At OSU, the server located in the then called Bioresource Engineering department experienced a loss after a server upgrade. After years of low activity on global database access, and changes in personnel, the database was no longer accessible. At the shadow site, hosted by AIT in Thailand, a similar fate befell the GED. The reconstruction of the database by Hillary Egna, Shawn Hayward, and Cole Ensminger took years, on-and-off from 2012 to 2019, and it remains unclear if all data were captured for each site and cycle. The most reliable data for each site are therefore presented in “hard copy” format in the dataset called Data Reports. The recovered files are presented as .csv files uploaded in this Central Data Base dataset and are useful insofar as they are complete, digital, and manipulable. Data Formatting procedures and instructions can be found in the Database Data Submission Manual referenced in this dataset, and on the archived CRSP website.
description: The original database was a product under the former Pond Dynamics/Aquaculture Collaborative Research Support Program (PD/A CRSP) and may be cited thusly if extracted from the archived website and older publications. The recovered and restored dataset presented in this dataverse was a product under the former AquaFish Innovation Lab (AquaFish IL) and under Oregon State University and may be cited thusly. Dr. Hillary Egna was Lead Principal Investigator during both grants and time periods. Original data managers and collectors names are credited under contributors. Authors for this dataset are those who devoted much effort and time to recovering data, recreating historical files, translating and restoring data, and making data accessible in this dataverse.