Twice a year, the Tacoma Water Electrical team visits 400 Cathodic Protection Test Stations to take readings. These readings were done by hand in a notebook and then manually entered into an Access database back at the office. This data was then ported to Excel and visualized with an unwieldy table and graph. Using GIS, we revamped this process to allow workers to use Survey123 to enter readings directly into their phone or computer in the field. These readings are automatically sent to the server and processed daily using a Python script that updates a Geocortex Map and an ESRI Dashboard that the supervisor can easily analyze.
This presentation will dissect the journey to create and implement this new process and cover topics like:
Linking Survey123 to existing datasets Visualizing season to season data along linear assets Handling attachments created in Survey123 Programming with ArcGIS API for Python Visually Stunning Charts using Plotly Programmatically Entering Data into SAP Asset Management System