|
The animations shown on this page were produced using the BCS Universal File Interface (UFI) product, the Informix Spatial DataBlade, gnuplot, and data from Environment Canada.
In these animations, UFI is used to query gridded weather forecast information that is residing in NetCDF files as if the information were actually stored as rows in a normal database table. For the first animation, this "virtual" database table is then joined with a spatial "Islands" table (using the Informix Spatial DataBlade) to restrict the display of arrows to every second grid point and to just those grid points that lie over the ocean. Output plot files are produced; these are then plotted using gnuplot. Each arrow length shown in the three plots below is proportional to the wind speed for that location and time, and its color changes from green to red whenever winds exceed 13.5 knots (25 kph or 15.5 mph) - a moderate breeze.
In the second animation we've zoomed in on the area now known as the "Salish Sea". We select every grid point (not every second one) and we use simple SQL to interpolate some more grid points in between.
In the final animation we've picked a different area - the Great Lakes Region - and instead of restricting our data based on island polygons we use lake polygons, picking just those points that lie inside one of the lakes.
For a description of how we used UFI in producing these animations, please refer to this document.
For more information about UFI, please see http://www.barrodale.com/bcs/universal-file-interface-ufi or these articles.
|
UFI Spatial DataBlade Demo
