United Kingdom Infrared Telescope Archive

Help on Queries


  • Composing a Query
  • Submitting a Query
  • Tabular Output
  • Controlling Tabular Output
  • Other Options

  • Composing a Query

    When you first enter the Common query form you will see several query fields like the following. (Note that the names of the fields also serve as links to their descriptions. Try clicking on one!)

    Object Name.............. :

    Leaving a query field blank is essentially the same as putting a wildcard in that query field. If nothing is specified in a field, all values in that field may be returned. The searching mechanism is NOT case sensitive, so uppercase and lowercase characters may be used interchangeably in a search. Although case is ignored, all searches ARE for an exact match, unless special operands (summarized below) are used.

    This is particularly important when specifying an Object Name on the Common form. A search without the name resolver for the object BS4030 will not return anything if the name is stored in the database as BS 4030 (note the space). In order to catch both of these, the query should be specified with a wildcard as BS*4030. (If the SIMBAD name resolver is being used, however, the * wildcard may not be used in the object name.)

    The * wildcard character, and some other useful operands are summarized below:

    *
    Wild-card in strings ( A*B will match AB, AxB, AxxxxB, etc. ).
    <
    Less than.
    >
    Greater than.
    <=
    Less than or equal to.
    >=
    Greater than or equal to.
    !=
    Not equal to.
    ..
    A range of values (ex: 234.56 .. 678.9 ).
    |
    OR
    Will match any of the specified expressions (ex: 123 OR > 5000 OR < 1 ).

    So for example : To select all exposures that started between the first of January and the fifteenth of February you could enter :

    Date (UT)..................... : yyyy-mmm-dd

    Some fields have a fixed set of allowable values from which you can choose.
    Instrument(s)............... :

    These fields normally have a default value of "ALL" which means : Accept all values in this field.


    Submitting Your Query

    To get the result of your query you have to submit it. At the top and at the bottom of the query form you will see a set of buttons like this :

    [Help] [Home]


    In order to to submit your request press the "Search" button. If you want to reset all the fields back to the way they were before you started entering qualifiers in them, press the "Reset" button. (You could try to edit the "Date" field above and then press the "Reset" button).


    Tabular Output

    If you submit a query that returns more than one row of data, you will see a list in tabular form somewhat like this:

    Mark MoreInst.Log Object Name RA (j2000) DEC (j2000) Date (UT) Instrument
    MILME2-1(J) 15 22 19.30 -23 37 29.5 1997-Mar-22 IRCAM3
    MILME2-1(J) 15 22 20.02 -23 37 29.5 1997-Mar-22 IRCAM3
    MILME2-1(J) 15 22 18.58 -23 37 29.6 1997-Mar-22 IRCAM3
    MILME2-1(J) 15 22 19.30 -23 37 29.5 1997-Mar-22 IRCAM3
    MILME2-1(J) 15 22 20.02 -23 37 29.5 1997-Mar-22 IRCAM3
    MILME2-1(J) 15 22 18.58 -23 37 29.6 1997-Mar-22 IRCAM3

    There will typically be one or more columns where the values have hypertext links. The values in the More column will lead you to a full-screen version of the corresponding row, with additional information available. The Inst. column links will take you to a screen with instrument-specific information for the row. The Log column links bring up the operator's log data for the day of the observation. Try them out !

    In the Common table, the leftmost column contains checkboxes which allow you to mark which datasets you would like to request. When you have selected all of the suitable datasets in this manner, you may click on the Request Marked Datasets button to file your request with UKIRT staff. All requests are processed as quickly as possible.


    Controlling Tabular Output

    The tabular output will normally only display a sub-set of the columns available. However, you are able to change the selection of which columns should be displayed.

    Each field in the query form is prepended with a checkbox, which indicates whether the field should be included in tabular output or not. This checkbox is not selected, so the corresponding field would not be included in the tabular output. This checkbox is selected so the corresponding field would be included in the tabular output.

    Note: The checkboxes have nothing to do with which fields are used as search parameters. All fields that have input are used to do the search. If you do not want to use a field in the search, leave it blank.


    Other options

    At the end of the query form there are a few additional options that you can change if you need to. You can force the archive to use the full-screen output format even if your query returns more than one row, and you can adjust the maximum number of rows to return at a time. (Please note that the system has a build in maximum of 1000 rows as the maximum.)

    Use full-screen output even if more than one row is returned.
    Return max rows.

    On the Common form there is also a checkbox which allows you to automatically mark all returned datasets. (If a query returns a large number of datasets, it is time consuming to mark them one at a time.)

    Mark all returned datasets by default.