<HTML>

<HEAD>

<TITLE>GATOR Overview and Tutorial </TITLE>

</HEAD>

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

Gator-Aid Tutorial

<A NAME="tut"></A> This section describes step-by-step examples of how to use GATOR. The examples include links to sample outputs. The values in quotes are entered in the forms without

the quotes.

Example 1:  Perform a cone search of  all measurements within 1 degree of M51 in the 2MASS Second Incremental Release Point Source Catalog; return

ra, dec, J, H and K magnitudes, with output records ordered by K magnitude.

Step 1:    At the start-up page, choose the 2MASS Second Incremental Release Point Source Catalog  by clicking the selection button for that catalog; hit select

to bring up the query builder  window for that catalog

Step 2:    Required Constraints: Choose table output to get a tabular listing of matches (the only option available for a cone search).

Step 3:    Required Constraints: Enter a fully qualified email address; e.g. sam@astro.jupiter.edu

Step 4:    Spatial Constraints:  Select cone search, type '1',  select degrees from the pull-down menu, and enter 'M51'.

Step 5:    User defined constraints: clear out any constraint typed in the space

Step 6:    In column selection, type 'k_m'  in the Order By space, hit 'None' in column selection, then hit 'Sel' column for ra, dec, j_m, h_m and

k_m

Step 7:   Hit "Run Query"

Step 8:   The Process Monitor window is brought up - see <A HREF="Example1_monitor.html">sample</A>. Hit "Check Query Status" to bring up the <A HREF="example1_log.html">processing log</A> for the job. Hit "Update Query Status" to

refresh it. Hit View Table link at the bottom of the page to <A HREF="Example1_out.pt">display the output table</A>. You can also use the back button to go back to the Process Monitor

and hit the View Table. This can be done during the processing, so that the table itself can be monitored while it is being written. The output file can be

downloaded through the File/Save As Feature in Netscape and Internet Explorer

Step 9:    Read your <A HREF="example1_mail.html">email from IRSA</A> that provides a processing summary and a link to the output file.

Example 2:  Perform a cone search of  all measurements within 1 degree of M51 in the 2MASS Second Incremental Release Point Source Catalog; return

ra, dec, J, H and K magnitudes for all rows where the J magnitude is less than 12.0, with output records ordered by K magnitude.

The procedure differs from that in Example 1 step 5.

Step 1:  At the start-up page, choose the 2MASS Second Incremental Release Point Source Catalog  by clicking the selection button for that catalog; hit select

to bring up the query builder  window for that catalog

Step 2:    Required Constraints: Choose table output to get a tabular listing of matches (the only option available for a cone search).

Step 3:    Required Constraints: Enter a fully qualified email address.

Step 4:    Spatial Constraints:  Select cone search, type 1,  select degrees from the pull-down menu, and enter "M51" (without quotes).

Step 5:    User defined constraints: type "j_m<12.0"

Step 6:    In column selection, type 'k_m' (no quotes) in the Order By space, hit 'None' in column selection, then hit 'Sel' column for ra, dec, j_m, h_m and

k_m

Step 7:   Hit "Run Query"

Step 8:    The Process Monitor window is brought up - see <A HREF="example2_monitor.html">sample</A>. Hit "Check Query Status" to bring up the <A HREF="example2_log.html">processing log</A> for the job. Hit "Update Query Status" to

refresh it. Hit View Table link at the bottom of the page to <A HREF="example2_out.pt">display the output table</A>. You can also use the back button to go back to the Process Monitor

and hit the View Table. The output file is smaller than in example 1, and contains only those rows having a J magnitde less than 12, ordered by ascending value

of K magnitude. This can be done during the processing, so that the table itself can be monitored while it is being written. The output file can be

downloaded through the File/Save As Feature in Netscape and Internet Explorer

Step 9:    Read your <A HREF="mail_example2.html">email from IRSA</A> that provides a link to the output file, and a processing summary

Example 3:  Perform a cone search of  all measurements within 1 degree of  RA =0, dec=0  in the 2MASS Second Incremental Release Point Source Catalog; return

ra, dec, J, H and K magnitudes for all rows where the J magnitude is greater than 12 and declination greater than 85 degrees, with output records ordered by K magnitude.

This contrived example shows how Gator returns data from a null request. It returns a file containing a header but no records, but does not report messages that no records have been found.

The procedure differs from that in Example 1 in steps 4 and 5.

Step 1:  At the start-up page, choose the 2MASS Second Incremental Release Point Source Catalog  by clicking the selection button for that catalog; hit select

to bring up the query builder  window for that catalog

Step 2:    Required Constraints: Choose table output to get a tabular listing of matches (the only option available for a cone search).

Step 3:    Required Constraints: Enter a fully qualified email address.

Step 4:    Spatial Constraints:  Select cone search, type 1,  select degrees from the pull-down menu, and enter "0  0 " (without quotes).

Step 5:    User defined constraints: type "j_m<12.0 and dec 85"

Step 6:    In column selection, type 'k_m' (no quotes) in the Order By space, hit 'None' in column selection, then hit 'Sel' column for ra, dec, j_m, h_m and

k_m

Step 7:   Hit "Run Query"

Step 8:   The Process Monitor window is brought up - see <A HREF="example3_monitor.html">sample</A>. Hit "Check Query Status" to bring up the <A HREF="example2_log.html">processing log</A> for the job. Hit "Update Query Status" to

refresh it. Hit View Table link at the bottom of the page to <A HREF="example3_out.pt">display the output table</A>. You can also use the back button to go back to the Process Monitor

and hit the View Table. The file contains only the header.

This can be done during the processing, so that the table itself can be monitored while it is being written. The output file can be

downloaded through the File/Save As Feature in Netscape and Internet Explorer

Step 9:    Read your <A HREF="mail_example2.html">email from IRSA</A> that provides a link to the output file, and a processing summary

</TD>

</TR>

Example 1: Simple query working with the 2MASS 2nd Incremental Release Point Source catalog to retrieve all point sources fainter than 15th magnitude and confined to a strip of sky between declinations 17 and 18 degrees.

Step 1:    At the start-up page, choose the 2MASS Second Incremental Release Point Source Catalog  by clicking the selection button for that catalog; hit select

to bring up the query builder  window for that catalog

Step 2:    Required Constraints: Choose table output to get a tabular listing of matches (the only option available for a cone search).

Step 3:    Required Constraints: Enter a fully qualified email address; e.g. sam@astro.jupiter.edu

Step 4:    Spatial Constraints:  Select cone search, type '1',  select degrees from the pull-down menu, and enter 'M51'.

Step 5:    User defined constraints: clear out any constraint typed in the space

Step 6:    In column selection, type 'k_m'  in the Order By space, hit 'None' in column selection, then hit 'Sel' column for ra, dec, j_m, h_m and

k_m

Step 7:   Hit "Run Query"

refresh it. Hit View Table link at the bottom of the page to <A HREF="Example1_out.pt">display the output table</A>. You can also use the back button to go back to the Process Monitor

and hit the View Table. This can be done during the processing, so that the table itself can be monitored while it is being written. The output file can be

downloaded through the File/Save As Feature in Netscape and Internet Explorer

Step 9:    Read your <A HREF="example1_mail.html">email from IRSA</A> that provides a processing summary and a link to the output file.

<BLOCKQUOTE>Step 1: Select 'Sampler Point Source Ctalog' in the "2 Micron All-Sky Survey First Incremental Release Public Database". </BLOCKQUOTE>

<BLOCKQUOTE>Step 2: Click submit. Now detailed selection page appears. Note: Any "submit" on the menu will suffice. </BLOCKQUOTE>

<BLOCKQUOTE>Step 3: Select "None (All Sky)" in the Spatial Constraints section. </BLOCKQUOTE>

<BLOCKQUOTE>Step 4: Clear out the "cntr < 10" in the Constraints by SQL input area. </BLOCKQUOTE>

<BLOCKQUOTE>Step 5: Go to Query-By-Table and Output Column Selection section. Scroll down (the third rows for the top) until you find the row for declination. Enter without the parentheses ( 17) into the box of the Low Limit column and (< 18) in the box of the Up Limit column. </BLOCKQUOTE>

<BLOCKQUOTE>Step 6: Enter e-mail address, so that the status will be informed. </BLOCKQUOTE>

<BLOCKQUOTE>Step 7: Scroll down again until you find the three rows for J, H, and K magnitude (labeled j_m, h_m, and k_m.) Enter in the Low Limit column ' 15' for all three boxes. </BLOCKQUOTE>

<BLOCKQUOTE>Step 8: Finally click on [Run Query] in the menu. </BLOCKQUOTE>

<BLOCKQUOTE>Step 9: Click one of the 'Run Query' buttons. One is located at the beginning of the page, while the another one is located at the bottom of the page.  </BLOCKQUOTE>

<BLOCKQUOTE>Keep in mind: In Step 7, the objective was to select objects *fainter* than 15th magnitude. Since fainter objects register as 16th, 17th, 18th, etc. magnitude, we used the greater-than symbol ().  </BLOCKQUOTE>

<BLOCKQUOTE>The another window is popped out, which contains your output file name and working space information. This information is required when you use monitor.  </BLOCKQUOTE>

<BLOCKQUOTE>Step 10: Click 'Check Status' to view your log file which corresponds to your query. </BLOCKQUOTE>

<BLOCKQUOTE>Step 11: You can click 'Stop Process' to stop your query.  </BLOCKQUOTE>

<BLOCKQUOTE>Step 12: Click 'View Table' to view your output file. </BLOCKQUOTE>

The first and last few lines of output look like the following:

<PRE>\fixlen = T\primary    = 0\RowsRetreived =               2112  \QueryTime     =   00:00:04.92739              \ORIGIN  = 'IPAC Infrared Science Archive (IRSA), Caltech/JPL'\DATETIME= '2001-01-02 13:37:00'\DATABASE= 'Sampler Point Source Catalog (PSC)  (pts_samp_cat_01)'\EQUINOX = 'J2000'\SQL     = 'WHERE  dec 17 and  dec <18 and  j_m 15 and  h_m 15 and  k_m 15'\SQL     = 'SELECT (13 column names follow in next row.)'|         ra|       dec|    j_m|j_msig|    h_m|h_msig|    k_m|k_msig|rd_flg|cc_flg|extd_flg|b_m_op|r_m_op||     double|    double| double|double| double|double| double|double|  char|  char|     int|double|double||           |          |       |      |       |      |       |      |      |      |        |      |      ||       null|      null|   null|  null|   null|  null|   null|  null|  null|  null|    null|  null|  null|  134.432070  17.000233  16.744  0.159  15.977  0.206  15.537  9.999    220    000        0  19.10  17.60   135.766618  17.001429  15.559  0.056  15.197  0.099  15.148  0.129    222    000        0  17.70  16.40   135.142333  17.001944  16.174  0.094  15.391  0.117  15.343  0.155    222    000        0   null   null   134.294303  17.002024  16.249  0.100  15.818  0.158  15.331  0.150    222    000        0  20.80  18.20                                                 ......  105.995377  17.999550  16.046  0.082  15.518  0.118  15.323  0.159    222    000        0  20.90  17.40   106.693891  17.999640  16.661  0.131  15.995  0.166  15.926  0.237    222    000        0  19.00  17.20   105.962050  17.999910  15.582  0.060  15.265  0.098  15.155  0.130    222    000        0  18.10  16.20 </PRE>

The first and last few lines of output look like the following:

<PRE>\fixlen = T\primary    = 0\RowsRetreived =                 49  \QueryTime     =   00:00:01.48776              \ORIGIN  = 'IPAC Infrared Science Archive (IRSA), Caltech/JPL'\DATETIME= '2001-01-02 15:17:10'\DATABASE= 'Sampler Point Source Catalog (PSC)  (pts_samp_cat_01)'\EQUINOX = 'J2000'\SKYAREA = 'within 3600 arcsec radius of ra=106.00000 dec=+22.00000 Eq J2000 '\SQL     = 'WHERE  j_m 16.1 and  h_m 16.1 and  k_m 16.1'\SQL     = 'SELECT (13 column names follow in next row.)'|         ra|       dec|    j_m|j_msig|    h_m|h_msig|    k_m|k_msig|rd_flg|cc_flg|extd_flg|b_m_op|r_m_op||     double|    double| double|double| double|double| double|double|  char|  char|     int|double|double||           |          |       |      |       |      |       |      |      |      |        |      |      ||       null|      null|   null|  null|   null|  null|   null|  null|  null|  null|    null|  null|  null|  105.972191  21.571095  16.481  0.110  16.379  0.260  16.825  9.999    220    000        0  18.60  17.40   105.905231  21.302307  16.351  0.109  16.101  0.194  16.142  0.309    222    000        0  19.10  18.00   106.140938  21.021360  16.218  0.527  16.332  0.634  16.224  1.759    222    000        0  20.10  18.30   106.252228  22.437738  16.459  0.112  16.222  0.228  16.124  9.999    220    000        0  20.30  18.10   106.267316  22.394638  16.281  0.099  16.116  0.191  16.515  9.999    220    000        0  18.10  17.10   106.140008  22.347929  16.455  0.353  16.148  0.213  16.511  9.999    220    000        0  19.10  17.70                              ......  106.860233  22.061275  16.340  0.098  16.126  0.178  16.147  0.300    222    000        0  19.00  17.60   106.882571  22.202032  16.491  0.107  16.497  9.999  16.116  0.294    202    000        0  18.80  17.90   106.871301  22.297138  16.447  0.107  16.141  0.178  16.209  9.999    220    000        0  20.20  17.90   105.900533  21.122622  16.462  0.118  16.134  9.999  16.196  0.312    202    000        0   null   null </PRE></TD>

</TR>

Example 2: A query that will return a list of objects at position (in decimal degrees) 106 by 22 out to a radius of 3600 arcsec. It will search for objects fainter than 16.1 mag.

<BLOCKQUOTE>Step 1: Select 'Sampler Point Source Catalog' as Example 1. </BLOCKQUOTE>

<BLOCKQUOTE>Step 2: Click submit. Now detailed selection page is appeared. </BLOCKQUOTE>

<BLOCKQUOTE>Step 3: Select 'Cone Search' on the Spatial Constraint Section.  </BLOCKQUOTE>

<BLOCKQUOTE>Step 4: Enter search radius 3600 in the area following 'Within'.  </BLOCKQUOTE>

<BLOCKQUOTE>Step 5: Select the search unit as arcsec.  </BLOCKQUOTE>

<BLOCKQUOTE>Step 6: Enter 106 for RA, 22 for DEC, and Coordinat System "Eq J2000". They are case insensitive. </BLOCKQUOTE>

<BLOCKQUOTE>Step 7: Clear out the 'cntr < 10' in the Constraints by SQL input area. </BLOCKQUOTE>

<BLOCKQUOTE>Step 8: Scroll down until you find the three rows for J, H, and K magnitude (labeled j_m, h_m, and k_m.) Type in the Low Limit column without quotation marks ( 16.1) for all three boxes. </BLOCKQUOTE>

<BLOCKQUOTE>Step 9: Finally click on [Run Query] in the menu.</BLOCKQUOTE>

The first and last few lines of output look like the following:

......

</TR>

Example 3: The same query in as in Example 2 but this time customizing your output. Specifically, you will have your output consisting of RA and DEC, J,H, and K magnitudes, J,H, and K aperture magnitudes.

<BLOCKQUOTE>Step 1-6 will be identical as those found in Example 2. </BLOCKQUOTE>

<BLOCKQUOTE>Step 7: In the "Query-By-Table and Output Column Selection" on Dataset, select None. </BLOCKQUOTE>

<BLOCKQUOTE>Step 8: Scroll down the list and select the following: ra, dec,

j_m, h_m, k_m, j_m_stdap, h_m_stdap, k_m_stdap. </BLOCKQUOTE>

<BLOCKQUOTE>Step 9: After making your selections, click on [Run Query] in the menu.</BLOCKQUOTE></TD>

</TR>

</TD>

</TR>

Example 4: NOTE: This function is still under development. Submit a query that will select all objects fainter than 14th magnitude using an uploaded source file containing specific coordinates to search. Here's a sample source file for your

reference (it's the same one you would find in the help page):

<PRE>\CHAR equinox = 'J2000'     | ra | dec |     | double | double |     20.1 30.7     21.2 32.2     33.0 20.1     30.5 20.0</PRE>

<BLOCKQUOTE>Step 1: Select 'Sampler Point Source Catalog'. </BLOCKQUOTE>

<BLOCKQUOTE>Step 2: Select "Upload Table" in the Spatial Constraint Section.  </BLOCKQUOTE>

<BLOCKQUOTE>Step 3: Set search radius to 3600 arcsec. </BLOCKQUOTE>

<BLOCKQUOTE>Step 4: Click on "Browse" to call up a listing of your directory. Scroll through listing until you find your source file and then select it. </BLOCKQUOTE>

<BLOCKQUOTE>Step 5: Scroll down until you find the three rows for J, H, and K magnitude (labeled j_m, h_m, and k_m.) Type in the Low Limit column (without quotation marks) ( 14) for all three boxes. </BLOCKQUOTE>

<BLOCKQUOTE>Step 6: Finally click on [Run Query] in the main menu.</BLOCKQUOTE></TD>

</TR>

<HR>

Comments to: <A HREF="mailto:irsa@ipac.caltech.edu">IRSA (irsa@ipac.caltech.edu)</A>

Last update: 18 September 1998</TD>

</TR>

</TABLE>

</BODY>

</HTML>