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