# City of Edmonton Open Data · Rows

Search public records with City of Edmonton Open Data · Rows from Alexandria through one Spiral API key. Any question that needs actual records from a Edmonton Open Data 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: Public Records
- Runs: In the background
- Returns: json
- Tool id: `alexandria` / `data-edmonton-ca/open-data/rows`
- Page: https://spiral.ai/tools/alexandria/data-edmonton-ca/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 `24uj-dj8v`) or a data.edmonton.ca 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 `issue_date DESC` or `count(*) DESC`. Default `:id` when no `group` is given. |
| `where` | text |  | — | SoQL $where, for example `address like '%86 STREET NW'`, `issue_date between '2026-09-01T00:00:00' and '2026-09-30T23:59:59'`, `within_circle(geometry_point,53.5449,-113.4885,200)`. |
| `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 `address,construction_value` or `job_category,count(*)`. Default: all columns. |
| `filters` | JSON |  | — | Bare equality filters sent as `field=value` query parameters (for example {"job_category": "Commercial Final"}); 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-edmonton-ca/open-data/rows",
    "input": {
      "dataset_id": "<dataset_id>"
    }
  }'
```

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

## Common questions

### City of Edmonton Open Data · Rows

**How much does City of Edmonton Open Data · 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 City of Edmonton Open Data · Rows through an API?**

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "data-edmonton-ca/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 City of Edmonton Open Data · Rows?**

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

**Can my AI agent use City of Edmonton Open Data · Rows?**

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

