Street Lighting Clean Up Projects

ICS aligned records in municipalities' utility asset bases after street lighting equipment was added and deleted from existing infrastructure supply inventories.

Innovative Contracting Services has handled multi-dimensional data & database management projects over the years and is ready to offer highly skilled support in any facet of this area from which your company may benefit. Deeply versed in all aspects of Systems, Applications, and Products (SAP) database management procedures and protocols, your team will be filled with confidence by what ICS brings to your organization. The database management projects we have collaborated on include private and public sector ventures with high degrees of complexity both qualitatively and quantitatively. Let ICS alleviate the pressures on your time, personnel, and financial resources by helping fulfill this vital role.

Project Details 


ICS contracted with several municipalities that had purchased street lighting infrastructure equipment, including poles exclusively used for lighting, from the utility companies. Delegated to accurately assess and update the utilities’ asset bases, ICS painstakingly managed the equipment records to inactivate street lighting equipment related to assets sold.


  • Utilizing SmartMap and Google or Bing Maps as resources, determined a pole’s equipment profile beyond street lighting attached.
  • Cross-referenced SAP structure list to visual references to determine what equipment should remain active as utility owned on each pole.
  • Deactivated equipment records and Functional Locations as required.


  • Over 6,000 poles and structures reviewed to determine ownership and accuracy of attachments.
  • Ascertained asset management records accurately reflected active equipment still under the ownership of the utility, with all other records inactivated.
  • Alternate label FLOCs were created for street lighting only equipment and records moved accordingly.