MargaretSiple-NOAA / goa-ai-data-reports

Automate data reports for GOA and AI surveys
1 stars 1 forks source link

survey station count #23

Closed Ned-Laman-NOAA closed 1 year ago

Ned-Laman-NOAA commented 1 year ago

survey station count in the data processed reports is equivalent to "biomass worthy" tows as indicated by the ABUDANCE_HAUL = 'Y' flag in RACEBASE.HAUL: SQLPlus script select count(distinct hauljoin) nstations from racebase.haul where region = 'AI' and cruise = 202201 and abundance_haul = 'Y' / on a historical note for the Gulf-Aleutian surveys, prior to the AbundanceHaul flag there were five fields in composite that identified a good (biomass worthy) tow (HAUL_TYPE = 3, PERFORMANCE >= 0, GEAR = 172, ACCESSORIES = 129, DURATION >= a minimum length of time that varies over the survey history...used to be 10 minutes but is currently 1.5 minutes)