Page History

...

1. First rows contain links between the hierarchy CSVs. There will be one row for each child level. The way this is done is a pair of comma separated numbers:
   1. The first number tells you which column of the parent level file the linking field is.
   2. The second number tells you which column of the child level file the linking field is displayed in.
2. Second last row containing links between the bottom level of the hierarchy and the demographic CSV.
3. Last row containing how each of the demographic metrics should be aggregated. The values available are "AVG", "SUM", "MAX", and "MIN". These should be listed in the same order the fields are listed in the demographic CSV.

Note: if your file only contains one hierarchy level, or it doesn't contain demographic information, simply do not include metadata rows to link up this data.

Example

In this example, we have a three level hierarchy, as well as demographic information. This will mean that we need the following in the metadata file:

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

...