# DataSF open data portal · 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.

- Provider: Alexandria
- Category: Listings
- Runs: In the background
- Returns: json
- Tool id: `alexandria` / `data-sf-gov/open-data/rows`
- Page: https://spiral.ai/tools/alexandria/data-sf-gov/open-data/rows

## Pricing

$0.00873 per call.

## Limits

- 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 | Allowed | Default | Description |
| --- | --- | --- | --- | --- |
| `dataset_id` (required) | text |  | — | 4x4 id (for example `3i4a-hu95`) or a data.sf.gov / data.sfgov.org URL containing it. |
| `q` | text |  | — | SoQL $q full-text search across all text columns. |
| `group` | text |  | — | SoQL $group; pair with aggregates in `select`. |
| `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 `filed_date DESC` or `count(*) DESC`. Default `:id` when no `group` is given. |
| `where` | text |  | — | 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)`. |
| `cursor` | text |  | — | Row offset to start from: the `next_cursor` of the previous page. Pattern: ^[0-9]{1,12}$. |
| `select` | text |  | — | SoQL $select, for example `zoning_sim,districtna` or `zoning_sim,count(*)`. Default: all columns. |
| `filters` | JSON |  | — | Bare equality filters sent as `field=value` query parameters (for example {"blklot": "3720009"}); keys must be column field names, values strings. |

## Example

```bash
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>"
    }
  }'
```

Try it in the Playground: https://spiral.ai/start?provider=alexandria&model=data-sf-gov%2Fopen-data%2Frows

## Common questions

### DataSF open data portal · Rows

**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.

