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 "world_geom_gnrs"




Column Data Type Null Description Values
user_id text YES
state_province_verbatim text YES Verbatim state/province, as submitted.
state_province_id integer YES Foreign key to table state_province
state_province character varying YES Standard state/province name from geonames database (GNRS)
poldiv_submitted character varying YES Lowest political division submitted
poldiv_matched character varying YES Lowest political division matched
poldiv_full text YES [internal use]
match_status character varying YES Is match complete? Partial? Or no match?
match_score_state_province numeric YES Match score if fuzzy matched
match_score_county_parish numeric YES Match score if fuzzy matched
match_score_country numeric YES Match score if fuzzy matched
match_method_state_province character varying YES Method of final successful match (exact, fuzzy, etc.)
match_method_county_parish character varying YES Method of final successful match (exact, fuzzy, etc.)
match_method_country character varying YES Method of final successful match (exact, fuzzy, etc.)
id bigint NO
county_parish_verbatim text YES Verbatim county/parish, as submitted
county_parish_id integer YES FK to table county_parish, integer identifier for standard county name
county_parish character varying YES Standard county/parish name from geonames database (GNRS)
country_verbatim text YES Verbatim country, as submitted
country_id integer YES
country character varying YES Standard country name from geonames database (GNRS)