Asset Management

Make Confident Decisions on Community Assets with Asset Management

CDPBlogPhoto2

A Rising Interest in Emergency Event Support

So, Here’s a Story (Map)

Cheers! Mundelein Employs Interactive Mapping to Manage Liquor Licenses

​​
​​​​​​

Problem-Solving 

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 MapOfficeInteractive 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 agrahovac@mgpinc.com. 

 

Author: Mike Falkofske, GIS Specialist in Mundelein 

Crystal Lake Teams up with GIS to Fight Fires in Lakewood

Crystal Lake Fire Rescue Department

Is it possible to save resources, improve community services, and help a fellow neighbor all at the same time? If you ask Crystal Lake, the answer is an enthusiastic “Yes!” 

 

In 2015, Crystal Lake’s neighbor, the Village of Lakewood, was in search of a new fire service provider. That summer, Lakewood approached Crystal Lake with a proposal to enlist the Crystal Lake Fire Rescue Department as the new provider with the caveat that the city would provide more efficient and cost-effective services.  

 

Fighting Fires With GIS 

 

Enthusiastic to help, Crystal Lake turned to its GIS program for assistance with the endeavor. To better understand if the city would be able to effectively provide this service, the fire department collaborated with the city’s GIS program to answer the following question: Can the Crystal Lake Fire Rescue Department respond from each station to all areas of Lakewood more effectively than the village’s current provider?  
 

Evaluating Distance Response Times

 

Crystal Lake’s GIS team created an emergency drive response time map to analyze how long it would take emergency responders to travel from the station to different areas of Lakewood. The team discovered that Crystal Lake is able to respond faster than the current provider. Upon reviewing various resources, Crystal Lake’s bid, and the drive time analysis, Lakewood chose to unite with the Crystal Lake Fire Rescue Department as the community’s new fire protection service provider.  

 


A New Year, A New Beginning 

 

January 1, 2016 marked the first official day of the new fire protection partnership. To ensure that the two communities made a successful transition sans service interruptions, the GIS Program developed a plan to facilitate the changeover. The GIS team and the fire department joined forces to use drive time analysis to map out ideal routes from each station to locations throughout both communities. The results and maps were shared with the staff to inform them of the new coverage area, and fire protection services were set into motion. 

By leveraging GIS and coordinating with the fire department, Crystal Lake and Lakewood combined resources and ideas to provide fire services to both communities. This collaboration enabled each community to receive efficient and effective services while saving time and resources. 

 

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 agrahovac@mgpinc.com. 

 

Author: Alexandria Caputo, GIS Specialist in Crystal Lake 

 

Business Intelligence Launches in Northbrook

 

The Village of Northbrook has recently launched the MapOffice Web Access tool called Business Intelligence.  Business Intelligence is a tool that allows users to filter and display live data from community or custom databases. 

Three attributes of Business Intelligence, filtering, visualization, and live data, make it a very powerful tool.  Business Intelligence allows users to visualize data on a map by plotting that data by address or XY coordinates.  Many times, community databases or software do not have great ways to display the wealth of data they hold.  Business Intelligence helps solve this problem by connecting to those databases and displaying the data on MapOffice so users can gain further incite about the data or look for trends.

When looking for trends it is sometimes necessary to manipulate how you view the data.  Business Intelligence permits the user to filter the data by date and/or a field within the data.  For example, Northbrook has set up a connection to a custom home foreclosure database that allows users to filter foreclosures by date and the foreclosure status.  Now the user can narrow the data that is displayed to show only what they are interested in.

Finally, Business Intelligence offers live connections to the databases.  This can be extremely powerful as users can view and analyze data held in the database as it is updated without having to wait for data to be uploaded to MapOffice.

The Village of Northbrook looks forward to taking advantage of this useful and powerful tool by connecting to community databases and software such as FireHouse, an ERP system, and many others to come.