SWAP Import Instructions and Metadata

This spreadsheet explains all the tables in the import spreadsheet, fields that we need to collect and what values are accepted.  These tables include SGCN, Action, Threat, and Associated Habitats.  In the actual import spreadsheet the Associated Habitats are split into their own tabs and listed by their Habitat Class name.  The spreadsheet also includes helper tabs for the accepted Action Class, Threat Class, Habitat Classes/Types, and Taxons and Subtaxons.

  • 12/22/2023
    • Action and Threat classification updates
  • 12/5/2023
    • Added optional field "State Location" to Action and Threat
    • Added optional fields "State Listed" and "State Legal Status" to SGCN
    • Changed several fields on Action and Threat to Not Required
    • Added "Continental Shelf and Marine" as an option for action location
    • Changed Threat Class 12 to "Other Options" and added 6 sub classes for other threat classification needs
  • 11/6/2023
    • Added State Habitat Name to Associated Habitats
    • Added State Threat Name to Threats
    • Added State Action Name to Actions

 

Link to File: http://northeastwildlifediversity.org/sites/default/files/2023-12/swap-import-instructions-and-metadata-v14.xlsx

 

Publication date