Mapping Public Water Systems in California

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
  lt10K connections (i.e. addresses)
• Existing browser-based utility for uploading
  address table and batch geocoding

11
Geocoding (contd)

• 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
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