PORTAL USER GUIDE

Spatialise Coordinates

The Spatialise Coordinates tool generates a geometry column for datasets containing latitude and longitude data. This is useful if you have a CSV file with geometries that you would like to use on the portal.

SET UP

For this worked example, we will run the Spatialise Coordinates tool on a dataset of high school locations in Queensland.

  • Download the CSV of the data here.
  • Import the downloaded CSV file using the import button in the data panel.

  • Input the metadata for this dataset as follows:
    • Title: The name we will give our dataset in our data list. Type Queensland High Schools.
    • Abstract: Some information that describes our data. Type Point dataset of high schools in Queensland.
    • Aggregation Level: The aggregation of our data that matches one used in the portal. Select Non Aggregated.
    • Key: The column in our dataset that represents unique IDs of our data. Select ID.

Once the dataset has been imported, it’s a good idea to check that it is correct. Your dataset should look like the table below

Inputs

Navigate to the Geocode tool (Tools → Spatial Tools → Spatialise Coordinates) and enter the parameters as follows.

  • Dataset Input: The dataset that you would like to spatialise, in this case, the imported CSV. Select Queensland High Schools.
  • Latitude Column: The field containing the latitude data. Select Latitude.
  • Longitude Column: The field containing the longitude data. Select Longitude.

Once you have added these parameters click Run Tool.

Outputs

Once the tool has run, there will be a new dataset which is the same as the original, with a new column representing the spatialised geometry. We can now display this on the map by clicking on spanner icon on the output and selecting Display on Map.

Using all the defaults, the output map should look similar to the image below. Highlighting a point will show the variables associated with it.

Looking for Spatial Data?

You can browse the AURIN Data Discovery:

How can you Create Impact?

Learn more about AURIN Researcher's outcomes & real-world impact: