View: BENV03

Year in which cruise was conducted.

Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.

Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.

The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).

The date the vessel returned to port. Date format (DD-MON-YYYY).

Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.

The nth consecutive number of a cruise on the given vessel.

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.

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.

Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.

Grab sample replicate number. Number of replicates that were taken.

Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only.

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)

Hathaway stratum code.

A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions.

A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data. See table BENVESS for vessel code descriptions.

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.

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.

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.

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.

Latitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute.

Longitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute.

Loran C time delay, X-Chain, only available for Sandy Hook data.

Loran C time delay, Y-Chain, only available for Sandy Hook data.

Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O.

Bottom temperature in tenths of degrees C

Bottom/Sediment Type

Sediment volume in tenths of liters

Sediment volume removed in tenths of liters

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).

Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table).

Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

The Oracle username of the individual who entered the new record.

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

The Oracle username of the individual who changed the current record.

Scientific name for specimen.

NODC code for species.

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.

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 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.

Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data.

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.