Spiral gives your agent every tool with one account. Browse the tools →

AlexandriaListingsAvailable now

DataSF open data portal · Rows

data-sf-gov/open-data/rows

Search property, job and marketplace listings with DataSF open data portal · Rows from Alexandria through one Spiral API key. Any question that needs actual records from a DataSF dataset. Get the 4x4 id from datasets and the column field names from dataset first. Use row_count to size a query before paging. It runs in the background and returns structured JSON. Pay as you go, with no subscription.

Pricing

$0.00873 per call.

Limits

Runs
In the background
Returns
json
Longest queue wait
1 hour
Run deadline
5 minutes
Longest run, end to end
225 minutes
Largest inline input
1 MB
Largest input file
2 GB
Largest output
5 GB

Input

FieldKindDefaultDescription
dataset_id requiredtext—

4x4 id (for example 3i4a-hu95) or a data.sf.gov / data.sfgov.org URL containing it.

qtext—

SoQL $q full-text search across all text columns.

grouptext—

SoQL $group; pair with aggregates in select.

limitnumber
1 to 50000
100

Rows per page. The portal caps a request at 50000; wide datasets with geometry should use far less.

ordertext—

SoQL $order, for example filed_date DESC or count(*) DESC. Default :id when no group is given.

wheretext—

SoQL $where, for example zoning_sim like 'RH-1%', filed_date between '2026-09-01T00:00:00' and '2026-09-02T00:00:00', intersects(the_geom,'POINT(-122.3966 37.7897)'), within_circle(point,37.7897,-122.3966,50).

cursortext—

Row offset to start from: the next_cursor of the previous page. Pattern: ^[0-9]{1,12}$.

selecttext—

SoQL $select, for example zoning_sim,districtna or zoning_sim,count(*). Default: all columns.

filtersJSON—

Bare equality filters sent as field=value query parameters (for example {"blklot": "3720009"}); keys must be column field names, values strings.

Same request in code

curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "data-sf-gov/open-data/rows",
    "input": {
      "dataset_id": "<dataset_id>"
    }
  }'

Frequently asked questions

How much does DataSF open data portal · Rows cost?

$0.00873 per call. You pay as you go from one Spiral balance, with no subscription, and a failed run is not charged.

How do I use DataSF open data portal · Rows through an API?

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "data-sf-gov/open-data/rows"` and the input fields on this page, using one Spiral API key. It runs in the background: poll the run, or name a webhook to be told when it finishes.

Do I need an account with Alexandria to use DataSF open data portal · Rows?

No. Spiral runs it on its own Alexandria account and charges your Spiral balance.

Can my AI agent use DataSF open data portal · Rows?

Yes. Agents find and run it through Spiral's MCP server, CLI or agent skill, with the same API key.