RI008AA1_V
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 52399
| Published / External
Created: 2018-04-17
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 5835
ID: 52399
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | RI008AA1_V |
---|---|
Short Name | RI008AA1_V |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Trawl station information for 8 NOAA R/V Townsend Cromwell cruises. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Trawl station information for 8 NOAA R/V Townsend Cromwell cruises. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | DATASET_CODE | Character | Source ID Code assigned by the data entry staff. |
100 | No | No | VERSION_CODE | Character | Code for the format version assigned by the data entry staff. |
100 | No | No | VESSEL_CODE | Number | Code for the vessel. Coded as TC on collection form, converted to '001'. |
100 | No | No | CRUISE_NUMBER | Number | Two-digit incremental number of the cruise for the year, expanded to 4 digits. |
100 | No | No | STATION_NUMBER | Number | Station number of trawl operation. |
100 | No | No | TRAWL_YEAR | Number | Year of trawl operatiom. |
100 | No | No | TRAWL_MONTH | Number | Month of trawl operation. |
100 | No | No | TRAWL_DAY | Number | Day of trawl operation. |
100 | No | No | START_LATITUDE_DEGREES | Number | Start latitude degrees of trawl operation, in degrees. Units for values are degrees. |
100 | No | No | 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 | No | No | START_LATITUDE_DIRECTION | Character | Start latitude direction of trawl operation. |
100 | No | No | 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 | No | No | START_LONGITUDE_DEGREES | Number | Start longitude degrees of trawl operation, in degrees. Units for values are degrees. |
100 | No | No | 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 | No | No | START_LONGITUDE_DIRECTION | Character | Start longitude direction of trawl operation. |
100 | No | No | 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 | No | No | END_LATITUDE_DEGREES | Number | End latitude degrees of trawl operation, in degrees. Units for values are degrees. |
100 | No | No | 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 | No | No | END_LATITUDE_DIRECTION | Character | End latitude direction of trawl operation. |
100 | No | No | 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 | No | No | END_LONGITUDE_DEGREES | Number | End longitude degrees of trawl operation. Units for values are degrees. |
100 | No | No | END_LONGITUDE_MINUTES | Number | End longitude minutes of trawl operation. Units for values are minutes. Measures are reported with a precision of 3. |
100 | No | No | END_LONGITUDE_DIRECTION | Character | End longitude direction of trawl operation. |
100 | No | No | 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 | No | No | GEAR | Character | Abbreviated name of gear used for trawl operation. |
100 | No | No | DOG_OFF_TIME | Number | Tow start time. |
100 | No | No | HAUL_BACK_TIME | Number | Tow end time at begin haul-back time. |
100 | No | No | MEDIAN_TIME | Number | Median time of trawl operation. |
100 | No | No | 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 | No | No | 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 | No | No | TOW_SPEED | Number | Tow speed, in tenths of a knot. Units for values are knots. Measures are reported with a precision of 3. |
100 | No | No | 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 | No | No | STATION_MINIMUM_DEPTH | Number | Minimum depth of station, in meters. Units for values are meters. |
100 | No | No | STATION_MAXIMUM_DEPTH | Number | Maximum depth of station, in meters. Units for values are meters. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | GENERAL_LOCALITY | Character | Abbreviated locality name of trawl operation. |
100 | No | No | 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 | No | No | SEQUENCE_NUMBER | Number | A consecutive number assigned to each record for a block of data. |
100 | No | No | FROM_FILE | Character | Name of the flat ASCII file that was the source of the data. |
100 | No | No | DATE_LOADED | Date | Date when the record was loaded into Oracle or updated. |
Attribute Details
Attribute Name | DATASET_CODE |
---|---|
Seq. Order | 1 |
Data Storage Type | Character |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Source ID Code assigned by the data entry staff. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VERSION_CODE |
---|---|
Seq. Order | 2 |
Data Storage Type | Character |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the format version assigned by the data entry staff. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_CODE |
---|---|
Seq. Order | 3 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the vessel. Coded as TC on collection form, converted to '001'. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 001 = NOAA R/V TOWNSEND CROMWELL |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CRUISE_NUMBER |
---|---|
Seq. Order | 4 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit incremental number of the cruise for the year, expanded to 4 digits. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION_NUMBER |
---|---|
Seq. Order | 5 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Station number of trawl operation. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRAWL_YEAR |
---|---|
Seq. Order | 6 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year of trawl operatiom. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRAWL_MONTH |
---|---|
Seq. Order | 7 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month of trawl operation. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRAWL_DAY |
---|---|
Seq. Order | 8 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Day of trawl operation. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LATITUDE_DEGREES |
---|---|
Seq. Order | 9 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Start latitude degrees of trawl operation, in degrees. Units for values are degrees. |
General Data Type | Number |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LATITUDE_MINUTES |
---|---|
Seq. Order | 10 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LATITUDE_DIRECTION |
---|---|
Seq. Order | 11 |
Data Storage Type | Character |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Start latitude direction of trawl operation. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N = NORTH S = SOUTH |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LATITUDE_DD |
---|---|
Seq. Order | 12 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LONGITUDE_DEGREES |
---|---|
Seq. Order | 13 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Start longitude degrees of trawl operation, in degrees. Units for values are degrees. |
General Data Type | Number |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LONGITUDE_MINUTES |
---|---|
Seq. Order | 14 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LONGITUDE_DIRECTION |
---|---|
Seq. Order | 15 |
Data Storage Type | Character |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Start longitude direction of trawl operation. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E = EAST W = WEST |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | START_LONGITUDE_DD |
---|---|
Seq. Order | 16 |
Data Storage Type | Number |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LATITUDE_DEGREES |
---|---|
Seq. Order | 17 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End latitude degrees of trawl operation, in degrees. Units for values are degrees. |
General Data Type | Number |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LATITUDE_MINUTES |
---|---|
Seq. Order | 18 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LATITUDE_DIRECTION |
---|---|
Seq. Order | 19 |
Data Storage Type | Character |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End latitude direction of trawl operation. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N = NORTH S = SOUTH |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LATITUDE_DD |
---|---|
Seq. Order | 20 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LONGITUDE_DEGREES |
---|---|
Seq. Order | 21 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End longitude degrees of trawl operation. Units for values are degrees. |
General Data Type | Number |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LONGITUDE_MINUTES |
---|---|
Seq. Order | 22 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LONGITUDE_DIRECTION |
---|---|
Seq. Order | 23 |
Data Storage Type | Character |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End longitude direction of trawl operation. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E = EAST W = WEST |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_LONGITUDE_DD |
---|---|
Seq. Order | 24 |
Data Storage Type | Number |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEAR |
---|---|
Seq. Order | 25 |
Data Storage Type | Character |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Abbreviated name of gear used for trawl operation. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOG_OFF_TIME |
---|---|
Seq. Order | 26 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tow start time. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_BACK_TIME |
---|---|
Seq. Order | 27 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tow end time at begin haul-back time. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MEDIAN_TIME |
---|---|
Seq. Order | 28 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Median time of trawl operation. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HOURS_FISHED |
---|---|
Seq. Order | 29 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DISTANCE_FISHED |
---|---|
Seq. Order | 30 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOW_SPEED |
---|---|
Seq. Order | 31 |
Data Storage Type | Number |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA_SAMPLED |
---|---|
Seq. Order | 32 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION_MINIMUM_DEPTH |
---|---|
Seq. Order | 33 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum depth of station, in meters. Units for values are meters. |
General Data Type | Number |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION_MAXIMUM_DEPTH |
---|---|
Seq. Order | 34 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Maximum depth of station, in meters. Units for values are meters. |
General Data Type | Number |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MEAN_DEPTH |
---|---|
Seq. Order | 35 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WIRE_OUT |
---|---|
Seq. Order | 36 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BOTTOM_TEMPERATURE |
---|---|
Seq. Order | 37 |
Data Storage Type | Number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GENERAL_LOCALITY |
---|---|
Seq. Order | 38 |
Data Storage Type | Character |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Abbreviated locality name of trawl operation. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_REMARKS |
---|---|
Seq. Order | 39 |
Data Storage Type | Number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEQUENCE_NUMBER |
---|---|
Seq. Order | 40 |
Data Storage Type | Number |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A consecutive number assigned to each record for a block of data. |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FROM_FILE |
---|---|
Seq. Order | 41 |
Data Storage Type | Character |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the flat ASCII file that was the source of the data. |
General Data Type | Character |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_LOADED |
---|---|
Seq. Order | 42 |
Data Storage Type | Date |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when the record was loaded into Oracle or updated. |
General Data Type | Date |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2018-05-23 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-05-23 |
Tags |
---|