190 likes | 323 Views
Mapping Public Water Systems in California. Craig Wolff, M.S. Eng CA Environmental Health Tracking Program (CEHTP) Environmental Health Investigations Branch CA Department of Public Health (CDPH). Leaks and GIS. Environmental Health Tracking.
E N D
Mapping Public Water Systems in California Craig Wolff, M.S. Eng CA Environmental Health Tracking Program (CEHTP) Environmental Health Investigations Branch CA Department of Public Health (CDPH)
Environmental Health Tracking National and statewide network that integrates environmental and health data to produce and make available information that drives action to improve the health of communities.
Enhancing Data for Tracking • Assist data owners in geo-referencing • Geocoding • Collaborative feature editing • Internet- and service-oriented architecture
Drinking Water Service Areas • No complete electronic statewide service area coverage, changes/time • How does Tracking benefit? • Better analysis capacity wrt population served • Other beneficiaries • Emergency mgmt community • Water resource mgmt
Solution – Mapping Tool • Funded by CDC Tracking and CA ODW • Collaborative Internet GIS application for calculating water system service areas in CA • Harness existing Tracking resources • Secure web portal & content mgmt system (hardware, software, data) • Software development expertise • Geocoding tool • Collaborators/advisory (ODW, UC Davis ICE, ACWA, CalEMA, CDC, USEPA, AWWA?)
Role-Based Access • Provide customized workspace for users who have varying levels of access/jurisdiction • Water system staff – read/write access to water system; indicate completion • Water system wholeseller staff – read/write access to member water systems; indicate completion • Regional engineer (LPA) staff – read/write access to all water systems within district; verification • State engineer/admin staff – read/write access to all water systems
Existing Information • GIS Files • Manually gathered existing statewide, regional and local coverages system name match to attach pwsid, evaluate linkage; ~600 PWS in existing dbs • Water utility staff uploads existing GIS files (KML or shapefile) describing service area boundaries • Customer Information Database • Upload customer address table
Geocoding • CDPH has web-based geocoding tool • Batch geocodes ~250K records/hr. ~90% of CWS have <10K connections (i.e. addresses) • Existing browser-based utility for uploading address table and batch geocoding
Geocoding (cont’d) • Processing steps for “connection” address table: • User uploads address table • Geocoding batch submitted • Geocoding results displayed on map • Point “cloud” inferred from geocoded points • Cloud polygon saved for additional editing
Polygon Editing • User edits nodes of boundaries • Backdrop: Google basemap, satellite imagery, terrain; Or personal geodata (i.e. KML). • 3 editing modes: • Node: manual insert/drag/delete; snap to street centerline optional • Path: New nodes inferred from “best” route • Buffer: Identify segment; Buffer to one/both sides of street or to adjacent property boundary
Place Point on Street Closest Street Found Automatically
Refine along Streets Points Placed on Street Automatically
Refine along Property Lines Select Second Point Select First Point Click GO
Outputs from Tool • Public use dataset • All boundaries available for download • New edits posted daily to flat file (KML or shapefile); archive of previous posts • Real-time feeds available for mash-ups (WMS, KML, JSON) • Embeddable code snippets to include maps on other websites • Coupled with geocoding (point-in-polygon)
Timeline • Major software development completed • Deployed and live http://www.ehib.org/water • Pilot with interested water systems NOW! • Role-based, sitewide finish-work (pending) • Navigation • Organization • Documentation • Integration with geocoding by Summer 2011 • Roll-out to all PWS by Winter 2012
What We Need From You • Contribute upload, geocode, digitize/refine • Help feedback during pilot • Use export to your own GIS • Web incorporate maps on your website (“Report a Leak”) • Encourage participation by neighboring water systems