|
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 |
|
C | Correspondence |
G | Grid based correspondence |
SA2 | Represents the name of the FROM region, in this case Statistical Area Level 2 |
2011 | The year that this version of the FROM region was released |
SA2 | Represents the name of the TO region, in this case Statistical Area Level 2 |
2016 | The year that this version of the TO region was released |
.xls | The 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.
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_2016 | SA2_NAME_2016 | QI_INDICATOR |
|
801051123 | Black Mountain | Poor |
801051126 | Parkes (ACT) - North | Poor |
801101137 | Molonglo | Poor |
505031255 | Alkimos - Eglinton | Poor |
801071132 | Tuggeranong - West | Poor |
801101139 | Wright | Poor |
127011592 | Badgerys Creek | Poor |
209041437 | Wollert | Poor |
|
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_2011 | SA2_NAME_2011 | SA2_MAINCODE_2016 | SA2_NAME_2016 | RATIO | PERCENT |
|
101011001 | Goulburn | 101051539 | Goulburn | 1.0 | 100 |
101011002 | Goulburn Region | 101051540 | Goulburn Region | 1.0 | 100 |
101011003 | Yass | 101061541 | Yass | 1.0 | 100 |
101011004 | Yass Region | 101061542 | Yass Region | 1.0 | 100 |
101011005 | Young | 101061543 | Young | 1.0 | 100 |
101011006 | Young Region | 101061544 | Young Region | 1.0 | 100 |
101021007 | Braidwood | 101021007 | Braidwood | 1.0 | 100 |
101021008 | Karabar | 101021008 | Karabar | 1.0 | 100 |
|
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_2011 | SA2_NAME_2011 | SA2_MAINCODE_2016 | SA2_NAME_2016 | RATIO | PERCENT |
|
| | 102011030 | Calga - Kulnura | 1.0 | 100 |
|
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_2011 | SA2_NAME_2011 | SA2_MAINCODE_2016 | SA2_NAME_2016 | RATIO | PERCENT |
|
107041144 | Balgownie - Fairy Meadow | 107041145 | Corrimal - Tarrawanna - Bellambi | 6.36e-05 | 0.0063571 |
109011172 | Albury - East | 109011175 | Albury Region | 5.91e-05 | 0.0059077 |
111021219 | Toronto - Awaba | 111021220 | Wangi Wangi - Rathmines | 7.54e-05 | 0.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. |
|
|