DataSF open data portal · Rows
data-sf-gov/open-data/rowsSearch 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
| Field | Kind | Default | Description |
|---|---|---|---|
dataset_id required | text | — | 4x4 id (for example |
q | text | — | SoQL $q full-text search across all text columns. |
group | text | — | SoQL $group; pair with aggregates in |
limit | number 1 to 50000 | 100 | Rows per page. The portal caps a request at 50000; wide datasets with geometry should use far less. |
order | text | — | SoQL $order, for example |
where | text | — | SoQL $where, for example |
cursor | text | — | Row offset to start from: the |
select | text | — | SoQL $select, for example |
filters | JSON | — | Bare equality filters sent as |
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.