La Query
la_queryRun a raw SoQL query against any Los Angeles open-data resource (data.lacity.org) by its Socrata id (8-char like "2nrs-mtv8"). Full SoQL: where/select/group/order/limit/offset. Use la_datasets to find a resource id, or la_recent for the common ones.
Example tool call
This call uses example arguments supplied in the tool’s input schema.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"limit": 100,
"where": "crm_cd_desc='BURGLARY'",
"_apiKey": "your-data-la-api-key",
"resource_id": "2nrs-mtv8"
},
"name": "la_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| group | No | SoQL $group (e.g. "crm_cd_desc"). | |
| limit | No | Max rows (default 100, max 5000). | |
| order | No | SoQL $order (e.g. "date_occ DESC"). | |
| where | No | SoQL $where filter (e.g. "area_name='Central'"). | |
| offset | No | Row offset for paging. | |
| select | No | SoQL $select (e.g. "crm_cd_desc, count(*)"). | |
| _apiKey | No | Optional, your own Socrata app token for higher rate limits. Omit to use the keyless endpoint. | |
| resource_id | Yes | Socrata resource id, e.g. "2nrs-mtv8" (crime data). |