sites

19267 rows


Description

The Sites table stores information about sites or localities, including name, geographic coordinates, and description. Sites generally have an areal extent and can be circumscribed by a latitude-longitude box. However, site data ingested from legacy databases have included only point locations. The lat-long box can be used either to circumscribe the aerial extent of a site or to provide purposeful imprecision to the site location. Site location may be imprecise because the original description was vague, e.g. «a gravel bar 5 miles east of town», or because the investigators, land owner, or land management agency may not want the exact location made public, perhaps to prevent looting and vandalism. In the first case, the lat-long box can be made sufficiently large to encompass the true location and in the second case to prevent exact location.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
siteid serial 10 nextval('ndb.seq_sites_siteid'::regclass)
collectionunits.siteid fk_collectionunits_sitesC
lakeparameters.siteid fk_lakeparameters_sitesC
sitegeopolitical.siteid fk_sitegeopolitical_sitesC
siteimages.siteid fk_siteimages_sitesC
sitename varchar 128 null
longitudeeast float8 17,17 null
latitudenorth float8 17,17 null
longitudewest float8 17,17 null
latitudesouth float8 17,17 null
altitude float8 17,17 null
area float8 17,17 null
sitedescription text 2147483647 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null
geog geography 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
sites_pkey Primary key Asc siteid
ix_siteid_sites Performance Asc siteid
sitegeog_gix Performance Asc geog
sitenames_idx Performance Asc sitename

Relationships