Water meter mapping project

Blog_Water_meter_mapping_project.png

Water meter billing can be a significant source of revenue for any
local government, so ensuring that the billing address information is
valid and complete is critical to the success of collecting all the
necessary fees. A key component to maintaining these utility accounts is
assuring they are up to date and cross-checked with other sources,
which can often be difficult and time-consuming. To assist with
validating the account locations for each billing record, the City of
Des Plaines Public Works department asked the city’s GIS department to
map out all the utility billing addresses in order to get a better
understanding of where potential address problems exist.

All utility billing records for the city are stored in software
called Penemation, so the first step in mapping each record was to
export the desired information into a GIS compatible format, such as
Excel. Once in this format, the billing addresses were mapped in the
city’s GIS software using the city’s comprehensive address database. By
comparing the billing addresses against the validated GIS addresses,
common issues that can cause fee collection problems were discovered.
These include incorrect street name spellings, invalid addresses, or
missing information. Having all the water meter locations visible on a
city-wide scale allowed the Public Works department to review all
records collectively and create a list of those addresses that require
further investigation.

Developing a comprehensive and visual method for reviewing water
meter billing locations provided a quick and efficient method for the
city to highlight problem account location, as well as locate addresses
that did not have a billing account on record. Using this information,
the city can develop a plan to help resolve these accounts and,
potentially, increase revenue through improved billing management.

Water meter mapping project

Blog_Water_meter_mapping_project.png

Water meter billing can be a significant source of revenue for any
local government, so ensuring that the billing address information is
valid and complete is critical to the success of collecting all the
necessary fees. A key component to maintaining these utility accounts is
assuring they are up to date and cross-checked with other sources,
which can often be difficult and time-consuming. To assist with
validating the account locations for each billing record, the City of
Des Plaines Public Works department asked the city’s GIS department to
map out all the utility billing addresses in order to get a better
understanding of where potential address problems exist.

All utility billing records for the city are stored in software
called Penemation, so the first step in mapping each record was to
export the desired information into a GIS compatible format, such as
Excel. Once in this format, the billing addresses were mapped in the
city’s GIS software using the city’s comprehensive address database. By
comparing the billing addresses against the validated GIS addresses,
common issues that can cause fee collection problems were discovered.
These include incorrect street name spellings, invalid addresses, or
missing information. Having all the water meter locations visible on a
city-wide scale allowed the Public Works department to review all
records collectively and create a list of those addresses that require
further investigation.

Developing a comprehensive and visual method for reviewing water
meter billing locations provided a quick and efficient method for the
city to highlight problem account location, as well as locate addresses
that did not have a billing account on record. Using this information,
the city can develop a plan to help resolve these accounts and,
potentially, increase revenue through improved billing management.