Utility GIS Platform
System Architecture
⚡ Fast Propagation
✓ Reliable Logic
↔ Weeks, Not Years
☁ Bring Your Own Cloud
01 Desktop Client 🖥
Qt / C++
  • Map rendering & feature editing
  • Graph-aware selection & tracing
  • Attribute propagation UI
  • Offline-capable operations
02 REST API ✦
Stateless · Language TBD
  • API-driven connectivity (no DB triggers)
  • Thin layer — logic lives in Postgres
  • Propagation & tracing endpoints
  • GeoJSON + JSON responses
03 PostgreSQL + PostGIS 🗄
Graph-First Schema
  • Nodes & Edges as primary model
  • Geometry is an attribute, not topology
  • Recursive CTE downstream propagation
  • Direction derived from source markers
⏱ < 1 Second Trace
Graph-first recursive CTE traverses 1M+ features in a single query — no topology rebuild, no cache invalidation.
✅ Logic You Can Read
Propagation lives in plain SQL stored procedures — inspectable, testable, auditable. No opaque engine to debug.
↔ Weeks, Not Years
Bring your existing data schema — geometry maps as attributes, graph edges built from your connectivity records.