Pull NYC street opening/construction permit records for a specific address or contractor via NYC Open Data's Socrata API instead of manually browsing the OCMC-linked datasets.
domain: data.cityofnewyork.us · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Identify the correct dataset for the date range needed: 'Street Construction Permits (2022-Present)' (tqtj-sjs8) for recent data, or 'Street Construction Permits (2013-2021)' (c9sj-fmsg) for historical
Query the Socrata SODA API endpoint (data.cityofnewyork.us/resource/{dataset-id}.json) with SoQL filters on permittee, street name, or issue date
Cross-check against the separate 'Street Opening Permits' (9jic-byiu) and 'OUR_PERMITS' (6kh8-23gv) datasets, which cover overlapping but not identical permit categories
Confirm field-level definitions in each dataset's data dictionary before joining across the split 2013-2021 / 2022-present tables
Register a free Socrata app token if making high-volume queries to avoid throttling
Known gotchas
Permit history is split across at least two separate datasets by date range with no single unified table — queries spanning both eras require two calls and a manual merge
Dataset field names and permit-type taxonomies have changed over the years; don't assume identical schemas across the split tables
These are NYC DOT/OCMC-tagged datasets on the citywide Socrata portal, not a dedicated OCMC-branded API endpoint
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?