Choose a database in the left panel then select the table you want!
Table: ukidss_dr11plus.lassource
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| ah | The galactic extinction correction in the H band for extragalactic objects | REAL |
| aj | The galactic extinction correction in the J band for extragalactic objects | REAL |
| ak | The galactic extinction correction in the K band for extragalactic objects | REAL |
| ay | The galactic extinction correction in the Y band for extragalactic objects | REAL |
| 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 |
| ebv | The galactic dust extinction value measured from the Schlegel, Finkbeiner & Davis (1998) maps. This uses the correction given in Bonifacio, Monai & Beers (2000). This correction reduces the extinction value in regions of high extinction (E(B-V)>0.1) | REAL |
| 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 |
| 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 |
| j_1apermag3 | Default point source J_1 aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| j_1apermag3err | Error in default point source J_1 mag (2.0 arcsec aperture diameter) | REAL |
| j_1apermag4 | Point source J_1 aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| j_1apermag4err | Error in point source J_1 mag (2.8 arcsec aperture diameter) | REAL |
| j_1apermag6 | Point source J_1 aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| j_1apermag6err | Error in point source J_1 mag (5.7 arcsec aperture diameter) | REAL |
| j_1class | discrete image classification flag in J_1 | SMALLINT |
| j_1classstat | N(0,1) stellarness-of-profile statistic in J_1 | REAL |
| j_1deblend | placeholder flag indicating parent/child relation in J_1 | INTEGER |
| j_1ell | 1-b/a, where a/b=semi-major/minor axes in J_1 | REAL |
| j_1errbits | processing warning/error bitwise flags in J_1 | INTEGER |
| j_1eta | Offset of J_1 detection from master position (+north/-south) | REAL |
| j_1gausig | RMS of axes of ellipse fit in J_1 | REAL |
| j_1hallmag | Total point source J_1 mag | REAL |
| j_1hallmagerr | Error in total point source J_1 mag | REAL |
| j_1mhext | Extended source colour J_1-H (using aperMag3) | REAL |
| j_1mhexterr | Error on extended source colour J_1-H | REAL |
| j_1mhpnt | Point source colour J_1-H (using aperMag3) | REAL |
| j_1mhpnterr | Error on point source colour J_1-H | REAL |
| j_1pa | ellipse fit celestial orientation in J_1 | REAL |
| j_1petromag | Extended source J_1 mag (Petrosian) | REAL |
| j_1petromagerr | Error in extended source J_1 mag (Petrosian) | REAL |
| j_1pperrbits | additional WFAU post-processing error bits in J_1 | INTEGER |
| j_1psfmag | Point source profile-fitted J_1 mag | REAL |
| j_1psfmagerr | Error in point source profile-fitted J_1 mag | REAL |
| j_1seqnum | the running number of the J_1 detection | INTEGER |
| j_1sermag2d | Extended source J_1 mag (profile-fitted) | REAL |
| j_1sermag2derr | Error in extended source J_1 mag (profile-fitted) | REAL |
| j_1xi | Offset of J_1 detection from master position (+east/-west) | REAL |
| j_2apermag3 | Default point source J_2 aperture corrected mag (2.0 arcsec aperture diameter) | REAL |
| j_2apermag3err | Error in default point source J_2 mag (2.0 arcsec aperture diameter) | REAL |
| j_2apermag4 | Point source J_2 aperture corrected mag (2.8 arcsec aperture diameter) | REAL |
| j_2apermag4err | Error in point source J_2 mag (2.8 arcsec aperture diameter) | REAL |
| j_2apermag6 | Point source J_2 aperture corrected mag (5.7 arcsec aperture diameter) | REAL |
| j_2apermag6err | Error in point source J_2 mag (5.7 arcsec aperture diameter) | REAL |
| j_2class | discrete image classification flag in J_2 | SMALLINT |
| j_2classstat | N(0,1) stellarness-of-profile statistic in J_2 | REAL |
| j_2deblend | placeholder flag indicating parent/child relation in J_2 | INTEGER |
| j_2ell | 1-b/a, where a/b=semi-major/minor axes in J_2 | REAL |
| j_2errbits | processing warning/error bitwise flags in J_2 | INTEGER |
| j_2eta | Offset of J_2 detection from master position (+north/-south) | REAL |
| j_2gausig | RMS of axes of ellipse fit in J_2 | REAL |
| j_2hallmag | Total point source J_2 mag | REAL |
| j_2hallmagerr | Error in total point source J_2 mag | REAL |
| j_2mhext | Extended source colour J_2-H (using aperMag3) | REAL |
| j_2mhexterr | Error on extended source colour J_2-H | REAL |
| j_2mhpnt | Point source colour J_2-H (using aperMag3) | REAL |
| j_2mhpnterr | Error on point source colour J_2-H | REAL |
| j_2pa | ellipse fit celestial orientation in J_2 | REAL |
| j_2petromag | Extended source J_2 mag (Petrosian) | REAL |
| j_2petromagerr | Error in extended source J_2 mag (Petrosian) | REAL |
| j_2pperrbits | additional WFAU post-processing error bits in J_2 | INTEGER |
| j_2psfmag | Point source profile-fitted J_2 mag | REAL |
| j_2psfmagerr | Error in point source profile-fitted J_2 mag | REAL |
| j_2seqnum | the running number of the J_2 detection | INTEGER |
| j_2sermag2d | Extended source J_2 mag (profile-fitted) | REAL |
| j_2sermag2derr | Error in extended source J_2 mag (profile-fitted) | REAL |
| j_2xi | Offset of J_2 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 |
| 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 |
| ymj_1ext | Extended source colour Y-J_1 (using aperMag3) | REAL |
| ymj_1exterr | Error on extended source colour Y-J_1 | REAL |
| ymj_1pnt | Point source colour Y-J_1 (using aperMag3) | REAL |
| ymj_1pnterr | Error on point source colour Y-J_1 | REAL |
| ymj_2ext | Extended source colour Y-J_2 (using aperMag3) | REAL |
| ymj_2exterr | Error on extended source colour Y-J_2 | REAL |
| ymj_2pnt | Point source colour Y-J_2 (using aperMag3) | REAL |
| ymj_2pnterr | Error on point source colour Y-J_2 | 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 |
