Streetlight_Fields_Asset_Management_System.xlsx

This file consists of a data schema and asset management system for the City of Phoenix's streetlight infrastructure inventory. The spreadsheet outlines the database structure for tracking streetlight poles, mastarms, fixtures, and attachments across the city's jurisdiction. The system captures comprehensive pole information including location, ownership status (Phoenix, APS Joint Use, or Private), material composition, height, configuration, and installation details. For mastarms and fixtures, the schema records specifications such as arm length, luminaire type (LED, HPS, or Sodium Vapor), wattage, fixture type (candycane, cobrahead, or shoebox configurations), and ownership classification. The attachment fields enable tracking of assets mounted to poles, mastarms, or fixtures, including small cells and shields, with associated ownership and status information. This asset management system supports the City of Phoenix's streetlight maintenance operations and provides the foundational data structure necessary for managing service delivery across the entire streetlight network.

The data schema directly supports the City of Phoenix's solicitation for streetlight maintenance services, a five-year agreement commencing December 1, 2026, with two one-year renewal options at the City's discretion. The standardized fields within this asset management system enable service providers to accurately inventory, track, and maintain the city's streetlight infrastructure, including poles, mastarms, fixtures, and related attachments. By centralizing asset information including installation dates, project numbers, contractor details, and current operational status, the system facilitates efficient maintenance scheduling, inventory management, and performance monitoring throughout the contract term and any subsequent extensions.