Table Columns

If the column has constrained values they are listed under values on the far right. Click on MORE to see full list and description of constrained values.
Back to table listings

  Sort columns ordinally
  Sort columns alphabetically

Columns in table "gnrs"




Column Data Type Null Description Values
country_iso text YES Standard country ISO code
county_parish_iso text YES Standard county ISO code
county_parish_verbatim_alt text YES Verbatim county/parish, minus class identifiers such as county, parish, 'municipio de', etc.
geonameid integer YES Identifier in geonames database
gid_0 text YES GADM identifier for admin level 0 (country) political unit (GNRS)
gid_1 text YES GADM identifier for admin level 1 (state) political unit (GNRS)
gid_2 text YES GADM identifier for admin level 2 (county) political unit GNRS)
state_province_iso text YES Sandard ISO code for state
state_province_verbatim_alt text YES Verbatim state/province name, minus any class identifiers ('state', 'province', 'Estado de', etc.)
id integer NO Integer primary key. Uniquely identifies each record in this table.
poldiv_full text YES [internal use]
country_verbatim text YES Verbatim country, as submitted
state_province_verbatim text YES Verbatim state/province, as submitted.
county_parish_verbatim text YES Verbatim county/parish, as submitted
country text YES Standard country name from geonames database (GNRS)
state_province text YES Standard state/province name from geonames database (GNRS)
county_parish text YES Standard county/parish name from geonames database (GNRS)
country_id integer YES FK to table country, integer identifier for standard country name
state_province_id integer YES Foreign key to record for this state in table state_province
county_parish_id integer YES FK to table county_parish, integer identifier for standard county name
match_method_country text YES Method of final successful match (exact, fuzzy, etc.) 'exact alternate name', 'exact ascii name', 'ex… MORE
match_method_state_province text YES Method of final successful match (exact, fuzzy, etc.) 'alternate code', 'exact alternate name', 'exac… MORE
match_method_county_parish text YES Method of final successful match (exact, fuzzy, etc.) 'exact alternate name', 'exact ascii name', 'ex… MORE
match_score_country numeric YES Match score if fuzzy matched
match_score_state_province numeric YES Match score if fuzzy matched
match_score_county_parish numeric YES Match score if fuzzy matched
poldiv_submitted text YES Lowest political division submitted
poldiv_matched text YES Lowest political division matched
match_status text YES Is match complete? Partial? Or no match? 'full match', 'no match', 'NULL', 'partial match' MORE