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