Looking for Patterns through Mapping Historical MFT Projects

Blog_Looking_for_Patterns_through_Mapping_Historical.bmp

The annual process of identifying the most critical locations for
resurfacing projects is challenging. Unfortunately, there is never a
shortage of roads in need of improvement, but always a lack of funding
to cover the whole list. In an effort to make better informed decisions
on how to use Motor Fuel Tax (MFT) funds, the Village of Lincolnshire
decided to review its history for possible patterns. By comparing each
year’s work, Public Works staff will be asking, “Are there any stretches
of road that we have repeatedly resurfaced in a short period of time?”
Rather than continuing to spend limited resurfacing funds to put a
proverbial bandage over a bigger issue, the Village hopes to rule these
locations out of the pool for MFT funding. Instead, these roads would be
cataloged as better candidates for reconstruction.

To answer this question visually, the Public Works intern reviewed
paper files and compiled a table of completed MFT projects dating back
to 1980. This table was then mapped out in GIS to visually represent
street segments that have been resurfaced. A graded color code was used
to denote the year of resurfacing, with older projects in red and recent
projects in green. While this analysis has not yet been completed for
the whole Village, there are already locations emerging as possible
candidates for more comprehensive repairs. By pulling these streets off
of the master list, the Village hopes to make better use of public funds
by identifying roads that would benefit the most from resurfacing.

Looking for Patterns through Mapping Historical MFT Projects

Blog_Looking_for_Patterns_through_Mapping_Historical.bmp

The annual process of identifying the most critical locations for
resurfacing projects is challenging. Unfortunately, there is never a
shortage of roads in need of improvement, but always a lack of funding
to cover the whole list. In an effort to make better informed decisions
on how to use Motor Fuel Tax (MFT) funds, the Village of Lincolnshire
decided to review its history for possible patterns. By comparing each
year’s work, Public Works staff will be asking, “Are there any stretches
of road that we have repeatedly resurfaced in a short period of time?”
Rather than continuing to spend limited resurfacing funds to put a
proverbial bandage over a bigger issue, the Village hopes to rule these
locations out of the pool for MFT funding. Instead, these roads would be
cataloged as better candidates for reconstruction.

To answer this question visually, the Public Works intern reviewed
paper files and compiled a table of completed MFT projects dating back
to 1980. This table was then mapped out in GIS to visually represent
street segments that have been resurfaced. A graded color code was used
to denote the year of resurfacing, with older projects in red and recent
projects in green. While this analysis has not yet been completed for
the whole Village, there are already locations emerging as possible
candidates for more comprehensive repairs. By pulling these streets off
of the master list, the Village hopes to make better use of public funds
by identifying roads that would benefit the most from resurfacing.