Arcgis Web Apps
I was hired on at the city to migrate data from the old Genemap/Oracle system to Arcgis/PostgreSQL. This includes the entire city's water, sewer, and storm sewer systems stored as lines, points, and polygons.
After completing the migration, my job became upkeep of the data and map creation. Rather than settling for that, I quickly started work on a web application in my free time at work. Below are a few examples.
Main GIS Viewer - Nodejs and Client JS
The main GIS viewer is a web application designed to best replace our old Genemap System. Think Google Maps, but with a focus on underground utilities. End users can query data stored in Postgres, and toggle different feature layers on and off.
For the most part, this process has a GUI to create maps, but their are a lot of limitations with it. The solution is a developer edition of the software.
Web App Builder Dev. Edition is a downloadable Node project that gives you complete control over the code, but can also work alongside already published datasets from Postgres.
Pipe Trace Tools - Python
Some end users need to trace the flow of sewage, either upstream from the plant, or downstream to the plant.
I wrote custom trace tools that take the input pipe number and select pipes up or down stream from the start pipe, then plots them on the map.
The tool works with database queries, by selecting pipes that have an entry in the DB that matches the selected pipe number.
It then uses the Arcgis library to plot them on a map.
Main Break Tool - Python
During a main break event, water crews need to know what valves need shut down and what hydrants need flushed. Similar to the Pipe Trace Tool, the Main Break Tool selects pipes out of the database. However, the criteria is different.
After inputting the main break pipe, the tool finds connected pipes by location and selects them. It continues to spider out until it dead ends at a valve.
It then shows the affected pipes, the valves that need shut off, and hydrants that need flushed on a map.