

How to Standardize Asset Naming for Public Works Departments
If your hydrant list, pump station register, and street-sign inventory all use different labels for the same kind of asset, you already know why learning how to standardize asset naming is a priority. Inconsistent names turn a CMMS search into a scavenger hunt, break GIS joins, hide duplicate records, and make GASB, FEMA, and insurance reports harder than they need to be. This guide walks public works administrators, municipal IT managers, and utility supervisors through a practical method to design, test, and enforce a naming convention that field crews will actually use.
A standardized name is not a pretty label. It is a durable identifier that stays stable when an asset is rebuilt, moved on a map, or handed from streets to water. Get the convention right once and every work order, inspection, and capital plan that follows becomes easier to trust.
Why Inconsistent Asset Names Cost Municipalities Real Money
Most cities and counties did not start with a single asset register. Water inherited pump IDs from a paper log. Streets numbered signs by intersection. Parks used “old mower” and “new mower.” Finance used vendor invoice descriptions. When those lists land in one platform, you get collisions: two “Pump 3” records, a hydrant called FH-12 in GIS and HYD-0012 in maintenance, and a lift station that exists under three spellings.
That noise shows up as:
- Duplicate work orders on the same asset
- Missed preventive maintenance because the PM schedule is tied to the wrong ID
- Incomplete history when a pump is replaced but the name changes
- Audit findings when capital asset reports cannot be reconciled to the field inventory
- Slow 311 response because the citizen request cannot be matched to a mapped asset
ISO 55000 treats an asset as any item with potential or actual value to the organization. If two records describe the same item under different names, the organization cannot realize that value. Standardized naming is the foundation of a usable asset tracking system.
Principles of a Durable Municipal Naming Convention
Before you invent codes, lock five design rules. Every later decision should pass these tests.
1. Unique. No two assets share an ID, ever. The ID is the primary key in the CMMS, GIS, and finance system.
2. Stable. Do not encode attributes that change: condition, assigned crew, current contractor, or “new vs. old.” Those belong in fields, not in the name.
3. Human-readable. A foreman on a tablet at 6 a.m. should recognize WAT-LS03-PMP-002 faster than a 32-character database GUID.
4. Machine-parsable. Use a fixed number of segments, a single delimiter (hyphen), uppercase letters, and zero-padded numbers so lists sort correctly.
5. Organization-wide. Water, wastewater, streets, fleet, parks, and facilities should share the same skeleton so a public works director can report across departments. Esri and utility asset-management practitioners warn against embedding only one department’s logic if the same platform will serve the rest of the city.
Do not use geodatabase ObjectIDs, Excel row numbers, or vendor serial numbers as the official asset ID. Those values are not portable and break when you migrate systems.
Step 1: Audit What You Already Have
You cannot standardize what you have not seen. Export every current list: CMMS, GIS layers, finance capital assets, paper binders, and the “master” spreadsheet on a shared drive.
Group records by type and answer:
- How many distinct asset classes exist (hydrants, valves, pumps, catch basins, signs, vehicles, buildings)?
- Which unofficial abbreviations already work in the field (MH, FH, CB, LS)?
- Where do collisions occur?
- Which IDs are already printed on tags, as-builts, or SCADA screens?
Keep abbreviations that crews already say out loud. Inventing a new three-letter code that nobody uses is how conventions die in the first month.
Document the audit in a one-page inventory of classes and estimated counts. That page becomes the scope of your first naming standard.
Step 2: Choose a Segment Structure
The most reliable municipal pattern is:
DEPT-LOCATION-TYPE-SEQUENCE
| Segment | Purpose | Example codes | Rules |
|---|---|---|---|
| Department / system | Which utility or function owns the asset | WAT, WW, STM, STR, FLT, PRK, BLD | 2–3 letters, city-wide list |
| Location / facility | Plant, basin, street segment, or site | LS03, WTP, MAIN, YARD | Fixed-length where possible |
| Type | What the asset is | PMP, VLV, HYD, MH, CB, SGN, TRK | Controlled vocabulary |
| Sequence | Distinguishes identical assets | 001, 002 | Zero-padded, never reused |


Examples:
- WAT-LS03-PMP-002 — Water, Lift Station 3, Pump 2
- WW-WTP-BLW-001 — Wastewater treatment plant blower 1
- STM-DIV4-CB-014 — Stormwater District 4 catch basin 14
- STR-MAPLE-SGN-008 — Maple Street sign 8
- FLT-YARD-TRK-012 — Yard fleet dump truck 12
Shorter agencies can drop a segment. Larger utilities can add a subunit (WAT-LS03-WET-PMP-002). Do not exceed what a field user can type or read on a tag.
A parallel descriptive name can sit in a separate “Asset Name” field (Lift Station 3 – Wet Well Pump 2) so reports stay readable without stuffing sentences into the ID.
Step 3: Build the Code Library Before You Rename Anything
A naming convention fails when people invent codes on the fly. Publish a controlled list:
- Approved department codes
- Approved location codes (every lift station, plant, yard, park, and district)
- Approved type codes (one code per class; pick “PMP” or “PUMP,” not both)
- Numbering rules (start at 001, pad to three digits, do not recycle numbers when an asset is retired)
- Forbidden characters (spaces, slashes, commas, apostrophes)
- Case rule (uppercase)
Give each type a one-line definition so “tank,” “vessel,” and “vat” do not proliferate. If two words mean the same thing, pick one.
This library is the governance artifact. It belongs next to your data-governance policy, not in a forgotten email.
Step 4: Separate the ID from Attributes That Change
Put these in fields, never in the ID:
- Condition rating
- Criticality
- Manufacturer, model, serial
- Installation date, cost, useful life
- Assigned crew or contractor
- Photo, barcode, RFID
- GIS coordinates and layer
Novo Solutions covers the recommended municipal field set in What Asset Fields Should Municipalities Track?. GASB 34 needs historical cost, in-service date, and depreciation data; those values must survive a rename of the display label. Keep the official ID boring and permanent.
Step 5: Test the Convention on a Real Sample
Apply the draft standard to 25–50 assets from different departments: a pump station, a hydrant run, a fleet unit, a park amenity, and a building system.
Check for:
- Duplicate generated IDs
- Names longer than a 20–24 character tag
- Codes that field staff cannot pronounce
- Sort order problems (PMP-9 appearing after PMP-10)
- GIS label clutter at typical map scales
Revise the library, then freeze version 1.0. A rushed convention that you roll back six months later is more disruptive than a slower, tested launch.
Step 6: Map, Tag, and Migrate Without Breaking History
Standardizing names is a data project, not a weekend rename.
- Create the new ID as a new field first. Keep the legacy ID as “Former ID.”
- Print or engrave physical tags only after the digital record is approved.
- Update GIS labels from the same source of truth as the CMMS.
- Point open work orders and PM templates at the new ID before you hide the old one.
- Archive retired IDs; do not reuse them.
Municipalities that cataloged hydrants, valves, and curb inlets in the field—as Otsego Utilities did after moving to NovoGov—succeeded because geo-location and photos traveled with a single record, not because they renamed assets in a vacuum. See the City of Otsego case study for how a small utilities staff centralized asset details without losing field context.
Perry Township used the same platform to pull siloed spreadsheets into one register with GIS, which is exactly when a shared naming skeleton pays off. Their case study shows why replacement cost and work history only become useful after the asset identity is stable.
How Software Should Enforce the Standard
A written SOP is not enough. Your maintenance software should:
- Require the official ID format at record creation
- Block reserved characters
- Auto-suggest the next sequence number for that type and location
- Support barcode or QR lookup so crews do not type the ID
- Keep an audit trail of ID changes
- Sync the same ID to the map, work order, inspection, and inventory record
NovoGov (the Novo Solutions operations platform) is built for this municipal pattern: one asset record, map location, maintenance history, and mobile update. When field staff can photograph the tag and complete the work order on-site, the naming convention stops being an office rule and becomes how the job gets done.
CTA: If your current lists still live in disconnected spreadsheets, request a Novo Solutions demo and walk through a sample asset register with your own hydrant or fleet data.
Governance: Who Owns the Convention
Assign a data steward (often the GIS coordinator or CMMS administrator) and a small cross-department board: water, streets, fleet, finance, and IT.
The board:
- Approves new type codes
- Reviews exception requests
- Reissues versioned updates of the code library
- Trains new hires and contractors
- Audits a sample of new records each quarter
Without an owner, “temporary” names become permanent within a season.


Common Mistakes to Avoid
- Encoding GPS or street address in the ID (locations get annexed, renamed, or surveyed again)
- Using leading zeros in one department and not in another
- Changing the ID when a pump is replaced instead of updating manufacturer fields
- Letting contractors invent project-specific names that never get converted
- Building a 10-segment industrial code for a 12-person public works shop
- Standardizing only water while streets keeps a separate scheme in the same database
Keep the convention as simple as the smallest department can follow. Complexity can be added later with attributes and hierarchy, not with longer IDs.
Rolling Out Across Departments
Start with one high-visibility class—hydrants or fleet—where physical tags already exist. Prove the process, then expand.
A practical 90-day sequence:
- Weeks 1–2: Audit and draft library
- Weeks 3–4: Pilot 50 assets and train two crews
- Weeks 5–8: Migrate the pilot class and print tags
- Weeks 9–12: Add the next two classes and lock validation rules in software
Publish a one-page “how we name assets” card in every shop and in the mobile app help. Short beats a 40-page manual that nobody opens.
Measuring Whether Standardization Worked
Track a few operational indicators, not just “percent of assets renamed”:
- Duplicate ID count (should fall to zero)
- Work orders missing a valid asset link
- Time to find an asset from a citizen request
- PM completion rate on the newly standardized class
- Audit exceptions related to capital asset identity
When names are clean, reports to council and applications for grants stop arguing about which pump is which.
Conclusion: Make the Name the Quiet Backbone of Operations
Learning how to standardize asset naming is less about clever codes and more about agreement: one unique, stable, readable ID per asset, shared by every department that touches the record. Audit first, design a short segmented ID, publish a code library, keep changing attributes out of the name, test on real equipment, then enforce the format in your CMMS and GIS.
Public works teams that do this stop hunting for “the other Pump 3” and start managing condition, cost, and service levels. That is the difference between an inventory and an asset management system.
Contact Novo Solutions for a demo and see how NovoGov can hold a standardized register, map, and work history in one place your crews will use.
FAQ section
What is an asset naming convention in public works?
It is the documented rule set for assigning every municipal asset a unique, stable, human-readable ID—typically department, location, type, and sequence—used consistently in CMMS, GIS, and finance.
Should GPS coordinates be part of the asset ID?
No. Coordinates belong in GIS fields. Embedding location in the ID creates problems when surveys are updated, streets are renamed, or assets are relocated.
How long should a municipal asset ID be?
Keep official IDs short enough to print on a tag and type on a phone, generally under 20–24 characters with a fixed number of hyphenated segments.
Do we rename an asset when we replace a pump?
No. Keep the same ID for the asset position or maintainable item and update manufacturer, serial, install date, and cost fields so history stays attached.
How does standardized naming support GASB 34?
A unique ID lets finance reconcile capital assets to the operational register so historical cost, in-service date, useful life, and depreciation stay tied to the correct physical item.
Who should own the naming standard?
A data steward plus a small cross-department board (utilities, streets, fleet, finance, IT) should approve codes, exceptions, and quarterly audits.
Can small towns use the same structure as large utilities?
Yes. Use fewer segments if needed, but keep the same rules: unique, stable, uppercase, hyphenated, zero-padded, and enforced in software.





