SLIDE 1 1
Update on: SCGA Hydrologic Data Management System
Presented to: SCGA Board
March 10, 2010
SLIDE 2
Outline
Needs and Vision Current Status
Data and Data Gaps Administrative Tools Public Tools Policy-Level Tools Technical-Level Tools
Next Steps
SLIDE 3
SLIDE 4
Needs and Vision
Consistent, common database Public outreach and education Easy access to data Analysis of data Streamline reporting/ BMO compliance
SLIDE 5
Database
Compiling and quality control of data
Pumping (monthly)
Municipal Production Remediation Operations
Water levels Water quality Lithology data
Scanned Images Interpreted Well Logs
SLIDE 6
Data Gaps
California DPH – X,Y location data for wells Local Purveyors – Production
CalAm Elk Grove Water Service Florin County Fruitridge Vista City of Sacramento
SLIDE 7 Interfaces
7
User Access Quality Control
SLIDE 8 Interfaces
8
User Access Quality Control
SLIDE 9 Statewide Data
Interfaces
9
User Access Quality Control Statewide Data
SLIDE 10
Interfaces
Technical Interface: GIS enabled for complex analysis purposes Administrative Interface: Intuitive for user management, data entry, and data validation Decision-Makers and Public Interfaces: Easy access to relevant data and analyses All relate to data from the common database
SLIDE 11
SacIWRIS Architecture
SLIDE 12
Technical Interface
ESRI ArcGIS-based interface
Create contours Polygon analysis Query tool Graphing tools
SLIDE 13
Data Contour Tool
SLIDE 14
Polygon Analysis Tool
SLIDE 15
Time Series Graph
SLIDE 16
Administrative Interface
Manage User Accounts and Permissions Enter and Upload data Validate data Publish data to Statewide IWRIS
SLIDE 17
Administrator Home Page
SLIDE 18
Manage User Accounts and Permissions
SLIDE 19
Enter Data
SLIDE 20
Validate Data
SLIDE 21
Publish to Statewide IWRIS
SLIDE 22
Decision-Maker and Public Interface
Statewide IWRIS Ease of Use, incorporation of statewide database, incorporation of local analysis uploaded by staff/consultants. Public access limited:
No well logs No production well locations No preliminary data or analysis
SLIDE 23
Statewide IWRIS
SLIDE 24
Statewide IWRIS
SLIDE 25
Statewide IWRIS
SLIDE 26 Project Status
Task Status Remaining Work
Lithology 60% Complete Visualization Tools. GW Quality 40% Complete Resolve DPH issues. QA/QC. GW Pumping Nearly Complete Additional purveyor data. QA/QC. GW Levels Nearly Complete Final QA/QC. DMS Data Update Nearly Complete Upload of final data. Tools Nearly Complete IWRIS/DWR interaction. Outreach 5% Complete Board presentation. Demos. Reporting 10% Complete Reports and User Manual. PM 75% Complete Ongoing.
SLIDE 27
Project Status
Schedule: Extension filed for the end of 2010 Budget
$160,000 spent to-date $90,000 remaining