Mapping snow sidewalk removal routes

​The Village of Glencoe and the Geographic Information System (GIS)
department have been continuously looking for new ways to incorporate
GIS into projects that assist staff in their daily workflows and
business processes. An opportunity occurred when the Public Works
department called on the GIS department with a request to update and
replace older Snow Sidewalk Removal Maps that are used by staff during
snow removal operations. These maps were to supplement the existing
programs in place which included a comprehensive Snow Removal Route
database along with Salting Routes and associated Trucks.

The public works department provided the GIS department with existing
examples and requested that these books be recreated using GIS so we
can produce a product that can be efficiently maintained, updated, and
distributed. The maps were designed to fit into existing booklets that
included multiple 8 ½” by 11” sheets broken down by 3 main Snow Sidewalk
Removal routes. Each sheet also contained very important information
used by staff including: Work Area Statistics, Mileage, Start and Finish
Times, Unit Numbers, Hour and Time Tracking Statistics, and Date. Each
map sheet was designed to show the portions of the Route and Areas
within that Route. The maps also displayed very important information
including locations and extents of priority sidewalks, normal sidewalks,
and locations of where the actual sidewalk ends.

The conversion of the map was a basic operation, in a sense, which
involved recreating the existing products after the Routes were
developed in the GIS database. Special attention was needed to match
these products as close as possible to avoid conflicts. During this
process a few cartographic tricks were used to carry out the full effect
of the maps. Once a few review cycles were completed the product was
completed and sent to production.

In conclusion, it is easy to see how the functionality of GIS within
the community can be beneficial for all parties. It is very important
for both the GIS department and other village departments to continue to
seek out opportunities where they can share important information. GIS
is uniquely positioned to help provide a common platform for data
collection, maintenance and visualization of geographical information
and the above project showcase is a prime example of how existing data
from multiple departments can be shared and used more efficiently.