34407 GMRI_COD_RELEASE Entity Published / External 27389 Northeast Regional Cod Tagging Program Data Set Completed Specific information about each haul. The COUNT breakdowns (by size, milt, eggs) apply only to fish with actual tags. Loaded by batch 9211, 08-23-2016 14:45 Data Table Yes CO_OP_RESEARCH Specific information about each haul. The COUNT breakdowns (by size, milt, eggs) apply only to fish with actual tags. 1 RELEASE_ID NUMBER 22 Yes No 11 0 Active Unique ID – identifies a specific haul NUMBER 2 TRIP_ID NUMBER 22 Yes No 11 0 Active Identifies trip associated with this haul - from COD_TRIP data table NUMBER 3 FISH_LENGTH_UNIT_ID NUMBER 22 Yes No 11 0 Active Identifies measurement units used (inches or centimeters) – from COD_UNIT LUT NUMBER 4 HAUL_NUMBER NUMBER 22 No No 11 0 Active Haul number entered by user NUMBER 5 START_LONGITUDE FLOAT 22 No No 126 Active Starting longitude of haul (redacted) FLOAT 6 START_LATITUDE FLOAT 22 No No 126 Active Starting latitude of haul (redacted) FLOAT 7 END_LONGITUDE FLOAT 22 No No 126 Active Ending longitude of haul (redacted) FLOAT 8 END_LATITUDE FLOAT 22 No No 126 Active Ending latitude of haul (redacted) FLOAT 9 START_LORAN1 FLOAT 22 No No 126 Active Starting LORAN 1 coordinate (redacted) FLOAT 10 START_LORAN2 FLOAT 22 No No 126 Active Starting LORAN 2 coordinate (redacted) FLOAT 11 END_LORAN1 FLOAT 22 No No 126 Active Ending LORAN 1 coordinate (redacted) FLOAT 12 END_LORAN2 FLOAT 22 No No 126 Active Ending LORAN 2 coordinate (redacted) FLOAT 13 START_DATE DATE 7 No No Active Date haul began DATE 14 END_DATE DATE 7 No No Active Date haul ended DATE 15 START_DEPTH FLOAT 22 No No 126 Active Depth of haul at beginning FLOAT 16 END_DEPTH FLOAT 22 No No 126 Active Depth of haul at the end FLOAT 17 TEMP_SURFACE FLOAT 22 No No 126 Active Surface water temperature FLOAT 18 TEMP_BOTTOM FLOAT 22 No No 126 Active Bottom water temperature FLOAT 19 CHECKING_SPAWN NUMBER 22 No No 3 0 Active 0= Tagger is not checking for spawn 1= Tagger is checking for spawn NUMBER 20 TAGGER VARCHAR2 200 No No Active Tagger'’s name VARCHAR2 21 USER_COMMENT VARCHAR2 1020 No No Active Miscellaneous comments VARCHAR2 22 DATE_UNCERTAIN NUMBER 22 No No 3 0 Active 0= Date is accurate 1= Date is uncertain 2= Date is REALLY uncertain NUMBER 23 LOCATION_UNCERTAIN NUMBER 22 No No 3 0 Active 0= Location coordinates are accurate 1= Location coordinates are estimated NUMBER 24 COUNT_SIZE_UNKNOWN NUMBER 22 No No 11 0 Active Total number of fish of unknown size - Calculated during trip approval NUMBER 25 COUNT_SIZE_VSMALL NUMBER 22 No No 11 0 Active Total number of very small fish (0-30 cm) Calculated during trip approval NUMBER 26 COUNT_SIZE_SMALL NUMBER 22 No No 11 0 Active Total number of small fish (30-50 cm) Calculated during trip approval NUMBER 27 COUNT_SIZE_MEDIUM NUMBER 22 No No 11 0 Active Total number of medium fish (50-80 cm) Calculated during trip approval NUMBER 28 COUNT_SIZE_LARGE NUMBER 22 No No 11 0 Active Total number of large fish (80+ cm) Calculated during trip approval NUMBER 29 COUNT_EGGS NUMBER 22 No No 11 0 Active Total number of fish with eggs Calculated during trip approval NUMBER 30 COUNT_MILT NUMBER 22 No No 11 0 Active Total number of fish with milt Calculated during trip approval NUMBER 31 CLOSURE_AREA_ID NUMBER 22 No No 11 0 Active Identifies groundfish closure area where haul took place (if applicable) – from COD_CLOSURE_AREA LUT NUMBER 32 COUNT_TAGGED NUMBER 22 Yes No 11 0 Active Number of fish tagged per haul NUMBER 33 COUNT_NONTAGGED NUMBER 22 Yes No 11 0 Active Number of fish assigned a non-tag ID per haul (e.g. poor condition, undersized fish) NUMBER gov.noaa.nmfs.inport:34407 Patricia Jones 2016-08-23T14:45:54 SysAdmin InPortAdmin 2022-08-09T17:11:05 2017-02-24 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2017-02-24 1 Year 2018-02-24