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