Hydrological observations
Automated quantitative and qualitative water measurements from the national hydrological monitoring network operated by the FOEN. The data product exposes station metadata, aggregated observation time series (10-minute, hourly, daily, monthly and yearly) and a near-real-time live feed (5–10 minute cadence, 7-day rolling window).
Results are returned in no particular order and a single query is capped at 10 000 rows. Queries that exceed the cap are rejected rather than truncated. Larger datasets are retrieved by partitioning into smaller filter windows (typically a date range) and iterating. See Pagination for details.
Available fields
| Field | Type | Notes |
|---|---|---|
no | String | Station number. |
name | String | Station name. |
siteName | String | Site name. |
riverName | String | River or water body name. |
catchmentName | String | Catchment area name. |
localX | Float | X coordinate (Swiss LV95). |
localY | Float | Y coordinate (Swiss LV95). |
latitude | Float | Latitude (WGS84). |
longitude | Float | Longitude (WGS84). |
status | String | Operational status. Values: Aufgebaut (in operation), Aufgehoben (decommissioned). |
elevation | Float | Elevation in metres above sea level. |
adminName | String | Administrative area name. |
adminLevel | String | Administrative level. |
coverageFrom | AWSDateTime | Earliest date for which data is available. |
coverageTo | AWSDateTime | Latest date for which data is available. |
Available fields
| Field | Type | Notes |
|---|---|---|
parameterName | String | Parameter code. Common values: Q (discharge), W (water level), WT (water temperature). |
tsName | String | Time-series name. |
unitName | String | Unit, full name. |
unitSymbol | String | Unit symbol, e.g. m³/s, °C, m ü.M. |
timestamp | AWSDateTime | Aggregation interval start (ISO-8601 UTC). |
value | Float | Aggregated measurement value. |
releaseState | String | Release / validation state. Values: 1 (provisional), 2 (validated), 3 (final / replaced). |
station | Water_Observations_Station | Nested station metadata: name, no, latitude, longitude, id. |
Available fields
| Field | Type | Notes |
|---|---|---|
stationNo | String | Station number (BAFU 4-digit code, range 2000–2999). |
parameterName | String | Normalised parameter code: W (water level), Q (discharge), WT (water temperature). |
timestamp | AWSDateTime | Observation timestamp (ISO-8601 UTC). |
value | Float | Measured value in the parameter's native unit. |
releaseStatus | Int | Release status flag; always 0 for the live (uncorrected) feed. |
Download data
The full time series are available as prepared, monthly-grouped files
(.csv.gz) for direct download — organised by year and aggregation
level. For targeted, filtered extracts, use the GraphQL API.
Dateien werden geladen…
Notes
- Filter operators follow the Hasura convention:
_eq,_neq,_in,_gte,_lt,_between, etc. - Timestamps are ISO-8601 in UTC (
YYYY-MM-DDTHH:MM:SSZ). - Available aggregations:
data_10min_mean,data_1hour_mean,data_1day_mean,data_1day_min,data_1day_max,data_1month_mean,data_1year_mean, anddata_live. - For long time series the request is split into
timestampwindows that each stay under 10 000 rows. See the note above. - The
data_livefeed has different characteristics from the aggregated feeds: rows older than 12 hours are not exposed, observations appear in the API approximately 9–19 minutes after the sensor reading, and the row shape omits the nestedstationobject.
Contact
Questions about the content of this dataset can be addressed to the FOEN — see Contact.