Template:ChadoTable nd geolocation
From GMOD
This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- The Chado Tables page, which lists all tables.
You can include this template anywhere you want to show the table description.
| Table: | nd_geolocation |
| Module: | Natural Diversity |
The geo-referencable location of the stock. NOTE: This entity is subject to change as a more general and possibly more OpenGIS-compliant geolocation module may be introduced into Chado.
| FK | Name | Type | Description |
|---|---|---|---|
| nd_geolocation_id | serial | PRIMARY KEY | |
| description | character varying(255) | A textual representation of the location, if this is the original georeference. Optional if the original georeference is available in lat/long coordinates. | |
| latitude | real | The decimal latitude coordinate of the georeference, using positive and negative sign to indicate N and S, respectively. | |
| longitude | real | The decimal longitude coordinate of the georeference, using positive and negative sign to indicate E and W, respectively. | |
| geodetic_datum | character varying(32) | The geodetic system on which the geo-reference coordinates are based. For geo-references measured between 1984 and 2010, this will typically be WGS84. | |
| altitude | real | The altitude (elevation) of the location in meters. If the altitude is only known as a range, this is the average, and altitude_dev will hold half of the width of the range. |
Tables referencing nd_geolocation via foreign key constraints:
