GeoLink
ES
Municipal · Sewer inspection

Inspection-grade GIS for municipal field crews.

Client

Municipal · Sewer inspection

Year

2024

Role

Architecture · Build · Deploy

Status

In production

Stack
  • Leaflet
  • GeoServer
  • AWS
  • PostgreSQL
  • Node.js
POSM GIS Enterprise
POSM GIS Enterprise — 1
POSM GIS Enterprise — 2
POSM GIS Enterprise — 3

The problem

Field inspection teams needed a single map view across thousands of sewer assets, with offline tile support and real-time sync back to a central SQL Server.

Prior tooling forced dispatchers to switch between desktop GIS, paper field reports, and three different spreadsheets — making it impossible to see live status across a region.

What we built

A Leaflet-based web app deployed on AWS with GeoServer WMS/WFS for the asset layers and PostgreSQL/PostGIS as the spatial backend.

The app handles offline tile caching for field crews, bi-directional sync with the existing SQL Server inspection database, and a dispatcher console with drill-down from region to individual asset.

Deployed on AWS Amplify with CI/CD and zero-downtime cutovers.

Results

  1. 01Single live map view across thousands of inspection assets
  2. 02Offline tile cache for field crews working outside coverage
  3. 03Bi-directional sync to existing SQL Server — no migration
  4. 04Sub-second drill-down from region → block → asset
Live demo

Production web app on AWS Amplify. The UI you see is the live system field crews use.

← Back to work

Book your free 30-minute audit.

We take 2 free audits per month.

In 48 hours you get a 2-page report and a clear next step.

  • 50+ municipal deployments
  • We tell you if you don’t need us
  • No contract to book the call
Book my free 30-min auditMessage us on WhatsApp