SQL Code: Dwell time, concurrent tag contacts, and receiver bypass analysis of FishTracks telemetry data

Executing the Dwell Time analysis condenses receiver/tag records into readable records of fish movement and receiver effectiveness. Fish movement is described by a temporal sequence of receiver/tag events (durations), where a tag is visible to a specific receiver or collection of receivers. The number and frequency of contacts within a receiver/tag event are summarized by the analysis. A receiver/tag event ends, and a new receiver/tag event begins when the tag is visible to a different set of receivers.

Additionally, the Dwell Time analysis identifies which receivers have overlapping detection ranges and identify which receivers are potentially being bypassed by tagged fish.

The SQL code included here is run within the FishTracks SQL Server Database, hosted by the Upper Midwest Environmental Sciences Center.