A postgres/postgis script to create centroids for PSMA localities which are based on actual population concentration, rather than geometric centroids. Uses new open PSMA GNAF and PSMA Administrative Boundaries datasets. Assumes you are using the GNAF Loader and Cleaned Admin Boundaries
This process takes ~30-45 mins.
This is never a perfect process! whilst every effort has been made to make a more usable centroid dataset than what currently exists for PSMA locality boundaries, this is but one methodology, it has it's flaws and doesn't work perfectly for all situations. It's up here for any suggestions or improvements. But note, the process needs to be data driven and repeatable 4 times per year!
You can run the script to get the result or just download the data from here:
Incorporates or developed using G-NAF ©PSMA Australia Limited licensed by the Commonwealth of Australia under the Open Geo-coded National Address File (G-NAF) End User Licence Agreement.
Incorporates or developed using Administrative Boundaries ©PSMA Australia Limited licensed by the Commonwealth of Australia under Creative Commons Attribution 4.0 International licence (CC BY 4.0).
- You will need to run the gnaf-loader script to load the required Admin Bdy and GNAF tables into Postgres
- Will assume you have the gnaf and admin-bdys schemas populated with data as per above. This data will be created as a new table in the admin-bdys schema
- Postgres 9.x (tested on 9.3, 9.4 & 9.5 on Windows and 9.5 on OSX)
- PostGIS 2.1+
Trimming the boundaries to the coastline removes a small number of bay or estuary based localities. These have very few G-NAF addresses.
As an alternative you could perform this operation on the raw PSMA localities file instead.