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 Character Source ID Code assigned by the data entry staff.
100
VERSION_CODE Character Code for the format version assigned by the data entry staff.
100
VESSEL_CODE Number Code for the vessel. Coded as TC on collection form, converted to '001'.
100
CRUISE_NUMBER Number Two-digit incremental number of the cruise for the year, expanded to 4 digits.
100
STATION_NUMBER Number Station number of trawl operation.
100
TRAWL_YEAR Number Year of trawl operatiom.
100
TRAWL_MONTH Number Month of trawl operation.
100
TRAWL_DAY Number Day of trawl operation.
100
START_LATITUDE_DEGREES Number Start latitude degrees of trawl operation, in degrees. Units for values are degrees.
100
START_LATITUDE_MINUTES Number Start latitude minutes of trawl operation, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
100
START_LATITUDE_DIRECTION Character Start latitude direction of trawl operation.
100
START_LATITUDE_DD Number Start latitude of trawl operation, in decimal degrees. North latitude values are positive. South latitude values are negative. Units for values are decimal degrees. Measures are reported with a precision of 15.
100
START_LONGITUDE_DEGREES Number Start longitude degrees of trawl operation, in degrees. Units for values are degrees.
100
START_LONGITUDE_MINUTES Number Start longitude minutes of trawl operation, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
100
START_LONGITUDE_DIRECTION Character Start longitude direction of trawl operation.
100
START_LONGITUDE_DD Number Start longitude of trawl operation, in decimal degrees. East longitude values are positive. West longitude values are negative. Units for values are decimal degrees. Measures are reported with a precision of 15.
100
END_LATITUDE_DEGREES Number End latitude degrees of trawl operation, in degrees. Units for values are degrees.
100
END_LATITUDE_MINUTES Number End latitude minutes of trawl operation, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.
100
END_LATITUDE_DIRECTION Character End latitude direction of trawl operation.
100
END_LATITUDE_DD Number End latitude of trawl operation, in decimal degrees. North latitude values are positive. South latitude values are negative. Units for values are decimal degrees. Measures are reported with a precision of 15.
100
END_LONGITUDE_DEGREES Number End longitude degrees of trawl operation. Units for values are degrees.
100
END_LONGITUDE_MINUTES Number End longitude minutes of trawl operation. Units for values are minutes. Measures are reported with a precision of 3.
100
END_LONGITUDE_DIRECTION Character End longitude direction of trawl operation.
100
END_LONGITUDE_DD Number End longitude of trawl operation, in decimal degrees. East longitude values are positive. West longitude values are negative. Units for values are decimal degrees. Measures are reported with a precision of 15.
100
GEAR Character Abbreviated name of gear used for trawl operation.
100
DOG_OFF_TIME Number Tow start time.
100
HAUL_BACK_TIME Number Tow end time at begin haul-back time.
100
MEDIAN_TIME Number Median time of trawl operation.
100
HOURS_FISHED Number Hours fished, in tenths of an hour. Leading zero was not entered for cruises TC 33, TC 35, TC 36 and TC40 but is now entered in this database. Units for values are hours. Measures are reported with a precision of 2.
100
DISTANCE_FISHED Number 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 Number Tow speed, in tenths of a knot. Units for values are knots. Measures are reported with a precision of 3.
100
AREA_SAMPLED Number Area sampled, in tenths of a hectare. Leading zero was not entered for cruises TC 33, TC 35, TC 36 and TC40 but is now entered in this database. Units for values are hectares.
100
STATION_MINIMUM_DEPTH Number Minimum depth of station, in meters. Units for values are meters.
100
STATION_MAXIMUM_DEPTH Number Maximum depth of station, in meters. Units for values are meters.
100
MEAN_DEPTH Number Mean depth of station, in meters. Leading zeros were not entered for cruises TC 33, TC 35, TC 36 and TC40 but are now entered in this database. Units for values are meters.
100
WIRE_OUT Number Wire out, in meters. Leading zero was not entered for cruises TC 33, TC 35, TC 36 and TC40 but is now entered in this database. Units for values are meters.
100
BOTTOM_TEMPERATURE Number Bottom temperature, in tenths of degree Celsius. Units for values are degrees Celsius. Measures are reported with a precision of 3.
100
GENERAL_LOCALITY Character Abbreviated locality name of trawl operation.
100
NUMBER_REMARKS Number Number of remarks on Trawling Log. Leading zero was not entered for cruises TC 33, TC 35, TC 36 and TC40 but is now entered in this database.
100
SEQUENCE_NUMBER Number A consecutive number assigned to each record for a block of data.
100
FROM_FILE Character Name of the flat ASCII file that was the source of the data.
100
DATE_LOADED Date Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

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

Source ID Code assigned by the data entry staff.

General Data Type: Character

VERSION_CODE

CC ID: 751439
Seq. Order: 2
Data Storage Type: Character
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: Character

VESSEL_CODE

CC ID: 751440
Seq. Order: 3
Data Storage Type: Number
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: Number
Allowed Values: 001 = NOAA R/V TOWNSEND CROMWELL

CRUISE_NUMBER

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

Two-digit incremental number of the cruise for the year, expanded to 4 digits.

General Data Type: Number

STATION_NUMBER

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

Station number of trawl operation.

General Data Type: Number

TRAWL_YEAR

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

Year of trawl operatiom.

General Data Type: Number

TRAWL_MONTH

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

Month of trawl operation.

General Data Type: Number

TRAWL_DAY

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

Day of trawl operation.

General Data Type: Number

START_LATITUDE_DEGREES

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

Start latitude degrees of trawl operation, in degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

START_LATITUDE_MINUTES

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

Start latitude minutes of trawl operation, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: Number
Unit of Measure: minutes

START_LATITUDE_DIRECTION

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

Start latitude direction of trawl operation.

General Data Type: Character
Allowed Values: N = NORTH S = SOUTH

START_LATITUDE_DD

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

Start latitude of trawl operation, in decimal degrees. North latitude values are positive. South latitude values are negative. 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: 751450
Seq. Order: 13
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Start longitude degrees of trawl operation, in degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

START_LONGITUDE_MINUTES

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

Start longitude minutes of trawl operation, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: Number
Unit of Measure: minutes

START_LONGITUDE_DIRECTION

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

Start longitude direction of trawl operation.

General Data Type: Character
Allowed Values: E = EAST W = WEST

START_LONGITUDE_DD

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

Start longitude of trawl operation, in decimal degrees. East longitude values are positive. West longitude values are negative. 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: 751454
Seq. Order: 17
Data Storage Type: Number
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

End latitude degrees of trawl operation, in degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

END_LATITUDE_MINUTES

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

End latitude minutes of trawl operation, in tenths of a minute. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: Number
Unit of Measure: minutes

END_LATITUDE_DIRECTION

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

End latitude direction of trawl operation.

General Data Type: Character
Allowed Values: N = NORTH S = SOUTH

END_LATITUDE_DD

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

End latitude of trawl operation, in decimal degrees. North latitude values are positive. South latitude values are negative. 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: 751458
Seq. Order: 21
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

End longitude degrees of trawl operation. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

END_LONGITUDE_MINUTES

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

End longitude minutes of trawl operation. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: Number
Unit of Measure: minutes

END_LONGITUDE_DIRECTION

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

End longitude direction of trawl operation.

General Data Type: Character
Allowed Values: E = EAST W = WEST

END_LONGITUDE_DD

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

End longitude of trawl operation, in decimal degrees. East longitude values are positive. West longitude values are negative. 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: 751462
Seq. Order: 25
Data Storage Type: Character
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Abbreviated name of gear used for trawl operation.

General Data Type: Character
Allowed Values: 09 ST = MINI TRAWL, SMALL TRI-NET FABRICATED BY R/V TOWNSEND CROMWELL MILLER-KAMAUU 1-M = 1-METER PLANKTON NET SURFACE TOW 22 ST = 22-FOOT GULF-TYPE FLAT SHRIMP TRAP; MILLER-KAMAUU MINI_TRAWL 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 MARINOVICH SHRIMP TRAWL 43 ST = 43-FOOT GULF-TYPE FLAT SHRIMP TRAP 55 ST = 55-FOOT GULF-TYPE FLAT SHRIMP TRAP; 55-FOOT STRUHSAKER FLAT SHRIMP TRAWL 6 IK = 6-FOOT ISAACS-KIDD MIDWATER TRAWL 60 ST = 60-FOOT SHRIMP TRAWL 66 NT = 66/83 OR 66/86 NORWEGIAN TRAWL 70 FT = 70-FOOT FISH TRAWL; 400-MESH EASTERN TYPE OTTER TRAWL 70 ST = 70-FOOT GULF OF MEXICO-TYPE SEMI-BALLOON SHRIMP TRAWL BENLL = BENTHIC LONGLINE BLINE = BOTTOM LONGLINE DREG = DREDGE (TUMBLER) FSTRP = UNKNOWN FTRAP = FISH TRAP GILL =GILL NET HDNLI = HANDLINE KAKA = KAKA LINE LTRAP = LOBSTER TRAP NITE = NIGHT LIGHT PSLED = PLANKTON SLED S POT = UNKNOWN S-POT = SHRIMP POT SHARK = UNKNOWN STRAP = SHRIMP TRAP TTRAP = UNKNOWN

DOG_OFF_TIME

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

Tow start time.

General Data Type: Number

HAUL_BACK_TIME

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

Tow end time at begin haul-back time.

General Data Type: Number

MEDIAN_TIME

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

Median time of trawl operation.

General Data Type: Number

HOURS_FISHED

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

Hours fished, in tenths of an hour. Leading zero was not entered for cruises TC 33, TC 35, TC 36 and TC40 but is now entered in this database. Units for values are hours. Measures are reported with a precision of 2.

General Data Type: Number
Unit of Measure: hours

DISTANCE_FISHED

CC ID: 751467
Seq. Order: 30
Data Storage Type: Number
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: Number
Unit of Measure: nautical miles

TOW_SPEED

CC ID: 751468
Seq. Order: 31
Data Storage Type: Number
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: Number
Unit of Measure: knots

AREA_SAMPLED

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

Area sampled, in tenths of a hectare. Leading zero was not entered for cruises TC 33, TC 35, TC 36 and TC40 but is now entered in this database. Units for values are hectares.

General Data Type: Number
Unit of Measure: hectares

STATION_MINIMUM_DEPTH

CC ID: 751470
Seq. Order: 33
Data Storage Type: Number
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: Number
Unit of Measure: meters

STATION_MAXIMUM_DEPTH

CC ID: 751471
Seq. Order: 34
Data Storage Type: Number
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: Number
Unit of Measure: meters

MEAN_DEPTH

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

Mean depth of station, in meters. Leading zeros were not entered for cruises TC 33, TC 35, TC 36 and TC40 but are now entered in this database. Units for values are meters.

General Data Type: Number
Unit of Measure: meters

WIRE_OUT

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

Wire out, in meters. Leading zero was not entered for cruises TC 33, TC 35, TC 36 and TC40 but is now entered in this database. Units for values are meters.

General Data Type: Number
Unit of Measure: meters

BOTTOM_TEMPERATURE

CC ID: 751474
Seq. Order: 37
Data Storage Type: Number
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: Number
Unit of Measure: degrees Celsius

GENERAL_LOCALITY

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

Abbreviated locality name of trawl operation.

General Data Type: Character
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: 751476
Seq. Order: 39
Data Storage Type: Number
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of remarks on Trawling Log. Leading zero was not entered for cruises TC 33, TC 35, TC 36 and TC40 but is now entered in this database.

General Data Type: Number

SEQUENCE_NUMBER

CC ID: 751477
Seq. Order: 40
Data Storage Type: Number
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: Number

FROM_FILE

CC ID: 751478
Seq. Order: 41
Data Storage Type: Character
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: Character

DATE_LOADED

CC ID: 751479
Seq. Order: 42
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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-05-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-05-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-05-23