Choose a database in the left panel then select the table you want!
Table: ukidss_dr11plus.gcssource
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| b | Galactic latitude | DOUBLE |
| chi2 | Chi-squared value of proper motion solution | REAL |
| cueventid | UID of curation event giving rise to this record | INTEGER |
| cx | unit vector of spherical co-ordinates | DOUBLE |
| cy | unit vector of spherical co-ordinates | DOUBLE |
| cz | unit vector of spherical co-ordinates | DOUBLE |
| dec | Celestial Declination | DOUBLE |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| epoch | Epoch of position measurement | 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 aperture diameter) | REAL |
| hapermag3err | Error in default point source H mag (2.0 arcsec aperture diameter) | REAL |
| hapermag4 | Point source H aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| hapermag4err | Error in point source H mag (2.8 arcsec aperture diameter) | REAL |
| hapermag6 | Point source H aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| hapermag6err | Error in point source H mag (5.7 arcsec aperture diameter) | REAL |
| hclass | discrete image classification flag in H | SMALLINT |
| hclassstat | N(0,1) stellarness-of-profile statistic in H | REAL |
| hdeblend | placeholder flag indicating parent/child relation in H | INTEGER |
| 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 |
| hhallmag | Total point source H mag | REAL |
| hhallmagerr | Error in total point source H mag | REAL |
| hmk_1ext | Extended source colour H-K_1 (using aperMag3) | REAL |
| hmk_1exterr | Error on extended source colour H-K_1 | REAL |
| hmk_1pnt | Point source colour H-K_1 (using aperMag3) | REAL |
| hmk_1pnterr | Error on point source colour H-K_1 | REAL |
| hmk_2ext | Extended source colour H-K_2 (using aperMag3) | REAL |
| hmk_2exterr | Error on extended source colour H-K_2 | REAL |
| hmk_2pnt | Point source colour H-K_2 (using aperMag3) | REAL |
| hmk_2pnterr | Error on point source colour H-K_2 | REAL |
| hmkext | Extended source colour H-K (using aperMag3) | REAL |
| hmkexterr | Error on extended source colour H-K | REAL |
| hmkpnt | Point source colour H-K (using aperMag3) | REAL |
| hmkpnterr | Error on point source colour H-K | 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 |
| hpsfmag | Point source profile-fitted H mag | REAL |
| hpsfmagerr | Error in point source profile-fitted H mag | REAL |
| hseqnum | the running number of the H detection | INTEGER |
| hsermag2d | Extended source H mag (profile-fitted) | REAL |
| hsermag2derr | Error in extended source H mag (profile-fitted) | REAL |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| htmid | Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates | BIGINT |
| hxi | Offset of H detection from master position (+east/-west) | REAL |
| japermag3 | Default point source J aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| japermag3err | Error in default point source J mag (2.0 arcsec aperture diameter) | REAL |
| japermag4 | Point source J aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| japermag4err | Error in point source J mag (2.8 arcsec aperture diameter) | REAL |
| japermag6 | Point source J aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| japermag6err | Error in point source J mag (5.7 arcsec aperture diameter) | REAL |
| jclass | discrete image classification flag in J | SMALLINT |
| jclassstat | N(0,1) stellarness-of-profile statistic in J | REAL |
| jdeblend | placeholder flag indicating parent/child relation in J | INTEGER |
| 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 |
| jhallmag | Total point source J mag | REAL |
| jhallmagerr | Error in total point source J mag | REAL |
| jmhext | Extended source colour J-H (using aperMag3) | 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 |
| 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 |
| jpsfmag | Point source profile-fitted J mag | REAL |
| jpsfmagerr | Error in point source profile-fitted J mag | REAL |
| jseqnum | the running number of the J detection | INTEGER |
| jsermag2d | Extended source J mag (profile-fitted) | REAL |
| jsermag2derr | Error in extended source J mag (profile-fitted) | REAL |
| jxi | Offset of J detection from master position (+east/-west) | REAL |
| k_1apermag3 | Default point source K_1 aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| k_1apermag3err | Error in default point source K_1 mag (2.0 arcsec aperture diameter) | REAL |
| k_1apermag4 | Point source K_1 aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| k_1apermag4err | Error in point source K_1 mag (2.8 arcsec aperture diameter) | REAL |
| k_1apermag6 | Point source K_1 aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| k_1apermag6err | Error in point source K_1 mag (5.7 arcsec aperture diameter) | REAL |
| k_1class | discrete image classification flag in K_1 | SMALLINT |
| k_1classstat | N(0,1) stellarness-of-profile statistic in K_1 | REAL |
| k_1deblend | placeholder flag indicating parent/child relation in K_1 | INTEGER |
| k_1ell | 1-b/a, where a/b=semi-major/minor axes in K_1 | REAL |
| k_1errbits | processing warning/error bitwise flags in K_1 | INTEGER |
| k_1eta | Offset of K_1 detection from master position (+north/-south) | REAL |
| k_1gausig | RMS of axes of ellipse fit in K_1 | REAL |
| k_1hallmag | Total point source K_1 mag | REAL |
| k_1hallmagerr | Error in total point source K_1 mag | REAL |
| k_1pa | ellipse fit celestial orientation in K_1 | REAL |
| k_1petromag | Extended source K_1 mag (Petrosian) | REAL |
| k_1petromagerr | Error in extended source K_1 mag (Petrosian) | REAL |
| k_1pperrbits | additional WFAU post-processing error bits in K_1 | INTEGER |
| k_1psfmag | Point source profile-fitted K_1 mag | REAL |
| k_1psfmagerr | Error in point source profile-fitted K_1 mag | REAL |
| k_1seqnum | the running number of the K_1 detection | INTEGER |
| k_1sermag2d | Extended source K_1 mag (profile-fitted) | REAL |
| k_1sermag2derr | Error in extended source K_1 mag (profile-fitted) | REAL |
| k_1xi | Offset of K_1 detection from master position (+east/-west) | REAL |
| k_2apermag3 | Default point source K_2 aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| k_2apermag3err | Error in default point source K_2 mag (2.0 arcsec aperture diameter) | REAL |
| k_2apermag4 | Point source K_2 aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| k_2apermag4err | Error in point source K_2 mag (2.8 arcsec aperture diameter) | REAL |
| k_2apermag6 | Point source K_2 aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| k_2apermag6err | Error in point source K_2 mag (5.7 arcsec aperture diameter) | REAL |
| k_2class | discrete image classification flag in K_2 | SMALLINT |
| k_2classstat | N(0,1) stellarness-of-profile statistic in K_2 | REAL |
| k_2deblend | placeholder flag indicating parent/child relation in K_2 | INTEGER |
| k_2ell | 1-b/a, where a/b=semi-major/minor axes in K_2 | REAL |
| k_2errbits | processing warning/error bitwise flags in K_2 | INTEGER |
| k_2eta | Offset of K_2 detection from master position (+north/-south) | REAL |
| k_2gausig | RMS of axes of ellipse fit in K_2 | REAL |
| k_2hallmag | Total point source K_2 mag | REAL |
| k_2hallmagerr | Error in total point source K_2 mag | REAL |
| k_2pa | ellipse fit celestial orientation in K_2 | REAL |
| k_2petromag | Extended source K_2 mag (Petrosian) | REAL |
| k_2petromagerr | Error in extended source K_2 mag (Petrosian) | REAL |
| k_2pperrbits | additional WFAU post-processing error bits in K_2 | INTEGER |
| k_2psfmag | Point source profile-fitted K_2 mag | REAL |
| k_2psfmagerr | Error in point source profile-fitted K_2 mag | REAL |
| k_2seqnum | the running number of the K_2 detection | INTEGER |
| k_2sermag2d | Extended source K_2 mag (profile-fitted) | REAL |
| k_2sermag2derr | Error in extended source K_2 mag (profile-fitted) | REAL |
| k_2xi | Offset of K_2 detection from master position (+east/-west) | REAL |
| kapermag3 | Default point source K aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| kapermag3err | Error in default point source K mag (2.0 arcsec aperture diameter) | REAL |
| kapermag4 | Point source K aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| kapermag4err | Error in point source K mag (2.8 arcsec aperture diameter) | REAL |
| kapermag6 | Point source K aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| kapermag6err | Error in point source K mag (5.7 arcsec aperture diameter) | REAL |
| kclass | discrete image classification flag in K | SMALLINT |
| kclassstat | N(0,1) stellarness-of-profile statistic in K | REAL |
| kdeblend | placeholder flag indicating parent/child relation in K | INTEGER |
| kell | 1-b/a, where a/b=semi-major/minor axes in K | REAL |
| kerrbits | processing warning/error bitwise flags in K | INTEGER |
| keta | Offset of K detection from master position (+north/-south) | REAL |
| kgausig | RMS of axes of ellipse fit in K | REAL |
| khallmag | Total point source K mag | REAL |
| khallmagerr | Error in total point source K mag | REAL |
| kpa | ellipse fit celestial orientation in K | REAL |
| kpetromag | Extended source K mag (Petrosian) | REAL |
| kpetromagerr | Error in extended source K mag (Petrosian) | REAL |
| kpperrbits | additional WFAU post-processing error bits in K | INTEGER |
| kpsfmag | Point source profile-fitted K mag | REAL |
| kpsfmagerr | Error in point source profile-fitted K mag | REAL |
| kseqnum | the running number of the K detection | INTEGER |
| ksermag2d | Extended source K mag (profile-fitted) | REAL |
| ksermag2derr | Error in extended source K mag (profile-fitted) | REAL |
| kxi | Offset of K detection from master position (+east/-west) | REAL |
| l | Galactic longitude | DOUBLE |
| lambda | SDSS system spherical co-ordinate 1 | DOUBLE |
| mergedclass | Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated) | SMALLINT |
| mergedclassstat | Merged N(0,1) stellarness-of-profile statistic | REAL |
| mudec | Proper motion in Dec direction | REAL |
| mura | Proper motion in RA direction | REAL |
| nest4096 | HEALPIX index (Nside 4096, Ring scheme => ~52 arcsec size) | INTEGER |
| nframes | No. of frames used for this proper motion measurement | SMALLINT |
| pgalaxy | Probability that the source is a galaxy | REAL |
| pnoise | Probability that the source is noise | REAL |
| priorsec | Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates). | BIGINT |
| psaturated | Probability that the source is saturated | REAL |
| pstar | Probability that the source is a star | REAL |
| ra | Celestial Right Ascension | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| ring256 | HEALPIX index (Nside 256, Ring scheme => ~14 arcmin size) | INTEGER |
| sigdec | Uncertainty in Dec | REAL |
| sigmudec | Error on proper motion in Dec direction | REAL |
| sigmura | Error on proper motion in RA direction | REAL |
| sigra | Uncertainty in RA | REAL |
| sourceid | UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm | BIGINT |
| yapermag3 | Default point source Y aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| yapermag3err | Error in default point source Y mag (2.0 arcsec aperture diameter) | REAL |
| yapermag4 | Point source Y aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| yapermag4err | Error in point source Y mag (2.8 arcsec aperture diameter) | REAL |
| yapermag6 | Point source Y aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| yapermag6err | Error in point source Y mag (5.7 arcsec aperture diameter) | REAL |
| yclass | discrete image classification flag in Y | SMALLINT |
| yclassstat | N(0,1) stellarness-of-profile statistic in Y | REAL |
| ydeblend | placeholder flag indicating parent/child relation in Y | INTEGER |
| 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 |
| yhallmag | Total point source Y mag | REAL |
| yhallmagerr | Error in total point source Y mag | REAL |
| ymjext | Extended source colour Y-J (using aperMag3) | 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 |
| ypsfmag | Point source profile-fitted Y mag | REAL |
| ypsfmagerr | Error in point source profile-fitted Y mag | REAL |
| yseqnum | the running number of the Y detection | INTEGER |
| ysermag2d | Extended source Y mag (profile-fitted) | REAL |
| ysermag2derr | Error in extended source Y mag (profile-fitted) | REAL |
| yxi | Offset of Y detection from master position (+east/-west) | REAL |
| zapermag3 | Default point source Z aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| zapermag3err | Error in default point source Z mag (2.0 arcsec aperture diameter) | REAL |
| zapermag4 | Point source Z aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| zapermag4err | Error in point source Z mag (2.8 arcsec aperture diameter) | REAL |
| zapermag6 | Point source Z aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| zapermag6err | Error in point source Z mag (5.7 arcsec aperture diameter) | REAL |
| zclass | discrete image classification flag in Z | SMALLINT |
| zclassstat | N(0,1) stellarness-of-profile statistic in Z | REAL |
| zdeblend | placeholder flag indicating parent/child relation in Z | INTEGER |
| zell | 1-b/a, where a/b=semi-major/minor axes in Z | REAL |
| zerrbits | processing warning/error bitwise flags in Z | INTEGER |
| zeta | Offset of Z detection from master position (+north/-south) | REAL |
| zgausig | RMS of axes of ellipse fit in Z | REAL |
| zhallmag | Total point source Z mag | REAL |
| zhallmagerr | Error in total point source Z mag | REAL |
| zmyext | Extended source colour Z-Y (using aperMag3) | REAL |
| zmyexterr | Error on extended source colour Z-Y | REAL |
| zmypnt | Point source colour Z-Y (using aperMag3) | REAL |
| zmypnterr | Error on point source colour Z-Y | REAL |
| zpa | ellipse fit celestial orientation in Z | REAL |
| zpetromag | Extended source Z mag (Petrosian) | REAL |
| zpetromagerr | Error in extended source Z mag (Petrosian) | REAL |
| zpperrbits | additional WFAU post-processing error bits in Z | INTEGER |
| zpsfmag | Point source profile-fitted Z mag | REAL |
| zpsfmagerr | Error in point source profile-fitted Z mag | REAL |
| zseqnum | the running number of the Z detection | INTEGER |
| zsermag2d | Extended source Z mag (profile-fitted) | REAL |
| zsermag2derr | Error in extended source Z mag (profile-fitted) | REAL |
| zxi | Offset of Z detection from master position (+east/-west) | REAL |
