Run the whole rehab project on one NASSCO-native database.
From the first CCTV inspection to the final pay application, TrenchlessPM keeps PACP, LACP, and MACP data, crew schedules, shot planning, wet-out documentation, submittals, and AIA billing in one system your whole team understands.
- NASSCO v7 & v8 round-trip
- Schema-driven validation
- AIA G702 / G703 pay apps
- Claude-powered project chat
| Segment | Use | Struct | O&M | Length |
|---|---|---|---|---|
| MH-14 → MH-15 | Storm | 5 | 3 | 284 ft |
| MH-15 → MH-16 | Sanitary | 4 | 2 | 312 ft |
| MH-16 → MH-17 | Sanitary | 3 | 3 | 201 ft |
| MH-17 → MH-18 | Storm | 2 | 1 | 398 ft |
| MH-18 → MH-19 | Sanitary | 5 | 4 | 267 ft |
Rehab projects live in a dozen disconnected places.
Access databases, whiteboards, Word docs, paper slips, email threads. Nothing talks to anything. TrenchlessPM connects the whole workflow so inspection data flows straight through to crew schedules and pay applications.
Five systems, zero integration
- CCTV software exports .mdb / .db3
- Whiteboards or standalone Gantts
- AIA G702 hand-typed in Word
- Paper wet-out slips
- Submittals buried in email
One database, every workflow
- One NASSCO-native database
- Integrated CPM + crew calendar
- Auto-generated pay apps
- Structured wet-out records
- AI-extracted submittal registers
Everything a rehab project needs, included.
Eight core modules ship with every instance. Activate plugins as your workflows mature — crews, scheduling, billing, submittals — without losing data when you switch them off.
Projects & baseboard
Create, archive, and track every rehab project. Per-project status — Pending → Mobilizing → CCTV → Active → Complete — with full contract metadata.
Main Line, Laterals, Manholes
Three dedicated NASSCO workspaces: PACP pipe inspections, LACP lateral access geometry, MACP component-level manhole detail — all from one unified database.
NASSCO import / export
Accept v7 .mdb or v8 .db3 from any vendor. Auto-detect, preview the diff, commit with an audit trail. Export byte-clean .db3 back to any compliant tool.
Repair list
Point repairs, root cutting, grout injection, bypass work — tied directly to inspected segments. Assign crews, schedule dates, track completion.
Ratings & exports
Structural + O&M grade distributions, critical-pipe counts, average ratings per project. One-click CSV per protocol and NASSCO-compliant .db3.
Cloud storage
Per-project folders for contracts, plans, CCTV videos, reports. Supabase Storage for documents; S3 integration for large video archives.
AI Project Assistant
Ask questions about inspection data, repairs, shots, and contract terms without leaving the project. Powered by Claude.
Team & access
Company-level roles (Admin, PM, Crew Lead), per-project PM assignment, and crew roster with schedule-entry tracking.
NASSCO compliance as a first-class engineering concern.
Certification is table stakes for public-sector work. We treat it as core infrastructure — not a bolt-on. Hand any TrenchlessPM-exported .db3 to any compliant tool, or drop any inspector's .mdb into TrenchlessPM. It just works.
Import a municipal inspector's .mdb, edit in the app, export a v8 .db3 — rows come back byte-clean, diff-verified against NASSCO reference samples.
PACP, LACP, MACP — full column parity to NASSCO v8 schema.
v7.0 (Access .mdb) and v8.0 (SQLite .db3) import; v8 export.
Every field checked against the published NASSCO data dictionary on import, entry, and export.
Import from any compliant vendor, export to any — no data loss.
Structural + O&M grade aggregation tested against NASSCO's own sample databases.
Autocomplete with live grade preview for every PACP / LACP code, scoped to pipe-use.
English, Spanish, and French field labels supported.
The NASSCO data dictionary is committed to the repo and stays in sync with every release.
Opt-in workflows. Pay for what your team actually uses.
Admins toggle plugins from a single screen. Activating a plugin reveals new tabs in every enabled project; deactivating hides them without losing data.
GIS Map
See rehab priority on a real map.
- ArcGIS-based segment overlays, color-coded by priority
- Shapefile (.zip), GeoJSON, KML, XML layer support
- Auto-reprojection from State Plane to WGS84
- Click any segment for full inspection data
Schedule AI
Crew scheduling with AI recommendations.
- Bid schedule with contract line-item quantities & costs
- Baseline CPM with predecessors and Gantt view
- Per-crew calendar of work dates by project and shot
- Claude-powered recommendations (weather, lead times)
Pay Application
Shot → wet-out → AIA pay app.
- Group segments into CIPP / burst / slip / spot repair shots
- Per-shot wet-out forms with liner, resin, and QC data
- Reusable manufacturer templates for wet-out
- AIA G702 / G703 generation with retainage & signatures
Submittal AI
Submittals on autopilot.
- Track every submittal by number, spec section, status
- Drop a contract PDF → Claude extracts requirements
- Compliance check with structured pass/fail report
- Version packages, attach review comments, track revisions
Import what NASSCO hands you. Export what NASSCO expects.
Run the whole rehab project in between — on a platform purpose-built for the way trenchless crews actually work.
One VPS, Ubuntu + Node 22 + PM2. Typical deploy is under an hour.
Point TrenchlessPM at your Supabase project for database and auth.
Drop a .mdb or .db3, or explore built-in demo projects (Holly Hill, Cullman, Frisco).
Turn on GIS, Scheduling, Pay Apps, or Submittals as your workflows mature.
Hand a round-trip-verified .db3 to your municipal client on day one.
Ready to run your next rehab on one database?
Request a demo. We'll walk you through a real NASSCO import, shot planning, and an AIA pay app — using your data or ours.