| Some Title Here | Some Title or Link Here |
Loading Search NOAO data page, please wait...
Query Form 1
Query Form 2
Results
Enter parameter constraints in the Simple Query Form, then
click "Search" button. To find data from your own NOAO programs, choose
"Search My Data" under Search Type. Data from the "Results" may be staged and
retrieved from the "Staging Area".
Target
Telescope & Instrument
Enter your SQL into the Advanced Query Text Area, then click
"Search" button. Data from the "Results" may be staged and retrieved from the
"Staging Area".
You may enter parameters into the "Simple Query Form", then switch to the "Advanced Query Form" to see the equivalent SQL. This can provide useful examples that you can modify to form your own custom queries.
There are a few required columns that you must include in your SELECT clause, these are: reference, release_date, start_date, filesize, dtpropid, and md5sum. Only voi.siap and voi.skyimage tables are allowed.
For further information about the schema of the tables voi.siap and voi.skyimage, please click here. Also, if you want to know more about SQL please click here or here for advanced users.
The LIMIT clause expects a range of 0..250000.
Warning: Queries by default will return data for which you are PI, and/or public data. To obtain data for which you are co-I, see the SQL example below. Observing mode is only applicable to KOSMOS instruments. The Advanced Query functionality is a new feature and will be improved in future versions of the archive.
You may enter parameters into the "Simple Query Form", then switch to the "Advanced Query Form" to see the equivalent SQL. This can provide useful examples that you can modify to form your own custom queries.
There are a few required columns that you must include in your SELECT clause, these are: reference, release_date, start_date, filesize, dtpropid, and md5sum. Only voi.siap and voi.skyimage tables are allowed.
For further information about the schema of the tables voi.siap and voi.skyimage, please click here. Also, if you want to know more about SQL please click here or here for advanced users.
The LIMIT clause expects a range of 0..250000.
Warning: Queries by default will return data for which you are PI, and/or public data. To obtain data for which you are co-I, see the SQL example below. Observing mode is only applicable to KOSMOS instruments. The Advanced Query functionality is a new feature and will be improved in future versions of the archive.
Examples of valid SQL queries
-
This selects the first 100 rows from the voi.siap table within a box
bounded by ra (10.352, 11.017) and dec (41.019, 41.519). Note that
position constraints must be in the same units (here, degrees). Tip:
LIMIT 100 or some other small number is useful for testing without
getting a very large data set back.
SELECT * FROM voi.siap WHERE ((ra >= 10.352 AND ra <= 11.017) AND (dec >= 41.019 AND dec <= 41.519)) LIMIT 100
-
This selects the first 100 rows from the voi.siap table for a specified
NOAO proposal ID (here, noao) using a wildcard match. A wildcard may be
specified by constructing a condition using the operator "LIKE" or
"ILIKE" (the later is case insensitive) followed by a string which may
contain one or more "%" characters which are the wildcards.
SELECT * FROM voi.siap WHERE dtpropid ILIKE '%noao%' LIMIT 100
-
This selects the first 50000 rows from the
voi.siap table at a specified proposal ID (here, 2015A)
using a wildcard match. Tip: This kind of condition can be useful to find
proposals where you are a co-investigator.
SELECT * FROM voi.siap WHERE dtpropid ILIKE '%2015A%' LIMIT 50000
-
This selects the first 50000 rows from the
voi.siap table within a range of dates (2014-11-29 and 2015-01-29)
at the start of an observing night. Tip: You can specify which columns
you want in the result set.
SELECT reference, release_date, start_date, filesize, dtpropid, md5sum, date_obs, ra, dec, telescope, instrument FROM voi.siap WHERE start_date BETWEEN '2014-11-29' AND '2015-01-29' LIMIT 50000
-
This selects the first 50000 rows from the
voi.siap table for a specified telescopes (kp4m, kp09m and ct4m) and
instruments (mosaic and mosaic_2). Note that this query is using a
wildcard match for some instruments.
SELECT * FROM voi.siap WHERE (telescope = 'kp4m' AND instrument LIKE 'mosaic%') OR (telescope = 'kp09m' AND instrument LIKE 'mosaic%') OR (telescope = 'ct4m' AND instrument = 'mosaic_2') LIMIT 50000
-
This selects the first 50000 rows from the
voi.siap table with release date less than some date (here,
2015-09-29). Tip: For getting public files, you
have to select a date less than today.
SELECT * FROM voi.siap WHERE release_date < '2015-09-29' LIMIT 50000
-
This selects the first 50000 rows from the
voi.siap table at a specified user (here, dummyuser). Tip: If you are adding
a noao_id condition, then make sure that the
noao_id column is present in the SELECT clause.
SELECT reference, release_date, start_date, filesize, dtpropid, md5sum, noao_id FROM voi.siap WHERE noao_id = 'dummyuser' LIMIT 50000
-
This selects CTIO 4m DECam data observed through the r-band filter. The
valid DECam filters are currently u, g, r, i, z, Y, and VR. The ILIKE
operator is case-insensitive. Tip: Use "ORDER BY date_obs ASC" to sort
the results by ascending values of the observing date.
SELECT * FROM voi.siap WHERE (telescope = 'ct4m' AND instrument = 'decam' AND filter ILIKE '%r DECam%') ORDER BY date_obs ASC LIMIT 50000
<No response yet, please make a query>
|
|
