BayDelta

1
Bay/Delta Tributaries Database Project

• Provide background on Bay/Delta and Tributaries
  Database Project
• Describe a distributed data management system
• Discuss local data management systems
• Example Fish system
• Discuss enterprise applications
• Discuss future development
• Answer questions

2
Sponsors/Participants
Background/Distributed Data Management System
3
Data Types
Background/Distributed Data Management System
4
Background/What Does an Enterprise Data System Do?

• Provides access to a multitude of monitoring
  program data from many individual entities
• Provides data for predictive tools such as models
• Provides data for project operations
• Provides data for adaptive management
• Provides a system to distribute GIS and model
  output
• Provides data on mitigation devices (fish
  screens/barriers etc.)
• Etc

5
Background/Enterprise Data SystemBDAT

• Requires coordination/cooperation between
  agencies and stakeholders
• Is a product of monitoring modeling efforts
• These data now need to be combined with other
  data and made accessible rapidly

6
Data Flow Characteristics RDBMS Alternative
Adult Striped Bass Population Study
CVPIA Camp Juvenile Data
Contra Costa Canal Intake Entrainment Study
Delta Agricultural Diversion Evaluation
Delta Fish Facilities Salvage Monitoring Program
Juvenile Salmon Migration
Hydrodynamic Monitoring
Delta Smelt Spawning Season Monitoring
TDB
TDB
TDB
TDB
Discrete Water Quality Sampling (D1485)
TDB
TDB
Juvenile Salmon Survival
TDB
TDB
TDB
TDB
Midwater Trawl Survey
Comprehensive Database
Monitoring of Delta Smelt Abundance
and Distribution
TDB
Mallard Slough Monitoring Program
TDB
TDB
Predator Dynamics
San Francisco Bay Monitoring
TDB
TDB
Resident Fish Survey
Research on Other Life Stages of Delta Smelt
TDB
TDB
TDB
North Bay Aqueduct Entrainment Monitoring
TDB
TDB
Pre-screen Fish Loss
TDB
TDB
TDB
TDB
TDB
TDB
TDB
TDB
TDB
Georgiana Slough Acoustic Fish Barrier
TDB
Neomysis/Zooplankton Survey
Splittail Studies
Suisun Marsh
Sturgeon Study
South Delta Temporary Barriers Project
Fishery Evaluation
Southern Delta Entrainment Monitoring
Summer Townet Survey
Suisun Marsh Salinity Control Structure (SMSCG)
Adult Salmon Migration Evaluation
San Joaquin River Dissolved Oxygen Monitoring
(D1485)
Striped Bass Egg and Larva Survey
Comprehensive Informix Database
KEY
ODBC/FTP Link
QA/QC
Data Provider (MS Access Client)
Informix Temporary Database (TDB)
QA/QC
7
Background/Enterprise Data System

• System includes a local database component that
  provides local management and control of data
• Local databases are usually developed in MS
  Access
• Local data are then loaded/synchronized into the
  comprehensive database using standard naming
  conventions, units, coordinates, etc

8
Cooperative Data Management System
Background/Distributed Data Management System
9
Background/Local Database

• Provides a data-entry utility so data can be
  entered into the PC and comprehensive database
• Provides a PC database for the group who collects
  the data
• Provides infrastructure for transferring data
  from the data provider to the comprehensive
  database

10
Demonstration of a local Fish Measures Database

• Example features of a local database

11
Example Data Collector
Discrete Field Measures
Bioassay

Fish Measures
Extended Field Measures

Biological Assessment
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17

• Responsibilities of Local
• Database Manager

• Customize Local Database
• Training/Facilitate Data Entry
• Field Data
• Analytical Data
• Quality Assurance of the database
• Completeness
• Consistency
• Anomalies
• Data Output
• QA Officers
• Public Access

18
Background/Enterprise Data System

• Data management is conducted locally
• Data are available locally
• Changes in the local database are reflected in
  the comprehensive database
• IT staff provide technical assistance that
  benefit both the data provider and comprehensive
  database project
• Historic data can be incorporated
• Require maintenance

19
(No Transcript)
20
Cooperative Data Management System
Enterprise Applications
21
Cooperative Data Management System
C E D E N
22
Background/Enterprise Data System

• Relational Database
• Relates divers types of information, including
  GIS, from multiple agencies, stakeholder groups.
• Data are combined using common naming
  conventions, units, datum, etc
• Saves data users time by providing these data in
  a readily accessible format
• Data can be distributed to remote applications
• The system keeps track of changes in data

23
Background/Enterprise Data System

• Infrastructure model is fully scaleable
• System combines the best features of a
  distributed and comprehensive data management
  system
• Standardized data from many sources can be
  obtained by scientists, decision makers, etc
• Data management is conducted by those who collect
  the data

24
Other Enterprise Applications

• Web Interface
• V-plotter developed for time-series data
• CALFED
• Modeling
• Datamon
• GR
• Spring Run
• etc

25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
Background/Data Currently Loaded

• CVPIA/CAMP Fisheries Basic WQ data
• DFG Region 4-Tuolomne Merced River
• SPCA-Stanislaus River
• EBMUD-Mokelumne River (RSTR, BS)
• DWR-Feather River
• USFWS Red Bluff
• DFG GCID-GCID

32
Background/Data Currently Loaded

• IEP
• UCD Suisun Marsh Studies -Suisun Marsh Monitoring
• USGS Hydrologic Monitoring Studies
• DWR Continuous Monitoring Data
• DFG Bay-Studies (In Progress)
• Program enhancements associated with the POD

33
Background/Data Currently Loaded

• IEP
• USFWS Stockton-Juvenile Monitoring
• DFG Summer Townet Survey
• DFG Fall Midwater Trawl
• DWR Yolo Bypass Monitoring
• Mysids Zooplankton (In Process)
• EMP WQ, Phytoplankton, Continuous Benthic

34
Background/Data Currently Loaded

• SWAMP
• Water Quality
• Field Monitoring
• Toxicity
• Bioassessment (In Process)
• Continuous Monitoring (In Process)

35
Current Projects Exchange Network CDX

• Provides gateway from BDAT/CEDEN data to be
  contributed to the EPA Exchange network
• 150 million records and growing daily
• Begin WQ flows
• Provides gateway to obtain data from Federal
  participants NWISS, NOAA, STORET and Central
  Data Warehouse and Sate of CA participants.
• Needed for variety of studies by many different
  groups
• Will supper-seeds our current systems of data
  capture and conveyance.
• Can provides a much needed gateway for anadromous
  fish data between NW States.

36
Current Projects-Standards

• For Projects using funds from Prop 13, 40 or 50
  we will be using the standards required under AB
  1747 or SWAMP Standards
• All data shared through BDAT/ CEDEN will be
  mapped to the EDSC Standards.
• CERES will be doing the metadata Cataloging for
  BDAT/CEDEN
• Part of the coordinated effort between Resource
  and Cal/EPA Agencies to manage, integrate and
  share environmental data.

37
Future ActivitiesStandards for Biological
Metrics

• Data Sharing
• Management

• Standards

• Architecture

• MetaData

38
Cooperative Data Management System
39
Cooperative Data Management System
40
Cooperative Data Management System
41
Conclusion

• The Bay/Delta and Tributaries data system has
  been implemented and is integrating into the EPA
  Exchange Network.
• This system is a comprehensive source of
  biological, water quality and hydrodynamics
  information in CA. You are welcome to gain input
  from us on us on how a similar system might work
  in the NW States.

42
Conclusion

• Questions?