As part of the ECGISAB I will be trying to post periodically about the projects that I have underway here at The City of Sandusky.
Today I would like to put forward the second largest GIS system that we have currently up and running within the city. The hydrant inventory began as a Fire Department project during my stint as a part-time employee here at the city. 3 guys from Fire agreed to take their phones and a collector app out and pick up as many hydrants as they could. In three days they collected everything you see below:
The above image is where the hydrant inventory stayed until about a week ago. Water Department came to me and said that they were going to start hydrant flushing soon and would like to utilize the GIS capabilities we had talked about months ago. Today we have a beta system in place that is being used in the field as I type this. The workflow looks something like this:
All of this takes under five minutes. The Geode unit connects to the tablet via blue tooth, and is rugged enough to take a beating in the field if surviving a fall off of a truck bumper into the roadway is any indication (my guys are pros at field testing tech, very thorough). The tablet handles all of the apps; Collector, Survey123 and GeodeConnect.
So far it is working remarkably well, and the guys in the field aren't too inconvenienced by it. The first run will be the hardest, there is lots of data to collect, but the consensus is strong that once it is finished it will be well worth it.
I'll dive a little deeper into the inner working from here out. Mostly pictures below:
Collector map view
The Survey123 Form is linked directly from the hydrant pop-up. There is a nifty bit of formatting you can do that will auto populate fields within the form to reduce data entry and error. For this form the hydrant ID number auto populates to tie the records.
I will eventually need to restructure the hydrant point file schema to better reflect the workflow for the guys. There has also been a request for a maintenance ticket related table. Just goes to show that a health application/system is always evolving to fit the needs of the user.
I am happy to answer and questions about the structure or share resources with anyone who might want them .
Thanks for reading!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.