The City of San Maria’s Department of Utilities Water Resources Operation and Maintenance Section was interested in improving their field crews efficiency by making information on disabling/enabling customers water service connections available online.
Information on the status of the City’s water service connections were being maintained in a legacy system by the City’s Department of Administrative Services. The City had the capability of querying this system every thirty minutes, extracting address information for needed turn offs/ons, and sending this information to a Microsoft SQL table.
Per the City's requirements, VESTRA developed an application that geocodes the addresses within this Microsoft SQL table and presents the results in an ArcGIS Online feature service making it available online and via mobile devices. This has enabled field crews the ability to access and edit the information from their smart phones utilizing Esri’s Collector for ArcGIS application.