Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

Abstract

Rb008aa1 with latitudes, longitudes and mocness sensor data.

Description

Rb008aa1 with latitudes, longitudes and mocness sensor data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
RECORD_NUMBER
VARCHAR2
Sequential row number as data were generated.
STATION_ID
VARCHAR2
Identification code for stations that qualitatively describes the station and distance to shore. The first character is either "W" or "L" denoting is station was on the wind ward or leeward side of O'ahu. The second one or two numbers denotes the ship's distance from shore in nautical miles. The next letter is either "D' or "N" denoting if the sample was collected during the day or night. Finally, the last number indicates if the station was the first or second replicate for that particular side, distance from shore and time of day.
COORD_ID
VARCHAR2
Concatenated TRAWL_YEAR-STATION_NUMBER-TRAWL_DAY-TRAWL_MONTH.
LATITUDE_RAW_N
VARCHAR2
Latitude degrees, minutes and direction from cruise reports.
LONGITUDE_RAW_W
VARCHAR2
Longitude degrees, minutes and direction from cruise reports.
LATITUDE_RAW_DEGREES
VARCHAR2
Latitude degrees, extracted from LATITUDE_RAW_N. Units for values are degrees.
LATITUDE_RAW_MINUTES
VARCHAR2
Latitude minutes, extracted from LATITUDE_RAW_N. Units for values are minutes. Measures are reported with a precision of 3.
LATITUDE_RAW_DIRECTION
VARCHAR2
Latitude direction, extracted from LATITUDE_RAW_N.
LATITUDE_RAW_DD
NUMBER
Latitude in decimal degrees. Units for values are degrees.
LONGITUDE_RAW_DEGREES
VARCHAR2
Longitude degrees, extracted from LONGITUDE_RAW_W. Units for values are degrees.
LONGITUDE_RAW_MINUTES
VARCHAR2
Longitude minutes, extracted from LONGITUDE_RAW_W. Units for values are minutes. Measures are reported with a precision of 3.
LONGITUDE_RAW_DIRECTION
VARCHAR2
Longitude direction, extracted from LONGITUDE_RAW_W.
LONGITUDE_RAW_DD
NUMBER
Longitude IN DECIMAL DEGREES. Units for values are degrees.
TRAWL_NOTES
VARCHAR2
Trawl notes from cruise reports.
DATASET_CODE
VARCHAR2
Source ID Code assigned by the data entry staff.
VERSION_CODE
VARCHAR2
Code for the format version assigned by the data entry staff.
VESSEL_CODE
VARCHAR2
Code for the vessel.
MOC_ID2
VARCHAR2
Unique identifier for a given cast of a given tow on a given survey. Concatenated from CRUISE_NUMBER, STATION_NUMBER and MOCNESS-NET-NUMBER.
CRUISE_NUMBER
VARCHAR2
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
TRAWL_YEAR
VARCHAR2
Year of the trawl operation.
TRAWL_MONTH
VARCHAR2
Month of the trawl operation.
TRAWL_DAY
VARCHAR2
Day of the trawl operation.
STATION_NUMBER
VARCHAR2
Station number of the trawl operation.
GEAR_CODE
VARCHAR2
Code for the type of trawl.
SAMPLE_CODE_1
VARCHAR2
Code for replicate.
SAMPLE_CODE_2
VARCHAR2
Code for net number.
SAMPLE_CODE_3
VARCHAR2
Code for sample number.
LOCATION_CODE_1
VARCHAR2
Code for the bank.
LOCATION_CODE_2
VARCHAR2
Code for the direction.
LOCATION_CODE_3
VARCHAR2
Code for the distance.
LOCATION_CODE_4
VARCHAR2
Code for the time.
START_TIME
VARCHAR2
Start time of the trawl operation.
END_TIME
VARCHAR2
End time of the trawl operation.
MINIMUM_DEPTH
VARCHAR2
Minimum depth, in meters. Units for values are meters.
MAXIMUM_DEPTH
VARCHAR2
Maximum depth, in meters. Units for values are meters.
WATER_VOLUME_FILTERED
NUMBER
Water volume filtered, in tenths of a cubic meter. Units for values are cubic meters. Measures are reported with a precision of 4.
SAMPLE_VOLUME
VARCHAR2
Sample volume, in milliliters. Units for values are milliliters.
TOTAL_NUMBER_SPECIMENS
VARCHAR2
Total number of specimens.
ROW_NUMBER
VARCHAR2
A consecutive number for each entry on the data collection form.
SPECIES_CODE
VARCHAR2
Ten-digit CZM code for the species.
NUMBER_SPECIES
VARCHAR2
Number of species items in the sample.
JOB_NUMBER
VARCHAR2
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D89443.
SEQUENCE_NUMBER
VARCHAR2
A consecutive number assigned to each record for a block of data.
FROM_FILE
VARCHAR2
Name of the file that was the source of the data.
DATE_LOADED
DATE
Date when the record was loaded or updated in Oracle.
MINIMUM_SALINITY
NUMBER
Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.
MINIMUM_TEMPERATURE
NUMBER
Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 4.
MINIMUM_NET_DEPTH
NUMBER
Depth as recorded by MOCNESS sensor given in meters. Units for values are meters.
MINIMUM_VOLUME
NUMBER
Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 4.
MINIMUM_NET_ANGLE
NUMBER
Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees.
MAXIMUM_SALINITY
NUMBER
Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.
MAXIMUM_TEMPERATURE
NUMBER
Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 4.
MAXIMUM_NET_DEPTH
NUMBER
Depth as recorded by MOCNESS sensor given in meters. Units for values are meters.
MAXIMUM_VOLUME
NUMBER
Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 6.
MAXIMUM_NET_ANGLE
NUMBER
Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees.
MEAN_SALINITY
NUMBER
Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.
MEAN_TEMPERATURE
NUMBER
Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 10.
MEAN_NET_DEPTH
NUMBER
Depth as recorded by MOCNESS sensor given in meters. Units for values are meters. Measures are reported with a precision of 10.
MEAN_VOLUME
NUMBER
Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 10.
MEAN_NET_ANGLE
NUMBER
Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees. Measures are reported with a precision of 10.

Child Items

No Child Items for this record.

Contact Information

Point of Contact
Eva M Schemmel
eva.schemmel@noaa.gov

Point of Contact
Andrea Schmidt
andrea.schmidt@noaa.gov

Item Identification

Title: RB008AA1_V_LAT_LONG_MEANS_V
Short Name: RB008AA1_V_LAT_LONG_MEANS_V
Status: Completed
Abstract:

Rb008aa1 with latitudes, longitudes and mocness sensor data.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Rb008aa1 with latitudes, longitudes and mocness sensor data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
RECORD_NUMBER VARCHAR2 Sequential row number as data were generated.
100
STATION_ID VARCHAR2 Identification code for stations that qualitatively describes the station and distance to shore. The first character is either "W" or "L" denoting is station was on the wind ward or leeward side of O'ahu. The second one or two numbers denotes the ship's distance from shore in nautical miles. The next letter is either "D' or "N" denoting if the sample was collected during the day or night. Finally, the last number indicates if the station was the first or second replicate for that particular side, distance from shore and time of day.
100
COORD_ID VARCHAR2 Concatenated TRAWL_YEAR-STATION_NUMBER-TRAWL_DAY-TRAWL_MONTH.
100
LATITUDE_RAW_N VARCHAR2 Latitude degrees, minutes and direction from cruise reports.
100
LONGITUDE_RAW_W VARCHAR2 Longitude degrees, minutes and direction from cruise reports.
100
LATITUDE_RAW_DEGREES VARCHAR2 Latitude degrees, extracted from LATITUDE_RAW_N. Units for values are degrees.
100
LATITUDE_RAW_MINUTES VARCHAR2 Latitude minutes, extracted from LATITUDE_RAW_N. Units for values are minutes. Measures are reported with a precision of 3.
100
LATITUDE_RAW_DIRECTION VARCHAR2 Latitude direction, extracted from LATITUDE_RAW_N.
100
LATITUDE_RAW_DD NUMBER Latitude in decimal degrees. Units for values are degrees.
100
LONGITUDE_RAW_DEGREES VARCHAR2 Longitude degrees, extracted from LONGITUDE_RAW_W. Units for values are degrees.
100
LONGITUDE_RAW_MINUTES VARCHAR2 Longitude minutes, extracted from LONGITUDE_RAW_W. Units for values are minutes. Measures are reported with a precision of 3.
100
LONGITUDE_RAW_DIRECTION VARCHAR2 Longitude direction, extracted from LONGITUDE_RAW_W.
100
LONGITUDE_RAW_DD NUMBER Longitude IN DECIMAL DEGREES. Units for values are degrees.
100
TRAWL_NOTES VARCHAR2 Trawl notes from cruise reports.
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff.
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
VESSEL_CODE VARCHAR2 Code for the vessel.
100
MOC_ID2 VARCHAR2 Unique identifier for a given cast of a given tow on a given survey. Concatenated from CRUISE_NUMBER, STATION_NUMBER and MOCNESS-NET-NUMBER.
100
CRUISE_NUMBER VARCHAR2 Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
100
TRAWL_YEAR VARCHAR2 Year of the trawl operation.
100
TRAWL_MONTH VARCHAR2 Month of the trawl operation.
100
TRAWL_DAY VARCHAR2 Day of the trawl operation.
100
STATION_NUMBER VARCHAR2 Station number of the trawl operation.
100
GEAR_CODE VARCHAR2 Code for the type of trawl.
100
SAMPLE_CODE_1 VARCHAR2 Code for replicate.
100
SAMPLE_CODE_2 VARCHAR2 Code for net number.
100
SAMPLE_CODE_3 VARCHAR2 Code for sample number.
100
LOCATION_CODE_1 VARCHAR2 Code for the bank.
100
LOCATION_CODE_2 VARCHAR2 Code for the direction.
100
LOCATION_CODE_3 VARCHAR2 Code for the distance.
100
LOCATION_CODE_4 VARCHAR2 Code for the time.
100
START_TIME VARCHAR2 Start time of the trawl operation.
100
END_TIME VARCHAR2 End time of the trawl operation.
100
MINIMUM_DEPTH VARCHAR2 Minimum depth, in meters. Units for values are meters.
100
MAXIMUM_DEPTH VARCHAR2 Maximum depth, in meters. Units for values are meters.
100
WATER_VOLUME_FILTERED NUMBER Water volume filtered, in tenths of a cubic meter. Units for values are cubic meters. Measures are reported with a precision of 4.
100
SAMPLE_VOLUME VARCHAR2 Sample volume, in milliliters. Units for values are milliliters.
100
TOTAL_NUMBER_SPECIMENS VARCHAR2 Total number of specimens.
100
ROW_NUMBER VARCHAR2 A consecutive number for each entry on the data collection form.
100
SPECIES_CODE VARCHAR2 Ten-digit CZM code for the species.
100
NUMBER_SPECIES VARCHAR2 Number of species items in the sample.
100
JOB_NUMBER VARCHAR2 A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D89443.
100
SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.
100
FROM_FILE VARCHAR2 Name of the file that was the source of the data.
100
DATE_LOADED DATE Date when the record was loaded or updated in Oracle.
100
MINIMUM_SALINITY NUMBER Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.
100
MINIMUM_TEMPERATURE NUMBER Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 4.
100
MINIMUM_NET_DEPTH NUMBER Depth as recorded by MOCNESS sensor given in meters. Units for values are meters.
100
MINIMUM_VOLUME NUMBER Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 4.
100
MINIMUM_NET_ANGLE NUMBER Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees.
100
MAXIMUM_SALINITY NUMBER Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.
100
MAXIMUM_TEMPERATURE NUMBER Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 4.
100
MAXIMUM_NET_DEPTH NUMBER Depth as recorded by MOCNESS sensor given in meters. Units for values are meters.
100
MAXIMUM_VOLUME NUMBER Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 6.
100
MAXIMUM_NET_ANGLE NUMBER Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees.
100
MEAN_SALINITY NUMBER Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.
100
MEAN_TEMPERATURE NUMBER Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 10.
100
MEAN_NET_DEPTH NUMBER Depth as recorded by MOCNESS sensor given in meters. Units for values are meters. Measures are reported with a precision of 10.
100
MEAN_VOLUME NUMBER Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 10.
100
MEAN_NET_ANGLE NUMBER Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees. Measures are reported with a precision of 10.

Attribute Details

RECORD_NUMBER

CC ID: 1262853
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Sequential row number as data were generated.

General Data Type: VARCHAR2

STATION_ID

CC ID: 1262854
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Identification code for stations that qualitatively describes the station and distance to shore. The first character is either "W" or "L" denoting is station was on the wind ward or leeward side of O'ahu. The second one or two numbers denotes the ship's distance from shore in nautical miles. The next letter is either "D' or "N" denoting if the sample was collected during the day or night. Finally, the last number indicates if the station was the first or second replicate for that particular side, distance from shore and time of day.

General Data Type: VARCHAR2

COORD_ID

CC ID: 1262855
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 13
Required: No
Primary Key: No
Status: Active
Description:

Concatenated TRAWL_YEAR-STATION_NUMBER-TRAWL_DAY-TRAWL_MONTH.

General Data Type: VARCHAR2

LATITUDE_RAW_N

CC ID: 1262856
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees, minutes and direction from cruise reports.

General Data Type: VARCHAR2

LONGITUDE_RAW_W

CC ID: 1262857
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees, minutes and direction from cruise reports.

General Data Type: VARCHAR2

LATITUDE_RAW_DEGREES

CC ID: 1262858
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees, extracted from LATITUDE_RAW_N. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_RAW_MINUTES

CC ID: 1262859
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Latitude minutes, extracted from LATITUDE_RAW_N. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_RAW_DIRECTION

CC ID: 1262860
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude direction, extracted from LATITUDE_RAW_N.

General Data Type: VARCHAR2

LATITUDE_RAW_DD

CC ID: 1262861
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees. Units for values are degrees.

General Data Type: NUMBER
Unit of Measure: degrees

LONGITUDE_RAW_DEGREES

CC ID: 1262862
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees, extracted from LONGITUDE_RAW_W. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_RAW_MINUTES

CC ID: 1262863
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Longitude minutes, extracted from LONGITUDE_RAW_W. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_RAW_DIRECTION

CC ID: 1262864
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude direction, extracted from LONGITUDE_RAW_W.

General Data Type: VARCHAR2

LONGITUDE_RAW_DD

CC ID: 1262865
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Status: Active
Description:

Longitude IN DECIMAL DEGREES. Units for values are degrees.

General Data Type: NUMBER
Unit of Measure: degrees

TRAWL_NOTES

CC ID: 1262866
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Trawl notes from cruise reports.

General Data Type: VARCHAR2

DATASET_CODE

CC ID: 1262867
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff.

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 1262868
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the format version assigned by the data entry staff.

General Data Type: VARCHAR2

VESSEL_CODE

CC ID: 1262869
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.

General Data Type: VARCHAR2

MOC_ID2

CC ID: 1262870
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for a given cast of a given tow on a given survey. Concatenated from CRUISE_NUMBER, STATION_NUMBER and MOCNESS-NET-NUMBER.

General Data Type: VARCHAR2

CRUISE_NUMBER

CC ID: 1262871
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.

General Data Type: VARCHAR2

TRAWL_YEAR

CC ID: 1262872
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year of the trawl operation.

General Data Type: VARCHAR2

TRAWL_MONTH

CC ID: 1262873
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month of the trawl operation.

General Data Type: VARCHAR2

TRAWL_DAY

CC ID: 1262874
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of the trawl operation.

General Data Type: VARCHAR2

STATION_NUMBER

CC ID: 1262875
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of the trawl operation.

General Data Type: VARCHAR2

GEAR_CODE

CC ID: 1262876
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for the type of trawl.

General Data Type: VARCHAR2

SAMPLE_CODE_1

CC ID: 1262877
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for replicate.

General Data Type: VARCHAR2

SAMPLE_CODE_2

CC ID: 1262878
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for net number.

General Data Type: VARCHAR2

SAMPLE_CODE_3

CC ID: 1262879
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for sample number.

General Data Type: VARCHAR2

LOCATION_CODE_1

CC ID: 1262880
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the bank.

General Data Type: VARCHAR2

LOCATION_CODE_2

CC ID: 1262881
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the direction.

General Data Type: VARCHAR2

LOCATION_CODE_3

CC ID: 1262882
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the distance.

General Data Type: VARCHAR2

LOCATION_CODE_4

CC ID: 1262883
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the time.

General Data Type: VARCHAR2

START_TIME

CC ID: 1262884
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Start time of the trawl operation.

General Data Type: VARCHAR2

END_TIME

CC ID: 1262885
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

End time of the trawl operation.

General Data Type: VARCHAR2

MINIMUM_DEPTH

CC ID: 1262886
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Minimum depth, in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

MAXIMUM_DEPTH

CC ID: 1262887
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth, in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

WATER_VOLUME_FILTERED

CC ID: 1262888
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Water volume filtered, in tenths of a cubic meter. Units for values are cubic meters. Measures are reported with a precision of 4.

General Data Type: NUMBER
Unit of Measure: cubic meters

SAMPLE_VOLUME

CC ID: 1262889
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Sample volume, in milliliters. Units for values are milliliters.

General Data Type: VARCHAR2
Unit of Measure: milliliters

TOTAL_NUMBER_SPECIMENS

CC ID: 1262890
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Total number of specimens.

General Data Type: VARCHAR2

ROW_NUMBER

CC ID: 1262891
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number for each entry on the data collection form.

General Data Type: VARCHAR2

SPECIES_CODE

CC ID: 1262892
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Ten-digit CZM code for the species.

General Data Type: VARCHAR2

NUMBER_SPECIES

CC ID: 1262893
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of species items in the sample.

General Data Type: VARCHAR2

JOB_NUMBER

CC ID: 1262894
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D89443.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1262895
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned to each record for a block of data.

General Data Type: VARCHAR2

FROM_FILE

CC ID: 1262896
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Name of the file that was the source of the data.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 1262897
Seq. Order: 45
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded or updated in Oracle.

General Data Type: DATE

MINIMUM_SALINITY

CC ID: 1262898
Seq. Order: 46
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: PSU

MINIMUM_TEMPERATURE

CC ID: 1262899
Seq. Order: 47
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 4.

General Data Type: NUMBER
Unit of Measure: degrees Celcius

MINIMUM_NET_DEPTH

CC ID: 1262900
Seq. Order: 48
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth as recorded by MOCNESS sensor given in meters. Units for values are meters.

General Data Type: NUMBER
Unit of Measure: meters

MINIMUM_VOLUME

CC ID: 1262901
Seq. Order: 49
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 4.

General Data Type: NUMBER
Unit of Measure: cubic meters

MINIMUM_NET_ANGLE

CC ID: 1262902
Seq. Order: 50
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees.

General Data Type: NUMBER
Unit of Measure: degrees

MAXIMUM_SALINITY

CC ID: 1262903
Seq. Order: 51
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: PSU

MAXIMUM_TEMPERATURE

CC ID: 1262904
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 4.

General Data Type: NUMBER
Unit of Measure: degrees Celcius

MAXIMUM_NET_DEPTH

CC ID: 1262905
Seq. Order: 53
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth as recorded by MOCNESS sensor given in meters. Units for values are meters.

General Data Type: NUMBER
Unit of Measure: meters

MAXIMUM_VOLUME

CC ID: 1262906
Seq. Order: 54
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 6.

General Data Type: NUMBER
Unit of Measure: cubic meters

MAXIMUM_NET_ANGLE

CC ID: 1262907
Seq. Order: 55
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees.

General Data Type: NUMBER
Unit of Measure: degrees

MEAN_SALINITY

CC ID: 1262908
Seq. Order: 56
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Salinity as recorded by MOCNESS sensor given in PSU, or in the case of values for TC8504, corrected: Salinity with correction factor of subtracted from all og_sal values. ALS took summarized salinity values from the upper 100m of the water column from the CTD and subtracted them from the average salinity value of all the TC8504 MOCNESS flights. This value was 6.323265288 and it was then subtracted from every salinity value in the TC 8504 MOCNESS readouts. Units for values are PSU. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: PSU

MEAN_TEMPERATURE

CC ID: 1262909
Seq. Order: 57
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Temperaure as recorded by MOCNESS sensor given in degrees Celcius. Units for values are degrees Celcius. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: degrees Celcius

MEAN_NET_DEPTH

CC ID: 1262910
Seq. Order: 58
Data Storage Type: NUMBER
Max Length: 12
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Depth as recorded by MOCNESS sensor given in meters. Units for values are meters. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: meters

MEAN_VOLUME

CC ID: 1262911
Seq. Order: 59
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 7
Status: Active
Description:

Volume of water filtered as recorded by MOCNESS sensor given in cubic meters. Units for values are cubic meters. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: cubic meters

MEAN_NET_ANGLE

CC ID: 1262912
Seq. Order: 60
Data Storage Type: NUMBER
Max Length: 11
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Net angle as measured by MOCNESS sensor given in degrees. Units for values are degrees. Measures are reported with a precision of 10.

General Data Type: NUMBER
Unit of Measure: degrees

Support Roles

Data Set Credit

CC ID: 1268664
Date Effective From: 2023-03
Date Effective To:
Contact (Person): Schmidt, Andrea
Email Address: andrea.schmidt@noaa.gov
Contact Instructions:

Contact via email.

Point of Contact

CC ID: 1268666
Date Effective From: 2023-08
Date Effective To:
Contact (Person): Schemmel, Eva M
Email Address: eva.schemmel@noaa.gov
Contact Instructions:

Contact via email.

Point of Contact

CC ID: 1268665
Date Effective From: 2023-03
Date Effective To:
Contact (Person): Schmidt, Andrea
Email Address: andrea.schmidt@noaa.gov
Contact Instructions:

Contact via email.

Catalog Details

Catalog Item ID: 70166
GUID: gov.noaa.nmfs.inport:70166
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2023-06-14 19:53+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2023-08-25 21:54+0000
Metadata Record Published: 2023-07-24
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2023-07-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2024-07-24