Guide to the Oracle tables
Metlog Comprehensible User Interface
This page is an attempt at a more comprehensible interface to
our online Oracle archive.
If you cannot get what you want via this page,
you may need to use the
Most of the information we have is synoptic data: ie, actual weather reports as they are received.
That is not what you want if you want to know long-term averages.
Monthly averages of temperature and pressure are available from the
table Jones and Limbert (don't ask...), which is updated with CLIMAT reports.
Experimentally, we have automated (and fuller) decoding of CLIMAT reports
Further links to other datasets are available from the
public data page.
Surface (land or ship) Data [SYNOP]
The last report from each land or
ship is available. We also
have a clickable-map interface to land manned and AWS stations.
Recent (from the present back to the start of the current year) surface data is available
from the table
GTS_PERL_SYNOP (selected to Antarctic stations)
GTS_PERL_SYNOP (all stations).
This link will take some time (20-30 seconds, without including netlag) to come up,
because it will search the table for all possible station ID's.
If you know which station you want and it is on the list below, it may be quicker to select a link from one
of the options below.
Jump straight to data retreival
Use this if you want the default data selection.
Use this if you want to modify the default data selection
(different dates, data items, averaging, etc).
Earlier data is available by year:
Upper Air data [TEMP]
Upper air is available from fewer stations.
Select tables "gts_temp_yyyy", where yyyy=1987,...,1998 for historical data with passable error checking
- see the full interface.
Select "gts_perl_temp" for data after April 1997, with minimal checking.
There is also some older data available.
You can select from all recent data available for all stations from table
or just the Antarctic stations
If you already know which station you want, it will be faster to use the choice below.
Is available from table GTS_PERL_ZBUOY
or link buoys-met.
Questions and Problems
Script and html problems may be addressed to firstname.lastname@example.org.
Questions about stations and general data availablility are better
addressed to email@example.com.
Page by WMC on a suggestion from JCK