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

Table: decaps_dr1.object
(The bold columns are indexed columns)
Column NameDescriptionDatatype
_idObject identifierBIGINT
decDeclination (deg)DOUBLE[]
dec_okDeclination of ok detections (deg)DOUBLE[]
elatEcliptic latitude (deg)DOUBLE[]
elonEcliptic longitude (deg)DOUBLE[]
epochmeanAverage MJDDOUBLE[]
epochmean_okAverage MJD (ok only)DOUBLE[]
epochrangeMJD between first and last detectionsDOUBLE[]
epochrange_okMJD between first and last ok detectionsDOUBLE[]
err_gUncertainty in mean flux in g-bandREAL
err_iUncertainty in mean flux in i-bandREAL
err_lbs_gUncertainty in mean local-background-subtracted flux in g-bandREAL
err_lbs_iUncertainty in mean local-background-subtracted flux in i-bandREAL
err_lbs_rUncertainty in mean local-background-subtracted flux in r-bandREAL
err_lbs_yUncertainty in mean local-background-subtracted flux in Y-bandREAL
err_lbs_zUncertainty in mean local-background-subtracted flux in z-bandREAL
err_rUncertainty in mean flux in r-bandREAL
err_yUncertainty in mean flux in Y-bandREAL
err_zUncertainty in mean flux in z-bandREAL
fracflux_gAverage fractional flux in g-band (ok only)REAL
fracflux_iAverage fractional flux in i-band (ok only)REAL
fracflux_rAverage fractional flux in r-band (ok only)REAL
fracflux_yAverage fractional flux in Y-band (ok only)REAL
fracflux_zAverage fractional flux in z-band (ok only)REAL
glatGalactic latitude (deg)DOUBLE[]
glonGalactic longitude (deg)DOUBLE[]
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
maglimit_g5-sigma magnitude limit of deepest image (ok only) in g-bandREAL
maglimit_i5-sigma magnitude limit of deepest image (ok only) in i-bandREAL
maglimit_r5-sigma magnitude limit of deepest image (ok only) in r-bandREAL
maglimit_y5-sigma magnitude limit of deepest image (ok only) in Y-bandREAL
maglimit_z5-sigma magnitude limit of deepest image (ok only) in z-bandREAL
mean_gMean flux in g-bandREAL
mean_iMean flux in i-bandREAL
mean_lbs_gMean local-background-subtracted flux (units of 3631 Jy) in g-bandREAL
mean_lbs_iMean local-background-subtracted flux (units of 3631 Jy) in i-bandREAL
mean_lbs_rMean local-background-subtracted flux (units of 3631 Jy) in r-bandREAL
mean_lbs_yMean local-background-subtracted flux (units of 3631 Jy) in Y-bandREAL
mean_lbs_zMean local-background-subtracted flux (units of 3631 Jy) in z-bandREAL
mean_mag_gMean magnitude in g-bandREAL
mean_mag_g_rMean magnitude of g-r colorREAL
mean_mag_iMean magnitude in i-bandREAL
mean_mag_i_zMean magnitude of i-z colorREAL
mean_mag_rMean magnitude in r-bandREAL
mean_mag_r_iMean magnitude of r-i colorREAL
mean_mag_yMean magnitude in Y-bandREAL
mean_mag_zMean magnitude in z-bandREAL
mean_mag_z_yMean magnitude of z-Y colorREAL
mean_rMean flux in r-bandREAL
mean_yMean flux in Y-bandREAL
mean_zMean flux in z-bandREAL
median_gMedian flux (units of 3631 Jy) in g-bandREAL
median_iMedian flux (units of 3631 Jy) in i-bandREAL
median_lbs_gMedian local-background-subtracted flux (units of 3631 Jy) in g-bandREAL
median_lbs_iMedian local-background-subtracted flux (units of 3631 Jy) in i-bandREAL
median_lbs_rMedian local-background-subtracted flux (units of 3631 Jy) in r-bandREAL
median_lbs_yMedian local-background-subtracted flux (units of 3631 Jy) in Y-bandREAL
median_lbs_zMedian local-background-subtracted flux (units of 3631 Jy) in z-bandREAL
median_mag_gMedian magnitude (units of 3631 Jy) in g-bandREAL
median_mag_g_rMedian magnitude of g-r colorREAL
median_mag_iMedian magnitude (units of 3631 Jy) in i-bandREAL
median_mag_i_zMedian magnitude of i-z colorREAL
median_mag_rMedian magnitude (units of 3631 Jy) in r-bandREAL
median_mag_r_iMedian magnitude of r-i colorREAL
median_mag_yMedian magnitude (units of 3631 Jy) in Y-bandREAL
median_mag_zMedian magnitude (units of 3631 Jy) in z-bandREAL
median_mag_z_yMedian magnitude of z-Y colorREAL
median_rMedian flux (units of 3631 Jy) in r-bandREAL
median_yMedian flux (units of 3631 Jy) in Y-bandREAL
median_zMedian flux (units of 3631 Jy) in z-bandREAL
ndetNumber of detectionsSMALLINT
ndet_lbsNumber of local-background-subtracted flux detectionsSMALLINT
ndet_lbs_okNumber of ok local-background-subtracted flux detectionsSMALLINT
ndet_okNumber of ok detectionsSMALLINT
nest4096HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size)INTEGER
nmag_gNumber of detections in g-bandSMALLINT
nmag_iNumber of detections in i-bandSMALLINT
nmag_lbs_gNumber of local-background-subtracted flux detections in g-bandSMALLINT
nmag_lbs_iNumber of local-background-subtracted flux detections in i-bandSMALLINT
nmag_lbs_ok_gNumber of ok local-background-subtracted flux detections in g-bandSMALLINT
nmag_lbs_ok_iNumber of ok local-background-subtracted flux detections in i-bandSMALLINT
nmag_lbs_ok_rNumber of ok local-background-subtracted flux detections in r-bandSMALLINT
nmag_lbs_ok_yNumber of ok local-background-subtracted flux detections in Y-bandSMALLINT
nmag_lbs_ok_zNumber of ok local-background-subtracted flux detections in z-bandSMALLINT
nmag_lbs_rNumber of local-background-subtracted flux detections in r-bandSMALLINT
nmag_lbs_yNumber of local-background-subtracted flux detections in Y-bandSMALLINT
nmag_lbs_zNumber of local-background-subtracted flux detections in z-bandSMALLINT
nmag_ok_gNumber of ok detections in g-bandSMALLINT
nmag_ok_iNumber of ok detections in i-bandSMALLINT
nmag_ok_rNumber of ok detections in r-bandSMALLINT
nmag_ok_yNumber of ok detections in Y-bandSMALLINT
nmag_ok_zNumber of ok detections in z-bandSMALLINT
nmag_rNumber of detections in r-bandSMALLINT
nmag_yNumber of detections in Y-bandSMALLINT
nmag_zNumber of detections in z-bandSMALLINT
obj_idUnique object identifierBIGINT
posstdevStandard deviation in position (arcsec)REAL
posstdev_okStandard deviation (ok detections only) (arcsec)REAL
q25_g25th percentile flux (units of 3631 Jy) in g-bandREAL
q25_i25th percentile flux (units of 3631 Jy) in i-bandREAL
q25_lbs_g25th percentile local-background-subtracted flux (units of 3631 Jy) in g-bandREAL
q25_lbs_i25th percentile local-background-subtracted flux (units of 3631 Jy) in i-bandREAL
q25_lbs_r25th percentile local-background-subtracted flux (units of 3631 Jy) in r-bandREAL
q25_lbs_y25th percentile local-background-subtracted flux (units of 3631 Jy) in Y-bandREAL
q25_lbs_z25th percentile local-background-subtracted flux (units of 3631 Jy) in z-bandREAL
q25_r25th percentile flux (units of 3631 Jy) in r-bandREAL
q25_y25th percentile flux (units of 3631 Jy) in Y-bandREAL
q25_z25th percentile flux (units of 3631 Jy) in z-bandREAL
q75_g75th percentile flux (units of 3631 Jy) in g-bandREAL
q75_i75th percentile flux (units of 3631 Jy) in i-bandREAL
q75_lbs_g75th percentile local-background-subtracted flux (units of 3631 Jy) in g-bandREAL
q75_lbs_i75th percentile local-background-subtracted flux (units of 3631 Jy) in i-bandREAL
q75_lbs_r75th percentile local-background-subtracted flux (units of 3631 Jy) in r-bandREAL
q75_lbs_y75th percentile local-background-subtracted flux (units of 3631 Jy) in Y-bandREAL
q75_lbs_z75th percentile local-background-subtracted flux (units of 3631 Jy) in z-bandREAL
q75_r75th percentile flux (units of 3631 Jy) in r-bandREAL
q75_y75th percentile flux (units of 3631 Jy) in Y-bandREAL
q75_z75th percentile flux (units of 3631 Jy) in z-bandREAL
raRight ascension (deg)DOUBLE[]
ra_okRight ascension of ok detections (deg)DOUBLE[]
random_idRandom ID in the range 0.0 => 100.0REAL
ring256HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size)INTEGER
stdev_gFlux standard deviation in g-bandREAL
stdev_iFlux standard deviation in i-bandREAL
stdev_lbs_gLocal-background-subtracted flux standard deviation in g-bandREAL
stdev_lbs_iLocal-background-subtracted flux standard deviation in i-bandREAL
stdev_lbs_rLocal-background-subtracted flux standard deviation in r-bandREAL
stdev_lbs_yLocal-background-subtracted flux standard deviation in Y-bandREAL
stdev_lbs_zLocal-background-subtracted flux standard deviation in z-bandREAL
stdev_rFlux standard deviation in r-bandREAL
stdev_yFlux standard deviation in Y-bandREAL
stdev_zFlux standard deviation in z-bandREAL


Data Lab is migrating from datalab.noao.edu to datalab.noirlab.edu. You are currently being re-directed.
If you are not automatically redirected in 5 seconds, please click here
Please update your bookmark to Data Lab accordingly.