Pull a municipality's published Pavement Condition Index dataset via its open-data API to benchmark a bid's condition assumptions against the city's own street ratings.

domain: Los Angeles GeoHub / data.lacity.org — 'Road Surface Condition Map' Socrata dataset · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Query the Socrata API endpoint for the LA Road Surface Condition Map dataset (data.lacity.org, dataset id d9rz-k88a) at its /resource/{id}.json endpoint.
  2. Filter results to street segments bordering or near the job site.
  3. Note the survey-date field, since the city's PCI values come from a periodic (roughly tri-annual) survey, not real-time sensing.
  4. Use neighboring public-street PCI as a rough contextual proxy for a private lot's likely condition — not a substitute for an on-site survey.
  5. Confirm the dataset covers city streets specifically, not private parking lots, before citing it in a bid.

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 Chicago CDOT street/lane closure permit records via the city's Socrata open-data API instead of manually browsing the ipi.cityofchicago.org portal.
data.cityofchicago.org · 5 steps · unrated
Pull demolition activity from Baltimore's and Philadelphia's municipal open data portals to research a property or contractor's demolition history
data.baltimorecity.gov · 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