2.2 Shared Drive Files

2.2.1 General Structure

The Shared Drive is organized into five main folders:

  • central-<UNK>-resources: includes meeting and event information, onboarding materials, information about travel reimbursements, and the team roster

  • communications: includes the blog schedule, Adobe design projects, PowerPoint templates, photo repository, logos, and publication and media tracking

  • data: includes the data directory and all datasets we work with (see section 2.2.3 for more on this)

  • projects: includes information on past and current projects, and project management guidelines

  • strategy: includes information about ’s strategic plan

A full table of contents can be seen here.

2.2.2 Project Folder Structure

Each project folder must contain the following 6 folders:

  • data: This data folder will contain a data_overview spreadsheet and all of the intermediate datasets as well as output datasets associated with the project (see section 2.2.3 for more on this). Be sure to also add a copy of your final datasets to the <UNK>/data folder and data directory.

  • deliverables: final reports, paper manuscripts, other final deliverables not related to data outputs

  • grant-reporting: grant reports for funders

  • meetings-and-events: meeting notes, agendas, documentation for workshop/event planning

  • presentations: any presentations created for the project

  • project-materials: everything else that does not fit into one of these folders (i.e. drafts of methods, literature review, etc.)

From here, each project can add sub-folders as they see fit within these 6 folders.

2.2.3 Data Storage

As stated above, there are two locations in which data can be stored. The two locations are OneDrive/Shared drives/<UNK>/projects/example-project/data and OneDrive/Shared drives/<UNK>/data. This may seem confusing and redundant, but this section explains the differences between these two locations. As a short summary: example-project/data may contain raw, cleaned, intermediate, and output files for a given project, and will be used as the “workspace” while the project develops. On the other hand, <UNK>/data contains only (raw) input and output data from a finalized project. More detail is provided in the subsequent sections.

2.2.3.1 example-project/data

All data used in a project should live in this project-specific repository. To help keep track of project data, we highly recommend creating a data_overview spreadsheet (see section 3.3.2 for more information). This overview spreadsheet will provide a centralized summary of the data inputs and outputs for a project, and also allow teams to keep track of the status of adding the data to the <UNK>/data folder and creating the necessary metadata documentation. This repository will typically contain subfolders for raw, processed (or clean), and output, although each team might make slight modifications to this structure to suit their needs.

To illustrate how each of these subfolders might be used, consider the following. A team may receive data from partners, extract data from external sources, compile survey responses, create a new dataset from a literature review, or use results from previous projects as input. These data are termed “raw data” and should never be directly modified - all of the errors, mistakes, and gremlins should be kept in the original versions. Instead, they should be processed / cleaned, and then exported as “clean data” that is actually used in analyses. The script used to do the processing / cleaning then acts as a reproducable record of everything that was done to the raw data.

Suppose that a team working in Montserrat is tasked to perform a stock assessment on lobster populations and receives a database of lobster landings from the government. These data are stored as an excel spreadsheet, and will surely contain many mistakes that need to be fixed prior to running anly analyses. The team will clean the data (preferabily, using a reproducible script), and then export a new version of the data in which the mistakes have been fixed. The team will then perform the stock assessment, and produce results before reporting back. Therefore, the project-level data folder could be subdivided into raw, clean, and output folders. The first one will contain the excel file recieved from the government. The second folder will contain the cleaned data (perhaps exported as a csv), which can then be used as input for analyses within this project. The output folder will then contain the stock assessment results that might be relevant to other projects.

As stated above, since the output folder could contain information relevant to other projects, this data should be made available to other projects once the project is complete. To do this, any output data (and raw data if it is not already there) should be moved to the <UNK>/data folder, as described below.

2.2.3.2 <UNK>/data

As a general rule, this folder contains all data used and produced by projects. The idea is to make it easier for people to find data that has been used in previous projects, as well as to use previous results as inputs for new projects.

To illustrate types of data that should be in the <UNK>/data folder, consider the following. The RAM Legacy stock assessment database is key to many projects, and was used as input in the Costello et al. 2016 “upsides” paper. The “upsides database” is an output from the Costello paper, which has then been used as input for other projects. Therefore, the <UNK>/data folder contains separate folders for both the RAM and upsides datasets.

This large central data repository has the potential to become messy. Therefore, it is important to follow some key guidelines to store the data. All datasets in this folder should be contained within their own folders that include at minimum the data and metadata files. For example, a file structure for the two datasets mentioned above might be:

In the above example, the folder containing the upsides database is relatively straightforward with the metadata file and a single csv file. However, the folder containing the RAM database is more complicated as this is a dataset that is re-released every so often as a new version. Specific guidelines for organizing different types of data within the <UNK>/data folder are discussed in detail in section 3.