TABLE  denisDR3Source

Contains the parameters provided in the third incremental release of the DENIS project.

This table contains brief descriptions of the parameters provided for
each source in the catalogue of 355,220,325 point sources detected by the
DENIS survey in 3662 strips (covering each 30 degrees in declination
and 12 arcmin in right ascension).

Required constraints:
  • Primary key is (seqNum)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
seqNumint4 Sequential number (unique object ID)  
Designationvarchar16 DENIS name, identifier  
Imageint4 DENIS image number; the image number is incremented at each image taken during the survey. In case a source results from the merging of two consecutive overlapping images (N and N+1) in the same strip (Flag_mult set to 1), the image number corresponds to the first image N.  
Stripint4 DENIS strip number  
RAdegreal4degRight ascension (J2000)  
DEdegreal4degDeclination (J2000)  
cxfloat8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.x
cyfloat8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.y
czfloat8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.z
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates pos.eq
Fitmag_Ifloat8magMagnitude in I band from PSF fit  
e_Fitmag_Ifloat8magMagnitude error in I band from PSF fit  
Fitmag_Jfloat8magMagnitude in J band from PSF fit  
e_Fitmag_Jfloat8magMagnitude error in J band from PSF fit  
Fitmag_Kfloat8magMagnitude in K band from PSF fit  
e_Fitmag_Kfloat8magMagnitude error in K band from PSF fit  
Ap55mag_Ifloat8magMagnitude in I band from 5.5" aperture  
e_Ap55mag_Ifloat8magError in I band mag from 5.5" aperture  
Ap55mag_Jfloat8magMagnitude in J band from 5.5" aperture  
e_Ap55mag_Jfloat8magError in J band mag from 5.5" aperture  
Ap55mag_Kfloat8magMagnitude in K band from 5.5" aperture  
e_Ap55mag_Kfloat8magError in K band mag from 5.5" aperture  
Ap45mag_Ifloat8magMagnitude in I band from 4.5" aperture  
e_Ap45mag_Ifloat8magError in I band mag from 4.5" aperture  
Ap45mag_Jfloat8magMagnitude in J band from 4.5" aperture  
e_Ap45mag_Jfloat8magError in J band mag from 4.5" aperture  
Ap45mag_Kfloat8magMagnitude in K band from 4.5" aperture  
e_Ap45mag_Kfloat8magError in K band mag from 4.5" aperture  
Ap35mag_Ifloat8magMagnitude in I band from 3.5" aperture  
e_Ap35mag_Ifloat8magError in I band mag from 3.5" aperture  
Ap35mag_Jfloat8magMagnitude in J band from 3.5" aperture  
e_Ap35mag_Jfloat8magError in J band mag from 3.5" aperture  
Ap35mag_Kfloat8magMagnitude in K band from 3.5" aperture  
e_Ap35mag_Kfloat8magError in K band mag from 3.5" aperture  
Apc35mag_Ifloat8magI band Magnitude in 3.5" corr. aperture  
e_Apc35mag_Ifloat8magI band mag error in 3.5" corr. aperture  
Apc35mag_Jfloat8magJ band Magnitude in 3.5" corr. aperture  
e_Apc35mag_Jfloat8magJ band mag error in 3.5" corr. aperture  
Apc35mag_Kfloat8magK band Magnitude in 3.5" corr. aperture  
e_Apc35mag_Kfloat8magK band mag error in 3.5" corr. aperture  
Apc25mag_Ifloat8magI band Magnitude in 2.5" corr. aperture  
e_Apc25mag_Ifloat8magI band mag error in 2.5" corr. aperture  
Apc25mag_Jfloat8magJ band Magnitude in 2.5" corr. aperture  
e_Apc25mag_Jfloat8magJ band mag error in 2.5" corr. aperture  
Apc25mag_Kfloat8magK band Magnitude in 2.5" corr. aperture  
e_Apc25mag_Kfloat8magK band mag error in 2.5" corr. aperture  
Apc15mag_Ifloat8magI band Magnitude in 1.5" corr. aperture  
e_Apc15mag_Ifloat8magI band mag error in 1.5" corr. aperture  
Apc15mag_Jfloat8magJ band Magnitude in 1.5" corr. aperture  
e_Apc15mag_Jfloat8magJ band mag error in 1.5" corr. aperture  
Apc15mag_Kfloat8magK band Magnitude in 1.5" corr. aperture  
e_Apc15mag_Kfloat8magK band mag error in 1.5" corr. aperture  
Rmagfloat8magR magnitude of USNOA2.0 nearest match  
Bmagfloat8magB magnitude of USNOA2.0 nearest match  
Qual_Ismallint2 Quality flag for I band [0,100]  
Qual_Jsmallint2 Quality flag for J band [0,100]  
Qual_Ksmallint2 Quality flag for K band [0,100]  
Correl_Ismallint2 Correlation to PSF for I band [0,100]  
Correl_Jsmallint2 Correlation to PSF for J band [0,100]  
Correl_Ksmallint2 Correlation to PSF for K band [0,100]  
Mcor_Ifloat8 Mean correlation to PSF in I band [0,1]  
Mcor_Jfloat8 Mean correlation to PSF in J band [0,1]  
Mcor_Kfloat8 Mean correlation to PSF in K band [0,1]  
Pix_x_Ifloat8pixPixel x position in I band  
Pix_y_Ifloat8pixPixel y position in I band  
Pix_x_Jfloat8pixPixel x position in J band  
Pix_y_Jfloat8pixPixel y position in J band  
Pix_x_Kfloat8pixPixel x position in K band  
Pix_y_Kfloat8pixPixel y position in K band  
RAusnoreal4degRight Ascension of USNOA2.0 nearest match  
DEusnoreal4degDeclination of USNOA2.0 nearest match  
Epochfloat8yrEpoch of USNOA2.0 nearest match  
Distfloat8masDistance to USNOA2.0 nearest match  
Julianreal4JDJulian day for DENIS observation  
Flag_Ivarchar5 Image and source flag in I band This flag is the concatenation of image and source flags, in hexadecimal format. For the image flag, the first two digits contain: Bit 0 - clouds during observation; Bit 1 - electronic Read-Out problem; Bit 2 - internal temperature problem; Bit 3 - very bright star; Bit 4 - bright star; Bit 5 - stray light; Bit 6 - unknown problem. For the source flag, the last two digits contain: Bit 0 - source might be a dust on mirror; Bit 1 - source is a ghost detection of a bright star; Bit 2 - source is saturated; Bit 3 - source is multiple detect.  
Flag_Jvarchar5 Image and source flag in J band This flag is the concatenation of image and source flags, in hexadecimal format. For the image flag, the first two digits contain: Bit 0 - clouds during observation; Bit 1 - electronic Read-Out problem; Bit 2 - internal temperature problem; Bit 3 - very bright star; Bit 4 - bright star; Bit 5 - stray light; Bit 6 - unknown problem. For the source flag, the last two digits contain: Bit 0 - source might be a dust on mirror; Bit 1 - source is a ghost detection of a bright star; Bit 2 - source is saturated; Bit 3 - source is multiple detect.  
Flag_Kvarchar5 Image and source flag in K band This flag is the concatenation of image and source flags, in hexadecimal format. For the image flag, the first two digits contain: Bit 0 - clouds during observation; Bit 1 - electronic Read-Out problem; Bit 2 - internal temperature problem; Bit 3 - very bright star; Bit 4 - bright star; Bit 5 - stray light; Bit 6 - unknown problem. For the source flag, the last two digits contain: Bit 0 - source might be a dust on mirror; Bit 1 - source is a ghost detection of a bright star; Bit 2 - source is saturated; Bit 3 - source is multiple detect.  
Flag_multtinyint1 Multiplicity flag; if set to 1, this flag indicates that the source was detected in two consecutive images, and that the 2 measurements have been combined.  
Total length548