TABLE  vikingMapRemeasAver

Contains averaged remeasurements from VIKING tiles.

This table contains the averaged matched-aperture remeasurements. For
each tile with pawprint remeasurements, the values are averaged
to improve depth. All the magnitude corrections for distortion,
illumination, saturation are applied at the pawprint level and
so the photometry should be more accurate than remeasuring at the tile

Required constraints:
  • Primary key is (apertureID, catalogueID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
apertureIDbigint8 UID of this aperture as assigned by MAP selection, see RequiredMatchedApertureProduct meta_id;meta_main
catalogueIDbigint8 Unique identifier for catalogue-99999999meta_id;meta_main
mapIDint4 UID of the matched-aperture product that this remeasurement is part of, see RequiredMatchedApertureProduct  
multiframeIDbigint8 the UID of the relevant multiframe obs.field
versionNumsmallint2 Version number of the catalogue  
extNumtinyint1 the extension number of this frame meta.number
cuEventIDint4 UID of curation event giving rise to this record meta.bib
filterIDtinyint1 UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank) meta.code;instr.filter
sumWeightreal4 Normalised (conf=100 in a pawprint=1) sum of all the weights, giving extimate of depth  
weighto1real4 Normalised (conf=100 in a pawprint=1) weight of offset 1-9.999995e8 
weighto2real4 Normalised (conf=100 in a pawprint=1) weight of offset 2-9.999995e8 
weighto3real4 Normalised (conf=100 in a pawprint=1) weight of offset 3-9.999995e8 
weighto4real4 Normalised (conf=100 in a pawprint=1) weight of offset 4-9.999995e8 
weighto5real4 Normalised (conf=100 in a pawprint=1) weight of offset 5-9.999995e8 
weighto6real4 Normalised (conf=100 in a pawprint=1) weight of offset 6-9.999995e8 
isoMagreal4magAveraged calibrated isophotal magnitude phot.mag
isoLupreal4lupAveraged calibrated isophotal luptitude phot.mag
isoJkyreal4janskyAveraged calibrated isophotal flux phot.mag
gauSigreal4pixelsAveraged RMS of axes of ellipse fit src.morph.param
ellreal4 Averaged 1-b/a, where a/b=semi-major/minor axes (SE: THETA_IMAGE) src.ellipticity
pa tooltipreal4degreesAveraged ellipse fit orientation to x axis pos.posAng
aperMagNoAperCorr1real4magDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1, calculated from aperJkyNoAperCorr1 phot.mag
aperMag1real4magDerived averaged Calibrated and corrected aperture magnitude 1 phot.mag
aperMag1errreal4magDerived Error in averaged calibrated aperture magnitude 1 stat.error
aperLupNoAperCorr1real4lupDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture luptitude 1 phot.mag
aperLup1real4lupDerived averaged Calibrated and corrected aperture luptitude 1 phot.mag
aperLup1errreal4lupDerived Error in averaged calibrated aperture luptitude 1 stat.error
aperJkyNoAperCorr1real4janskyAveraged Calibrated and standard corrected (but no aperture correction applied) aperture flux 1 phot.mag
aperJky1real4janskyAveraged Calibrated and corrected aperture flux 1 phot.mag
aperJky1errreal4janskyError in averaged calibrated aperture flux 1 stat.error
aperMagNoAperCorr2real4magDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 2, calculated from aperJkyNoAperCorr2 phot.mag
aperMag2real4magDerived averaged Calibrated and corrected aperture magnitude 2 phot.mag
aperMag2errreal4magDerived Error in averaged calibrated aperture magnitude 2 stat.error
aperLupNoAperCorr2real4lupDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture luptitude 2 phot.mag
aperLup2real4lupDerived averaged Calibrated and corrected aperture luptitude 2 phot.mag
aperLup2errreal4lupDerived Error in averaged calibrated aperture luptitude 2 stat.error
aperJkyNoAperCorr2real4janskyAveraged Calibrated and standard corrected (but no aperture correction applied) aperture flux 2 phot.mag
aperJky2real4janskyAveraged Calibrated and corrected aperture flux 2 phot.mag
aperJky2errreal4janskyError in averaged calibrated aperture flux 2 stat.error
aperMagNoAperCorr3real4magDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 3, calculated from aperJkyNoAperCorr3 phot.mag
aperMag3real4magDerived averaged Calibrated and corrected aperture magnitude 3 phot.mag
aperMag3errreal4magDerived Error in averaged calibrated aperture magnitude 3 stat.error
aperLupNoAperCorr3real4lupDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture luptitude 3 phot.mag
aperLup3real4lupDerived averaged Calibrated and corrected aperture luptitude 3 phot.mag
aperLup3errreal4lupDerived Error in averaged calibrated aperture luptitude 3 stat.error
aperJkyNoAperCorr3real4janskyAveraged Calibrated and standard corrected (but no aperture correction applied) aperture flux 3 phot.mag
aperJky3real4janskyAveraged Calibrated and corrected aperture flux 3 phot.mag
aperJky3errreal4janskyError in averaged calibrated aperture flux 3 stat.error
aperMagNoAperCorr4real4magDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 4, calculated from aperJkyNoAperCorr4 phot.mag
aperMag4real4magDerived averaged Calibrated and corrected aperture magnitude 4 phot.mag
aperMag4errreal4magDerived Error in averaged calibrated aperture magnitude 4 stat.error
aperLupNoAperCorr4real4lupDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture luptitude 4 phot.mag
aperLup4real4lupDerived averaged Calibrated and corrected aperture luptitude 4 phot.mag
aperLup4errreal4lupDerived Error in averaged calibrated aperture luptitude 4 stat.error
aperJkyNoAperCorr4real4janskyAveraged Calibrated and standard corrected (but no aperture correction applied) aperture flux 4 phot.mag
aperJky4real4janskyAveraged Calibrated and corrected aperture flux 4 phot.mag
aperJky4errreal4janskyError in averaged calibrated aperture flux 4 stat.error
aperMagNoAperCorr5real4magDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 5, calculated from aperJkyNoAperCorr5 phot.mag
aperMag5real4magDerived averaged Calibrated and corrected aperture magnitude 5 phot.mag
aperMag5errreal4magDerived Error in averaged calibrated aperture magnitude 5 stat.error
aperLupNoAperCorr5real4lupDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture luptitude 5 phot.mag
aperLup5real4lupDerived averaged Calibrated and corrected aperture luptitude 5 phot.mag
aperLup5errreal4lupDerived Error in averaged calibrated aperture luptitude 5 stat.error
aperJkyNoAperCorr5real4janskyAveraged Calibrated and standard corrected (but no aperture correction applied) aperture flux 5 phot.mag
aperJky5real4janskyAveraged Calibrated and corrected aperture flux 5 phot.mag
aperJky5errreal4janskyError in averaged calibrated aperture flux 5 stat.error
aperMagNoAperCorr6real4magDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 6, calculated from aperJkyNoAperCorr6 phot.mag
aperMag6real4magDerived averaged Calibrated and corrected aperture magnitude 6 phot.mag
aperMag6errreal4magDerived Error in averaged calibrated aperture magnitude 6 stat.error
aperLupNoAperCorr6real4lupDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture luptitude 6 phot.mag
aperLup6real4lupDerived averaged Calibrated and corrected aperture luptitude 6 phot.mag
aperLup6errreal4lupDerived Error in averaged calibrated aperture luptitude 6 stat.error
aperJkyNoAperCorr6real4janskyAveraged Calibrated and standard corrected (but no aperture correction applied) aperture flux 6 phot.mag
aperJky6real4janskyAveraged Calibrated and corrected aperture flux 6 phot.mag
aperJky6errreal4janskyError in averaged calibrated aperture flux 6 stat.error
aperMagNoAperCorr7real4magDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 7, calculated from aperJkyNoAperCorr7 phot.mag
aperMag7real4magDerived averaged Calibrated and corrected aperture magnitude 7 phot.mag
aperMag7errreal4magDerived Error in averaged calibrated aperture magnitude 7 stat.error
aperLupNoAperCorr7real4lupDerived averaged Calibrated and standard corrected (but no aperture correction applied) aperture luptitude 7 phot.mag
aperLup7real4lupDerived averaged Calibrated and corrected aperture luptitude 7 phot.mag
aperLup7errreal4lupDerived Error in averaged calibrated aperture luptitude 7 stat.error
aperJkyNoAperCorr7real4janskyAveraged Calibrated and standard corrected (but no aperture correction applied) aperture flux 7 phot.mag
aperJky7real4janskyAveraged Calibrated and corrected aperture flux 7 phot.mag
aperJky7errreal4janskyError in averaged calibrated aperture flux 7 stat.error
aperMag8real4magDerived averaged Calibrated and corrected aperture magnitude 8 phot.mag
aperMag8errreal4magDerived Error in averaged calibrated aperture magnitude 8 stat.error
aperLup8real4lupDerived averaged Calibrated and corrected aperture luptitude 8 phot.mag
aperLup8errreal4lupDerived Error in averaged calibrated aperture luptitude 8 stat.error
aperJky8real4janskyAveraged Calibrated and corrected aperture flux 8 phot.mag
aperJky8errreal4janskyError in averaged calibrated aperture flux 8 stat.error
aperMag9real4magDerived averaged Calibrated and corrected aperture magnitude 9 phot.mag
aperMag9errreal4magDerived Error in averaged calibrated aperture magnitude 9 stat.error
aperLup9real4lupDerived averaged Calibrated and corrected aperture luptitude 9 phot.mag
aperLup9errreal4lupDerived Error in averaged calibrated aperture luptitude 9 stat.error
aperJky9real4janskyAveraged Calibrated and corrected aperture flux 9 phot.mag
aperJky9errreal4janskyError in averaged calibrated aperture flux 9 stat.error
aperMag10real4magDerived averaged Calibrated and corrected aperture magnitude 10 phot.mag
aperMag10errreal4magDerived Error in averaged calibrated aperture magnitude 10 stat.error
aperLup10real4lupDerived averaged Calibrated and corrected aperture luptitude 10 phot.mag
aperLup10errreal4lupDerived Error in averaged calibrated aperture luptitude 10 stat.error
aperJky10real4janskyAveraged Calibrated and corrected aperture flux 10 phot.mag
aperJky10errreal4janskyError in averaged calibrated aperture flux 10 stat.error
aperMag11real4magDerived averaged Calibrated and corrected aperture magnitude 11 phot.mag
aperMag11errreal4magDerived Error in averaged calibrated aperture magnitude 11 stat.error
aperLup11real4lupDerived averaged Calibrated and corrected aperture luptitude 11 phot.mag
aperLup11errreal4lupDerived Error in averaged calibrated aperture luptitude 11 stat.error
aperJky11real4janskyAveraged Calibrated and corrected aperture flux 11 phot.mag
aperJky11errreal4janskyError in averaged calibrated aperture flux 11 stat.error
aperMag12real4magDerived averaged Calibrated and corrected aperture magnitude 12 phot.mag
aperMag12errreal4magDerived Error in averaged calibrated aperture magnitude 12 stat.error
aperLup12real4lupDerived averaged Calibrated and corrected aperture luptitude 12 phot.mag
aperLup12errreal4lupDerived Error in averaged calibrated aperture luptitude 12 stat.error
aperJky12real4janskyAveraged Calibrated and corrected aperture flux 12 phot.mag
aperJky12errreal4janskyError in averaged calibrated aperture flux 12 stat.error
aperMag13real4magDerived averaged Calibrated and corrected aperture magnitude 13 phot.mag
aperMag13errreal4magDerived Error in averaged calibrated aperture magnitude 13 stat.error
aperLup13real4lupDerived averaged Calibrated and corrected aperture luptitude 13 phot.mag
aperLup13errreal4lupDerived Error in averaged calibrated aperture luptitude 13 stat.error
aperJky13real4janskyAveraged Calibrated and corrected aperture flux 13 phot.mag
aperJky13errreal4janskyError in averaged calibrated aperture flux 13 stat.error
averageConfreal4 Weighted mean average confidence level in the default 2 arcsec diameter aperture (aper3) (SE: default)-0.9999995e9stat.likelihood
mjdfloat8dayAveraged Modified Julian Day of each detection time.epoch
ra link to glossaryfloat8DegreesAveraged Celestial Right Ascension pos.eq.ra;meta.main
dec link to glossaryfloat8DegreesAveraged Celestial Declination pos.eq.dec;meta.main
raErrfloat8pixelsError in averaged Celestial Right Ascension  
decErrfloat8pixelsError in averaged Celestial Declination  
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
lfloat8DegreesGalactic longitude pos.galactic.lon
bfloat8DegreesGalactic latitude pos.galactic.lat
lambdafloat8DegreesSDSS system spherical co-ordinate 1 pos
etafloat8DegreesSDSS system spherical co-ordinate 2 pos
class tooltip smallint2 Merged Flag indicating most probable morphological classification src.class
classStat link to glossaryreal4 Averaged N(0,1) stellarness-of-profile statistic (SE: classification statistic CLASS_STAR; 0 - galaxy, 1 - star) stat
ppErrBits link to glossaryint4 additional WFAU post-processing error bits based on combining average pawprint and tile flagging0meta.code
deprecated link to glossarytinyint1 Code for a current (=0) or deprecated (!=0) detection0meta.code
Total length603