The Chicago Metropolitan Agency for Planning (CMAP) helps local governments plan land use and transportation initiatives to promote sustainability. CMAP’s GO TO 2040 comprehensive plan is designed to achieve this by providing recommendations on transportation, human capital and governance. One way in which CMAP strives to improve the livability of communities is through their Soles and Spokes Plan which encourages citizens to walk and bike.
The Village of Tinley Park, IL was asked to provide information about their existing walking and biking facilities for integration into CMAP’s Bikeway Information System (BIS). In order to respond to CMAP’s request, the Village had to fill out a questionnaire and mark a map with any changes or updates to the bikeway system.
After consulting with Geographic Information Systems (GIS), the Village responded to CMAP’s request by structuring bikeway facility data around the questionnaire. Bikeways were drawn using GIS and attributed based on CMAP’s interest in facility type, status, location, and other factors. By relying on GIS, the Village of Tinley Park reduced the time to complete a written response for each bikeway. Data is now stored in a system that is easily accessible and can be queried whenever needed by staff.
Each year the U.S. Census Bureau asks local governments to participate in the Boundary Annexation Survey (BAS). This survey gives the U.S. Census Bureau the most current geographic boundaries of the area the municipality serves. For many, like the Village of Woodridge, IL, it is an excellent opportunity to improve population estimates.
In previous years, this review process was manual, and municipalities used paper and colored pencils to demarcate their boundaries and neighboring borders. They had to note down any annexations, de-annexations, or boundary changes that occurred since the last BAS was conducted.
Today, the Census Bureau encourages digital submissions of BAS materials using Geographic Information Systems (GIS). Instead of listing and drawing modifications by hand, GIS tools are used to quickly identify changes between village boundaries and census boundaries. Using GIS for BAS submissions has benefitted the village in meaningful ways. It’s saved a great deal of staff time and effort, provided richer detail in identifying changes, and ultimately improved the population estimates provided by the Census Bureau.
The Village of Woodridge, IL is asked periodically by Comcast Corporation to verify customer addresses. This is done in accordance with the Municipal Franchise Fee Review, which helps municipalities confirm that they are receiving the proper franchise fees from Comcast.
Working with Geographic Information Systems (GIS), the Village of Woodridge quickly audited the address lists provided by Comcast rather than manually comparing each address to their enterprise management system. GIS compared the village’s address database against two customer address lists provided by Comcast, saving village staff numerous hours of manual review.
Even though the first address list from Comcast included customers who live in Woodridge, annexation dates were missing. The second list of customers could not be identified as being in the village or not. Using GIS, these addresses were mapped and compared against existing locations and annexation information stored in the GIS environment. The results gave Comcast the accurate information they need and provided the village with greater certainty about the franchise fees they receive from Comcast.
In the past the Village of Northbrook, IL has worked with Geographic Information Systems (GIS) to setup a process to help better record and track properties as they move through the foreclosure process. This process involves a monthly review of mailed foreclosure documents and entry of dates into an excel spreadsheet correlating to when a lis pendens or pre-foreclosure notice is filed, when the property is found to be in foreclosure, and finally when the court approves the sale of that property and it is no longer in foreclosure. Previously a static map was created from this information and sent to the Community Development and Planning Department and Police for use in their workflows. With the new capabilities provided by Business Intelligence connections in the village’s browser-based mapping application, MapOffice™ Web Access, this process has been streamlined and provides increased access to the associated foreclosure information.
To allow for this connection to occur, GIS created a database connection that allows Village Staff to query the information stored in the foreclosure spreadsheet in MapOffice™ by property status and date. These query results are then displayed by location in MapOffice™ Web Access. Using Business Intelligence, community staff has increased access to the information being tracked within the excel spreadsheet, where before they could only see the latest date and status for a specific property. They also able to view the individual dates and gain a better understanding of the history behind a property. Also, because the legal documents are scanned and stored by address within the village’s document management environment, a custom hyperlink is included with each entry which staff is able to click on to directly find and view the specific documents associated with the dates displayed on the map for verification or more information.