def sql_example():
request = DwdObservationRequest(
parameter=[DwdObservationDataset.TEMPERATURE_AIR],
resolution=DwdObservationResolution.HOURLY,
start_date="2019-01-01",
end_date="2020-01-01",
tidy=True,
humanize=True,
)
stations = request.filter_by_station_id(station_id=(1048, ))
sql = "SELECT * FROM data WHERE parameter='temperature_air_200' AND value < -7.0;"
log.info(f"Invoking SQL query '{sql}'")
# Acquire observation values and filter with SQL.
results = stations.values.all()
results.filter_by_sql(sql)
print(results.df)
def sql_example():
"""Retrieve temperature data by DWD and filter by sql statement."""
Settings.tidy = True
Settings.humanize = True
Settings.si_units = False
request = DwdObservationRequest(
parameter=[DwdObservationDataset.TEMPERATURE_AIR],
resolution=DwdObservationResolution.HOURLY,
start_date="2019-01-01",
end_date="2020-01-01",
)
stations = request.filter_by_station_id(station_id=(1048,))
sql = "SELECT * FROM data WHERE " "parameter='temperature_air_mean_200' AND value < -7.0;"
log.info(f"Invoking SQL query '{sql}'")
# Acquire observation values and filter with SQL.
results = stations.values.all()
results.filter_by_sql(sql)
print(results.df)
