The RunQA table provides information relevant to the average data quality for the objects in each field. |

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: 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. |

name | type | length | unit | ucd | description |

fieldID | bigint | 8 | 64-bit unique fieldID identifier f(skyversion,firstfield?,run,rerun,camcol,firstField,field) | ||

skyVersion | tinyint | 1 | 0=target, 1=best, currently the runQA table in DR3 CAS only contains quality on the 'best' skyVersion | ||

first | tinyint | 1 | is this field the first in a segment? 0=no 1=yes | ||

run | smallint | 2 | Run number | ||

rerun | smallint | 2 | Rerun processing number | ||

camcol | tinyint | 1 | Camera Col 1-6 | ||

field | smallint | 2 | Field within a run | ||

fieldQall | tinyint | 1 | Overall Field Quality measure: 0=BAD, 1=ACCEPTABLE, 2=GOOD, 3=EXCELLENT | ||

opdbq | tinyint | 1 | Operations Database quality measure: 0=UNDETERMINDED, 1=BAD, 2=ACCEPTABLE, 3=GOOD, 4=MISSING (unused), 5=HOLE | ||

appsfq | tinyint | 1 | Aperture magnitude - PSF magnitude difference quality measure: 1=GOOD 0=BAD | ||

pcmedq | tinyint | 1 | Principal color analysis median shift from nominal cosmic (Galactic) value: 1=GOOD, 0=shift too big | ||

pcrmsq | tinyint | 1 | Principal color analysis RMS spread in colors vs. nomial: 1=GOOD, 0=Spread too big | ||

PSFwcondq | tinyint | 1 | PSF width quality: 1=GOOD, 0=BAD | ||

pc_s | real | 4 | 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_w | real | 4 | 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_x | real | 4 | 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_y | real | 4 | 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_s | real | 4 | mags | rms width of the s color | |

rmsPC_w | real | 4 | mags | rms width of the w color | |

rmsPC_x | real | 4 | mags | rms width of the x color | |

rmsPC_y | real | 4 | mags | rms width of the y color | |

medAp7mPSF_u | real | 4 | mags | median difference between the PSF mag and the 7-bin summed aperture mag in u band | |

medAp7mPSF_g | real | 4 | mags | median difference between the PSF mag and the 7-bin summed aperture mag in g band | |

medAp7mPSF_r | real | 4 | mags | median difference between the PSF mag and the 7-bin summed aperture mag in r band | |

medAp7mPSF_i | real | 4 | mags | median difference between the PSF mag and the 7-bin summed aperture mag in i band | |

medAp7mPSF_z | real | 4 | mags | median difference between the PSF mag and the 7-bin summed aperture mag in z band | |

rmsAp7mPSF_u | real | 4 | mags | rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in u | |

rmsAp7mPSF_g | real | 4 | mags | rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in g | |

rmsAp7mPSF_r | real | 4 | mags | rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in r | |

rmsAp7mPSF_i | real | 4 | mags | rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in i | |

rmsAp7mPSF_z | real | 4 | mags | rms scatter inthe difference between the PSF mag and the 7-bin aperture mag in z | |

seeing_u | real | 4 | arcsec | average measure of the FWHM seeing in the u band for the field | |

seeing_g | real | 4 | arcsec | average measure of the FWHM seeing in the g band for the field | |

seeing_r | real | 4 | arcsec | average measure of the FWHM seeing in the r band for the field | |

seeing_i | real | 4 | arcsec | average measure of the FWHM seeing in the i band for the field | |

seeing_z | real | 4 | arcsec | average measure of the FWHM seeing in the z band for the field |