Streamlining Workflows with GIS
Streamlining Workflows with GIS
Alan Lee, Opelika Utilities Grant Mullins, GISi April 28, 2009
Agenda • Introduction • Challenges • Solutions • What’s Next?
Opelika, Alabama
Introduction – Site & Situation • Opelika, Alabama – Railroad Town – Population: 30,000 – Customers: 13,000 – Near Auburn University – Home of RTJ’s Grand National Golf Course
Opelika Utilities • System Overview – Governed by Board of Directors (not a city department) – Created in 1948 – Revenues generated solely by water sales
– 2 Surface Water Treatment Plants – 155 Miles of Water Main – 14,000+ Water Meters – 2,000 Fire Hydrants – 8,000 Valves
Opelika Utilities GIS Overview •
GIS Staff – Project Manager, Alan Lee • Project Coordinator • Project Inspector – GPS Operator
•
Utilizing mapping & GIS technology for over 15 years
•
Initially utilized Microstation, Geographics and Oracle Database – Why not ESRI?
•
Decision Time – Landbase file was provided by others • Map was moved and stretched to match NAD 83
– Decided to Start Over
Challenge: Starting Over • What GIS Platform – ESRI Selected – Why? • Industry Standard • Used by most governmental and related agencies • Training readily available
• Can we do this alone? – Consultant – Other agencies • Landbase data – City of Opelika – Lee County • Other utility data
The Vision… • Pilot Project – Gain the knowledge and tools to complete our entire network – A to Z: Data capture thru geometric network • GPS all water facilities – Meters, valves, fire hydrants, water mains, tanks, etc • Utilize automated data model and database • Set-up network analysis to isolate mains for maintenance – Which valves need to be shut – Have ability to trace the affects of isolation » Who will not have water » What fire hydrants will be out of service
Solution: Custom Data Model • GISi created a custom data model – Conducted interviews with GIS staff – Started with ESRI’s water utility data model – Added needed feature classes: extended the standard model • Water model is available online
Solution: Custom Data Model
Solution: GPS Workflow • Utilized Leica System 1200 GPS (Rover) – Continuous operating reference station (CORS) – Sub centimeter accuracy, no post processing
• GISi created customized code list within the Leica unit – Provided on-the-fly data entry – Required entry of critical field data
• Real-time GPS data uploaded to geodatabase – Uploaded utilizing ESRI’s Data Interoperability Tool
Solution: Data Translation - ETL • ETL tools were created and applied to transform GPS data into the standard model GDB
Solution: Meter Reading • Wireless meter reading system – New technology results in loss of knowledge
• GIS & GPS captures the knowledge before it is lost – Critical and time sensitive
Solution: GPS Workflow
Solution: System Integration • Connections to other departmental data sources – – – –
Billing system Hydraulic model Hydrant flow data Water quality data
Result: Success • Teamwork – – – –
Opelika had the domain and business knowledge GISi had the GIS and technical skills GISi provided the tools, we did the work Teamwork resulted in success
Result: Additional Data • Discovered ways to utilize archived GPS data
Result: External Data • Leveraged relationships with other agencies – Watershed – Basemap – Planning
Development Projects
Watershed Hazards Assessment
Impervious Surface Analysis
Record Drawing Access
Water Quality Sample Sites
Watershed Stream Buffers
Service Areas
Comprehensive Plan
Challenge: Hydrant Flow Testing • Hydrant Flow Test Data – Needed by Opelika Utilities • Data used in Hydraulic Modelling • Data provided to engineers
– Collected by Opelika Fire Department • Paper-Based • Slow Turnaround • Inconsistent Entry
Solution: Web GIS • Enterprise GIS Implementation – ArcGIS Server – ArcSDE • Web Based Flow Entry • Mobile Based Flow Entry
Web Solution • Web application created for flow data entry – ArcGIS Server 9.3 Application • Rich Internet Application • Built on the ArcGIS API for Flex • Custom web service • SQL Based Security
– Flow Entry Module • Data entered and stored into SQL database • Realtime availability to web and mobile users
– Routine Maintenance Module • Maintenance requests entered and stored into SQL database
Web Based Flow Entry
Mobile Solution • Mobile Application for Flow Entry – ArcGIS Mobile Application • Windows Mobile application • Real time connectivity via Cell Network • Using same custom web service as Web App
– Flow Entry Module • Data entered and stored in SQL database • Edits are pushed back continuously
– Routine Maintenance Module • Maintenance requests can be entered in field
Mobile Solution
What’s Next • Cityworks Implementation • Water Plant GIS Modeling • Water Quality Mobile Application • ???
Acknowledgements • Opelika Utilities – Alan Lee & Staff – (334) 705-5527 – [email protected]
• Geographic Information Services, Inc. – Booth 218 – Grant Mullins – (205) 941-0442 ext.35 – [email protected]
Questions?
Alan Lee, Opelika Utilities Grant Mullins, GISi April 28, 2009
Agenda • Introduction • Challenges • Solutions • What’s Next?
Opelika, Alabama
Introduction – Site & Situation • Opelika, Alabama – Railroad Town – Population: 30,000 – Customers: 13,000 – Near Auburn University – Home of RTJ’s Grand National Golf Course
Opelika Utilities • System Overview – Governed by Board of Directors (not a city department) – Created in 1948 – Revenues generated solely by water sales
– 2 Surface Water Treatment Plants – 155 Miles of Water Main – 14,000+ Water Meters – 2,000 Fire Hydrants – 8,000 Valves
Opelika Utilities GIS Overview •
GIS Staff – Project Manager, Alan Lee • Project Coordinator • Project Inspector – GPS Operator
•
Utilizing mapping & GIS technology for over 15 years
•
Initially utilized Microstation, Geographics and Oracle Database – Why not ESRI?
•
Decision Time – Landbase file was provided by others • Map was moved and stretched to match NAD 83
– Decided to Start Over
Challenge: Starting Over • What GIS Platform – ESRI Selected – Why? • Industry Standard • Used by most governmental and related agencies • Training readily available
• Can we do this alone? – Consultant – Other agencies • Landbase data – City of Opelika – Lee County • Other utility data
The Vision… • Pilot Project – Gain the knowledge and tools to complete our entire network – A to Z: Data capture thru geometric network • GPS all water facilities – Meters, valves, fire hydrants, water mains, tanks, etc • Utilize automated data model and database • Set-up network analysis to isolate mains for maintenance – Which valves need to be shut – Have ability to trace the affects of isolation » Who will not have water » What fire hydrants will be out of service
Solution: Custom Data Model • GISi created a custom data model – Conducted interviews with GIS staff – Started with ESRI’s water utility data model – Added needed feature classes: extended the standard model • Water model is available online
Solution: Custom Data Model
Solution: GPS Workflow • Utilized Leica System 1200 GPS (Rover) – Continuous operating reference station (CORS) – Sub centimeter accuracy, no post processing
• GISi created customized code list within the Leica unit – Provided on-the-fly data entry – Required entry of critical field data
• Real-time GPS data uploaded to geodatabase – Uploaded utilizing ESRI’s Data Interoperability Tool
Solution: Data Translation - ETL • ETL tools were created and applied to transform GPS data into the standard model GDB
Solution: Meter Reading • Wireless meter reading system – New technology results in loss of knowledge
• GIS & GPS captures the knowledge before it is lost – Critical and time sensitive
Solution: GPS Workflow
Solution: System Integration • Connections to other departmental data sources – – – –
Billing system Hydraulic model Hydrant flow data Water quality data
Result: Success • Teamwork – – – –
Opelika had the domain and business knowledge GISi had the GIS and technical skills GISi provided the tools, we did the work Teamwork resulted in success
Result: Additional Data • Discovered ways to utilize archived GPS data
Result: External Data • Leveraged relationships with other agencies – Watershed – Basemap – Planning
Development Projects
Watershed Hazards Assessment
Impervious Surface Analysis
Record Drawing Access
Water Quality Sample Sites
Watershed Stream Buffers
Service Areas
Comprehensive Plan
Challenge: Hydrant Flow Testing • Hydrant Flow Test Data – Needed by Opelika Utilities • Data used in Hydraulic Modelling • Data provided to engineers
– Collected by Opelika Fire Department • Paper-Based • Slow Turnaround • Inconsistent Entry
Solution: Web GIS • Enterprise GIS Implementation – ArcGIS Server – ArcSDE • Web Based Flow Entry • Mobile Based Flow Entry
Web Solution • Web application created for flow data entry – ArcGIS Server 9.3 Application • Rich Internet Application • Built on the ArcGIS API for Flex • Custom web service • SQL Based Security
– Flow Entry Module • Data entered and stored into SQL database • Realtime availability to web and mobile users
– Routine Maintenance Module • Maintenance requests entered and stored into SQL database
Web Based Flow Entry
Mobile Solution • Mobile Application for Flow Entry – ArcGIS Mobile Application • Windows Mobile application • Real time connectivity via Cell Network • Using same custom web service as Web App
– Flow Entry Module • Data entered and stored in SQL database • Edits are pushed back continuously
– Routine Maintenance Module • Maintenance requests can be entered in field
Mobile Solution
What’s Next • Cityworks Implementation • Water Plant GIS Modeling • Water Quality Mobile Application • ???
Acknowledgements • Opelika Utilities – Alan Lee & Staff – (334) 705-5527 – [email protected]
• Geographic Information Services, Inc. – Booth 218 – Grant Mullins – (205) 941-0442 ext.35 – [email protected]
Questions?
