| field |
comment |
| whole table |
This table contains all Block Lab acoustic detection data. It joins to acoustic_deployment with receiver and receiver_dnum fields and to tm_acoustic_with_eventid with code and codespace fields. |
| channel |
Channel was included in old Vemco data files not currently used and will be deprecated |
| code |
This is the basic identification code for an acoustic tag. |
| codespace |
Additional ID information that when combined with code in theory creates the complete unique tag ID. This is NOT true for A69-1105 codespace! Used along with code to join with tag management and deployment metadata in tm_acoustic_with_eventid. |
| data |
Sensor data from sensor equiped tags. |
| dataid |
Not currently used and will be deprecated. |
| date |
Original date field but not currently used and will be deprecated. |
| downloadid |
A unique date time generated ID associated with a specific file ingestion. |
| false_hit |
Any known bad detection will have a value of 1. |
| fdate |
Not sure about this one. Probably not used. |
| ftime |
Not sure about this one. Probably not used. |
| latitude |
Latitude at time of detection. Generally only present for VMT detections. |
| longitude |
Longitude at time of detection. Generally only present for VMT detections. |
| ping_detection |
Date and time of detection. |
| receiver |
Unique ID number of receiver that made the detection. |
| receiver_dnum |
This value reflects a specific deployment event for an individual receiver. Used along with receiver field to join with acoustic_deployment table. |
| time |
Original time field but not currently used and will be deprecated. |
| tkey |
Unique ID serial primary key field. |
| units |
Units from sensor data from sensor equiped tags. |