10067 rows


Lookup table of GeoPoliticalUnits. Table is referenced by the SiteGeoPolitical table. These are countries and various subdivisions. Countries and subdivisions were acquired from the U.S. Central Intelligence Agency World Factbook8 and the ISO 3166-1 and ISO 3166-2 databases9.
Each GeoPolitical Unit has a rank. GeoPolitical Units with Rank 1 are generally countries. There are a few exceptions, including Antarctica and island territories, such as Greenland, which although a Danish territory, is geographically separate and distinct. Rank 2 units are generally secondary political divisions with various designations: e.g. states in the United States, provinces in Canada, and regions in France. For some countries, the secondary divisions are not political but rather distinct geographic entities, such as islands. The secondary divisions of some island nations include either groups of islands or sections of more highly populated islands; however, the actual island on which a site is located is more important information. Some countries also have Rank 3 units, e.g. counties in the United States and metropolitan departments in France. In addition to purely political units, various other administrative regions and geographic entities can be contained in this table. Examples of administrative regions are National Parks and Forests. It might be quite useful, for example, to have a record of all the sites in Yellowstone National Park. These additional units are Rank 4, and they can be added to the database as warranted.


Column Type Size Nulls Auto Default Children Parents Comments
geopoliticalid serial 10 nextval('ndb.seq_geopoliticalunits_geopoliticalid'::regclass)
geopaths.geoin geopaths_geoin_fkeyR
geopoldepth.geopoliticalid Implied ConstraintR
sitegeopolitical.geopoliticalid fk_sitegeopolitical_geopoliticalunitsR

An arbitrary GeoPolitical identification number.

geopoliticalname varchar 255 null

Name of the GeoPolitical Unit, e.g. Canada, Saskatchewan.

geopoliticalunit varchar 255 null

The name of the unit, e.g. country, state, county, island, governorate, oblast.

rank int4 10 null

The rank of the unit.

highergeopoliticalid int4 10 null

The GeoPoliticalUnit with higher rank, e.g. the country in which a state lies.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null


Constraint Name Type Sort Column(s)
geopoliticalunits_pkey Primary key Asc geopoliticalid
ix_geopoliticalname_geopoliticalunits Performance Asc geopoliticalname
ix_rank_geopoliticalunits Performance Asc rank