Choose a database in the left panel then select the table you want!
Table: stripe82.twomass_psc
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| a | Catalog 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_opt | Blue magnitude of associated optical source. | REAL |
| bl_flg | Blend 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_flg | Contamination 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 |
| coadd | Sequence 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_key | Unique identification number of the record in the Atlas Image Information Table that corresponds to Image in which the position of this source falls. | INTEGER |
| date | The observation reference date for this source expressed in ISO standard format. | CHAR |
| dec | J2000 declination with respect to the ICRS | DOUBLE |
| designation | Sexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...]. | CHAR |
| dist_edge_ew | The distance from the source to the nearest East or West scan edge. | INTEGER |
| dist_edge_flg | Two 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_ns | The distance from the source to the nearest North or South scan edge. | INTEGER |
| dist_opt | Distance separating 2MASS source position and associated optical source within approximately 5 arcsec | REAL |
| dup_src | Duplicate 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_ang | Position angle on the sky of the semi-major axis of the position uncertainty ellipse (East of North) | SMALLINT |
| err_maj | Semi-major axis length of the one sigma position uncertainty ellipse | REAL |
| err_min | Semi-minor axis length of the one sigma position uncertainty ellipse | REAL |
| ext_key | Unique identification number of the record in the XSC that corresponds to this point source. | INTEGER |
| gal_contam | Extended source contamination flag. | SMALLINT |
| glat | Galactic latitude | REAL |
| glon | Galactic longitude | REAL |
| h_cmsig | Corrected photometric uncertainty for the default H-band magnitude. | REAL |
| h_m | Default 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_stdap | H-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_stdap | Uncertainty in the H-band standard aperture magnitude. | REAL |
| h_msigcom | Combined, or total photometric uncertainty for the default H-band magnitude. | REAL |
| h_psfchi | Reduced chi-squared goodness-of-fit value for the H-band profile-fit photometry made on the 1.3 s Read_2 exposures. | REAL |
| h_snr | H-band scan signal-to-noise ratio. | REAL |
| hemis | Hemisphere code for the 2MASS Observatory from which this source was observed. n=North/Mt. Hopkins. s=South/CTIO | CHAR |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| j_cmsig | Corrected photometric uncertainty for the default J-band magnitude. | REAL |
| j_m | Default 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_stdap | J-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_stdap | Uncertainty in the J-band standard aperture magnitude. | REAL |
| j_msigcom | Combined, or total photometric uncertainty for the default J-band magnitude. | REAL |
| j_psfchi | Reduced chi-squared goodness-of-fit value for the J-band profile-fit photometry made on the 1.3 s Read_2 exposures. | REAL |
| j_snr | J-band scan signal-to-noise ratio. | REAL |
| jdate | The Julian Date of the source measurement accurate to +-30 seconds. | DOUBLE |
| k_cmsig | Corrected photometric uncertainty for the default Ks-band magnitude. | REAL |
| k_m | Default 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_stdap | Ks-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_stdap | Uncertainty in the Ks-band standard aperture magnitude. | REAL |
| k_msigcom | Combined, or total photometric uncertainty for the default Ks-band magnitude. | REAL |
| k_psfchi | Reduced chi-squared goodness-of-fit value for the Ks-band profile-fit photometry made on the 1.3 s Read_2 exposures. | REAL |
| k_snr | Ks-band scan signal-to-noise ratio. | REAL |
| mp_flg | Minor 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 |
| ndet | Frame detection statistics. | CHAR |
| nest256 | HEALPIX index (Nsides 256 => ~14 arcmin size) | INTEGER |
| nopt_mchs | The number of USNO-A2.0 or Tycho 2 optical sources found within a radius of approximately 5 arcsec of the 2MASS position. | SMALLINT |
| ph_qual | Photometric quality flag. | CHAR |
| phi_opt | Position angle on the sky of the vector from the the associated optical source to the 2MASS source position, in degrees East of North. | SMALLINT |
| prox | Proximity. The distance between this source and its nearest neighbor in the PSC. | REAL |
| pts_key | A unique identification number for the PSC source. | INTEGER |
| pxcntr | The pts_key value of the nearest source in the PSC. | INTEGER |
| pxpa | The 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 |
| ra | J2000 right ascension with respect to the ICRS | DOUBLE |
| rd_flg | Read 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 |
| ring256 | HEALPIX index (Nsides 256 => ~14 arcmin size) | INTEGER |
| scan | The nightly scan number in which the source was detected. | SMALLINT |
| scan_key | Unique identification number of the record in the Scan Information Table that corresponds to the survey scan in which this source was detected. | INTEGER |
| use_src | Use 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_opt | Visual or red magnitude of the associated optical source. | REAL |
| x_scan | Mean 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 |
