This talk will describe a hybrid geospatial workflow combining ArcGIS Online with a self-hosted FOSS backend built for a small municipality in Ohio (now devoid of any GIS staff). We will outline how we came to this point, the tools involved, and some of the roadblocks met along the way.

The stack consists of a custom Mapbox GL-based frontend, backed by PostgreSQL/PostGIS via pg_featureserv and pg_tileserv, and currently Esri FieldMaps for data collection. To sync from AGOL to Postgres we use a collection of python-based tools (RESTerville). The majority of the backend FOSS stack is deployed via Docker, with the object-based storage, static raster tile server, and frontend managed separately.

A few of the unique features of the backend stack include syncing feature services from AGOL to Postgres including attachments, property search and city service information via pg_featureserv, and pg_tileserv for about everything else. On the frontend we have deployed a simple print feature used extensively by city officials, a sewer system trace feature, saved map state, and customizable feature filters.

The result is a fast, mobile-friendly mapping app used throughout the city.