RB008AA1_V_LAT_LONG_MEANS_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:70166 | Updated: August 25, 2023 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Rb008aa1 with latitudes, longitudes and mocness sensor data.
DescriptionRb008aa1 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |