Three places
The complaint, the case and the map are updated separately.
Code enforcementSolution
From complaint to case.
To the map. To closed.
Code complaints flow from 311 into the case system and onto a code-case map, and closures flow back, so officers, the public and the dashboard all agree.
This solution
Code enforcement
StartsWhen a system calls in · Sentra 311 calls in
SystemsSentra 311, Accela Civic Platform, OpenGov Permitting & Licensing, Esri ArcGIS feature layer…
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.
No location
Cases without a map point can't be planned into a route.
Closed, but not told
The complainant never hears that the case was closed.
§ How it works
How it works: Code enforcement
- 01ComplaintFrom Sentra 311
- 02CaseAccela or OpenGov record
- 03Map pointOnto the code-case layer
- 04CloseBack to 311
§ 01 / Triage
Every request to the right place.
The 311 triage template checks each changed request, sends new potholes, lights and trees to Scheduler crews, code cases to the ArcGIS map, and everything else to an SFTP file.
- Clean and check before routing
- Database lookup: is it new?
- Summary by department emailed
§ Templates
Ready-made flows for this.
Sentra 311 → Accela Civic Platform
311 code-enforcement requests become Accela records
When Sentra 311 sends request.created, code-enforcement requests become new Accela records. Everything else is ignored.
Sentra 311 → Sentra Scheduler → PostgreSQL / PostGIS → Esri ArcGIS feature layer → SFTP server311 triage: route every request to the right system
Cleans and checks changed 311 requests, sends bad ones to a data-quality sub-flow, checks the city database to see if each is new, then routes new…
Accela Civic Platform → Sentra 311Closed Accela records close their 311 requests
Every 15 minutes, finds Accela records closed since the last run and closes the matching Sentra 311 request.
§ Systems
Works with
Pre-built connectors used in this solution. Anything else with an API, a database or SFTP works too.
Sentra 311See your own systems connected.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.