GIS Integrates Sign Inventory into Business Intelligence

The Village of Winnetka Public Works Department has long been heavily involved with the village’s Geographic Information Systems (GIS) department to create new project ideas. One such idea was to take a newly updated sign inventory and bring it into Business Intelligence for staff viewing. Previously, Village staff would refer to paper maps to view the all of the signs. This was functional but could be much improved with the help of GIS and MapOffice™. 

Using Business Intelligence, staff is able to view the sign inventory by category, making it easier to view and understand. This limits what is seen based on the request of the staff member.  It was decided to break down the sign inventory into these types and condition categories:

  •  All Type

  •  Ornamental – OK Condition

  •  Ornamental – Poor Condition

  •  Regulatory – Fair Condition  

  •  Regulatory – OK Condition

  •  Regulatory – Poor Condition

  •  School Area – Fair Condition

  •  School Area – OK Condition

  •  School Area – Poor Condition

  •  Service – Fair Condition

  •  Service – OK Condition

  •  Street Name – OK Condition

  •  Street Name – Poor Condition

  •  Unknown – Fair Condition

  •  Unknown – OK Condition

  •  Unknown – Poor Condition

  •  Warning – Fair Condition

  •  Warning – OK Condition

  •  Warning – Poor Condition

 

Now staff can view data based on the criteria selected. This gives staff an ease of viewing and accessing data.