surveying the past north pacific pelagic seabird database gary s drew and john f piatt
Download
Skip this Video
Download Presentation
Surveying the Past: North Pacific Pelagic Seabird Database Gary S. Drew and John F. Piatt

Loading in 2 Seconds...

play fullscreen
1 / 39

Surveying the Past: North Pacific Pelagic Seabird Database Gary S. Drew and John F. Piatt - PowerPoint PPT Presentation


  • 222 Views
  • Uploaded on

Surveying the Past: North Pacific Pelagic Seabird Database Gary S. Drew and John F. Piatt. Assessing Seabird Abundance and Distribution. Outer Continental Shelf Environmental Assessment Program - OCSEAP. 1974-1982 273 Surveys Standard Protocols Central Data Repository Limitations

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Surveying the Past: North Pacific Pelagic Seabird Database Gary S. Drew and John F. Piatt' - EllenMixel


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
surveying the past north pacific pelagic seabird database gary s drew and john f piatt

Surveying the Past: North Pacific Pelagic Seabird DatabaseGary S. Drew and John F. Piatt

outer continental shelf environmental assessment program ocseap

Outer Continental Shelf Environmental Assessment Program - OCSEAP

  • 1974-1982
  • 273 Surveys
  • Standard Protocols
  • Central Data Repository
  • Limitations
    • Data format
    • Surveys not integrated
    • Lack of documentation
objectives of the nppsd
Objectives of the NPPSD
  • Compile databases in native formats
  • Merge datasets using common unit of measure
  • Provide extensive documentation
  • Develop database programs for accessing and querying the database
  • Create web site for disseminating data
obstacles
Lack of documentation

Variable QAQC

Lack of documentation

Variable QAQC

Different formats

Different protocols

Obstacles

OCSEAP

Post OCSEAP

design
Design
  • Comprehensive archiving plan
  • Extensive QAQC
  • Use of relational database
  • Selection of density for units of measure
  • Reclassification of some fields
  • Extensive documentation
    • Metadata database
    • Taxonomic code list
    • Users guide
archiving
Archiving
  • Original Format (Raw)
  • Level 1 - Post QAQC (Access DT)
  • Level 2 - Standardized (Access DT)
  • NPPSD Summary Database (Access DT)
slide9
QAQC
  • Out of Range
  • Data type mismatch
  • Documentation data mismatch
calculating density
Calculating Density
  • Time x Speed x Transect Width
  • Distance x Transect Width
  • Use Lat Long Start/Stop and Great Circle Distance Formula x Transect Width
standardization
Standardization
  • Survey Type
  • Survey Platform
  • Behavior
metadata
NPPSD MetadataMetadata
  • FDGC Compliant
  • Access Database
slide14
Marine Mammals

Data on marine mammals was collected on most seabird surveys

slide15
Kodiak Surveys

Divoky Surveys

Robert Day Surveys

USFWS Surveys

OCSEAP Surveys

George Hunt Surveys

Data processing queries

NPPSD

Marine Mammal Numbers

Seabird Numbers

Seabird Density

Marine Mammal Density

USFWS Ecological Services

Mapped Data Products

Short-Tailed Albatross

Datasets for Analysis

slide16
LOCATION

L2

ENVIRONMENT

L1

LOCATION

L1

Make

Location

L2 (4)

Location

L2 (2)

Great Circle XY Distance Calc

Make

Location

L2 (2)

Make

Location

L2 (1)

Export to Excel

Make

Location

L2 (3)

Copy Distance Calculations

ImporttoAccess

Access Table

Location

L2 (2)

Access Select Query

Excel Spreadsheet

Make Table Query

slide17
Make

Data Birds

L2 (1)

LOCATION

L2

DATA

L1

Make

Data Birds

L2 (2)

Access Table

Access Select Query

Make Table Query

Make Data Birds

L2 (3)

Numbers/Density

Make Data Mammals

L2 (3)

Numbers / Density

Make Data Birds

L2 (4) Number

Make Data Birds

L2 (4) Density

Make Data Mammals

L2 (4) Number

Make Data Mammals

L2 (4) Density

slide18
Data Table

Number of Surveys

Number of Transects

Seabird Density

377

57,660

Seabird Number

406

61,195

Marine Mammal Density

377

57,660

Marine Mammal Number

406

61,195

NPPSD Data Tables

Version 1.0

slide19
Data Set

Number of Surveys

Number of Transects

Shuntov (Russia)

8

2900

Piatt (USGS)

12

1356

Irons (USFWS)

19

5088

Byrd/Piatt (USFWS/USGS)

9

225

Day

8

653

Acquired Datasets

acquired data sets will fill data gaps
Acquired data setswill fill data gaps
  • Russia
  • Prince William Sound
  • Glacier Bay
products and collaborations
Products and Collaborations
  • Distribution of Black-Footed and Laysan Albatrosses - USFWS and NMFS
products and collaborations23
Products and Collaborations
  • Distribution of Black-Footed and Laysan Albatrosses - USFWS and NMFS
  • Distribution and density data for Kittlitz’s Murrelet - USFWS for “Petition for Listing”
  • Distribution maps for Kittlitz’s Murrelets - USGS inventory plans for this species
products and collaborations25
Products and Collaborations
  • Distribution of Black-Footed and Laysan Albatrosses - USFWS and NMFS
  • Distribution and density data for Kittlitz’s Murrelet - USFWS for “Petition for Listing”
  • Distribution maps for Kittlitz’s Murrelets - USGS inventory plans for this species
  • Broad-scale map of Alaskan seabird distribution – MMS to assess environmental risk
products and collaborations27
Products and Collaborations
  • Distribution of Black-Footed and Laysan Albatrosses - USFWS and NMFS
  • Distribution and density data for Kittlitz’s Murrelet - USFWS for “Petition for Listing”
  • Distribution maps for Kittlitz’s Murrelets - USGS inventory plans for this species
  • Broad-scale map of Alaskan seabird distribution – MMS to assess environmental risk
  • Developed a database for Short-tailed Albatross (STAL) - USFWS ESO
products and collaborations29
Products and Collaborations
  • Distribution of Black-Footed and Laysan Albatrosses - USFWS and NMFS
  • Distribution and density data for Kittlitz’s Murrelet - USFWS for “Petition for Listing”
  • Distribution maps for Kittlitz’s Murrelets - USGS inventory plans for this species
  • Broad-scale map of Alaskan seabird distribution – MMS to assess environmental risk
  • Developed a database for Short-tailed Albatross (STAL) - USFWS ESO
  • Collaborated with George Hunt and Jaime Jahncke (UC Irving) on a presentation at PICES
  • Coauthored the paper “Prey Consumption and Energy Transfer by Seabirds in the Gulf of Alaska” Deep Sea Research II (in press) with George Hunt and Jaime Jahncke of UC Irving
slide30
Prey Consumption and Energy Transfer by Marine Birds in the Gulf of Alaska

PICES Presentation – Hunt, G.S. et al. 2004

Deep Sea Research II Publication in press 2005

products and collaborations31
Products and Collaborations
  • Distribution of Black-Footed and Laysan Albatrosses - USFWS and NMFS
  • Distribution and density data for Kittlitz’s Murrelet - USFWS for “Petition for Listing”
  • Distribution maps for Kittlitz’s Murrelets - USGS inventory plans for this species
  • Broad-scale map of Alaskan seabird distribution – MMS to assess environmental risk
  • Developed a database for Short-tailed Albatross (STAL) - USFWS ESO
  • Collaborated with George Hunt and Jaime Jahncke (UC Irving) on a presentation at PICES
  • Coauthored the paper “Prey Consumption and Energy Transfer by Seabirds in the Gulf of Alaska” Deep Sea Research II (in press) with George Hunt and Jaime Jahncke of UC Irving
  • Distribution of pink-footed shearwater for the “North American Conservation Action Plan” prepared by the Commission for Environmental Cooperation
products and collaborations32
Products and Collaborations
  • Distribution of Black-Footed and Laysan Albatrosses - USFWS and NMFS
  • Distribution and density data for Kittlitz’s Murrelet - USFWS for “Petition for Listing”
  • Distribution maps for Kittlitz’s Murrelets - USGS inventory plans for this species
  • Broad-scale map of Alaskan seabird distribution – MMS to assess environmental risk
  • Developed a database for Short-tailed Albatross (STAL) - USFWS ESO
  • Collaborated with George Hunt and Jaime Jahncke (UC Irving) on a presentation at PICES
  • Coauthored the paper “Prey Consumption and Energy Transfer by Seabirds in the Gulf of Alaska” Deep Sea Research II (in press) with George Hunt and Jaime Jahncke of UC Irving
  • Distribution of pink-footed shearwater for the “North American Conservation Action Plan” prepared by the Commission for Environmental Cooperation
  • Collaborated with Bruce Robson (World Wildlife Fund) on the planned Pribilof Islands Habitat Conservation Area.
products and collaborations34
Products and Collaborations
  • Distribution of Black-Footed and Laysan Albatrosses - USFWS and NMFS
  • Distribution and density data for Kittlitz’s Murrelet - USFWS for “Petition for Listing”
  • Distribution maps for Kittlitz’s Murrelets - USGS inventory plans for this species
  • Broad-scale map of Alaskan seabird distribution – MMS to assess environmental risk
  • Developed a database for Short-tailed Albatross (STAL) - USFWS ESO
  • Collaborated with George Hunt and Jaime Jahncke (UC Irving) on a presentation at PICES
  • Coauthored the paper “Prey Consumption and Energy Transfer by Seabirds in the Gulf of Alaska” Deep Sea Research II (in press) with George Hunt and Jaime Jahncke of UC Irving
  • Distribution of pink-footed shearwater for the “North American Conservation Action Plan” prepared by the Commission for Environmental Cooperation
  • Collaborated with Bruce Robson (World Wildlife Fund) on the planned Pribilof Islands Habitat Conservation Area.
  • Preliminary assessment of marine bird abundance and species composition in the vicinity of the Selendang Ayu grounding
conclusions
Conclusions
  • Integration of seabird surveys is a complex process.
  • Retention of original data and format is critical
  • Documentation is a critical aspect
  • The utility of integrated datasets is manifold and unpredictable
what next
What Next?
  • Complete integration of acquired data
  • Develop more user friendly interface
  • Identify a host to serve the data
  • Develop a web based GIS interface
  • Hard Copy Atlas
acknowledgements
Acknowledgements

We are grateful to NPRB and NPMRI as well as the USFWS and USGS for funding this research. We thank Shiway Wang, Michelle St. Peters, and Jennifer Wetzal for their tedious work on data entry, proofing, and documentation. Dave Irons, Jay Johnson, Kathy Kulitz, and Shawn Stevenson provide valuable guidance as part of a “NPPSD Working Group”. Dave and Shawn were also invaluable in finding hard copy data sheets and cruise reports for many of the historical USFWS surveys. We also want to thank Bob Day and George Hunt who have been strong supporters of this work and have provided considerable data to the effort.

ad