Type GeographyTree
Type category Entity
Description GeographyTree provides the layers of geographies with parents. It is useful to get the details on the names/ISO codes of Countries, States, Sub-Divisions, Metropolitan Area for any specific KeyGeographyTree value in the table.
Fields
Name Type Filters Description
key id string(250)* = The id field uniquely identifies the entity record.
activeSnlCoverage boolean ActivesnlCoverage indicates that the value is actively maintained and that it should appear within the product suite.
link cityAsReported CityAsReported The City provides the name of the city.
country string(2) The Country fields represents the two-letter abbreviation for countries as defined by ISO-3166.
formOrder long The FormOrder represents the rows of output are to be displayed in ascending order by this value. This item should have no absolute value. It is used for relative ordering.
isDeleted boolean Indicates whether the row is (logically) deleted or not.
keyContinent long The specific key used in the table to represent the continents.
keyCountryDivision long The specific key used in the table to represent the Country Division.
keyDma long The specific key used in the table to represent the Designated Market Area.
keyGeographyTreeParent long The specific key used in the table to represent the Parent Geo Tree.
keyGlobalRegion long The specific key used in the table to represent the Global Region.
keyMetroPolitanArea long The specific key used in the table to represent the Metropolitan Area.
keyRegion string(2) The specific key used in the table to represent the identifier for regions within the U.S..
keySubscriptionGeography long The specific key used in the table to represent the default subscription geographic.
lastModifiedDateTime dateTime* Last modification date and time of a physical row in UTC timezone.
maskSearchType long Bitmask that indicates the search type(s) that are available for the tree. In lieu of a lookup use the following to resolve the mask: 0 = Classic Search; 1 = OmniSearch.
productCaption string(50) The specific key used in the table to represent the caption of an item to be used in products.
treeId long The specific key used in the table to represent a distinct tree within the set of all trees in a table.
treeValueLeft long The specific key used in the table to represent the leftmost or lowest value of the counter used to create a set-based tree for SQL.
treeValueRight long The specific key used in the table to represent the rightmost or highest value of the counter used to create a set-based tree for SQL.
20 rows of 20 total
API Open API Specification