Table: BENSTA
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:31015 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Benthic Station and Site Table
DescriptionBenthic Station and Site Table
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
RECID
NUMBER |
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. |
CRUISE_ID
VARCHAR2 |
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
VARCHAR2 |
Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station. |
REPLICATE_NUMBER
VARCHAR2 |
Grab sample replicate number. Number of replicates that were taken. |
FIXED_SITE
VARCHAR2 |
Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only. |
STRATUM
VARCHAR2 |
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) |
H_STRATUM
VARCHAR2 |
Hathaway stratum code. |
GEAR_CODE
VARCHAR2 |
A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions. |
VESSEL_CODE
VARCHAR2 |
A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data. See table BENVESS for vessel code descriptions. |
SAMPLE_DATE
DATE |
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. |
SAMPLE_GMT_DATE
DATE |
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. |
ARRIVAL_DATE
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. |
ARRIVAL_GMT_DATE
DATE |
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. |
LAT
NUMBER |
Latitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute. |
LON
NUMBER |
Longitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute. |
LORX
VARCHAR2 |
Loran C time delay, X-Chain, only available for Sandy Hook data. |
LORY
VARCHAR2 |
Loran C time delay, Y-Chain, only available for Sandy Hook data. |
DEPTH
NUMBER |
Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O. |
BOTTEMP
NUMBER |
Bottom temperature in tenths of degrees C |
SED_TYPE_CODE
VARCHAR2 |
2 character Bottom/Sediment Type code. See table BENSED for sediment types. |
SED_VOLUME
NUMBER |
Sediment volume in tenths of liters |
SED_REMOVED
NUMBER |
Sediment volume removed in tenths of liters |
ORIGINAL_BENTHIC_KEY
VARCHAR2 |
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). |
CRC
VARCHAR2 |
Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table). |
DATA_SOURCE
VARCHAR2 |
Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole) |
DOE
DATE |
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). |
UOE
VARCHAR2 |
The Oracle username of the individual who entered the new record. |
DOC
DATE |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
UOC
VARCHAR2 |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: BENSTA |
---|---|
Short Name: | BENSTA |
Status: | Completed |
Abstract: |
Benthic Station and Site Table |
Notes: |
Loaded by batch 8234, 03-07-2016 15:12 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | BENTHIC |
Description: |
Benthic Station and Site Table |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
RECID | NUMBER | 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. | |
100
|
CRUISE_ID | VARCHAR2 | 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. | |
100
|
STATION | VARCHAR2 | Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station. | |
100
|
REPLICATE_NUMBER | VARCHAR2 | Grab sample replicate number. Number of replicates that were taken. | |
100
|
FIXED_SITE | VARCHAR2 | Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only. | |
100
|
STRATUM | VARCHAR2 | 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) | |
100
|
H_STRATUM | VARCHAR2 | Hathaway stratum code. | |
100
|
GEAR_CODE | VARCHAR2 | A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions. | |
100
|
VESSEL_CODE | VARCHAR2 | A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data. See table BENVESS for vessel code descriptions. | |
100
|
SAMPLE_DATE | DATE | 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. | |
100
|
SAMPLE_GMT_DATE | DATE | 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. | |
100
|
ARRIVAL_DATE | 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. | |
100
|
ARRIVAL_GMT_DATE | DATE | 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. | |
100
|
LAT | NUMBER | Latitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute. | |
100
|
LON | NUMBER | Longitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute. | |
100
|
LORX | VARCHAR2 | Loran C time delay, X-Chain, only available for Sandy Hook data. | |
100
|
LORY | VARCHAR2 | Loran C time delay, Y-Chain, only available for Sandy Hook data. | |
100
|
DEPTH | NUMBER | Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O. | |
100
|
BOTTEMP | NUMBER | Bottom temperature in tenths of degrees C | |
100
|
SED_TYPE_CODE | VARCHAR2 | 2 character Bottom/Sediment Type code. See table BENSED for sediment types. | |
100
|
SED_VOLUME | NUMBER | Sediment volume in tenths of liters | |
100
|
SED_REMOVED | NUMBER | Sediment volume removed in tenths of liters | |
100
|
ORIGINAL_BENTHIC_KEY | VARCHAR2 | 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). | |
100
|
CRC | VARCHAR2 | Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table). | |
100
|
DATA_SOURCE | VARCHAR2 | Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole) | |
100
|
DOE | DATE | Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). | |
100
|
UOE | VARCHAR2 | The Oracle username of the individual who entered the new record. | |
100
|
DOC | DATE | Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). | |
100
|
UOC | VARCHAR2 | Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
Attribute Details
RECID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
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. |
General Data Type: | NUMBER |
CRUISE_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
STATION
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station. |
General Data Type: | VARCHAR2 |
REPLICATE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Grab sample replicate number. Number of replicates that were taken. |
General Data Type: | VARCHAR2 |
FIXED_SITE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only. |
General Data Type: | VARCHAR2 |
STRATUM
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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) |
General Data Type: | VARCHAR2 |
H_STRATUM
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hathaway stratum code. |
General Data Type: | VARCHAR2 |
GEAR_CODE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions. |
General Data Type: | VARCHAR2 |
VESSEL_CODE
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data. See table BENVESS for vessel code descriptions. |
General Data Type: | VARCHAR2 |
SAMPLE_DATE
Seq. Order: | 10 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | DATE |
SAMPLE_GMT_DATE
Seq. Order: | 11 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | DATE |
ARRIVAL_DATE
Seq. Order: | 12 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | DATE |
ARRIVAL_GMT_DATE
Seq. Order: | 13 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | DATE |
LAT
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 1 |
Status: | Active |
Description: |
Latitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute. |
General Data Type: | NUMBER |
LON
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 1 |
Status: | Active |
Description: |
Longitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute. |
General Data Type: | NUMBER |
LORX
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 9 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Loran C time delay, X-Chain, only available for Sandy Hook data. |
General Data Type: | VARCHAR2 |
LORY
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 9 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Loran C time delay, Y-Chain, only available for Sandy Hook data. |
General Data Type: | VARCHAR2 |
DEPTH
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O. |
General Data Type: | NUMBER |
BOTTEMP
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 3 |
Status: | Active |
Description: |
Bottom temperature in tenths of degrees C |
General Data Type: | NUMBER |
SED_TYPE_CODE
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2 character Bottom/Sediment Type code. See table BENSED for sediment types. |
General Data Type: | VARCHAR2 |
SED_VOLUME
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Sediment volume in tenths of liters |
General Data Type: | NUMBER |
SED_REMOVED
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Sediment volume removed in tenths of liters |
General Data Type: | NUMBER |
ORIGINAL_BENTHIC_KEY
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 14 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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). |
General Data Type: | VARCHAR2 |
CRC
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table). |
General Data Type: | VARCHAR2 |
DATA_SOURCE
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole) |
General Data Type: | VARCHAR2 |
DOE
Seq. Order: | 26 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). |
General Data Type: | DATE |
UOE
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle username of the individual who entered the new record. |
General Data Type: | VARCHAR2 |
DOC
Seq. Order: | 28 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
General Data Type: | DATE |
UOC
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 31015 |
---|---|
GUID: | gov.noaa.nmfs.inport:31015 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-03-07 15:12+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-03-14 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-03-14 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-03-14 |