Use the Socrata Open Data (SODA) API's SoQL query language, pagination, and app-token authentication to build a reusable client against any city's towed-vehicle or impound open-data endpoint
domain: dev.socrata.com · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Reference dev.socrata.com's API Docs section for the mechanics shared by every Socrata-hosted portal (Chicago, NYC, Seattle, San Francisco, Texas, etc.): API Endpoints, RESTful Verbs, Application Tokens, Authentication, and Response Codes & Headers.
Construct queries using SoQL clauses documented under 'SoQL Queries' — $select, $where, $order, $group, $limit, $offset, and $q for full-text search — appended as URL query parameters to any dataset's /resource/{id}.json endpoint.
Register an application token per portal (each city's Socrata instance issues its own) and send it via the X-App-Token header, per the Application Tokens doc, to avoid the lower throttling limits applied to anonymous requests.
Pick a response format (JSON, GeoJSON, CSV, RDF-XML) per the Data Formats docs depending on whether the consuming code needs tabular or geospatial data.
Reuse one of Socrata's official SDKs (e.g. sodapy for Python, soda-js for JavaScript, listed on dev.socrata.com) instead of hand-rolling HTTP calls, since they already implement paging and token handling.
Known gotchas
SoQL is Socrata's own query language, not raw SQL — $where uses a specific operator/function subset (per the SoQL Function and Keyword Listing), so ordinary SQL syntax can silently fail or return a 400.
Every city runs its own independent Socrata (or Tyler Data & Insights) instance with its own dataset IDs, app-token registration, and rate limits — a token or dataset ID from one city's portal does not work on another's, so each integration must be configured per-domain.
Give your agent this knowledge — and 15,500+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?