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.

Link to File: https://northeastwildlifediversity.org/sites/default/files/2024-09/swap-import-instructions-and-metadata-v18.xlsx

Revision Notes

• 9/3/2024 (version 18)
  • Move Tidal Wetlands & Flats under the Estuarine Habitat Class
  • Move Tidal Rivers & Streams under the Estuarine Habitat Class
• 5/20/2024 (version 17)
  • Added Genesee and Lake Erie to the Habitat Modifier for Major River Basin
  • Fixed the naming of the Location Region to be Ridge and Valley.  It was previously Valley and Ridge.
• 4/29/2024 (version 16)
  • Added Freshwater beach pool as an option for Feature and Formations
• 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