# Database (PDR3)

There are a number of database changes since PDR2:

• Uncertainties were referred to as  sigma in PDR2, but it is now called err.  Your SQL script will have to be updated when you recycle queries from PDR2.
• There was a smallcat table, which contains some of the most useful columns from the forced and meas table.  It has been updated to a summary table.  We encourage the user to start with this table.
• coord is normalized to unity (it was not in PDR2).
• There is a new column in the forced table, field.   This can be used to query objects in a specific field, e.g., WHERE field = 'cosmos' yields objects in the D/UD-COSMOS field.  The available field names are cosmos, deep2-3, elais-n1, xmm-lss for D/UD fields.  For Wide, hectomap is available for the Hectomap field.  The equatorial stripes are split into R.A., and equator00 returns objects in tracts whose centers are at 0-1h, equator01 includes tracts with centers between 1-2h, and so on.  Note that the search is done on a tract by tract basis and equator00 includes objects outside of R.A.=0-1h because a tract located at, e.g., R.A.=0.9h extends to R.A.>1h.  You can use coneSearch or boxSearch to query objects at specific R.A., Dec ranges.

## Database Tables

The Deep+UltraDeep and Wide layers are stored in separate database schemas named pdr3_dud and pdr3_wide, respectively. Note that ‘dud’ here means Deep+UltraDeep, not a bad table!  In each schema, there are meta tables and object catalog tables. Be sure to use the right schema/table for your search, e.g., if you search for objects in the Deep-ELAIS-N1 field using a table in the Wide schema, you will find no objects.  Also, be sure to choose the right release; if you use the online SQL editor, choose PDR3 from the release pull-down menu.  Due to a limitation of a database engine, we split the forced and unforced measurements into multiple tables (forced[2345] and meas[234]).  You can join these tables with object ID.  There is a summary table that condensed the most useful columns from the forced and meas table into a single table.  We believe 80% of the user can do their science with just table only and we suggest you start with it.

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 document of Stored Functions, as well.

## 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+DEEP g,r,i,z,y,NB0387,NB0816,NB0921,NB1010 19,051,243
COSMOS g,r,i,z,y,NB0387,NB0816,NB0921,NB1010 9569-9572, 9812-9814, 10054-10056 5,495,012
DEEP2-3 g,r,i,z,y,NB0387,NB0816,NB0921 9219-9221, 9462-9465, 9706-9708 4,114,697
ELAIS-N1 g,r,i,z,y,NB0816,NB0921 16984-16985, 17129-17131, 17270-17272, 17406-17407 4,826,118
SXDS+XMM-LSS g,r,i,z,y,NB0387,NB0816,NB0921,NB1010 8282-8284, 8523-8525, 8765-8767 4,615,416
WIDE g,r,i,z,y 507,215,729
Spring field g,r,i,z,y 9069-9136, 9312-9379, 9555-9622, 9797-9864,10039-10106, 10282-10348 281,969,880
Autumn field g,r,i,z,y 8278-8286, 8519-8527, 8761-8769, 8984-9011, 9206-9253, 9448-9496, 9691-9739, 9933-9981, 10175-10223, 10418-10437, 10659-10677, 10899-10904, 10912-10917 184,911,815
Hectomap g,r,i,z,y 15808-15834, 15987-16012, 16162-16186 39,422,651
(AEGIS) g,r,i,z,y 16821-16822, 16972-16973 911,383
The Number of Records in Public Data Release Database Tables
Table Table Name Table Description UDEEP+DEEP WIDE
Frame frame CCD Image Meta 433,746 2,167,558
Warped warped Warped Image Meta 364,919 1,584,918
Mosaic mosaic Mosaic Image Meta (Coadd) 11,794 247,282
Mosaic Meas meas* Objects detected in Coadd in multiBand photometry 31,004,134 830,139,306
Mosaic Forced forced* Objects detected in Coadd in forced photometry 31,004,134 830,139,306