DWD OBS DAILY CLIMATE SUMMARY DUCKDB DUMP 2024_05_20

Overview

This is a complete dump of the DWD Observation Daily Climate Summary dataset in one duckdb file. Query it and find out about Germany's climatological history including highs, lows, extremes etc of all parameters.

List of parameters:

• CLOUD_COVER_TOTAL
• HUMIDITY
• PRECIPITATION_FORM
• PRECIPITATION_HEIGHT
• PRESSURE_AIR_SITE
• PRESSURE_VAPOR
• SNOW_DEPTH
• SUNSHINE_DURATION
• TEMPERATURE_AIR_MAX_200
• TEMPERATURE_AIR_MEAN_200
• TEMPERATURE_AIR_MIN_005
• TEMPERATURE_AIR_MIN_200
• WIND_GUST_MAX
• WIND_SPEED

How to use

import duckdb

FILE = "dwd_obs_daily_climate_summary.duckdb"
con = duckdb.connect(FILE)
# stations
print(con.execute("SELECT * FROM stations LIMIT 1000"))
# values
print(con.execute("SELECT * FROM values LIMIT 1000"))
# or get a polars dataframe
print(con.execute("SELECT * FROM values LIMIT 1000").pl())

v0.84.0

What's Changed

• Improve the usage of the info class by @gutzbenj in #1284
• Fix DWD Obs station list column specs again by @gutzbenj in #1296

Full Changelog: v0.83.0...v0.84.0

v0.83.0

What's Changed

• Allow wide shape with multiple datasets by @gutzbenj in #1282

Full Changelog: v0.82.0...v0.83.0

v0.82.0

What's Changed

• Bump idna from 3.6 to 3.7 by @dependabot in #1273
• Bump aiohttp from 3.9.3 to 3.9.4 in the pip group across 1 directory by @dependabot in #1274
• README fixes by @1Maxnet1 in #1275
• Adjust column specs for DWD Observation station listing by @gutzbenj in #1280
• Fix parsing IMGW station list by @gutzbenj in #1281

New Contributors

• @1Maxnet1 made their first contribution in #1275

Full Changelog: v0.81.0...v0.82.0

v0.81.0

What's Changed

• Improve warming stripes by @gutzbenj in #1270
• Add tests for streamlit apps by @gutzbenj in #1271

Full Changelog: v0.80.0...v0.81.0

v0.80.0

What's Changed

• Bump poethepoet from 0.24.4 to 0.25.0 by @dependabot in #1259
• Bump pillow from 10.2.0 to 10.3.0 by @dependabot in #1264
• UI: Add warming stripes by @gutzbenj in 9ca6c6d
• Add warming stripes app by @gutzbenj in #1268

Full Changelog: v0.79.0...v0.80.0

v0.79.0

What's Changed

• Add multiple lint rules by @gutzbenj in #1245
• Set target-version of ruff to py39 by @gutzbenj in #1252
• Fix parsing of DWD Observation stations where name contains a comma

Full Changelog: v0.78.0...v0.79.0

v0.78.0

What's Changed

• Docker: Install more extras
• Cli/Restapi: Return empty values if no data is available by @gutzbenj in #1243

Full Changelog: v0.77.1...v0.78.0

v0.77.1

What's Changed

• Fix setting NOAA GHCN-h date to UTC

Full Changelog: v0.77.0...v0.77.1

v0.77.0

What's Changed

• Fix AsyncFileSystem monkeypatching breaking 3rd-party file systems by @provinzkraut in #1241
• Refactor index caching -> Remove monkeypatch for fsspec by @gutzbenj in #1242

New Contributors

• @provinzkraut made their first contribution in #1241

Full Changelog: v0.76.1...v0.77.0