ExampleTemplate
EnerGov issued permits to ArcGIS
Every night, reads permits issued or changed in EnerGov since the last run and adds them to the permits map layer in ArcGIS.
This flow
6 steps
StartsOn a schedule
SystemsTyler EnerGov, 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.
§ Step by step
What each step does.
- 01 · Start · On a schedule
Nightly at 2 am
- Every night at 2:00 am (workspace time zone)
Then: Permits from EnerGov
- 02 · Read · Get records · Tyler EnerGov
Permits from EnerGov
- Reads Permits from Tyler EnerGov
- Only records changed since the last good run
- At most 2,000 records per run
Then: Issued only
- 03 · Decide · Filter
Issued only
- Keeps only records where
StatusisIssued
Then: To layer fields
- Keeps only records where
- 04 · Change · Map fields
To layer fields
- Shapes each record into 5 fields:
ref,status,address,lat,lng
Then: Make map point
- Shapes each record into 5 fields:
- 05 · Database · Make map point
Make map point
- Builds an ArcGIS map point from
latandlng - Drops records without coordinates
Then: Add to the map layer
- Builds an ArcGIS map point from
- 06 · Write · Send records · Esri ArcGIS feature layer
Add to the map layer
- Creates Features in Esri ArcGIS feature layer
§ Systems
Connectors used
Swap any of them for another system with the same kind of data.
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.