tblHaul
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:29757 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | tblHaul |
---|---|
Short Name: | tblHaul |
Status: | Completed |
Abstract: |
NA |
Notes: |
Loaded by FGDC Metadata Uploader, batch 7848, 12-14-2015 14:31 |
Entity Information
Description: |
NA |
---|
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
HaulID | NUMBER | Primary key; autonumber | |
100
|
CruiseID | Unknown | Foreign key; Same as the 'CruiseID' in tblCruise | |
100
|
HaulNo | NUMBER | Haul number specific to cruise, year, leg, area and site | |
100
|
SiteCode | Unknown | From lovSiteCode table; WB is Whale Bay; SL is St.Lazaria; SS is Salisbury Sound; IB is Islas Bay; TB is Torch Bay; GH is Graves Harbor; KB is Kiliuda Bay; IZ is Izuit Bay; PD is Port Dick; AB is Ailiak Bay | |
100
|
SubSiteCode | Unknown | From lovSubSiteCode; see table "lovSubSiteCode" | |
100
|
GearCode | Unknown | From lovGear table; | |
100
|
Date | NUMBER | Date the haul took place | |
100
|
StartWPT | NUMBER | Start waypoint number from handheld Garmin GPS; start only recorded for purse, and beach seines, jigging. | |
100
|
EndWPT | NUMBER | End of trawl waypoint number from handheld Garmin GPS | |
100
|
StartLatDD | NUMBER | Latitide of deployment/haul in decimal degrees | |
100
|
StartLongDD | NUMBER | Longitude of deployment/haul in decimal degrees | |
100
|
EndLatDD | NUMBER | End latitude of deployment/trawl in decimal degrees | |
100
|
EndLongDD | NUMBER | End longitude of deployment/trawl in decimal degrees | |
100
|
StartTime | NUMBER | Time gear was deployed in 24 hours, ADT (Alaska Daylight Time) | |
100
|
EndTime | NUMBER | Time gear was retrieved in 24 hours, ADT (Alaska Daylight Time) | |
100
|
SeaState | Unknown | Sea state; calm, breezy, windy, rough | |
100
|
SetQuality | Unknown | NA | |
100
|
Substrate | Unknown | Habitat, substrate of the sampling site; Large/medium/small cobble/sand/mud; | |
100
|
Vegetation | Unknown | Habitat, vegetation type on sampling site; eelgrass/bull kelp/kelp/lettuce kelp; | |
100
|
VegCover | Unknown | Habitat, vegetation coverage on sampling site; full, partial, sparse | |
100
|
HaulCom | Unknown | Haul comments about the quality of the set; additional comments e.g., fish species, count, weight etc. |
Attribute Details
HaulID
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary key; autonumber |
Allowed Values: | 91 - 605 |
CruiseID
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Foreign key; Same as the 'CruiseID' in tblCruise |
Allowed Values: | unknown |
HaulNo
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul number specific to cruise, year, leg, area and site |
Allowed Values: | 1 - 10 |
SiteCode
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
From lovSiteCode table; WB is Whale Bay; SL is St.Lazaria; SS is Salisbury Sound; IB is Islas Bay; TB is Torch Bay; GH is Graves Harbor; KB is Kiliuda Bay; IZ is Izuit Bay; PD is Port Dick; AB is Ailiak Bay |
Allowed Values: | unknown |
SubSiteCode
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
From lovSubSiteCode; see table "lovSubSiteCode" |
Allowed Values: | unknown |
GearCode
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
From lovGear table; |
Allowed Values: | unknown |
Date
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date the haul took place |
Allowed Values: | 201104180000 - 201110270000 |
StartWPT
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Start waypoint number from handheld Garmin GPS; start only recorded for purse, and beach seines, jigging. |
Allowed Values: | 0 - 184 |
EndWPT
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End of trawl waypoint number from handheld Garmin GPS |
Allowed Values: | 0 - 185 |
StartLatDD
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitide of deployment/haul in decimal degrees |
Allowed Values: | 0 - 59.92312 |
StartLongDD
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude of deployment/haul in decimal degrees |
Allowed Values: | -153.19128 - 136.4821 |
EndLatDD
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End latitude of deployment/trawl in decimal degrees |
Allowed Values: | 0 - 59.30474 |
EndLongDD
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End longitude of deployment/trawl in decimal degrees |
Allowed Values: | -153.15428 - 0 |
StartTime
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time gear was deployed in 24 hours, ADT (Alaska Daylight Time) |
Allowed Values: | 145 - 2149 |
EndTime
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time gear was retrieved in 24 hours, ADT (Alaska Daylight Time) |
Allowed Values: | 1034 - 2238 |
SeaState
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sea state; calm, breezy, windy, rough |
Allowed Values: | unknown |
SetQuality
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NA |
Allowed Values: | unknown |
Substrate
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat, substrate of the sampling site; Large/medium/small cobble/sand/mud; |
Allowed Values: | unknown |
Vegetation
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat, vegetation type on sampling site; eelgrass/bull kelp/kelp/lettuce kelp; |
Allowed Values: | unknown |
VegCover
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat, vegetation coverage on sampling site; full, partial, sparse |
Allowed Values: | unknown |
HaulCom
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul comments about the quality of the set; additional comments e.g., fish species, count, weight etc. |
Allowed Values: | unknown |
Catalog Details
Catalog Item ID: | 29757 |
---|---|
GUID: | gov.noaa.nmfs.inport:29757 |
Metadata Record Created By: | Angie Greig |
Metadata Record Created: | 2015-12-14 14:31+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 |