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