Call GET https://data.sfgov.org/resource/tkzw-k3nq.json to query DataSF's 'Street Tree List' dataset (Socrata dataset id tkzw-k3nq).
Filter with $where on fields like qspecies (species), qsiteinfo, or planting date, and paginate with $limit/$offset across the full dataset.
Register a Socrata application token and send it as X-App-Token to avoid the platform's default anonymous rate limits.
Cross-reference against San Francisco Planning's separate EveryTreeSF citywide census if full city coverage (not just DPW-maintained trees) is required.
Use the dataset's OData endpoint variant instead of the JSON REST endpoint if integrating directly with Excel or Tableau.
Known gotchas
The Street Tree List only covers DPW-maintained street trees — it excludes private and many park trees, so it will undercount total urban forest if used naively for coverage analysis.
Same Socrata throttling behavior as other SODA-hosted municipal datasets: unauthenticated calls hit low rate limits quickly.
Field names are DPW-specific abbreviations (qspecies, qsiteinfo, qcaretaker, etc.) — consult the dataset's column metadata before building filters.
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?