Skip to content
Eden Engine
Get started

San Mateo County Open Data: Dataset Rows by SoQL Query

smcgovopendata/dataset-rows

Queries any tabular dataset on the San Mateo County open data portal by its dataset id with SoQL: choose columns, filter rows, order, limit (1 to 25 rows, default 10) and page. Returns the rows with the dataset's own columns; most numbers arrive as strings and geometry columns are GeoJSON, so select only the columns you need. An unknown dataset id or a column that does not exist returns a validation error. Passed through unmodified and served by Eden Engine; not an official County of San Mateo product.

activeper callv1

Price

$0.0026 per call

You pay the price shown. If a call turns out to cost more than its quote, you pay the actual price, capped at twice the quote. No monthly minimum. Top-ups start at $0.50.

Data source

San Mateo County Open Data (data.smcgov.org)

Data from the County of San Mateo, published on Open San Mateo County (data.smcgov.org). Each dataset's metadata names its publishing department and licence. Served by Eden Engine; not an official County of San Mateo product.

Use it

Five steps: search, inspect, learn, run, settle. No per-tool setup; your agent reaches this tool through the meta-tools it already has.

Connect once and your AI can find and run this tool, and any other it needs.

Install itCreate an account
agent
// 1. search: find the tool
omnial_search({ query: "what you need" })

// 2. inspect: price and input schema
omnial_inspect({ tool: "smcgovopendata/dataset-rows" })

// 3. learn: read the usage guide at runtime
omnial_learn({ tool: "smcgovopendata/dataset-rows" })

// 4. run: price the exact call first, then run it
omnial_execute({ tool: "smcgovopendata/dataset-rows", input: { /* see input_schema */ }, dry_run: true })
omnial_execute({ tool: "smcgovopendata/dataset-rows", input: { /* ... */ } })

// 5. settle: the call is charged when it finishes, nothing to do

Not connected yet? Point your MCP client at https://mcp.eden-engine.com/mcp, then copy a config for your client.

Pricing

Every charge this tool can incur.

ChargePrice
Per call
$0.0026
Updated
Oct 24, 2026

Input and output schemas

Input schema
input_schema.json
{
  "type": "object",
  "required": [
    "dataset_id"
  ],
  "properties": {
    "limit": {
      "type": "integer",
      "default": 10,
      "maximum": 25,
      "minimum": 1,
      "description": "How many rows to return, 1 to 25. Defaults to 10."
    },
    "order": {
      "type": "string",
      "maxLength": 200,
      "description": "Optional SoQL ordering, for example precinctid DESC."
    },
    "where": {
      "type": "string",
      "maxLength": 500,
      "description": "Optional SoQL filter, for example precinctid = '0100'. A column the dataset does not have is refused as a validation error."
    },
    "offset": {
      "type": "integer",
      "maximum": 1000000,
      "minimum": 0,
      "description": "Rows to skip, for reading further pages in the order given by `order`. Leave out to start at the first row."
    },
    "select": {
      "type": "string",
      "maxLength": 500,
      "description": "Optional SoQL select: a comma list of columns or expressions, for example precinctid,lastupdate, or count(*). Leave out for every column, geometry included."
    },
    "dataset_id": {
      "type": "string",
      "pattern": "^[a-z0-9]{4}-[a-z0-9]{4}$",
      "description": "The dataset's 8-character id, two groups of four lowercase letters or digits joined by a hyphen, for example g5sj-6zp8 (Election Precincts). Find ids with the dataset catalog tool."
    }
  },
  "additionalProperties": false
}
Output schema
output_schema.json
{
  "type": "object",
  "required": [
    "results"
  ],
  "properties": {
    "results": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": true
      },
      "description": "One object per row, with the dataset's own columns. Empty when the filter matches nothing."
    }
  },
  "additionalProperties": true
}