How to Create a Streetlight Asset Map for Your Municipality

The most effective streetlight asset map shows every fixture in your jurisdiction — with its location, type, condition, maintenance history, and responsible district — on a single live map that field crews can access on a tablet and managers can review from the office without waiting for a weekly report.

If your municipality tracks streetlight assets in a spreadsheet with addresses, a legacy GIS file that only one person can open, or a paper inventory that hasn't been updated since the last major installation project, you're operating without the spatial visibility that makes proactive maintenance possible and reactive repairs efficient. That's why public works departments ask: how do we build a streetlight asset map that connects every fixture to its location and records — and keeps that connection accurate as maintenance happens every day?

With Atlas, a streetlight asset map is a live, browser-based platform where every fixture is a geographic point with attached records, accessible to field crews in the field and administrators in the office from the same source of truth.

Here's how to build it step by step.

Why a Streetlight Asset Map Is the Foundation of Effective Maintenance

You can't maintain what you can't find — and a spreadsheet address is not the same as a map location visible to a crew in a bucket truck at night.

A streetlight asset map isn't a GIS project — it's the operational foundation that makes every maintenance decision faster, better-informed, and more accountable.

Step 1: Import Your Existing Streetlight Inventory

Atlas makes it easy to bring your current records into a live map:

Prepare a CSV export from your existing inventory source — spreadsheet, work order system, or GIS database — with columns for a unique fixture ID, street address or GPS coordinates, fixture type, wattage, installation year, and current condition
Geocode address-based records by importing your CSV into Atlas, which matches street addresses to precise geographic coordinates automatically
Import GPS coordinate records directly if your inventory already includes latitude/longitude columns, placing each fixture at its exact surveyed position
Flag incomplete records where addresses are missing, coordinates are inaccurate, or fixture type is unknown — these become the gaps your field team will fill during the next walk-down
Review the imported points on the aerial imagery base map, confirming that fixtures appear on the correct street segments and not offset onto adjacent parcels or wrong blocks

Your entire existing inventory, however imperfect, becomes a starting point on the map rather than a list in a file.

Step 2: Add Fixture Attributes and Classification

Next, enrich each fixture point with the data that makes the map operationally useful:

You can classify streetlights across multiple dimensions:

Fixture type — cobra head, decorative post-top, wall-mount, pedestrian-scale, highway luminaire — determining maintenance approach and replacement parts
Light source technology — HPS, MH, LPS, or LED — critical for energy management, retrofit planning, and expected service life
Pole material and height — wood, steel, aluminum, concrete; pole height in feet — relevant for maintenance equipment requirements and structural inspection scheduling
Mounting configuration — mast arm, direct mount, pendant, bracket — affecting the maintenance procedure and fall protection requirements
Ownership and billing — municipal-owned, utility-owned, developer-installed, BID district — determining who is responsible for repair costs and who initiates work orders
District or zone assignment — which maintenance district, crew route, or management area each fixture belongs to, enabling filtered views by jurisdiction

Each attribute becomes a filter layer that lets managers and crews see only the relevant subset of fixtures for any given task.

Step 3: Set Up Condition Status and Visual Styling

To make fixture condition immediately readable on the map:

Define your condition categories — functioning, reported out, under repair, flagged for inspection, scheduled replacement, decommissioned — as the status values every fixture carries
Style each status with a distinct color — green for functioning, red for out, orange for flagged, grey for decommissioned — so the map is a condition dashboard readable at a glance
Add a priority tier — routine, urgent, emergency — as a secondary classification for fixtures needing attention, so crew dispatch prioritizes correctly
Configure icon differentiation by fixture type so cobra heads, decorative fixtures, and highway luminaires display as distinct symbols rather than generic dots
Set up automatic visual alerts for fixtures approaching scheduled replacement age so aging inventory is visible on the map before failures occur

A well-styled asset map communicates condition across thousands of fixtures in a single view that no report or spreadsheet can match.

Step 4: Attach Maintenance Records to Each Fixture

To turn point locations into complete asset records:

Link work order history to each fixture so every past service event — bulb replacement, ballast repair, pole inspection, damage report — is accessible from the fixture's map panel
Attach installation documentation including original specs, warranty information, and contractor records for fixtures where this information exists
Upload inspection photos so the current physical condition of each fixture is visible without a site visit
Record outage reports from utility companies, 311 systems, or direct public submissions linked to the affected fixture's map location
Log maintenance costs per fixture so lifecycle cost analysis can identify high-cost assets that are candidates for early replacement rather than continued repair

Each fixture becomes a complete asset file — not just a point on a map but a documented record of everything that has happened to it.

Step 5: Configure Access for Field Crews and Management

To put the right map in front of the right people:

Create a field crew view optimized for phone and tablet use showing fixture location, current status, assigned work orders, and access notes without the administrative detail relevant only in the office
Build a management dashboard view showing portfolio-level condition summary, open work orders by district, and fixtures overdue for inspection or replacement
Set up district-filtered views so each maintenance supervisor sees only the fixtures in their assigned area without the visual noise of the full municipal inventory
Configure public reporting integration where citizen outage reports create new flagged records linked to the nearest fixture location on the map
Enable offline field access for crews working in areas with poor cellular coverage, allowing work order updates to sync when connectivity is restored

Also read: How to Track Streetlight Outages and Repairs in Real Time

Step 6: Keep the Asset Map Current with Every Work Order

Now that your streetlight asset map is live:

Update fixture status at the completion of every work order so the map reflects current condition rather than last week's data
Add new fixtures to the map at the time of installation, before the new assets enter operation, so inventory completeness is maintained from day one of each new installation
Remove or reclassify decommissioned fixtures when poles are removed or converted so the active inventory count remains accurate
Conduct an annual field verification comparing the map inventory to physical conditions in each district, correcting positions, updating conditions, and adding any fixtures missed in earlier surveys
Integrate with your work order system so status changes in the CMMS automatically update the Atlas map without requiring manual double-entry

Your streetlight asset map becomes the living record of your entire lighting infrastructure — accurate, accessible, and always current.

Use Cases

Creating a streetlight asset map matters for:

Municipal public works departments managing thousands of streetlight fixtures across a city or county who need a spatial view of asset condition that no spreadsheet or report can provide
Utility companies with streetlight service agreements who need to track customer-owned fixtures, manage outage response, and document maintenance history for billing and compliance
Business improvement districts managing decorative streetlight infrastructure in commercial zones who need to track fixture condition and coordinate maintenance with a municipality
Transportation departments responsible for highway and arterial lighting who need to separate their fixture inventory from municipal residential lighting for separate maintenance budget tracking
Engineering firms conducting streetlight audits for municipalities transitioning from aging HPS inventory to LED, who need a map-based tool for field data collection and condition reporting

It's essential for any organization responsible for streetlight infrastructure where knowing what you have, where it is, and what condition it's in is the prerequisite for everything else.

Tips

Start with your highest-density areas when building the initial inventory — downtown, commercial corridors, and school zones generate the most outage complaints and benefit most immediately from map-based visibility
Use GPS coordinates rather than addresses wherever possible — a streetlight at the corner of two streets matches two address records, creating ambiguity that GPS coordinates eliminate
Photograph every fixture during the initial field survey rather than planning a separate photo documentation phase — photos taken during walk-down cost almost nothing in additional time and create an invaluable baseline condition record
Assign a fixture ID that's independent of location — an ID that encodes the street address breaks when fixtures are moved or streets are renamed; a sequential unique ID survives all physical changes
Integrate with your 311 or service request system from the beginning so public outage reports flow directly into the asset map rather than requiring manual transfer from a separate database

A comprehensive streetlight asset map in Atlas transforms infrastructure management from reactive to proactive — giving every stakeholder the spatial visibility to make better decisions about a city's most visible public service.

Streetlight Asset Management with Atlas

Managing streetlight infrastructure requires knowing exactly what you have, where it is, and what condition it's in — across potentially thousands of fixtures spread across an entire jurisdiction.

Atlas gives you the browser-based asset mapping platform to build and maintain that knowledge without enterprise GIS complexity.

From Spreadsheet to Live Map

You can:

Import your existing fixture inventory CSV and geocode addresses to precise map locations in minutes
Enrich fixture records with type, technology, age, ownership, and district classification for complete asset data
Publish field and management access views from the same map so every team member sees the right information for their role

Also read: How to Build a Streetlight Inventory Database with a Map

Asset Visibility That Drives Better Decisions

Atlas lets you:

See the condition of every fixture across your entire jurisdiction in a single map view that updates as crews complete work orders
Filter by district, fixture type, condition, or age to identify patterns and prioritize maintenance resources efficiently
Export complete asset data at any time for budget reporting, grant applications, and capital improvement planning

That means no more "we think we have about 4,000 fixtures" — and no more discovering that a district has been reporting higher outage rates because its fixtures are ten years older than average.

Streetlight Asset Mapping at Any Scale

Whether you manage 500 fixtures in a small town or 50,000 across a major city, Atlas scales to your inventory without requiring specialist GIS skills.

It's streetlight asset management software — built for the public works professional who needs operational visibility, not a GIS degree.

Build Your Streetlight Asset Map with the Right Tools

Every maintenance decision starts with knowing where your fixtures are and what condition they're in. Atlas gives you the live, spatial asset map that makes that knowledge accessible to everyone who needs it.

In this article, we covered how to create a streetlight asset map — from importing your inventory and classifying fixtures to condition styling, record attachment, and keeping the map current through daily operations.

From initial inventory mapping to ongoing maintenance management and capital planning, Atlas supports the complete streetlight asset lifecycle — all from your browser.

So whether you're building your first digital streetlight inventory or replacing a legacy system that can't be accessed in the field, Atlas helps you move from "we have a spreadsheet somewhere" to "here's the live map" faster.