BRIGHT, SATURATED,
SATUR_CENTER, or NOPETRO_BIG set.
We also took into account the nominal SDSS flux limit by only selecting galaxies with dereddened model magnitude r < 22.0.
An example of the query we used to extract the data with RA in the range
[0,170) is given below.
|
declare @BRIGHT bigint set @BRIGHT=dbo.fPhotoFlags('BRIGHT')
declare @SATURATED bigint set @SATURATED=dbo.fPhotoFlags('SATURATED') declare @SATUR_CENTER bigint set @SATUR_CENTER=dbo.fPhotoFlags('SATUR_CENTER') declare @bad_flags bigint set @bad_flags=(@SATURATED|@SATUR_CENTER|@BRIGHT) select objID, ra, dec,type,dered_u,dered_g,dered_r,dered_i,dered_z, petroR50_u, petroR50_g, petroR50_r, petroR50_i, petroR50_z, petroR90_u, petroR90_g, petroR90_r, petroR90_i, petroR90_z into MyDb.all_ra_0_170 FROM PhotoPrimary WHERE ((flags & @bad_flags)) = 0 AND (dered_r<=22.0) AND (ra>=0.0) AND (ra<170.0) AND (type = 3) |
BINNED1 flag set and remove objects with the NODEBLEND flag.
BINNED1 objects were detected at >= 5&sigma in the original
imaging frame.
BLENDED objects have multiple peaks detected within them, which PHOTO
attempts to deblend into several CHILD objects.
NODEBLEND objects are BLENDED but no deblending was attempted on them, because
they are either too close to an EDGE, or too large, or one of their
children overlaps an edge.
| Survey | Number of Objects | Number of Unique Objects | zspec Quality Cut |
| 2SLAQ | 52,842 | 11,426 | qop >= 3 |
| CFRS | 1,830 | 272 | Class >= 1 |
| CNOC2 | 21,123 | 1,435 | - |
| TKRS | 728 | 389 | z > -1 |
| DEEP + DEEP2 | 31,716 | 6,049 | qz = A,B (DEEP); Q >= 3(DEEP2) |
| SDSS Spectroscopic Sample | 531,672 | 531,672 | zconf >= 0.9 |
| All | 639,911 | 551,243 | typically 90% confidence |
![]() |
![]() |
| Performance Metric | Definition |
| zbias | 1/N &Sigma (ziphot-zispec) |
| &sigma2 | 1/N &Sigma (ziphot-zispec)2 |
| &sigma68 | Range in |zphot-zspec| containing 68% of objects |
| &sigma95 | Range in |zphot-zspec| containing 95% of objects |
| Case | Inputs/Description | &sigma | &sigma68 |
| D1 | ugriz + cucgcrcicz ; Split training in r | 0.0519 | 0.0209 |
| CC2 | u-g, g-r, r-i, i-z + cgcrci | 0.0593 | 0.0245 |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
| r magnitude | &sigmadist (CC2) | &sigmadist (D1) | KS statistic (CC2) | KS statistic (D1) |
| r < 18 | 0.0392 | 0.0330 | 0.0632 | 0.0391 |
| 18 < r < 19 | 0.0390 | 0.0430 | 0.0520 | 0.0533 |
| 19 < r < 20 | 0.0391 | 0.0399 | 0.0366 | 0.0413 |
| 20< r < 21 | 0.0403 | 0.0471 | 0.0363 | 0.0665 |
| 21< r < 22 | 0.0652 | 0.0702 | 0.1051 | 0.1306 |
| All | 0.0383 | 0.0338 | 0.0485 | 0.0307 |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
BINNED1
flag (object detected at > 5&sigma) and removing
objects with the NODEBLEND flag
(object is a blend but deblending was not possible).
Finally, we note that the training of the photo-z estimators used
only galaxies, not stars.
As a result, photo-z estimates for stars that contaminate the
photometric galaxy sample will be wrong, and cutting out
objects with low zphot will not remove such stars.
photoz2 table in the DR6 context on the
SDSS CasJobs site, at
http://casjobs.sdss.org/casjobs/ .
We describe the columns of the photoz2 table in CasJobs in Table 5.
| Column name | Type | Description |
| objID | bigint | unique ID pointing to PhotoObjAll table |
| photozcc2 | real | photometric redshift using ANN-CC2 method |
| photozerrcc2 | real | &sigma68 error estimate for ANN-CC2 photo-z |
| photozd1 | real | photometric redshift using ANN-D1 method |
| photozerrd1 | real | &sigma68 error estimate for ANN-CC2 photo-z |
| flag | int | 0 = objects with r<=20, 2 = objects with r>20. |
photoz2 entry.
photoz2 table in the SDSS CAS,
an independent photoz table is also available, for which the
photo-z's have been computed using a template-based technique; see
Csabai et al. (2007), Adelman-McCarthy et al (2007).