ExampleTemplate
Copy 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.
This flow
4 steps
StartsOn a schedule
SystemsSentra 311, PostgreSQL / PostGIS
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.
§ Step by step
What each step does.
- 01 · Start · On a schedule
Every 15 minutes
- Every 15 minutes (workspace time zone)
Then: Changed 311 requests
- 02 · Read · Get records · Sentra 311
Changed 311 requests
- Reads Service requests from Sentra 311
- Only records changed since the last good run
Then: Name fields like the columns
- 03 · Change · Map fields
Name fields like the columns
- Shapes each record into 11 fields:
request_id,number,category,department,status,address,description,created_at,updated_at,lat…
Then: Upsert into service_requests
- Shapes each record into 11 fields:
- 04 · Database · Write to database · PostgreSQL / PostGIS
Upsert into service_requests
- Upserts rows in
service_requestskeyed onrequest_id - Builds a map point in
geom(SRID 4326)
- Upserts rows in
§ Systems
Connectors used
Swap any of them for another system with the same kind of data.
Sentra 311Run this flow on your systems.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.