Difference between revisions of "Wind profile"

From ecology
Jump to: navigation, search
(Process)
(FlySafe database for the wind profile data from the KNMI Doppler radar)
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
= WINDPROF =
+
= FlySafe database for the wind profile data from the KNMI Doppler radar =
 
 
'''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===
 
===References===
Line 10: Line 5:
 
KNMI description for HDF5 V 3.5:
 
KNMI description for HDF5 V 3.5:
  
[http://www.knmi.nl/kodac/over_kodac/catalogus/hdftag3-5.pdf-http://www.knmi.nl/kodac/over_kodac/catalogus/hdftag3-5.pdf]
+
[http://www.knmi.nl/kodac/over_kodac/catalogus/hdftag3-5.pdf http://www.knmi.nl/kodac/over_kodac/catalogus/hdftag3-5.pdf]
  
 
KNMI description of data product:
 
KNMI description of data product:
  
[http://www.knmi.nl/kodac/over_kodac/catalogus/nl-rdr-data-wind-prof-5m.htm-http://www.knmi.nl/kodac/over_kodac/catalogus/nl-rdr-data-wind-prof-5m.htm]
+
[http://www.knmi.nl/kodac/over_kodac/catalogus/nl-rdr-data-wind-prof-5m.htm http://www.knmi.nl/kodac/over_kodac/catalogus/nl-rdr-data-wind-prof-5m.htm]
 
 
  
 
==Process==
 
==Process==
Line 25: Line 19:
 
==Datamodel==
 
==Datamodel==
  
[[Image|Windprof_datamodel.png]]
+
[[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 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.  

Latest revision as of 11:46, 14 May 2008

FlySafe database for the wind profile data from the KNMI Doppler radar

References

KNMI description for HDF5 V 3.5:

http://www.knmi.nl/kodac/over_kodac/catalogus/hdftag3-5.pdf

KNMI description of data product:

http://www.knmi.nl/kodac/over_kodac/catalogus/nl-rdr-data-wind-prof-5m.htm

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

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.