Station Precipitation Query Builder (Any CDEC Station))
Preview
CDEC's official query builder for retrieving CSV data from any individual station, or multiple stations at once by entering comma-separated three-letter station codes. Users select station(s), sensor, duration, and date range via the form, and the tool generates the appropriate CSV download. Example query generated by this tool — single station, daily, sensor 2: https://cdec.water.ca.gov/dynamicapp/req/CSVDataServlet?Stations=ORO&SensorNums=2&dur_code=D&Start=2015-01-01&End=2024-12-31 Multiple stations (comma-separated): https://cdec.water.ca.gov/dynamicapp/req/CSVDataServlet?Stations=ORO,HTC,BLC&SensorNums=2&dur_code=D&Start=2015-01-01&End=2024-12-31 Note: monthly-duration queries (dur_code=M) for sensor 2 are only available for stations that CDEC classifies as monthly-reporting stations (see the [Monthly Precipitation Stations by River Basin list](https://cdec.water.ca.gov/reportapp/javareports?name=MonthlyPrecip)) — daily-only stations do not support monthly-duration queries. Additionally, monthly reporting start dates vary significantly by station (as early as the 1980s for some stations, as recent as January 2025 for others) — if a monthly query returns no data, try a more recent date range before concluding the station does not support monthly reporting. Station codes can be found via the [CDEC Precipitation Station Search](https://cdec.water.ca.gov/dynamicapp/staSearch?sta=&sensor_chk=on&sensor=45&collect=DATA+COLLECTION+TYPE&dur=D), the [Daily](https://cdec.water.ca.gov/reportapp/javareports?name=DailyPrecip) and [Monthly](https://cdec.water.ca.gov/reportapp/javareports?name=MonthlyPrecip) Precipitation Stations by River Basin lists, or the [PRECIPMON reference report](https://cdec.water.ca.gov/reportapp/javareports?name=PRECIPMON).