Slide Menu
Search Help Show/Hide Menu

Item Identification

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 Information

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.

Data Attributes

Attribute Summary

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

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 Details

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: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28