PORTAL USER GUIDE
Spatialise Aggregated Dataset
The AURIN portal stores most datasets as geographically explicit datasets, to optimise web-based interactivity. This means most datasets in their original form are non-spatial tables that contain a key providing the ability to be joined to a single “template” of geometries (such as the Australian Statistical Geography Standard (ASGS)). This is a fast and lightweight solution, as the geographies are standard coverages, meaning we only need to store one description of the geography and apply it many times.
The Spatialise Aggregated Dataset tool joins a non-spatial table to its respective spatial geography. This is performed automatically through Portal by finding the unique geographic identifier in the dataset and joining it to the stored geometry. This allows the dataset to be used with the spatial statistic tools in the AURIN Portal and allows the dataset to be downloaded in a geospatial data format (such as a Shapefile or GeoJSON) for offline use in your own system.
To demonstrate this tool, we will spatialise some Australian Early Development Census (AEDC) data in Tasmania.
Select Tasmania as your area.
Select AEDC – Language and Cognitive Skills (SA3) 2009-2018 as your dataset and select all variables.
Open the Spatialise Aggregated Dataset tool (Tools → Spatial Tools → Spatialise Aggregated Dataset) and enter select the dataset that you want to spatialise. In this instance, we select AEDC – Language and Cognitive Skills (SA3) 2009-2018. Alternatively, you can access the tool by clicking the spanner icon for the dataset and selecting Spatialise Dataset.
The input parameters are summarised in the image below, once complete click Run Tool.
Once the tool has run, open the output dataset’s table and if successful, the table will include the same data as the original table. Alongside this, a geometry column will be evident, indicating that geometry has successful been joined to the table. The output dataset’s table also includes three buttons in the top left allowing the data to be downloaded as CSV, Shapefile and GeoJSON data formats.
It is good practice to give the spatialised dataset a meaningful name, by clicking the spanner icon and selecting Rename Dataset.