GIS assists in maintaining Village alleys

Blog_GISassistsinmaintainingVillagealleys.png

During the major snowstorm of February 2011, the Village of Norridge
Public Works staff needed to start plowing the alleys so that residents
could get their vehicles out of their garages. Unfortunately, the
amount of snow prohibited staff from plowing them. The Village wanted
to send notices to all residents along the alleys to assure them that
they would be cleared of snow as soon as possible. The village did not
have a current list of the addresses along the alleys and asked the GIS
department to create a list that could be added to the village’s CTY
Reverse 911 system.

First, the village staff, using aerial imagery and local knowledge,
highlighted all the alleys within the village limits. Then, all the
addresses with access to the alleys were added to a specific table.
This table was then added to the village’s notification system allowing
the village to contact just residents who live on the alleys to let them
know of any specific events that only concern them. By using GIS, the
village was able to quickly select all the residences that were attached
to the alleys and add their addresses as a group, therefore eliminating
the need to pick out each individual address anytime a notification had
to be sent out.

GIS assists in maintaining Village alleys

Blog_GISassistsinmaintainingVillagealleys.png

During the major snowstorm of February 2011, the Village of Norridge
Public Works staff needed to start plowing the alleys so that residents
could get their vehicles out of their garages. Unfortunately, the
amount of snow prohibited staff from plowing them. The Village wanted
to send notices to all residents along the alleys to assure them that
they would be cleared of snow as soon as possible. The village did not
have a current list of the addresses along the alleys and asked the GIS
department to create a list that could be added to the village’s CTY
Reverse 911 system.

First, the village staff, using aerial imagery and local knowledge,
highlighted all the alleys within the village limits. Then, all the
addresses with access to the alleys were added to a specific table.
This table was then added to the village’s notification system allowing
the village to contact just residents who live on the alleys to let them
know of any specific events that only concern them. By using GIS, the
village was able to quickly select all the residences that were attached
to the alleys and add their addresses as a group, therefore eliminating
the need to pick out each individual address anytime a notification had
to be sent out.

GIS and tracking garage sales

Blog_GISandtrackinggaragesales.png

Whenever a resident of the Village of Norridge decides to have a
garage sale, they are required to register for a permit from the village
and pay a specific fee. The Village, in turn, keeps a record of all
the garage sales for a year, only allowing a resident to hold three
sales a year. The Village requested that the garage sale information,
(location and dates), be made available to the public on the village
website. The GIS department was tasked with creating a map that would
show the garage sale information and be easily updated.

First, a table was created that would house all the garage sale
information needed for the website map. The table was created using
Microsoft Excel and could be easily edited by village staff. Then, by a
process called “geocoding”, a series of points were created
representing the location of each garage sale from the most up to date
table. Finally, the points were converted into a format provided by
Google called “KML”. In this format, the points could be loaded into
Google Maps added as a link to the village website. When a resident
clicks on the link, Google Maps opens with any upcoming garage sale
locations. By using GIS, the village was able to create an interactive
map on their website providing residents with the most current garage
sale information.

GIS and tracking garage sales

Blog_GISandtrackinggaragesales.png

Whenever a resident of the Village of Norridge decides to have a
garage sale, they are required to register for a permit from the village
and pay a specific fee. The Village, in turn, keeps a record of all
the garage sales for a year, only allowing a resident to hold three
sales a year. The Village requested that the garage sale information,
(location and dates), be made available to the public on the village
website. The GIS department was tasked with creating a map that would
show the garage sale information and be easily updated.

First, a table was created that would house all the garage sale
information needed for the website map. The table was created using
Microsoft Excel and could be easily edited by village staff. Then, by a
process called “geocoding”, a series of points were created
representing the location of each garage sale from the most up to date
table. Finally, the points were converted into a format provided by
Google called “KML”. In this format, the points could be loaded into
Google Maps added as a link to the village website. When a resident
clicks on the link, Google Maps opens with any upcoming garage sale
locations. By using GIS, the village was able to create an interactive
map on their website providing residents with the most current garage
sale information.

Blackboard Connect Address Review

Blog_BlackboardConnectAddressReview.jpg

The Village of Norridge has a reverse 911 system called Blackboard
Connect, that’s purpose is to send out a mass phone call, text or email
as long as the village resident is registered. The Village was noticing
that not all residents were receiving notifications and wanted to make
sure every resident knew about the program and its benefits. The
Village determined it wanted to send out a mass letter to any resident
not registered in the program and asked the GIS Department for help.

First, a list of all the village addresses currently in the
Blackboard Connect system was gathered and then geocoded (a process in
which addresses are mapped using an existing address database). This
created a list of residents and businesses that had not subscribed to
the service. This then allows the village to send letters to the
unsubscribed detailing the program and why it is beneficial to be part
of the program. The initial plan is to track the unsubscribed addresses
whenever a small notification (e.g. water main break) is sent out and
then send letters based on a smaller service area. By using GIS, the
Village was able to start tracking residents and businesses not part of
their Blackboard Connect system, which means that they would no longer
be missing out on important village notifications if they elected to be
part of the program.

Blackboard Connect Address Review

Blog_BlackboardConnectAddressReview.jpg

The Village of Norridge has a reverse 911 system called Blackboard
Connect, that’s purpose is to send out a mass phone call, text or email
as long as the village resident is registered. The Village was noticing
that not all residents were receiving notifications and wanted to make
sure every resident knew about the program and its benefits. The
Village determined it wanted to send out a mass letter to any resident
not registered in the program and asked the GIS Department for help.

First, a list of all the village addresses currently in the
Blackboard Connect system was gathered and then geocoded (a process in
which addresses are mapped using an existing address database). This
created a list of residents and businesses that had not subscribed to
the service. This then allows the village to send letters to the
unsubscribed detailing the program and why it is beneficial to be part
of the program. The initial plan is to track the unsubscribed addresses
whenever a small notification (e.g. water main break) is sent out and
then send letters based on a smaller service area. By using GIS, the
Village was able to start tracking residents and businesses not part of
their Blackboard Connect system, which means that they would no longer
be missing out on important village notifications if they elected to be
part of the program.

Address auditing using GIS

Blog_AddressauditingusingGIS.jpg

When the Village of Norridge needs to send out a mass mailing to its
residents, the Village typically uses the addresses found in the water
billing database. After each mailing, the Village typically receives a
small amount of letters deemed undeliverable. In an effort to eliminate
the undeliverable letters, the Village decided to go through the
database and make sure all the addresses in the village were accounted
for. They decided to map out the water addresses using a GIS process
called geocoding.

Geocoding is a process of taking a list of addresses and then mapping
them in GIS using an existing addresses database as the reference data.
The list of addresses from the water billing database were first
mapped out against the existing GIS address database. This process
generated a list of all the addresses from the water billing database
that did not match any address in the GIS database. With this list
created, the village went out and field verified the addresses in
question, as well as any returned mail, to determine the actual
addresses. With all the errors corrected, a final master address
database was created that could be used for a number of different
mailings, such as billings, vehicle sticker notifications, and voting
information. By having a master address list, the village is able to
send out mass mailings with a minimal amount of returned mail, in turn
cutting down on wasted time, envelopes, and postage.

Address auditing using GIS

Blog_AddressauditingusingGIS.jpg

When the Village of Norridge needs to send out a mass mailing to its
residents, the Village typically uses the addresses found in the water
billing database. After each mailing, the Village typically receives a
small amount of letters deemed undeliverable. In an effort to eliminate
the undeliverable letters, the Village decided to go through the
database and make sure all the addresses in the village were accounted
for. They decided to map out the water addresses using a GIS process
called geocoding.

Geocoding is a process of taking a list of addresses and then mapping
them in GIS using an existing addresses database as the reference data.
The list of addresses from the water billing database were first
mapped out against the existing GIS address database. This process
generated a list of all the addresses from the water billing database
that did not match any address in the GIS database. With this list
created, the village went out and field verified the addresses in
question, as well as any returned mail, to determine the actual
addresses. With all the errors corrected, a final master address
database was created that could be used for a number of different
mailings, such as billings, vehicle sticker notifications, and voting
information. By having a master address list, the village is able to
send out mass mailings with a minimal amount of returned mail, in turn
cutting down on wasted time, envelopes, and postage.

Tracking parking restrictions

Blog_Tracking_parking_restrictions.png

The Village of Norridge is a densely populated community with many
residential streets running through each neighborhood. Parking
restrictions can vary from street to street, and in some instances, vary
on the same street. The village keeps a list of each parking
restriction in the municipal code, but it can be difficult to track each
restriction based on a list. The village of Norridge requested that a
map be created showing every parking restriction, so that if a resident
had any questions, a village employee could access the information
easily.

By using the restrictions listed in the municipal code, a map was
created highlighting every street that had some sort of parking
restriction. The data was then ported over to the in-house mapping
software, MapOffice™ Advanced, so that it could be easily accessed on
any village computer. The restrictions for each area were stored with
the data so that if a village employee wants to see what type of
restrictions are on a specific street, all they have to do is click on
the section to get the detailed information. By using GIS, the village
has taken information already available, and moved it from a cumbersome
format to one that is far more accessible.

Tracking parking restrictions

Blog_Tracking_parking_restrictions.png

The Village of Norridge is a densely populated community with many
residential streets running through each neighborhood. Parking
restrictions can vary from street to street, and in some instances, vary
on the same street. The village keeps a list of each parking
restriction in the municipal code, but it can be difficult to track each
restriction based on a list. The village of Norridge requested that a
map be created showing every parking restriction, so that if a resident
had any questions, a village employee could access the information
easily.

By using the restrictions listed in the municipal code, a map was
created highlighting every street that had some sort of parking
restriction. The data was then ported over to the in-house mapping
software, MapOffice™ Advanced, so that it could be easily accessed on
any village computer. The restrictions for each area were stored with
the data so that if a village employee wants to see what type of
restrictions are on a specific street, all they have to do is click on
the section to get the detailed information. By using GIS, the village
has taken information already available, and moved it from a cumbersome
format to one that is far more accessible.