Data Dictionary
The documentation of the fields is as follows:
**** denotes a field that will be MISSING if NO taxonomic authority was found.
- "id": example "1cff000fe5ebfbe2fb7dd7c453c0f193227ada03", (Internal DB record identifier. Should not be searchable)
- "common name": The common name of the species as found in the state SWAP data file
- "scientific name": The scientific name of the species as found in the state SWAP data file
- "taxonomic category": Taxonomic category (optionally) provided in the state SWAP data file. This will be overridden by data matched in the sgcnTaxonomicGroupMappings.json file. If no match is found in the sgcnTaxonomicGroupMappings.json file, whatever data (if provided) in the original SWAP data will be used.
- "state": State where species was recorded in SWAP data
- "sciencebase_item_id": Sciencebase location for state SWAP data
- "record_processed": Date the record was processed by the SGCN pipeline
- "source_file_date": Date associated with the SWAP data file where the species was found
- "source_file_url": Web location of SWAP data for a specific state
- "year": Year that SWAP data was entered for the state (currently 2005 OR 2015)
- "clean_scientific_name": Derived from "scientific name" after cleaning up unrecognizable characters and numbers and other extraneous, unprocessable characters.
- "historic_list": true/false if species was found in the 2005SWAPSpeciesList.txt file
- "itis_override_id": true/null if species was found in the SGCN ITIS Overrides.json file
- "sppin_key": Internal search key. Should NOT be searchable externally
- "taxogroupings": Transient internal key that will always be null at this point
- ** "scientificname": Populated with the corrected scientific name ONLY IF found in a taxonomic authority (ITIS/WoRMS)
- ** "taxonomicrank": Populated with the corrected taxonomic rank ONLY IF found in a taxonomic authority (ITIS./WoRMS)
- ** "taxonomic_authority_url": Populated with the url associated with the taxonomic authority ONLY IF found (ITIS/WoRMS)
- ** "match_method": The method of scientific name that caused a match in the taxomic authority. Can be one of: "Exact Match", "Fuzzy Match", "Followed Accepted TSN", or "Found multiple matches"
- ** "class_name": The class of the species as designated by the taxonomic authority
- ** "commonname": The correct common name of the species as designated by the taxonomic authority
- "nationallist" : true / false Designates whether or not this species is on the National List. If the species has a taxonomic_authority OR the value of "historic_list" is true, then nationallist will be true.