geopoliticalunits

10065 rows


Description

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.

Columns

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
geopoliticalname varchar 255 null
geopoliticalunit varchar 255 null
rank int4 10 null
highergeopoliticalid int4 10 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

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

Relationships