Where's My Water? Using ArcGIS server, ArcGIS Online, Python scripting and SQL reporting to get the Water department and the Finance department in sync!

Site Archive
You are viewing a static copy of the 2013 Sunriver Conference website archived on December 11, 2013. To view current Northwest GIS User Group events and news visit nwgis.org.

Some people don't pay their water bill on time. On the day that those folks get their water turned off, little did they know there was a mad scramble behind the scenes to track whose water was off, whose needed to be turned on, and whose didn't. GIS to the rescue! This presentation shows how the City of Bellingham used ArcGIS Server map services, ArcGIS Online web maps, iPads and mobile editing, a shared status map, and SQL reporting tools for live web-based reporting to coordinate efforts for a smooth day. Job effort hours were reduced 40%, Finance staff reported a 100% reduction in stress levels, and the finance supervisor reported going from juggling stressed employees schedules to no longer even noticing when shut off days happen! All work was done using existing licensing, free tools, and Esri web templates. No additional cost was incurred. We will demonstrate how easy it is to build a web application using standard Esri templates with small modifications and free SQL reporting tools for web reports.

Presenter(s): 
Ann Stark, GISP
Biography: 

Ann is a GIS Analyst at the City of Bellingham. She received her M.S. in Geography at Oregon State University and has 20 years of experience in natural resource and government applications of GIS. Her interests include automating GIS tasks with Python and cartography. She was a technical editor of the recently published "Programming ArcGIS 10.1 with Python Cookbook" and blogs about python related things at GISStudio.wordpress.com. Ann is also an active member of the GIS community, coordinating local user group meetings and is the current President of the WAURISA. You can find her on twitter at @StarkAnn.

Room: 
Homestead 3
When: 
October 17, 2013 - 2:00pm - 2:30pm
4.42857
Your rating: None Average: 4.4 (7 votes)