Geographic unit relationships can be updated in two ways.
If you need to update a few relationships, this can be done individually within the FDW.
If you need to update many relationships, this is best done by uploading a relationship table.
Relationship Types
Relationship tables work as Types must be one of the predefined options:
Successor: There was no change or barely any change in this administrative unit between geographic unit set versions.
Merge: Parts of, or the whole of, two or more administrative units were joined together to create a new administrative unit.
Split: An administrative unit was divided to form new administrative units.
Aggregate: An administrative unit becomes a higher-level administrative unit, e.g., Admin2 becomes Admin1.
Redistribute: Parts of an administrative unit were divided and redistributed to become part of new administrative units.
Demotion: An administrative unit becomes a lower-level administrative unit, e.g., Admin1 becomes Admin2.
Updating Geographic Unit Relationships in the FDW
To add individual unit relationships:
Go to Metadata Management > Spatial > Geographic Unit Relationships.
Click Add Geographic Unit Relationship.
Preparing and Uploading Relationship Tables
Relationship tables provide a path for the system to follow when looking at data across different administrative versions, e.g., comparing ML_1983 to ML_2016.
Preparing tables
Relationship tables should be completed before they are uploaded.
...
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
Relationship Types must be one of predefined options
...
Successor
This means that there was no change or barely any change in this administrative unit between geographic unit set versions
...
Aggregate
An administrative unit becomes a higher level administrative unit
Admin2 becomes Admin1
...
Redistribute
Parts of a administrative unit were divided to become a part of new administrative units
...
Demotion
An administrative unit becomes a lower level administrative unit
IE Admin1 become Admin2
...
Parts of, or the whole of two or more administrative units joined together to create a new administrative unit
Split
An administrative unit is divided in two (almost perfectly) to form new administrative units
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
There must only five rows columns of information in the Relationship table tab.
Uploading Relationship Tables to FDW
...
Go to
...
Metadata Management
...
> Spatial
...
> Geographic Unit Relationships.
Click Import Geographic Unit Relationships.
Click Choose
...
File.
Choose a format from the dropdown menu. This will likely be xls(x).
Click Submit.
Confirm
...
the import.