31074 BENV03 Entity Published / External 25749 Benthic Habitat Database Data Set Completed View of Benthic Cruise, Station and Catch Tables Loaded by batch 8255, 03-08-2016 16:45 Data View Yes BENTHIC View of Benthic Cruise, Station and Catch Tables 1 YEAR VARCHAR2 4 No No Active Year in which cruise was conducted. VARCHAR2 2 PURPOSE_CODE VARCHAR2 3 No No Active Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes. VARCHAR2 3 VESSEL VARCHAR2 4 No No Active Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table. VARCHAR2 4 START_DATE DATE 7 No No Active The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY). DATE 5 END_DATE DATE 7 No No Active The date the vessel returned to port. Date format (DD-MON-YYYY). DATE 6 OPSID VARCHAR2 11 No No Active Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code. VARCHAR2 7 VESSEL_NUM VARCHAR2 5 No No Active The nth consecutive number of a cruise on the given vessel. VARCHAR2 8 RECID NUMBER 22 Yes No 8 0 Active Unique record identifier assigned to record. For Woods Hole data, this record id was extracted from the original benthic files loaded into ORACLE. For Sandy Hook data, this record id was assigned sequentially while loading the SH data into the benthic tables. NUMBER 9 CRUISE_ID VARCHAR2 10 Yes No Active Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise. VARCHAR2 10 STATION VARCHAR2 4 No No Active Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station. VARCHAR2 11 REPLICATE_NUMBER VARCHAR2 2 No No Active Grab sample replicate number. Number of replicates that were taken. VARCHAR2 12 FIXED_SITE VARCHAR2 4 No No Active Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only. VARCHAR2 13 STRATUM VARCHAR2 5 No No Active Stratum Code. A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 characters. The benthic stratum codes match the offshore regular stratum group (Group 01) in the NEFSC offshore bottom trawl surveys. (SVDBS) VARCHAR2 14 H_STRATUM VARCHAR2 3 No No Active Hathaway stratum code. VARCHAR2 15 GEAR_CODE VARCHAR2 2 No No Active A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions. VARCHAR2 16 VESSEL_CODE VARCHAR2 2 No No Active A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data. See table BENVESS for vessel code descriptions. VARCHAR2 17 SAMPLE_DATE DATE 7 No No Active Local date and time station was sampled. (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS) Time recorded to hour for Woods Hole data, recorded to minute for Sandy Hook data. If Daylight Savings Time was in effect at time of cruise, time is recorded in Daylight Savings Time. Time 00:00:00 indicates time not recorded. DATE 18 SAMPLE_GMT_DATE DATE 7 No No Active Greenwich mean date and time sample was taken (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Time recorded to hour for Woods Hole data, recorded to minute for Sandy Hook data. Time 00:00:00 indicates time not recorded. Sample GMT was calculated from SAMPLE_DATE. DATE 19 ARRIVAL_DATE DATE 7 No No Active Local date and time of arrival at station (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Not recorded for Woods Hole data. Sandy Hook data recorded to minute accuracy. If Daylight Savings Time was in effect at time of cruise, time is recorded in Daylight Savings Time. Time 00:00:00 indicates time not recorded. DATE 20 ARRIVAL_GMT_DATE DATE 7 No No Active Greenwich mean date and time of arrival at station (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Not recorded for Woods Hole data. Sandy Hook data recorded to minute accuracy. Time 00:00:00 indicates time not recorded. Arrival GMT calculated from ARRIVAL_DATE. DATE 21 LAT NUMBER 22 No No 5 1 Active Latitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute. NUMBER 22 LON NUMBER 22 No No 5 1 Active Longitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute. NUMBER 23 LORX VARCHAR2 9 No No Active Loran C time delay, X-Chain, only available for Sandy Hook data. VARCHAR2 24 LORY VARCHAR2 9 No No Active Loran C time delay, Y-Chain, only available for Sandy Hook data. VARCHAR2 25 DEPTH NUMBER 22 No No 4 0 Active Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O. NUMBER 26 BOTTEMP NUMBER 22 No No 6 3 Active Bottom temperature in tenths of degrees C NUMBER 27 SED_TYPE_CODE VARCHAR2 2 No No Active Bottom/Sediment Type VARCHAR2 28 SED_VOLUME NUMBER 22 No No 4 1 Active Sediment volume in tenths of liters NUMBER 29 SED_REMOVED NUMBER 22 No No 4 1 Active Sediment volume removed in tenths of liters NUMBER 30 ORIGINAL_BENTHIC_KEY VARCHAR2 14 No No Active Original benthic key, for Woods Hole data 2 character year, 2 character vessel code, 2 character cruise number, 4 character station, 2 character gear code, 2 character collection (replicate). For Sandy Hook data, 6 character cruise number (CRC), 4 character station (CON), 2 character grab (GRAB). VARCHAR2 31 CRC VARCHAR2 6 No No Active Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table). VARCHAR2 32 DATA_SOURCE VARCHAR2 2 No No Active Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole) VARCHAR2 33 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 34 UOE VARCHAR2 8 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 35 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 36 UOC VARCHAR2 8 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 37 SCINAME VARCHAR2 40 No No Active Scientific name for specimen. VARCHAR2 38 NODC_CODE VARCHAR2 12 No No Active NODC code for species. VARCHAR2 39 WH_SPECIES_CODE VARCHAR2 12 No No Active Species code assigned in the original Woos Hole benthic data. Code consists of 2-digit phylum, 1-digit class, 2-digit order, 2-digit family, 2-digit genus, 2-digit species. See table BENTXN for list of benthic taxonomic codes. VARCHAR2 40 CATCHWGT NUMBER 22 No No 9 3 Active Weight of catch in grams. For Woods Hole catch data (BENCAT), this weight is the expanded catch weight using the expansion factors from table BENCONV. For Woods Hole catalog data (BENCATALOG), this weight is not expanded. NUMBER 41 CATCHNUM NUMBER 22 No No 8 0 Active Number of individuals in catch. For Woods Hole catch data (BENCAT), this weight is the expanded catch number using the expansion factors from table BENCONV. For Woods Hole catalog data (BENCATALOG), this number is not expanded. NUMBER 42 CONDITION VARCHAR2 1 No No Active Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data. VARCHAR2 43 CATALOG VARCHAR2 1 No No Active For Woods Hole data, indicates if this sample is also in the benthic catalog. C indicates a record for this sample is in the benthic catalog, BENCATALOG. VARCHAR2 gov.noaa.nmfs.inport:31074 Patricia Jones 2016-03-08T16:45:10 SysAdmin InPortAdmin 2022-08-09T17:11:08 2017-03-14 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-03-14 1 Year 2018-03-14