Seattle 311
Sync Seattle 311 service requests into your warehouse.
The Seattle 311 connector syncs Seattle service requests into analytics-ready tables in your data warehouse. Pull customer service requests with the handling department, intake channel, status and geocoded location from the Socrata Open Data API on data.seattle.gov, with Ingest handling pagination and retries so the tables stay current.
Seattle 311 is not a certified connector yet. Ingest authors one from the vendor's API documentation when a customer asks for it, runs it against the real API, and only then lists it as deployable. Request it and it moves up the queue.
What you can sync
Ingest lands the following Seattle 311 data in your warehouse or lake, each as its own table on the schedule you pick:
- Service requests
- Request status
- Request types
- Department and location
Authentication
None. The Seattle 311 API is public and needs no credential. A Socrata app token is optional and only raises the rate limit.
Credentials go into a form, never into a chat, and are held in a secret store under your own path. Only the key NAMES ever reach the control database.