View topp.public.acoustic_atn_station
This view summarizes acoustic detections at main Block Lab locations by station and site. It is used by the ATN.

 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
code int4 10  √  null This is the basic identification code for an acoustic tag.
detections int8 19  √  null The number of detections at a receiver at a specific station.
site text 2147483647  √  null The site level geographich area of receiver deployment.
station text 2147483647  √  null The station level geographic area of receiver deployment.
longitude numeric 131089  √  null The longitude of receiver deployment.
latitude numeric 131089  √  null The latitude of the receiver deployment.
commonname text 2147483647  √  null The common name of animal carrying detected tag.

Analyzed at Wed Dec 27 13:25 PST 2017