1270.0.55.006 - Australian Statistical Geography Standard (ASGS): Correspondences, July 2011  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 27/06/2012  First Issue
   Page tools: Print Print Page Print all pages in this productPrint All

METADATA FOR CORRESPONDENCE FILES

The Australian Bureau of Statistics (ABS) provides a set of correspondence files that enable users to convert data from one type of geographic area to another.



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 indicator 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 are below a pre-set minimum output size (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 2011 Local Government Areas (LGA).

File name:
Statistical Area Level 2 2011 TO Local Government Area 2011

and

CG_SA2_2011_LGA_2011.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
LGARepresents the name of the TO region, in this case Local Government Area
2011The 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 QI_INDICATOR Worksheet

Table 3: An example of the quality indicator of a grid based correspondence file for each TO region.
LGA_CODE_2011LGA_NAME_2011QI_INDICATOR
57630Sandstone (S)Poor
56160Murchison (S)Poor
34830Mapoon (S)Poor
37570Wujal Wujal (S)Poor
70540Belyuen (S)Poor
58470Upper Gascoyne (S)Poor
52380Cue (S)Poor
56860Nungarin (S)Poor
34570Lockhart River (S)Poor
55390Menzies (S)Poor

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

LGA_CODE_2011
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 Local Government Area code.

LGA_NAME_2011
This is the name of the Local Government Area 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 CORRESPONDENCE Worksheet

Table 4: An example of a grid based correspondence file.
SA2_MAINCODE_2011SA2_NAME_2011LGA_CODE_2011LGA_NAME_2011RATIO PERCENT
101011001Goulburn13310Goulburn Mulwaree (A)1100
101011002Goulburn Region13310Goulburn Mulwaree (A)0.469017246.9017245
101011002Goulburn Region16180Palerang (A)0.01136191.1361892
101011002Goulburn Region17640Upper Lachlan Shire (A)0.518071251.8071226
101011002Goulburn Region18350Wingecarribee (A)0.00034450.0344547
101011002Goulburn Region18710Yass Valley (A)0.00120510.120509
101011003Yass18710Yass Valley (A)1100
101011004Yass Region11050Boorowa (A)0.02290012.2900082
101011004Yass Region13700Harden (A)0.02909422.9094239
101011004Yass Region17640Upper Lachlan Shire (A)0.113154911.3154917
101011004Yass Region18710Yass Valley (A)0.834850783.4850664
101011005Young13700Harden (A)0.01080061.0800613
101011005Young18750Young (A)0.989199498.9199387
101011006Young Region11050Boorowa (A)0.292152729.2152719
101011006Young Region13700Harden (A)0.428319142.8319116
101011006Young Region18750Young (A)0.279528227.9528165

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 Statistical Area Level 2 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 Statistical Area Level 2.

LGA_CODE_2011
This is the unique numerical code representing the TO region, in this case it is the unique 2011 Local Government Area code.

LGA_NAME_2011
This is a textual label associated with the unique code of the TO region, in this case it is the textual label for each 2011 Local Government Area.

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_2011LGA_CODE_2011LGA_NAME_2011RATIO PERCENT
801061066Lake Burley Griffin1100

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 Statistical Area Level 2 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 Statistical Area Level 2.

LGA_CODE_2011
This is the unique numerical code representing the TO region, in this case it is the unique 2011 Local Government Area code. In the example above there is no LGA Code listed which indicates that the SA2 of Lake Burley Griffin does not correspond with any LGA.

LGA_NAME_2011
This is a textual label associated with the unique code of the TO region, in this case it is the textual label for each 2011 Local Government Area.

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_2011LGA_CODE_2011LGA_NAME_2011RATIO PERCENT
101011004Yass Region17500Tumut Shire (A)1.00E-079.80E-06
101031013Bombala10550Bega Valley (A)1.20E-060.0001241
101031015Cooma Region10550Bega Valley (A)2.20E-060.0002205
101041022Deua - Wadbilliga12050Cooma-Monaro (A)1.70E-050.0017011

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 Statistical Area Level 2 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 Statistical Area Level 2.

LGA_CODE_2011
This is the unique numerical code representing the TO region, in this case it is the unique 2011 Local Government Area code.

LGA_NAME_2011
This is a textual label associated with the unique code of the TO region, in this case it is the textual label for each 2011 Local Government Area.

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 and is expressed as an exponential value.


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.


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 geography@abs.gov.au