Each of the UltraDeep, Deep, and Wide layers are stored in separate database schema named pdr1_udeep, pdr1_deep, pdr1_wide. In each schema, there are meta tables and object catalog tables (summary tables). Be sure to use the right schema/table for your search, e.g., if you search for objects in the COSMOS field using a table in the wide schema, you will find no objects.
All the tables in database can be queried by using the CAS (Catalog Archive Server) search with online SQL editor. There are some useful sample SQLs in the CAS search page. See the documents of Summary Table Usage and Stored Functions, as well.
Schema | Table | Notes | |
Meta Information | pdr1_[udeep/deep/wide] | mosaic, frame, wcs etc. | Meta information of image data, such as time, filter, wcs, etc, for each image. This table is generated from the header information of the pipeline products. Most users do not need to directly use this table. |
Object Catalogs (Summary Table) | pdr1_[udeep/deep/wide] | forced | Measurements of forced photometry. We use the extinction map of Schlegel, Finkbeiner, and Davis (1998) to compute the reddening (Galactic extinction) in the HSC filters. |
pdr1_[udeep/deep/wide] | meas, meas2 | Measurements of unforced photometry. Due to the limitation of the postgreSQL database engine, we split the unforced photometry table into two. If you query the meas tables, you want to join the two tables using object_id. | |
pdr1_[udeep/deep/wide] | afterburner | Other value-added catalogs. | |
Obs. Log | obslog | obslog_pdr | Observing logs. This includes seeing, transparency, etc, from the on-site reduction system. |
Quality Assuarance | pdr1_[udeep/deep/wide] | patch_qa | Table with color offsets in the stellar sequence on color-color diagrams as well as depth estimates and seeing for each patch. |
Added Items | pdr1_[udeep/deep/wide] | photoz_* | Photometric redshifts computed by using HSC data. See this page for details. |
pdr1_[udeep/deep/wide] | specz | Collection of public spectroscopic redshifts. See this page for details. | |
pdr1_[udeep/deep/wide] | random | Set of randomly generated points within the survey footprints for clustering analysis. See this page for details. |
Online Data Retrieval Tools
Here is a brief summary of our tools. Go to the Data Access page for quick access to all the tools.
CAS Search | Catalog database search interface with online SQL editor. You can type in your SQL query, check the syntax, and send it to the database. It also comes with a simple download manager. |
Schema Browser | Essential reference for writing SQL queries. It gives you all the details of the database tables. |
DAS Quarry | Image cutout tool. |
DAS Search | File search tool. You can specify filter, coordinates, tract, etc to search for flat files. |
hscMap | googleMap-like image browser with a lot of very useful features (e.g., it can talk to the database and display retrieved objects on your browser). |
Database Records
Survey/Field Name | Filters | Tract | No. of objects | |
---|---|---|---|---|
UDEEP | g,r,i,z,y,NB0816,NB0921 | 3,225,285 | ||
COSMOS | g,r,i,z,y,NB0816,NB0921 | 9570-9571, 9812-9814, 10054-10055 | 1,666,600 | |
SXDS | g,r,i,z,y,NB0816,NB0921 | 8523-8524, 8765-8766 | 1,558,685 | |
DEEP | g,r,i,z,y,NB0816,NB0921 | 15,959,257 | ||
COSMOS | g,r,i,z,y,NB0921 | 9569-9572, 9812-9814, 10054-10056 | 4,421,643 | |
DEEP2-3 | g,r,i,z,y,NB0816,NB0921 | 9220-9221, 9462-9465, 9706-9708 | 4,192,496 | |
ELAIS-N1 | g,r,i,z,y,NB0921 | 16984-16985, 17129-17131, 17270-17272, 17406-17407 | 4,453,232 | |
XMM-LSS | g,r,i,z,y | 8282-8284, 8523-8525, 8765-8767 | 2,891,886 | |
WIDE | g,r,i,z,y | 52,658,163 | ||
XMM | g,r,i,z,y | 8279-8285, 8520-8526, 8762-8768 | 9,902,654 | |
GAMA09H | g,r,i,z,y | 9314-9318, 9557-9562, 9800-9805 | 8,389,626 | |
WIDE12H | g,r,i,z,y | 9346-9349, 9589-9592 | 6,706,575 | |
GAMA15H | g,r,i,z,y | 9370-9375, 9613-9618 | 9,183,254 | |
HECTOMAP | g,r,i,z,y | 15830-15833, 16008-16011 | 3,654,234 | |
VVDS | g,r,i,z,y | 9450-9456, 9693-9699, 9935-9941 | 14,078,747 | |
AEGIS | g,r,i,z,y | 16821-16822, 16972-16973 | 743,073 |
Table | Table Name | Table Description | UDEEP | DEEP | WIDE |
---|---|---|---|---|---|
Frame | frame | CCD Image Meta | 39,937 | 69,140 | 476,058 |
Warped | warped | warped Image Meta | 35,593 | 52,626 | 167,683 |
Wcs & Fcr | wcs & fcr | wcs and fcr file Meta | 57,733 | 103,912 | 713,292 |
Mosaic | mosaic | Mosaic Image Meta(Coadd) | 1,593 | 7689 | 19,519 |
Mosaic Meas | meas, meas2 | Objects detected in Coadd in multiBand photometry | 5,073,357 | 25,945,287 | 84,042,022 |
Mosaic Forced | forced | Summary table of objects detected in Coadd | 5,073,357 | 25,918,070 | 84,017,247 |