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"




Column Data Type Null Description Values
type_2 character varying YES
type_1 character varying YES
state_province_verbatim text YES Verbatim state/province, as submitted.
state_province text YES Standard state/province name from geonames database (GNRS)
county text YES Standard county/parish name from geonames database (GNRS)
country_verbatim text YES Verbatim country, as submitted
country text YES Standard country name from geonames database (GNRS)
ccn_5 numeric YES
ccn_4 numeric YES
ccn_3 numeric YES
ccn_2 numeric YES
ccn_1 numeric YES
cca_5 character varying YES
cca_4 character varying YES
cca_3 character varying YES
cca_2 character varying YES
cca_1 character varying YES
name_3 character varying YES
varregion character varying YES
varname_4 character varying YES
varname_3 character varying YES
varname_2 character varying YES
varname_1 character varying YES
validto_4 character varying YES
validto_3 character varying YES
validto_2 character varying YES
validto_1 character varying YES
validfr_4 character varying YES
validfr_3 character varying YES
validfr_2 character varying YES
validfr_1 character varying YES
uid numeric YES
type_5 character varying YES
type_4 character varying YES
type_3 character varying YES
remarks_1 character varying YES
region character varying YES Geographic region
poldiv_full text YES [internal use]
ogc_fid integer NO
objectid numeric YES
nl_name_3 character varying YES
nl_name_2 character varying YES
nl_name_1 character varying YES
name_5 character varying YES
name_4 character varying YES
name_1 character varying YES
name_0 character varying YES
match_status text YES Is match complete? Partial? Or no match?
iso character varying YES Standard 2-letter alphanumeric ISO country code
id_5 numeric YES
id_4 numeric YES
id_3 numeric YES
id_2 numeric YES
id_1 numeric YES
id_0 numeric YES
hasc_3 character varying YES Third level hasc code
hasc_2 character varying YES Second leve hasc code
hasc_1 character varying YES First level hasc code
geom USER-DEFINED YES Spatial object
engtype_5 character varying YES
engtype_4 character varying YES
engtype_3 character varying YES
engtype_2 character varying YES
engtype_1 character varying YES
county_verbatim text YES Verbatim county/parish, as submitted
shape_leng numeric YES
shape_area numeric YES
remarks_4 character varying YES
remarks_3 character varying YES
remarks_2 character varying YES
name_2 character varying YES