Choose a database in the left panel then select the table you want!
Table: ukidss_dr11plus.udssource
(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 |
| b | Galactic latitude | DOUBLE |
| 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 |
| 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/extended source H mag, no aperture correction applied | REAL |
| hapermag3err | Error in default point/extended source H mag (2.0 arcsec aperture diameter) | REAL |
| hapermag4 | Extended source H mag, no aperture correction applied | REAL |
| hapermag4err | Error in extended source H mag (2.8 arcsec aperture diameter) | REAL |
| hapermag6 | Extended source H mag, no aperture correction applied | REAL |
| hapermag6err | Error in extended source H mag (5.7 arcsec aperture diameter) | REAL |
| hclass | discrete image classification flag in H | SMALLINT |
| hclassstat | S-Extractor classification 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 | SMALLINT |
| heta | Offset of H detection from master position (+north/-south) | REAL |
| hgausig | RMS of axes of ellipse fit in H | REAL |
| hhallmag | Not available in SE output | REAL |
| hhallmagerr | Not available in SE output | 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 | Not available in SE output | REAL |
| hpsfmagerr | Not available in SE output | REAL |
| hseqnum | the running number of the H detection | INTEGER |
| hsermag2d | Not available in SE output | REAL |
| hsermag2derr | Not available in SE output | 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/extended source J mag, no aperture correction applied | REAL |
| japermag3err | Error in default point/extended source J mag (2.0 arcsec aperture diameter) | REAL |
| japermag4 | Extended source J mag, no aperture correction applied | REAL |
| japermag4err | Error in extended source J mag (2.8 arcsec aperture diameter) | REAL |
| japermag6 | Extended source J mag, no aperture correction applied | REAL |
| japermag6err | Error in extended source J mag (5.7 arcsec aperture diameter) | REAL |
| jclass | discrete image classification flag in J | SMALLINT |
| jclassstat | S-Extractor classification 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 | SMALLINT |
| jeta | Offset of J detection from master position (+north/-south) | REAL |
| jgausig | RMS of axes of ellipse fit in J | REAL |
| jhallmag | Not available in SE output | REAL |
| jhallmagerr | Not available in SE output | 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 | Not available in SE output | REAL |
| jpsfmagerr | Not available in SE output | REAL |
| jseqnum | the running number of the J detection | INTEGER |
| jsermag2d | Not available in SE output | REAL |
| jsermag2derr | Not available in SE output | REAL |
| jxi | Offset of J detection from master position (+east/-west) | REAL |
| kapermag3 | Default point/extended source K mag, no aperture correction applied | REAL |
| kapermag3err | Error in default point/extended source K mag (2.0 arcsec aperture diameter) | REAL |
| kapermag4 | Extended source K mag, no aperture correction applied | REAL |
| kapermag4err | Error in extended source K mag (2.8 arcsec aperture diameter) | REAL |
| kapermag6 | Extended source K mag, no aperture correction applied | REAL |
| kapermag6err | Error in extended source K mag (5.7 arcsec aperture diameter) | REAL |
| kclass | discrete image classification flag in K | SMALLINT |
| kclassstat | S-Extractor classification 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 | SMALLINT |
| keta | Offset of K detection from master position (+north/-south) | REAL |
| kgausig | RMS of axes of ellipse fit in K | REAL |
| khallmag | Not available in SE output | REAL |
| khallmagerr | Not available in SE output | 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 | Not available in SE output | REAL |
| kpsfmagerr | Not available in SE output | REAL |
| kseqnum | the running number of the K detection | INTEGER |
| ksermag2d | Not available in SE output | REAL |
| ksermag2derr | Not available in SE output | 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 S-Extractor classification statistic | REAL |
| nest4096 | HEALPIX index (Nside 4096, Ring scheme => ~52 arcsec size) | INTEGER |
| 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). | SMALLINT |
| 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 |
| sourceid | UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm | BIGINT |
