Master spreadsheet of data available for EBM Sci Frame working group
list of data available, source, scale and resolution of data, variables, people responsible for tracking down each data layer, etc.
Error - Row not in range during extraction.
Spreadsheet's Author: Carrie Kappel
Last Updated with Excel 97
Created with xlhtml 0.5.1
Sheet1
Data Files for NCEAS Scientific Frameworks for EBM - October 30 | ||||||||||||||
Data Category | Data | Format (GIS layer, Excel table, txt file) | Source | Coverage | Spatial resolution | Temporal resolution | Continuous or categorical | In hand? | Project | Location of data | Outside Contact/Owner | Contact Person/ Person Responsible for Obtaining Data | Priority (high, med, low) | Notes |
Bathymetry | Bathymetry | GIS layer | http://marinemap.org/mlpa/viewer.htm | statewide | Y | Boundary Delineation | Carrie's computer | Carrie | ||||||
Substrate & Habitat type | Benthic rugosity 200m | GIS layer | http://marinemap.org/mlpa/viewer.htm | statewide | 200 m grid | - | Y | Boundary Delineation | Carrie | |||||
Benthic rugosity 5m | GIS layer | http://marinemap.org/mlpa/viewer.htm | Central California (MLPA Central Coast study region) | 5 m grid | - | Cat: low, med, high | Y | Boundary Delineation | Carrie | |||||
Seafloor type (soft vs. hard bottom) | GIS layer | http://marinemap.org/mlpa/viewer.htm | statewide | ? | Cat: soft, hard | Y | Boundary Delineation | Carrie | ||||||
Coarse scale habitat type (also avail. intersected with MLPA depth zones and canyons) | GIS layer | http://marinemap.org/mlpa/viewer.htm | Central California (MLPA Central Coast study region) | ? | - | Cat: multiple habitat types | Y | Boundary Delineation, Valuation, Network model | Carrie | |||||
Fine scale habitat type (also avail. intersected with MLPA depth zones and canyons) | GIS layer | http://marinemap.org/mlpa/viewer.htm | Central California (MLPA Central Coast study region) | 1:5000 scale | - | Cat: multiple habitat types | Y | Boundary Delineation, Valuation, Network model | Carrie | |||||
Southern California Rocky Substrate | GIS layer | http://marinemap.org/mlpa/viewer.htm | Southern California | 1:125000 | - | Cat: rock | Y | Boundary Delineation | Carrie | |||||
Southern California Sediment | GIS layer | http://marinemap.org/mlpa/viewer.htm | Southern California | 1:125000 | - | Cat: sediment | Y | Boundary Delineation | Carrie | |||||
Kelp | Kelp coverage | GIS layer | http://marinemap.org/mlpa/viewer.htm | statewide | 1989, 1999, 2002-2004 | Y | Boundary Delineation, Valuation, Network model | Carrie | ||||||
Persistent kelp | GIS layer | http://marinemap.org/mlpa/viewer.htm | statewide | 3 out of 4 of: 1989, 1999, 2002, 2003 | Y | Boundary Delineation, Valuation, Network model | Carrie | |||||||
Kelp abundance | GIS layer/table? | PISCO | Boundary Delineation, Valuation, Network model | Bernardo | ||||||||||
Seabirds | Bird density | GIS layer | http://marinemap.org/mlpa/viewer.htm | Northern and Central California | 5' grid | 1975-1997 (avail divided into warm, cold, and neutral water periods or Davidson Current Season vs. Oceanic Season vs. Upwelling Season) | cont: 76 species | Y | Boundary Delineation | Carrie | ||||
Bird diversity | GIS layer | http://marinemap.org/mlpa/viewer.htm | Northern and Central California | 5' grid | 1975-1997 (avail divided into warm, cold, and neutral water periods or Davidson Current Season vs. Oceanic Season vs. Upwelling Season) | cont: Shannon-Wiener Index | Y | Boundary Delineation | Carrie | |||||
Bird biomass density | GIS layer | http://marinemap.org/mlpa/viewer.htm | Northern and Central California | 5' grid | 1984, 2001(avail divided into warm, cold, and neutral water periods or Davidson Current Season vs. Oceanic Season vs. Upwelling Season) | cont: 76 spp, kg/km2 | Y | Boundary Delineation | Carrie | |||||
Bird breeding colonies | GIS layer | http://marinemap.org/mlpa/viewer.htm | Northern and Central California | point data | 1980, 2000, updated w/ 2002 | Y | Boundary Delineation | Carrie | ||||||
Bird colonies with counts by species (MMS survey) | GIS layer | http://seamap.env.duke.edu/datasets/detail/271 | statewide | point data | 1980 | cont: counts by species or presence/absence | Y | Boundary Delineation | Carrie | |||||
Marine mammals | Marine mammal haulouts | GIS layer | http://marinemap.org/mlpa/viewer.htm | statewide | point data | 2002 | Y | Boundary Delineation | Carrie | |||||
Marine mammal rookeries | GIS layer | http://marinemap.org/mlpa/viewer.htm | statewide | point data | 2002 | Y | Boundary Delineation | Carrie | ||||||
Marine mammal counts | GIS layer | http://seamap.env.duke.edu/datasets/detail/271 | statewide | point data | 1991 | cont: counts by species | Y | Boundary Delineation, Valuation, Network model | Carrie | |||||
Sea otter counts | GIS layer | http://marinemap.org/mlpa/viewer.htm | Golden Gate to Santa Barbara | 0.5 km intervals | 2001, 2002 | Cont: counts | Y | Boundary Delineation, Valuation, Network model | Carrie | |||||
sea otter linear densities | GIS layer | http://marinemap.org/mlpa/viewer.htm | Golden Gate to Santa Barbara | 10 km segments | 2001-2002 | Cat: low, med, high | Y | Boundary Delineation, Valuation, Network model | Carrie | |||||
Zooplankton | Zooplankton biomass | CalCOFI | CalCOFI cruise locations and interpolated data, statewide in earlier years, Southern California in more recent years | point data | 1951-1998, at least quarterly | Boundary Delineation, Network Model, Path Analysis | Becca (Irit) | Mark Ohman (Scripps/LTER) | ||||||
Wave Exposure | Bernardo (Dave) | |||||||||||||
Wind | Bernardo (Dave) | |||||||||||||
Temperature | Temperature | CalCOFI | CalCOFI cruise locations and interpolated data, statewide in earlier years, Southern California in more recent years | point data | 1949-2005, at least quarterly | Boundary Delineation | ||||||||
SST | AVHRR http://las.pfeg.noaa.gov/oceanWatch/oceanwatch_safari.php | statewide | 1.25 km | 1,3,8,14 day composites from 2006, archives elsewhere | Cont | Boundary Delineation | Bernardo | |||||||
Ocean temperature | SeaWIFS | statewide | 0.1 degree | monthly or 8 day (1985-2003) | Cont | Boundary Delineation | Bernardo | |||||||
Salinity | Salinity | CalCOFI | CalCOFI cruise locations and interpolated data, statewide in earlier years, Southern California in more recent years | point data | 1949-2005, at least quarterly | Boundary Delineation | ||||||||
Salinity, nutrients, phosphate, oxygen (?) | GIS? | NODC/ World Ocean Atlas 2005 | NODC | 1 degree | annual | Bernardo | ||||||||
Water chemistry | Phosphate | CalCOFI | CalCOFI cruise locations and interpolated data, statewide in earlier years, Southern California in more recent years | point data | 1949-2005, at least quarterly | Cont | Boundary Delineation | |||||||
Oxygen | CalCOFI | CalCOFI cruise locations and interpolated data, statewide in earlier years, Southern California in more recent years | point data | 1949-2005, at least quarterly | Cont | |||||||||
Primary productivity | Chlorophyll | CalCOFI | CalCOFI cruise locations and interpolated data, statewide in earlier years, Southern California in more recent years | point data | 1983-2005, at least quarterly | Cont | Boundary Delineation | |||||||
Chlorophyll | GIS | SeaWIFS | statewide | 0.1 degree | monthly or 8 day (1997-2005) | Cont | Boundary Delineation | Bernardo (Dave) | ||||||
Primary productivity (derived from SeaWIFS Chl a) | GIS | SeaWIFS | statewide | 0.1 degree | monthly(1997-2005) | Cont | Boundary Delineation | Bernardo (Dave?) | ||||||
Fish and benthos | Fish diversity and abundance (spatial subset of data from NMFS trawl surveys, from N-Central CA biogeographic analysis, all years in one layer) | GIS | http://marinemap.org/mlpa/viewer.htm | Point Arena to Point Sal | point data (from trawls) | summer-fall (1977-2001) | Cont | Y | Boundary Delineation, Valuation, Network model | Carrie | ||||
Fish Biomass & recruitment from stock assessments (sp. specific) | Excel File | Pacific Fisheries Management Council | Point data | Cont.: biomass & recruitment for relevant kelp species (time series data) | Path Analysis, Network Model | Irit/Becca | ||||||||
Sessile spp percent cover UPC | GIS/Excel | PISCO | Central California (Santa Cruz (Sandhill) to Oxnard (Naples) plus the Channel Islands (to SBI) | point data (transects and quadrats) | 1999-2005 | Cont: % cover UPC, species and/or fxn grps and substrate | Boundary Delineation | Bernardo | ||||||
Invert and algal density swaths | GIS/Excel | PISCO | Central California (Santa Cruz (Sandhill) to Oxnard (Naples) plus the Channel Islands (to SBI) | point data (transects and quadrats) | 1999-2005 | Cont: counts by spp | Boundary Delineation, Valuation, Network model | Bernardo | ||||||
Fish abundance/diversity | GIS/Excel | PISCO | Central California (Santa Cruz (Sandhill) to Oxnard (Naples) plus the Channel Islands (to SBI) | point data (40 x 2 m swath transects, midwater and benthic) | 1999-2005 | Cont: counts by spp and length of each indiv | Boundary Delineation, Valuation, Network model | Bernardo | ||||||
Commercial Fishing | Commercial fish landings (sp. Specific) & value | Excel File | CADFG | Annual landings by port & sites within ports (also monthly) | point data | Annual 2001-2004 (&monthly) | Continuous | Y? | Path Analysis, Valuation | Irit/Becca | high | |||
Commercial fish landings (sp. Specific) | Excel File | CADFG | Statewide fish landings by port (9 ports) | point data | Annual 1928-2002 (& monthly) | Cont: landings by port (time series data) | Y | Path Analysis, Valuation | Becca | high | ||||
Commercial fish landings (sp. specific and aggregate) | GIS/Excel | CADFG, fish block data | Statewode fish landings by block | 10 minute blocks | Annual | Cont: landings & effort (size structure?) | Boundary Delineation, Network Model, Path Analysis, Valuation | Dave Osorio, DFG | Chato | high | ||||
Sea urchin fishery landings & value | Excel File | CADFG | sea urchin landings by port/county in SC | Point data (by sites) | Annual 1991-2005 | Cont.: landings & value | Path Analysis, Valuation | Becca | high | Talk to Susanne about central california data | ||||
Abalone Fisheries Landings (historical data) | Susanne | |||||||||||||
Kelp Harvest | Excel File (GIS?) | Susanne | ||||||||||||
Recreational Fishing | http://www.recfin.org/recfin/intq.htm | Excel File (GIS?) | RecFIN | landings & effort by location, by mode (charter boats, land based), by gear type - kelp sp only | Point data (by site) | Annual 1980-2006 | Cont: effort & landings by site (time series) | Valuation, path analysis, network model, threats analysis (GIS) | Fio (split by years, by species, and by fishing mode) | high | ||||
Abalone Fisheries Landings (historical data) | Susanne | |||||||||||||
Water Quality | Beach closure data (NRDC) | Excel File (GIS?) | NRDC | statewide | Point data (by beach) - turn into beach segments? | Annual (14 years?) | Cat: closed/not closed; process it to make continuous: number of days exceeding standards per year | Path analysis, network model, threats analysis (GIS), boundary delineation | Sarah Chassis (NRDC) | Carrie | high | |||
Beach closure data (surfrider) | Excel File | Surfrider | statewide? | Point data (by beach) | Carrie | Talk to Kim Selkoe | ||||||||
Land based pollution | GIS | FAO/UNEP/Global Threats project | statewide (watersheds) | 1km2 blocks | snapshot | Cont: pollution outputs | Valuation, path analysis, boundary delineation, threats analysis | Global threats project (Ben Halpern) | Carrie | med | ||||
Chemical pollution | www.swrcb.ca.gov | statewide (25 sites) | point data | annual 1977-2005? | Chato | |||||||||
Coastal Armoring | Sites of coastal armoring vs natural shores | GIS | Coastal Services Center - Environmental Sensitivity Index (Global Threats Analysis) | statewide | 1km2 blocks | snapshot | Cat: ranks of shoreline sections as threatened by oil spills (process to get armored vs natural shores) | Boundary delineation, threats analysis | Coastal Services Center/ESI (Global Threats Project - Ben Halpern) | Carrie | low | |||
Diving | Dive sites reported from dive surveys | Excel table (GIS) | Susanne's dive surveys | Monterey to San Diego | point data | snapshot (2005) | Cont: dive activity levels (# of dives at sites) | Valuation, boundary delineation | Susanne Menzel | Susanne/Ana | high | |||
Coastal Population Density | Census data for population centers | GIS | statewide | 1 km2 blocks | Valuation, boundary delineation, threats analysis | Global Threats Project (Ben Halpern) | Carrie | low | ||||||
Sedimentation | Land based sedimentation | GIS? | MBNMS | MBNMS | Threats, boundary delineation, network model | Fio (from the Sanctuary) | ||||||||
Sedimentation inputs from watersheds | California | Threats, boundary delineation, network model | John Warrick (USGS Menlo Park | Fio (Dave's student) | ||||||||||
Land Use or Habitat Maps | GIS layers of habitat for MBNMS | GIS | SIMON (www.mbnms-simon.org) - originally from the ESI for central California | MBNMS/Central California (Point Conception to Point Reyes) | 1:50000 scale (?) | snapshot (1992, 1994) | Cat: habitat types | Boundary delineation, threats analysis | Fio (from the Sanctuary) |
Spreadsheet's Author: Carrie Kappel
Last Updated with Excel 97
Created with xlhtml 0.5.1