Raw ArcGIS query
raw_queryRun raw SQL-92 WHERE queries against ArcGIS well-data layers to retrieve attributes for filters beyond standard search, such as dates, depths, and cumulative production.
Instructions
Escape hatch: run a raw SQL-92 WHERE clause against one source's ArcGIS layer and get raw attributes back. Use list_sources for source keys; field names are the layer's own (see the searchableFilters mapping, or query with where='1=1' limit=1 to inspect a record). Useful for filters the normalized search does not cover (dates, depths, cumulative production).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| where | Yes | ArcGIS SQL-92 where clause, e.g. "totcum_oil > 1000000 AND county = 'BEAVER'" | |
| offset | No | ||
| source | Yes | Source key, e.g. UT or CA-OG. | |
| out_fields | No | Comma-separated field list, or * for all. | * |