01 · GIS systems · 2024

POSM GIS Enterprise

Inspection-grade GIS for municipal field crews.

Region
GIS systems
Year
2024
Status
Production
Stack items
5

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.

Solution

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.

Stack
LeafletGeoServerAWSPostgreSQLNode.js
Live · interactive

Click through the actual mockup.

main.d2dmn7au6qkp2d.amplifyapp.com
LIVE

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

Outcomes

What this changes.

  1. 01

    Single live map view across thousands of inspection assets

  2. 02

    Offline tile cache for field crews working outside coverage

  3. 03

    Bi-directional sync to existing SQL Server — no migration

  4. 04

    Sub-second drill-down from region → block → asset

Related work
POSM Earth CMMS

POSM Earth CMMS

Field-data gathering and pipe-asset CMMS with ArcGIS SSO.

Web GIS Inspection Platform

Web GIS Inspection Platform

ArcGIS Web Components with OAuth PKCE for municipal field crews.

Live Operations Dashboard

Live Operations Dashboard

Region-to-asset drill-down for a utility ops team — live KPIs from 1,200 field devices.

Want one of these for your operation?

POSM GIS Enterprise · GeoLink