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 "cds" Column Data Type Null Description Values centroid_dist_km numeric YES Absolute distance in km from observation to known centroid centroid_dist_max_km numeric YES Maximum distance from centroid to be counted as centroid (cds parameter) centroid_dist_relative numeric YES Relative distance to centroid (Absolute distance divided by distance from centroid to farthest point on perimiter). centroid_poldiv text YES Political division of which point is most likely to be centroid centroid_type text YES Centroid of shape of this type coordinate_decimal_places integer YES Verbatim decimal places of coordinates (min of latitude & longitude) coordinate_inherent_uncertainty_m numeric YES Uncertainty in m due to number of decimal places country text YES Country in which point is located, as georeferenced by CDS country_cent_dist numeric YES Absolute distance in km from observation to country centroid country_cent_dist_max numeric YES Maximum distance from centroid to be counted as centroid country_cent_dist_relative numeric YES Relative distance to centroid (Absolute distance divided by distance from centroid to farthest point on perimiter). country_cent_type text YES Centroid of shape of this type county text YES County in which point is located, as georeferenced by CDS county_cent_dist numeric YES Absolute distance in km from observation to county centroid user_id text YES [internal use] county_cent_dist_max numeric YES Maximum distance from centroid to be counted as centroid county_cent_dist_relative numeric YES Relative distance to centroid (Absolute distance divided by distance from centroid to farthest point on perimiter). county_cent_type text YES Centroid of shape of this type gid_0 text YES GADM identifier for admin level 0 (country) political unit (GNRS) gid_1 text YES GADM identifier for admin level 1 (state) political unit (GNRS) gid_2 text YES GADM identifier for admin level 2 (county) political unit GNRS) id bigint NO Integer primary key. Uniquely identifies each record in this table. is_country_centroid smallint YES 1=point is a centroid; 0=point not a centroid is_county_centroid smallint YES 1=point is a centroid; 0=point not a centroid is_state_centroid smallint YES 1=point is a centroid; 0=point not a centroid is_subpoly_centroid smallint YES 1=point is a centroid of a subpolygon of main polygon; 0=point not a centroid latitude numeric YES Decimal latitude latitude_verbatim text YES Verbatim latitude latlong_err text YES Coordinates impossible (non-numeric, out of range or in water) latlong_verbatim text YES Verbatim latitude and longitude longitude numeric YES Decimal longitude longitude_verbatim text YES Verbatim longitude max_dist numeric YES Maximum distance from centroid to be counted as centroid (parameter) max_dist_rel numeric YES Relative distance to centroid (Absolute distance divided by distance from centroid to farthest point on perimiter). state text YES State in which point is located, as georeferenced by CDS state_cent_dist numeric YES Absolute distance in km from observation to county centroid state_cent_dist_max numeric YES Maximum distance from centroid to be counted as centroid state_cent_dist_relative numeric YES Relative distance to centroid (Absolute distance divided by distance from centroid to farthest point on perimiter). state_cent_type text YES Centroid of shape of this type subpoly_cent_dist numeric YES Absolute distance in km from observation to subpolygon centroid subpoly_cent_dist_max numeric YES Maximum distance from centroid to be counted as centroid subpoly_cent_dist_relative numeric YES Relative distance to centroid (absolute distance divided by distance from centroid to farthest point on perimiter). subpoly_cent_type text YES Centroid of shape of this type