query_datasf
Execute SoQL queries against San Francisco's open data datasets to retrieve structured JSON results with automatic column name correction.
Instructions
Execute a SoQL (Socrata Query Language) query against a dataset. Supports auto-correction of column names. Returns query results as JSON.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataset_id | Yes | Dataset 4x4 ID (format: xxxx-xxxx) | |
| soql | Yes | SoQL query string (1-4000 characters) | |
| auto_correct | No | Enable automatic column name correction (default: true) |