Database

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 reddedning (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

Summary of Public Release Catalog Database.  The last column shows the number of primary objects in the forced table.
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

The Number of Records in Public Data Release Database Tables
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