GeoJSON Converter

CSV data format

The CSV to GeoJSON conversion tool can be used to create GeoJSON files for the NEMSR. This tool reads the CSV files and converts them to a GeoJSON file for submission to the NEMSR.

When providing your data in CSV format, there are two templates to complete:

 1. NEMSR template_network.xlsx download and save as .csv (Step 1 CSV to GeoJSON Converter Tool)

 2. NEMSR template_site.xlsx download and save as .csv

For examples, refer to the these sample files.

CSV data format

  • The NEII team will QA your CSV files and convert to them to the GeoJSON format before sending them back to you for uploading to the NEMSR. Alternatively, you may do the conversion yourself using the CSV to GeoJSON Converter Tool. Scroll down the page to view all steps.
  • Before uploading to the NEMSR, please do a visual review of your data by 'dragging and dropping' the GeoJSON file onto the NEII Viewer. Check the location of sites (dots on the map) appear where you expect and the metadata is displayed correctly. Note that the data labels may not be correct but make sure the actual data values are correct. If there are any issues, fix the data in the CSV files and repeat the conversion process until the appearance is correct. If you are technically savvy, you may prefer to update the GeoJSON file directly.

Preparing the CSV data files

  • The order and titles of the columns in the templates are crucial, and cannot be moved around, deleted or changed. Please contact the NEII team if you are unsure how to enter your data in any of the fields. Refer to the information in the Guide for help.
  • There are five extension fields used for capturing additional data categories for the network or sites. The templates do not accommodate more than five extension fields. If you do not have extra data to include in the extension fields, then leave them blank – do not delete the unused columns.
  • In the network details template there are 'extension field names' and in the site details template there are 'extension field values' – these are corresponding fields, for example:
    • extension field name: Receiver Type
    • extension field value: Digital receiver
  • There are seven options for 'environmental theme'. It is mandatory to have one value, however multiple values may be entered.
  • The firstObservationDate and finalObservationDate fields must contain entries in date format, or left blank. If observations at a site are ongoing, leave the finalObservationDate field blank. Enter dates in the format YYYY/MM/DD
  • If your dataset has multiple observing properties, additional columns need to be inserted in the template as shown in this example. Once again, the order of the columns must not be altered. Please liaise with the NEII team for guidance.
  • Once the data is uploaded to the NEMSR, you may wish to provide the URL, that is unique to your data, to your data users. First, open the dataset in the NEII Viewer, then click on the 'Share/Print' button, then click the 'Advanced options', then click on the box beside 'Shorten the share URL using a web service'. You may now copy the shortened URL to embed on your website or to send to your users.

You may make future updates to your datasets by repeating the above process and uploading the whole GeoJSON file as a complete overwrite of the existing full dataset. As this is a replacement dataset, ensure the updated file contains all the data records not just the updated components.