Bird Density By Station in the California Current Ecosystem
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36823
| Published / External
Created: 2017-02-16
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 30860
ID: 36823
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
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 |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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. |
* Purpose | |
Notes | |
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 | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
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. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | Yes | No | Log_Density | VARCHAR2 | This is the logarithm, base 10, of the raw density. Units for values are log (individuals per square kilometer). |
100 | Yes | No | Decimal_Latitude | NUMBER | This is the latitude of the survey station. Units for values are decimal degrees latitude. |
100 | Yes | No | Decimal_Longitude | NUMBER | This is the longitude of the survey station. Units for values are decimal degrees longitude. |
100 | Yes | No | Month | VARCHAR2 | This is the calendar month, represented as a number. Units for values are n/a. |
100 | Yes | No | 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 | Yes | No | 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 | Yes | No | Local_Month | VARCHAR2 | This is the local month, represented as text. Units for values are n/a. |
Attribute Details
Attribute Name | Station_Code |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | n/a |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Year |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | n/a |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Transect_Name |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | n/a |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Station_Name |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | n/a |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Species_Code |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | n/a |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Segment_Species_Count |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 16 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | integer |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Segment_Distance_For_Sums |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 16 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | real number > = 0 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Area_Surveyed_For_Sums |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 16 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | real number > = 0 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Density |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 16 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | real number > = 0 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Log_Density |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 16 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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) |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | real number |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Decimal_Latitude |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 <= real number < = +90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Decimal_Longitude |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 <= real number < = +180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Month |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | n/a |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Distance_From_Shore |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | real number > 0 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Local_Date |
---|---|
Seq. Order | 15 |
Data Storage Type | DATE |
Max Length | 8 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | n/a |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Local_Month |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 9 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | n/a |
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 | 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 Workflow State | Published / External |
Metadata Last Review Date | 2018-02-27 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-02-27 |
Tags |
---|