Tax Exempt Property Analysis


The Village of Mundelein, IL needed a more efficient way of
identifying Tax Exempt properties, with the ultimate goal being too
quickly view and query all the tax exempt properties in a given area.
They also wanted to see all tax exempt properties classified into
categories such as public, private, and worship. Knowing the location
of these properties is vital for the Village when developing Tax
Increment Finance (TIF) Districts or Special Service Areas (SSA).

The Geographic Information Systems (GIS) Office used Lake County Tax
Assessor data to locate tax exempt properties and classify them into
categories. The first product created was a paper map of tax exempt
properties used for review. The second product was a custom map layer
created for display in the village’s interactive mapping application,
MapOffice™. This custom layer increased the functionality of the data,
as a user can type in an address in the application and see all the tax
exempt properties in the area around that address.

By having the GIS Office develop a tax exempt property layer in the
village’s GIS applications, the Village of Mundelein is saving employee
time. Employees no longer have to query an area, property by property,
or call the Township office for more information on a property. They
can turn on the custom layer in the MapOffice™ application and
immediately see the location of all the tax exempt properties in the
village limits and use the property classification information to
determine which organization that property belongs to.​

Urban Speed Districts


​Effective July 1, 2013 Illinois law enforcement agencies were required
to identify tickets issues for speeding 25 MPH over the posted limit in
an “Urban District”. The Police Department contacted the GIS Office
about creating a layer that defined the Urban District within Mundelein.
There was concern that not all of The Village would be included within
the defined are of an Urban District. Since the new law requires
officers issuing citations to note if the violation occurred in an urban
area, it was important understand which parts of the village might be
outside of an urban area.
The Police Department asked the GIS
Office to define urban districts by using the statutory definition which
reads: (625 ILCS 5.0/1-214) is: The territory contiguous to and
including any street which is built up with structures devoted to
business, industry or dwelling house at intervals of 100 feet for a
distance of a quarter of a mile or more. Using this definition GIS
Office focused locating areas where the buildings were with 100 feet of
each other. These buildings were used to select properties and the
properties were merged into an urban district area. Then the area was
reviewed to remove anomalies created by parks or other open areas.
The final product showed all the areas of the Village that met the
definition of an urban area. The next step was creating a wall map so
that people could clearly see which areas of The Village where in or out
of an Urban District. By contacting the GIS Office the Police
Department received an accurate product that helps officers understand
which parts of Mundelein are outside of an Urban District.

Empowering users to edit utility data in the field


Providing users with the ability to edit utility information in the
field is a powerful tool for keeping utility information current. The
Village of Mundelein, IL is using two options to provide employees with
the ability to update utility data.

The first approach is using a web based mapping application developed
by the Geographic Information System (GIS) Consortium called MapOffice™
Web Access. This application allows users to select utility features
and update the information directly in their web browser. At this time,
the village uses this tool primarily to update sewer jetting and
installed date information. There are planned updates to the
application that will allow users to move existing utilities or add new
utilities as needed. After this update to the application, it is
expected that Public Works employees will be able to update the utility
data on their own after small in house construction projects, thereby
improving data maintenance and better optimizing the data update

A second approach, which is currently in development, is integrating
GIS data directly with their sewer televising application, called
Granite XP. In this application, video files are linked to GIS data.
Furthermore, the information for each pipe and structure is displayed
and can be edited directly in the applications interface. So, if a user
is televising a line, and they notice that a pipe’s material is marked
incorrectly in the GIS data, they can make the necessary change right
there while in the field.

Both methods mentioned above allow users to update information
without going the time consuming process of marking up a printed map and
delivering it to the GIS Office. Using these methods of data
management empowers users to be more proactive in maintaining the
utility information and gives them the confidence that edits are being
captured correctly.

Estimating response times for Insurance Services Office (ISO) accreditation


Every three years Fire Department protection is evaluated by the
Insurance Services Office (ISO). Insurance companies use the ISO ratings
to help set property insurance premiums for local government
communities. One of the items evaluated by ISO is the five minute
response time from stations. Previously the response time areas were
created by using response time locations from CAD to select properties.
This was a good process, but it was time intensive as everything was
manually extracted and selected.

After watching a Geographic Information System (GIS) Consortium
webinar about the ESRI Network Analyst Extension, the Village of
Mundelein Fire Department asked the GIS Office about the feasibility of
creating five minute response areas using routes based on a street
network. The GIS Office enhanced an existing street network by adding
speed limits to help better simulate how a vehicle might respond during
an actual incident response. They then calculated a time, or cost, for
a vehicle to traverse each street network segment. Using the
calculated routes, a five minute time area from both fire stations was
created. A second map showing five minute response times into Mundelein
from neighboring fire stations was also created. This map displays
coverage areas not included in a five minute response area from a
Mundelein fire station.

Using the ESRI Network Analyst Extension, the GIS Office quickly
created a route that could be used to create fire station response
areas. This saved the Fire Department many hours of manual labor.
Furthermore, now that a response time layer has been created, it can be
used in future projects such as inspection routing or even future ISO


Tracking Sewer Backups


 The Public Work Wastewater division traditionally recorded sewer backups
in an Excel worksheet. This was useful quick reference as to how many
backup occurred in a year but it was difficult to determine if there
were any groupings of sewer backups. One way to reduce the number of
sewer backup is jetting the sewer mains. Jetting is a process where
pressurized water is used to cut through debris that has stuck to the
pipes. The Wastewater division had been tracking sewer main jetting by
highlighting jetted sewer mains on a paper map. This was not a good
system and they asked the GIS Office if sewer main jetting could be
maintained in GIS so that maps and the MapOffice application could be
easily updated.

The GIS Office was tasked to create a map of sewer backups and second
map of sewer jetting. The GIS Office also suggested creating a third
map that would show the sewer backups overlaid ontop of the sewer
jetting layer. This would show where sewer backups have occurred and
where the Village had performed maintenance to reduce the chance that
these backup would reoccur.

The Sewer backup map reaffirmed what the Wastewater Division had
suspected. The backups were randomly distributed and showed that there
were no mains with a high number of reoccurring incidents. The sewer
backup locations with sewer jetting locations map showed that Village
had performed maintenance in some of the areas with reported backups but
that there were several other areas that should be targeted for future
jetting projects. By using GIS to create visual references the
Wastewater Division could easily see where sewer backup issues were
located and if they were jetting the correct areas of the Village to
correct these issues. 

Enhancing a street sweeping report


The Director of Public Works tasked the Street Department with
developing a presentation of the street sweeping schedules for a
presentation to the Village Administration. The Street Department
created a good report describing the street sweeping cycles but the
Director of Public Works felt that graphic displays of the schedule
would be more useful. Therefore they decided to create a series of
maps showing street sweeping zones and various street sweeping
maintenance scenarios.

The first map is a Street Sweeping Zone map that shows the location o
f the seven work zones used by the Village to manage when areas of the
Village are swept. The GIS Office created a paper map that is used with
a formal report. The second map was also a paper map but focused on
the downtown area and showed what streets were swept every Friday during
the summer. These streets are swept more frequently during the summer
to ensure the downtown area has a clean look. The final map was a
storm structure street sweeping maintenance map. This was a village
wide map that showed which streets get swept before a major storm event.
Some streets are more prone to flooding and require sweeping to remove
debris so that grates do not get clogged with debris during heavy rain

By using data already stored in the GIS the Village was able to
quickly produce maps to enhance the report. The maps provided important
visual information to clarify the information in the report.

Planning for a Heavy Rain event


During the week of April 14, 2013 – April 20, 2013The National
Weather Service was forecasting 4-6 inches of rain for the greater
Chicago area. Luckily for the Village of Mundelein most of the heavy
rain missed the Village. However, in anticipation of the potential
impact of heavy rains Village of Mundelein began planning for monitoring
flooded streets. The Director of Public Works asked the GIS Office to
create a map that would assist the Street Superintendent with monitor in
storm water infrastructure during the heavy rain event.

The Streets Department requested that GIS created a Strom Water
Maintenance Map. This map divided the Village into two sections. Each
section was monitored by a Village Employee driving in a truck. As
different issues were observed, street flooding, streams overflowing,
the location would be marked on the map. Any actions taken to correct
the flooding, such as clearing an inlet, would also be marked on the
map. The map also showed streets that tend to flood frequently so
employees would know which streets to check regularly.

Asking the GIS Office to create a map provided the Public Work
Streets Department with a valuable tool for monitoring heavy rain
events. It provided any easy way to track new events and ongoing events
as they were reported by Village staff. In the past the Superintendent
would have met with employees after the event and reviewed the log
books. Now the Superintendent can see events as they are occurring and
thus make more informed decisions when responding to new incidents.

Managing tree planting using GIS


The Village of Mundelein received a grant that provided the money for
132 trees this Spring. The new plantings will replace Ash trees and
other trees that were removed last summer. The Superintendent of
Streets wanted an easier to provide planting location information to a
contractor. He also wanted to track the progress of plantings to ensure
no locations were missed.

In previous years the planting were tracked using an Excel worksheet.
This method was inefficient because even though planting locations
could be sorted by address. It was difficult to review streets that
were in close proximity to each other. The Superintendent of Streets
enquired if the GIS Office could make a map showing the location of each
tree planting. He also requested that a table of planting information
for each for each tree be added to the map. The most important part of
the map would be adding consecutive numbers for each tree planting
location that correlated to a numbered recorded in the table. The GIS
Office quickly created this map by locating all the trees using
addresses. The numbers were assigned starting with the lowest numbers
in the northeast and snaking back and forth so that the highest numbers
ended up in the southeast corner of the Village. The table was then
exported back to a table so that each tree record had a number that
matched a location on the map.

By using the power of GIS the Superintendent of Streets received a
project that he could send to contractor who is planting the trees. The
Superintendent also has map and table to track the new planting

Water Sampling Station Analysis


The State of Illinois Environmental Protection Agency (IEPA) requires
all water utilities to collect monthly samples for coliform testing.
Although coliform itself is not necessarily a lie threatening bacteria,
the presence of coliform could indicate a contamination issue in the
water system. The number of sampling stations required for each utility
is dependent on the number of customers served by that water utility.
The IEPA also requires information on the location of Stage 1 Stage 2
Disinfectant Byproduct Sampling stations.

The IEPA requires an annual map or report of a community’s coliform
testing site, storage facilities, and water entry points. Every winter
the Village of Mundelein updates their water sampling and asset location
map. This map has several purposes. The first being a visual display
of the water entry points for each of the three pressure zones and the
location of storage tanks for each of the pressure zones. The second
purpose is to show how the coliform sampling locations are evenly
distributed throughout the Village and that the Stage 2 Testing sites
are located as far away as possible from each pressure zone entry

Because the Village maintains it’s utility information in a GIS
system. It is easy to quickly create a map the entry points, tanks and
other infrastructure. The coliform sampling stations are listed by
address and easy to overlay on the map. Without GIS the Village would
not be able to efficiently create a this map for the IEAP.

MapOffice™ Advanced Web Access deployed


One of the key factors of success for a GIS program is providing
access to GIS data for all users. With the deployment of MapOffice™
Advanced Web Access (MOAWA) the Village now has that capability. MOAWA
is browser based application that allows users to quickly locate
information and create maps or reports. Unlike traditional GIS
software, MOAWA contains simple tools that require on 15-30 minutes of
training for most people to master them.

Some of functionality includes a find and Go tool that lets users
find a location by address, street name, intersection or even a landmark
name. Once a user finds the location they are looking for they can use
other tools such as Parcel summary that creates a report showing
garbage collecting day, election information, and even provides a link
to the County Assessor page. Another tool displays all the utility
systems maintained by Village. It allows users to click on utility
features to collect more information or even print a utility map. The
Create address list task quickly creates an address list using selected
properties. This list can then be exported to an Excel and used to
create a mailing list

These tools are only a few examples of the many ways MOAWA allows
user to interact with the GIS data. It is anticipated using MOAWA will
improve the efficiency of some workflows. Equally important MOAWA
will open up access to GIS for people who might not have used it in the