1 / 19

Mapping Public Water Systems in California

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.

perry
Download Presentation

Mapping Public Water Systems in California

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 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)

  2. Leaks and GIS

  3. 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.

  4. Data Visualization Example

  5. Enhancing Data for Tracking • Assist data owners in geo-referencing • Geocoding • Collaborative feature editing • Internet- and service-oriented architecture

  6. 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

  7. 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?)

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. Place Point on Street Closest Street Found Automatically

  14. Delete Points

  15. Refine along Streets Points Placed on Street Automatically

  16. Refine along Property Lines Select Second Point Select First Point Click GO

  17. 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)

  18. 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

  19. 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

More Related