Ecological Stoichiometry Cooperative

ESC

Return to the STOICH Database Home

Template Data Entry Guide and FAQ

Table of Contents

Data Entry Guide:

Steps-by-step directions on how to enter data into the template.

FAQs:

Frequently asked questions on entering data into the template.

Template Outline:

List of column headings found in the data template and instructions on how to complete the column's cells including cell formatting and definitions.

Data Entry Guide - How to enter your data into the Data Template
back to top

  1. Transfer relevant data from your datasheet to the STOICH data template (found here).
    1. Begin by entering required data. If not all required data is available, see FAQs for more details on what to do with an incomplete dataset.
      1. Pay special attention to making sure the C, N, and/or P values are associated with whole-organism or whole-resource (homogenous) samples.
      2. The STOICH project is most interested in whole-organism samples for accurate representation of whole-body stoichiometry. If you include tissue-specific samples or other partial-organism samples in your dataset, you must indicate this in the column "Stoichiometry_Origin_Organism."
      3. Make sure the organism or resource sample is collected from the field or a natural setting.
    2. Expand hidden cells by selecting all cells and then using the menu bar to select Format → Column → Unhide
    3. Fill out the template with your remaining data, making notes when your dataset has additional data that does not fit into the template (see FAQs).
    4. If you are submitting multiple publications worth of data with distinct datasets, please duplicate the "Template" tab and save each distinct dataset in its own tab or as it's own document.
  2. Email the completed data template to STOICH.project.contact@gmail.com
    1. Indicate whether you have interest in co-authorship on the manuscript accompanying the initial data release.
    2. Your response to STOICH.project.contact@gmail.com with data, either raw or in the STOICH data template, indicates that you consent to publication of your data in the STOICH database and acknowledge its public use under Creative Commons Attribution-NonCommercial 4.0 International License.

FAQs
back to top

  1. What data is required for a complete dataset?

    Complete datasets must have the data enterer's name and the date of data entry as well as the site name, the sample date, and stoichiometric measurements of organic material that include at least two of the following elements with their associated units: carbon, phosphorus, and/or nitrogen.

    Columns within the STOICH data template that indicate required data contain red cells until the cells are filled. These columns are as follows:

    Data_entry_name
    Data_entry_date
    Site_name
    Date

    At least two of the three following, with their associated units (indicated in yellow):

    C_content_Organism
    P_content_Organism
    N_content_Organism

  2. How do I reveal hidden columns?

    To reveal all hidden columns in the excel spreadsheet, select all of the columns and then use "Format" in the menu bar to select "Column", and click on "Unhide."

  3. What if I don't have all of the required data?

    If you don't have the required data, but think your dataset is still relevant to STOICH, please email us at STOICH.project.contact@gmail.com.

  4. What if my dataset contains extraneous or additional data?

    If the dataset you are attempting to enter into the template contains extra data (data that doesn't fit into the template), make the comment "additional data" in the appropriate notes sections (i.e. Notes_Water) and create a new tab in the data template labeled "additional data." Add your additional data to the "additional data tab." Please include any relevant metadata.

  5. What do the colors Mean?

    Column Heading Colors

    Each color correlates to a data type (i.e. blue represents water chemistry data).

    Black Column Heading
    Information regarding the data enterer
    Gray Column Heading
    Data specific to the site location, spatial information
    Green Column Heading
    Data specific to each individual sampling event, temporally influenced information
    Yellow Column Heading
    Organism (living or dead at the time of collection) data and metadata
    Blue Column Heading
    Water chemistry data
    Orange Column Heading
    Data source information

    Yellow Subheadings

    Yellow subheadings
    Indicate a validated cell that is not required to be filled, but does contain specific requirements for entry (i.e. selection via dropdown menu).

    Red Cells

          Blank red cells indicate compulsory data. These red columns are validated cells which will remain red until filled.
    Exception: All C_content_Organism, N_content_Organism, and P_content_Organism cells are red. However, you are only required to have data for two of these fields.

    Yellow Cells

          Blank yellow cells indicate compulsory metadata ONLY when there is associated data. These yellow columns are validated cells which will remain yellow until filled.
    Example: Completing the cell for the column, C_units_Organism, is only required when there is associated data in the C_content_organism column.

  6. Experimental/lab and field-collected data

    If you have both lab or experimental data as well as field data, only enter the data collected in the field into the STOICH data template.

    See additional data for more detailed instruction on options for what to do with lab data.
    See the document, "Data Inclusion Requirements" in the Contributor Resources folder for more details on specific data requirements.

  7. Marine and inland data

    If you have both inland and non-inland data, only enter the inland or estuarine data into the STOICH data template.

    See additional data for more detailed instruction on options for what to do with lab data.
    See the document, "Data Inclusion Requirements" in the Contributor Resources folder for more details on specific data requirements.

  8. Data is in the wrong units

    Wrong Units

    Please transform your units to match those that we have provided in the "units" column. We have provided units that are common for each type of measurement, and would like the units to remain standardized across the STOICH database for optimized user experience.

    See below for resources for unit conversion in R
    https://www.rdocumentation.org/packages/units/versions/0.8-0
    https://r-quantities.github.io/units/reference/units.html

    Wrong Coordinate System

    Lat or Long
    If the site location information is not lat/long in decimal degrees (DD.DDDDD), use google maps (https://www.google.com/maps) to convert the current coordinate system to lat/long.

  9. My data is transformed data, now what?

    Corrected data

    If your data has been transformed in order to standardize or correct the data to a more accurate value (i.e. due to drifting analytical equipment), please use this data, and not the raw data. Add a note in the associated note column.

    If you would like to add additional transparency, please consider following additional data guidelines.

    Statistical transformations

    In some data columns, the mean and standard deviations are accepted. However, log transformation and other similar changes to raw data are not accepted in the template. Please use only your raw data, unless your data falls under the category of "corrected data."

  10. Partial organism or tissue-specific stoichiometry - does it count?

    At least some of your stoichiometry data needs to be derived from a whole-organism or whole-body sample. The STOICH project is most interested in whole-organism or whole-resource stoichiometry. If there is partial organism stoichiometry in addition to whole-organism stoichiometry, make a note in the Stoichiometry_Origin_Organism column.

    Exceptions to the whole-organism rule:
    Gut clearance is acceptable
    Shell removal is acceptable

  11. Multiple water samples correlate with a single organism sample

    Example scenarios - multiple water samples at various depths, but single plankton tow covering the entire water column.
    Solution: correlate one water sample with the single plankton sample, leave the rest of the organism samples blank to avoid replication.

  12. Multiple organism samples correlate with a single water sample

    Example scenarios - single water sample, but multiple plankton species measured for stoichiometry from a single tow.
    Solution: correlate water sample with only one plankton species, leave the rest of the water samples blank to avoid replication.

Template Outline
back to top

Data Entry
Data_entry_name REQUIRED
Name of the person entering data. NA
Format:string, capitalized, [Last_First]
Validation: Cell is red until cell is filled.
Data_entry_date REQUIRED
Year, month, and day of the data entry. NA
Format:date, YYYY-MM-DD
Validation: Cell is red until cell is filled.
Site (Location) Information
Site_name REQUIRED
Descriptive name of location where sample was collected NA
Format:string, all lowercase
Validation: Cell is red until cell is filled.
Country REQUIRED
Full name of country where sample was collected, no abbreviations. NA
Format:string, capitalized
Validation: Cell is red until cell is filled.
State_province REQUIRED
Full name of the state or province where the sample was collected. If there are multiple states (i.e. a lake is in Idaho and Utah), then separate with a comma (,). NA
Format:string
Validation: Cell is red until cell is filled.
Lat
Latitude of site location where sample was collected. NA
Format:numeric, DDD.DDDDD, degrees
Validation:Input Message: Decimal Degrees: DDD.DDDDD
Long
Longitude of site location where sample was collected. NA
Format:numeric, DDD.DDDDD, degrees
Validation:Input Message: Decimal Degrees: DDD.DDDDD
Ecosystem_type
The type of ecosystem where sample was collected. NA
Format:list
Lake, Reservoir, Stream, Wetland, River, Saline Lake, Pond, Coastal, NA
Validation:list
Input Message: Utilize database glossary for definitions of: Lake, Reservoir, Stream, Wetland, River, Saline Lake, Pond
Ecosystem_type_other
If "Ecosystem_type" = NA to indicate other, specify what other type it is. NA
Format:string, lowercase
Validation:NONE
Trophic_status
Ecosystem trophic state NA
Format:list
Oligotrophic, Mesotrophic, Eutrophic, NA
Validation:list
Input Message: Utilize the database glossary for definitions of: Oligotrophic, Mesotrophic, Eutrophic
Trophic_status_other
If "Trophic_status" = NA to indicate other, specify what the other status is. NA
Format:string, lowercase
Validation:NONE
Elevation_m
Meters above sea level. NA
Format:numeric, meters
Validation:Input Message: Elevation in meters, sometimes referred to as "altitude"
Formula: value must be a number or "NA"
=OR(AND(EXACT({cell_ref}, UPPER({cell_ref})), {cell_ref} = "NA", ISTEXT({cell_ref})), ISNUMBER({cell_ref}))
Notes_SampleLocation
Additional notes related to the sample location data. NA
Format:string
Validation:NONE
Field (Sampling Event) Data
Sample_Start_Date REQUIRED
Date sample was collected or if a range of dates, start of the sampling event. NA
Format:date, YYYY-MM-DD
Validation:Input Message: YYYY-MM-DD
Cell is red until cell is filled.
Sample_End_Date REQUIRED
If a range of dates, end of the sampling event. NA
Format:date, YYYY-MM-DD
Validation:Input Message: YYYY-MM-DD
Cell is red until cell is filled.
Habitat_type
Describes the aquatic habitat from which the sample was collected during the sample event, at the specific unique site ID. NA
Format:list
Pelagic, Benthic, Littoral, Riparian, NA
Validation:list
Depth_m
Depth the sample was collected. NA
Format:numeric, meters
Validation:Input Message: Depth in meters
Formula: value must be a number or "NA"
=OR(AND(EXACT({cell_ref}, UPPER({cell_ref})), {cell_ref} = "NA", ISTEXT({cell_ref})), ISNUMBER({cell_ref}))
Air_temp
Air Temperature at time of collection in degrees Celsius. NA
Format:numeric, Celsius
Validation:NONE
Water_temp
Temperature of water at time of collection at the most representative location in degrees Celsius, okay to report mean value. NA
Format:numeric, Celsius
Validation:NONE
Cloud_cover
Cloud cover as a percentage. NA
Format:integer, 0 to 100, percent
Validation: Decimal number between 0 and 100
Canopy_cover
Canopy cover as a percentage. NA
Format:integer, 0 to 100, percent
Validation: Decimal number between 0 and 100
Light
Measurement of light levels at time of collection at the most representative location. OK to report a mean value. NA
Format:numeric
Validation:NONE
Light_units
Units in which light levels were measured in "Light"(list: micromole per second and square meter [umol_m2_s1], lumen [lm] or lumens per square meter[lm_m2]) NA
Format:list
umol_m2_s, lm, lm_m2, NA
Validation:list
Input Message: µmol_m2_s = micromoles per square meter per second,
lm = lumens,
lm_m2 = lumen per square meter (lux)
Cell is yellow if a numeric value is defined but units have not been defined.
Notes_SampleEvent
Additional notes related to the sample event data. Example: two measures of DO were taken, one can be recorded in the DO column, and one can be included here.
Format:string
Validation:NONE
Organism (Animal/Resource) Data
Type_Organism
Type of organism being sampled for stoichiometry data. NA
Format:list
Fish, Insecta, Mollusca, Annelida, Amphibian, Crustacean, Periphyton, Seston, Detritus (FPOM), Detritus (CPOM), Detritus (Other), Macrophyte, Bryophyte, Zooplankton, Invertebrates (Other), Microbial (Other), Other, NA
Validation:list
Type_other_Organism
If "NA" was selected for Type_Organism to indicate something other than the listed organism types, then define what organism type it is. NA
Format:string, lowercase
Validation:NONE
Origin_Organism
Original source location of the organism being measured. For example, indicate "benthic" if your sample was collected from the bottom of a lake (list) NA
Format:list
Benthic, Sestonic, Epipsammic, Epiphyte, Epixylon, Epilithon, Epizootic, Epipelon, NA
Validation:list
Trophic_mode_Organism
Identify the trophic mode of your sample (list) NA
Format:list
photoautotroph, chemoautotroph, herbivore, omnivore, carnivore, detritivore, saprotroph, other
Validation:NONE
Kingdom_Organism
Organism's taxonomic kingdom NA
Format:list
Archaebacteria, Eubacteria, Protista, Chromista, Fungi, Plantae, Animalia
Validation:list
Order_Organism
Organism's taxonomic order. Indicate "NA" for unknown or for multiple known orders. If multiple known, indicate in Note_Organism column. NA
Format:string, lowercase
Validation:NONE
Family_Organism
Organism's taxonomic family. Indicate "NA" for unknown or for multiple known families. If multiple known, indicate in Notes_Organism column. NA
Format:string, lowercase
Validation:NONE
Genus_Organism
Taxonomic Genus of organism. Indicate "NA" for multiple genera, known or unknown. If known, list in Notes_Organism. NA
Format:string, lowercase
Validation:NONE
Species_Organism
Species epithet of organism. Indicate "sp" for single unknown species. Indicate "spp" for multiple species, known or unknown. If known, list in Notes_Organism. NA
Format:string, lowercase
Validation:NONE
Sample_pooling_Organism
How individual organism(s) were pooled for the sample NA
Format:list
single_individual, multiple_individuals, subsample_composite, NA_unknown
Validation:list
Statistical_pooling_Organism
Whether a given observation is statistically pooled or not. Is this observation from one raw independent measure of a sample, or summarizing multiple observations. NA
Format:list
Independent, Aggregate, NA_unknown
Validation:list
Sample_size_Organism
Number of individual (statistical) samples contributing to measurement (e.g. a mean) for the sampling event. NA
Format:integer, greater than 0, less than 1 million, or NA
Validation:Formula: value must be from 0 to 1,000,000, or NA
=OR(AND({cell_ref}>0,{cell_ref}<=1000000), {cell_ref}="NA")
Development_stage_Organism
Name of developmental stage, i.e. pupa, if applicable. NA
Format:string, lowercase
Validation:NONE
Gut_clearance
Did the sample organism(s) have their guts cleared or removed. i.e. caddisflies often have their guts removed before whole-body element analysis occurs NA
Format:list
Clearance, Gut_Removed, NA
Validation:list
Organism_mass
Measured value NA
Format:numeric
Validation:NONE
Organism_mass_measure
Type of body mass measurement NA
Format:list
Dry, Wet, AFDM, Carbon, NA
Validation:list
Cell is yellow if a numeric value is defined but the measurement type has not been defined.
Organism_mass_units
Units used in Body_mass NA
Format:list
kg, g, mg, ug, mg_L, ug_L, mg_cm2, ug_cm2, NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
Organism_mass_notes
Additional notes related to body mass. NA
Format:string, lowercase
Validation:NONE
Stoichiometry_Origin_Organism REQUIRED
Indicate whether the elemental measurements or stoichiometric values are representative of the entire organism (whole_organism) or only part of the organism (partial_organism). NA
Format:list
whole_organism, partial_organism, NA
Validation:list
Cell is red until cell is filled.
Stoichiometry_Tissue_Organism
If you selected "partial_organism" in the "Stoichiometry_Origin_Organism" column, use this note section to indicate what part of the organism was sampled for these elemental measurements NA
Format:string, lowercase
Validation:NONE
C_content_Organism
The amount of carbon measured in the sample. NA
Format:numeric
Validation: Cell is red until cell is filled.
C_sd_Organism
standard deviation of carbon NA
Format:numeric
Validation:NONE
C_unit_Organism
Units of measurement of C content NA
Format:list
percent_dm, mg_g_dm, umol_L, mg_L, mg_cm2, ug_L, ug_cm2, NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
C_unit_other_Organism
If "NA" was selected for C_unit to indicate other, then define what unit it is. NA
Format:string, lowercase
Validation:NONE
C_method_Organism
Analysis for measuring C content. NA
Format:list
CHN_analysis, LOI_C, NA
Validation:list
C_method_other_Organism
If "NA" was selected in C_method to indicate "other", then define what the method is. NA
Format:string
Validation:NONE
C_method_link_Organism
If the organismal carbon analysis method has an associated link to information about the method type or method protocol, add the URL here NA
Format:string, URL
Validation:NONE
N_content_Organism
The amount of nitrogen measured in the sample. NA
Format:numeric
Validation: Cell is red until cell is filled.
N_sd_Organism
standard deviation of nitrogen NA
Format:numeric
Validation:NONE
N_unit_Organism
Units of measurement of N content. NA
Format:list
percent_dm, mg_g_dm, umol_L, mg_L, mg_cm2, ug_L, ug_cm2, NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
N_unit_other_Organism
If "NA" is selected in N_unit to indicate other then define what unit it is. NA
Format:string, lowercase
Validation:NONE
N_method_Organism
Analysis for measuring N content NA
Format:list
CHN_analysis, Kjedahl, persulfate, NA
Validation:list
N_method_other_Organism
If "NA" is selected in N_method to indicate "other", then define what method it is. NA
Format:string, lowercase
Validation:NONE
N_method_link_Organism
If the organismal nitrogen analysis method has an associated link to information about the method type or method protocol, add the URL here NA
Format:string, URL
Validation:NONE
P_content_Organism
The amount of phosphorus measured in the sample. NA
Format:numeric
Validation: Cell is red until cell is filled.
P_sd_Organism
The standard deviation of phosphorus NA
Format:numeric
Validation:NONE
P_unit_Organism
Units of measurement of P content NA
Format:list
percent_dm, mg_g_dm, umol_L, mg_L, mg_cm2, ug_L, ug_cm2, NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
P_unit_other_Organism
If "NA" is selected in P_unit to indicate other, then define what the unit is. NA
Format:string, lowercase
Validation:NONE
P_method_Organism
Analysis for measuring P content NA
Format:list
ICP_OMS, acid_digest, persulfate_digest, NA
Validation:list
P_method_other_Organism
If "NA" is selected in P_method to indicate "other", then define what the method is. NA
Format:string, lowercase
Validation:NONE
P_method_link_Organism
If the organismal phosphorous analysis method has an associated link to information about the method type or method protocol, add the URL here NA
Format:string, URL
Validation:NONE
CN_molar_Organism
carbon to nitrogen molar ratio NA
Format:numeric
Validation: Cell is red until cell is filled.
CP_molar_Organism
carbon to phosphorus molar ratio NA
Format:numeric
Validation: Cell is red until cell is filled.
NP_molar_Organism
nitrogen to phosphorus molar ratio NA
Format:numeric
Validation: Cell is red until cell is filled.
Element_other_Organism
Mark "Y" only if other element(s) (not C, N, or P) are reported for a whole-body organism in association with the dataset NA
Format:list
Y, NA
Validation:list
Isotope_13C_Organism
Must be on Vienna Pee Dee Belemnite (VPDB) scale. NA
Format:numeric, permil, little delta is implied
Validation:NONE
Isotope_13C_sd_Organism
Carbon 13 isotope standard deviation for organismal pooling, not for lab/analytical. NA
Format:numeric, greater than 0
Validation:NONE
Isotope_15N_Organism
Must be on Atmosphere air scale. NA
Format:numeric, permil, little delta is implied
Validation:NONE
Isotope_15N_sd_Organism
Nitrogen 15 isotope standard deviation for organismal pooling, not for lab/analytical. NA
Format:numeric, greater than 0
Validation:NONE
Isotope_other_Organism
Mark "Y" if the dataset may include stable isotope data for the given animal other than 13C or 15N. NA
Format:list
Y, NA
Validation:list
Chlorophyll_Organism
Measure of chlorophyll content of resource. NA
Format:numeric
Validation:NONE
Chlorophyll_units_Organism
Units of chlorophyll measure. NA
Format:list
ug_L, ug_cm2, ug_mg_dm, NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
Quantity_Organism
Mark "Y" if the dataset may include data on resource quantity (standing stocks or biomass) from the field site. NA
Format:list
Y, NA
Validation:list
Sample_Id_Organism
Indicate the sample ID as used in the original dataset. This is a user-contributed column for tracking purposes. There is no database-wide organization for this identification. It is unique to each contributed dataset within the STOICH database. NA
Format:string
Validation:NONE
Notes_Organism
Additional notes related to organismal (animal or resource) data. NA
Format:string
Validation:NONE
Water Chemistry
Spec_conductivity
Water conductivity as specific conductivity. NA
Format:numeric, uS/cm
Validation:NONE
pH
pH value NA
Format:numeric, value from 0 to 14
Validation: Decimal number between 0 and 14
DO
Measurement of dissolved oxygen. NA
Format:numeric
Validation:NONE
DO_units
Unit in which the measurement of dissolved oxygen was taken. NA
Format:list
percent, mg_L, ppm, other
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
DOC
Dissolved Organic Carbon concentration. NA
Format:numeric
Validation:NONE
DOC_units
Units of DOC measurement. NA
Format:list
umol_L, mg_L (C), ug_L (C), ppm (C), NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
NH4
Concentration of elemental N in ammonium. NA
Format:numeric
Validation:NONE
NH4_units
Units of NH4 measurement. NA
Format:list
umol_L, mg_L (N), ug_L (N), mg_L (NH4), ug_L (NH4), mEq_L, ppm (N), ppm (NH4), NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
SRP
Concentration of elemental P as Soluble Reactive Phosphorus. NA
Format:numeric
Validation:NONE
SRP_units
Units of SRP measurement. NA
Format:list
umol_L, mg_L (P), ug_L (P), mg_L (PO4), ug_L (PO4), mEq_L, ppm (P), ppm (PO4), NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
NO3
Concentration of elemental N in Nitrate. NA
Format:numeric
Validation:NONE
NO3_units
Units of NO3 measurement. NA
Format:list
umol_L, mg_L (N), ug_L (N), mg_L (NO3), ug_L (NO3), mEq_L, ppm (N), ppm (NO3), NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
TDN
Total Dissolved Nitrogen NA
Format:numeric, in units of elemental Nitrogen
Validation:NONE
TDN_units
Units of Total Dissolved Nitrogen measurement NA
Format:list
umol_L, mg_L (N), ug_L (N), ppm (N), NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
TN
Total Nitrogen NA
Format:numeric, in units of elemental Nitrogen
Validation:NONE
TN_units
Units of total nitrogen NA
Format:list
umol_L, mg_L (N), ug_L (N), ppm (N), NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
TDP
Total Dissolved Phosphorus NA
Format:numeric, in units of elemental Phosphorus
Validation:NONE
TDP_units
Units of Total Dissolved Phosphorus NA
Format:list
umol_L, mg_L (P), ug_L (P), ppm (P), NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
TP
Total Phosphorus NA
Format:numeric, in units of elemental Phosphorus
Validation:NONE
TP_units
Units Total Phosphorus NA
Format:list
umol_L, mg_L (P), ug_L (P), ppm (P), NA
Validation:list
Cell is yellow if a numeric value is defined but units have not been defined.
Statistical_pooling_Water
Whether a given observation is statistically pooled or not. Is this observation from one raw independent measure of a sample, or summarizing multiple observations. NA
Format:list
Independent, Aggregate, NA
Validation:list
Sample_size_Water
Number of individual (statistical) samples contributing to measurement (e.g. a mean) for the sampling event. NA
Format:integer
Validation:NONE
Other_elements_Water
Mark "Y" only if other element(s) (not C, N, or P) dissolved within the water are reported in association with dataset. NA
Format:list
Y, NA
Validation:list
Sample_Id_Water
Indicate the sample ID as used in the original dataset. This is a user-contributed column for tracking purposes. There is no database-wide organization for this identification. It is unique to each contributed dataset within the STOICH database. NA
Format:string
Validation:NONE
Notes_Water
Additional notes related to water chemistry data NA
Format:string
Validation:NONE
Source Information
Source_type
The source for this set of data. NA
Format:list
manualextraction_paper, raw_author, raw_repository, raw_unpublished, NA
Validation:list
Source_DOI
If DOI is available; for published dataset or publication NA
Format:string
Validation: Cell is red until cell is filled, required for database/repository data.
Source_URL
If available; for publicly accessible data sources NA
Format:string
Validation: Cell is red until cell is filled, required for database/repository data.
Source_title
If the source of this data has a title, write the full title here. NA
Format:string, lowercase
Validation:NONE
Source_author_first
If applicable, list the first author of the source of this data; for published sources. Use the format Last, First. Example: Doe, Jane NA
Format:string, capitalized
Validation:NONE
Source_year
If applicable, list the publication year, or the year that this data became publicly available. NA
Format:integer, YYYY
Validation:NONE
Source_journal
If the source was published, list the journal. i.e. Ecosystems. NA
Format:string, lowercase
Validation:NONE
Source_publisher
NA NA
Format:string
Validation:NONE
Source_license
The license used if the data was previously published. NA
Format:list
CC BY-NC-SA 4.0, CC BY, MIT, CC BY-NC 3.0, CC BY-SA 4.0, CC0 1.0, CC BY 3.0 US, GPL 3.0+, GPL-3.0
Validation:list
LitSurvey
Identifies if the source of the data is derived from the literature survey process. Was this data source found during the literature survey (either the author was contacted or the associated paper was discovered)? NA
Format:list
Y,N
Validation:list
LitSurvey_ID
If relevant, identify the lit survey unique ID. NA
Format:integer, 5-digit
Validation: integer greater than or equal to -1
Data_Affiliations
Identify the organizations affiliated with the dataset. If there are multiple organizations, separate them with a comma (,). NA
Format:string, alphabetical, comma separated, specific options as listed below:, federal, higher_education, NEON, NGO, state, tribe, other
Validation:Input message: Options (separate with commas): federal, higher_education, NEON, NGO, state, tribe, other
Source_contact_last
The last name of the person who has provided the dataset, or the corresponding author. NA
Format:string, capitalized
Validation: Cell is red until cell is filled, required for author/contributor data.
Source_contact_first
The first name of the person who has provided the dataset, or the corresponding author. NA
Format:string, capitalized
Validation: Cell is red until cell is filled, required for author/contributor data.
Source_contact_email REQUIRED
The email of the person who has provided the dataset, or the corresponding author. NA
Format:string, lowercase
Validation: Cell is red until cell is filled.
Notes_Source
Additional notes related to the data source. NA
Format:string
Validation:NONE
NSF"
The STOICH Project is supported by the NSF EPSCoR Track-2 Program