Difference between revisions of "Wind profile"
(New page: = WINDPROF = '''FlySafe database for the wind profile data from the KNMI Doppler radar''' Bart Heupers - Sara Reken- en Netwerkdiensten Last updated : vrijdag 4 januari 2008 ===Referenc...) |
(→Process) |
||
| Line 21: | Line 21: | ||
The wind profile data is being retrieved from the KNMI website twice a day and imported into the database. Wind profiles are produced every 5 minutes for two locations, De Bilt and Den Helder. If there are not sufficient radar reflections these profiles are not or only partly available. The schema used for the wind profile data tables and views is | The wind profile data is being retrieved from the KNMI website twice a day and imported into the database. Wind profiles are produced every 5 minutes for two locations, De Bilt and Den Helder. If there are not sufficient radar reflections these profiles are not or only partly available. The schema used for the wind profile data tables and views is | ||
'''WINDPROF'''. | '''WINDPROF'''. | ||
| + | |||
| + | |||
| + | ==Datamodel== | ||
| + | |||
| + | [[Image|Windprof_datamodel.png]] | ||
| + | |||
| + | The datamodel for the wind profile data is very simple. The '''radar '''table gives the name , the latitude and longitude of the radar. The location is the GIS representation for latitude/longitude. | ||
| + | |||
| + | The '''profiles''' table stores all the wind profiles. The '''radar_id''' is a reference to the radar. The '''date_time''' is a timestamp which gives the date and time of the wind profile data. | ||
| + | The '''height''' gives the geometric height in meters of the profile. | ||
| + | The '''u''','''v''' and '''w''' values are east-west, north-south and vertical components of the wind-speed in m/s. | ||
| + | The '''stddev''' value is standard deviation of radial velocity. This value is used to determine whether birds are present because the variability of the radial velocity can be caused by birds. If this value is bigger then 2.0 then probably birds are present. | ||
| + | |||
| + | The '''bird_traces '''view selects from the profiles table all records where the '''stddev''' value is bigger then 2.0. | ||
Revision as of 11:42, 14 May 2008
Contents
WINDPROF
FlySafe database for the wind profile data from the KNMI Doppler radar
Bart Heupers - Sara Reken- en Netwerkdiensten Last updated : vrijdag 4 januari 2008
References
KNMI description for HDF5 V 3.5:
KNMI description of data product:
Process
The wind profile data is being retrieved from the KNMI website twice a day and imported into the database. Wind profiles are produced every 5 minutes for two locations, De Bilt and Den Helder. If there are not sufficient radar reflections these profiles are not or only partly available. The schema used for the wind profile data tables and views is WINDPROF.
Datamodel
The datamodel for the wind profile data is very simple. The radar table gives the name , the latitude and longitude of the radar. The location is the GIS representation for latitude/longitude.
The profiles table stores all the wind profiles. The radar_id is a reference to the radar. The date_time is a timestamp which gives the date and time of the wind profile data. The height gives the geometric height in meters of the profile. The u,v and w values are east-west, north-south and vertical components of the wind-speed in m/s. The stddev value is standard deviation of radial velocity. This value is used to determine whether birds are present because the variability of the radial velocity can be caused by birds. If this value is bigger then 2.0 then probably birds are present.
The bird_traces view selects from the profiles table all records where the stddev value is bigger then 2.0.
