Firecrawl Alexandria

DataSF open data portal

Name: DataSF open data portal
Creator: DataSF open data portal

San Francisco's open data portal (data.sf.gov, a Socrata site): typed Department of Building Inspection building permits (search by address, parcel, contractor, type, status and dates, poll for new and changed permits, read one permit with its contractors, architects and engineers, rank contractors by permits and valuation), plus search the dataset catalog, read a dataset's metadata and columns, query and count rows of any dataset with SoQL ($select/$where/$order/$group/$q and bare field filters, including spatial functions), and list the portal's category and tag facets.

1 Firecrawl tool uses DataSF open data portal

Try in Agent

Find up to five tabular DataSF datasets about zoning and show their IDs, descriptions and published column names.

Try DataSF open data portal now.

Choose an example or ask your own question.

What do you want to do with DataSF open data portal?

DataSF open data portal

TRY ASKING

Codefollows the fields above

const result = await firecrawl.scrape({
  alexandria: {
    provider: "data-sf-gov",
    capability: "open-data/rows",
    options: {
      dataset_id: "3i4a-hu95",
      limit: 5,
      select: "zoning_sim,districtna,gen",
      where: "intersects(the_geom,'POINT(-122.3966 37.7897)')",
    },
  },
});

2Response example

This is a sample shape. Press Run to see live data from DataSF open data portal.

{
  "columns": [
    {
      "datatype": "text",
      "field_name": "zoning_sim"
    },
    {
      "datatype": "text",
      "field_name": "districtna"
    },
    {
      "datatype": "text",
      "field_name": "gen"
    }
  ],
  "count": 1,
  "data_last_modified": "Mon, 21 Sep 2026 11:24:25 GMT",
  "dataset_id": "3i4a-hu95",
  "limit": 5,
  "next_cursor": null,
  "observed_at_ms": 1790056202526,
  "offset": 0,
  "rows": [
    {
      "districtna": "DOWNTOWN- OFFICE (SPECIAL DEVELOPMENT)",
      "gen": "Commercial",
      "zoning_sim": "C-3-O(SD)"
    }
  ],
  "source_url": "https://data.sf.gov/resource/3i4a-hu95.json?%24select=zoning_sim%2Cdistrictna%2Cgen&%24where=intersects%28the_geom%2C%27POINT%28-122.3966+37.7897%29%27%29&%24order=%3Aid&%24limit=5"
}

City and County of San Francisco, Department of Building Inspection, via DataSF. Open Data Commons Public Domain Dedication and License (PDDL). (https://data.sf.gov/d/i98e-djp9)