TABLE  TargRunQA

The RunQA table provides information relevant to the average data quality for the objects in each field for the TARGET skyVersion (see the RunQA table for the BEST skyVersion).

This table may be joined to the rest of your query to sub-select only fields of the very highest quality, for instance, with seeing below a certain threshold, if that is desired. For example:
SELECT TOP 10 f.field, f.run, r.fieldQall
FROM Field f, TargRunQA r
WHERE
f.fieldid=r.fieldid
AND r.fieldQall IN (2,3) -- GOOD or EXCELLENT quality

If you want just one number that describes the overall quality of a field, your best bet is the fieldQall number (0=bad, 1=acceptable, 2=good, 3=excellent). This overall quality determination is based on the (dereddened) principal colors of all the stars in the field vs. the Galactic value of this quantity, the PSF quality, the difference between Aperture and PSF magnitudes for the same stars in the field, and the seeing.

nametypelengthunitucddescription
fieldIDbigint8  64-bit unique fieldID identifier f(skyversion,firstfield?,run,rerun,camcol,firstField,field)
skyVersiontinyint1  0=target, 1=best, currently the runQA table in DR3 CAS only contains quality on the 'best' skyVersion
firsttinyint1  is this field the first in a segment? 0=no 1=yes
runsmallint2  Run number
rerunsmallint2  Rerun processing number
camcoltinyint1  Camera Col 1-6
fieldsmallint2  Field within a run
fieldQalltinyint1  Overall Field Quality measure: 0=BAD, 1=ACCEPTABLE, 2=GOOD, 3=EXCELLENT
opdbqtinyint1  Operations Database quality measure: 0=UNDETERMINDED, 1=BAD, 2=ACCEPTABLE, 3=GOOD, 4=MISSING (unused), 5=HOLE
appsfqtinyint1  Aperture magnitude - PSF magnitude difference quality measure: 1=GOOD 0=BAD
pcmedqtinyint1  Principal color analysis median shift from nominal cosmic (Galactic) value: 1=GOOD, 0=shift too big
pcrmsqtinyint1  Principal color analysis RMS spread in colors vs. nomial: 1=GOOD, 0=Spread too big
PSFwcondqtinyint1  PSF width quality: 1=GOOD, 0=BAD
pc_sreal4  average principal color s=-0.249u+0.794g-0.555r+0.234 for stars in field (perp. to stellar locus in u-g,g-r)
pc_wreal4  average principal color w=-0.227g+0.792r-0.567i+0.05 for stars in field (perp. to blue branch of stellar locus in r-i,g-r)
pc_xreal4  average principal color x=0.707g-0.707r-0.983 for stars in field (perp. to red branch of stellar locus in r-i,g-r)
pc_yreal4  average principal color y=-0.27r+0.8i-0.534z+0.059 for stars in field (perp. to stellar locus in r-i,i-z)
rmsPC_sreal4mags rms width of the s color
rmsPC_wreal4mags rms width of the w color
rmsPC_xreal4mags rms width of the x color
rmsPC_yreal4mags rms width of the y color
medAp7mPSF_ureal4mags median difference between the PSF mag and the 7-bin summed aperture mag in u band
medAp7mPSF_greal4mags median difference between the PSF mag and the 7-bin summed aperture mag in g band
medAp7mPSF_rreal4mags median difference between the PSF mag and the 7-bin summed aperture mag in r band
medAp7mPSF_ireal4mags median difference between the PSF mag and the 7-bin summed aperture mag in i band
medAp7mPSF_zreal4mags median difference between the PSF mag and the 7-bin summed aperture mag in z band
rmsAp7mPSF_ureal4mags rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in u
rmsAp7mPSF_greal4mags rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in g
rmsAp7mPSF_rreal4mags rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in r
rmsAp7mPSF_ireal4mags rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in i
rmsAp7mPSF_zreal4mags rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in z
seeing_ureal4arcsec average measure of the FWHM seeing in the u band for the field
seeing_greal4arcsec average measure of the FWHM seeing in the g band for the field
seeing_rreal4arcsec average measure of the FWHM seeing in the r band for the field
seeing_ireal4arcsec average measure of the FWHM seeing in the i band for the field
seeing_zreal4arcsec average measure of the FWHM seeing in the z band for the field