Problems & solutions · Business Intelligence Dashboards

Pavement Management Software Problems: The 5 That Cost Real Money, and How to Avoid Them

Pavement Management Software architecture and database illustration showing common problems and fixes.
The short answer

The most expensive failure in this category is unstable segment identity. When the survey vendor's segmentation does not match how you let contracts, and nobody fixes it structurally, every condition survey lands as a fresh snapshot rather than the next entry in a history. You then cannot compare cycles, you cannot calibrate deterioration curves against your own pavements, and you run preventive treatments off somebody else's defaults. A mistimed preventive treatment is the worst spend available in this field because it buys little or no life extension, and a city doing that across a preservation contract every year is losing a meaningful share of the paving budget without a single line item showing it.

Why does a pavement project turn into an asset management project?

The request that gets funded is narrow: defend the paving list. The project that gets scoped six weeks later covers signs, signals, sidewalks, streetlights, work orders and a citizen request portal, because every division head who attends the requirements workshop has something they want in it. This is the most common way a pavement build fails, and it fails quietly. Eighteen months later the department has a competent asset inventory and still cannot answer why Maple Avenue is not on the list.

It happens in pavement specifically because pavement is the only asset class where the decision is contested in public. So pavement carries the political urgency that gets a project approved, and once approved it becomes the vehicle for every other unfunded need in public works.

The fix is a scoping rule written down before the first workshop. This release answers one question: what to pave, in what order, at what cost, under a funding level someone can change on screen. That means segmentation, condition history, deterioration and treatment modelling, a constrained multi year program and a map. Work orders, sign inventories and citizen requests are a later phase with their own budget. Departments that hold that line ship a first release in 12 to 16 weeks. Departments that do not are still in requirements at week 20 and the paving list is still defended from a spreadsheet.

What goes wrong when you load historic condition surveys?

Loading one survey is easy. Loading three surveys from two vendors across nine years and getting a usable history out of them is the real work, and it is routinely underestimated because everyone assumes a condition index is a condition index.

Three things break. Segmentation differs between vendors and sometimes between cycles from the same vendor, because one used your linear referencing scheme and another split at driveways or at surface type changes. Segment identifiers get reused when the GIS layer is rebuilt, so a 2018 segment 4412 and a 2024 segment 4412 are different pieces of road. And the network itself changes: streets are reconstructed, annexed, realigned or vacated, so a straight identifier match across cycles quietly drops the segments that changed most.

The fix is structural and it belongs in the first sprint rather than in a data cleanup phase. Hold a segment identity you own, tied to the GIS centerline and aligned to how you let contracts block to block between cross streets. Every incoming survey is reconciled to that identity through a documented mapping, with a report of what matched, what split, what merged and what could not be resolved. Unresolved segments go to a human, not to a default. Then condition becomes a time series on a stable object and the question of how fast your pavements actually decay becomes answerable, which is the whole point of owning the system.

Why do the GIS and finance integrations break after launch?

Both of these work perfectly in the demo and fail in month seven, for the same reason: they depend on data owned by a team that has no idea your system exists.

The GIS centerline is republished on the GIS division's own schedule. Somebody splits a street at a new intersection, corrects a geometry error, or renumbers a corridor after an annexation. Nothing in that process asks whether a pavement system is keyed to those identifiers, so your condition history fragments overnight and the first symptom is a map with holes in it. The financial system, whether Tyler Munis, BS and A or Springbrook, has the same pattern. A new fiscal year brings a chart of accounts change or a new project numbering convention, and the appropriation link that fed your budget scenarios stops resolving.

The fix has two halves. Technically, never depend on a foreign identifier as your own primary key. Store the external reference as an attribute with an effective date, keep your own identity stable, and run a scheduled reconciliation job that reports differences rather than silently accepting them. Organisationally, get the GIS division named in the project charter and give them a change notification obligation, because this is a coordination failure that engineering alone cannot fix. The same applies to your survey vendor: put the deliverable schema, the segmentation basis and the segment identifier convention in the procurement documents for the next survey, not in an email after the data arrives.

What happens when utility conflicts and ramp obligations are not modelled?

This is the failure that reaches the newspaper. A street is resurfaced in July, and in October the water department opens a trench down the centre of it for a main replacement that sat in their capital plan the entire time. Most cities have a pavement cut moratorium precisely to prevent this, and the moratorium only works if somebody checks it against the paving list before the list is finalised. In a lot of departments that check is a person remembering to ask.

The second uncovered obligation is accessibility. Where a resurfacing project counts as an alteration, curb ramps at the affected intersections have to be brought into compliance, and that cost belongs in the project estimate. When it is not modelled, it arrives as a change order after award, which does not just cost money, it changes which projects were actually affordable in the first place. A program built without ramp costs is a program that will not deliver the mileage it promised.

Both are cheap to build compared with the modelling work around them. Utility and moratorium checking is a spatial and temporal overlap query against capital plans that already exist as GIS layers or spreadsheets, plus a review workflow so a flagged conflict has an owner. Ramp costs attach as a rule on the project estimate, triggered by scope type and intersection count. Confirm the specific triggering criteria with your city attorney or accessibility coordinator, because the determination depends on the work being done and is not a software judgement.

Should you build custom or configure what you already own?

For a real share of readers, the honest answer is configure, and the product to configure is StreetSaver. If you manage under roughly 100 centerline miles, it costs a fraction of a build, produces a defensible network condition index that consultants and peer agencies understand, and leaves budget for crack sealing, which will do more for your network this year than any software. We would tell you that in the first call.

The same applies further up. If your question is condition reporting rather than contested prioritisation, OpenGov Cartegraph is a reasonable purchase and its asset inventory and work order management are genuinely strong. Just do not buy its pavement analysis expecting a multi year constrained optimiser, because that is not what it is. If you are a state agency or a very large network with a modelling specialist on staff, Deighton dTIMS does deterioration modelling and constrained optimisation properly and there is no reason to rebuild it. AgileAssets is sized for state agency asset breadth and behaves accordingly.

Building earns its place when three conditions hold together: the paving program is politically contested, the model has to reconcile with the capital budget and with utility plans rather than living beside them, and you need a public facing answer to why a specific street is not on the list. Those are integration and communication problems, not modelling problems, and they are exactly what a licensed tool leaves as manual work for your staff every single cycle.

How do hidden costs get into the quote?

Four of them, reliably, and none is dishonest. They are simply invisible until someone opens the data.

  • Centerline remediation. If your centerline lacks stable identifiers, carries duplicate geometry from an old conversion or disagrees with the street name file, that has to be fixed first. It is a prerequisite project and should be priced separately rather than absorbed into a fixed bid.
  • Historic survey reconciliation. Priced per cycle, not per project. Four cycles from three vendors with a network that changed in between is weeks of work producing no visible feature.
  • The public map. A genuinely public map carries accessibility requirements, performance requirements under load and a content review process. An internal staff map carries none of those, and quoting them as one line is where fixed price projects go wrong.
  • Ongoing ingestion. Every future survey cycle needs importing, reconciling and quality checking. Unbudgeted, the system is current for two years and then abandoned.

What separates a pavement build that works from one that fails?

Three things, and none of them is the optimiser.

The first is a closed loop. Recommended treatments group into projects, projects carry a funding source and an appropriation, and award plus as built quantities post back to the segments that were actually treated. Without that, the model believes every recommendation was executed. Bids come in high, a preservation contract covers 31 of the 40 segments the model recommended, nothing records the shortfall, and within about three cycles the model's picture of the network and the real network have separated. The ranking then loses credibility at exactly the moment a council member challenges it.

The second is honesty about confidence. Deterioration curves shipped as defaults must be labelled as defaults on screen, so nobody presents a projection as a measurement. Calibration needs at least two survey cycles on the same segments, which is why most agencies never do it, and a system that hides which curves are fitted and which are assumed removes the only signal staff have about how much to trust a number.

The third is the two click council answer. Given any street, show the score, the recommended treatment, that treatment's cost and its rank under current funding, on a map a resident can read. That view is what makes the project defensible politically and it is the feature most likely to be cut for schedule. Protect it.

Then settle ownership in writing before kickoff: the repository, the cloud accounts and every condition, treatment and cost record, with the right to hire another firm. At Digital Heroes the client owns the code from the first commit. Condition history compounds in value across survey cycles, and it should never sit inside a supplier's platform.

Research & sources

The evidence behind this guide

Independent findings on why this investment pays off. Every link goes to the primary source.

  1. In a survey of 113 supply chain leaders (conducted late March to mid-April 2022), 67% had implemented digital dashboards for end-to-end visibility, and those companies were about twice as likely as others to avoid supply chain problems during the disruptions of early 2022; 71% expected to revise inventory policies going forward. Source: McKinsey & Company (2022) →
  2. The performance gap between digital and AI leaders and laggards is widening: McKinsey reports leaders pull ahead on shareholder returns, and the average maturity spread between top and bottom performers jumped ~60% (from 10 points in 2016-19 to 16 points in 2020-22), reinforcing that the returns to transformation concentrate among top performers. Source: McKinsey & Company (2023) →
  3. 48% of private companies cite integration with legacy systems or technical debt as a top obstacle to realizing the full value of their digital and AI investments (behind data quality/availability at 72% and gaps in AI fluency or technology talent/leadership at 53%). Source: Deloitte (2026) →
  4. McKinsey found that currently demonstrated technologies can fully automate about 42% of finance activities and mostly automate a further 19%, indicating roughly 60% of finance work is technically automatable. Source: McKinsey & Company (2018) →
Aaradhya R. · Senior Backend Engineer · Python · Delhi

Aaradhya builds Python backends at Digital Heroes, from APIs and scheduled jobs to data processing behind reporting and automation features. Her posts suit readers trying to understand what sits between a business process they want automated and software that can actually run it.

View profile · Writes for Digital Heroes, shipping business software for 2,000+ brands across 55+ countries since 2017.

FAQ

Frequently asked questions

Our survey vendor changed at recompete and the new segmentation does not match. What do we do?
Reconcile the new deliverable to the segment identity you own rather than adopting the vendor's. Build a documented mapping that reports what matched cleanly, what split, what merged and what could not be resolved, and send the unresolved list to an engineer instead of defaulting it. Then fix the cause: put the segmentation basis, the identifier convention and the deliverable schema into the procurement documents for the next survey so this is a contract requirement rather than a data cleanup exercise every cycle.
How many centerline miles justify a custom pavement system?
Mileage alone is the wrong test. Under roughly 100 centerline miles, StreetSaver or an equivalent is proportionate and we would tell you to buy it. Above that, the real trigger is whether your paving list is contested in public, whether the model has to reconcile with your capital budget and utility plans, and whether you need to answer a question about one specific street in a council meeting. Those are integration and communication needs, and they are what licensed tools leave as recurring manual work.
Can we keep StreetSaver and just build the public map on top?
Sometimes, and it is worth costing before you consider a full replacement. The constraint is that the map needs the score, the recommended treatment, the treatment cost and the rank under current funding for every street, so whatever you build has to consume all of those reliably and refresh on a schedule. If the export you can get is a static file produced once a year, the map will be stale within a quarter and residents will notice, which is worse than not publishing it.
What breaks when the GIS division republishes the centerline?
Any part of your system that used their identifiers as its own primary key. Segments get split at new intersections, geometry errors get corrected and corridors get renumbered after annexation, and none of that process asks whether a pavement system depends on it. Store the external reference as a dated attribute against your own stable identity, run a scheduled reconciliation that reports differences rather than accepting them silently, and get the GIS division named in the project charter with a change notification obligation.
How should the system handle streets that were reconstructed or realigned?
As a new segment identity with an explicit link to what it replaced, not as an edit to the old one. A reconstruction resets condition and often changes the physical extent, so treating it as the same object corrupts the deterioration history that calibration depends on. Recording the supersession relationship keeps the old history retrievable for reporting while stopping the curve fitting from treating a reconstruction as a very fast improvement in an existing pavement.
Why does the model drift away from reality after a few years?
Because nothing tells it what was actually built. The model recommends 40 segments, the contract covers 31 after bids come in high, and no as built feedback posts the difference back. Repeat that for three cycles and the modelled network and the real network no longer agree. Closing the loop means treatments group into projects, projects carry appropriations, and award and as built quantities reset the condition of the segments that were genuinely treated while the rest stay in the queue.
Do curb ramp costs really belong in the pavement model?
Yes, because they change which projects are affordable. Where a resurfacing project counts as an alteration, ramps at the affected intersections have to be brought into compliance, and a program priced without that cost will not deliver the mileage it promised. Attach the estimate as a rule on the project driven by scope type and intersection count. Confirm the triggering criteria with your city attorney or accessibility coordinator, since the determination depends on the work rather than on the software.
What should we require from a survey vendor so the data is actually usable?
Name the segmentation basis and require it to follow your centerline, require stable segment identifiers that you supply rather than ones the vendor generates, and specify the distress data and index method you want alongside the raw measurements. Ask for the file format and schema in the contract, plus the right to receive the underlying measurements rather than only the computed index. Getting those four clauses into the procurement removes most of the reconciliation cost from every future cycle.
We run everything on spreadsheets and Airtable. How do we know it's time for custom software?
The reliable signals are re-typing the same data into multiple tools, one employee acting as human middleware between systems, and errors appearing in handoffs between teams. Hard limits force the issue too: Airtable's Team plan caps at 50,000 records per base, and Business costs $45 per seat per month, so a 20-person team pays about $10,800 a year for a tool it has already outgrown. When workarounds consume more hours than the tools save, the spreadsheet era is over.
How do I vet an agency or developer for a BI dashboard project?
Ask them to walk you through the data model of a past project, not a portfolio of pretty charts, because dashboard failures are almost always data modeling failures. Good answers mention specifics like star schemas, dbt, incremental refresh, and how they handled a source schema change after launch. Then ask for a fixed-scope discovery phase with a written data audit as the deliverable, so you judge their real work for a small spend before committing to the build.
Can one dashboard pull from QuickBooks, Salesforce, and Google Analytics at the same time?
Yes, and combining sources like that is the main reason to build custom instead of living inside each tool's built-in reports. The standard pattern syncs each source into one warehouse using connectors such as Fivetran or Airbyte, then joins them there, so marketing spend, pipeline, and revenue finally sit in a single view. Each additional source typically adds 1 to 2 weeks to the build, mostly for field mapping and reconciliation.
How long does it take to build a custom web or mobile app from scratch?
Plan on 8 to 16 weeks for a focused first version and 4 to 9 months for a larger platform, which is the typical spread across Digital Heroes builds. The first 2 to 3 weeks go to discovery and design before any production code ships. The two things that stretch timelines most are integrations with legacy systems and slow feedback from your side, not developer speed.
How do I vet a software development agency before signing a contract?
Ask to speak with two past clients whose projects resemble yours in size and industry, and ask exactly who will write your code, since some agencies sell senior faces and deliver junior or subcontracted hands. Demand a written specification with acceptance criteria before any fixed price, and check that their portfolio links to products that are actually live. An instant quote given without questions about your workflows is the clearest warning sign there is.
Is custom software more secure than off-the-shelf SaaS?
Neither is secure by default; security tracks the practices of whoever builds and operates the system, not the model. SaaS gives you the vendor's certifications and patching but puts your data in a shared multi-tenant platform on their terms, while custom gives you full control over data residency, access rules, and compliance requirements like HIPAA, with the responsibility sitting with you and your agency. Before hiring anyone for a system holding sensitive data, ask for their security checklist: encryption at rest and in transit, an OWASP Top 10 review, role-based access, and a penetration test before launch.
What are the most common mistakes companies make on dashboard projects?
The four we see most: designing charts before modeling the data, cramming 30 metrics onto one screen so nothing stands out, letting every team define revenue slightly differently, and skipping data quality checks so the dashboard confidently displays wrong numbers. The wrong-numbers failure is the fatal one, because a dashboard loses trust once and never fully earns it back. Spend the first weeks on metric definitions and data quality, not on colors.
Do I need a data warehouse before building a custom dashboard?
Not for a small build; a dashboard reading from 1 or 2 sources can query them directly or use a plain Postgres database as its store. You want a real warehouse like BigQuery or Snowflake once you are joining 3 or more sources, keeping history beyond what source systems retain, or serving many concurrent users. Adding the warehouse costs around 2 to 4 extra weeks and is usually the single best investment in the project's future.
Can custom software connect to the tools we already use, like QuickBooks, Stripe, and Google Workspace?
Yes, and connecting your existing tools is one of the main reasons to build custom: mainstream platforms like QuickBooks, Stripe, Shopify, and Google Workspace all publish documented APIs. Budget 1 to 3 weeks of work per integration depending on API quality and how much data flows in both directions. Ask any vendor whether they have integrated with your specific tools before, because quirks like QuickBooks' OAuth token handling and API rate limits get learned on someone's project, and it should not be yours.
Will a custom dashboard stay fast once our data hits millions of rows?
Yes, if it aggregates before it displays; no dashboard should scan millions of raw rows on every page load. The standard techniques are pre-aggregated summary tables, incremental refresh, and caching, which keep typical page loads under 2 seconds even on datasets in the hundreds of millions of rows. Ask your vendor how the dashboard behaves at 10 times your current data volume; a good one gives a specific answer about aggregation, not just a bigger server.
What questions should I ask a development agency on the first call?
Ask who exactly will build it, what happens when scope changes mid-project, what their maintenance terms are after launch, and what they will need from you every week. Then ask them to describe a project that went wrong and what they changed afterward; teams that have shipped at real volume have war stories, and teams claiming a perfect record are hiding something. The scope-change answer matters most: a disciplined shop describes a written change-order process, not a vague promise to be flexible.
Who can build a custom business intelligence dashboards system?

Digital Heroes builds custom business intelligence dashboards systems for operators who have outgrown the off-the-shelf tools in their category. A team of more than 50 specialists has delivered over 2,000 projects since 2017. Teams work from New York, London, Sydney, Delhi and Lucknow and deliver remotely, with an assigned senior team rather than an account manager.

Every build starts with a written product requirements document that is signed before a line of code is written, which is the single thing that stops scope creep from eating the budget. Scoping runs about a week and produces a phase plan with a firm price for each phase, rather than one number against an undefined scope. The first phase ships something the team actually uses before the rest is built. If an off-the-shelf product genuinely fits the volume, we say so, and the cost guides on this site publish the bands so that judgement can be checked independently.

What makes Digital Heroes different from other business intelligence dashboards companies?

Four things that competitors in this bracket cannot simply copy. Digital Heroes runs a YouTube channel with more than 2.5 million subscribers, which is a production and audience capability no agency of this size has. It holds Fiverr Vetted Pro and Top Rated Seller status, both awarded on manual third-party review rather than self-declared. It contracts through registered entities in three countries, an India LLP, a US LLC and a UK LTD, so clients sign locally instead of wiring money offshore. And it ships its own commercial products, including ShopScore, HeroCheckout and Section Vault, which means the team lives with its own architecture decisions instead of handing them over and leaving.

Two more that show up in the work. Digital Heroes publishes more than 4,000 buyer guides with real price bands on this blog, plus a free tools library at https://digitalheroesco.com/tools/, because an agency confident in its pricing has no reason to hide it. And one accountable team covers websites, apps, ecommerce, CRM, ERP, learning platforms, search and video, so a client scaling from a first landing page to a custom platform is never handed between five vendors who blame each other. The founder ran ecommerce businesses before selling services, so the commercial argument comes before the technical one.

How can I check Digital Heroes is legitimate before getting in touch?

Verify it independently rather than taking the site's word for it. The YouTube channel is at https://youtube.com/@DigitalMarketingHeroes, the Fiverr profile at https://www.fiverr.com/shreyanshsin261, and the Upwork profile at https://www.upwork.com/freelancers/shreyanshsingh. Client reviews sit on Clutch at https://clutch.co/profile/digital-heroes-0 and Trustpilot at https://www.trustpilot.com/review/digitalheroes.co.in, and the company page is at https://www.linkedin.com/company/digital-heroes-1/.

Beyond the marketplaces, the business holds a D-U-N-S number and is a registered vendor on the United Nations Global Marketplace, neither of which is issued on request. Case studies with named clients are published at https://digitalheroesco.com/case-studies/. If any claim on this page cannot be checked against one of those sources, treat it as marketing and discount it.

Keep reading
let's build

Build something worth launching.

A plan, a team, a timeline, within 24 hours. No decks, no discovery calls. Tell us what you're building and we'll come back with a real scope and a real number.

message us directly · we reply within one business day

mission briefing

Monthly dispatch

Playbooks, real build costs, and what we're shipping. One email a month. No fluff.

visit us

New York HQ

1140 Broadway, Suite 704 · New York, NY 10001

Get directions
Online now

Hey there 👋 How can we help you today?