How can communities determine the balance between having too many and too few liquor licenses in a certain area? Many communities are faced with this challenge. If they allow too many businesses to sell alcohol, they risk stretching their policing resources too thin. If they allow too few, they risk alienating future business. Mundelein recently tackled this concern with an innovative new way to visualize their liquor license data.
A Traditional Approach
Like many communities, Mundelein used to track businesses with liquor licenses in a spreadsheet, an excellent approach for managing information, but not for visualizing it. For instance, a spreadsheet only allows the user to view an address, but not the physical location of the property. So the user might accidently issue a liquor license to a business that is too close to a prohibited location, such as a religious building. To prevent situations like this one, the community decided to innovate their liquor license tracking process.
A Better Understanding
To improve upon the current situation, Community Development and GIS collaborated to discuss mapping the location of liquor licenses in the Village utilizing an interactive map called a custom overlay, which is available in . Interactive maps are more visually appealing than PDF maps, are easier to understand, and are quick to update. By taking this new approach, Mundelein improved its liquor license tracking process and utilized a new way to view pertinent information.
Continuing to Improve
Although the Liquor License custom overlay is a great step in visualizing this data, Mundelein desired to further improve their workflow efficiency. The community then asked about adding a search function to locate businesses by name. Community Development and GIS developed an ArcGIS Online map that shows the location of all the businesses with liquor licenses and has a search tool to locate businesses by name. This innovation gave the community a new way to search for businesses and visualize data that was previously tucked away in a spreadsheet.
Benefits to the Community
Both the custom overlay and the ArcGIS Online map improved the ability of users to see how many licenses are in a commercial district or at a specific property such as a mall. Further, the maps are only visible to community staff, so all data is secure. Mundelein progressed from viewing data in a spreadsheet to working with it in an interactive map that significantly enhances the community’s liquor license review process.
Take the Lead
Discover, innovate, and collaborate with the GIS Consortium today! Contact your community’s GIS Specialist to discuss project opportunities, Consortium services, and GIS.
If you would like to learn more about this initiative or if you have questions, please contact firstname.lastname@example.org.
Author: Mike Falkofske, GIS Specialist in Mundelein
A forum of managers in local government in northern Illinois, the Leadership Roundtable, came together in early 2015 to generate a list of common problems they could solve together. As the list of project ideas grew one of them quickly floated to the top of the list. As a result, the managers prioritized a project that would enhance service by improving communication between residents and the municipality.
Next, the managers authored a charter document that outlined clear outcomes for the project, and then selected their top Thought Leaders to participate on an innovation team who would work together to achieve the desired outcome.
In 4 months’ time the team…
- used the innovation process
- wrote user stories
- issued a Request for Information (RFI)
- short-listed five vendors
- conducted interviews and demonstration
- created a presentation
- presented their recommendation to the managers of the Leadership Roundtable.
The team’s recommendation was to partner with a solution provider they found would achieve the outcomes of the charter best. The recommendation to implement a Citizen Service Request system has been accepted by 14 communities and we expect that number to keep growing. The communities are now in the process of negotiating collectively with the vendor of choice to obtain the best possible outcomes. Implementation of the solution will begin in the first quarter of 2016.
We will accomplish more together than we will on our own!
During a fire event, a sprinkler system is a key ally in battling the blaze and minimizing the damage. The City of Park Ridge, IL understands this firsthand and requires any new construction be equipped with a fire sprinkler system. While a long-time standard for commercial structures, this now includes residential buildings.
Sprinkler information was traditionally tracked in a spreadsheet. However, locating a particular address wasn’t an easy or robust process, and not all staff members had direct access. As a result, the Geographic Information Systems (GIS) Office was asked to devise a more effective way of delivering this information to staff.
GIS created a MapOffice™ Web Access Business Intelligence connection that references residential sprinkler locations throughout the city. Now when staff want to determine whether or not a residential sprinkler is installed at a home, all they do is type in an address when the connection is on. They can then click a point on the map and the spreadsheet information attributed to that address can be quickly accessed.
This is a great example of how GIS can connect with address-based tabular data and make information immediately accessible to those who need it.