Project

General

Profile

Support #8504

Clean data from the weather station

Added by Philippe May almost 5 years ago. Updated almost 5 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Philippe May
Start date:
17/06/2019
Due date:
% Done:

0%

Close

Description

The WS has moved to a proper location (3m high pole).

The data stored until today (17/6/2019), except for rainfall, should be removed from the DB.

History

#1 Updated by Philippe May almost 5 years ago

  • Status changed from New to Resolved

I think that we can also keep the air pressure, because absolute value is stored.

update avsm_misc.weather_station_levels set humidity=NULL, solarradiation=NULL, sun_duration=NULL, wind_speed=NULL, wind_direction=NULL, temperature=NULL, uv=NULL where time < '2019-06-18';

Also available in: Atom PDF