Improving utility information via the use of a sewer televising program

​The Village of Lincolnshire and the Geographic Information System
Department have been continuously looking for new ways to incorporate
GIS into the daily business processes and work flows conducted by their
departments. The village’s Public Works Department had previously
installed a “Sanitary Sewer Televising” Program and for many years since
its inception has used it to help identify and maintain the condition
of the sewers within the village. The idea of taking this data and
integrating it with the GIS utility databases was an easy decision for
the village since it would improve data efficiency and allow for better
accuracy.

Once the idea of integration was decided upon the GIS Department and
the village’s Public Works Department began to outline a plan for proper
methods of data capture in order to better understand the sanitary
sewer system and what might be needed for this process to work. The
ultimate goal was to use highly accurate base data collected by an
external consultant and update this information on the existing sanitary
sewer system database within the GIS Department. Features that were
identified included residential and commercial service connection
locations, pipe size verification, pipe material identification, pipe
and asset condition and the positional accuracy of sewer mains and
structures.

With all goals outlined in the project’s plan the next phase looked
into the process of how to incorporate the data from the external
consultant into the GIS database. Since many functions of GIS data
creation involve manual work it was determined that best approach was to
use televising reports and cross check these reports the GIS system.
During this process, GIS technicians would review data provided and
update the system while conducting normal data maintenance procedures.
This method enabled crucial data updates and information to be added
into the system as part of a normal work flow. Although the updates
would not occur overnight they would however be integrated into the GIS
database progressively with an eventual output to the end users.

In conclusion, it is easy to see how the functionality of GIS along
with other business processes within the community can be beneficial for
all parties. It is very important for both the GIS Department and
other village departments to continue to seek out opportunities where
they can share important information. GIS is uniquely positioned to
help provide a common platform for data collection, maintenance and
visualization of geographical information and the above project showcase
is a prime example of how existing data from multiple departments can
be shared and used more efficiently.