Choose a database in the left panel then select the table you want!
Table: decaps_dr1.object
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| _id | Object identifier | BIGINT |
| dec | Declination (deg) | DOUBLE |
| dec_ok | Declination of ok detections (deg) | DOUBLE |
| elat | Ecliptic latitude (deg) | DOUBLE |
| elon | Ecliptic longitude (deg) | DOUBLE |
| epochmean | Average MJD | DOUBLE |
| epochmean_ok | Average MJD (ok only) | DOUBLE |
| epochrange | MJD between first and last detections | DOUBLE |
| epochrange_ok | MJD between first and last ok detections | DOUBLE |
| err_g | Uncertainty in mean flux in g-band | REAL |
| err_i | Uncertainty in mean flux in i-band | REAL |
| err_lbs_g | Uncertainty in mean local-background-subtracted flux in g-band | REAL |
| err_lbs_i | Uncertainty in mean local-background-subtracted flux in i-band | REAL |
| err_lbs_r | Uncertainty in mean local-background-subtracted flux in r-band | REAL |
| err_lbs_y | Uncertainty in mean local-background-subtracted flux in Y-band | REAL |
| err_lbs_z | Uncertainty in mean local-background-subtracted flux in z-band | REAL |
| err_r | Uncertainty in mean flux in r-band | REAL |
| err_y | Uncertainty in mean flux in Y-band | REAL |
| err_z | Uncertainty in mean flux in z-band | REAL |
| fracflux_g | Average fractional flux in g-band (ok only) | REAL |
| fracflux_i | Average fractional flux in i-band (ok only) | REAL |
| fracflux_r | Average fractional flux in r-band (ok only) | REAL |
| fracflux_y | Average fractional flux in Y-band (ok only) | REAL |
| fracflux_z | Average fractional flux in z-band (ok only) | REAL |
| glat | Galactic latitude (deg) | DOUBLE |
| glon | Galactic longitude (deg) | DOUBLE |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| maglimit_g | 5-sigma magnitude limit of deepest image (ok only) in g-band | REAL |
| maglimit_i | 5-sigma magnitude limit of deepest image (ok only) in i-band | REAL |
| maglimit_r | 5-sigma magnitude limit of deepest image (ok only) in r-band | REAL |
| maglimit_y | 5-sigma magnitude limit of deepest image (ok only) in Y-band | REAL |
| maglimit_z | 5-sigma magnitude limit of deepest image (ok only) in z-band | REAL |
| mean_g | Mean flux in g-band | REAL |
| mean_i | Mean flux in i-band | REAL |
| mean_lbs_g | Mean local-background-subtracted flux (units of 3631 Jy) in g-band | REAL |
| mean_lbs_i | Mean local-background-subtracted flux (units of 3631 Jy) in i-band | REAL |
| mean_lbs_r | Mean local-background-subtracted flux (units of 3631 Jy) in r-band | REAL |
| mean_lbs_y | Mean local-background-subtracted flux (units of 3631 Jy) in Y-band | REAL |
| mean_lbs_z | Mean local-background-subtracted flux (units of 3631 Jy) in z-band | REAL |
| mean_mag_g | Mean magnitude in g-band | REAL |
| mean_mag_g_r | Mean magnitude of g-r color | REAL |
| mean_mag_i | Mean magnitude in i-band | REAL |
| mean_mag_i_z | Mean magnitude of i-z color | REAL |
| mean_mag_r | Mean magnitude in r-band | REAL |
| mean_mag_r_i | Mean magnitude of r-i color | REAL |
| mean_mag_y | Mean magnitude in Y-band | REAL |
| mean_mag_z | Mean magnitude in z-band | REAL |
| mean_mag_z_y | Mean magnitude of z-Y color | REAL |
| mean_r | Mean flux in r-band | REAL |
| mean_y | Mean flux in Y-band | REAL |
| mean_z | Mean flux in z-band | REAL |
| median_g | Median flux (units of 3631 Jy) in g-band | REAL |
| median_i | Median flux (units of 3631 Jy) in i-band | REAL |
| median_lbs_g | Median local-background-subtracted flux (units of 3631 Jy) in g-band | REAL |
| median_lbs_i | Median local-background-subtracted flux (units of 3631 Jy) in i-band | REAL |
| median_lbs_r | Median local-background-subtracted flux (units of 3631 Jy) in r-band | REAL |
| median_lbs_y | Median local-background-subtracted flux (units of 3631 Jy) in Y-band | REAL |
| median_lbs_z | Median local-background-subtracted flux (units of 3631 Jy) in z-band | REAL |
| median_mag_g | Median magnitude (units of 3631 Jy) in g-band | REAL |
| median_mag_g_r | Median magnitude of g-r color | REAL |
| median_mag_i | Median magnitude (units of 3631 Jy) in i-band | REAL |
| median_mag_i_z | Median magnitude of i-z color | REAL |
| median_mag_r | Median magnitude (units of 3631 Jy) in r-band | REAL |
| median_mag_r_i | Median magnitude of r-i color | REAL |
| median_mag_y | Median magnitude (units of 3631 Jy) in Y-band | REAL |
| median_mag_z | Median magnitude (units of 3631 Jy) in z-band | REAL |
| median_mag_z_y | Median magnitude of z-Y color | REAL |
| median_r | Median flux (units of 3631 Jy) in r-band | REAL |
| median_y | Median flux (units of 3631 Jy) in Y-band | REAL |
| median_z | Median flux (units of 3631 Jy) in z-band | REAL |
| ndet | Number of detections | SMALLINT |
| ndet_lbs | Number of local-background-subtracted flux detections | SMALLINT |
| ndet_lbs_ok | Number of ok local-background-subtracted flux detections | SMALLINT |
| ndet_ok | Number of ok detections | SMALLINT |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size) | INTEGER |
| nmag_g | Number of detections in g-band | SMALLINT |
| nmag_i | Number of detections in i-band | SMALLINT |
| nmag_lbs_g | Number of local-background-subtracted flux detections in g-band | SMALLINT |
| nmag_lbs_i | Number of local-background-subtracted flux detections in i-band | SMALLINT |
| nmag_lbs_ok_g | Number of ok local-background-subtracted flux detections in g-band | SMALLINT |
| nmag_lbs_ok_i | Number of ok local-background-subtracted flux detections in i-band | SMALLINT |
| nmag_lbs_ok_r | Number of ok local-background-subtracted flux detections in r-band | SMALLINT |
| nmag_lbs_ok_y | Number of ok local-background-subtracted flux detections in Y-band | SMALLINT |
| nmag_lbs_ok_z | Number of ok local-background-subtracted flux detections in z-band | SMALLINT |
| nmag_lbs_r | Number of local-background-subtracted flux detections in r-band | SMALLINT |
| nmag_lbs_y | Number of local-background-subtracted flux detections in Y-band | SMALLINT |
| nmag_lbs_z | Number of local-background-subtracted flux detections in z-band | SMALLINT |
| nmag_ok_g | Number of ok detections in g-band | SMALLINT |
| nmag_ok_i | Number of ok detections in i-band | SMALLINT |
| nmag_ok_r | Number of ok detections in r-band | SMALLINT |
| nmag_ok_y | Number of ok detections in Y-band | SMALLINT |
| nmag_ok_z | Number of ok detections in z-band | SMALLINT |
| nmag_r | Number of detections in r-band | SMALLINT |
| nmag_y | Number of detections in Y-band | SMALLINT |
| nmag_z | Number of detections in z-band | SMALLINT |
| obj_id | Unique object identifier | BIGINT |
| posstdev | Standard deviation in position (arcsec) | REAL |
| posstdev_ok | Standard deviation (ok detections only) (arcsec) | REAL |
| q25_g | 25th percentile flux (units of 3631 Jy) in g-band | REAL |
| q25_i | 25th percentile flux (units of 3631 Jy) in i-band | REAL |
| q25_lbs_g | 25th percentile local-background-subtracted flux (units of 3631 Jy) in g-band | REAL |
| q25_lbs_i | 25th percentile local-background-subtracted flux (units of 3631 Jy) in i-band | REAL |
| q25_lbs_r | 25th percentile local-background-subtracted flux (units of 3631 Jy) in r-band | REAL |
| q25_lbs_y | 25th percentile local-background-subtracted flux (units of 3631 Jy) in Y-band | REAL |
| q25_lbs_z | 25th percentile local-background-subtracted flux (units of 3631 Jy) in z-band | REAL |
| q25_r | 25th percentile flux (units of 3631 Jy) in r-band | REAL |
| q25_y | 25th percentile flux (units of 3631 Jy) in Y-band | REAL |
| q25_z | 25th percentile flux (units of 3631 Jy) in z-band | REAL |
| q75_g | 75th percentile flux (units of 3631 Jy) in g-band | REAL |
| q75_i | 75th percentile flux (units of 3631 Jy) in i-band | REAL |
| q75_lbs_g | 75th percentile local-background-subtracted flux (units of 3631 Jy) in g-band | REAL |
| q75_lbs_i | 75th percentile local-background-subtracted flux (units of 3631 Jy) in i-band | REAL |
| q75_lbs_r | 75th percentile local-background-subtracted flux (units of 3631 Jy) in r-band | REAL |
| q75_lbs_y | 75th percentile local-background-subtracted flux (units of 3631 Jy) in Y-band | REAL |
| q75_lbs_z | 75th percentile local-background-subtracted flux (units of 3631 Jy) in z-band | REAL |
| q75_r | 75th percentile flux (units of 3631 Jy) in r-band | REAL |
| q75_y | 75th percentile flux (units of 3631 Jy) in Y-band | REAL |
| q75_z | 75th percentile flux (units of 3631 Jy) in z-band | REAL |
| ra | Right ascension (deg) | DOUBLE |
| ra_ok | Right ascension of ok detections (deg) | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| stdev_g | Flux standard deviation in g-band | REAL |
| stdev_i | Flux standard deviation in i-band | REAL |
| stdev_lbs_g | Local-background-subtracted flux standard deviation in g-band | REAL |
| stdev_lbs_i | Local-background-subtracted flux standard deviation in i-band | REAL |
| stdev_lbs_r | Local-background-subtracted flux standard deviation in r-band | REAL |
| stdev_lbs_y | Local-background-subtracted flux standard deviation in Y-band | REAL |
| stdev_lbs_z | Local-background-subtracted flux standard deviation in z-band | REAL |
| stdev_r | Flux standard deviation in r-band | REAL |
| stdev_y | Flux standard deviation in Y-band | REAL |
| stdev_z | Flux standard deviation in z-band | REAL |
