Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Insular Metadata Portfolio > Trawl station information of eight NOAA R/V Tow... >

RI008AA1_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:52399  |  Updated: February 15, 2024  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Trawl station information for 8 NOAA R/V Townsend Cromwell cruises.

Description

Trawl station information for 8 NOAA R/V Townsend Cromwell cruises.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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. Coded as 'TC' on collection form, converted to '001'.
CRUISE_NUMBER
VARCHAR2 		Two-digit incremental number of the cruise, expanded to 4 digits, 33 = 0033.
STATION_NUMBER
VARCHAR2 		Station number of the activity.
YEAR
VARCHAR2 		Year of the activity.
MONTH
VARCHAR2 		Month of the activity.
DAY
VARCHAR2 		Day of the activity.
START_LATITUDE_DEGREES
VARCHAR2 		Start latitude degrees of the activity, in degrees. Units for values are degrees.
START_LATITUDE_MINUTES
VARCHAR2 		Start latitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
START_LATITUDE_DIRECTION
VARCHAR2 		Start latitude direction of the activity.
START_LATITUDE_DD
NUMBER 		Computed start latitude, in decimal degrees, of the trawl operation. Postive values are North latitudes; negative values are South latitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
START_LONGITUDE_DEGREES
VARCHAR2 		Start longitude degrees of the activity, in degrees. Units for values are degrees.
START_LONGITUDE_MINUTES
VARCHAR2 		Start longitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
START_LONGITUDE_DIRECTION
VARCHAR2 		Start longitude direction of the activity.
START_LONGITUDE_DD
NUMBER 		Computed start longitude, in decimal degrees, of the activity. Positive values are East longitudes; negative values are West longitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
END_LATITUDE_DEGREES
VARCHAR2 		End latitude degrees of the activity, in degrees. Units for values are degrees.
END_LATITUDE_MINUTES
VARCHAR2 		End latitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
END_LATITUDE_DIRECTION
VARCHAR2 		End latitude direction of the activity.
END_LATITUDE_DD
NUMBER 		Computed end latitude, in decimal degrees, of the activity. Positive values are North latitudes; negative values are South latitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
END_LONGITUDE_DEGREES
VARCHAR2 		End longitude degrees of the activity. Units for values are degrees.
END_LONGITUDE_MINUTES
VARCHAR2 		End longitude minutes of the activity. Units for values are minutes. Measures are reported with a precision of 3.
END_LONGITUDE_DIRECTION
VARCHAR2 		End longitude direction of the activity.
END_LONGITUDE_DD
NUMBER 		Computed end longitude, in decimal degrees, of the activity. Positive values are East longitudes; negative values are West longitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
GEAR
VARCHAR2 		Abbreviated name of gear used for the activity.
DOG_OFF_TIME
VARCHAR2 		Tow start time (see Struhsaker and Yoshida shrimp trawl paper).
HAUL_BACK_TIME
VARCHAR2 		Tow end time at begin haul-back time (see Struhsaker and Yoshida shrimp trawl paper).
MEDIAN_TIME
VARCHAR2 		Median time of the activity.
HOURS_FISHED
VARCHAR2 		Hours fished, in tenths of an hour. Units for values are hours. Measures are reported with a precision of 2.
DISTANCE_FISHED
VARCHAR2 		Distance fished, in tenths of a nautical mile. Units for values are nautical miles. Measures are reported with a precision of 2.
TOW_SPEED
VARCHAR2 		Tow speed, in tenths of a knot. Units for values are knots. Measures are reported with a precision of 3.
AREA_SAMPLED
VARCHAR2 		Area sampled, in tenths of a hectare. Units for values are hectares.
STATION_MINIMUM_DEPTH
VARCHAR2 		Minimum depth of station, in meters. Units for values are meters.
STATION_MAXIMUM_DEPTH
VARCHAR2 		Maximum depth of station, in meters. Units for values are meters.
MEAN_DEPTH
VARCHAR2 		Mean depth of station, in meters. Units for values are meters.
WIRE_OUT
VARCHAR2 		Wire out, in meters. Units for values are meters.
BOTTOM_TEMPERATURE
VARCHAR2 		Bottom temperature, in tenths of degree Celsius. Units for values are degrees Celsius. Measures are reported with a precision of 3.
GENERAL_LOCALITY
VARCHAR2 		Abbreviated locality name where the activity took place.
NUMBER_REMARKS
VARCHAR2 		Number of remarks on the Trawling Log.
SEQUENCE_NUMBER
VARCHAR2 		A consecutive number assigned to each record for a block of data.
DATE_LOADED
DATE 		Date when the record was loaded into Oracle or updated.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: RI008AA1_V
Short Name: RI008AA1_V
Status: Completed
Abstract:

Trawl station information for 8 NOAA R/V Townsend Cromwell cruises.

Entity Information

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

Trawl station information for 8 NOAA R/V Townsend Cromwell cruises.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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. Coded as 'TC' on collection form, converted to '001'.
100
 CRUISE_NUMBER VARCHAR2 Two-digit incremental number of the cruise, expanded to 4 digits, 33 = 0033.
100
 STATION_NUMBER VARCHAR2 Station number of the activity.
100
 YEAR VARCHAR2 Year of the activity.
100
 MONTH VARCHAR2 Month of the activity.
100
 DAY VARCHAR2 Day of the activity.
100
 START_LATITUDE_DEGREES VARCHAR2 Start latitude degrees of the activity, in degrees. Units for values are degrees.
100
 START_LATITUDE_MINUTES VARCHAR2 Start latitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
100
 START_LATITUDE_DIRECTION VARCHAR2 Start latitude direction of the activity.
100
 START_LATITUDE_DD NUMBER Computed start latitude, in decimal degrees, of the trawl operation. Postive values are North latitudes; negative values are South latitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
100
 START_LONGITUDE_DEGREES VARCHAR2 Start longitude degrees of the activity, in degrees. Units for values are degrees.
100
 START_LONGITUDE_MINUTES VARCHAR2 Start longitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
100
 START_LONGITUDE_DIRECTION VARCHAR2 Start longitude direction of the activity.
100
 START_LONGITUDE_DD NUMBER Computed start longitude, in decimal degrees, of the activity. Positive values are East longitudes; negative values are West longitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
100
 END_LATITUDE_DEGREES VARCHAR2 End latitude degrees of the activity, in degrees. Units for values are degrees.
100
 END_LATITUDE_MINUTES VARCHAR2 End latitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
100
 END_LATITUDE_DIRECTION VARCHAR2 End latitude direction of the activity.
100
 END_LATITUDE_DD NUMBER Computed end latitude, in decimal degrees, of the activity. Positive values are North latitudes; negative values are South latitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
100
 END_LONGITUDE_DEGREES VARCHAR2 End longitude degrees of the activity. Units for values are degrees.
100
 END_LONGITUDE_MINUTES VARCHAR2 End longitude minutes of the activity. Units for values are minutes. Measures are reported with a precision of 3.
100
 END_LONGITUDE_DIRECTION VARCHAR2 End longitude direction of the activity.
100
 END_LONGITUDE_DD NUMBER Computed end longitude, in decimal degrees, of the activity. Positive values are East longitudes; negative values are West longitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
100
 GEAR VARCHAR2 Abbreviated name of gear used for the activity.
100
 DOG_OFF_TIME VARCHAR2 Tow start time (see Struhsaker and Yoshida shrimp trawl paper).
100
 HAUL_BACK_TIME VARCHAR2 Tow end time at begin haul-back time (see Struhsaker and Yoshida shrimp trawl paper).
100
 MEDIAN_TIME VARCHAR2 Median time of the activity.
100
 HOURS_FISHED VARCHAR2 Hours fished, in tenths of an hour. Units for values are hours. Measures are reported with a precision of 2.
100
 DISTANCE_FISHED VARCHAR2 Distance fished, in tenths of a nautical mile. Units for values are nautical miles. Measures are reported with a precision of 2.
100
 TOW_SPEED VARCHAR2 Tow speed, in tenths of a knot. Units for values are knots. Measures are reported with a precision of 3.
100
 AREA_SAMPLED VARCHAR2 Area sampled, in tenths of a hectare. Units for values are hectares.
100
 STATION_MINIMUM_DEPTH VARCHAR2 Minimum depth of station, in meters. Units for values are meters.
100
 STATION_MAXIMUM_DEPTH VARCHAR2 Maximum depth of station, in meters. Units for values are meters.
100
 MEAN_DEPTH VARCHAR2 Mean depth of station, in meters. Units for values are meters.
100
 WIRE_OUT VARCHAR2 Wire out, in meters. Units for values are meters.
100
 BOTTOM_TEMPERATURE VARCHAR2 Bottom temperature, in tenths of degree Celsius. Units for values are degrees Celsius. Measures are reported with a precision of 3.
100
 GENERAL_LOCALITY VARCHAR2 Abbreviated locality name where the activity took place.
100
 NUMBER_REMARKS VARCHAR2 Number of remarks on the Trawling Log.
100
 SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.
100
 DATE_LOADED DATE Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

CC ID: 1285648
Seq. Order: 1
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: 1285649
Seq. Order: 2
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: 1285650
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel. Coded as 'TC' on collection form, converted to '001'.
General Data Type: VARCHAR2
Allowed Values: 001 = NOAA R/V TOWNSEND CROMWELL

CRUISE_NUMBER

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

Two-digit incremental number of the cruise, expanded to 4 digits, 33 = 0033.
General Data Type: VARCHAR2

STATION_NUMBER

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

Station number of the activity.
General Data Type: VARCHAR2

YEAR

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

Year of the activity.
General Data Type: VARCHAR2

MONTH

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

Month of the activity.
General Data Type: VARCHAR2

DAY

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

Day of the activity.
General Data Type: VARCHAR2

START_LATITUDE_DEGREES

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

Start latitude degrees of the activity, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

START_LATITUDE_MINUTES

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

Start latitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: minutes

START_LATITUDE_DIRECTION

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

Start latitude direction of the activity.
General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

START_LATITUDE_DD

CC ID: 1285659
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 16
Required: No
Primary Key: No
Scale: 13
Status: Active
Description:

Computed start latitude, in decimal degrees, of the trawl operation. Postive values are North latitudes; negative values are South latitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
General Data Type: NUMBER
Unit of Measure: decimal degrees

START_LONGITUDE_DEGREES

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

Start longitude degrees of the activity, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

START_LONGITUDE_MINUTES

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

Start longitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: minutes

START_LONGITUDE_DIRECTION

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

Start longitude direction of the activity.
General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

START_LONGITUDE_DD

CC ID: 1285663
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 17
Required: No
Primary Key: No
Scale: 12
Status: Active
Description:

Computed start longitude, in decimal degrees, of the activity. Positive values are East longitudes; negative values are West longitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
General Data Type: NUMBER
Unit of Measure: decimal degrees

END_LATITUDE_DEGREES

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

End latitude degrees of the activity, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

END_LATITUDE_MINUTES

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

End latitude minutes of the activity, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: minutes

END_LATITUDE_DIRECTION

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

End latitude direction of the activity.
General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

END_LATITUDE_DD

CC ID: 1285667
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 16
Required: No
Primary Key: No
Scale: 13
Status: Active
Description:

Computed end latitude, in decimal degrees, of the activity. Positive values are North latitudes; negative values are South latitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
General Data Type: NUMBER
Unit of Measure: decimal degrees

END_LONGITUDE_DEGREES

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

End longitude degrees of the activity. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

END_LONGITUDE_MINUTES

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

End longitude minutes of the activity. Units for values are minutes. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: minutes

END_LONGITUDE_DIRECTION

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

End longitude direction of the activity.
General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

END_LONGITUDE_DD

CC ID: 1285671
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 17
Required: No
Primary Key: No
Scale: 12
Status: Active
Description:

Computed end longitude, in decimal degrees, of the activity. Positive values are East longitudes; negative values are West longitudes. Units for values are decimal degrees. Measures are reported with a precision of 15.
General Data Type: NUMBER
Unit of Measure: decimal degrees

GEAR

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

Abbreviated name of gear used for the activity.
General Data Type: VARCHAR2
Allowed Values: 09 ST = MINI SHRIMP TRAWL, SMALL TRY NET FABRICATED BY R/V TOWNSEND CROMWELL'S MILLER-KAMAUU; 1-M = 1-METER PLANKTON NET SURFACE TOW; 22 ST = 22-FOOT GULF-TYPE FLAT SHRIMP TRAP; 27 ST = 27-FOOT GULF-TYPE FLAT SHRIMP TRAP; 40 ST = 40-FOOT GULF-TYPE FLAT SHRIMP TRAP; 41 ST = 41-FOOT GULF-TYPE FLAT SHRIMP TRAP, 41-FOOT SEMI-BALLOON SHRIMP TRAWL; 43 ST = 43-FOOT GULF-TYPE FLAT SHRIMP TRAP; 50 ST = 50-FOOT SHRIMP TRAWL; 55 ST = 55-FOOT GULF-TYPE FLAT SHRIMP TRAWL; 6 IK = 6-FOOT ISAACS-KIDD MIDWATER TRAWL; 60 ST = 60-FOOT SHRIMP TRAWL; 63 NT = 63-FOOT NORWEGIAN TRAWL; 66 NT = 66-FOOT NORWEGIAN TRAWL; 70 FT = 400-MESH EASTERN-TYPE OTTER FISH TRAWL; 70 ST = 70-FOOT GULF OF MEXICO-TYPE SEMI-BALLOON SHRIMP TRAWL; BENLL = BENTHIC LONGLINE; BLINE = BOTTOM LONGLINE; DREG = DREDGE; FSTRP = FISH-SHRIMP TRAP; FTRAP = FISH TRAP; GILL =GILL NET; HDNLI = HANDLINE; KAKA = KAKA LINE; LTRAP = LOBSTER TRAP; NITE = NIGHT LIGHT FISHING; PSLED = PLANKTON SLED; S POT = SHRIMP-CRAB POT; S-POT = SHRIMP POT; SHARK = SHARK LINE; STRAP = SHRIMP TRAP; TTRAP = TENT TRAP

DOG_OFF_TIME

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

Tow start time (see Struhsaker and Yoshida shrimp trawl paper).
General Data Type: VARCHAR2

HAUL_BACK_TIME

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

Tow end time at begin haul-back time (see Struhsaker and Yoshida shrimp trawl paper).
General Data Type: VARCHAR2

MEDIAN_TIME

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

Median time of the activity.
General Data Type: VARCHAR2

HOURS_FISHED

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

Hours fished, in tenths of an hour. Units for values are hours. Measures are reported with a precision of 2.
General Data Type: VARCHAR2
Unit of Measure: hours

DISTANCE_FISHED

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

Distance fished, in tenths of a nautical mile. Units for values are nautical miles. Measures are reported with a precision of 2.
General Data Type: VARCHAR2
Unit of Measure: nautical miles

TOW_SPEED

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

Tow speed, in tenths of a knot. Units for values are knots. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: knots

AREA_SAMPLED

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

Area sampled, in tenths of a hectare. Units for values are hectares.
General Data Type: VARCHAR2
Unit of Measure: hectares

STATION_MINIMUM_DEPTH

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

Minimum depth of station, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

STATION_MAXIMUM_DEPTH

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

Maximum depth of station, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

MEAN_DEPTH

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

Mean depth of station, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

WIRE_OUT

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

Wire out, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

BOTTOM_TEMPERATURE

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

Bottom temperature, in tenths of degree Celsius. Units for values are degrees Celsius. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: degrees Celsius

GENERAL_LOCALITY

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

Abbreviated locality name where the activity took place.
General Data Type: VARCHAR2
Allowed Values: GARNDE = GARDNER PINNACLES; HALE = HALEIWA; HAMAKU = HAMAKUA COAST; KAIWI = KAIWI CHANNEL; KALOHI = KALOHI CHANNEL; KAWAIH = KAWAIHAE; KEA-CH = KEALAIKAHIKI CHANNEL; KEA.CH = KEALAIKAHIKI CHANNEL; KONA = KONA; KURE = KURE ATOLL; LAYSAN = LAYSAN ISLAND; LISIAN = LISIANSKI; MAUI = MAUI; MIDDLE = MIDDLE BANK; MIDH20 = UNKNOWN; MOLO = MOLOKAI; N.MAUI = NORTH MAUI; N.MOLO = NORTH MOLOKAI; NECKER = NECKER ISLAND; NIHOA = NIHOA; P-MAUI = PAILOLO CHANNEL, CLOSER TO MAUI; P-MOLO = PAILOLO CHANNEL, CLOSER TO MOLOKAI; P.BANK = PENGUIN BANK; P.MOLO = PAILOLO CHANNEL, CLOSER TO MOLOKAI; PAI-CH = PAILOLO CHANNEL; PAI-MC = PAILOLO CHANNEL, MIDCHANNEL; PEARL = PEARL AND HERMES ATOLL; PEN.BK = PENGUIN BANK; ST.ROG = ST. ROGATIEN BANK; W.NIHO = WEST NIHOA; W.OAHU = WEST OAHU; WAINAE = WAIANAE

NUMBER_REMARKS

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

Number of remarks on the Trawling Log.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1285687
Seq. Order: 40
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

DATE_LOADED

CC ID: 1285688
Seq. Order: 41
Data Storage Type: DATE
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle or updated.
General Data Type: DATE

Catalog Details

Catalog Item ID: 52399
GUID: gov.noaa.nmfs.inport:52399
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2018-04-17 22:31+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2024-02-15 03:36+0000
Metadata Record Published: 2023-12-16
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2023-12-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2024-12-16