GeoJSON Converter

CSV Data Format

The CSV to GeoJSON conversion tool can be used to help with the creation of GeoJSON files for NEMSR. This tool can read CSV files and convert them into GeoJSON for submission to NEMSR.

If 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 provided example files.

CSV Data Format

  • The NEII team will do a final QA review of your CSV data files and convert to GeoJSON format and then send back to you for uploading to NEMSR. Alternatively you may complete the conversion process yourself using the CSV to GeoJSON Converter Tool (remembering to scroll down).
  • Before uploading to the live NEMSR, please do a final review of your data visually by doing a 'drag and drop' of the GeoJSON file onto the NEII Viewer – check the location of sites (dots on the map) appear where you expect and the metadata displayed is correct. Note that the data labels may not be correct but make sure the actual data values are correct. If there are any issues, you will need to fix the data in the CSV data files and then we go through this process again until it's perfect. 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 these templates are important and cannot be shifted 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 this Guide for help.
  • There are 5 extension fields which are used for capturing additional data categories for the network or sites. The templates don't accommodate more than 5 extension fields. If you do not have any extra data to include in the extension fields, then leave these blank – do not delete the unused columns.
  • You will notice in the network details template there are 'extension field names' and in the sites details template there are 'extension field values' – these are corresponding fields – so an example is:
    • extension field name: Receiver Type
    • extension field value: Digital receiver
  • There are 3 options for 'environmental theme', it is mandatory to enter at least one value, or you may select multiple values.
  • The fields: firstObservationDate and finalObservationDate must be in date format or left blank (it doesn't accept free text like 'ongoing'). Enter date as: YYYY/MM/DD
  • If your dataset has multiple observing properties, the additional columns need to be appended to the existing 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 live to NEMSR, you may wish to embed the URL that is unique to your data, for your data users. First open the dataset in the NEII Viewer, then click on the 'Share' button, then click on the box 'Shorten the share URL using a web service'. You can now copy the shortened URL to embed on your website or to send to your users.

In future, you can do updates to your datasets by repeating this process and uploading the whole GeoJSON file as a complete overwrite of the existing full dataset – this is a replacement of the dataset, so ensure the updated file contains all the data records not just the updated components.