tblHaul
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:24148 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | tblHaul |
|---|---|
| Short Name: | tblHaul |
| Status: | In Work |
| Abstract: |
NA |
| Notes: |
Loaded by FGDC Metadata Uploader, batch 5688, 03-24-2015 13:51 |
Entity Information
| Description: |
NA |
|---|
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
CruiseID | Unknown | Primary key with haul number. vessel initials and the year and the leg of the cruise on vessel | |
|
100
|
Haul | NUMBER | Primary key with cruise number. | |
|
100
|
RecTotCatWt | NUMBER | For RECOVERY cruises only recorded in kg NOT Metric tons; Total fish weight captured, including Atka mackerel | |
|
100
|
CruiseType | Unknown | Tag release or tag recovery research cruise | |
|
100
|
Area | Unknown | Seguam, Tanaga, Amchitka, Petrel, Kiska, Buldir, Ingenstrom Rock, Walls Plateau, Heck Canyon, Tahoma Reef, Tahoma Seamount, Agattu | |
|
100
|
Stratum | NUMBER | Subareas within "Areas" designated specifically for the tag release and tag recoveries (1,2,3) | |
|
100
|
Substratum | NUMBER | Only applies to Tanaga area. Strata 3 was broken into sub-subarea's | |
|
100
|
TimeZone | Unknown | ADT (Alaska Daylight Time; GMT -8) | |
|
100
|
Date | NUMBER | Date tow began, not necessarily when it ended, note made in comments if haul ended on different day that it began | |
|
100
|
Recorder | Unknown | Initials of data enterer | |
|
100
|
EQTime | NUMBER | In military time | |
|
100
|
EQLat | NUMBER | Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) | |
|
100
|
EQLatDD | NUMBER | Based on a query, converts to decimal degrees for use in GIS | |
|
100
|
EQLong | NUMBER | Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) | |
|
100
|
EQLongDD | NUMBER | Based on a query, converts to decimal degrees for use in GIS | |
|
100
|
EQBtmDepth | NUMBER | Recorded in meters | |
|
100
|
HBTime | NUMBER | In military time | |
|
100
|
HBLat | NUMBER | Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) | |
|
100
|
HBLong | NUMBER | Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) | |
|
100
|
HBLatDD | NUMBER | Based on a query, converts to decimal degrees for use in GIS | |
|
100
|
HBLongDD | NUMBER | Based on a query, converts to decimal degrees for use in GIS | |
|
100
|
HBBtmDep | NUMBER | In meters | |
|
100
|
VesselHaulComments | Unknown | NA | |
|
100
|
AvgBtmDep | NUMBER | Subjective, based on what we "view" during tow duration | |
|
100
|
Min | NUMBER | Minimum bottom depth | |
|
100
|
Max | NUMBER | Maximum bottom depth | |
|
100
|
SurfaceTemp | NUMBER | Recorded in celsius | |
|
100
|
GearTemp | NUMBER | Recorded in celsius | |
|
100
|
WindDirection | NUMBER | Recorded in degrees | |
|
100
|
WindSpeed | NUMBER | Recorded in knots | |
|
100
|
SeaHeight | NUMBER | Recorded in wave height/meter (not feet) | |
|
100
|
CurrentSpeed | NUMBER | Recorded in knots | |
|
100
|
CurrentDirection | NUMBER | Recorded in degrees | |
|
100
|
NetPerformanceCode | Unknown | NA | |
|
100
|
DoorWidth | Unknown | In fathoms | |
|
100
|
NetHeight | NUMBER | In fathoms | |
|
100
|
WireOut | NUMBER | Recorded in fathoms | |
|
100
|
DistanceFished | NUMBER | Recorded in miles | |
|
100
|
PositionDataMethod | Unknown | GLOBE | |
|
100
|
DoorDroppedDD | NUMBER | Recorded in military time | |
|
100
|
BrakeSetBS | NUMBER | Recorded in military time | |
|
100
|
EQTimeInt1 | NUMBER | Recorded in military time | |
|
100
|
EQLatInt1 | NUMBER | Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) | |
|
100
|
EQLongInt1 | NUMBER | Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) | |
|
100
|
EQBtmDep1 | NUMBER | Recorded in meters | |
|
100
|
EQTimeInt2 | NUMBER | Recorded in military time | |
|
100
|
EQLatInt2 | NUMBER | Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) | |
|
100
|
EQLongInt2 | NUMBER | Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) | |
|
100
|
EQBtmDep2 | NUMBER | Recorded in meters | |
|
100
|
DoorsUpDU | NUMBER | Recorded in military time |
Attribute Details
CruiseID
CC ID: 194485
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Primary key with haul number. vessel initials and the year and the leg of the cruise on vessel |
| Allowed Values: | unknown |
Haul
CC ID: 194486
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Primary key with cruise number. |
| Allowed Values: | 1 - 1360 |
RecTotCatWt
CC ID: 194487
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
For RECOVERY cruises only recorded in kg NOT Metric tons; Total fish weight captured, including Atka mackerel |
| Allowed Values: | 0 - 114663.1015625 |
CruiseType
CC ID: 194488
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tag release or tag recovery research cruise |
| Allowed Values: | unknown |
Area
CC ID: 194489
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Seguam, Tanaga, Amchitka, Petrel, Kiska, Buldir, Ingenstrom Rock, Walls Plateau, Heck Canyon, Tahoma Reef, Tahoma Seamount, Agattu |
| Allowed Values: | unknown |
Stratum
CC ID: 194490
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Subareas within "Areas" designated specifically for the tag release and tag recoveries (1,2,3) |
| Allowed Values: | 1 - 99 |
Substratum
CC ID: 194491
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Only applies to Tanaga area. Strata 3 was broken into sub-subarea's |
| Allowed Values: | 1 - 3 |
TimeZone
CC ID: 194492
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
ADT (Alaska Daylight Time; GMT -8) |
| Allowed Values: | unknown |
Date
CC ID: 194493
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date tow began, not necessarily when it ended, note made in comments if haul ended on different day that it began |
| Allowed Values: | 199908060000 - 201505010000 |
Recorder
CC ID: 194494
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials of data enterer |
| Allowed Values: | unknown |
EQTime
CC ID: 194495
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
In military time |
| Allowed Values: | 0 - 2356 |
EQLat
CC ID: 194496
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) |
| Allowed Values: | 5115.37 - 5257 |
EQLatDD
CC ID: 194497
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Based on a query, converts to decimal degrees for use in GIS |
| Allowed Values: | 51.25 - 52.96 |
EQLong
CC ID: 194498
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) |
| Allowed Values: | -17957.08 - 17924.72 |
EQLongDD
CC ID: 194499
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Based on a query, converts to decimal degrees for use in GIS |
| Allowed Values: | -179.529166666667 - 179.412 |
EQBtmDepth
CC ID: 194500
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in meters |
| Allowed Values: | 70.9 - 314 |
HBTime
CC ID: 194501
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
In military time |
| Allowed Values: | 4 - 2359 |
HBLat
CC ID: 194502
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) |
| Allowed Values: | 5004.62 - 5404.93 |
HBLong
CC ID: 194503
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) |
| Allowed Values: | -17931.09 - 17923.75 |
HBLatDD
CC ID: 194504
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Based on a query, converts to decimal degrees for use in GIS |
| Allowed Values: | 50.077 - 54.0821666666667 |
HBLongDD
CC ID: 194505
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Based on a query, converts to decimal degrees for use in GIS |
| Allowed Values: | -179.518166666667 - 179.4 |
HBBtmDep
CC ID: 194506
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
In meters |
| Allowed Values: | 67 - 412 |
VesselHaulComments
CC ID: 194507
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
NA |
| Allowed Values: | unknown |
AvgBtmDep
CC ID: 194508
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Subjective, based on what we "view" during tow duration |
| Allowed Values: | 0 - 248 |
Min
CC ID: 194509
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Minimum bottom depth |
| Allowed Values: | 16 - 182 |
Max
CC ID: 194510
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Maximum bottom depth |
| Allowed Values: | 91.3 - 237 |
SurfaceTemp
CC ID: 194511
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in celsius |
| Allowed Values: | 5 - 8.3 |
GearTemp
CC ID: 194512
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in celsius |
| Allowed Values: | 3 - 5.8 |
WindDirection
CC ID: 194513
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees |
| Allowed Values: | 0 - 360 |
WindSpeed
CC ID: 194514
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in knots |
| Allowed Values: | 0 - 45 |
SeaHeight
CC ID: 194515
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in wave height/meter (not feet) |
| Allowed Values: | 0 - 18 |
CurrentSpeed
CC ID: 194516
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in knots |
| Allowed Values: | 0 - 4.7 |
CurrentDirection
CC ID: 194517
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees |
| Allowed Values: | 0 - 360 |
NetPerformanceCode
CC ID: 194518
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
NA |
| Allowed Values: | unknown |
DoorWidth
CC ID: 194519
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
In fathoms |
| Allowed Values: | unknown |
NetHeight
CC ID: 194520
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
In fathoms |
| Allowed Values: | 2.8 - 7 |
WireOut
CC ID: 194521
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in fathoms |
| Allowed Values: | 3 - 675 |
DistanceFished
CC ID: 194522
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in miles |
| Allowed Values: | 0.14 - 8.58 |
PositionDataMethod
CC ID: 194523
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
GLOBE |
| Allowed Values: | unknown |
DoorDroppedDD
CC ID: 194524
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in military time |
| Allowed Values: | 3 - 2348 |
BrakeSetBS
CC ID: 194525
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in military time |
| Allowed Values: | 8 - 2355 |
EQTimeInt1
CC ID: 194526
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in military time |
| Allowed Values: | 3 - 2357 |
EQLatInt1
CC ID: 194527
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) |
| Allowed Values: | 5114.4 - 5257 |
EQLongInt1
CC ID: 194528
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) |
| Allowed Values: | -17957.08 - 17924.72 |
EQBtmDep1
CC ID: 194529
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in meters |
| Allowed Values: | 66.5 - 205 |
EQTimeInt2
CC ID: 194530
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in military time |
| Allowed Values: | 1 - 2342 |
EQLatInt2
CC ID: 194531
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) |
| Allowed Values: | 5115.28 - 5256 |
EQLongInt2
CC ID: 194532
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in degrees, minutes and a fraction of minute (ex: 5246.63) |
| Allowed Values: | -17930.49 - 17923.17 |
EQBtmDep2
CC ID: 194533
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in meters |
| Allowed Values: | 66.7 - 206 |
DoorsUpDU
CC ID: 194534
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recorded in military time |
| Allowed Values: | 0 - 2353 |
Catalog Details
| Catalog Item ID: | 24148 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:24148 |
| Metadata Record Created By: | Angie Greig |
| Metadata Record Created: | 2015-03-24 13:51+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-05-05 |
| Owner Org: | AFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-05-05 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-05-05 |