1270.0.55.003 - Australian Statistical Geography Standard (ASGS): Volume 3 - Non ABS Structures, July 2016  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 13/09/2016   
   Page tools: Print Print Page Print all pages in this productPrint All

METADATA FOR CORRESPONDENCE FILES

Correspondences allow users to reallocate data between areas by providing a population weighted proportionate distribution and a goodness of fit indicator. These correspondences may then be extended to develop a one to one concordance based on the most significant contributors.

This publication contains a suite of correspondences for the Australian Statistical Geography Standard (ASGS) Non ABS Structures between the 2011 and 2016 ASGS.

FILE FORMAT


There are a number of correspondences available within this product. The correspondences are supplied in Microsoft Excel format (.xls). Within each Microsoft Excel file there may be several Worksheets along with a Contents page and Explanatory Notes.

The Worksheets are as follows:

QI_MEASURE

This Worksheet contains the overall quality measure in textual description, This Worksheet will always be supplied with correspondences.

QI_INDICATOR

This Worksheet contains the individual quality indicator in textual descriptions for every TO region. This Worksheet will always be supplied with correspondences.

CORRESPONDENCE

This Worksheet contains the main correspondence and the majority of the records. This Worksheet will always be supplied with correspondences.

NULL_TO_OR_FROM_FIELD

This Worksheet contains records where a FROM region does not have a corresponding TO region, or vice versa. An example of when this may occur is when one geography dataset contain islands which are not included in the other dataset. This Worksheet will only be supplied if records fall in to this category.

BELOW_MINIMUM_OUTPUT_SIZE

This Worksheet contains records that have a statistical weight below a pre-set minimum (typically below 0.01). These are records where the proportion of the FROM region that is being donated is very small and is deemed as being statistically insignificant. This Worksheet will only be supplied if there are records that fall in to this category.

MISSING_TO_UNITS

Contains records where the TO unit is not represented elsewhere in the correspondence. This is due to the TO unit being very small relative to the FROM unit and, as a result, a grid point is not associated with the TO unit. In cases where this occurs, documentation will be included with the affected correspondence as well as a list of the TO units that are not represented in the other Worksheets.

FILE NAMING CONVENTION FOR GRID BASED CORRESPONDENCES

Correspondence File Name


Grid based correspondences supplied by the ABS have a standard naming convention applied. The examples below relates to a correspondence where 2011 Statistical Areas Level 2 (SA2) are being corresponded to 2016 SA2s.

File name:

Statistical Area Level 2 2011 TO Statistical Area Level 2 2016

and

CG_SA2_2011_SA2_2016.xls

Table 1: Character and meaning of the file name.


Character Meaning

CCorrespondence
GGrid based correspondence
SA2Represents the name of the FROM region, in this case Statistical Area Level 2
2011The year that this version of the FROM region was released
SA2Represents the name of the TO region, in this case Statistical Area Level 2
2016The year that this version of the TO region was released
.xlsThe format that the file is being supplied, Microsoft Excel format


CORRESPONDENCE WORKBOOK AND FIELD DEFINITIONS

Below is an example of the content for each of the Worksheets in the correspondence Microsoft Excel Workbook files provided in this publication. Definition of the fields in the Worksheets is also provided with the examples.


The QI_MEASURE Worksheet


Table 2: An example of the overall quality indicator of a grid based correspondence file.

QI_MEASURE

Good


In the above example the field name and descriptions are:

QI_MEASURE

The overall quality indicator for the entire correspondence.

The same textual descriptions used for the overall quality measure are also applied to the individual quality indicators. The textual descriptions are Good, Acceptable and Poor.

The QI_INDICATOR Worksheet

Table 3: An example of the quality indicator of a grid based correspondence file for each TO region.

SA2_MAINCODE_2016SA2_NAME_2016QI_INDICATOR

801051123Black MountainPoor
801051126Parkes (ACT) - NorthPoor
801101137MolongloPoor
505031255Alkimos - EglintonPoor
801071132Tuggeranong - WestPoor
801101139WrightPoor
127011592Badgerys CreekPoor
209041437WollertPoor


In the above example the field names and descriptions are as follows:

SA2_CODE_2016

This is a unique code associated with each TO region, to which a textual description of quality is supplied. In this case it is the unique SA2 code.

SA2_NAME_2016

This is the name of the SA2 which in this example is the TO region to which a textual description of quality is supplied.

QI_INDICATOR

This is the textual description of quality that is supplied for each TO region of the correspondence.

The same textual descriptions used for the individual quality indicators are also applied to the overall quality measure. The textual descriptions are Good, Acceptable and Poor.
The CORRESPONDENCE Worksheet

Table 4: An example of a grid based correspondence file.

SA2_MAINCODE_2011SA2_NAME_2011SA2_MAINCODE_2016SA2_NAME_2016RATIO PERCENT

101011001Goulburn101051539Goulburn1.0100
101011002Goulburn Region101051540Goulburn Region1.0100
101011003Yass101061541Yass1.0100
101011004Yass Region101061542Yass Region1.0100
101011005Young101061543Young1.0100
101011006Young Region101061544Young Region1.0100
101021007Braidwood101021007Braidwood1.0100
101021008Karabar101021008Karabar1.0100


In the above example the field names and descriptions are as follows:

SA2_MAINCODE_2011

This is the unique numerical code representing the FROM region and in this case, the unique 2011 SA2 code.

SA2_NAME_2011

This is a textual label associated with the unique code of the FROM region, in this case it is the textual label for each 2011 SA2.

SA2_MAINCODE_2016

This is the unique numerical code representing the TO region, in this case it is the unique 2016 SA2 code.

SA2_NAME_2016

This is a textual label associated with the unique code of the TO region, in this case it is the textual label for each 2016 SA2.

RATIO

This field describes the Ratio of the FROM region that is being donated to the TO region. The Ratio is a figure between 0 and 1.

PERCENTAGE

This field describes the Percentage of the FROM region that is being donated to the TO region. The Percentage is the Ratio multiplied by 100.
The NULL_TO_OR_FROM_FIELD Worksheet

Table 5: An example of a table identifying NULL areas in either the TO or FROM region in a grid based correspondence.

SA2_MAINCODE_2011SA2_NAME_2011SA2_MAINCODE_2016SA2_NAME_2016RATIO PERCENT

102011030Calga - Kulnura1.0100


In the above example the field names and descriptions are as follows:

SA2_MAINCODE_2011

This is the unique numerical code representing the FROM region, in this case it is the unique 2011 SA2 code. In the example above there is no 2011 SA2 listed which indicates that the 2016 SA2 does not correspond with any 2011 SA2.

SA2_NAME_2011

This is a textual label associated with the unique code of the FROM region, in this case it is the textual label for each 2011 SA2.

SA2_MAINCODE_2016

This is the unique numerical code representing the TO region, in this case it is the unique 2016 SA2 code.

SA2_NAME_2016

This is a textual label associated with the unique code of the TO region, in this case it is the textual label for each 2016 SA2.

RATIO

This field describes the Ratio of the FROM region that is being donated to the TO region. The Ratio is a figure between 0 and 1.

PERCENTAGE

This field describes the Percentage of the FROM region that is being donated to the TO region. The Percentage is the Ratio multiplied by 100.

The BELOW_MINIMUM_OUTPUT_SIZE Worksheet

Table 6: An example of a table identifying ratios and percents of a TO region that is below minimum output size.

SA2_MAINCODE_2011SA2_NAME_2011SA2_MAINCODE_2016SA2_NAME_2016RATIO PERCENT

107041144Balgownie - Fairy Meadow107041145Corrimal - Tarrawanna - Bellambi6.36e-050.0063571
109011172Albury - East109011175Albury Region5.91e-050.0059077
111021219Toronto - Awaba111021220Wangi Wangi - Rathmines7.54e-050.0075379


In the above example the field names and descriptions are as follows:

SA2_MAINCODE_2011

This is the unique numerical code representing the FROM region, in this case it is the unique 2011 SA2 code.

SA2_NAME_2011

This is a textual label associated with the unique code of the FROM region, in this case it is the textual label for each 2011 SA2.

SA2_MAINCODE_2016

This is the unique numerical code representing the TO region, in this case it is the unique 2016 SA2 code.

SA2_NAME_2016

This is a textual label associated with the unique code of the TO region, in this case it is the textual label for each 2016 SA2.

RATIO

This field describes the Ratio of the FROM region that is being donated to the TO region. The Ratio is a figure between 0 and 1. In many cases, as can be seen in the example above, the amount that a FROM region is donating to a TO region is very small and is expressed as an exponential value.

PERCENTAGE

This field describes the Percentage of the FROM region that is being donated to the TO region. The Percentage is the Ratio multiplied by 100. In many cases, as can be seen in the example above, the amount that a FROM region is donating to a TO region is very small.

The MISSING_TO_UNITS Worksheet


There may be cases where a TO unit is not represented in a correspondence file. This is due to the TO unit being very small relative to the FROM unit, and as a result a grid point is not associated with the TO unit. In cases where this occurs, an additional worksheet will be included with the affected correspondence file. It will consist of a list of the TO units that are not represented in any of the other Worksheets listed above, and will be in a similar format.

FURTHER INFORMATION


More information on the ASGS and ABS Statistical Geography can be found by visiting the ABS website: https://www.abs.gov.au/geography

Any questions or comments can be emailed to <client.services@abs.gov.au> or contact the National Information and Referral Service (NIRS) on 1300 135 070.