So, Here’s a Story (Map)

Optimizing Tree Planting in Park Ridge

 

January 2017 Tree Planting

Most Public Works and Forestry departments know the magnitude and attention to detail that must be paid to tree plantings each year. What locations should we plant trees in? What is the most efficient route to take? How do we stay within budget and get the project done in a timely manner?  

 

In the spring and fall of each year, the City of Park Ridge must answer these questions to coordinate and manage tree planting in the parkway.  The planting process is conducted by contractors and can include 100 to 300 trees, depending on the fiscal year and money availableBecause of the vast number of trees paired with the extensive planting area, coordinating and managing an efficient tree planting project can be a difficult task.  

 

How Trees Are Planted 

In the past, planters worked off only a map of the planting locations, without any directions regarding how to order the plantings. This was problematic for Village staff needing to work on trees following a tree planting, as staff would not know where trees had been or were going to be planted next. GIS was able to simplify and streamline this process by creating a map of the optimal route planters should follow. This helps Village staff to better manage the planting process and know which locations to visit. 

 

Efficiency, Collaboration, and Technology 

The route is created using a tree location address list provided by Public Works and ESRI’s Network Analyst extension, a tool shared within the GIS Consortium. The mapped addresses are ordered to reduce mileage and drive time in the overall route.   

 

These tasks work together to create a systematic and efficient workflow for the planters and city staff, reducing the time and effort spent on coordinating the bi-yearly tree planting. To further aid in management of the tree planting process, the time it takes to plant a tree could be incorporated into the analysis. This would give all involved a better idea of how many trees should be expected to be planted per day. Such a process and workflow is not limited to planting trees but could be created for other projects as well.   

 

Contact a specialist to discuss ways in which this process could be applied to improve a workflow! 

 

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: Louise Hahn, GIS Specialist 

 

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.