Metadata Rubric

100%

6 / 6

NWFSC Metadata Library > FE (Fish Ecology) Division > Bird Distribution and Abundance - Ocean Surviva... >

Bird Density By Station in the California Current Ecosystem

Entity (ENT) | Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:36823 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

These tables contain information on the density of seabirds or other animals/objects counted during ship-based visual strip-transect surveys in the California Current Ecosystem.

Description

These tables contain information on the density of seabirds or other animals/objects counted during ship-based visual strip-transect surveys in the California Current Ecosystem.

Entity Type
Spreadsheet

Data Attribute / Type	Description
Station_Code VARCHAR2	This is the unique database code used to identify an oceanographic station for a given year, month, and day. Units for values are n/a.
Year VARCHAR2	This is the calendar year; add "2000" to get the year, e.g. "3" = "2003", "11" = "2011". Units for values are n/a.
Transect_Name VARCHAR2	This is the two-letter designation for each east-west survey transect in the survey. Units for values are n/a.
Station_Name VARCHAR2	This is the nearest survey station to which a given bird (or other) density has been assigned. Units for values are n/a.
Species_Code VARCHAR2	These are four-letter species codes that typically follow the American Ornithologists' Union code for bird species or taxon (see http://www.wec.ufl.edu/birds/SurveyDocs/species_list.pdf). For marine mammals, large fishes, or other objects, a similar four-letter code is assigned to that sighting. Units for values are n/a.
Segment_Species_Count VARCHAR2	This is the total count, in whole numbers, of species sightings assigned to a given station. Units for values are count.
Segment_Distance_For_Sums VARCHAR2	This is the segment distance (in kilometers) along the transect that was assigned to a given station. Units for values are kilometers.
Area_Surveyed_For_Sums VARCHAR2	This is the area covered by the visual survey (in square kilometers) and over which species sightings were summed and assigned to a given station. Units for values are square kilometers.
Density VARCHAR2	This is the density, in individuals per square kilometer, assigned to a given survey station. Units for values are individuals per square kilometer.
Log_Density VARCHAR2	This is the logarithm, base 10, of the raw density. Units for values are log (individuals per square kilometer).
Decimal_Latitude NUMBER	This is the latitude of the survey station. Units for values are decimal degrees latitude.
Decimal_Longitude NUMBER	This is the longitude of the survey station. Units for values are decimal degrees longitude.
Month VARCHAR2	This is the calendar month, represented as a number. Units for values are n/a.
Distance_From_Shore VARCHAR2	This is the distance (in nautical miles) of the survey station from the shoreline where the transect line would intersect the coastline if it were extended all the way to shore. Units for values are nautical miles.
Local_Date DATE	This is the local date represented in DD-MM-YY format, where YY begins from the year 2000. Units for values are n/a.
Local_Month VARCHAR2	This is the local month, represented as text. Units for values are n/a.

Data Attribute / Type

Description

Station_Code
VARCHAR2

This is the unique database code used to identify an oceanographic station for a given year, month, and day. Units for values are n/a.

Year
VARCHAR2

This is the calendar year; add "2000" to get the year, e.g. "3" = "2003", "11" = "2011". Units for values are n/a.

Transect_Name
VARCHAR2

This is the two-letter designation for each east-west survey transect in the survey. Units for values are n/a.

Station_Name
VARCHAR2

This is the nearest survey station to which a given bird (or other) density has been assigned. Units for values are n/a.

Species_Code
VARCHAR2

These are four-letter species codes that typically follow the American Ornithologists' Union code for bird species or taxon (see http://www.wec.ufl.edu/birds/SurveyDocs/species_list.pdf). For marine mammals, large fishes, or other objects, a similar four-letter code is assigned to that sighting. Units for values are n/a.

Segment_Species_Count
VARCHAR2

This is the total count, in whole numbers, of species sightings assigned to a given station. Units for values are count.

Segment_Distance_For_Sums
VARCHAR2

This is the segment distance (in kilometers) along the transect that was assigned to a given station. Units for values are kilometers.

Area_Surveyed_For_Sums
VARCHAR2

This is the area covered by the visual survey (in square kilometers) and over which species sightings were summed and assigned to a given station. Units for values are square kilometers.

Density
VARCHAR2

This is the density, in individuals per square kilometer, assigned to a given survey station. Units for values are individuals per square kilometer.

Log_Density
VARCHAR2

This is the logarithm, base 10, of the raw density. Units for values are log (individuals per square kilometer).

Decimal_Latitude
NUMBER

This is the latitude of the survey station. Units for values are decimal degrees latitude.

Decimal_Longitude
NUMBER

This is the longitude of the survey station. Units for values are decimal degrees longitude.

Month
VARCHAR2

This is the calendar month, represented as a number. Units for values are n/a.

Distance_From_Shore
VARCHAR2

This is the distance (in nautical miles) of the survey station from the shoreline where the transect line would intersect the coastline if it were extended all the way to shore. Units for values are nautical miles.

Local_Date
DATE

This is the local date represented in DD-MM-YY format, where YY begins from the year 2000. Units for values are n/a.

Local_Month
VARCHAR2

This is the local month, represented as text. Units for values are n/a.

No Child Items for this record.

No contact information is available for this record.

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

Title:	Bird Density By Station in the California Current Ecosystem
Short Name:	Bird Density By Station in the California Current Ecosystem
Status:	Planned
Abstract:	These tables contain information on the density of seabirds or other animals/objects counted during ship-based visual strip-transect surveys in the California Current Ecosystem.

Entity Type:	Spreadsheet
Active Version?:	Yes
Schema Name:	PARR
Description:	These tables contain information on the density of seabirds or other animals/objects counted during ship-based visual strip-transect surveys in the California Current Ecosystem.

Attribute Summary

	Name	Type	Description
100	Station_Code	VARCHAR2	This is the unique database code used to identify an oceanographic station for a given year, month, and day. Units for values are n/a.
100	Year	VARCHAR2	This is the calendar year; add "2000" to get the year, e.g. "3" = "2003", "11" = "2011". Units for values are n/a.
100	Transect_Name	VARCHAR2	This is the two-letter designation for each east-west survey transect in the survey. Units for values are n/a.
100	Station_Name	VARCHAR2	This is the nearest survey station to which a given bird (or other) density has been assigned. Units for values are n/a.
100	Species_Code	VARCHAR2	These are four-letter species codes that typically follow the American Ornithologists' Union code for bird species or taxon (see http://www.wec.ufl.edu/birds/SurveyDocs/species_list.pdf). For marine mammals, large fishes, or other objects, a similar four-letter code is assigned to that sighting. Units for values are n/a.
100	Segment_Species_Count	VARCHAR2	This is the total count, in whole numbers, of species sightings assigned to a given station. Units for values are count.
100	Segment_Distance_For_Sums	VARCHAR2	This is the segment distance (in kilometers) along the transect that was assigned to a given station. Units for values are kilometers.
100	Area_Surveyed_For_Sums	VARCHAR2	This is the area covered by the visual survey (in square kilometers) and over which species sightings were summed and assigned to a given station. Units for values are square kilometers.
100	Density	VARCHAR2	This is the density, in individuals per square kilometer, assigned to a given survey station. Units for values are individuals per square kilometer.
100	Log_Density	VARCHAR2	This is the logarithm, base 10, of the raw density. Units for values are log (individuals per square kilometer).
100	Decimal_Latitude	NUMBER	This is the latitude of the survey station. Units for values are decimal degrees latitude.
100	Decimal_Longitude	NUMBER	This is the longitude of the survey station. Units for values are decimal degrees longitude.
100	Month	VARCHAR2	This is the calendar month, represented as a number. Units for values are n/a.
100	Distance_From_Shore	VARCHAR2	This is the distance (in nautical miles) of the survey station from the shoreline where the transect line would intersect the coastline if it were extended all the way to shore. Units for values are nautical miles.
100	Local_Date	DATE	This is the local date represented in DD-MM-YY format, where YY begins from the year 2000. Units for values are n/a.
100	Local_Month	VARCHAR2	This is the local month, represented as text. Units for values are n/a.

Name

Type

Description

100

Station_Code

VARCHAR2

This is the unique database code used to identify an oceanographic station for a given year, month, and day. Units for values are n/a.

100

Year

VARCHAR2

This is the calendar year; add "2000" to get the year, e.g. "3" = "2003", "11" = "2011". Units for values are n/a.

100

Transect_Name

VARCHAR2

This is the two-letter designation for each east-west survey transect in the survey. Units for values are n/a.

100

Station_Name

VARCHAR2

This is the nearest survey station to which a given bird (or other) density has been assigned. Units for values are n/a.

100

Species_Code

VARCHAR2

100

Segment_Species_Count

VARCHAR2

This is the total count, in whole numbers, of species sightings assigned to a given station. Units for values are count.

100

Segment_Distance_For_Sums

VARCHAR2

This is the segment distance (in kilometers) along the transect that was assigned to a given station. Units for values are kilometers.

100

Area_Surveyed_For_Sums

VARCHAR2

This is the area covered by the visual survey (in square kilometers) and over which species sightings were summed and assigned to a given station. Units for values are square kilometers.

100

Density

VARCHAR2

This is the density, in individuals per square kilometer, assigned to a given survey station. Units for values are individuals per square kilometer.

100

Log_Density

VARCHAR2

This is the logarithm, base 10, of the raw density. Units for values are log (individuals per square kilometer).

100

Decimal_Latitude

NUMBER

This is the latitude of the survey station. Units for values are decimal degrees latitude.

100

Decimal_Longitude

NUMBER

This is the longitude of the survey station. Units for values are decimal degrees longitude.

100

Month

VARCHAR2

This is the calendar month, represented as a number. Units for values are n/a.

100

Distance_From_Shore

VARCHAR2

100

Local_Date

DATE

This is the local date represented in DD-MM-YY format, where YY begins from the year 2000. Units for values are n/a.

100

Local_Month

VARCHAR2

This is the local month, represented as text. Units for values are n/a.

Attribute Details

Station_Code

CC ID: 731394

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the unique database code used to identify an oceanographic station for a given year, month, and day. Units for values are n/a.
General Data Type:	VARCHAR2
Unit of Measure:	n/a
Allowed Values:	n/a

Year

CC ID: 731395

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the calendar year; add "2000" to get the year, e.g. "3" = "2003", "11" = "2011". Units for values are n/a.
General Data Type:	VARCHAR2
Unit of Measure:	n/a
Allowed Values:	n/a

Transect_Name

CC ID: 731396

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the two-letter designation for each east-west survey transect in the survey. Units for values are n/a.
General Data Type:	VARCHAR2
Unit of Measure:	n/a
Allowed Values:	n/a

Station_Name

CC ID: 731397

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the nearest survey station to which a given bird (or other) density has been assigned. Units for values are n/a.
General Data Type:	VARCHAR2
Unit of Measure:	n/a
Allowed Values:	n/a

Species_Code

CC ID: 731398

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	These are four-letter species codes that typically follow the American Ornithologists' Union code for bird species or taxon (see http://www.wec.ufl.edu/birds/SurveyDocs/species_list.pdf). For marine mammals, large fishes, or other objects, a similar four-letter code is assigned to that sighting. Units for values are n/a.
General Data Type:	VARCHAR2
Unit of Measure:	n/a
Allowed Values:	n/a

Segment_Species_Count

CC ID: 731399

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	16
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the total count, in whole numbers, of species sightings assigned to a given station. Units for values are count.
General Data Type:	VARCHAR2
Unit of Measure:	count
Allowed Values:	integer

Segment_Distance_For_Sums

CC ID: 731400

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	16
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the segment distance (in kilometers) along the transect that was assigned to a given station. Units for values are kilometers.
General Data Type:	VARCHAR2
Unit of Measure:	kilometers
Allowed Values:	real number > = 0

Area_Surveyed_For_Sums

CC ID: 731401

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	16
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the area covered by the visual survey (in square kilometers) and over which species sightings were summed and assigned to a given station. Units for values are square kilometers.
General Data Type:	VARCHAR2
Unit of Measure:	square kilometers
Allowed Values:	real number > = 0

Density

CC ID: 731402

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	16
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the density, in individuals per square kilometer, assigned to a given survey station. Units for values are individuals per square kilometer.
General Data Type:	VARCHAR2
Unit of Measure:	individuals per square kilometer
Allowed Values:	real number > = 0

Log_Density

CC ID: 731403

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	16
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the logarithm, base 10, of the raw density. Units for values are log (individuals per square kilometer).
General Data Type:	VARCHAR2
Unit of Measure:	log (individuals per square kilometer)
Allowed Values:	real number

Decimal_Latitude

CC ID: 731404

Seq. Order:	11
Data Storage Type:	NUMBER
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the latitude of the survey station. Units for values are decimal degrees latitude.
General Data Type:	VARCHAR2
Unit of Measure:	decimal degrees latitude
Allowed Values:	-90 <= real number < = +90

Decimal_Longitude

CC ID: 731405

Seq. Order:	12
Data Storage Type:	NUMBER
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the longitude of the survey station. Units for values are decimal degrees longitude.
General Data Type:	VARCHAR2
Unit of Measure:	decimal degrees longitude
Allowed Values:	-180 <= real number < = +180

Month

CC ID: 731406

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the calendar month, represented as a number. Units for values are n/a.
General Data Type:	VARCHAR2
Unit of Measure:	n/a
Allowed Values:	n/a

Distance_From_Shore

CC ID: 731407

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the distance (in nautical miles) of the survey station from the shoreline where the transect line would intersect the coastline if it were extended all the way to shore. Units for values are nautical miles.
General Data Type:	VARCHAR2
Unit of Measure:	nautical miles
Allowed Values:	real number > 0

Local_Date

CC ID: 731408

Seq. Order:	15
Data Storage Type:	DATE
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the local date represented in DD-MM-YY format, where YY begins from the year 2000. Units for values are n/a.
General Data Type:	DATE
Unit of Measure:	n/a
Allowed Values:	n/a

Local_Month

CC ID: 731409

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	9
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the local month, represented as text. Units for values are n/a.
General Data Type:	VARCHAR2
Unit of Measure:	n/a
Allowed Values:	n/a

Catalog Item ID:	36823
GUID:	gov.noaa.nmfs.inport:36823
Metadata Record Created By:	Jeffrey W Cowen
Metadata Record Created:	2017-02-16 19:24+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2018-02-27
Owner Org:	NWFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2018-02-27
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2019-02-27

Bird Density By Station in the California Current Ecosystem

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

Station_Code

Year

Transect_Name

Station_Name

Species_Code

Segment_Species_Count

Segment_Distance_For_Sums

Area_Surveyed_For_Sums

Density

Log_Density

Decimal_Latitude

Decimal_Longitude

Month

Distance_From_Shore

Local_Date

Local_Month

Catalog Details