Metadata Rubric

83%

5 / 6

Alaska Fisheries Science Center Metadata Librar... > Auke Bay Laboratories > AFSC/ABL: Nearshore Fish Atlas of Alaska >

Events

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:23969 | Updated: February 27, 2023 | Published / External

Item Identification

Title:	Events
Short Name:	Events
Status:	In Work
Abstract:	-no description-
Notes:	Loaded by FGDC Metadata Uploader, batch 5630, 03-16-2015 18:08

Entity Information

Description:	-no description-

Data Attributes

Attribute Summary

	Name	Type	Description
100	ProjectName	character varying	Project under which the sampling event was performed. References "ProjectName" column in Lookup_project table.
100	SiteID	foreign key	A number that identifies a unique Site. Links Sites table to Event table. See relationships for details.
100	EventID	id	A key that identifies a unique sampling effort.
100	Date	Unknown	Date that sampling took place: month/day/year as xx/xx/xxxx.
100	SetTime	time	Time of set.
100	RawEvent	integer	Information to help cross reference sites of raw data sheets and database. 1-8=site number on raw data sheets, MB=data from Mark Byerly, YN=data from yellow notebook, "empty cell"=database <Site> value provides adequate information.
100	GearSpecific	VARCHAR2	Fish sampling method: BSEINE=standard beach seine, 4BSEINE=4 foot tall beach seine, PSEINE=purse seine These choices are in a drop-down menu. Only BSEINE data included in 2012 synthesis report.
100	Weather	VARCHAR2	Climatological conditions during sampling: CLOUDY, FOGGY, PARTLY CLOUDY, RAIN, SLEET, SNOW, SUNNY. These choices are in a drop-down menu.
100	Temperature	numeric	Water temperature in degrees Celsius measured with a handheld thermometer or CTD. Temp. taken approx. 0.5 meters depth.
100	Salinity	numeric	Salinity in ppt measured with a handheld refractometer or CTD. Temp. taken approx. 0.5 meters depth.
100	TidalStage	character varying	Tidal stage at which site was sampled: EBB, FLOOD, SLACK. These choices are in a drop-down menu.
100	Comments	text	Comments
100	GearBasic	text	General description of gear.

Name

Type

Description

100

ProjectName

character varying

Project under which the sampling event was performed. References "ProjectName" column in Lookup_project table.

100

SiteID

foreign key

A number that identifies a unique Site. Links Sites table to Event table. See relationships for details.

100

EventID

A key that identifies a unique sampling effort.

100

Date

Unknown

Date that sampling took place: month/day/year as xx/xx/xxxx.

100

SetTime

time

Time of set.

100

RawEvent

integer

Information to help cross reference sites of raw data sheets and database. 1-8=site number on raw data sheets, MB=data from Mark Byerly, YN=data from yellow notebook, "empty cell"=database <Site> value provides adequate information.

100

GearSpecific

VARCHAR2

Fish sampling method: BSEINE=standard beach seine, 4BSEINE=4 foot tall beach seine, PSEINE=purse seine These choices are in a drop-down menu. Only BSEINE data included in 2012 synthesis report.

100

Weather

VARCHAR2

Climatological conditions during sampling: CLOUDY, FOGGY, PARTLY CLOUDY, RAIN, SLEET, SNOW, SUNNY. These choices are in a drop-down menu.

100

Temperature

numeric

Water temperature in degrees Celsius measured with a handheld thermometer or CTD. Temp. taken approx. 0.5 meters depth.

100

Salinity

numeric

Salinity in ppt measured with a handheld refractometer or CTD. Temp. taken approx. 0.5 meters depth.

100

TidalStage

character varying

Tidal stage at which site was sampled: EBB, FLOOD, SLACK. These choices are in a drop-down menu.

100

Comments

text

Comments

100

GearBasic

text

General description of gear.

Attribute Details

ProjectName

CC ID: 1203982

Seq. Order:	1
Data Storage Type:	character varying
Required:	No
Primary Key:	No
Status:	Active
Description:	Project under which the sampling event was performed. References "ProjectName" column in Lookup_project table.

SiteID

CC ID: 228052

Data Storage Type:	foreign key
Required:	No
Primary Key:	No
Status:	Active
Description:	A number that identifies a unique Site. Links Sites table to Event table. See relationships for details.
Allowed Values:	No domain defined.

EventID

CC ID: 228053

Data Storage Type:	id
Required:	No
Primary Key:	Yes
Status:	Active
Description:	A key that identifies a unique sampling effort.
Allowed Values:	No domain defined.

Date

CC ID: 228055

Data Storage Type:	Unknown
Required:	No
Primary Key:	No
Status:	Active
Description:	Date that sampling took place: month/day/year as xx/xx/xxxx.
Allowed Values:	No domain defined.

SetTime

CC ID: 228057

Data Storage Type:	time
Required:	No
Primary Key:	No
Status:	Active
Description:	Time of set.
Allowed Values:	Field source not limited to list.

RawEvent

CC ID: 228060

Data Storage Type:	integer
Required:	No
Primary Key:	No
Status:	Active
Description:	Information to help cross reference sites of raw data sheets and database. 1-8=site number on raw data sheets, MB=data from Mark Byerly, YN=data from yellow notebook, "empty cell"=database <Site> value provides adequate information.
Allowed Values:	No domain defined.

GearSpecific

CC ID: 228061

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Fish sampling method: BSEINE=standard beach seine, 4BSEINE=4 foot tall beach seine, PSEINE=purse seine These choices are in a drop-down menu. Only BSEINE data included in 2012 synthesis report.
Allowed Values:	"4BSEINE", "BSEINE", "PSEINE"

Weather

CC ID: 228063

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Climatological conditions during sampling: CLOUDY, FOGGY, PARTLY CLOUDY, RAIN, SLEET, SNOW, SUNNY. These choices are in a drop-down menu.
Allowed Values:	"CLOUDY", "FOGGY", "PARTLY CLOUDY", "RAIN", "SLEET", "SNOW", "SUNNY"

Temperature

CC ID: 228064

Data Storage Type:	numeric
Required:	No
Primary Key:	No
Status:	Active
Description:	Water temperature in degrees Celsius measured with a handheld thermometer or CTD. Temp. taken approx. 0.5 meters depth.
Allowed Values:	No domain defined.

Salinity

CC ID: 228065

Data Storage Type:	numeric
Required:	No
Primary Key:	No
Status:	Active
Description:	Salinity in ppt measured with a handheld refractometer or CTD. Temp. taken approx. 0.5 meters depth.
Allowed Values:	No domain defined.

TidalStage

CC ID: 228066

Data Storage Type:	character varying
Required:	No
Primary Key:	No
Status:	Active
Description:	Tidal stage at which site was sampled: EBB, FLOOD, SLACK. These choices are in a drop-down menu.
Allowed Values:	Field source not limited to list.

Comments

CC ID: 228067

Data Storage Type:	text
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments
Allowed Values:	No domain defined.

GearBasic

CC ID: 228068

Data Storage Type:	text
Required:	No
Primary Key:	No
Status:	Active
Description:	General description of gear.
Allowed Values:	No domain defined.

Catalog Details

Catalog Item ID:	23969
GUID:	gov.noaa.nmfs.inport:23969
Metadata Record Created By:	Emily A Fergusson
Metadata Record Created:	2015-03-16 18:08+0000
Metadata Record Last Modified By:	Emily A Fergusson
Metadata Record Last Modified:	2023-02-27 23:31+0000
Metadata Record Published:	2023-02-27
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-05-18
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-05-18