Importing, Exporting, and Bulk-Editing Program Data

Use the provided templates to upload a CSV of new data, bulk edit existing data, or connect an ArcGIS Online Feature Layer to display BMP drainage areas.

Format your import data correctly on your computer to prevent any errors when importing new assets. 

Requirements for all import files

  • The import file must be a .csv.
  • Each column header should correspond to a property that exists for that asset to be properly imported.
  • The tool will match the column header the corresponding property name where possible. Otherwise, you can manually map your column headers to the corresponding property name. 
  • If you are using Excel for Mac, make sure to save your CSV file in the format of "Windows Comma Separated (.csv)". Otherwise you may have trouble importing mac CSV files. 

Importing Data

  1. Download the appropriate template (below)
  2. Format your dataset using the template
  3. Save your dataset as a .csv
  4. Select Import button in the blue banner
  5. Select the layer you would like to import
  6. Drag & Drop or Browse for your .csv file
  7. If necessary, fix any errors and map any column headers to the correct fields
  8. Click Import

Upload Templates

Error Messages

The import tool will generate error messages to indicate whether an entry is a conflict, invalid, ignored, or duplicate. 

  • A conflict is any entry that has an existing ID in the database. The import cannot be completed until these IDs are changed.
  • invalid is any entry that does not meet that field's formatting requirements (i.e. text in an integer field). The import cannot be completed until these IDs are changed.
  • An entry is ignored when a non-required field does not meet that field's formatting requirements.

Importing Structural BMP Drainage Areas

You can upload structural BMP drainage areas from ArcGIS Online using the steps below. This is currently not a live connection; meaning if the feature layer is updated on AGOL, it will not be updated in 2NDNATURE. We are working on ways to make this connection live, stay tuned!

  1. Upload structural BMP drainage areas to ArcGIS Online (if necessary)
  2. Ensure drainage area feature layer in AGOL contains a "BMP ID" field that maps to an existing BMP in 2NDNATURE.feature layer
  3. Navigate to the feature layer in AGOL and find the Service URL
  4. Copy the Service URL
  5. Navigate to 2NDNATURE platform
  6. Click  image-66 in the top banner
  7. Click Import Data
  8. Click Structural BMPs Drainage Area
  9. Paste the Service URL
  10. Map the BMP ID field to the correct field (if necessary)
  11. Click Import 

Editing Existing Data

Users can currently bulk-edit structural BMPs and industrial/commercial facilities. Functionality

coming soon for outfalls and projects!

To bulk-edit your existing data:

  1. Click  image-66 in the top banner
  2. Click Import Data
  3. Click either Structural BMPs or Facilities
  4. Click Download Data
  5. Open the .csv file and edit all fields as necessary, making sure to follow our formatting guidelines
    1. Note: if you are unsure of our formatting guidelines, please also download the corresponding template to review the data formatting requirements
  6. Save the file as a new .csv 
  7. Drag & Drop or Browse for your new .csv file
  8. Review any error messages and the number of BMPs that will be uploaded/edited
  9. If all looks good, click Import

Exporting Data

We are currently revamping the way data is exported. Users are able to currently export data from Structural BMPs, and TrashTo do so:

  1. Navigate to the module that you are interested in 
  2. Click in the top banner
  3. Click Export Data
  4. Select the format (Excel or Shapefile) that you would like 

If you would like to export other data that is not listed above, please contact customer support! We apologize for the inconvenience.