Slide Menu
Search Help Show/Hide Menu

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