Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Resource Ecology and Fisheries Management Divis... > Fish Abundance Surveys > AFSC/REFM: Inshore research surveys in the east... >

tblHaul

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:29757  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

NA

Description

NA

Entity Information

Data Attribute / Type Description
HaulID
NUMBER 		Primary key; autonumber
CruiseID
Unknown 		Foreign key; Same as the 'CruiseID' in tblCruise
HaulNo
NUMBER 		Haul number specific to cruise, year, leg, area and site
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
SubSiteCode
Unknown 		From lovSubSiteCode; see table "lovSubSiteCode"
GearCode
Unknown 		From lovGear table;
Date
NUMBER 		Date the haul took place
StartWPT
NUMBER 		Start waypoint number from handheld Garmin GPS; start only recorded for purse, and beach seines, jigging.
EndWPT
NUMBER 		End of trawl waypoint number from handheld Garmin GPS
StartLatDD
NUMBER 		Latitide of deployment/haul in decimal degrees
StartLongDD
NUMBER 		Longitude of deployment/haul in decimal degrees
EndLatDD
NUMBER 		End latitude of deployment/trawl in decimal degrees
EndLongDD
NUMBER 		End longitude of deployment/trawl in decimal degrees
StartTime
NUMBER 		Time gear was deployed in 24 hours, ADT (Alaska Daylight Time)
EndTime
NUMBER 		Time gear was retrieved in 24 hours, ADT (Alaska Daylight Time)
SeaState
Unknown 		Sea state; calm, breezy, windy, rough
SetQuality
Unknown 		NA
Substrate
Unknown 		Habitat, substrate of the sampling site; Large/medium/small cobble/sand/mud;
Vegetation
Unknown 		Habitat, vegetation type on sampling site; eelgrass/bull kelp/kelp/lettuce kelp;
VegCover
Unknown 		Habitat, vegetation coverage on sampling site; full, partial, sparse
HaulCom
Unknown 		Haul comments about the quality of the set; additional comments e.g., fish species, count, weight etc.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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

CC ID: 263490
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Primary key; autonumber
Allowed Values: 91 - 605

CruiseID

CC ID: 263491
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Foreign key; Same as the 'CruiseID' in tblCruise
Allowed Values: unknown

HaulNo

CC ID: 263492
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

CC ID: 263493
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

CC ID: 263494
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

From lovSubSiteCode; see table "lovSubSiteCode"
Allowed Values: unknown

GearCode

CC ID: 263495
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

From lovGear table;
Allowed Values: unknown

Date

CC ID: 263496
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Date the haul took place
Allowed Values: 201104180000 - 201110270000

StartWPT

CC ID: 263497
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

CC ID: 263498
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

CC ID: 263499
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

CC ID: 263500
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

CC ID: 263501
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

CC ID: 263502
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

CC ID: 263503
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

CC ID: 263504
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

CC ID: 263505
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Sea state; calm, breezy, windy, rough
Allowed Values: unknown

SetQuality

CC ID: 263506
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

NA
Allowed Values: unknown

Substrate

CC ID: 263507
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

CC ID: 263508
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

CC ID: 263509
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

CC ID: 263510
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