25749
Benthic Habitat Database
Benthic Habitat Database
Data Set
Published / External
24234
Data Management Systems (DMS)
Project
Completed
The NOAA Northeast Fisheries Science Center has, through the years, accumulated an extensive data base of qualitative and quantitative (wet weight and number per square meter) data on the composition, distribution and abundance (including a variety of environmental measurements) of the macrobenthic invertebrate fauna of the U.S.east coast continental shelf, slope and upper rise ranging from the mouth of the Bay of Fundy to Key West, Florida.
Benthic fauna data has been collected from 1881 to the present by the National Marine Fisheries Service Laboratories at Woods Hole, MA (early years Bureau of Fisheries) and Sandy Hook, NJ (formerly with the Bureau of Sport Fisheries). Little data exists from 1881 to around 1955. After intensive sampling, data became sparse again after 1986. The data includes the work by Wigley and Theroux on the macrofauna of the Northeastern United States. Other major studies include Ocean Pulse, the Northeast Monitoring Program, New York Bight, 12 Mile Dumpsite, Long Island Sound and Raritan Bay surveys. Parameters included in these surveys include depth, sediment type, gear type, number, weight, family, class, genus, species name, and abundance. A total of 21,000 sample sites are included in this data set with 4,000 meters being the maximum depth sampled. Bottom temperature from MBTs and XBTs were measured from the 1960s to the present.
The benthic data base and the invertebrate collection continue to be used by ecologists, systematists, and taxonomists in preparing environmental impact statements, characterizing the benthic fauna of selected sites for a host of specific purposes (e.g. mining, dumping, drilling, marine sanctuaries, etc.).
Theme
benthic grab
Theme
benthic habitat
Theme
benthic mapping
Theme
benthic taxonomy
Theme
benthos
Theme
biology
Theme
bottom temperature
Theme
macrobenthic invertebrate fauna
Theme
marine
Theme
sediment type
Temporal
1953 - 1975
Temporal
1966 - 1992
Spatial
Bay of Fundy
Spatial
Georges Bank
Spatial
Gulf of Maine
Spatial
Nantucket Shoals
Spatial
U.S.east coast continental shelf
Stratum
benthic
Northeast Fisheries Science Center
Woods Hole
MA
USA
Data Set
Oracle Database
None Planned
Table (digital)
not applicable
Vessels: A.E.Verrill, Advance, Albatross I, Albatross III, Albatross IV, Antelope/Anderson, Asterias, Atlantic Twin, Blueback, Challenger, Delaware, Delaware II, Fish Hawk, Gilbert, Gosnold, Harengus, Kelez, Kyma, Mount Mitchell, Oregon II, Phalarope, Priscilla V., Researcher, Rorqual, Shirley & Roland, Silver Mink, Soop Ambrose Channel, SOOP Long Island Sound, SOOP Long Island Sound/Block Isl. Sound, Soop Raritan Bay, Soop Raritan Bay East, Venture, Whaling City
Gears: 1-M. Plankton Net, 1-Meter Nat. Dredge, 1-Meter Sled Net, 40 Ft Shrimp Trawl, 6 Foot Seine, Beam Trawl, Bongo Nets, Bottom Skimmer, Campbell Grab, Clam Shell Dredge, Dietz Lafond Sampler, Digby Drag, Digby Scoop, Dip Net, Diving Person-Scuba, Dutch Herr. Trawl, Engle Mid-Water Trawl, Fish Stomachs, Hand Collection, Hydraulic Clam Dredge, Isaac-Kidd Mid-Water, Mbl Nat. Dredge, Miller Plankton Net, Misc. Gear, No Gear Info, One Half Meter Net, Otter Trawl, Petersen Grab, Plank. Misc. Gear, Pots, Quahog Dredge, Ring Or Stramin Net, Rock Dredge, Scallop Dredge, Scoopfish, Shrimp Gear Misc Types, Smith Mcintyre Grab, Submersible, Tangle, Van Veen Bcf 0.2m2, Whoi Chain Bag Dredge, Whoi Min. Van Veen, Whoi Pipe Dredge
31013
Table: BENGEAR
BENGEAR
Published / External
Completed
Benthic Gear Codes and Description Support Table
Loaded by batch 8233, 03-07-2016 14:36
Data Table
Yes
BENTHIC
Benthic Gear Codes and Description Support Table
1
GEAR_CODE
VARCHAR2
2
No
No
Active
A two character field indicating the gear used.
VARCHAR2
2
GEAR_TYPE
VARCHAR2
25
No
No
Active
Name of gear type
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
4
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
5
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31014
Table: BENCAT
BENCAT
Published / External
Completed
Benthic Species Catch Table
Loaded by batch 8234, 03-07-2016 15:12
Data Table
Yes
BENTHIC
Benthic Species Catch Table
1
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
2
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
3
STATION
VARCHAR2
4
No
No
Active
Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.
VARCHAR2
4
REPLICATE_NUMBER
VARCHAR2
2
No
No
Active
Grab sample replicate number. Number of replicates that were taken.
VARCHAR2
5
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
6
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
7
H_STRATUM
VARCHAR2
3
No
No
Active
Hathaway stratum code.
VARCHAR2
8
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
9
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
10
SCINAME
VARCHAR2
40
No
No
Active
Scientific name for specimen.
VARCHAR2
11
NODC_CODE
VARCHAR2
12
No
No
Active
NODC code for species.
VARCHAR2
12
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
13
CATCHWGT
NUMBER
22
No
No
9
3
Active
Weight of catch. 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
14
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
15
CONDITION
VARCHAR2
1
No
No
Active
Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data.
VARCHAR2
16
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
17
DATA_SOURCE
VARCHAR2
2
No
No
Active
Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
VARCHAR2
18
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
19
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
20
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
21
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
22
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31015
Table: BENSTA
BENSTA
Published / External
Completed
Benthic Station and Site Table
Loaded by batch 8234, 03-07-2016 15:12
Data Table
Yes
BENTHIC
Benthic Station and Site Table
1
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 station table.
NUMBER
2
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
3
STATION
VARCHAR2
4
No
No
Active
Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.
VARCHAR2
4
REPLICATE_NUMBER
VARCHAR2
2
No
No
Active
Grab sample replicate number. Number of replicates that were taken.
VARCHAR2
5
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
6
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
7
H_STRATUM
VARCHAR2
3
No
No
Active
Hathaway stratum code.
VARCHAR2
8
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
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
LORX
VARCHAR2
9
No
No
Active
Loran C time delay, X-Chain, only available for Sandy Hook data.
VARCHAR2
17
LORY
VARCHAR2
9
No
No
Active
Loran C time delay, Y-Chain, only available for Sandy Hook data.
VARCHAR2
18
DEPTH
NUMBER
22
No
No
4
0
Active
Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O.
NUMBER
19
BOTTEMP
NUMBER
22
No
No
6
3
Active
Bottom temperature in tenths of degrees C
NUMBER
20
SED_TYPE_CODE
VARCHAR2
2
No
No
Active
2 character Bottom/Sediment Type code. See table BENSED for sediment types.
VARCHAR2
21
SED_VOLUME
NUMBER
22
No
No
4
1
Active
Sediment volume in tenths of liters
NUMBER
22
SED_REMOVED
NUMBER
22
No
No
4
1
Active
Sediment volume removed in tenths of liters
NUMBER
23
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
24
CRC
VARCHAR2
6
No
No
Active
Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table).
VARCHAR2
25
DATA_SOURCE
VARCHAR2
2
No
No
Active
Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
VARCHAR2
26
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
27
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
28
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
29
UOC
VARCHAR2
8
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
VARCHAR2
31016
Table: BENCONV
BENCONV
Published / External
Completed
Benthic Conversion Sorting Factors Support Table (Woods Hole data only)
Loaded by batch 8235, 03-07-2016 15:27
Data Table
Yes
BENTHIC
Benthic Conversion Sorting Factors Support Table (Woods Hole data only)
1
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
2
STATION
VARCHAR2
4
No
No
Active
Station number.
VARCHAR2
3
REPLICATE_NUMBER
VARCHAR2
2
No
No
Active
Grab sample replicate number.
VARCHAR2
4
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
5
SCINAME
VARCHAR2
40
No
No
Active
Scientific name for specimen.
VARCHAR2
6
CONV
NUMBER
22
No
No
7
2
Active
Expansion conversion factor used to adjust weight and number in Benthic Catch Table (BENCAT) to 100%.
NUMBER
7
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
8
ORIGWGT
NUMBER
22
No
No
10
2
Active
Original weight.
NUMBER
9
ORIGNUM
NUMBER
22
No
No
10
0
Active
Original number.
NUMBER
10
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).
VARCHAR2
11
RECID
NUMBER
22
Yes
No
8
0
Active
Unique record identifier assigned to record.
NUMBER
12
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
13
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
14
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
15
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31017
Table: BENHSTRATUM
BENHSTRATUM
Published / External
Completed
Benthic Hathaway Stratum Codes and Description Support Table
Loaded by batch 8235, 03-07-2016 15:27
Data Table
Yes
BENTHIC
Benthic Hathaway Stratum Codes and Description Support Table
1
H_STRATUM
VARCHAR2
3
No
No
Active
Hathaway stratum code
VARCHAR2
2
H_STRATUM_DESC
VARCHAR2
50
No
No
Active
Name of Hathaway stratum area.
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
4
UOE
VARCHAR2
8
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
VARCHAR2
5
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31018
Table: BENSED
BENSED
Published / External
Completed
Benthic Sediment Codes and Description Support Table
Loaded by batch 8235, 03-07-2016 15:27
Data Table
Yes
BENTHIC
Benthic Sediment Codes and Description Support Table
1
SED_TYPE_CODE
VARCHAR2
2
No
No
Active
Bottom/Sediment Type
VARCHAR2
2
SED_TYPE
VARCHAR2
20
No
No
Active
Sediment Type Description
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
4
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
5
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31019
Table: BENSTRATUM
BENSTRATUM
Published / External
Completed
Benthic Grosslein Stratum Codes and Description Support Table
Loaded by batch 8235, 03-07-2016 15:27
Data Table
Yes
BENTHIC
Benthic Grosslein Stratum Codes and Description Support Table
1
STRATUM
VARCHAR2
2
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
2
STRATUM_DESC
VARCHAR2
50
No
No
Active
Name of stratum area.
VARCHAR2
3
SVDBS_STRATUM
VARCHAR2
5
No
No
Active
5 digit stratum from Survey table SVDBS.SVMSTRATUM from which the stratum description was taken.
VARCHAR2
4
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
7
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31020
Table: BENTXN
BENTXN
Published / External
Completed
Benthic Taxonomic Names Table (Woods Hole data only)
Loaded by batch 8235, 03-07-2016 15:27
Data Table
Yes
BENTHIC
Benthic Taxonomic Names Table (Woods Hole data only)
1
RECID
NUMBER
22
Yes
No
8
0
Active
Unique record identifier assigned to record. This record id was taken from the original benthic field TXNSORT.
NUMBER
2
SCINAME
VARCHAR2
42
No
No
Active
Scientific name for specimen.
VARCHAR2
3
NODC_CODE
VARCHAR2
12
No
No
Active
NODC code for species. (currently not available)
VARCHAR2
4
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
5
TXN_TYPE
VARCHAR2
1
No
No
Active
Taxonomic type code. 1 = Scientific name, 2 = Synonym name, 3 = Common name, 4 = Common synonym name
VARCHAR2
6
SYN
VARCHAR2
1
No
No
Active
Synonym indicator. S for synonym names, blank for scientific names.
VARCHAR2
7
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
8
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
9
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
10
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31021
Table: BENVESS
BENVESS
Published / External
Completed
Benthic Vessel Codes and Description Support Table
Loaded by batch 8235, 03-07-2016 15:27
Data Table
Yes
BENTHIC
Benthic Vessel Codes and Description Support Table
1
VESSEL_CODE
VARCHAR2
2
No
No
Active
A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data.
VARCHAR2
2
VESSEL_NAME
VARCHAR2
50
No
No
Active
Name of vessel
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
4
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
5
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31069
Table: BENCATALOG
BENCATALOG
Published / External
Completed
Benthic Species Catalog Table (Woods Hole data only)
Loaded by batch 8253, 03-08-2016 14:32
Data Table
Yes
BENTHIC
Benthic Species Catalog Table (Woods Hole data only)
1
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
2
CRUISE_ID
VARCHAR2
8
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
3
STATION
VARCHAR2
4
No
No
Active
Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.
VARCHAR2
4
REPLICATE_NUMBER
VARCHAR2
2
No
No
Active
Grab sample replicate number. Number of replicates that were taken.
VARCHAR2
5
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
6
H_STRATUM
VARCHAR2
3
No
No
Active
Hathaway stratum code.
VARCHAR2
7
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
8
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
9
SCINAME
VARCHAR2
40
No
No
Active
Scientific name for specimen.
VARCHAR2
10
NODC_CODE
VARCHAR2
12
No
No
Active
NODC code for species.
VARCHAR2
11
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
12
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
13
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
14
CONDITION
VARCHAR2
1
No
No
Active
Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data.
VARCHAR2
15
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
16
DATA_SOURCE
VARCHAR2
2
No
No
Active
Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
VARCHAR2
17
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
18
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
19
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
20
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31070
Table: BENCRUISE
BENCRUISE
Published / External
Completed
Benthic Cruise Master Table
Loaded by batch 8254, 03-08-2016 15:45
Data Table
Yes
BENTHIC
Benthic Cruise Master Table
1
CRUISE_ID
VARCHAR2
8
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
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
YEAR
VARCHAR2
4
No
No
Active
Year in which cruise was conducted.
VARCHAR2
5
START_DATE
DATE
7
No
No
Active
The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).
DATE
6
END_DATE
DATE
7
No
No
Active
The date the vessel returned to port. Date format (DD-MON-YYYY).
DATE
7
OPSID
VARCHAR2
11
No
No
Active
Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.
VARCHAR2
8
DATA_SOURCE
VARCHAR2
2
No
No
Active
Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
VARCHAR2
9
VESSEL_NUM
VARCHAR2
5
No
No
Active
The nth consecutive number of a cruise on the given vessel.
VARCHAR2
10
AREA_INVESTIGATION
VARCHAR2
200
No
No
Active
Brief description of the physical area of investigation of the cruise.
VARCHAR2
11
CHIEF_SCIENTIST
VARCHAR2
150
No
No
Active
Chief scientist for the cruise.
VARCHAR2
12
SCIENTIFIC_PARTY
VARCHAR2
1000
No
No
Active
List of names of participants on the cruise. List of names were taken from the sailing orders, not the actual cruise results.
VARCHAR2
13
PURPOSE_DESC
VARCHAR2
150
No
No
Active
Brief description of the purpose for the cruise.
VARCHAR2
14
CRUISE_COMMENTS
VARCHAR2
500
No
No
Active
Comments at the cruise level, ie: notes about any discrepancies with the cruise data, absence of station or catch records, etc.
VARCHAR2
15
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
16
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
17
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
18
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31071
Table: BENPURPOSE
BENPURPOSE
Published / External
Completed
Benthic Cruise Purpose Codes and Description Support Table
Loaded by batch 8254, 03-08-2016 15:45
Data Table
Yes
BENTHIC
Benthic Cruise Purpose Codes and Description Support Table
1
PURPOSE_CODE
VARCHAR2
3
No
No
Active
Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.
VARCHAR2
2
PURPOSE
VARCHAR2
100
No
No
Active
Cruise Purpose description.
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
4
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
5
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31072
View: BENV01
BENV01
Published / External
Completed
View of Benthic Cruise and Station Tables
Loaded by batch 8255, 03-08-2016 16:45
Data View
Yes
BENTHIC
View of Benthic Cruise and Station 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
31073
View: BENV02
BENV02
Published / External
Completed
View of Benthic Station and Catch Tables
Loaded by batch 8255, 03-08-2016 16:45
Data View
Yes
BENTHIC
View of Benthic Station and Catch Tables
1
YEAR
VARCHAR2
4
No
No
Active
Year in which cruise was conducted.
VARCHAR2
2
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
3
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
4
STATION
VARCHAR2
4
No
No
Active
Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.
VARCHAR2
5
REPLICATE_NUMBER
VARCHAR2
2
No
No
Active
Grab sample replicate number. Number of replicates that were taken.
VARCHAR2
6
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
7
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
8
H_STRATUM
VARCHAR2
3
No
No
Active
Hathaway stratum code.
VARCHAR2
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
LORX
VARCHAR2
9
No
No
Active
Loran C time delay, X-Chain, only available for Sandy Hook data.
VARCHAR2
18
LORY
VARCHAR2
9
No
No
Active
Loran C time delay, Y-Chain, only available for Sandy Hook data.
VARCHAR2
19
DEPTH
NUMBER
22
No
No
4
0
Active
Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O.
NUMBER
20
BOTTEMP
NUMBER
22
No
No
6
3
Active
Bottom temperature in tenths of degrees C
NUMBER
21
SED_TYPE_CODE
VARCHAR2
2
No
No
Active
Bottom/Sediment Type
VARCHAR2
22
SED_VOLUME
NUMBER
22
No
No
4
1
Active
Sediment volume in tenths of liters
NUMBER
23
SED_REMOVED
NUMBER
22
No
No
4
1
Active
Sediment volume removed in tenths of liters
NUMBER
24
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
25
CRC
VARCHAR2
6
No
No
Active
Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table).
VARCHAR2
26
DATA_SOURCE
VARCHAR2
2
No
No
Active
Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
VARCHAR2
27
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
28
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
29
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
30
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31
SCINAME
VARCHAR2
40
No
No
Active
Scientific name for specimen.
VARCHAR2
32
NODC_CODE
VARCHAR2
12
No
No
Active
NODC code for species.
VARCHAR2
33
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
34
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
35
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
36
CONDITION
VARCHAR2
1
No
No
Active
Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data.
VARCHAR2
37
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
31074
View: BENV03
BENV03
Published / External
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
Data Steward
2001
Person
Jones, Patricia L
patti.jones@noaa.gov
166 Water Street
Woods Hole
MA
02543-1026
USA
508-495-2116
508-295-2258
Distributor
2001
Organization
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center
NEFSC Home Page
Online Resource
8:00 a.m. to 4:30 p.m. Monday - Friday
Metadata Contact
2015
Person
Jones, Patricia L
patti.jones@noaa.gov
166 Water Street
Woods Hole
MA
02543-1026
USA
508-495-2116
508-295-2258
Originator
2001
Person
Jones, Patricia L
patti.jones@noaa.gov
166 Water Street
Woods Hole
MA
02543-1026
USA
508-495-2116
508-295-2258
Point of Contact
2019
Person
Jones, Patricia L
patti.jones@noaa.gov
166 Water Street
Woods Hole
MA
02543-1026
USA
508-495-2116
508-295-2258
-82
-49.167
49.167
24.16666666667
US east coast continental shelf, slope and upper rise ranging from the mouth of the Bay of Fundy to Key West, Florida
Range
1880
1975
The time frame for the Woods Hole data extends from 1881 to 1975; however, the majority of records are from 1953 to 1975
Range
1966
1992
The time frame for the Sandy Hook data extends from 1966 to 1992
Unclassified
NEFSC Data Access Procedure:
1. Formal request in writing usually to the data owner/contact or Center Director;
2. Requester is contacted by data owner to review and verify the request content and details for data delivery options.
3. If data is confidential then owner will determine if the data may be released to the requester;
4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online.
none
Prior to use of these records in any analysis or report, the provenance of the original data must be acknowledged. Acknowledge the use of specific records from contributing NOAA databases and acknowledge the use of the OBIS-USA facility. Recognize the limitations of data in OBIS-USA.
https://storage.googleapis.com/nmfs_odp_nefsc/PARR/DMS/25749/25749_BenthicData.zip
25749_BenthicData.zip
Compressed Zipped Folder: 25749_BenthicData
https://www1.usgs.gov/csas/obis-usa/search/?datasetid=NEFSCBenthicDatabase#
NEFSC Benthic Database (OBIS-USA) Resource ID 1694
Oracle 10g nova database
not applicable
Woods Hole Data was audited as part of a NODC Data Rescue project migrating the dataset to an Oracle database. Sandy Hook Data was merged into Oracle database as part of NODC Data Rescue.
Yes
Unknown
Yes
No
no
none
not applicable
Other
none
Scheduled backups and remote storage backups at NEFSC, archival of data set at OBIS
Interest in and studies relating to the benthic invertebrate fauna of the marine environment off the coasts of the United States formally began in a systematically organized manner with the establishment, by Spencer F. Baird, of the U.S. Fish Commission in 1871. Woods Hole, MA was chosen as the site of the first permanent laboratory in the U.S. solely devoted to the scientific study of all aspects of the marine environment. Collections and data gathered on the benthic fauna from those early days, for the most part, were distributed to many other institutions and museums through the intervening years. However, some material (specimens and data) were preserved at the Woods Hole laboratory and have been incorporated into the data base and Specimen Reference Collection. The vast majority of the Woods Hole data and specimens, however, are the result of activities conducted at the Woods Hole Laboratory, beginning in the mid 1950's, as part of studies relating to the feeding habits of commercially important demersal fishes. The perceived lack of ecologically oriented data on the composition, distribution, abundance, and ecological and environmental relationships of the benthic fauna making up the diet of these fishes led to the establishment of studies designed to provide the necessary information on those topics. When the USGS Continental Margin Program was initiated in the early 1960's in cooperation with the Woods Hole Oceanographic Institution, the Woods Hole Fisheries Lab's Benthic Dynamics Investigation, then conducting similar studies, was invited to join the effort to provide biological expertise.
The Woods Hole samples were obtained by a wide variety of means including hand collecting in the intertidal zone to the use of research vessels (17 different ones) on 208 separate cruises using 49 different types of sampling gear (ranging from dipnets to trawls, dredges, grab type devices etc.) at sea out to 4,000 meters depth.
31014
Entity
Table: BENCAT
31069
Entity
Table: BENCATALOG
31016
Entity
Table: BENCONV
31070
Entity
Table: BENCRUISE
31013
Entity
Table: BENGEAR
31017
Entity
Table: BENHSTRATUM
31071
Entity
Table: BENPURPOSE
31018
Entity
Table: BENSED
31015
Entity
Table: BENSTA
31019
Entity
Table: BENSTRATUM
31020
Entity
Table: BENTXN
31021
Entity
Table: BENVESS
31072
Entity
View: BENV01
31073
Entity
View: BENV02
31074
Entity
View: BENV03
gov.noaa.nmfs.inport:25749
Patricia Jones
2015-07-01T12:01:19
Michaael Armbruster
2023-04-10T15:00:57
2017-03-14
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
http://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