Sanitary sewer smoke testing program

​The Village of Deerfield relies on accurate utility information to
assist the community staff with their daily activities just like any
other local government does. The Village of Deerfield Public Works
Engineering Department is working with the RJN Group to conduct a
Sanitary Sewer Smoke Testing program throughout the village. This
program is being used it to help identify and maintain the condition of
the sanitary 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.

This project involved three parties including the Engineering
Department, GIS Department, and RJN Group. The scope of the project
included providing RJN with GIS data so that their staff could use for
creating field data reports and track the program. The data was also
used to provide base information that can be reviewed and updated when
field reports are returned back into the office. Another important
aspect of this project was reviewing and updating a legacy Community ID
system used for Sanitary Manholes within the village. These numbers are
used by village staff and are included on all reports. It was
important to make sure the GIS data included these numbers and was able
to be updated when needed.

Once all the parties had the required data, the Sanitary Sewer Smoke
Testing Program continued, and field reports were collected and prepared
by RJN Field Crews. These reports would then be sent to the GIS
Department for updating. Once all reports for the week were in place,
the GIS Department then updated any necessary items within the system
and uploaded updated back to RJN for immediate use. This process worked
well, as the flow of data and updates went smoothly.

In conclusion, the above is a brief example how multiple departments
worked together to communicate beneficial information to all parties
involved. GIS was able to provide data for RJN Field Crews to assist in
their field operations, and at the same time RJN while conducting the
Smoke Testing Program was able to provide field updates back to the GIS
office for updating the data. This program is currently ongoing and is
proving to be a valuable solution for helping to maintain and update
this important GIS utility database.