Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: EffortPre1987
Short Name: EffortPre1987
Status: Completed
Abstract:

Gray whale shore based counting effort including 1967 to 1986/87 during the southbound migration off Yankee Point/Granite Canyon.

Notes:

Loaded by FGDC Metadata Uploader, batch 6252, 06-17-2015 19:01

Entity Information

Entity Type: Data File
Description:

Gray whale shore based counting effort including 1967 to 1986/87 during the southbound migration off Yankee Point/Granite Canyon.

Data Attributes

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? Name Type Description
N/A
ID NUMBER Auto Number for primary key
N/A
Location VARCHAR Location code: 1 is Yankee Point and 2 is Granite Canyon; different from Location in RecentSurveyData
N/A
Day NUMBER Day of month for survey effort
N/A
Month NUMBER Month for survey effort
N/A
Year NUMBER Year of survey effort
N/A
Watchperiod VARCHAR Watch period: 1,2 or 3
N/A
Observer VARCHAR Numeric code for observer - see ObserverCodes table
N/A
Begintime NUMBER Time of beginning of watch
N/A
Endtime NUMBER Time of end of watch
N/A
Block1winddirection NUMBER First recorded WindDirection (0 to 360)
N/A
Block1beaufort VARCHAR First recorded Beaufort (0 - 9)
N/A
Block1visibility VARCHAR First recorded visibility code: 1 - Excellent, 2 - Very Good, 3 - Good, 4 - Fair, 5 - Poor, 6 - Unusable
N/A
Block2winddirection NUMBER Second recorded WindDirection
N/A
Block2beaufort VARCHAR Second recorded Beaufort
N/A
Block2visibility VARCHAR Second recorded visibility code
N/A
Block3winddirection NUMBER Third recorded WindDirection
N/A
Block3beaufort VARCHAR Third recorded Beaufort
N/A
Block3visibility VARCHAR Third recorded Visibilty code
N/A
key Unknown Key field of date_watch to link up to sightings
N/A
Use Unknown No if Beaufort or Vis >4 on effort record or any associated sighting; yes otherwise

Attribute Details

ID

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

Auto Number for primary key

Allowed Values: 1 - 1765

Location

CC ID: 205653
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Location code: 1 is Yankee Point and 2 is Granite Canyon; different from Location in RecentSurveyData

Allowed Values: Codeset: Location

Day

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

Day of month for survey effort

Allowed Values: 1 - 31

Month

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

Month for survey effort

Allowed Values: 1 - 12

Year

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

Year of survey effort

Allowed Values: 1967 - 1986

Watchperiod

CC ID: 205657
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Watch period: 1,2 or 3

Allowed Values: Codeset: Watch period

Observer

CC ID: 205658
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Numeric code for observer - see ObserverCodes table

Allowed Values: Codeset: Observer code

Begintime

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

Time of beginning of watch

Allowed Values: 0 - 23:59:59

Endtime

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

Time of end of watch

Allowed Values: 0 - 23:59:59

Block1winddirection

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

First recorded WindDirection (0 to 360)

Allowed Values: 0 - 359

Block1beaufort

CC ID: 205662
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

First recorded Beaufort (0 - 9)

Allowed Values: Codeset: Beaufort scale

Block1visibility

CC ID: 205663
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

First recorded visibility code: 1 - Excellent, 2 - Very Good, 3 - Good, 4 - Fair, 5 - Poor, 6 - Unusable

Allowed Values: Codeset: Visibility

Block2winddirection

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

Second recorded WindDirection

Allowed Values: 0 - 359

Block2beaufort

CC ID: 205665
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Second recorded Beaufort

Allowed Values: Codeset: Beaufort scale

Block2visibility

CC ID: 205666
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Second recorded visibility code

Allowed Values: Codeset: Visibility

Block3winddirection

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

Third recorded WindDirection

Allowed Values: 0 - 359

Block3beaufort

CC ID: 205668
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Third recorded Beaufort

Allowed Values: Codeset: Beaufort scale

Block3visibility

CC ID: 205669
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Third recorded Visibilty code

Allowed Values: Codeset: Visibility

key

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

Key field of date_watch to link up to sightings

Allowed Values: No domain defined.

Use

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

No if Beaufort or Vis >4 on effort record or any associated sighting; yes otherwise

Catalog Details

Catalog Item ID: 25527
GUID: gov.noaa.nmfs.inport:25527
Metadata Record Created By: Janice Waite
Metadata Record Created: 2015-06-17 19:01+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-11-30
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-11-30
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-11-30