Choose a database in the left panel then select the table you want!
Table: ukidss_dr11plus.gpssource
(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 |
| h2apermag1 | Default point source H2 aperture corrected mag (1.0 arcsec aperture diameter) | REAL |
| h2apermag1err | Error in point source H2 mag (1.0 arcsec aperture diameter) | REAL |
| h2apermag3 | Default point source H2 aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| h2apermag3err | Error in default point source H2 mag (2.0 arcsec aperture diameter) | REAL |
| h2apermag4 | Point source H2 aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| h2apermag4err | Error in point source H2 mag (2.8 arcsec aperture diameter) | REAL |
| h2class | discrete image classification flag in H2 | SMALLINT |
| h2classstat | N(0,1) stellarness-of-profile statistic in H2 | REAL |
| h2deblend | placeholder flag indicating parent/child relation in H2 | INTEGER |
| h2ell | 1-b/a, where a/b=semi-major/minor axes in H2 | REAL |
| h2errbits | processing warning/error bitwise flags in H2 | INTEGER |
| h2eta | Offset of H2 detection from master position (+north/-south) | REAL |
| h2gausig | RMS of axes of ellipse fit in H2 | REAL |
| h2hallmag | Total point source H2 mag | REAL |
| h2hallmagerr | Error in total point source H2 mag | REAL |
| h2pa | ellipse fit celestial orientation in H2 | REAL |
| h2petromag | Extended source H2 mag (Petrosian) | REAL |
| h2petromagerr | Error in extended source H2 mag (Petrosian) | REAL |
| h2pperrbits | additional WFAU post-processing error bits in H2 | INTEGER |
| h2psfmag | Point source profile-fitted H2 mag | REAL |
| h2psfmagerr | Error in point source profile-fitted H2 mag | REAL |
| h2seqnum | the running number of the H2 detection | INTEGER |
| h2sermag2d | Extended source H2 mag (profile-fitted) | REAL |
| h2sermag2derr | Error in extended source H2 mag (profile-fitted) | REAL |
| h2xi | Offset of H2 detection from master position (+east/-west) | REAL |
| hapermag1 | Default point source H aperture corrected mag (1.0 arcsec aperture diameter) | REAL |
| hapermag1err | Error in point source H mag (1.0 arcsec aperture diameter) | REAL |
| 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 |
| 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 |
| 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 |
| japermag1 | Default point source J aperture corrected mag (1.0 arcsec aperture diameter) | REAL |
| japermag1err | Error in point source J mag (1.0 arcsec aperture diameter) | 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 |
| 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_1apermag1 | Default point source K_1 aperture corrected mag (1.0 arcsec aperture diameter) | REAL |
| k_1apermag1err | Error in point source K_1 mag (1.0 arcsec aperture diameter) | 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_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_2apermag1 | Default point source K_2 aperture corrected mag (1.0 arcsec aperture diameter) | REAL |
| k_2apermag1err | Error in point source K_2 mag (1.0 arcsec aperture diameter) | 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_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 |
| kapermag1 | Default point source K aperture corrected mag (1.0 arcsec aperture diameter) | REAL |
| kapermag1err | Error in point source K mag (1.0 arcsec aperture diameter) | 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 |
| 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 |
