shp2pgsql.map

# This file defines how to load the ABS ASGS SHAPE files into our database
# (which has the schema defined in 03-create-asgs-schema.sql).
#
# Lines must be of the format:
# ABS_VOL_NUM SCHEMA SHAPE_FILE.SHAPE_FILE_ATTRIBUTE PSQL_TABLE.PSQL_ATTRIBUTE PSQL_ATTRIBUTE_DATATYPE
#
# The geometry from these shape files is join into the existing tables which
# have the CSV data already loaded in.

# To the extent possible under law, the person who associated CC0
# with this work has waived all copyright and related or neighboring
# rights to this work.
# http://creativecommons.org/publicdomain/zero/1.0/

# This schema is partly derived from the ASGS structure.
# http://www.abs.gov.au/websitedbs/D3310114.nsf/home/Australian+Statistical+Geography+Standard+%28ASGS%29

1 2011 GCCSA_2011_AUST.GCC_CODE11 gccsa.code
1 2011 MB_2011_*.MB_CODE11 mb.code
1 2011 SA1_2011_AUST.SA1_MAIN11 sa1.code
1 2011 SA2_2011_AUST.SA2_MAIN11 sa2.code
1 2011 SA3_2011_AUST.SA3_CODE11 sa3.code
1 2011 SA4_2011_AUST.SA4_CODE11 sa4.code
1 2011 STE_2011_AUST.STE_CODE11 ste.code

1 2016 GCCSA_2016_AUST.GCC_CODE16 gccsa.code
1 2016 MB_2016_*.MB_CODE16 mb.code
1 2016 SA1_2016_AUST.SA1_MAIN16 sa1.code
1 2016 SA2_2016_AUST.SA2_MAIN16 sa2.code
1 2016 SA3_2016_AUST.SA3_CODE16 sa3.code
1 2016 SA4_2016_AUST.SA4_CODE16 sa4.code
1 2016 STE_2016_AUST.STE_CODE16 ste.code

2 2011 IARE_2011_AUST.IA_CODE11 iare.code
2 2011 ILOC_2011_AUST.IL_CODE11 iloc.code
2 2011 IREG_2011_AUST.IR_CODE11 ireg.code

2 2016 IARE_2016_AUST.IAR_CODE16 iare.code
2 2016 ILOC_2016_AUST.ILO_CODE16 iloc.code
2 2016 IREG_2016_AUST.IRE_CODE16 ireg.code

3 2011 ADD_2011_AUST.ADD_CODE add.code
3 2011 CED_2011_AUST.CED_CODE ced.code
3 2011 LGA_2011_AUST.LGA_CODE11 lga.code
3 2011 NRMR_2011_AUST.NRMR_CODE nrmr.code
3 2011 POA_2011_AUST.POA_CODE poa.code
3 2011 SED_2011_AUST.SED_CODE sed.code
3 2011 SSC_2011_AUST.SSC_CODE ssc.code
3 2011 TR_2011_AUST.TR_CODE11 tr.code

3 2012 LGA_2012_AUST.LGA_CODE12 lga.code
3 2012 TR_2012_AUST.TR_CODE12 tr.code

3 2013 LGA_2013_AUST.LGA_CODE13 lga.code
3 2013 CED_2013_AUST.CED_CODE13 ced.code
3 2013 TR_2013_AUST.TR_CODE13 tr.code

3 2014 LGA_2014_AUST.LGA_CODE14 lga.code
3 2014 TR_2014_AUST.TR_CODE14 tr.code

3 2015 LGA_2015_AUST.LGA_CODE15 lga.code
3 2015 TR_2015_AUST.TR_CODE15 tr.code

3 2016 ADD_2016_AUST.ADD_CODE16 add.code
3 2016 CED_2016_AUST.CED_CODE16 ced.code
3 2016 LGA_2016_AUST.LGA_CODE16 lga.code
3 2016 NRMR_2016_AUST.NRM_CODE16 nrmr.code
3 2016 POA_2016_AUST.POA_CODE16 poa.code
3 2016 SED_2016_AUST.SED_CODE16 sed.code
3 2016 SSC_2016_AUST.SSC_CODE16 ssc.code
3 2016 TR_2016_AUST.TR_CODE16 tr.code

3 2017 CED_2017_AUST.CED_CODE17 ced.code
3 2017 LGA_2017_AUST.LGA_CODE17 lga.code
3 2017 SED_2017_AUST.SED_CODE17 sed.code

4 2011 SUA_2011_AUST.SUA_CODE11 sua.code
4 2011 UCL_2011_AUST.UCL_CODE11 ucl.code
4 2011 SOSR_2011_AUST.SSR_CODE11 sosr.code
4 2011 SOS_2011_AUST.SOS_CODE11 sos.code

4 2016 SUA_2016_AUST.SUA_CODE16 sua.code
4 2016 UCL_2016_AUST.UCL_CODE16 ucl.code
4 2016 SOSR_2016_AUST.SSR_CODE16 sosr.code
4 2016 SOS_2016_AUST.SOS_CODE16 sos.code

5 2011 RA_2011_AUST.RA_CODE11 ra.code

5 2016 RA_2016_AUST.RA_CODE16 ra.code