Read and query a CSV/JSON data file from data.geo.admin.ch
read_geodata_assetFetch and query CSV or JSON assets from data.geo.admin.ch, returning rows you can filter, sort and page, with tail support for recent time-series values.
Instructions
Download a CSV or JSON asset from data.geo.admin.ch (href from get_geodata_collection_items) and return it as rows you can filter, sort and page, e.g. MeteoSwiss SwissMetNet station files. Filters: where={column: value} (exact), '~text' (substring), '>n'/'<n' (numeric). tail=true returns the latest rows of a time series. Example: url='https://data.geo.admin.ch/ch.meteoschweiz.ogd-smn/ber/ogd-smn_ber_d_recent.csv', tail=true, limit=7, columns=['reference_timestamp','tre200d0','rre150d0']. Large historical files may exceed max_mb, prefer '_recent' or '_now' files.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"url": "<url>"
},
"name": "read_geodata_asset"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | Yes | Asset href on https://data.geo.admin.ch/ (CSV, TXT or JSON/GeoJSON) | |
| sort | No | Sort column; prefix '-' for descending | |
| tail | No | Return the LAST matching rows (latest values of a time series) | |
| limit | No | Max rows (default 50) | |
| where | No | Column filters, e.g. {"station_abbr": "BER"} or {"tre200d0": ">25"} | |
| max_mb | No | Download size cap in MB (default 8, max 20) | |
| offset | No | Skip this many matching rows (ignored with tail) | |
| search | No | Case-insensitive text search across all columns | |
| columns | No | Columns to return (default all; max 40) |