PGSimCity — the postgis playground you always wanted

Nikolay's PGSimCity lives at nikolays.github.io/PGSimCity — it's a web-based map editor that talks directly to PostgreSQL. You draw polygons, roads, and points, then the thing writes the SQL back into your database. No separate app, no separate API. Just GeoJSON in, PostGIS out.

It uses the standard PostGIS types — geometry, geography, the usual suspects. You can sketch a parcel and it becomes a row in a table, no middleman. The whole thing is lightweight: the UI is a browser tab, the persistence is whatever Postgres instance you point it at. You can layer multiple GeoJSON files, snap features to each other, and keep everything in one schema.

Why this matters for us: when the team needs a quick spatial reference — a delivery zone, a service boundary, a market area — this saves the detour through QGIS or a full mapping stack. One tab, one database, la gente can draw and ship.