Manual layer refreshes
Exporting a table, geocoding and appending to a layer is a weekly chore.
For GIS analystsBy role
Layers that update themselves.
From the systems of record.
Keep ArcGIS feature layers in step with permits, 311 requests and code cases. SentraBridge reads the source, builds map points, and adds or updates features on a schedule.
§ The problem
What gets in the way.
Coordinates in odd places
Latitude and longitude arrive as separate fields, sometimes empty, and need turning into geometry.
Layers that drift
Updated or closed records in the source never reach the map.
§ How it works
How it works for gis analysts
- 01Read changesPermits issued since the last good run.
- 02Make map pointFrom latitude and longitude fields.
- 03Add featuresAdd or update features on the layer.
- 04LogCounts and IDs for every run.
§ What you get
Built for gis analysts.
Make map point
Turn latitude and longitude into an ArcGIS point or PostGIS geometry, and drop records without coordinates.
Learn more →ArcGIS feature layers
Add and update features on a layer, and read features back as records.
Learn more →PostGIS
Upsert rows with a map point column into PostgreSQL/PostGIS tables.
Learn more →§ Examples
Flows that fit.
Generated from SentraBridge's ready-made templates.
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
Systems you likely run.
Each links to its connector page. Not listed? Any REST API, OpenAPI file, database or SFTP server works.
Sentra 311§ FAQ
Questions, answered
Can it geocode addresses?
The Esri World Geocoder and US Census Geocoder are available as plain API connectors, so a flow can look up coordinates before making a map point.
What spatial reference does it use?
Database map points default to SRID 4326 and can be set per step. ArcGIS queries are read in 4326.
Can it update existing features?
Yes. The ArcGIS connector can add and update features.
See your own systems connected.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.