Research prior underpinning/foundation permit activity on a property or block using NYC and Chicago open building-permit datasets

domain: data.cityofnewyork.us · 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 data.cityofnewyork.us, checked against official docs, with linked verified routes.

Steps

  1. Query NYC's 'DOB Permit Issuance' dataset (data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a) via the Socrata SODA API, filtering by address/BIN and job-type/work-type text fields for underpinning-related descriptions
  2. Note that DOB Permit Issuance only covers permits issued in the legacy Buildings Information System (BIS); most current NYC permits now issue through DOB NOW, so also check DOB NOW's public look-up for recent activity the BIS-sourced dataset may miss
  3. For Chicago, query the 'Building Permits' dataset (data.cityofchicago.org/Buildings/Building-Permits/ydr8-5enu) via its SODA API, filtering the work_description or permit_type fields for foundation/underpinning-related text
  4. Because neither city publishes a dataset pre-filtered to 'underpinning' specifically, build the filter around free-text search terms (e.g., 'underpin', 'foundation repair', 'shoring') against the description fields rather than expecting a dedicated category code
  5. Use the permit-holder/contractor fields in results to identify which licensed foundation contractors have prior underpinning work on file in the area, useful for due diligence or competitive research

Known gotchas

Related routes

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.
data.cityofnewyork.us · 5 steps · unrated
Pull currently open elevator violations for a building via NYC's Active Elevator Violations open dataset
data.cityofnewyork.us · 4 steps · unrated
Look up NYC demolition permit history and status using the NYC DOB open data via the Socrata portal
data.cityofnewyork.us · 5 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