NW Startups Geospatial Database API: Geographic Table Schemas

NW Startups Geospatial Database API Service

(GA) Version 2.01
May 16, 2012

<< Intro REST Calls
Get
Find
Add
Update
 Implementation
REST Layer
Middleware
 Table Schemas
Overview
Store Locator
Geographic
 Form Entry
Overview
Store Locator
Geographic
 

Table Schemas: Geographic Locating

Tables for the geographic locating service support:

  • Country (World)
  • State (World) - 1st Level Adminstative Boundaries
  • County (US/Canada/Mexico) - 2nd Level Administrative or Census Division Boundaries
  • City (Americas, partial Europe)
  • Postal (US, partial Canada)
  • Schools (US, partial Canada)
  • Airport (US/Canada/Mexico)

Country (Toplevel Administrative Division)

This table is for all data related to a country (top level administrative boundary). The following columns are entered and updated by users.

  • ISOen_name - The ISO 3166-1 official English short name of the country (Gazetteer order). [Unique]
    • Country names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to Gazetteer order.
    Ex. Bolivia, Plurinational State of
  • ISOen_proper - The ISO 3166-1 official English short name of the country (proper reading order). [Indexed]
    • Country names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to the proper reading order.
    Ex. Plurinational State of Bolivia
  • ISOen_ro_name - The ISO 3166-1 official English romanized short name of the country (Gazetteer order). [Indexed]
    • Country names are spelled in romanized format (UTF-8 w/diacritics), spelled according to Gazetteer order.
    Ex. Åland Islands
  • ISOen_ro_proper - The ISO 3166-1 official English romanized short name of the country (proper reading order).
    • Country names are spelled in romanized format (UTF-8 w/diacritics), spelled according to the proper reading order.
    Ex. Åland Islands
  • ISOfr_name - The ISO 3166-1 official French short name of the country (Gazetteer order).
    • Country names are spelled in French only character set (UTF-8) and grammatical form, spelled according to Gazetteer order. By French grammatical convention, adjectives are lowercased.
    Ex. Syrienne, République arabe
  • ISOfr_proper - The ISO 3166-1 official French short name of the country (proper reading order).
    • Country names are spelled in French only character set (UTF-8) and grammatical form, spelled according to the proper reading order. By French grammatical convention, adjectives are lowercased.
    Ex. République arabe syrienne,
  • ISOes_name - The ISO 3166-1 official Spanish short name of the country (Gazetteer reading order).
    • Country names are spelled in Spanish only character set (UTF-8 w/diacritics) and grammatical form, spelled according to Gazetteer order.
    Ex. República Checa
  • BGN_name - US Board on Geographic Names (BGN) approved English short name of the country (Gazetteer order).
    • Country names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to Gazetteer order.
    Ex. Syria
  • BGN_proper - US Board on Geographic Names (BGN) approved English short name of the country (proper reading order).
    • Country names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to the proper reading order.
    Ex. The Bahamas
  • BGN_longname - US Board on Geographic Names (BGN) approved English long name of the country (proper reading order).
    • Country names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to the proper reading order.
    Ex. Syrian Arab Republic
  • BGNlc_name - US Board on Geographic Names (BGN) local short name of the country (proper reading order).
    • Country names are spelled are spelled in English only character set (UTF-7 w/o diacritics), spelled according to the proper reading order. The convention of lowercasing adjectives for the French language is not followed.
    Ex. Oesterreich(at)
  • BGNlc_longname - US Board on Geographic Names (BGN) local long name of the country (proper reading order).
    • Country names are spelled are spelled in English only character set (UTF-7 w/o diacritics), spelled according to the proper reading order. The convention of lowercasing adjectives for the French language is not followed.
    Ex. Jamhuri ya Muungano wa Republique Centrafricaine(fr).
  • UNGEGNlc_ro_name - United Nations Group of Experts on Geographic Names (UNGEGN) local romanized short name of the country (proper reading order).
    • Country names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language, spelled according to the proper reading order. By French grammatical convention, adjectives are lowercased.
    Ex. Österreich
  • UNGEGNlc_ro_longname - United Nations Group of Experts on Geographic Names (UNGEGN) local romanized formal (long) name of the country (proper reading order).
    • Country names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language, spelled according to the proper reading order. By French grammatical convention, adjectives are lowercased.
    Ex. la République centrafricaine(fr)
  • UNGEGNen_name - United Nations Group of Experts on Geographic Names (UNGEGN) English short name of the country (Gazetteer reading order).
    • Country names are spelled in English only character set (UTF-7 w/o diacritics) and grammatical form, spelled according to the gazetteer reading order.
    Ex. Czech Republic (the)
  • UNGEGNen_longname - United Nations Group of Experts on Geographic Names (UNGEGN) English formal (long) name of the country (proper reading order).
    • Country names are spelled in English only character set (UTF-7 w/o diacritics) and grammatical form, spelled according to the proper reading order.
    Ex. the Czech Republic
  • UNGEGNfr_name - United Nations Group of Experts on Geographic Names (UNGEGN) French short name of the country (Gazetteer reading order).
    • Country names are spelled in French only character set (UTF-8 w/diacritics) and grammatical form, spelled according to the gazetteer reading order. By French grammatical convention, adjectives are lowercased.
    Ex. République tchéque (la)
  • UNGEGNfr_longname - United Nations Group of Experts on Geographic Names (UNGEGN) French formal (long) name of the country (proper reading order).
    • Country names are spelled in French only character set (UTF-8 w/diacritics) and grammatical form, spelled according to the proper reading order. By French grammatical convention, adjectives are lowercased.
    Ex. la République tchéque
  • UNGEGNes_name - United Nations Group of Experts on Geographic Names (UNGEGN) Spanish short name of the country (Gazetteer reading order).
    • Country names are spelled in Spanish only character set (UTF-8 w/diacritics) and grammatical form, spelled according to the gazetteer reading order.
    Ex. República Checa (la)
  • UNGEGNes_longname - United Nations Group of Experts on Geographic Names (UNGEGN) Spanish formal (long) name of the country (proper reading order).
    • Country names are spelled in Spanish only character set (UTF-8 w/diacritics) and grammatical form, spelled according to the proper reading order.
    Ex. la República Checa
  • UNGEGNru_name - United Nations Group of Experts on Geographic Names (UNGEGN) Russian short name of the country (Gazetter order).
    • Country names are spelled in Russian only character set (UTF-8 cyrillic) and grammatical form, spelled according to the gazetteer order.
    Ex. Австрия
  • UNGEGNru_longname - United Nations Group of Experts on Geographic Names (UNGEGN) Russian formal (long) name of the country (proper reading order).
    • Country names are spelled in Russian only character set (UTF-8 cyrillic) and grammatical form, spelled according to the proper reading order.
    Ex. Австрийская Республика
  • UNGEGNar_name - United Nations Group of Experts on Geographic Names (UNGEGN) Arabic short name of the country (Gazetter order).
    • Country names are spelled in Arabic script only character set (UTF-8 arabic) and grammatical form, spelled according to the gazetteer order.
  • UNGEGNar_longname - United Nations Group of Experts on Geographic Names (UNGEGN) Arabic formal (long) name of the country (proper reading order).
    • Country names are spelled in Arabic script only character set (UTF-8 arabic) and grammatical form, spelled according to the proper reading order.
  • UNGEGNzh_name - United Nations Group of Experts on Geographic Names (UNGEGN) Chinese short name of the country (Gazetter order).
    • Country names are spelled in Chinese script only character set (UTF-8 hanzi) and grammatical form, spelled according to the gazetteer order.
  • UNGEGNzh_longname - United Nations Group of Experts on Geographic Names (UNGEGN) Chinese formal (long) name of the country (proper reading order).
    • Country names are spelled in Chinese script only character set (UTF-8 hanzi) and grammatical form, spelled according to the proper reading order.
  • PCGN_name - UK Permanent Committee on Geographic Names (PCGN) approved English short name of the country (Gazetteer order).
    • Country names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to Gazetteer order.
    Ex. Korea, North
  • PCGN_proper - UK Permanent Committee on Geographic Names (PCGN) pproved English short name of the country (proper reading order).
    • Country names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to the proper reading order.
    Ex. North Korea
  • PCGN_longname - UK Permanent Committee on Geographic Names (PCGN) approved English long name of the country (proper reading order).
    • Country names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to the proper reading order.
    Ex. Democratic People's Republic of Korea
  • FAOit_name - Food and Agriculture Organization of the United Nations (FAO) Italian short name of the country (Gazetteer order).
    • Country names are spelled in Italian only character set (UTF-8 w/diacritics), spelled according to Gazetteer order.
    Ex. Perù
  • FAOit_proper - Food and Agriculture Organization of the United Nations (FAO) Italian short name of the country (proper reading order).
    • Country names are spelled in Italian only character set (UTF-8 w/diacritics), spelled according to the proper reading order.
    Ex. Perù
  • FAOit_longname - Food and Agriculture Organization of the United Nations (FAO) Italian offical (long) name of the country (proper reading order).
    • Country names are spelled in Italian only character set (UTF-8 w/diacritics) and grammatical form, spelled according to the gazetteer reading order. By Italian grammatical convention, adjectives are lowercased.
    Ex. Repubblica del Perù
  • EKI_name - Institute of Estonian Language (EKI) Estonian short name of the country (Gazetteer order).
    • Country names are spelled in Estonian only character set (UTF-8 w/diacritics), spelled according to Gazetteer order.
    Ex. Peruu
  • EKI_longname - Institute of Estonian Language (EKI) Estonian offical (long) name of the country (proper reading order).
    • Country names are spelled in Estonian only character set (UTF-8 w/diacritics) and grammatical form, spelled according to the gazetteer reading order. Ex. Peruu Vabariik
  • con_abbr - Conventional abbreviation for the country name.
    • Ex. BIOT for British Indian Ocean Territory
  • ISO3166A2 - The ISO 3166-1 alpha-2 country code for the country. [Unique]
  • ISO3166A3 - The 3166-1 alpha-3 country code for the country.
  • ISO3166N3 - The ISO 3166-1 numeric-3 country code for the country.
  • FIPS104 - The 2 letter FIPS 10-4 country code for the country.


  • BGN_capital - US Board on Geographic Names (BGN) English name of the country's capital city.
    • Capital city names are spelled in English only character set (UTF-7 w/o diacritics).
    Ex. Mexico City
  • UNGEGNlc_capital - United Nations Group of Experts on Geographic Names (UNGEGN) local name of the country's capital city.
    • Capital city names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language.
    Ex. Ciudad de. México
  • UNen_capital - United Nations terms English name of the country's capital city.
    • Capital city names are spelled in English only character set (UTF-7 w/o diacritics).
    Ex. Mexico City
  • UNfr_capital - United Nations terms French name of the country's capital city.
    • Capital city names are spelled in French only character set (UTF-8 w/diacritics) and grammatical form, spelled according to the proper reading order. By French grammatical convention, adjectives are lowercased.
    Ex. Mexico
  • UNes_capital - United Nations terms Spanish name of the country's capital city.
    • Capital city names are spelled in Spanish only character set (UTF-8 w/diacritics) and grammatical form, spelled according to the proper reading order.
    Ex. Ciudad de. México
  • UNru_capital - United Nations terms Russian name of the country's capital city.
    • Capital city names are spelled in Russian only character set (UTF-8 cyrillic) and grammatical form, spelled according to the gazetteer order.
    Ex. Mexикo
  • UNar_capital - United Nations terms Arabic name of the country's capital city.
    • Capital city names are spelled in Arabic script only character set (UTF-8 arabic) and grammatical form, spelled according to the gazetteer order.
  • UNzh_capital - United Nations terms Chinese name of the country's capital city.
    • Capital city names are spelled in Chinese script only character set (UTF-8 hanji) and grammatical form, spelled according to the gazetteer order.
  • EKI_capital - Institute of Estonian Language (EKI) Estonian name of the country's capital city.
    • Capital city names are spelled in Estonian only character set (UTF-8) and grammatical form, spelled according to the gazetteer order.
    Ex. México
  • Continent - 2 letter code of the continent the country resides in.
  • Sub-continent - 2 letter code of the sub-continent the country resides in.
  • ISOregion - ISO 3166-1 3 digit numeric code of the geographic region (continental) the country resides in.
  • ISOsubregion - ISO 3166-1 3 digit numeric code of the geographic subregion (sub-continental) the country resides in.


  • Population/Year - The estimated population and year.
  • Land Area - Land area ( excluding water) in square kilometers of the country.
  • Water Area - Water area in square kilometers of the country.
  • Land Mass - Total land mass (land and water) in square kilometers of the country.
  • Lang - The ISO 639-1 alpha-2, ISO 639-2 alpha-3, or ISO 639-3 alpha-3 language codes of the official languages of the country (comma separated list).
  • BGN_denonym - US Board on Geographic Names (BGN) English noun and adjective form for nationality (denonym).
  • Ethnic - Ethnic races and percentages of country's population.


  • Primary Postal - The length and format of the primary postal code of the country's postal system.
  • Secondary Postal - The length and format of the secondary postal code of the country's postal system.


  • ITU - The International Teleccmmunication Union (ITU) E.164 International Dialing Code.
  • ICV - United Nations Economic Commission for Europe Transport Division for International Vehicle Codes.


  • Coord - The geographic Latitude/Longitude centroid of the country.
  • BGNc_coord - US Board on Geographic Names (BGN) latitude/longitude geographic centroid of the capital city.
  • UNc_coord - United Nations Group of Experts on Geographic Names (UNGEGN) latitude/longitude geographic centroid of the capital city.
  • Max_Latitude - The maximum latitude coordinate of the country's territory.
  • Min_Latitude - The minimum latitude coordinate of the country's territory.
  • Max_Longitude - The maximum longitude coordinate of the country's territory.
  • Min_Longitude - The minimum latitude coordinate of the country's territory.


  • URL_gov - Web Site for the country's government portal.
  • URL_stats - Web Site for the country's national statistics (census).
  • URL_gis - Web Site for the country's geographic information system.
  • URL_postal - Web Site for the country's postal service.
  • flag - URL link to image of country's flag.
  • Notes - Entry citations.

For UNGEGN and BGN local names, when there is more than one language local name, each local name is followed by the ISO 639-1 alpha-2 or ISO 639-2 alpha-3 language code within square brackets [xx] and separated by a slash (/). Ex. Canada[xx]/le Canada[fr]

For BGN English noun forms of denonyms (nationality), plural is specified either by an ending (s), or a separate entry separated from the singular form by a slash (/) and each denoted by an ending (singular) and (plural). If the singular and plural forms are the same, no notation is specified. Gender forms are designated by an ending (men) an (women). Ex. Croat(s)/Croatian(s)

The following columns are automatically updated when an entry is created or modified.

Coverage

The table covers the United Nations recognized 249 countries and territories of the world.

References

The following references and sources were used to populate the table.

State (1st Level Administrative Division)

This table is for all data related to a first level administrative division (e.g., state, province, district, territory, etc) for countries in the Americas, Europe and Australia. The following columns are entered and updated by users.

  • BGNlc_name - US Board on Geographic Names (BGN) local short name of the 1st level administrative division.[Indexed]
    • First level administrative division names are spelled are spelled in English only character set (UTF-7 w/o diacritics) of the local language (gazetteer order).
    Ex. Michoacan de Ocampo
  • BGNlc_ro_name - US Board on Geographic Names (BGN) local romanized short name of the 1st level administrative division. [Indexed]
    • First level administrative division names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language (gazetteer order).
    Ex. Michoacán de Ocampo
  • BGNlc_variant - US Board on Geographic Names (BGN) local romanized variant name of the 1st level administrative division.
    • First level administrative division names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language.
    Ex. Michoacán
  • BGNlc_formalname - US Board on Geographic Names (BGN) approved local romanized formal name of the 1st level administrative division.
    • First level administrative division names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language (gazetteer order).
    Ex. Estado de Michoacán de Ocampo
  • BGNlc_formalproper - US Board on Geographic Names (BGN) approved local romanized formal name of the 1st level administrative division.
    • First level administrative division names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language (proper reading order).
    Ex. Michoacán de Ocampo, Estado de
  • Lang - The ISO 639-1 alpha-2, ISO 639-2 alpha-3, or ISO 639-3 alpha-3 official local language for the local names of the first level administrative division.


  • BGNlc_oth_name - US Board on Geographic Names (BGN) local short name, in other official languages, of the 1st level administrative division.
    • First level administrative division names are spelled are spelled in English only character set (UTF-7 w/o diacritics) of the local language (gazetteer order).
    Ex. Colombie-Britannique[fr]
  • BGNlc_oth_ro_name - US Board on Geographic Names (BGN) local romanized short name, in other official languages, of the 1st level administrative division.
    • First level administrative division names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language (gazetteer order).
    Ex. Colombie-Britannique[fr]
  • BGNlc_oth_variant - US Board on Geographic Names (BGN) local romanized variant name, in other official languages, of the 1st level administrative division.
    • First level administrative division names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language.
    Ex.
  • BGNlc_oth_formalname - US Board on Geographic Names (BGN) approved local romanized formal name, in other official languages, of the 1st level administrative division.
    • First level administrative division names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language (gazetteer order).
    Ex. Colombie-Britannique, Province de[fr]
  • BGNlc_oth_formalproper - US Board on Geographic Names (BGN) approved local romanized formal name, in other official languages, of the 1st level administrative division.
    • First level administrative division names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language (proper reading order).
    Ex. Province de Colombie-Britannique[fr]
  • Admin1Type - The type of administrative division (e.g., state, territory, province, district, department, etc).
  • Country - The ISO 3166-1 official English short name of the country the 1st level administrative division resides in.
  • ISO3166A2 - The ISO 3166-1 alpha-2 country code of the country the 1st level administrative division resides in. [Indexed]
  • ISO31662A2 - The ISO 3166-2 alpha-2 subdivision code for the first level administrative division. [Indexed]
  • FIPS52 - The NIST (US National Institute of Standards and Technology) 2-digit FIPS (Federal Information Processing Standards) 5-2 code for the 1st level administrative division. [Indexed]
  • GNS - The 8 digit NGA (National Geospatial-Intelligence Agency) GEONet Name Server for non-US unique feature identifier (UFI).
  • CSGI - Country specific geographic identifier.
    • GNIS - The USGS Geographic Name Information System (GNIS) feature identifier.
    • SGC - The 2 digit Statistics Canada (Canadian Census) SGC (Standard Geographic Code) identifier for provinces/territories.
    • Region - The Columbia numeric code for regions.
    • Department - The Guyana numeric code for departments.
  • lc_capital - The local name of the capital of the 1st level administrative division.
    • Capital names of first level administrative divisions are spelled are spelled in English only character set (UTF-7 w/o diacritics) of the local language.
    Ex. Quebec City
  • lc_ro_capital - The local romanized name of the capital of the 1st level administrative division.
    • Capital names of 1st level administrative divisions are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language.
    Ex. Québec City
  • c_coord - The latitude/longitude geographic centroid of the capital of the 1st level administrative division.
  • Postal Prefix: Min/Max - the 1 or 2 alphanumeric prefix of the postal code range for the 1st level administrative division.
    • For US and Mexican states, the 2-digit prefix of the zipcode range for the state.
    For example, 98-99 would cover zipcodes from 098000 to 99999.

    The value of zero for Max will default to the Min value. For example, 97-0 would cover zipcodes from 97000 to 97999.

    For Canadian provinces and territories, the 1 character prefix of the postal code.
  • Population/Year - The estimated population and year.
  • Housing/Occupied Units - The estimated number of total and occupied housing units.
  • Land - Total land mass in square kilometers.
  • URL_gov - Web Site for the 1st administrative division's government portal.
  • Coord - The geographic latitude/longitude centroid of the 1st level administrative division.
  • Notes - Entry citations.

For BGN local names, when there is more than one language local name, each local name is followed by the ISO 639-1 alpha-2 or ISO 639-2 alpha-3 language code within square brackets [xx] and separated by a slash (/). Ex. British Columbia[en]/Colombie-Britannique[fr]

The following columns are automatically updated when an entry is created or modified.

Coverage

The table covers all:

    North America: Northen
  • United States: 50 states, District of Columbia, the 5 US territories, and 4 freely associated states.
  • Canada: 10 provinces and 3 territories.
  • Mexico: 3 states and the federal district.
  • Bermuda: 9 parishes and 2 municipalities.
  • Greenland: 4 municipalities and 2 unincorporated divisions.


    • North America: Central America
  • Belize: 6 districts
  • Honduras: 18 departments
  • Guatemala: 22 departments
  • El Salvador: 14 departments
  • Nicaragua: 16 epartments and 2 autonomous regions
  • Costa Rica: 7 provinces
  • Panama: 9 provices and 3 autonomous regions


    • North America: Caribbean
  • Antigua and Barbuda: 6 parishes and 2 dependencies.
  • Bahamas: 31 districts.
  • Barbados: 11 parishes and 1 municipalities.
  • Cayman Islands: 8 districts
  • Cuba: 15 provinces and 1 municipality
  • Dominica: 10 parishes.
  • Dominican Republic: 31 provinces and 1 district.
  • Grenada: 6 parishes and 1 dependency.
  • Haiti: 10 departments.
  • Jamaica: 14 parishes.
  • Montserrat: 3 parishes.
  • Saint Kitts and Nevis: 14 parishes.
  • Saint Lucia: 11 quarters.
  • Saint Vincent and The Grenadines: 6 parishes.
  • Trinidad and Tobago: 9 regions, 3 boroughs and 2 municipalities.


    • South America
  • Argentina: 23 provinces and 1 municipality.
  • Bolivia: 9 departments.
  • Brazil: 26 states and 1 federal district.
  • Chile: 15 regions.
  • Columbia: 32 departments and 1 federal district.
  • Ecuador: 24 provinces.
  • Guyana: 10 regions
  • Paraguay: 17 departments and 1 municipality.
  • Peru: 25 departments.
  • Suriname: 10 districts.
  • Uruguay: 19 departments.
  • Venezuela: 23 states, 1 federal district and 1 dependency.


    • Europe
  • Albania: 12 counties.
  • Andorra: 7 parishes.
  • Austria: 8 states.
  • Belarus: 6 provinces, and 1 municipality.
  • Belgium: 3 regions.
  • Bosnia and Herzegovina: 2 divisions and 1 internationally supervised district.
  • Bulgaria: 28 provinces.
  • Crotia: 20 counties and 1 municipality.
  • Czech Republic: 13 regions, 1 district.
  • Denmark: 5 regions.
  • Estonia: 15 counties and 1 federal district.
  • Finland: 19 regions.
  • France: 22 regions.
  • Germany: 16 states.
  • Greece: 13 regions and 1 autonomous state.
  • Hungary: 19 counties, 23 urban counties, and 1 federal district.
  • Iceland: 9 regions.
  • Ireland: 29 counties and 5 municipalities.
  • Italy: 15 regions and 5 autonompus regions.
  • Latvia: 118 municipalities.
  • Liechtenstein: 11 communes.
  • Lithuania: 10 counties.
  • Luxembourg: 3 districts.
  • Macedonia: 84 municipalities.
  • Moldova: 32 districts, 3 municipalities, 1 autonomous region and 1 territory.
  • Montenegro: 21 municipalities.
  • Netherlands: 12 provinces.
  • Norway: 19 counties.
  • Poland: 19 provinces.
  • Portugal: 16 districts and 2 autonomous regions.
  • Romania: 41 counties and 1 municipality.
  • Russia: 46 provinces, 21 republics, 4 districts, 8 territories and 2 municipilities.
  • San Marina: 9 municipalities.
  • Serbia: TODO
  • Slovakia: 8 regions.
  • Slovenia: 200 municipalities and 11 urban municipalities.
  • Spain: 17 autonomous regions - TODO
    • .
  • Sweden: 21 counties.
  • Switzerland: 6 cantons.
  • Ukraine: 24 provinces, 1 autonomous region and 2 municipalities.


    • World
  • Australia: 6 states and 2 territories.
  • United Kingdom: 233 administrative divisions

References

The following references and sources were used to populate the table.

County (2nd Level Administrative Division)

This table is for all data related to a US county or Canadian County, Muncipiality or Census Division (i.e., 2nd level administrative boundary). The following columns are entered and updated by users.

  • Name - The USGS geographic short and formal name of the county.
  • FIPS - The NIST (US National Institute of Standards and Technology) 3-digit FIPS (Federal Information Processing Standards) code for the county. [Indexed]
  • S_FIPS - The 2 digit FIPS code for the state the county is in.
  • GNS - The 8 digit NGA GEONet Name Server for non-US unique identifier.
  • SGC - The 4 digit Statistics Canada (Canadian Census) SGC (Standard Geographic Code) identifier for 2nd level administrative regions and census divisions.
  • INCITS - The ANSI INCITS code for the subdivision.
  • Seat - The county seat.
  • Population - the county population.
  • Housing - the number of housing units in the county.
  • Land - The total area of the county in square kilometers.
  • Water - The total water area of the county in square kilomters.
  • URL_gov - Web Site for the 2nd administrative division's government portal.
  • Latitude/Longitude - Average latitude/longitude of 2nd level administrative division.

The following columns are automatically updated when an entry is created or modified.

Coverage

The table covers:

  • 3,306 US counties, boroughs and census designated areas for Alaska, parishes for Louisiana, municipios for Puerto Rico, islands for the Virgin Islands, Marshall Islands, U.S. Minor Outlying Islands, districts for American Samoa, and municipalities for Nothern Mariana Islands.
  • 384 Canadian counties, municipalities and census divisions.
References

The following references and sources were used to populate the table.

City

This table is for all data related to a cities in North and South America, and world capitals. The following columns are entered and updated by users.

  • BGNlc_formalproper - US Board on Geographic Names (BGN) approved local romanized formal name of the city (proper reading order).[Indexed]
    • City names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language, spelled according to the proper reading order.
    Ex. Ciudad de México
  • BGNlc_name - US Board on Geographic Names (BGN) approved local short name of the city (Gazetteer order).
    • City names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to Gazetteer order.
    Ex. Mexico
  • BGNlc_ro_name - US Board on Geographic Names (BGN) approved local romanized short name of the city (Gazetteer order).
    • City names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language, spelled according to Gazetteer order.
    Ex. México
  • BGNlc_formalname - US Board on Geographic Names (BGN) approved local romanized formal name of the city (Gazetteer order).
    • City names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language, spelled according to Gazetteer order.
    Ex. Ciudad de México
  • BGNen_name - US Board on Geographic Names (BGN) English conventional short name of the city (Gazetteer order).
    • City names are spelled in English only character set (UTF-7 w/o diacritics), spelled according to Gazetteer order.
    Ex. Mexico City
  • BGN_variant - US Board on Geographic Names (BGN) local variant name(s) of the city.
    • City names are spelled are spelled in romanized character set (UTF-8 w/diacritics) of the local language.
    Ex. México Distrito Federal
  • FIPS - The NIST (US National Institute of Standards and Technology) 5-digit FIPS (Federal Information Processing Standards) code for the city. [Indexed]
  • S_FIPS - The 2 digit FIPS code for the state the city is in.
  • C_FIPS - The 3 digit FIPS code for the county the city is in.
  • INCITS - The 10 digit BGN INCITS 446-2008 permanent feature identifier for the city (US cities only). [Indexed]
  • GNS/UFI - The 8 digit NGA GEONet Name Server for non-US unique identifier.
  • type - city classification type - city, town, village, borough, CDP (census designated place), AFB (airforce base), subdivision, housing (housing project), mobile park, condo (condominium), retirement (retirement home), resort.
  • Population / Population Urban / Year - the population for the city proper and city urban (metropolitan) and year.
  • Land / Land Urban - the land mass in kilometers squared for the city proper and city urban (metropolitan).
  • Water / Water Urban - the water area in kilometers squared for the city proper and city urban (metropolitan).
  • Housing - the number of housing units in the city.
  • Elevation - average elevation in meters.
  • IsCapital - Indicator if city is a capital of an administrative division
    • -1 : no
    • 0 : top-level (country)
    • 1 : 1st administrative division
    • 2 : 2nd administrative division
  • Coord - Geographic latitude/longitude centroid of the city.
  • URL_gov - Web Site for the local government portal.
  • Notes - Entry citations.

The following columns are automatically updated when an entry is created or modified.

Coverage

The table covers:

    North America: Northen
  • 176,000+ US cities, towns, villages, boroughs, census designated places, and other unincorporated areas in the US identified by the US Census Bureau 2000 TIGER data, and other unincorporated populated places identified in the USGS 2010 geographic names database.
  • 5,000+ Canada cities identified in the NGA Geonet Name Server (GNS) 2010 geographic name database.
  • 1,800+ Mexico cities identified in the NGA Geonet Name Server (GNS) 2010 geographic name database.
  • 20+ Bermuda cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 200+ Greenland cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.


    • North America: Central America & Caribbean
  • 36 Anguilla cities identified in the NGA Geonet Name Server (GNS) 2010 geographic name database.
  • 120 Antigua and Barbuda cities identified in the NGA Geonet Name Server (GNS) 2010 geographic name database.
  • 100+ Aruba cities identified in the NGA Geonet Name Server (GNS) 2010 geographic name database.
  • 65 Cayman Island cities identified in the NGA Geonet Name Server (GNS) 2010 geographic name database.
  • 2300+ Costa Rica cities identified in the NGA Geonet Name Server (GNS) 2010 geographic name database.
  • 8900+ Cuba cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 80+ Curacao cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 90 Dominican cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 7800+ Dominican Republic cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 3500+ El Salvador cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 270+ Grenada cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 6100+ Guatemala cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 10,700+ Haiti cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 11,900+ Honduras cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 2000+ Jamaica cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 500+ Martinique cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 70+ Montserrat cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 2700+ Nicaragua cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 6200+ Panamana cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 17 Saint Barthelemy cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 100+ Saint Kitts and Nevis cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 170+ Saint Lucia cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 50+ Saint Martin (French part) cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 3 Saint Pierre and Miquelon cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 60+ Saint Vincent and The Grenadines cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 50+ Sint Maarten (Dutch part) cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 400+ Trinidad and Tobago cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 14 Turks and Caicos Islands cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 22 Virgin Islands, British cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.


    • South America
  • 6800+ Argentina cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 13,800+ Bolivia cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 35,400+ Brazil cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 3,800+ Chile cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 29,000+ Columbia cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 6,800+ Ecuador cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 50+ Falkland Islands cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 600+ French Guiana cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 400+ Guyana cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 2,000+ Paraguay cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 37,000+ Peru cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 400+ Suriname cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 700+ Uruguay cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 24,000+ Venezuela cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.


    • Europe
  • 15 Åland Island cities obtained from Ålands statistik- och utredningsbyrå 2010.
  • 4,300+ Albania cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 50+ Andorra cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 5,000+ Austria cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 16,000+ Belarus cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 10,800+ Belgium cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 14,000+ Bosnia and Herzegovina cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.
  • 5,700+ Bulgaria cities identified in the NGA Geonet Name Server (GNS) 2011 geographic name database.


    • World
  • 9,600+ Australia cities identified in the NGA Geonet Name Server (GNS) 2010 geographic name database.
  • 300+ Major cities and country capitals of the world identified by the CIA World Factbook.

References

The following references and sources were used to populate the table.

Postal Codes

This table is for all data related to a US postal codes. The following columns are entered and updated by users.

  • Postal - The postal code in alphanumeric representation. [Index]
  • ISO3166A2 - The ISO 3166-1 alpha 2 country code for the corresponding country. [Primary]
  • ISO31662A2 - The ISO 3166-2 alpha 2 subdivision code for the corresponding administrative division (e.g., state, province).
  • City - The city for the postal code.
  • Land - The total area of the postal code in square kilometers.
  • Water - The total water area of the postal code in square kilomters.
  • Coord - The Geographic latitude/longitude centroid of the postal code.
  • Notes - Entry citations.

The following columns are automatically updated when an entry is created or modified.

  • CID - A unique auto-incremented ID within the table. [Primary]
  • Created, Modified - Date timestamp of creation and last modified.
  • Submitter - ID of registered user who created or last modified the entry.
Coverage

The table covers:

  • US 5 digit zip codes
  • CA misc postal codes
References

The following references and sources were used to populate the table.

School

This table is for all data related to Elementary, Secondary and Post-Secondary education institutions in th United States. The following columns are entered and updated by users.

  • lc_formal - The local formal name of the institution. [Primary]
  • lc_name - The local short name of the institution.
  • lc_abbr - The local abbreviation of the institution.
  • en_name - The english name of the institition.
  • ISO3166A2 - The ISO 3166-1 alpha 2 country code for the corresponding country. [Index]
  • ISO31662A2 - The ISO 3166-2 alpha 2 subdivision code for the corresponding administrative division (e.g., state, province).
  • City - The local name of the city where the institution is located.
  • Street - The street address of the institution.
  • Postal - The postal code of the institution.
  • S_FIPS - The NIST (US National Institute of Standards and Technology) 2 digit FIPS code for the state the institution is in.
  • C_FIPS - The NIST (US National Institute of Standards and Technology) 3-digit FIPS (Federal Information Processing Standards) code for the county the institution is in.
  • Tele - The general (public) telephone number of the institution.
  • URL - Web Site for the institution.
  • URL_admin - Web Site for the institution's admission's office.
  • URL_FAID - Web Site for the institution's financial aid office.
  • URL_appl - Web Site for the institution's online application.
  • type - The type of insitution (e.g., college, university, trade school, school, school district, special education).
  • OPEID - US Department of Education Postsecondary Education ID for the institution. [Index]
  • IPEDS - US Department of Education Integrated Postsecondary Education Data System Survery ID (also UNITID).[Index]
  • EIN - Federal Taxpayer Employer Indentification Number.
  • DISTNO - US School District Number (local to state).
  • NCESID - US Department of Education NCES identifier.
  • Tribal - Flag indicating if a Native American tribal institution.
  • Private - Flag indicating if a private institution.
  • Landgrant - Flag indicating if a US land grant institution.
  • HBCU - Flag indicating if a historically black college or university.
  • Medical - Flag indicating if institution offers a medical degree.
  • Hospital - Flag indicating if institution has a hospital.
  • Level Min/Max - Minimum and maximum education levels (e.g., grade levels) offered by the institution, where 999 designates Ph.D and above.
  • Accredation/Status - The accredation and status of accredation for the institution.
  • Enrollment K-12/Undergraduate/Graduate - Enrollment of men, women and foreign in K-12, undergraduate, and graduate studies.
  • Tuition In-state/Out-of-State Undergraduate/Graduate - In-state and out-of-state annual tuition for undergraduate and graduate studies.
  • Fees In-state/Out-of-State Undergraduate/Graduate - In-state and out-of-state annual fees for undergraduate and graduate studies.
  • Charge per Credit Hour In-state/Out-of-State Undergraduate/Graduate - In-state and out-of-state charge per credit hour for part-time students in undergraduate and graduate studies.
  • Cost In-state/Out-of-State Undergraduate/Graduate - In-state and out-of-state total annual cost for undergraduate and graduate studies.
  • Books - Estimated annual cost of books
    • .
  • Room/Board, Other Expenses On/Off Campus - Average annual cost of room, board and other expenses for both on and off campus living.
  • Chief - The name of the chief administrator of the institution.
  • Chief Title - The title of the chief administrator of the institution.
  • Number of Schools - Total number of schools or campuses.
  • Number of Days - Total number of school days in a school year.
  • Number of Hours - Average number of hours in a school day.
  • Ratio - Pupil to Teacher ratio
  • FTE - Number of full-time teacher equivalents.
  • Religious - Religious orientation, if any.
  • Land - Total land area covered by institution in square kilometers.
  • Water - Total water area within area covered by institution in square kilometers.
  • Coord - The Geographic latitude/longitude centroid of the institution.
  • Notes - Entry citations.

The following columns are automatically updated when an entry is created or modified.

Coverage

The table covers:

  • 11,500+ US post-secondary education institutions.
  • 13,000+ US school districts.
  • 100,000+ US public schools.
  • 20,000+ US private schools.
  • 2,000+ British Columbia, CA public and private schools.
References

The following references and sources were used to populate the table.

Airport

This table is for all data related to North American airports. The following columns are entered and updated by users.

  • Name - The USGS geographic name of the airport. [Indexed]
  • City - The airport city location.
  • Postal - The airport postal code.
  • S_FIPS - The 2 digit FIPS code for the state the airport is in.
  • C_FIPS - The 3 digit FIPS code for the county the city is in.
  • INCITS - INCITS - The 10 digit INCITS 446-2008 permanent feature identifier for the airport. [Indexed]
  • IATA - 3 letter International Air Transport Association code or FAA code for the US. [Indexed]
  • ICAO - 4 letter International Civil Aviation Organization code. [Indexed]
  • Type - Airport type.
    • Airport
    • Heliport
    • Sailport
    • Seaplane
    • Ultralight
    • Balloonport
  • Scope - Airport access.
  • International
  • Regional
  • Municipal
  • Emergency - emergency landing
  • Military
  • Fire - fire station
  • Police
  • Private
  • Ranch
  • Corporate
  • School - flight training
  • Medical
  • Federal - federal agency
  • State - state agency
  • Utility
  • University
  • Elevation - average elevation in meters.
  • Latitude/Longitude - Average latitude/longitude value.
  • Timezone - Hours offset from UTC.
  • DST - Daylight savings zone.

The following columns are automatically updated when an entry is created or modified.

Coverage

The table covers 19,000+ airports in North America.

References

The following references and sources were used to populate the table.

  • INCITS codes, state and county FIPS, latitude/longitude and elevation obtained from the US Geological Survey Bureau - 2010 Geographic Domestic Names database.
  • IATA/ICAO codes, city, timezone and DST from the open source Openflights.Org public domain 2010 Airport Database.


<< Intro REST Calls
Get
Find
Add
Update
 Implementation
REST Layer
Middleware
 Table Schemas
Overview
Store Locator
Geographic
 Form Entry
Overview
Store Locator
Geographic