tbl_site_natgridrefs

0 rows


Description

Stores site coordinates using various national grid systems, such as the UK Ordnance Survey National Grid and Swedish SWEREF99. Each site may have coordinates in multiple grid systems (e.g., Swedish RT90 and SWEREF99TM).

Columns

Column Type Size Nulls Auto Children Parents Comments
site_natgridref_id int4 10 √

Primary key (automatically incremented).
site_id int4 10
tbl_sites.site_id fk_site_natgridrefs_sites_id R

Specifies the specific site.
method_id int4 10
tbl_methods.method_id fk_site_natgridrefs_method_id R

Specifies the coordinate system.
natgridref varchar 2147483647

The national grid reference for the site.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_site_natgridrefs_pkey Primary key Asc site_natgridref_id

Relationships

Close relationships within degrees of separation