Schema Version: 1.3

nd_geolocation


Description

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.

Columns

Column Type Size Foreign Key Nullable Default Comments
nd_geolocation_id bigserial 19
nextval('chado.nd_geolocation_nd_geolocation_id_seq'::regclass)
description text 2147483647
null

A textual representation of the location, if this is the original georeference. Optional if the original georeference is available in lat/long coordinates.

latitude float4 8,8
null

The decimal latitude coordinate of the georeference, using positive and negative sign to indicate N and S, respectively.

longitude float4 8,8
null

The decimal longitude coordinate of the georeference, using positive and negative sign to indicate E and W, respectively.

geodetic_datum varchar 32
null

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 float4 8,8
null

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.

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
nd_geolocation_pkey Primary key Asc nd_geolocation_id
nd_geolocation_idx1 Performance Asc latitude
nd_geolocation_idx2 Performance Asc longitude
nd_geolocation_idx3 Performance Asc altitude

Relationships