tblHaul
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 29757
| Published / External
Created: 2015-12-14
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 12858
ID: 29757
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | tblHaul |
---|---|
Short Name | tblHaul |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
NA |
* Purpose | |
Notes |
Loaded by FGDC Metadata Uploader, batch 7848, 12-14-2015 14:31 |
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 | |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
NA |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | HaulID | NUMBER | Primary key; autonumber |
100 | No | No | CruiseID | Unknown | Foreign key; Same as the 'CruiseID' in tblCruise |
100 | No | No | HaulNo | NUMBER | Haul number specific to cruise, year, leg, area and site |
100 | No | No | 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 | No | No | SubSiteCode | Unknown | From lovSubSiteCode; see table "lovSubSiteCode" |
100 | No | No | GearCode | Unknown | From lovGear table; |
100 | No | No | Date | NUMBER | Date the haul took place |
100 | No | No | StartWPT | NUMBER | Start waypoint number from handheld Garmin GPS; start only recorded for purse, and beach seines, jigging. |
100 | No | No | EndWPT | NUMBER | End of trawl waypoint number from handheld Garmin GPS |
100 | No | No | StartLatDD | NUMBER | Latitide of deployment/haul in decimal degrees |
100 | No | No | StartLongDD | NUMBER | Longitude of deployment/haul in decimal degrees |
100 | No | No | EndLatDD | NUMBER | End latitude of deployment/trawl in decimal degrees |
100 | No | No | EndLongDD | NUMBER | End longitude of deployment/trawl in decimal degrees |
100 | No | No | StartTime | NUMBER | Time gear was deployed in 24 hours, ADT (Alaska Daylight Time) |
100 | No | No | EndTime | NUMBER | Time gear was retrieved in 24 hours, ADT (Alaska Daylight Time) |
100 | No | No | SeaState | Unknown | Sea state; calm, breezy, windy, rough |
100 | No | No | SetQuality | Unknown | NA |
100 | No | No | Substrate | Unknown | Habitat, substrate of the sampling site; Large/medium/small cobble/sand/mud; |
100 | No | No | Vegetation | Unknown | Habitat, vegetation type on sampling site; eelgrass/bull kelp/kelp/lettuce kelp; |
100 | No | No | VegCover | Unknown | Habitat, vegetation coverage on sampling site; full, partial, sparse |
100 | No | No | HaulCom | Unknown | Haul comments about the quality of the set; additional comments e.g., fish species, count, weight etc. |
Attribute Details
Attribute Name | HaulID |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary key; autonumber |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 91 - 605 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CruiseID |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Foreign key; Same as the 'CruiseID' in tblCruise |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HaulNo |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Haul number specific to cruise, year, leg, area and site |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 - 10 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SiteCode |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SubSiteCode |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
From lovSubSiteCode; see table "lovSubSiteCode" |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GearCode |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
From lovGear table; |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Date |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the haul took place |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 201104180000 - 201110270000 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | StartWPT |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Start waypoint number from handheld Garmin GPS; start only recorded for purse, and beach seines, jigging. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0 - 184 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EndWPT |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End of trawl waypoint number from handheld Garmin GPS |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0 - 185 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | StartLatDD |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitide of deployment/haul in decimal degrees |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0 - 59.92312 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | StartLongDD |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude of deployment/haul in decimal degrees |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -153.19128 - 136.4821 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EndLatDD |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End latitude of deployment/trawl in decimal degrees |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0 - 59.30474 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EndLongDD |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End longitude of deployment/trawl in decimal degrees |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -153.15428 - 0 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | StartTime |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time gear was deployed in 24 hours, ADT (Alaska Daylight Time) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 145 - 2149 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EndTime |
---|---|
Seq. Order | |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time gear was retrieved in 24 hours, ADT (Alaska Daylight Time) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1034 - 2238 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SeaState |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sea state; calm, breezy, windy, rough |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SetQuality |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
NA |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Substrate |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Habitat, substrate of the sampling site; Large/medium/small cobble/sand/mud; |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Vegetation |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Habitat, vegetation type on sampling site; eelgrass/bull kelp/kelp/lettuce kelp; |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VegCover |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Habitat, vegetation coverage on sampling site; full, partial, sparse |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HaulCom |
---|---|
Seq. Order | |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Haul comments about the quality of the set; additional comments e.g., fish species, count, weight etc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | unknown |
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 | 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 Workflow State | Published / External |
Metadata Last Review Date | 2016-05-05 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-05 |
Tags |
---|