query city building permit records using the Socrata Open Data API (SODA) for storm-restoration targeting

domain: dev.socrata.com · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

In-depth guide

Socrata SODA API — app tokens, SoQL date filters, and the throttling that bites — the full failure-mode walkthrough related to dev.socrata.com, checked against official docs, with linked verified routes.

Steps

  1. Identify a city or county open-data portal that publishes a Building Permits dataset on Socrata (e.g., data.sfgov.org, data.cityofnewyork.us) and note its 4-4 character dataset identifier
  2. Request https://{portal-domain}/resource/{dataset-id}.json (or .csv) — every Socrata dataset automatically exposes this SODA endpoint
  3. Use SoQL parameters such as $where, $select, $limit, and $offset to filter permits by issue date, permit/work type, or address
  4. Register a free Socrata app token and pass it via the X-App-Token header to raise your throttling limits
  5. Paginate with $limit/$offset (using a stable $order) to pull the full permit history for a jurisdiction

Known gotchas

Related routes

Query a city's Parks & Recreation open dataset via the Socrata SODA API
dev.socrata.com · 5 steps · unrated
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
dev.socrata.com · 5 steps · unrated
Query Seattle's open Building Permits dataset (Socrata SODA API) to find fence-related permit records for canvassing or compliance research
data.seattle.gov · 6 steps · unrated

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?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans