Ask the Grid
Create free workspace

CONAGUA Daily Reservoir, River and Climate Measurements

CONAGUA's daily station measurements: reservoir level, stored volume, outflow and spill; river discharge; rainfall, evaporation, temperatures, pressure and humidity.

CONAGUAHydrology dataCENACE market
Query with the agent
Native record
station x day
daily observations, refreshed four times a day in rotation publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · observation_date

Overview

Some stations reach back to the 1920s.

Query contract

Preserve one canonical row per (station_kind, station_id, observation_date) before aggregating.

Analysis rules

  • station_kind is 'presas' (reservoirs), 'hidros' (river gauges) or 'climas' (weather stations); station_id joins cenace.hydrology_stations on (station_kind, station_id).
  • Dedupe with argMax(value, ingested_at) per (station_kind, station_id, observation_date).

Interpretation

  • Collection is a bounded, resumable backfill: a station or date absent here may simply not have been fetched yet. Say the history is incomplete rather than calling it missing at the source.
  • Each variable has its own history inside a station's span; a NULL is not a zero.

Access

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema21

Column
Type
station_kindString
station_idString
observation_dateDate32
precipitation_mmNullable(Float64)
level_mNullable(Float64)
stored_volume_million_m3Nullable(Float64)
outlet_flow_m3_sNullable(Float64)
spillway_flow_m3_sNullable(Float64)
overflow_m3_sNullable(Float64)
discharge_m3_sNullable(Float64)
evaporation_mmNullable(Float64)
mean_temperature_cNullable(Float64)
maximum_temperature_cNullable(Float64)
minimum_temperature_cNullable(Float64)
ambient_temperature_cNullable(Float64)
barometric_pressure_g_cm2Nullable(Float64)
relative_humidity_percentNullable(Float64)
source_urlNullable(String)
snapshot_atDateTime64(6, 'UTC')
native_jsonNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

station_kindstation_idobservation_dateprecipitation_mmlevel_mstored_volume_million_m3outlet_flow_m3_sspillway_flow_m3_soverflow_m3_sdischarge_m3_sevaporation_mmmean_temperature_cmaximum_temperature_cminimum_temperature_cambient_temperature_cbarometric_pressure_g_cm2relative_humidity_percentsource_urlsnapshot_atnative_jsoningested_at
presasLDYGJ2026-10-091.51730.28219.6716.35600∅8.3∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LDYGJ.csv2026-10-10 08:16:23.629021{"Estacion":"LDYGJ","Fecha":"2026-10-09","Nivel(m)":"1730.28","Precipitacion(mm)":"1.5","VolumenAlm(Mm3)":"219.67","ObraToma(m3/s)":"16.356","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"8.3"}2026-10-10 08:17:41.025253
presasLFGCL2026-10-090294.714.624000∅3.3∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LFGCL.csv2026-10-10 08:17:46.683338{"Estacion":"LFGCL","Fecha":"2026-10-09","Nivel(m)":"294.7","VolumenAlm(Mm3)":"14.624","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Precipitacion(mm)":"0.0","Evaporacion(mm)":"3.3"}2026-10-10 08:18:14.712239
presasLJSCH2026-10-0901551.4238.741000∅4.55∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LJSCH.csv2026-10-10 08:18:21.283342{"Estacion":"LJSCH","Fecha":"2026-10-09","Nivel(m)":"1551.42","Precipitacion(mm)":"0.0","VolumenAlm(Mm3)":"38.741","ObraToma(m3/s)":"0.0","Evaporacion(mm)":"4.55","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0"}2026-10-10 08:19:14.550978
presasLLAHD2026-10-0972177.9715.139000∅∅∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LLAHD.csv2026-10-10 08:19:19.816471{"Estacion":"LLAHD","Fecha":"2026-10-09","Precipitacion(mm)":"7.0","Nivel(m)":"2177.97","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","VolumenAlm(Mm3)":"15.139","Evaporacion(mm)":""}2026-10-10 08:20:05.130030
presasLLAQT2026-10-09∅1888.241.877000∅∅∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LLAQT.csv2026-10-10 08:20:08.946728{"Estacion":"LLAQT","Fecha":"2026-10-09","Nivel(m)":"1888.24","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","VolumenAlm(Mm3)":"1.877","Precipitacion(mm)":"","Evaporacion(mm)":""}2026-10-10 08:20:34.079286
presasLLNCH2026-10-0901017.0228.304000∅7.41∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LLNCH.csv2026-10-10 08:20:39.779060{"Estacion":"LLNCH","Fecha":"2026-10-09","Precipitacion(mm)":"0.0","Nivel(m)":"1017.02","Evaporacion(mm)":"7.41","ObraToma(m3/s)":"0.0","VolumenAlm(Mm3)":"28.304","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0"}2026-10-10 08:21:30.917834
presasLNRDR2026-10-09016484.8550.100∅∅∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LNRDR.csv2026-10-10 08:21:38.270969{"Estacion":"LNRDR","Fecha":"2026-10-09","Nivel(m)":"1648.0","VolumenAlm(Mm3)":"4.855","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","ObraToma(m3/s)":"0.1","Precipitacion(mm)":"0.0","Evaporacion(mm)":""}2026-10-10 08:22:03.191556
presasLOBZC2026-10-0902077.096.944000.557∅5∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LOBZC.csv2026-10-10 08:22:09.446547{"Estacion":"LOBZC","Fecha":"2026-10-09","Precipitacion(mm)":"0.0","VolumenAlm(Mm3)":"6.944","Nivel(m)":"2077.09","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.557","Evaporacion(mm)":"5.0"}2026-10-10 08:22:48.706007
presasLOLMC2026-10-093.3417.910.108000∅3.66∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LOLMC.csv2026-10-10 08:22:53.844633{"Estacion":"LOLMC","Fecha":"2026-10-09","Precipitacion(mm)":"3.3","Nivel(m)":"417.9","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","VolumenAlm(Mm3)":"10.108","Evaporacion(mm)":"3.66"}2026-10-10 08:23:44.239527
presasLREZC2026-10-0902123.354.171000∅4.18∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/LREZC.csv2026-10-10 08:24:35.104096{"Estacion":"LREZC","Fecha":"2026-10-09","Nivel(m)":"2123.3","Precipitacion(mm)":"0.0","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"4.18","VolumenAlm(Mm3)":"54.171"}2026-10-10 08:25:37.336971
presasMALCP2026-10-090164.447429.49333.8300∅1.32∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/MALCP.csv2026-10-10 08:25:48.228744{"Estacion":"MALCP","Fecha":"2026-10-09","Precipitacion(mm)":"0.0","Nivel(m)":"164.44","VolumenAlm(Mm3)":"7429.49","ObraToma(m3/s)":"333.83","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"1.32"}2026-10-10 08:26:49.026245
presasMOCMC2026-10-0931707.63112.81000∅5.27∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/MOCMC.csv2026-10-10 08:28:07.644260{"Estacion":"MOCMC","Fecha":"2026-10-09","Precipitacion(mm)":"3.0","Nivel(m)":"1707.63","VolumenAlm(Mm3)":"112.81","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"5.27"}2026-10-10 08:29:17.531762
presasMRGTP2026-10-09074.59560.896000∅4.8∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/MRGTP.csv2026-10-10 08:30:56.489177{"Estacion":"MRGTP","Fecha":"2026-10-09","Nivel(m)":"74.59","VolumenAlm(Mm3)":"560.896","Precipitacion(mm)":"0.0","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"4.8"}2026-10-10 08:32:08.987411
presasNGRAG2026-10-0901828.4916.4480.7801.789∅2.75∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/NGRAG.csv2026-10-10 08:32:49.605516{"Estacion":"NGRAG","Fecha":"2026-10-09","Precipitacion(mm)":"0.0","Nivel(m)":"1828.49","VolumenAlm(Mm3)":"16.448","ObraToma(m3/s)":"0.78","Derrame(m3/s)":"1.789","Vertedor(m3/s)":"0.0","Evaporacion(mm)":"2.75"}2026-10-10 08:33:49.396616
presasNNEPB2026-10-0951328.2912.818000∅∅∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/NNEPB.csv2026-10-10 08:33:52.586643{"Estacion":"NNEPB","Fecha":"2026-10-09","Precipitacion(mm)":"5.0","Nivel(m)":"1328.29","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","VolumenAlm(Mm3)":"12.818","Evaporacion(mm)":""}2026-10-10 08:34:27.680182
presasPAGCH2026-10-0901609.5217.769000∅4.4∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PAGCH.csv2026-10-10 08:34:33.225384{"Estacion":"PAGCH","Fecha":"2026-10-09","VolumenAlm(Mm3)":"17.769","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Nivel(m)":"1609.52","Precipitacion(mm)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"4.4"}2026-10-10 08:34:58.170872
presasRSPTP2026-10-090.582.3148.397000∅4.83∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/RSPTP.csv2026-10-10 14:21:01.759956{"Estacion":"RSPTP","Fecha":"2026-10-09","Nivel(m)":"82.31","Precipitacion(mm)":"0.5","VolumenAlm(Mm3)":"48.397","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"4.83"}2026-10-10 14:21:40.160809
presasPALZC2026-10-0901904.324.698000.629∅3.74∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PALZC.csv2026-10-10 08:36:04.338424{"Estacion":"PALZC","Fecha":"2026-10-09","Precipitacion(mm)":"0.0","Nivel(m)":"1904.32","VolumenAlm(Mm3)":"4.698","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.629","ObraToma(m3/s)":"0.0","Evaporacion(mm)":"3.74"}2026-10-10 08:36:49.961934
presasPECAG2026-10-0902006.46118.1350.600∅3.13∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PECAG.csv2026-10-10 08:36:56.472320{"Estacion":"PECAG","Fecha":"2026-10-09","Precipitacion(mm)":"0.0","Nivel(m)":"2006.46","VolumenAlm(Mm3)":"118.135","ObraToma(m3/s)":"0.6","Derrame(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Evaporacion(mm)":"3.13"}2026-10-10 08:38:03.125515
presasPECSO2026-10-090278.591746.715147.66900∅4.57∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PECSO.csv2026-10-10 08:38:12.959461{"Estacion":"PECSO","Fecha":"2026-10-09","Nivel(m)":"278.59","Precipitacion(mm)":"0.0","VolumenAlm(Mm3)":"1746.715","ObraToma(m3/s)":"147.669","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"4.57"}2026-10-10 08:38:57.897735
presasPEMVC2026-10-095110.842.540.1500.838∅∅∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PEMVC.csv2026-10-10 08:39:05.517941{"Estacion":"PEMVC","Fecha":"2026-10-09","Nivel(m)":"110.84","Precipitacion(mm)":"5.0","VolumenAlm(Mm3)":"2.54","ObraToma(m3/s)":"0.15","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.838","Evaporacion(mm)":""}2026-10-10 08:39:18.542203
presasPAGDR2026-10-0901891.9323.935000∅∅∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PAGDR.csv2026-10-10 08:35:03.451885{"Estacion":"PAGDR","Fecha":"2026-10-09","Nivel(m)":"1891.93","Precipitacion(mm)":"0.0","VolumenAlm(Mm3)":"23.935","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":""}2026-10-10 08:35:52.703285
presasPTZMC2026-10-096.62034.74282.078000∅∅∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PTZMC.csv2026-10-10 14:16:17.494588{"Estacion":"PTZMC","Fecha":"2026-10-09","Precipitacion(mm)":"6.6","Nivel(m)":"2034.74","VolumenAlm(Mm3)":"282.078","ObraToma(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":""}2026-10-10 14:16:48.588805
presasPTRAG2026-10-0902087.011.2911.3600∅1.65∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PTRAG.csv2026-10-10 14:14:56.070012{"Estacion":"PTRAG","Fecha":"2026-10-09","Precipitacion(mm)":"0.0","Nivel(m)":"2087.01","VolumenAlm(Mm3)":"1.291","ObraToma(m3/s)":"1.36","Derrame(m3/s)":"0.0","Vertedor(m3/s)":"0.0","Evaporacion(mm)":"1.65"}2026-10-10 14:16:13.617985
presasPRGHD2026-10-09111977.0840.7920.4500∅1.22∅∅∅∅∅∅https://sih.conagua.gob.mx/basedatos/Presas/PRGHD.csv2026-10-10 14:11:25.259551{"Estacion":"PRGHD","Fecha":"2026-10-09","Nivel(m)":"1977.08","Precipitacion(mm)":"11.0","VolumenAlm(Mm3)":"40.792","ObraToma(m3/s)":"0.45","Vertedor(m3/s)":"0.0","Derrame(m3/s)":"0.0","Evaporacion(mm)":"1.22"}2026-10-10 14:12:06.269431

Coverage

No time-indexed data — coverage isn’t applicable to this dataset.