Comment: One row per site where a study was or is being conducted. One pair of geographic coordinates are designated to the entire site.
|siteid||integer Auto Increment [nextval('site_siteid_seq')]||Unique row identifier. The value of this column is automatically assigned by the system; the normal practice, which results in a system generated id, is to omit this column when inserting new rows or to supply a NULL value. The value of this column cannot be NULL.|
|name||character varying(64)||The name of the site, which must be unique. This may be a short or a long name, depending on what the study uses.|
|latitude||numeric(7,3) NULL||The decimal latitude coordinate of the site, using positive and negative sign to indicate N and S, respectively.|
|longitude||numeric(7,3) NULL||The decimal longitude coordinate of the site, using positive and negative sign to indicate E and W, respectively.|
|geodetic_datum||character varying(12) NULL [WGS84]||The geodetic system on which the geo-coordinates are based. For geo-coordinates measured between 1984 and 2010 this will typically be WGS84, which is the default value.|