nd_geolocation

4 rows


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 Nulls Auto Default Children Parents Comments
nd_geolocation_id serial 10 nextval('nd_geolocation_nd_geolocation_id_seq'::regclass)
nd_experiment.nd_geolocation_id nd_experiment_nd_geolocation_id_fkey C
nd_geolocation_dbxref.nd_geolocation_id nd_geolocation_dbxref_nd_geolocation_id_fkey C
nd_geolocationprop.nd_geolocation_id nd_geolocationprop_nd_geolocation_id_fkey C
description varchar 255 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.

Indexes

Constraint Name Type Sort Column(s)
nd_geolocation_pkey Primary key Asc nd_geolocation_id

Relationships