Lake Anne Water Level
At-a-glance gauges, live from the sensor. Visual reference only, data is not stored.
Expected inflow
Open-Meteo daily rainfall forecast for Reston — the incoming signal that should drive the next changes in lake level.
Interactive charts
Four core series — lake level, lake temperature, air temperature, and daily rainfall — plus an overlay where you can click the legend to isolate or combine any of them (inches on the left axis, °F on the right).
Download the dataset
Full readings = every measurement the Lake Anne Sensor has sent (all fields — level, temp, battery, radio signal — with the exact per-reading timestamp). Daily / hourly are convenience summaries joined with Open-Meteo weather. All times in UTC + US/Eastern, generated live from the database.
Schema & provenance
Two independent sources, stored in UTC and shown in US/Eastern.
| Column | Type | Unit | Description |
|---|---|---|---|
| reading_ts | datetime | UTC | Observation timestamp (PK) |
| depth_in | double | inches | Sensor stage — a near-shore, shallow gauge (relative). Use its change (Δ), not the absolute value as lake depth. |
| temp_f | double | °F | Water temperature |
| battery_pct/_v, rssi_dbm, snr_db | num | %/V/dBm/dB | Sensor health & radio signal |
| src | varchar | — | ingest — Tom's device POSTs to the API |
| Column | Type | Unit | Description |
|---|---|---|---|
| obs_ts | datetime | UTC | Hour (PK) |
| precip_mm | double | mm | Precipitation |
| temp_c | double | °C | Air temperature |
| et0_mm, humidity_pct, wind_kmh, solar_wm2, pressure_hpa, soil_moist | num | SI | Other meteorology (collected) |
Methodology
• Time: stored UTC; ET shown DST-aware (CONVERT_TZ).
• Daily level change = last reading of the ET day − prior day.
Sources
• Lake Anne Sensor — a resident's LoRa depth/temperature logger on Lake Anne.
• Weather — Open-Meteo (CC-BY 4.0).
Lake Anne Water Level · public monitoring report · all times US/Eastern.