Pull public weatherization program data from a state/city open-data portal

domain: data.austintexas.gov · 4 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Use Austin, TX's Socrata open-data portal dataset "Weatherization Assistance Program" (data.austintexas.gov, dataset ID fnns-rqqh) as a concrete, currently real example of a queryable municipal WAP dataset with a standard Socrata API.
  2. For other jurisdictions, check whether they publish on a Socrata (or similar) open-data platform first (e.g., data.michigan.gov) before assuming a WAP-specific dataset exists — most states publish only PDF program reports, not queryable open datasets.
  3. If a Socrata dataset exists, use the standard Socrata Open Data API (SODA) query parameters against the dataset's resource endpoint rather than scraping the portal UI.
  4. Cross-check any pulled figures (homes weatherized, spend, wait-list counts) against the state agency's own published annual report, since open-data exports can lag or differ from official public reporting.

Known gotchas

Related routes

Pull daily temperature data from NOAA's Climate Data Online (CDO) API v2 to compute heating/cooling degree days for utility weather-normalization
ncdc.noaa.gov · 5 steps · unrated
Request historical weather/climate data via the NOAA Climate Data Online (CDO) API v2
www.ncei.noaa.gov · 6 steps · unrated
Retrieve free weather data for renewables forecasting using the Open-Meteo API
api.open-meteo.com · 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