A number of utilities can be used to access data in the TMS. Most have been
created to serve a particular purpose, such as a plotting the submm seeing.
Others allow to directly access the tables in the database using
Query Language (SQL).
-- ESO/CADC Web based interface to the
JCMT Archive and TMS.
This interface uses forms with database table columns as fields and
allows to set constraints to a query. The results of the query are
captured within the browser for preview and retrieval, if relevant.
For more information look at the help supplied with the forms.
-- Searches, lists, and plots scans on JCMT spectral standards. For a
specified UT range the utility scans the database for observations of
JCMT standard sources which cover standard spectral lines. There are
two versions of the program: a WDB based version and a command-line
one. The results of the search are returned as a list. The WDB version
allows previewing and retrieval of scans. Note: the scans listed
by Jcmtstandards have not been checked for quality and compatibility
with the scans in the Standards archive.
-- Plots noise data on Scuba bolometers. The utility can create a number
of different plot types to investigate Scuba noise statistics.
-- Plots submm opacity and seeing (phase) as a function of time by
piping the values for a fixed time-range into Xmgr, which allows extensive
manipulation of the plot.
-- Menu based utility to retrieve current value, value vs. time plots,
or statistics of the submm opacity at 225 GHz from the CSO tau meter or
the submm seeing (phase stability) from the SAO phase monitor. The
resulting output is listed or plotted to a device of choice
(e.g. X-window, graphics terminal, file).
-- Plots Receiver temperatures as function of UT, LOFREQ, or Elevation.
-- General command-line based SQL interface, which enables a direct
inspection of the tables in the TMS. Knowledge of Structured Query
Language (SQL) is a prerequisite, as is familiarity with the
tables layout in the TMS. There is also a more comprehensive guide on
-- Like isql with command-line history and editing and more. This
version is much more user-friendly and versatile than the standard isql.
For best results install a file with the following two lines
as .sqshrc in your home directory (include back-slashes):
-- Emacs SQL interface, results of queries are retrieved into an XEmacs
window. Very useful for complex interactions with the DB, when a query
needs to be sorted out or optimized, or when the results need editing
for further processing.