Leveraging GPS to Integrate Customer Service Data with GIS
Leveraging GPS to Integrate Customer Service Data with GIS
Scott Williams (IRWD) Haritha Vendra (DCSE) Shil Niyogi (DCSE)
IRWD Overview • Located in Orange g County, y California • Formed in 1961 to serve Ag customers • 180 square miles • Population of 340,000 340 000 • Over 100,000 service connections (Potable/Recycled) • Service area includes Irvine and portions of Lake Forest, Orange, Newport Beach, Tustin, Santa Ana, Costa Mesa • Potable Water - 1420 miles of pipe • Nonpotable Water - 450 miles of pipe • Sewer Collection - 930 miles of pipe • Was an area of rapid real estate development
Current GIS at IRWD z z z z
ArcGIS Desktop p 9.3.1 ArcGIS Server 9.3.1 SQL Server Enterprise GIS Applications z MapLibrary.NET z Mapplet.NET Mapplet NET z FieldMapplet.NET z USA z Valve Turning / Hydrant Flushing z Water Demand Forecasting, Hydraulic Modeling z Data Maintenance Tools z Atlas Printing Tool
GPS Data Collection Drivers z z z z
Need of a complete inventory of Service Meters in GIS Need of integration of billing data to the GIS service meters Need of an efficient route to enable faster and more accurate meter GPS data collection Need of connecting mains with meters, meters using service laterals to establish network connectivity
Project Overview z z z z
Route Development from Geocoded Meter addresses Field Data Collection with QA/QC Post Processing Data to sub-foot accuracy and R Rework k Constructing Service laterals
Route Development z z z
z
DCSE Geocoded Customer Billing Addresses Divided the meters into service villages Service villages were further divided i t realizable into li bl and d efficient ffi i t books b k (or ( routes) Divided the routes among DCSE DCSE’ss 12 GPS teams
Field Data Collection z
z
z
z
DCSE chose sub-foot sub foot accuracy capable Trimble’s GeoXH handheld for its data collection DCSE developed a custom application to help the field crew collect points and verify addresses Lasers were used in places where GPS signals were weak or where the meters were nott accessible ibl QA/QC at multiple levels helped the team catch error as soon as they were committed
Post Processing and Rework z z
z z
DCSE chose h Pathfinder P hfi d Office Offi for f post processing i DCSE’s QA/QC involved looking at statistical data DOP values, values as well as National Mapping Accuracy Aerials Points that did not meet the stringent accuracy criteria were re-collected per a rework plan DCSE used RTK instruments for collecting those that were in the rework plan
Constructing Service Laterals z
z
z
DCSE constructed d service i laterals l l for f those meters that were approved in the Q /Q QA/QC DCSE developed a custom application and also looked through asbuilts for constructing the service laterals A final check was made that all the billing g addresses had a corresponding p g meter associated connected to the mains
Anomaly Handling z
z
DCSE used PMI’s methodology to manage scope, schedule, budget and issues Separate routes were developed for meters that were difficult to find
Measuring Success z
IRWD has since been using the Meter GPS points to visualize Billing System data: z
Historical usage data to identify potential conservation issues
What Next for IRWD z z
Develop on-going GPS procedures for new meters Develop applications to leverage new data
Questions? Please contact us at: Scott Williams ([email protected]; 949-453-5584) Haritha Vendra ([email protected]; (hvendra@dcse com; 949 949-465-3417) 465 3417) Shil Niyogi ([email protected]; 949-465-3424)
Scott Williams (IRWD) Haritha Vendra (DCSE) Shil Niyogi (DCSE)
IRWD Overview • Located in Orange g County, y California • Formed in 1961 to serve Ag customers • 180 square miles • Population of 340,000 340 000 • Over 100,000 service connections (Potable/Recycled) • Service area includes Irvine and portions of Lake Forest, Orange, Newport Beach, Tustin, Santa Ana, Costa Mesa • Potable Water - 1420 miles of pipe • Nonpotable Water - 450 miles of pipe • Sewer Collection - 930 miles of pipe • Was an area of rapid real estate development
Current GIS at IRWD z z z z
ArcGIS Desktop p 9.3.1 ArcGIS Server 9.3.1 SQL Server Enterprise GIS Applications z MapLibrary.NET z Mapplet.NET Mapplet NET z FieldMapplet.NET z USA z Valve Turning / Hydrant Flushing z Water Demand Forecasting, Hydraulic Modeling z Data Maintenance Tools z Atlas Printing Tool
GPS Data Collection Drivers z z z z
Need of a complete inventory of Service Meters in GIS Need of integration of billing data to the GIS service meters Need of an efficient route to enable faster and more accurate meter GPS data collection Need of connecting mains with meters, meters using service laterals to establish network connectivity
Project Overview z z z z
Route Development from Geocoded Meter addresses Field Data Collection with QA/QC Post Processing Data to sub-foot accuracy and R Rework k Constructing Service laterals
Route Development z z z
z
DCSE Geocoded Customer Billing Addresses Divided the meters into service villages Service villages were further divided i t realizable into li bl and d efficient ffi i t books b k (or ( routes) Divided the routes among DCSE DCSE’ss 12 GPS teams
Field Data Collection z
z
z
z
DCSE chose sub-foot sub foot accuracy capable Trimble’s GeoXH handheld for its data collection DCSE developed a custom application to help the field crew collect points and verify addresses Lasers were used in places where GPS signals were weak or where the meters were nott accessible ibl QA/QC at multiple levels helped the team catch error as soon as they were committed
Post Processing and Rework z z
z z
DCSE chose h Pathfinder P hfi d Office Offi for f post processing i DCSE’s QA/QC involved looking at statistical data DOP values, values as well as National Mapping Accuracy Aerials Points that did not meet the stringent accuracy criteria were re-collected per a rework plan DCSE used RTK instruments for collecting those that were in the rework plan
Constructing Service Laterals z
z
z
DCSE constructed d service i laterals l l for f those meters that were approved in the Q /Q QA/QC DCSE developed a custom application and also looked through asbuilts for constructing the service laterals A final check was made that all the billing g addresses had a corresponding p g meter associated connected to the mains
Anomaly Handling z
z
DCSE used PMI’s methodology to manage scope, schedule, budget and issues Separate routes were developed for meters that were difficult to find
Measuring Success z
IRWD has since been using the Meter GPS points to visualize Billing System data: z
Historical usage data to identify potential conservation issues
What Next for IRWD z z
Develop on-going GPS procedures for new meters Develop applications to leverage new data
Questions? Please contact us at: Scott Williams ([email protected]; 949-453-5584) Haritha Vendra ([email protected]; (hvendra@dcse com; 949 949-465-3417) 465 3417) Shil Niyogi ([email protected]; 949-465-3424)
