Sites
The Sites table represents the highest level in the relationships since all data must be associated with a site.
Column name	Data type	Column description
SiteID	varchar	Unique Site identification number. Numeric of five digits prefix with "S".
SiteName	varchar	Sitename
Region	varchar	Administrative or geographic region. Purely for distinguishing sites with same names. Optional.
Latitude	decimal	Decimal degrees to 3 dp
Longitude	decimal	Decimal degrees to 3 dp. Negative values are west of Greenwich meridian
Country	varchar	Modern geo-political country
Notes	varchar