36200 LnkLarLenDens Entity Published / External 27485 Coastal Estuarine Linkages Data Set Completed Linkages Larva-Length table Data File Yes Linkages Larva-Length table 1 key VARCHAR 8 Yes No Active concatenation of Cruise code and Standard Station number VARCHAR 2 cr VARCHAR 6 Yes No Active 2 char each for ship, year and consecutive cruise number (for the year) VARCHAR 3 stdsta INTEGER 2 Yes No 2 0 Active standard,or fixed, station number INTEGER 4 gear VARCHAR 4 Yes No Active gear code VARCHAR 5 net VARCHAR 1 Yes No Active net id VARCHAR 6 haul INTEGER 2 Yes No 1 0 Active haul number for the specific gear type INTEGER 7 CD INTEGER 4 Yes No 9 0 Active 9-digit species code for fish INTEGER 8 totcnt INTEGER 2 Yes No 4 0 Active Total count of fish larvae in the net INTEGER 9 TotDen10m2 DOUBLE PRECISION 8 Yes No 18 14 Active Density/Total catch adjusted & expressed as no./10m2 of sea-surface area DOUBLE PRECISION 10 TotDen100m3 DOUBLE PRECISION 8 Yes No 18 14 Active Density/Total catch adjusted & expressed as no./100m3 of cubic meters DOUBLE PRECISION 11 mct INTEGER 2 Yes No 3 0 Active Total number of fish larvae measured INTEGER 12 len DOUBLE PRECISION 8 Yes No 3 1 Active Length of each fish larvae measured DOUBLE PRECISION 13 num INTEGER 2 Yes No 2 0 Active Number of fish larvae at that length INTEGER 14 Lden10m2 DOUBLE PRECISION 8 Yes No 16 14 Active Density/Total catch by length adjusted & expressed as no./10m2 of sea-surface area DOUBLE PRECISION 15 Lden100m3 DOUBLE PRECISION 8 Yes No 16 14 Active Density/Total catch by length adjusted & expressed as no./100m3 of cubic meters DOUBLE PRECISION gov.noaa.nmfs.inport:36200 Patricia Jones 2017-01-04T11:39:43 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-02-15 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-15 1 Year 2018-02-15