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

Table: stripe82.twomass_psc
(The bold columns are indexed columns)
Column NameDescriptionDatatype
aCatalog identifier of an optical source from either the Tycho 2 or USNO-A2.0 catalog that falls within approximately 5 arcsec of the 2MASS source position.CHAR
b_m_optBlue magnitude of associated optical source.REAL
bl_flgBlend flag. Three character flag, one character per band [JHKs], that indicates the number of components that were fit simultaneously when estimating the brightness of a source.CHAR
cc_flgContamination and confusion flag. Three character flag, one character per band [JHKs], that indicates that the photometry and/or position measurements of a source may be contaminated or biased due to proximity to an image artifact or nearby source of equal or greater brightness.CHAR
coaddSequence number of the Atlas Image in which the position of this source falls. The Image sequence number is number of the frame that is nearest the center of the Image.SMALLINT
coadd_keyUnique identification number of the record in the Atlas Image Information Table that corresponds to Image in which the position of this source falls.INTEGER
dateThe observation reference date for this source expressed in ISO standard format.CHAR
decJ2000 declination with respect to the ICRSDOUBLE
designationSexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...].CHAR
dist_edge_ewThe distance from the source to the nearest East or West scan edge.INTEGER
dist_edge_flgTwo character flag that specifies to which scan edges a source lies closest, and to which edges the dist_edge_ns and dist_edge_ew values refer.CHAR
dist_edge_nsThe distance from the source to the nearest North or South scan edge.INTEGER
dist_optDistance separating 2MASS source position and associated optical source within approximately 5 arcsecREAL
dup_srcDuplicate source flag. Used in conjunction with the use_src flag, this numerical flag indicates whether the source falls in a Tile overlap region, and if so, if it was detected multiple times.SMALLINT
err_angPosition angle on the sky of the semi-major axis of the position uncertainty ellipse (East of North)SMALLINT
err_majSemi-major axis length of the one sigma position uncertainty ellipseREAL
err_minSemi-minor axis length of the one sigma position uncertainty ellipseREAL
ext_keyUnique identification number of the record in the XSC that corresponds to this point source.INTEGER
gal_contamExtended source contamination flag.SMALLINT
glatGalactic latitudeREAL
glonGalactic longitudeREAL
h_cmsigCorrected photometric uncertainty for the default H-band magnitude.REAL
h_mDefault H-band magnitude, or if the source is not detected in the H-band, the 95% confidence upper limit derived from a 4-inch radius aperture measurement taken at the position of the source on the Atlas Image.REAL
h_m_stdapH-band standard aperture magnitude. This is the curve-of-growth corrected average brightness measured in a 4-inch radius aperture centered on the source position on each of the available 1.3 s 'Read_2' frames.REAL
h_msig_stdapUncertainty in the H-band standard aperture magnitude.REAL
h_msigcomCombined, or total photometric uncertainty for the default H-band magnitude.REAL
h_psfchiReduced chi-squared goodness-of-fit value for the H-band profile-fit photometry made on the 1.3 s 'Read_2' exposures.REAL
h_snrH-band 'scan' signal-to-noise ratio.REAL
hemisHemisphere code for the 2MASS Observatory from which this source was observed. 'n'=North/Mt. Hopkins. 's'=South/CTIOCHAR
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
j_cmsigCorrected photometric uncertainty for the default J-band magnitude.REAL
j_mDefault J-band magnitude, or if the source is not detected in the J-band, the 95% confidence upper limit derived from a 4-inch radius aperture measurement taken at the position of the source on the Atlas Image.REAL
j_m_stdapJ-band standard aperture magnitude. This is the curve-of-growth corrected average brightness measured in a 4-inch radius aperture centered on the source position on each of the available 1.3 s 'Read_2' frames.REAL
j_msig_stdapUncertainty in the J-band standard aperture magnitude.REAL
j_msigcomCombined, or total photometric uncertainty for the default J-band magnitude.REAL
j_psfchiReduced chi-squared goodness-of-fit value for the J-band profile-fit photometry made on the 1.3 s 'Read_2' exposures.REAL
j_snrJ-band 'scan' signal-to-noise ratio.REAL
jdateThe Julian Date of the source measurement accurate to +-30 seconds.DOUBLE
k_cmsigCorrected photometric uncertainty for the default Ks-band magnitude.REAL
k_mDefault Ks-band magnitude, or if the source is not detected in the Ks-band, the 95% confidence upper limit derived from a 4-inch radius aperture measurement taken at the position of the source on the Atlas Image.REAL
k_m_stdapKs-band standard aperture magnitude. This is the curve-of-growth corrected average brightness measured in a 4-inch radius aperture centered on the source position on each of the available 1.3 s 'Read_2' frames.REAL
k_msig_stdapUncertainty in the Ks-band standard aperture magnitude.REAL
k_msigcomCombined, or total photometric uncertainty for the default Ks-band magnitude.REAL
k_psfchiReduced chi-squared goodness-of-fit value for the Ks-band profile-fit photometry made on the 1.3 s 'Read_2' exposures.REAL
k_snrKs-band 'scan' signal-to-noise ratio.REAL
mp_flgMinor Planet Flag. Indicates if this source is associated with the predicted position of a known minor planet, comet, planet or planetary satellite. This association does not guarantee that the PSC source is a detection of the solar system object.SMALLINT
ndetFrame detection statistics.CHAR
nest256HEALPIX index (Nsides 256 => ~14 arcmin size)INTEGER
nopt_mchsThe number of USNO-A2.0 or Tycho 2 optical sources found within a radius of approximately 5 arcsec of the 2MASS position.SMALLINT
ph_qualPhotometric quality flag.CHAR
phi_optPosition angle on the sky of the vector from the the associated optical source to the 2MASS source position, in degrees East of North.SMALLINT
proxProximity. The distance between this source and its nearest neighbor in the PSC.REAL
pts_keyA unique identification number for the PSC source.INTEGER
pxcntrThe pts_key value of the nearest source in the PSC.INTEGER
pxpaThe position angle on the sky of the vector from the source to the nearest neighbor in the PSC, in degrees East of North. This column in null if prox=0.0, which occurs only for confused sources or from errors in the bandmerge process caused by confusion.SMALLINT
raJ2000 right ascension with respect to the ICRSDOUBLE
rd_flgRead flag. Three character flag, one character per band [JHKs], that indicates the origin of the default magnitudes and uncertainties in each band (j_m, h_m, k_m, j_cmsig, h_cmsig, k_cmsig). Rd_flg values of 1,2, or 3 generally indicate the best quality detections, photometry and astrometry (although other quality flags must be considered). Values of 0,4,6,9 in a band indicate either non-detections, or generally poor quality photometry and positions.CHAR
ring256HEALPIX index (Nsides 256 => ~14 arcmin size)INTEGER
scanThe nightly scan number in which the source was detected.SMALLINT
scan_keyUnique identification number of the record in the Scan Information Table that corresponds to the survey scan in which this source was detected.INTEGER
use_srcUse source flag. Used in conjunction with the dup_src flag, this numerical flag indicates if a source falls within a Tile overlap region, and whether or not it satisfies the unbiased selection rules for multiple source resolution.SMALLINT
vr_m_optVisual or red magnitude of the associated optical source.REAL
x_scanMean cross-scan focal plane position of the source in the Universal scan (U-scan) coordinate system. This is the approximate distance a source lies west or east of the focal plane centerline. Positive values of x_scan indicate that the source falls west of the centerline and negative values indicate the source is east of the centerline.REAL