Detections and Releases

Definitions for columns in materialized tables presented via GeoServer, GoogleEarth, CSV files, and spreadsheets. These are products created directly from OTN database tables.

Table Name	Description
mv_anm_released	A record for each animal tagged by project owner, along with animal release and morphology information.
mv_anm_detections	A 'release' record for each animal along with all detections of tagger's animals no matter where they occurred. Release records will be present even if there have been no detections.
mv_anm_compressed	A compression of mv_anm_detections. There will be one record representing both arrival and departure at at station/receiver . Time of arrival, time of departure, and detection counts along with average of any sensor calibrations. Useful for visualizing sets with large detection counts.
mv_line_detections	All detections for a deployment line stripped of all identifying animal information. Only projects which deployed receivers will have this table. Useful for performance analysis of Sentinel tags. Not to be used for tracking animals.


Column	Definition	Example	Special	Data Source	Where Used	Source Table	Source Column
collectioncode	Acronym for project representing release or detection record. This is assigned by OTN when the project is first proposed or the data arrives at OTN headquarters for loading.	GTS		OTN assigned	mv_anm_released mv_anm_detections mv_anm_compressed mv_line_detections	otn_resources	collectioncode
catalognumber	Unique identifier for an animal. When tracking an animal this is the column which should be used to group all the detections for one animal. Made from the project acronym and an animal id if given by researcher. If no animal id is provided OTN creates one. For mv_line_detections the catalognumber will be unique for each record, and will be made from the project acronym, tagname, plus a sequence number.	GTS-a45 GTS-A69-1303-1234-987		OTN assigned	mv_anm_released mv_anm_detections mv_anm_compressed mv_line_detections	otn_animals	catalognumber
scientificname	Scientific name of animal as recognized by WORMS.			Metadata: verified with WORMS	mv_anm_released mv_anm_detections mv_anm_compressed	otn_animals	scientificname
commonname	Common name as given by researcher.			Metadata	mv_anm_released mv_anm_detections mv_anm_compressed	otn_animals	commonname
datelastmodified	Date record was added to database table or updated. YYYY-MM-DD	2012-03-22		auto assigned	mv_anm_released mv_anm_detections mv_anm_compressed mv_line_detections	all source tables have this column	datelastmodified
detectedby	For releases the word 'release' is used to represent the starting point. For detection records the project acronym for the deployment operator.	release HFX		OTN assigned	mv_anm_detections mv_anm_compressed	otn_detections	collectioncode
subarray	For future use: Grouping code for several stations or receivers. This is used in cases where a deployment operator has several lines. Perhaps various crossing points on a river or across several harbours or bays. Used to group detections especially when counts are very high. Currently will always be the same as detectedby.	HFX			mv_anm_detections mv_anm_compressed mv_line_detections	otn_detections	collectioncode
station	An abstract value for grouping consecutive receiver deployments in the same area. The receivers can be the same or different.	HFX456 GTS-E5		Metadata	mv_anm_detections mv_anm_compressed mv_line_detections	moorings record RECEIVER	relatedcatalogitem
receiver	The model and serial number of the receiver as it appears on the detection record exported from Vemco VUE database. For satellite detections the word 'Satellite' will be in this column. If 'lost/found' is concatenated to the receiver name this means the detection is from a receiver which was lost and found, frequently far from the deployment area. These detections should be used with caution.	VR4-34568 Satellite	VR4-34568-lost/found assigned when reported	VUE export	mv_anm_detections mv_anm_compressed mv_line_detections	otn_detections	collectornumber
tagname	The tagname as it appears on the detection record exported from Vemco VUE database. For satellite transmitters this could be the PPT number as it appears on the manufacturers processed detection file, or the catalognumber for the specific satellite transmitter release metadata. For sensor tags which are associated with a pinger id, this will the the tagname for the pinger. CAUTION: as tags and other transmitters are reused this column cannot be used to group detections for an animal. Grouping by this column could combine detections for more than one animal. Some animals have more than one type of transmitter so using this column for grouping will miss detections from a second source. To group detections for an animal use CATALOGNUMBER.	A69-1303-45623 A69-9002-3456 66501-F853		VUE export WildLife export Metadata	mv_anm_detections mv_anm_compressed mv_line_detections	otn_detections	fieldnumber
sensorname	The tagname for the the sensor tag as it appears on the detection record exported from Vemco VUE database. For new style (A69-9002) will be the same as the tagname. Will be null for non sensor tags.	A69-1105-78910 A69-9002-3456		VUE export	mv_anm_compressed	otn_detections	fieldnumber
sensorraw	The sensor value for the the sensor tag as it appears on the detection record exported from Vemco VUE database.	integer value		VUE export	mv_anm_detections	otn_detections	sensorraw
sensortype	The sensor type as noted in manufactures tag specifications. Null if we have not received specifications.	acceleration temperature depth		manufacture specifications	mv_anm_detections	otn_detections	sensortype
sensorvalue	The calculated value using the raw integer value from the detection and the slope and intercept from the manufacturers specifications. Null if we have not received specifications.	decimal value		manufacture specifications	mv_anm_detections	otn_detections	sensorvalue
sensorunit	The sensor unit as noted in manufactures tag specifications. Null if we have not received specifications.	m C ADC (indicates raw only) m/s² Meters		manufacture specifications	mv_anm_detections	otn_detections	sensorunit
datecollected	Date of release (from tagging metadata) or date of detection from processed detection files. Always UTC. Format YYYY-MM-DD HH:MI:SS	2012-01-31 13:45:26	corrected to UTC if necessary	VUE export WildLife export	mv_anm_released mv_anm_detections mv_line_detections	otn_detections	datecollected
timezone	Always UTC	UTC			mv_anm_released mv_anm_detections mv_anm_compressed mv_line_detections	otn_detections	timezone
longitude	For 'release' records as reported in the tagging metadata. For detection records as reported in receiver metadata deployment sheet. In the case of lost/found receivers it will be the longitude where the instrument was found.	decimal degrees		metadata	mv_anm_released mv_anm_detections mv_anm_compressed mv_line_detections	otn_animals moorings record RECEIVER	longitude
latitude	For 'release' records as reported in the tagging metadata. For detection records as reported in receiver metadata deployment sheet. In the case of lost/found receivers it will be the latitude where the instrument was found.	decimal degrees		metadata	mv_anm_released mv_anm_detections mv_anm_compressed mv_line_detections	otn_animals moorings record RECEIVER	latitude
st_setsrid	Geometry point in projection 4326. Calculated from postgis function: st_setsrid(st_makepoint(longitude,latitude), 4326).	geometry		calculated	mv_anm_released mv_anm_detections mv_anm_compressed mv_line_detections	all source tables	longitude latitude
yearcollected	Extracted from datecollected.	integer::text			mv_anm_released mv_anm_detections mv_line_detections	all source tables	datecollected
monthcollected	Extracted from datecollected.	integer::text			mv_anm_released mv_anm_detections mv_line_detections	all source tables	datecollected
daycollected	Extracted from datecollected.	integer::text			mv_anm_released mv_anm_detections mv_line_detections	all source tables	datecollected
julianday	Extracted from datecollected.	integer			mv_anm_released mv_anm_detections mv_line_detections	all source tables	datecollected
timeofday	Extracted from datecollected.	decimal hours			mv_anm_released mv_anm_detections mv_line_detections	all source tables	datecollected
datereleasedanimal	Date animal metadata released to public. Controlled by tag owner and OTN Data Policy Agreement. YYYY-MM-DD	Future use		OTN Data Policy Agreement	mv_anm_released mv_anm_detections mv_anm_compressed	otn_animals	datereleasedanimal
datereleaseddetections	Date the animal detection released to public. Controlled by tag owner and OTN Data Policy Agreement. YYYY-MM-DD	Future use		OTN Data Policy Agreement	mv_anm_released mv_anm_detections mv_anm_compressed	otn_animals	datereleaseddetections
local_area or locality	Description of release area or receiver deployment area as reported in metadata.	Sand dollar beach Algoa Bay East Island		Discovery Metadata	mv_anm_detections mv_anm_compressed
linecitation	Citation of project as it appears in Discovery Metadata. For 'release' records it will be the citation for the tag owner. For detection records it will be the citation for the deployment operator.			Discovery Metadata	mv_anm_detections mv_anm_compressed	otn_resources	citation

These columns appear only in table MV_ANM_RELEASED.

lifestagedescription

Column	Definition	Example	Data Source	Source Table	Source Column
stock		4X, can be null	metadata	otn_animals	stock
wild_ind	An indicator of whether the animal is wild, farmed, or from a hatchery.	W,H,U, can be null	metadata	otn_animals	wild_ind
sex		M,F,U, can be null	metadata	otn_animals	sex
observedweight	Weight in kilograms.	numeric , can be null	metadata	otn_animals	observedweight
length	Length in metres.	numeric , can be null	metadata	otn_animals	length
lengthtype	Description of length measured. Should not be null if length is not null.	Fork, Total, Carapace	metadata	otn_animals	lengthtype
length2	Length in metres.	numeric, can be null	metadata	otn_animals	length2
length2type	Description of length2 measured.Should not be null if length2 is not null.	Fork, Total, Carapace	metadata	otn_animals	length2type
age		numeric, can be null	metadata	otn_animals	age
ageunit	Unit used for age column.Should not be null if age is not null.	Year, month.	metadata	otn_animals	ageunit
lifestage	One word or category recognizable by researchers as meaningful.	Grisle, can be null	metadata	otn_animals	lifestage
lifestagedescription	Description of meaning of lifestage word or category.	one sea winter can be null	metadata	otn_animals

These columns appear only in table MV_ANM_COMPRESSED. This table presents fewer records to make it easier to visualize an animal track. There is one record representing the

time an animal arrives at a station or receiver and when it leaves. There is a sequence number so that the records can be properly ordered.

Column	Description	Source Table	Source Column
avgtemp	Average temperature during sequence period.	otn_detections	Function f_sensor_mean operating on temperature sensor detections during arrival/departure period.
mintemp	Minimum temperature during sequence period.	otn_detections	Function f_sensor_mean operating on temperature sensor detections during arrival/departure period.
maxtemp	Maximum temperature during sequence period.	otn_detections	Function f_sensor_mean operating on temperature sensor detections during arrival/departure period.
unittemp	The unit of the temperature scale. This will always be Celsius.	otn_detections	Function f_sensor_mean operating on temperature sensor detections during arrival/departure period.
avgdepth	Average depth during sequence period.	otn_detections	Function f_sensor_mean operating on depth sensor detections during arrival/departure period.
mindepth	Minimum depth during sequence period.	otn_detections	Function f_sensor_mean operating on depth sensor detections during arrival/departure period.
maxdepth	Maximum depth during sequence period.	otn_detections	Function f_sensor_mean operating on depth sensor detections during arrival/departure period.
unitdepth	The unit of depth scale during sequence period. This will always be metres.	otn_detections	Function f_sensor_mean operating on depth sensor detections during arrival/departure period.
avgaccel	Average acceleration during sequence period.	otn_detections	Function f_sensor_mean operating on acceleration sensor detections during arrival/departure period.
minaccel	Minimum acceleration during sequence period.	otn_detections	Function f_sensor_mean operating on acceleration sensor detections during arrival/departure period.
maxaccel	Maximum acceleration during sequence period.	otn_detections	Function f_sensor_mean operating on acceleration sensor detections during arrival/departure period.
unitaccel	Unit of acceleration during sequence period. This will always be m/s².	otn_detections	Function f_sensor_mean operating on acceleration sensor detections during arrival/departure period.
seq_num	A number representing the order of stations or receivers at which the animal was detected.	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.
total_count	The number of detections at the receiver during arrival and departure at receiver. This number will be equal to the sum of: pinger_count + sen_temp_count + sen_depth_count + sen_acclr_count + sen_unkn_count	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.
pinger_count	Total number of non sensor detections during sequence period.	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.
sen_temp_count	Total number of temperature sensor detections during sequence period.	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.
sen_depth_count	Total number of depth sensor detections during sequence period.	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.
sen_acclr_count	Total number of accelleration sensor detections during sequence period.	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.
sen_unkn_count	Total number of unknown type sensor detections during sequence period. These will be sensor detections for which we do not have the calibration factors from the Vendor specifications.	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.
datestart	Date and time animal arrives at station or receiver.	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.
dateend	Date and time animal leaves station or receiver.	otn_detections	Function f_det_compressed operating on detection records during arrival/departure period.