| ODM2 [ODM2_DBWrench_Schema.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| SamplingFeatures | Describes the sampling features on which observations are made. |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| SamplingFeatureID | Integer |
| nextval('"ODM2Core"."SamplingFeatures_SamplingFeatureID_seq"'::regclass) | Primary key identifier. | ||
| SamplingFeatureUUID | VarChar(36) | A universally unique identifier for the sampling feature. | |||||
| SamplingFeatureTypeCV | VarChar(255) | CV term descripting the type of sampling feature. |
|
||||
| SamplingFeatureCode | VarChar(50) | A short but meaningful text identifier for the sampling feature. | |||||
| SamplingFeatureName | VarChar(255) |
| Sampling Feature name (free text). | ||||
| SamplingFeatureDescription | VarChar(5000) |
| Text describing the sampling feature. | ||||
| SamplingFeatureGeotypeCV | VarChar(255) |
| Dimensionality of SamplingFeature: point2d, line2d, etc. |
|
|||
| FeatureGeometry | Geometry |
| The location geometry of the sampling feature on the Earth expressed using a geometry data type. Can be a Point, Curve (profile, trajectory, etc), Surface (flat polygons, etc) or Solid/Volume (although often limited to 2D geometries). | ||||
| FeatureGeometryWKT | VarChar(8000) |
| The location geometry of the sampling feature on the Earth expressed as well known text (WKT). Can be a Point, Curve (profile, trajectory, etc.), Surface (flat polygons, etc.), or Solid/Volume (although often limited to 2D geometries). | ||||
| Elevation_m | Float |
| The elevation of the sampling feature in meters, or in the case of Specimen, the elevation from where the SamplingFeature.Specimen was collected | ||||
| ElevationDatumCV | VarChar(255) |
| The code for the vertical geodetic datum that specifies the zero point for the Sampling Feature Elevation. |
|
|||
| Latitude | Float |
| Latitude of centroid of SamplingFeature | ||||
| Longitude | Float |
| Longitude of centroid of SamplingFeature | ||||
| EPSG | VarChar(20) |
| EPSG of the Spatial Reference System that describes the latitude and longitude coordinates. This refers to codes obtained from http://www.epsg.org/ and maintained in epsg db | ||||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_SamplingFeatures_CV_ElevationDatum | ODM2CV.CV_ElevationDatum | ODM2Core.SamplingFeatures | Term | ElevationDatumCV |
| fk_SamplingFeatures_CV_SamplingFeatureGeoType | ODM2CV.CV_SamplingFeatureGeoType | ODM2Core.SamplingFeatures | Term | SamplingFeatureGeotypeCV |
| fk_SamplingFeatures_CV_SamplingFeatureType | ODM2CV.CV_SamplingFeatureType | ODM2Core.SamplingFeatures | Term | SamplingFeatureTypeCV |
| Triggers (none) |