Query River Mile Markers by River and Mile Range
usace_rivermile_queryQuery USACE river mile markers by river name or mile-value range to find marker locations, names, and coordinates. Returns paginated results ordered by mile, with total count and offset for navigation.
Instructions
Query USACE river mile markers by river name and/or mile-value range.
Use when: "List markers on the RED river", "How many markers on the Mississippi between mile 400 and 600?", "Show markers on the Ohio above mile 900" (mile_min=900).
Results are ordered by MILE ascending and paginated. total_count reflects all matching markers; use next_offset to fetch the next page.
Returns: { "count": int, # markers on this page "total_count": int, # total markers matching the filter "has_more": bool, "next_offset": int|null, # pass as 'offset' to get the next page "where": str, # the WHERE clause applied (for transparency) "markers": [ { name, MILE, RIVER_NAME, RIVER_CODE, RIVER_NUMB, LONGITUDE1, LATITUDE1, SOURCE }, ... ], "provenance": { source agency, dataset, service URL, layer, CRS, retrieved_utc } }
Error responses:
"Error: mile_min cannot be greater than mile_max"
"Error: provide at least one filter (river_name, mile_min, or mile_max)"
"Error: River Mile request failed: ..."
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum markers to return per page. Default 25. | |
| offset | No | Number of matching markers to skip (for pagination). Default 0. | |
| mile_max | No | Maximum river mile value (inclusive). Omit for no upper bound. | |
| mile_min | No | Minimum river mile value (inclusive). Omit for no lower bound. | |
| river_name | No | River name to filter on (case-insensitive substring match against RIVER_NAME, e.g. 'RED', 'MISSISSIPPI', 'OHIO'). Omit to match all rivers. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||