36201 LnkPlSta2 Entity Published / External 27485 Coastal Estuarine Linkages Data Set Completed Linkages Plankton-Station table Data File Yes Linkages Plankton-Station table 1 key VARCHAR 8 Yes Yes 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 consta INTEGER 2 Yes No 2 0 Active consecutive station number for a given cruise INTEGER 4 stdsta INTEGER 2 Yes No 2 0 Active standard,or fixed, station number INTEGER 5 pdate DATE 8 Yes No Active Plankton_date format mm/dd/yyyy DATE 6 ptime TIME 8 Yes No Active Plankton_timeformat HH:MI:SS AM/PM TIME 7 pdatetime TIMESTAMP 8 Yes No Active Plankton_Datetime format mm/dd/yyyy HH24:MI TIMESTAMP 8 pjdat DOUBLE PRECISION 8 Yes No 10 7 Active Plankton_Julian date DOUBLE PRECISION 9 mon INTEGER 2 Yes No 2 0 Active Month (1 to 12) INTEGER 10 year INTEGER 2 Yes No 4 0 Active Year (4-digit) INTEGER 11 sur INTEGER 2 Yes No 1 0 Active consecutive survey number INTEGER 12 pgear VARCHAR 4 Yes No Active Plankton_gear code VARCHAR 13 net VARCHAR 1 Yes No Active net identifier VARCHAR 14 haul INTEGER 2 Yes No 1 0 Active haul number for the specific gear type INTEGER 15 plat DOUBLE PRECISION 8 Yes No 6 2 Active Plankton_Latitude (ddmm.xx) DOUBLE PRECISION 16 plng DOUBLE PRECISION 8 Yes No 6 2 Active Plankton_Longitude (ddmm.xx) DOUBLE PRECISION 17 pdlat DOUBLE PRECISION 8 Yes No 15 13 Active Plankton_Latitude, decimal-degrees DOUBLE PRECISION 18 pdlng DOUBLE PRECISION 8 Yes No 15 13 Active Plankton_Longitude, decimal-degrees DOUBLE PRECISION 19 pdpt DOUBLE PRECISION 8 Yes No 3 1 Active Plankton_towdepth DOUBLE PRECISION 20 fmNum INTEGER 2 Yes No 5 0 Active flowmeter number INTEGER 21 calib(m/ct) DOUBLE PRECISION 8 Yes No 7 6 Active calibrationfactor (m/count) DOUBLE PRECISION 22 fmStart INTEGER 2 Yes No 6 0 Active flowmeter start value INTEGER 23 fmEnd INTEGER 2 Yes No 6 0 Active flowmeter end value INTEGER 24 fmcounts INTEGER 2 Yes No 5 0 Active actual flowmeter count INTEGER 25 calcdist DOUBLE PRECISION 8 Yes No 7 6 Active distance traveled (fmcounts*calibrationfactor) DOUBLE PRECISION 26 mouthArea DOUBLE PRECISION 8 Yes No 10 9 Active plankton net area (pi*r2)=0.285815938m2 DOUBLE PRECISION 27 Volm3 DOUBLE PRECISION 8 Yes No 16 13 Active Volume of water filtered (moutharea*distanced traveled) DOUBLE PRECISION 28 mwo DOUBLE PRECISION 8 Yes No 3 1 Active maximum amount of wire out DOUBLE PRECISION 29 AngleFrSfc DOUBLE PRECISION 8 Yes No 4 2 Active wire angle from surface DOUBLE PRECISION 30 calcmtd DOUBLE PRECISION 8 Yes No 16 14 Active calculated max tow depth (mwo * sin(AngleFrSfc) DOUBLE PRECISION 31 HF10m2 DOUBLE PRECISION 8 Yes No 16 14 Active Haul factor (no./10m2), =mtd/[(counts)*(moutharea)*(calib)*10)] DOUBLE PRECISION gov.noaa.nmfs.inport:36201 Patricia Jones 2017-01-04T11:39:58 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