This icon can directly visualise ODB data in using various plot types. Optionally it can perform an ODB/SQL query on the input ODB and visualises the resulting (intermediate) data. It works for both databases (ODB-1) and files (ODB-2).
| Info |
|---|
From Macro/Python the icon can be called as odb_visualiser(). |
| Tip |
|---|
A tutorial about using ODB in Metview can be found here. |
What is ODB?ODB is a database developed at ECMWF to store and retrieve large volumes of meteorological observational and feedback data efficiently for use within the IFS. Currently, ODB comes in two flavours: - ODB-1 (the original hierarchical table format capable of running in a parallel environment within IFS)
- ODB-2 (a new flat format with a modern API used for archiving in MARS).
How does ODB/SQL query work in the ODB Visualiser?We illustrate it with a simple example. Let us suppose we want to perform this ODB/SQL query on our data then want to plot the results as points on a map: | Code Block |
|---|
SELECT
lat@hdr,
lon@hdr,
fg_depar@body
WHERE
vertco_reference_1@body = 5
ORDERBY
obsvalue@body |
Then in the icon editor we need to set the following parameters: | ODB Latitude Variable | lat@hdr | | ODB Longitude variable | lon@hdr | | ODB Value Variable | fg_depar@body | | ODB Where | vertco_reference_1@body = 5 | | ODB Orderby | obsvalue@body |
| 