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