Pass-through integration for local government · records are never stored System status1-559-251-7767Sentra familySign in
SentraBridgeIntegration platform
ExampleTemplate

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.

Try it on your dataAll examples
This flow

4 steps

StartsOn a schedule
SystemsPostgreSQL / PostGIS, Esri ArcGIS feature layer
Branches0
Stored recordsNone: pass-through
§ The flow

The whole flow, as it appears on the canvas.

Scroll sideways on small screens. Colors show the kind of step: start, read, change, decide, write.

Flow diagram: Publish issued permits to an ArcGIS map layerNightly, reads permits issued since the last run from the city database and adds them as points on an ArcGIS feature layer.Nightly at 2 amOn a scheduleIssued permitsRead database · PostgreSQLMake map pointMake map pointAdd to the layerSend records · ArcGIS
StartReadFilesDatabaseChangeDecideWriteAct
§ Step by step

What each step does.

  1. 01 · Start · On a schedule

    Nightly at 2 am

    • Every night at 2:00 am (workspace time zone)

    Then: Issued permits

  2. 02 · Database · Read database · PostgreSQL / PostGIS

    Issued permits

    • Reads from PostgreSQL / PostGIS with a read-only query
    • SELECT permit_number AS ref, permit_type, status, address, ST_Y(geom) AS lat, ST_X(geom) AS lng, updated_at
FROM permits
WHERE status = 'issued'
  AND updated_at > COALESCE(CAST(:last_success_at AS timestamptz), '1970-01-01')
ORDER BY updated_at
    • Row ID column: ref (used for replay and lineage)

    Then: Make map point

  3. 03 · Database · Make map point

    Make map point

    • Builds an ArcGIS map point from lat and lng
    • Drops records without coordinates

    Then: Add to the layer

  4. 04 · Write · Send records · Esri ArcGIS feature layer

    Add to the layer

    • Creates Features in Esri ArcGIS feature layer
§ Systems

Connectors used

Swap any of them for another system with the same kind of data.

§ Next

Keep exploring

SolutionGIS publishingExampleCopy 311 requests into the city database, with map pointsExample311 triage: route every request to the right systemExampleNightly backup: a database table to CSV in S3

Run this flow on your systems.

We'll set up a workspace with your systems in a sandbox and build your first flow with you.

Request a demoBrowse live examples