Choose a database in the left panel then select the table you want!

Table: smash_dr1.chip
(The bold columns are indexed columns)
Column NameDescriptionDatatype
alf_depthMedian ALLFRAME depth, instrumental magsREAL
alf_nsourcesTotal number of DAOPHOT/ALLFRAME sourcesINTEGER
apcorAperture correctionREAL
badsolnDid we have a good transformation equation/solution for these dataSMALLINT
baseBase of all files for this chipCHAR
calib_amtermTransformation equation airmass/extinction termREAL
calib_amtermsigTransformation equation uncertainty in airmass/extinction termREAL
calib_bandTransformation equation band nameCHAR
calib_colbandTransformation equation band name to construct the colorCHAR
calib_colsignTrans. eqn. sign: 1 - color=band-colband; -1 - color=colband-bandSMALLINT
calib_coltermTransformation equation color termREAL
calib_coltermsigSigma of color term in calibrationREAL
calib_zptermTransformation equation zeropoint termREAL
calib_zptermsigTransformation equation uncertainty in zeropoint termREAL
calibratedIs this chip calibrated or notSMALLINT
chipChip number (1-62)SMALLINT
dao_depthALLSTAR depth (peak of the source histogram), instrumental magsREAL
dao_npsfstarsNumber of stars used to construct PSFINTEGER
dao_nsourcesTotal number of DAOPHOT/ALLSTAR sources in chipINTEGER
dao_psfboxsizePSF box size in pixelsINTEGER
dao_psfchiDAOPHOT PSF chi goodness-of-fit valueREAL
dao_psftypeAnalytical function type for DAOPHOT PSFCHAR
dao_psfvarorderSpatial PSF variations, -1 to 2INTEGER
decDeclination at center of chip (in degrees)DOUBLE
ebvMedian SFD E(B-V) for this chipREAL
expnumEight-digit exposure numberCHAR
fileFilename for this chipCHAR
fwhmFWHM of PSF (i.e. seeing) in pixels (multiply by 0.26 to get arcsec)REAL
gaiawcsnmatchGAIA matches used for the astrometric fittingINTEGER
gaiawcsrmsThe RMS of the residuals using the GAIA reference starsREAL
gainGain, electrons/ADUREAL
htm9HTM index (order 9 => ~10 arcmin size)BIGINT
nest4096Nested-scheme HEALPix (Gorski et al. 2005) index with NSIDE=4096 (~1 arcmin resolution)BIGINT
nsrcNumber of sources in SOURCE table for this chipINTEGER
nxNumber of pixels in X-dimensionINTEGER
nyNumber of pixels in Y-dimensionINTEGER
photometricIs this from a photometric nightSMALLINT
photred_fieldShort field name for the PHOTRED reductionCHAR
pixscaleArcsec per pixelREAL
raRight ascension at center of chip (in degrees)DOUBLE
rdnoiseRead noise, electronsREAL
refexpnumExposure number for the reference frameCHAR
ring256Ring-scheme HEALPix (Gorski et al. 2005) index with NSIDE=256 (~14 arcmin resolution)BIGINT
skymodeMedian sky background levelREAL
skysigSigma in sky backgroundREAL
ubercal_flagUbercal flag: 0-none, 1-good, 2-med exp+chip, 3-med exp+std chipSMALLINT
ubercal_magoffsetThe magnitude offset applied from the ubercal algorithmREAL
vertex_dec1First DEC value for the four corners of the chipDOUBLE
vertex_dec2Second DEC value for the four corners of the chipDOUBLE
vertex_dec3Third DEC value for the four corners of the chipDOUBLE
vertex_dec4Fourth DEC value for the four corners of the chipDOUBLE
vertex_ra1First RA value for the four corners of the chipDOUBLE
vertex_ra2Second RA value for the four corners of the chipDOUBLE
vertex_ra3Third RA value for the four corners of the chipDOUBLE
vertex_ra4Fourth RA value for the four corners of the chipDOUBLE
wcsrmsRMS in WCS fit with respect to reference catalog in arcsecREAL
wcstypeWCS type, always TPVCHAR
zpcalib_magofferrThe uncertainty in the zero-point offsetREAL
zpcalib_magoffsetThe zero-point offset used for this chipREAL
zpcalibflagZP calib type: 1-phot DECam, 2-overlap, 3-0.9m, 4-GAIA relationsSMALLINT