EALGIS Data Loader: PostgreSQL Dumps

PostgreSQL database dumps generated from EALGIS's data loaders.

Download the dump files from below and restore them into your database.

Data Loaders

• 2016 Census
• 2011 Census
• Australian Electorates
• Australian Statistical Geography Standard
• Generic CSV Loader

Pre-requisites

• PostgreSQL 10+ with PostGIS 2.4+
• A knowledge of Postgres pg_restore parameters

Dumps

These dumps come from PostgreSQL 10.7 and PostGIS 2.5.

2016 Census

• Aboriginal and Torres Strait Islander Peoples Profile (~19MB)
• General Community Profile (~512MB)
• Place of Enumeration Profile (~357MB)
• Time Series Profile (~62MB)
• Working Population Profile (~35MB)
• ASGS Geometry (~1.6GB)

2011 Census

• Basic Community Profile (~335MB)
• Indigenous Profile (~23MB)
• Place of Enumeration Profile (~334MB)
• Time Series Profile (~79MB)
• Working Population Profile (~32MB)
• Extended Community Profile (~59MB)
• ASGS Geometry (~2.7GB)

Australian Electorates

• Federal (~587MB)
• NSW (~30MB)
• NT (~1MB)
• QLD (~20MB)
• SA (~29MB)
• VIC (~64MB)
• WA (~73MB)

Australian Statistical Geography Standard

• ASGS Geometry 2011 (~1.3GB)
• ASGS Geometry 2012 (~248MB)
• ASGS Geometry 2013 (~364MB)
• ASGS Geometry 2014 (~251MB)
• ASGS Geometry 2015 (~251MB)
• ASGS Geometry 2016 (~1.4GB)
• ASGS Geometry 2017 (~403MB)
• ASGS Geometry 2018 (~402MB)
• ASGS Geometry 2019 (~153MB)

Process

1. Download one or more set of dumps
2. Run pg_restore for each dump e.g. pg_restore --host=localhost --username=postgres --dbname=your-database-name /path/to/your/folder/dumps/aus_census_2016_gcp.dump and enjoy!
3. Run VACUUM ANALYZE on each of the database schemas that were loaded (e.g. aus_census_2016_gcp, aus_census_2016_pep)

Data Licenses

Incorporates or developed using Census data from the Australian Bureau of Statistics under Creative Commons Attribution 4.0 International licence (CC BY 4.0).

Incorporates or developed using Australian Statistical Geography Standard data from the Australian Bureau of Statistics under Creative Commons Attribution 4.0 International licence (CC BY 4.0).

Incorporates data from Australian federal and state electoral commissions. Refer to Australian Electorates.

Data Customisation

Census metadata files have been customised to fix some of their known minor limitations. The most notable are:

• ABS metadata statements have been parsed through our data loaders to turn the provided XLS files into a queryable JSON structure. As always, please refer back to the source metadata.