Table topp.public.acoustic_deployment
This table contains deployment info for acoustic receivers affiliated with Block Lab acoustic detection data. A deployment represents a specific period of time at a specific location and is denoted by the fields receiver and receiver_dnum. The geographic name for the deployment is broken down into three levels by area of influence - station, site and region. These levels are subjective. Joins to acoustic_data with receiver and receiver_dnum.

 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
deploystamp timestamp 29,6  √  null The date with or without time at deployment. Local time.
latdeg text 2147483647  √  null
latmin text 2147483647  √  null
londeg text 2147483647  √  null
lonmin text 2147483647  √  null
tzone text 2147483647  √  null
site text 2147483647  √  'unknown'::text The mid size geographic area of deployment, e.g., Farallones, Ano Nuevo or Tomales.
project text 2147483647  √  'unknown'::text The agency or group affiliated with the deployed, e.g., TOPP, OTN or Hydra.
dlondd float8 17,17  √  null Decimal degree longitude position of deployment.
dlatdd float8 17,17  √  null Decimal degree latitude position of deployment.
riser_m float8 17,17  √  null Not sure but possibly distance off bottom in meters
bottom_depth_m float8 17,17  √  null Bathymetric depth at receiver location.
type text 2147483647  √  'unknown'::text The receiver type, e.g., VR2W, VR2C or VR4G.
comments text 2147483647  √  null General comments not easily fitting in other fields.
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_data table.
station text 2147483647  √  'unknown'::text The most specific geographic location area of deployment, e.g., West Farallones, Ano North or PB19.
tkey serial 10  √  nextval('acoustic_deployment_tkey_seq'::regclass)
downloadid int8 19  √  null A unique date time generated ID associated with a specific file ingestion.
receiver int4 10  √  null Unique ID of deployed receiver. Each receiver can be deployed multiple times.
receiver_depth float8 17,17  √  null Depth of receiver below surface in meters.
region text 2147483647  √  'unknown'::text The largest geographic location area of deployment, e.g., Chagos, Mid-Atlantic Bight or Gulf of St Lawrence.
lost_missing text 2147483647  √  '0'::text If the receiver was lost or is currently missing then will have a value of 1.
substrate text 2147483647  √  null Substrate of seafloor at deploy site.
hydrophone int4 10  √  null The hydrophone serial number used with a VR4G or VR2C receiver.
cable_len text 2147483647  √  null Length of hydrophone cable used with a VR4G or VR2C receiver.
atn_site int4 10  √  null Not yet implemented but could make identifying site on ATN easy. Where 1 is true.

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

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