The Town of West Springfield has a unique and diverse array of both natural and man-made features that are impacted by stormwater runoff. From reservoirs to streams, and levees to pumping stations, it is the town's responsibility to convey these waters as cleanly and efficiently as possible to their ultimate destination. Understanding where the water comes from and where it goes is essential in capital planning as well as state and federal compliance. Historically, our GIS data have been limited to just stormwater utility infrastructure. Recently however, our team has been working on manually digitizing water bodies that interconnect with our existing stormwater system. This has given us the ability to trace upstream and downstream through the entire water network--giving our engineers and planning staff the ability to see where the water ultimately came from, and where it ultimately goes. These tracing analyses are available to our team both in the office and in the field--made possible by custom recursive SQL queries.
