Using GIS to Audit Franchise Fee Addresses

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.