Geographic unit relationships provide a path for the system to follow when looking at data across different administrative versions, e.g., comparing ML_1983 to ML_2016.
Geographic unit relationships can be updated in two ways.
...
Preparing and Uploading Relationship Tables
...
Preparing tables
...
Preparing tables
To prepare a relationship table for upload, you will need to copy the relationship data from one tab to another in the relevant spreadsheet.
| Note |
|---|
The relationship table tab must be the first tab in the spreadsheet. Relationship tables should be completed before they are uploaded. |
To prepare a relationship table for upload:
Find the relevant relationship table spreadsheet.
Go to flow chart tab and copy paste the appropriate data set by set (FNID, Admin name, relationship type, etc) starting from left to right
...
Copy all the relationship for changes from 1993-1996 from top to bottom
Once you finish that, copy all the relationships for changes from 1996-1997, etc.
...
The relationship tab should be set up as follows:
from_name | from_fnid | relationship type | to_name | to_fnid |
|---|---|---|---|---|
This column should contain the old name of the geographic unit. | This column should contain the old FNID of the geographic unit. | This column should include the relationship between the old and new units. Use a type from the list at the beginning of this page. | This column should contain the new name of the geographic unit. | This column should contain the new FNID of the geographic unit. |
To copy the information:
You will need to copy the appropriate information from the FlowChart tab to the Relationship Table tab.
Copy information by dataset.
If there are multiple relationship sets, copy the data for the oldest start year first so they are at the top of the sheet. When all relationships for that year are done, begin again for the next set. This ensures the data are ordered chronologically.
For cases where there is only one start row that splits into multiple rows in the flow chart (Splits, redistributes, etc FlowChart tab (e.g., when a unit splits or redistributes), make sure you copy over the starting information for each individual split.
...
Copied information
...
Copy start information for second row
...
Upload Requirements
Relationship table sheet must be first in the workbook (farthest left)
Relationship table has to follow exact format below from_name, from_fnid,relationship type, to_name, to_fnid
Older FNID goes on the left hand side, newer FNID goes on the right
...
There must only five columns of information in the Relationship table tab.
If there are multiple relationship sets, the oldest start-years are listed first, and when all relationships for that year are done, begin again for the next set
...
Uploading Relationship Tables to FDW
...