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