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.