Monthly exports
The permit layer is refreshed when the GIS analyst has time to run an export.
GIS publishingSolution
Every permit on the map.
By morning.
Issued permits, code cases and 311 requests become points on ArcGIS feature layers and PostGIS tables, with attributes, every night or every 15 minutes.
This solution
GIS publishing
StartsOn a schedule · Nightly at 2 am
SystemsEsri ArcGIS feature layer, PostgreSQL / PostGIS, Microsoft SQL Server, Esri World Geocoder…
Templates3 ready-made flows to start from3
Stored recordsNone: pass-through, in memory only0
Preview any template on your own data before it writes anything.
§ The problem
What it looks like today.
Missing coordinates
Records without a location quietly break the map or vanish.
Two copies
A shapefile on a shared drive drifts away from the system of record.
§ How it works
How it works: GIS publishing
- 01Read permitsIssued since the last run
- 02Make map pointlat/lng to geometry
- 03Add featuresArcGIS feature layer
- 04ReportOptional summary email
§ 01 / Permits to ArcGIS
Issued permits, as points.
Nightly, SentraBridge reads permits issued since the last run from the city database and adds them as points on an ArcGIS feature layer.
- Read with a table or read-only query
- Drop or route records without coordinates
- Update features when permits change
§ 02 / A full pipeline
Map issued, report finaled, file expired.
The permit pipeline template does three jobs in one run: issued permits go to the map, finaled permits are totalled by type for building, and expired permits go to a CSV on SFTP.
- Nested If/else branches
- Summarize by type
- Clean and check first
§ Templates
Ready-made flows for this.
PostgreSQL / PostGIS → Esri ArcGIS feature layer
Publish issued permits to an ArcGIS map layer
Nightly, reads permits issued since the last run from the city database and adds them as points on an ArcGIS feature layer.
PostgreSQL / PostGIS → Esri ArcGIS feature layer → SFTP serverPermit pipeline: map issued, report finaled, file expired
Nightly, reads changed permits with a SQL query, cleans and checks them, then puts issued permits on the ArcGIS map, emails building a total of…
Sentra 311 → PostgreSQL / PostGISCopy 311 requests into the city database, with map points
Every 15 minutes, upserts new and changed Sentra 311 requests into a PostGIS table, with a map point built from latitude and longitude.
§ Systems
Works with
Pre-built connectors used in this solution. Anything else with an API, a database or SFTP works too.
See your own systems connected.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.