Exports & the API

Four report types cover most deliverable needs; the REST API covers the rest. Reports build in the background and appear on the Exports tab when ready.

The Reporting tab with its four report cards — The Reporting tab. Each card opens a configurator: gages, columns or panels, and date range.

Data workbook (Excel)

Every reading from your selected gages, one sheet per gage, with optional derived columns — rolling averages at several windows, percent-change and spike flags, z-score and outlier flags, and a per-gage daily statistics sheet. Derived columns are built as live Excel formulas with their thresholds on a Params sheet, so you can adjust them in the workbook without rebuilding the export.

Formula windows count rows and assume an unbroken 15-minute cadence, so gaps in the record stretch a window's real time span. Server-side analytics use time-based windows and exclude flagged rows; results can differ slightly. The workbook restates this caveat on its Params sheet.

Visualization workbook (Excel)

The charts from the gage detail page rebuilt as native Excel charts — hydrograph, percentile envelope, flow-duration, distribution, daily range, water-year comparison, annual statistics, and several deep-dive panels (cumulative volume, flow-condition classes, monthly distribution). Native charts mean you can restyle them and paste them into your own documents. Works in Excel and Google Sheets.

Statistics workbook (Excel)

Summary statistics per gage over your date range: mean, median, percentiles, monthly breakdowns, and the period set against prior water years.

Flow conditions report (PDF)

A print-ready PDF of daily flow per gage with percentile context and flow-condition classes (the standard USGS WaterWatch classes, from "Much below normal" to "Much above normal", based on period-of-record percentiles for the day of year). Every chart links back to the live record.

The REST API

Everything the site displays is available under /api/v1/. Authentication is by session or JWT (verified accounts); interactive reference and schema live at /api/docs/ (OpenAPI JSON at /api/schema/).

Endpoint	Returns
`GET /api/v1/gauges/?gage_key=…&start=…&end=…`	Readings for a gage over a date range
`GET /api/v1/sources/available/`	Gages available to your account
`GET /api/v1/subscriptions/me/`	Your plan and limits

Source access through the API follows your plan's source cap, the same as the site.