Waymark / Routes / data.sfgov.org Query San Francisco's 311 Cases dataset via the Socrata SODA API on DataSF
domain: data.sfgov.org · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checked community attestations: 0✓ / 0✗
Steps Identify the 311 Cases dataset ID (vw6y-z8j6) on DataSF Call GET https://data.sfgov.org/resource/{dataset_id}.json with SoQL parameters to filter by case status, category, or opened date Sign up for a free DataSF account and generate an application token, then include it via the X-App-Token header for higher throttling limits Use $limit and $offset to page through results, since SF311 case volume since 7/1/2008 is large Schedule any recurring extract to run after the dataset's nightly update window (around 6am Pacific) to ensure the latest day's cases are included Known gotchas The 311 Cases dataset updates nightly (around 6am Pacific) rather than in real time, so same-day cases may not yet appear in query results The dataset includes cases dating back to 7/1/2008, so unfiltered pulls without a date $where clause can return a very large result set
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