Firecrawl Alexandria
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 ready-made skill uses DataSF open data portalTry DataSF open data portal now.
Choose an example or ask your own question.
TRY ASKING
Codefollows the fields above
const result = await firecrawl.scrape({
alexandria: {
provider: "data-sf-gov",
capability: "open-data/dataset",
options: {
dataset_id: "3i4a-hu95",
},
},
});2Response example
This is a sample shape. Press Run to see live data from DataSF open data portal.
{
"api_url": "https://data.sf.gov/resource/3i4a-hu95.json",
"asset_type": "dataset",
"attribution": "City and County of San Francisco Planning Department",
"attribution_link": "https://sfplanning.org/zoning",
"category": "Geographic Locations and Boundaries",
"column_count": 7,
"columns": [
{
"cached": null,
"datatype": "multipolygon",
"description": "the_geom",
"field_name": "the_geom",
"name": "the_geom",
"position": 1,
"render_type": "multipolygon"
},
{
"cached": {
"cardinality": 10617,
"count": 10617,
"non_null_count": 10617,
"null_count": 0,
"top": [
{
"count": 1872,
"value": "RH-1"
},
{
"count": 1454,
"value": "RH-2"
},
{
"count": 908,
"value": "RTO-C"
},
{
"count": 795,
"value": "P"
},
{
"count": 763,
"value": "NCD"
},
{
"count": 605,
"value": "RM-1"
},
{
"count": 591,
"value": "RH-3"
},
{
"count": 584,
"value": "RH-1(D)"
},
{
"count": 347,
"value": "NC-1"
},
{
"count": 285,
"value": "NCT"
},
{
"count": 216,
"value": "RM-2"
},
{
"count": 180,
"value": "RM-3"
},
{
"count": 130,
"value": "RC-4"
},
{
"count": 129,
"value": "PDR-2"
},
{
"count": 112,
"value": "UMU"
},
{
"count": 101,
"value": "C-2"
},
{
"count": 97,
"value": "PDR-1-G"
},
{
"count": 87,
"value": "NC-2"
},
{
"count": 85,
"value": "NC-3"
},
{
"count": 83,
"value": "RTO-1"
}
]
},
"datatype": "text",
"description": "zoning_sim",
"field_name": "zoning_sim",
"name": "zoning_sim",
"position": 2,
"render_type": "text"
},
{
"cached": {
"cardinality": 10617,
"count": 10617,
"non_null_count": 10617,
"null_count": 0,
"top": [
{
"count": 1872,
"value": "RESIDENTIAL- HOUSE, ONE FAMILY"
},
{
"count": 1454,
"value": "RESIDENTIAL- HOUSE, TWO FAMILY"
},
{
"count": 908,
"value": "RESIDENTIAL TRANSIT ORIENTED DISTRICT - C"
},
{
"count": 795,
"value": "PUBLIC"
},
{
"count": 605,
"value": "RESIDENTIAL- MIXED, LOW DENSITY"
},
{
"count": 591,
"value": "RESIDENTIAL- HOUSE, THREE FAMILY"
},
{
"count": 584,
"value": "RESIDENTIAL- HOUSE, ONE FAMILY- DETACHED"
},
{
"count": 347,
"value": "NEIGHBORHOOD COMMERCIAL, CLUSTER"
},
{
"count": 216,
"value": "RESIDENTIAL- MIXED, MODERATE DENSITY"
},
{
"count": 180,
"value": "RESIDENTIAL- MIXED, MEDIUM DENSITY"
},
{
"count": 130,
"value": "RESIDENTIAL- COMMERCIAL, HIGH DENSITY"
},
{
"count": 129,
"value": "PDR PRODUCTION, DISTRIBUTION, AND REPAIR"
},
{
"count": 112,
"value": "URBAN MIXED USE"
},
{
"count": 101,
"value": "COMMUNITY BUSINESS"
},
{
"count": 97,
"value": "PRODUCTION, DISTRIBUTION & REPAIR - 1 - GENERAL"
},
{
"count": 95,
"value": "GEARY BOULEVARD NEIGHBORHOOD COMMERCIAL DISTRICT"
},
{
"count": 87,
"value": "NEIGHBORHOOD COMMERCIAL, SMALL SCALE"
},
{
"count": 85,
"value": "NEIGHBORHOOD COMMERCIAL, MODERATE SCALE"
},
{
"count": 75,
"value": "EXCELSIOR OUTER MISSION STREET NEIGHBORHOOD COMMERCIAL DISTRICT"
},
{
"count": 75,
"value": "RESIDENTIAL TRANSIT ORIENTED- MISSION"
}
]
},
"datatype": "text",
"description": "districtname",
"field_name": "districtna",
"name": "districtname",
"position": 3,
"render_type": "text"
},
{
"cached": {
"cardinality": 10617,
"count": 10617,
"non_null_count": 10617,
"null_count": 0,
"top": [
{
"count": 4506,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-20077"
},
{
"count": 1068,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-56337"
},
{
"count": 908,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-20086"
},
{
"count": 790,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-50175"
},
{
"count": 347,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-25360#rid-0-0-0-25492"
},
{
"count": 282,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-20123"
},
{
"count": 222,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-20120"
},
{
"count": 162,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-20083"
},
{
"count": 158,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-20086"
},
{
"count": 112,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-67810"
},
{
"count": 101,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-20117"
},
{
"count": 99,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-34612"
},
{
"count": 95,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-25360#rid-0-0-0-62706"
},
{
"count": 87,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-25360#rid-0-0-0-25507"
},
{
"count": 85,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-25360#rid-0-0-0-25522"
},
{
"count": 75,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-25360#rid-0-0-0-25623"
},
{
"count": 73,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-21366"
},
{
"count": 66,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-19790#rid-0-0-0-20132"
},
{
"count": 57,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-25360#rid-0-0-0-57664"
},
{
"count": 48,
"value": "https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-70715"
}
]
},
"datatype": "text",
"description": "url",
"field_name": "url",
"name": "url",
"position": 4,
"render_type": "text"
},
{
"cached": {
"cardinality": 10617,
"count": 10617,
"non_null_count": 10617,
"null_count": 0,
"top": [
{
"count": 5894,
"value": "Residential"
},
{
"count": 2214,
"value": "Mixed Use"
},
{
"count": 1292,
"value": "Commercial"
},
{
"count": 836,
"value": "Public"
},
{
"count": 378,
"value": "Industrial"
},
{
"count": 3,
"value": "Mixed"
}
]
},
"datatype": "text",
"description": "gen",
"field_name": "gen",
"name": "gen",
"position": 5,
"render_type": "text"
},
{
"cached": {
"cardinality": 10617,
"count": 10617,
"non_null_count": 10617,
"null_count": 0,
"top": [
{
"count": 1872,
"value": "RH-1"
},
{
"count": 1454,
"value": "RH-2"
},
{
"count": 908,
"value": "RTO-C"
},
{
"count": 795,
"value": "P"
},
{
"count": 605,
"value": "RM-1"
},
{
"count": 591,
"value": "RH-3"
},
{
"count": 584,
"value": "RH-1(D)"
},
{
"count": 347,
"value": "NC-1"
},
{
"count": 216,
"value": "RM-2"
},
{
"count": 180,
"value": "RM-3"
},
{
"count": 130,
"value": "RC-4"
},
{
"count": 128,
"value": "PDR-2"
},
{
"count": 112,
"value": "UMU"
},
{
"count": 101,
"value": "C-2"
},
{
"count": 97,
"value": "PDR-1-G"
},
{
"count": 95,
"value": "NCD-GEARY BOULEVARD"
},
{
"count": 87,
"value": "NC-2"
},
{
"count": 85,
"value": "NC-3"
},
{
"count": 83,
"value": "RTO-1"
},
{
"count": 75,
"value": "RTO-M"
}
]
},
"datatype": "text",
"description": "zoning",
"field_name": "zoning",
"name": "zoning",
"position": 6,
"render_type": "text"
},
{
"cached": {
"cardinality": 10617,
"count": 10617,
"non_null_count": 9709,
"null_count": 908,
"top": [
{
"count": 4507,
"value": "209.1"
},
{
"count": 1068,
"value": "209.2"
},
{
"count": 794,
"value": "211"
},
{
"count": 347,
"value": "710.1"
},
{
"count": 283,
"value": "210.3"
},
{
"count": 223,
"value": "210.2"
},
{
"count": 162,
"value": "209.3"
},
{
"count": 158,
"value": "209.4"
},
{
"count": 112,
"value": "843"
},
{
"count": 101,
"value": "210.1"
},
{
"count": 99,
"value": "249.64"
},
{
"count": 95,
"value": "739"
},
{
"count": 87,
"value": "711.1"
},
{
"count": 85,
"value": "712.1"
},
{
"count": 75,
"value": "720"
},
{
"count": 70,
"value": "249.52"
},
{
"count": 66,
"value": "210.4"
},
{
"count": 57,
"value": "752"
},
{
"count": 48,
"value": "844"
},
{
"count": 48,
"value": "722.1"
}
]
},
"datatype": "text",
"description": "codesection",
"field_name": "codesectio",
"name": "codesection",
"position": 7,
"render_type": "text"
}
],
"created_at": "2019-12-26T19:04:34Z",
"custom_fields": {
"Department Metrics": {
"Publishing Department": "Planning"
},
"Geospatial API Pre-release": {
"Enabled": "true"
},
"Internal Management": {
"Inventory ID": "CPC-0009"
},
"Publishing Details": {
"Data change frequency": "Quarterly",
"Geographic unit": "",
"Program link": "",
"Publishing frequency": "Quarterly"
}
},
"description": "The Zoning Districts are a component of the Zoning Map which in turn is a key component of the San Francisco Planning Code. More information can be found here: https://sfplanning.org/zoning\n\nThe official zoning map can be found here: https://experience.arcgis.com/experience/573d02b43b7b46e381df04b7f225da95",
"display_type": "table",
"download_count": 3109,
"id": "3i4a-hu95",
"license": {
"id": "PDDL",
"name": "Open Data Commons Public Domain Dedication and License",
"terms_link": "http://opendatacommons.org/licenses/pddl/1.0/"
},
"metadata_url": "https://data.sf.gov/api/views/3i4a-hu95.json",
"name": "Zoning Map - Zoning Districts",
"observed_at_ms": 1790056199439,
"provenance": "official",
"publication_date": "2019-12-26T19:07:58Z",
"publishing_department": "Planning",
"publishing_frequency": "Quarterly",
"rows_updated_at": "2026-09-21T11:24:30Z",
"source_url": "https://data.sf.gov/d/3i4a-hu95",
"tags": [
"planning",
"zoning",
"development"
],
"view_count": 17577,
"view_last_modified": "2026-09-21T11:24:23Z"
}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)
Use cases
1Built-in skills that call DataSF open data portal.
Related providers
Browse the library//
Get started
//
Give your agent DataSF open data portal.
One API key for the live web and every provider in Alexandria.
Are you an AI agent? See setup options