Table topp.public.acoustic_data
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.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
tkey serial 10  √  nextval('acoustic_data_tkey_seq'::regclass) Unique ID serial primary key field.
channel text 2147483647  √  null Channel was included in old Vemco data files not currently used and will be deprecated
code int4 10  √  null This is the basic identification code for an acoustic tag.
date text 2147483647  √  null Original date field but not currently used and will be deprecated.
time text 2147483647  √  null Original time field but not currently used and will be deprecated.
data text 2147483647  √  null Sensor data from sensor equiped tags.
units text 2147483647  √  null Units from sensor data from sensor equiped tags.
receiver int4 10  √  null Unique ID number of receiver that made the detection.
dataid int4 10  √  null Not currently used and will be deprecated.
downloadid int8 19  √  null A unique date time generated ID associated with a specific file ingestion.
longitude float8 17,17  √  null Longitude at time of detection. Generally only present for VMT detections.
latitude float8 17,17  √  null Latitude at time of detection. Generally only present for VMT detections.
receiver_dnum int4 10  √  null This value reflects a specific deployment event for an individual receiver. Used along with receiver field to join with acoustic_deployment table.
codespace text 2147483647  √  null 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.
false_hit int4 10  √  0 Any known bad detection will have a value of 1.
fdate text 2147483647  √  null Not sure about this one. Probably not used.
ftime text 2147483647  √  null Not sure about this one. Probably not used.
ping_detection timestamp 29,6  √  null Date and time of detection.

Table contained 2,964,525 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
tkey Primary key Asc acoustic_data_pkey