Views

Geography

Administration

These views are used by the Scheduled Imports to generate useful derivations of the structured data such as maps (based on fields of type Location).

The general views are of the form:

MS.SOURCEKEY
Export Myself (Formula: MS.SOURCEKEY & Constant ("Blank") & Rename)
Export My Parent (Derived Field & Rename)
Export My Grandparent (Derived Field & Rename)
Export My Great Grandparent (Derived Field & Rename)
Export My Great Great Grandparent (Derived Field & Rename)

Pull Into Nation

This view pulls the Kingdom information from the parent into entries of Designation Nation.

Pull Into State or Province

This view pulls the Kingdom information from the grandparent, the nation information from the parent and the state or province information from itself into entries of Designation State or Province.

Pull Into City

This view pulls all 4 pieces of information (Kingdom, Nation, State or Province, County) from whatever node it is attached to through City Parent and County Parent.

This allows IDT to expose a simplified view of the demographic information to consumers while managing it internally as needed.

Set City Location

This view uses Formulas to concatenate the 4 pieces of information into a string suitable for a column of type Location.

Navigation

Browse Map

The map view is driven by the City Location field in the Geography category.

Browse Kingdoms (or Unions)

Browse Nations

Browse States (or Provinces)

Browse Counties

Browse Cities

Requests

Edit Container

Edit County

Edit City

Next Page