Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date_time | timestamptz | 35,6 | null |
|
|
Date/time stamp of the tag positional data record |
||||||||||
| lat | float8 | 17,17 | null |
|
|
Latitude in decimal degrees of the positional data tag record |
||||||||||
| lon | float8 | 17,17 | null |
|
|
Longitude in decimal degrees of the positional data tag record |
||||||||||
| lat_err | float8 | 17,17 | √ | null |
|
|
Error associated with the tag record Laitudiinal positional estimate |
|||||||||
| lon_err | float8 | 17,17 | √ | null |
|
|
Error associated with the tag record Longitudinal positional estimate |
|||||||||
| submission_id | int8 | 19 | null |
|
|
Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase |
||||||||||
| tag_id | int8 | 19 | null |
|
|
Unique numeric Tag ID associated with the ingested tag data file |
||||||||||
| argosLC | bpchar | 1 | √ | null |
|
|
Single character Argos Location Class positional quality code based on argosLC scheme defined by Argos System |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| data_position_pkey | Primary key | Asc/Asc/Asc | submission_id + tag_id + date_time |
| data_position_date_time_index | Performance | Asc | date_time |
| data_position_latlontime_index | Performance | Asc/Asc/Asc/Asc/Asc | date_time + lat + lon + submission_id + tag_id |