Top-header1
Some Title Here Manage your user account  |  Log in
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".
● Reset      Search Type:
   ● Search
Target
Object name
Object name
Click on the "Resolve" button to use an external service to find coordinates for an object name. This string is matched to user-provided object names in image headers, which may not always be reliable.
Examples
M31
NGC 7027
 ●Resolve
Coordinates
Coordinates
Search position in right ascension and declination. Decimal degrees or sexagesimal formats (with RA = hh:mm:ss; Dec = dd:mm:ss) are acceptable. Warning: Header coordinates may occasionally be incorrect or missing.
Examples
156.455994, 50.7508011
10:25:49.44, +50:45:02.88



Search box size (arcmin)
Search box size (arcmin)
Search box around point coordinates given via a object name or one of coordinate fields (RA, Dec)
Examples
30.0
Observation
Program number
Program number
NOAO program identifier, normally in format "semester-####", e.g., "2010A-0123". Partial matches are allowed. Some data are owned by the observatories and have program IDs like "NOAO".
Examples
2010A-0123
2010a-01
2010A
noao
smarts
soar
wiyn
Principal Investigator
Principal Investigator
Name of the principle investigator for an observing program.
Examples
Ivania
dickinson
Exequiel Fuentes
Observing calendar date
Observing calendar date
Calendar date at the start of an observing night, in format YYYY-MM-DD. Operators =, <, > and BETWEEN can be used to select a range. Clicking on the box brings up a calendar tool.
Examples
= 2008-10-15
< 2010-01-01
BETWEEN 2009-02-15 AND 2009-02-18
Original Filename
Original Filename
Filename originally assigned to a data file at the telescope. Partial string matches are allowed, and file extensions (e.g., ".fits") are not necessary.
Examples
data9876
n03.1234
obj4567
obj
Archive Filename
Archive Filename
Filename assigned to a data file in the NOAO Science Archive. All files are renamed to unique names when they enter the archive. Partial string matches are allowed, and file extensions (e.g., ".fits") are not necessary.
Examples
kp624469raw data from KPNO
ct087083.fitsraw data from CTIO (".fits" allowed but not necessary)
dec009783raw data from DECam
dec009matches partial filename
tu964235pipeline-processed data product
tu1432996.fits.fzextensions (".fits.fz" indicating fpack-compressed FITS file) allowed but not necessary
Telescope & Instrument
Telescope & Instrument
Telescope & Instrument
Select one or more telescope+instrument combinations
Exposure time (seconds)
Exposure time (seconds)
Exposure time (in seconds) for an observation. Operators =, <, > and BETWEEN can be used to select a range. Warning: some instruments have unreliable exposure time information.
Examples
> 1000
BETWEEN 200 AND 900
Data products
Public release date
Public release date
Date for public release of a data set. Operators =, <, > and BETWEEN can be used to select a range. Clicking on the box brings up a calendar tool.
Examples
< 2010-01-01
BETWEEN 2011-01-01 AND 2011-12-31
All instruments
Raw
Raw data as recorded by the instrument, without further processing.
Mosaic, NEWFIRM and DECam
Calibrated images
Individual on-sky exposures in multi-extension FITS format with basic instrumental signatures removed, e.g., bias or dark subtraction, flat fielding, pupil ghost removal (for Mosaic), etc. Whenever possible,a world coordinate system and approximate photometric zeropoint are recorded in the headers. Calibrated images are accompanied by data quality masks. See the NOAO Data Handbook for details.

Reprojected images
Individual calibrated exposures, geometrically rectified and projected onto a sky plane, combining data from all camera detectors into a single-extension FITS image. Reprojected images are accompanied by data quality masks. See the NOAO Data Handbook for details.

Stacked images
Coadded image constructed from a sequence of overlapping sky exposures, with masking of static and transient defects such as cosmic rays. Stacked images are accompanied by exposure maps and data quality masks. See the NOAO Data Handbook for details.

Master calibration files
Combined and processed calibration images such as bias frames, darks, dome or sky flat fields, pupil images, etc. Master calibration files may be accompanied by data quality masks. See the NOAO Data Handbook for details.

Image tiles
An Image tile.
NEWFIRM only
Sky subtracted images
For NEWFIRM, individual calibrated exposures in multi-extension FITS format with basic instrumental signatures removed (dark subtraction, flat fielding), with astrometric and photometric calibration whenever possible, and with two-dimensional sky background subtraction. Sky subtracted images are accompanied by data quality masks. See the NOAO Data Handbook for details.
Dark Energy Survey (DES) public data
Dark Energy Survey (DES) public data
Raw data: Query for non-proprietary raw DECam data from the Dark Energy Survey (DES), NOAO program ID = 2012B-0001.

Reduced data: Query for non-proprietary, pipeline-reduced DECam data from the Dark Energy Survey (DES). The first ("year 1") data product delivery from the DES consists of reduced, calibrated, individual DECam exposures.
●Raw data ●Reduced data
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.
● Reset    ● Search

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>
Staging Area empty

Your Staging Area is empty

You have not added any data to be staged yet. Please make a query and add at least an image to the Staging Area.

Noao-logo Aura-logo Nsf-logo NOAO is the national center for ground-based nighttime astronomy in the United States and is operated by the Association of Universities for Research in Astronomy (AURA), under cooperative agreement with the National Science Foundation.