Page History

...

"State"
"State Name", "State Code"
"New South Wales", "NSW", "<WKT Point>", "<WKT Polygon>"
"Victoria", "VIC", "<WKT Point>", "<WKT Polygon>"
...
etc ...

...

"Postcode"
"Postcode"
"2000", "NSW", "<WKT Point>", "<WKT Polygon>"
"2009", "NSW", "<WKT Point>", "<WKT Polygon>"
...
"3000", "VIC", "<WKT Point>", "<WKT Polygon>"
"3008", "VIC", "<WKT Point>", "<WKT Polygon>"
...
etc ...

...

"Suburb"
"Suburb Name"
"Sydney CBD", "2000", "<WKT Point>", "<WKT Polygon>"
"Darling Harbour", "2000", "<WKT Point>", "<WKT Polygon>"
"Haymarket", "2000", "<WKT Point>", "<WKT Polygon>"
"Darling Island", "2009", "<WKT Point>", "<WKT Polygon>"
...
"Melbourne CBD", "3000", "<WKT Point>", "<WKT Polygon>"
"Docklands", "3008", "<WKT Point>", "<WKT Polygon>"
...
etc ...

...

In this example, we will need to link our demographic information to the bottom of our hierarchy, the Suburb level. As our bottom level only has one alias, we'll use that to identify each row, if there were multiple available we would have to select one to use throughout. Either way we will need to specify this link in the metadata file, described later.

"Population", "Median Income"
14308, 75000, "Sydney CBD"
28371, 60000, "Melbourne CBD"
...
etc ...

...

1. The first row will need to pair the State and Postcode levels.
   The Postcode file uses the State Code field as the pairing field. The State Code is the 2nd column in the State file and the linking field is the 2nd column of the Postcode file. So the row will be 2,2.
2. The second row will need to pair the Postcode and Suburb levels.
   The Suburb file uses the Postcode field as the pairing field. The Postcode is the 1st column in the Postcode file and the linking field is the 2nd column of the Suburb file. So the row will be 1,2.
3. The third row will need to pair the Suburb level with the Demographic data.
   The Demographic file uses the Suburb Name field as the pairing field. The Suburb Name is in the 1st column in the Suburb file and the linking field is in the 3rd column of the Demographic file. So the row will be 1,3.
4. The fourth row will need to nominate how each metric in the Demographic file should be aggregated.
   The Population value should be summed up, and the Median Income should be averaged, so the row will be SUM,AVG.

2, 2
1, 2
1, 3
SUM, AVG