Choose a database in the left panel then select the table you want!
Table: vhs_dr5.vhs_cat_v3
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| ah | The galactic extinction correction in the H band | REAL |
| aj | The galactic extinction correction in the J band | REAL |
| aks | The galactic extinction correction in the Ks band | REAL |
| ay | The galactic extinction correction in the Y band | REAL |
| b | Galactic latitude | DOUBLE |
| cueventid | UID of curation event giving rise to this record | INTEGER |
| dec2000 | Celestial Declination | DOUBLE |
| ebv | The galactic dust extinction value measured from the Schlegel maps | REAL |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| eta | SDSS system spherical co-ordinate 2 | DOUBLE |
| framesetid | UID of the set of frames that this merged source comes from | BIGINT |
| hapermag3 | Default point source H aperture corrected mag (2.0 arcsec diam) | REAL |
| hapermag3err | Error in default point/extended source H mag | REAL |
| hapermag4 | Point source H aperture corrected mag (2.8 arcsec aperture diam) | REAL |
| hapermag4err | Error in point/extended source H mag (2.8 arcsec aperture diam) | REAL |
| hapermag6 | Point source H aperture corrected mag (5.7 arcsec aperture diam) | REAL |
| hapermag6err | Error in point/extended source H mag (5.7 arcsec aperture diam) | REAL |
| hapermagnoapercorr3 | Default extended source H aperture mag (2.0 arcsec diam) | REAL |
| hapermagnoapercorr4 | Extended source H aperture mag (2.8 arcsec aperture diameter) | REAL |
| hapermagnoapercorr6 | Extended source H aperture mag (5.7 arcsec aperture diameter) | REAL |
| haverageconf | average confidence in 2 arcsec diam default aperture 3 H | REAL |
| hclass | discrete image classification flag in H | SMALLINT |
| hclassstat | N(0,1) stellarness-of-profile statistic in H | REAL |
| hell | 1-b/a, where a/b=semi-major/minor axes in H | REAL |
| herrbits | processing warning/error bitwise flags in H | INTEGER |
| heta | Offset of H detection from master position (+north/-south) | REAL |
| hgausig | RMS of axes of ellipse fit in H | REAL |
| hhlcorsmjradas | Seeing corrected half-light, semi-major axis in H band | REAL |
| hmjd | Modified Julian Day in H band | DOUBLE |
| hmksext | Extended source colour H-Ks (using aperMagNoAperCorr3) | REAL |
| hmksexterr | Error on extended source colour H-Ks | REAL |
| hmkspnt | Point source colour H-Ks (using aperMag3) | REAL |
| hmkspnterr | Error on point source colour H-Ks | REAL |
| hpa | ellipse fit celestial orientation in H | REAL |
| hpetromag | Extended source H mag (Petrosian) | REAL |
| hpetromagerr | Error in extended source H mag (Petrosian) | REAL |
| hpperrbits | additional WFAU post-processing error bits in H | INTEGER |
| hseqnum | the running number of the H detection | INTEGER |
| htm9 | HTM index (order 9 => ~10 arcmin size) | DOUBLE |
| hxi | Offset of H detection from master position (+east/-west) | REAL |
| japermag3 | Default point source J aperture corrected mag (2.0 arcsec diam) | REAL |
| japermag3err | Error in default point/extended source J mag | REAL |
| japermag4 | Point source J aperture corrected mag (2.8 arcsec aperture diam) | REAL |
| japermag4err | Error in point/extended source J mag (2.8 arcsec aperture diam) | REAL |
| japermag6 | Point source J aperture corrected mag (5.7 arcsec aperture diam) | REAL |
| japermag6err | Error in point/extended source J mag (5.7 arcsec aperture diam) | REAL |
| japermagnoapercorr3 | Default extended source J aperture mag (2.0 arcsec diam) | REAL |
| japermagnoapercorr4 | Extended source J aperture mag (2.8 arcsec aperture diameter) | REAL |
| japermagnoapercorr6 | Extended source J aperture mag (5.7 arcsec aperture diameter) | REAL |
| javerageconf | average confidence in 2 arcsec diam default aperture 3 J | REAL |
| jclass | discrete image classification flag in J | SMALLINT |
| jclassstat | N(0,1) stellarness-of-profile statistic in J | REAL |
| jell | 1-b/a, where a/b=semi-major/minor axes in J | REAL |
| jerrbits | processing warning/error bitwise flags in J | INTEGER |
| jeta | Offset of J detection from master position (+north/-south) | REAL |
| jgausig | RMS of axes of ellipse fit in J | REAL |
| jhlcorsmjradas | Seeing corrected half-light, semi-major axis in J band | REAL |
| jmhext | Extended source colour J-H (using aperMagNoAperCorr3) | REAL |
| jmhexterr | Error on extended source colour J-H | REAL |
| jmhpnt | Point source colour J-H (using aperMag3) | REAL |
| jmhpnterr | Error on point source colour J-H | REAL |
| jmjd | Modified Julian Day in J band | DOUBLE |
| jmksext | Extended source colour J-Ks (using aperMagNoAperCorr3) | REAL |
| jmksexterr | Error on extended source colour J-Ks | REAL |
| jmkspnt | Point source colour J-Ks (using aperMag3) | REAL |
| jmkspnterr | Error on point source colour J-Ks | REAL |
| jpa | ellipse fit celestial orientation in J | REAL |
| jpetromag | Extended source J mag (Petrosian) | REAL |
| jpetromagerr | Error in extended source J mag (Petrosian) | REAL |
| jpperrbits | additional WFAU post-processing error bits in J | INTEGER |
| jseqnum | the running number of the J detection | INTEGER |
| jxi | Offset of J detection from master position (+east/-west) | REAL |
| ksapermag3 | Default point source Ks aperture corrected mag (2.0 arcsec diam) | REAL |
| ksapermag3err | Error in default point/extended source Ks mag | REAL |
| ksapermag4 | Point source Ks aperture corrected mag (2.8 arcsec aperture diam) | REAL |
| ksapermag4err | Error in point/extended source Ks mag (2.8 arcsec aperture diam) | REAL |
| ksapermag6 | Point source Ks aperture corrected mag (5.7 arcsec aperture diam) | REAL |
| ksapermag6err | Error in point/extended source Ks mag (5.7 arcsec aperture diam) | REAL |
| ksapermagnoapercorr3 | Default extended source Ks aperture mag (2.0 arcsec diam) | REAL |
| ksapermagnoapercorr4 | Extended source Ks aperture mag (2.8 arcsec aperture diameter) | REAL |
| ksapermagnoapercorr6 | Extended source Ks aperture mag (5.7 arcsec aperture diameter) | REAL |
| ksaverageconf | average confidence in 2 arcsec diam default aperture 3 Ks | REAL |
| ksclass | discrete image classification flag in Ks | SMALLINT |
| ksclassstat | N(0,1) stellarness-of-profile statistic in Ks | REAL |
| ksell | 1-b/a, where a/b=semi-major/minor axes in Ks | REAL |
| kserrbits | processing warning/error bitwise flags in Ks | INTEGER |
| kseta | Offset of Ks detection from master position (+north/-south) | REAL |
| ksgausig | RMS of axes of ellipse fit in Ks | REAL |
| kshlcorsmjradas | Seeing corrected half-light, semi-major axis in Ks band | REAL |
| ksmjd | Modified Julian Day in Ks band | DOUBLE |
| kspa | ellipse fit celestial orientation in Ks | REAL |
| kspetromag | Extended source Ks mag (Petrosian) | REAL |
| kspetromagerr | Error in extended source Ks mag (Petrosian) | REAL |
| kspperrbits | additional WFAU post-processing error bits in Ks | INTEGER |
| ksseqnum | the running number of the Ks detection | INTEGER |
| ksxi | Offset of Ks detection from master position (+east/-west) | REAL |
| l | Galactic longitude | DOUBLE |
| lambda | SDSS system spherical co-ordinate 1 | DOUBLE |
| mergedclass | Class flag,1|0|-1|-2|-3|-9=gal|noise|star|probStar|probGal|saturated | SMALLINT |
| mergedclassstat | Merged N(0,1) stellarness-of-profile statistic | REAL |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size) | INTEGER |
| pgalaxy | Probability that the source is a galaxy | REAL |
| pnoise | Probability that the source is noise | REAL |
| primary_source | Flag indicates primary sources (=1), otherwise (=0) | DOUBLE |
| priorsec | Seam code for a unique (=0) or duplicated (!=0) source | BIGINT |
| psaturated | Probability that the source is saturated | REAL |
| pstar | Probability that the source is a star | REAL |
| ra2000 | Celestial Right Ascension | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| ring256 | HEALPix ring nside=256 index | INTEGER |
| sourceid | UID of this merged detection as assigned by merge algorithm | BIGINT |
| sourcename | Source name in IAU convention | CHAR |
| yapermag3 | Default point source Y aperture corrected mag (2.0 arcsec diam) | REAL |
| yapermag3err | Error in default point/extended source Y mag | REAL |
| yapermag4 | Point source Y aperture corrected mag (2.8 arcsec aperture diam) | REAL |
| yapermag4err | Error in point/extended source Y mag (2.8 arcsec aperture diam) | REAL |
| yapermag6 | Point source Y aperture corrected mag (5.7 arcsec aperture diam) | REAL |
| yapermag6err | Error in point/extended source Y mag (5.7 arcsec aperture diam) | REAL |
| yapermagnoapercorr3 | Default extended source Y aperture mag (2.0 arcsec diam) | REAL |
| yapermagnoapercorr4 | Extended source Y aperture mag (2.8 arcsec aperture diameter) | REAL |
| yapermagnoapercorr6 | Extended source Y aperture mag (5.7 arcsec aperture diameter) | REAL |
| yaverageconf | average confidence in 2 arcsec diam default aperture 3 Y | REAL |
| yclass | discrete image classification flag in Y | SMALLINT |
| yclassstat | N(0,1) stellarness-of-profile statistic in Y | REAL |
| yell | 1-b/a, where a/b=semi-major/minor axes in Y | REAL |
| yerrbits | processing warning/error bitwise flags in Y | INTEGER |
| yeta | Offset of Y detection from master position (+north/-south) | REAL |
| ygausig | RMS of axes of ellipse fit in Y | REAL |
| yhlcorsmjradas | Seeing corrected half-light, semi-major axis in Y band | REAL |
| ymjd | Modified Julian Day in Y band | DOUBLE |
| ymjext | Extended source colour Y-J (using aperMagNoAperCorr3) | REAL |
| ymjexterr | Error on extended source colour Y-J | REAL |
| ymjpnt | Point source colour Y-J (using aperMag3) | REAL |
| ymjpnterr | Error on point source colour Y-J | REAL |
| ypa | ellipse fit celestial orientation in Y | REAL |
| ypetromag | Extended source Y mag (Petrosian) | REAL |
| ypetromagerr | Error in extended source Y mag (Petrosian) | REAL |
| ypperrbits | additional WFAU post-processing error bits in Y | INTEGER |
| yseqnum | the running number of the Y detection | INTEGER |
| yxi | Offset of Y detection from master position (+east/-west) | REAL |
