VIDEO DR3 ivo://wfau.roe.ac.uk/videoDR3-dsa WFAU, Institute for Astronomy, University of Edinburgh WFAU, Institute for Astronomy, University of Edinburgh http://wfaudata.roe.ac.uk/wfau.gif 2014-03-05 Data Release 3 Mark Holliman msh@roe.ac.uk Observational cosmology, galaxy, cluster, evolution, infrared The VIDEO survey is a 30 sq. degree, Z,Y,J,H,K survey that is specifically designed to enable exploration of the main issues in observational cosmology. It allows galaxy and cluster/structure evolution to be traced as a function of both epoch and environment from the present day out to z=4 and AGN/QSO evolution up to and into the epoch of reionization at z > 6. The multi-band nature of the survey ensures many key science drivers can be tackled using the survey alone, without recourse to data from other wavebands. http://arxiv.org/abs/1206.4263 Survey Research service-for ivo://wfau.roe.ac.uk/videoDR3-dsa/ceaApplication videoSource: cone search the VISTA Deep Extragalactic Observations source table http://wfaudata.roe.ac.uk/videoDR3-dsa/DirectCone?DSACAT=VIDEO_DR3&DSATAB=videoSource& 1.500000 2000000 false 37.0 -5.47 0.001 videoDetection: cone search the VISTA Deep Extragalactic Observations detection table http://wfaudata.roe.ac.uk/videoDR3-dsa/DirectCone?DSACAT=VIDEO_DR3&DSATAB=videoDetection& 1.500000 2000000 false 37.0 -5.47 0.001 Access to two applications: general ADQL query, and asynchronous cone-search where relevant/enabled. http://wfaudata.roe.ac.uk/videoDR3-dsa/services/CommonExecutionConnectorService ivo://wfau.roe.ac.uk/videoDR3-dsa/ceaApplication http://wfaudata.roe.ac.uk/videoDR3-dsa/VOSI/capabilities GET application/xml http://wfaudata.roe.ac.uk/videoDR3-dsa/VOSI/capabilities GET application/xml http://wfaudata.roe.ac.uk/videoDR3-dsa/VOSI/availability GET application/xml http://wfaudata.roe.ac.uk/videoDR3-dsa/VOSI/availability GET application/xml http://wfaudata.roe.ac.uk/videoDR3-dsa/VOSI/tables GET application/xml http://wfaudata.roe.ac.uk/videoDR3-dsa/VOSI/applications GET application/xml http://wfaudata.roe.ac.uk/videoDR3-dsa/delegations GET application/xml videoSourceContains merged sources from detections in videoDetection sourceID UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm ID_MAIN long cuEventID UID of curation event giving rise to this record int frameSetID UID of the set of frames that this merged source comes from long ra Celestial Right Ascension deg POS_EQ_RA_MAIN double dec Celestial Declination deg POS_EQ_DEC_MAIN double cx unit vector of spherical co-ordinates double cy unit vector of spherical co-ordinates double cz unit vector of spherical co-ordinates double htmID Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates long l Galactic longitude Degrees double b Galactic latitude Degrees double lambda SDSS system spherical co-ordinate 1 Degrees double eta SDSS system spherical co-ordinate 2 Degrees double priOrSec Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates). long zmyPnt Point source colour Z-Y (using aperMag3) mag float zmyPntErr Error on point source colour Z-Y mag float ymjPnt Point source colour Y-J (using aperMag3) mag float ymjPntErr Error on point source colour Y-J mag float jmhPnt Point source colour J-H (using aperMag3) mag float jmhPntErr Error on point source colour J-H mag float hmksPnt Point source colour H-Ks (using aperMag3) mag float hmksPntErr Error on point source colour H-Ks mag float zmyExt Extended source colour Z-Y (using aperMagNoAperCorr3) mag float zmyExtErr Error on extended source colour Z-Y mag float ymjExt Extended source colour Y-J (using aperMagNoAperCorr3) mag float ymjExtErr Error on extended source colour Y-J mag float jmhExt Extended source colour J-H (using aperMagNoAperCorr3) mag float jmhExtErr Error on extended source colour J-H mag float hmksExt Extended source colour H-Ks (using aperMagNoAperCorr3) mag float hmksExtErr Error on extended source colour H-Ks mag float mergedClassStat Merged S-Extractor classification statistic float mergedClass Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated) int pStar Probability that the source is a star float pGalaxy Probability that the source is a galaxy float pNoise Probability that the source is noise float pSaturated Probability that the source is saturated float eBV The galactic dust extinction value measured from the Schlegel, Finkbeiner &#38; Davis (1998) maps. This uses the correction given in Bonifacio, Monai &#38; Beers (2000). This correction reduces the extinction value in regions of high extinction (E(B-V)&gt;0.1) float aZ The galactic extinction correction in the Z band for extragalactic objects mag float aY The galactic extinction correction in the Y band for extragalactic objects mag float aJ The galactic extinction correction in the J band for extragalactic objects mag float aH The galactic extinction correction in the H band for extragalactic objects mag float aKs The galactic extinction correction in the Ks band for extragalactic objects mag float zPetroMag Extended source Z mag (Petrosian) mag float zPetroMagErr Error in extended source Z mag (Petrosian) mag float zAperMag3 Default point source Z aperture corrected mag (2.0 arcsec aperture diameter) mag float zAperMag3Err Error in default point/extended source Z mag (2.0 arcsec aperture diameter) mag float zAperMag4 Point source Z aperture corrected mag (2.8 arcsec aperture diameter) mag float zAperMag4Err Error in point/extended source Z mag (2.8 arcsec aperture diameter) mag float zAperMag6 Point source Z aperture corrected mag (5.7 arcsec aperture diameter) mag float zAperMag6Err Error in point/extended source Z mag (5.7 arcsec aperture diameter) mag float zAperMagNoAperCorr3 Default extended source Z aperture mag (2.0 arcsec aperture diameter) mag float zAperMagNoAperCorr4 Extended source Z aperture mag (2.8 arcsec aperture diameter) mag float zAperMagNoAperCorr6 Extended source Z aperture mag (5.7 arcsec aperture diameter) mag float zHlCorSMjRadAs Seeing corrected half-light, semi-major axis in Z band arcsec float zGausig RMS of axes of ellipse fit in Z pixels float zEll 1-b/a, where a/b=semi-major/minor axes in Z float zPA ellipse fit celestial orientation in Z Degrees float zErrBits processing warning/error bitwise flags in Z int zClass discrete image classification flag in Z int zClassStat S-Extractor classification statistic in Z float zppErrBits additional WFAU post-processing error bits in Z int zSeqNum the running number of the Z detection int zXi Offset of Z detection from master position (+east/-west) arcsec float zEta Offset of Z detection from master position (+north/-south) arcsec float yPetroMag Extended source Y mag (Petrosian) mag float yPetroMagErr Error in extended source Y mag (Petrosian) mag float yAperMag3 Default point source Y aperture corrected mag (2.0 arcsec aperture diameter) mag float yAperMag3Err Error in default point/extended source Y mag (2.0 arcsec aperture diameter) mag float yAperMag4 Point source Y aperture corrected mag (2.8 arcsec aperture diameter) mag float yAperMag4Err Error in point/extended source Y mag (2.8 arcsec aperture diameter) mag float yAperMag6 Point source Y aperture corrected mag (5.7 arcsec aperture diameter) mag float yAperMag6Err Error in point/extended source Y mag (5.7 arcsec aperture diameter) mag float yAperMagNoAperCorr3 Default extended source Y aperture mag (2.0 arcsec aperture diameter) mag float yAperMagNoAperCorr4 Extended source Y aperture mag (2.8 arcsec aperture diameter) mag float yAperMagNoAperCorr6 Extended source Y aperture mag (5.7 arcsec aperture diameter) mag float yHlCorSMjRadAs Seeing corrected half-light, semi-major axis in Y band arcsec float yGausig RMS of axes of ellipse fit in Y pixels float yEll 1-b/a, where a/b=semi-major/minor axes in Y float yPA ellipse fit celestial orientation in Y Degrees float yErrBits processing warning/error bitwise flags in Y int yClass discrete image classification flag in Y int yClassStat S-Extractor classification statistic in Y float yppErrBits additional WFAU post-processing error bits in Y int ySeqNum the running number of the Y detection int yXi Offset of Y detection from master position (+east/-west) arcsec float yEta Offset of Y detection from master position (+north/-south) arcsec float jPetroMag Extended source J mag (Petrosian) mag float jPetroMagErr Error in extended source J mag (Petrosian) mag float jAperMag3 Default point source J aperture corrected mag (2.0 arcsec aperture diameter) mag float jAperMag3Err Error in default point/extended source J mag (2.0 arcsec aperture diameter) mag float jAperMag4 Point source J aperture corrected mag (2.8 arcsec aperture diameter) mag float jAperMag4Err Error in point/extended source J mag (2.8 arcsec aperture diameter) mag float jAperMag6 Point source J aperture corrected mag (5.7 arcsec aperture diameter) mag float jAperMag6Err Error in point/extended source J mag (5.7 arcsec aperture diameter) mag float jAperMagNoAperCorr3 Default extended source J aperture mag (2.0 arcsec aperture diameter) mag float jAperMagNoAperCorr4 Extended source J aperture mag (2.8 arcsec aperture diameter) mag float jAperMagNoAperCorr6 Extended source J aperture mag (5.7 arcsec aperture diameter) mag float jHlCorSMjRadAs Seeing corrected half-light, semi-major axis in J band arcsec float jGausig RMS of axes of ellipse fit in J pixels float jEll 1-b/a, where a/b=semi-major/minor axes in J float jPA ellipse fit celestial orientation in J Degrees float jErrBits processing warning/error bitwise flags in J int jClass discrete image classification flag in J int jClassStat S-Extractor classification statistic in J float jppErrBits additional WFAU post-processing error bits in J int jSeqNum the running number of the J detection int jXi Offset of J detection from master position (+east/-west) arcsec float jEta Offset of J detection from master position (+north/-south) arcsec float hPetroMag Extended source H mag (Petrosian) mag float hPetroMagErr Error in extended source H mag (Petrosian) mag float hAperMag3 Default point source H aperture corrected mag (2.0 arcsec aperture diameter) mag float hAperMag3Err Error in default point/extended source H mag (2.0 arcsec aperture diameter) mag float hAperMag4 Point source H aperture corrected mag (2.8 arcsec aperture diameter) mag float hAperMag4Err Error in point/extended source H mag (2.8 arcsec aperture diameter) mag float hAperMag6 Point source H aperture corrected mag (5.7 arcsec aperture diameter) mag float hAperMag6Err Error in point/extended source H mag (5.7 arcsec aperture diameter) mag float hAperMagNoAperCorr3 Default extended source H aperture mag (2.0 arcsec aperture diameter) mag float hAperMagNoAperCorr4 Extended source H aperture mag (2.8 arcsec aperture diameter) mag float hAperMagNoAperCorr6 Extended source H aperture mag (5.7 arcsec aperture diameter) mag float hHlCorSMjRadAs Seeing corrected half-light, semi-major axis in H band arcsec float hGausig RMS of axes of ellipse fit in H pixels float hEll 1-b/a, where a/b=semi-major/minor axes in H float hPA ellipse fit celestial orientation in H Degrees float hErrBits processing warning/error bitwise flags in H int hClass discrete image classification flag in H int hClassStat S-Extractor classification statistic in H float hppErrBits additional WFAU post-processing error bits in H int hSeqNum the running number of the H detection int hXi Offset of H detection from master position (+east/-west) arcsec float hEta Offset of H detection from master position (+north/-south) arcsec float ksPetroMag Extended source Ks mag (Petrosian) mag float ksPetroMagErr Error in extended source Ks mag (Petrosian) mag float ksAperMag3 Default point source Ks aperture corrected mag (2.0 arcsec aperture diameter) mag float ksAperMag3Err Error in default point/extended source Ks mag (2.0 arcsec aperture diameter) mag float ksAperMag4 Point source Ks aperture corrected mag (2.8 arcsec aperture diameter) mag float ksAperMag4Err Error in point/extended source Ks mag (2.8 arcsec aperture diameter) mag float ksAperMag6 Point source Ks aperture corrected mag (5.7 arcsec aperture diameter) mag float ksAperMag6Err Error in point/extended source Ks mag (5.7 arcsec aperture diameter) mag float ksAperMagNoAperCorr3 Default extended source Ks aperture mag (2.0 arcsec aperture diameter) mag float ksAperMagNoAperCorr4 Extended source Ks aperture mag (2.8 arcsec aperture diameter) mag float ksAperMagNoAperCorr6 Extended source Ks aperture mag (5.7 arcsec aperture diameter) mag float ksHlCorSMjRadAs Seeing corrected half-light, semi-major axis in Ks band arcsec float ksGausig RMS of axes of ellipse fit in Ks pixels float ksEll 1-b/a, where a/b=semi-major/minor axes in Ks float ksPA ellipse fit celestial orientation in Ks Degrees float ksErrBits processing warning/error bitwise flags in Ks int ksClass discrete image classification flag in Ks int ksClassStat S-Extractor classification statistic in Ks float ksppErrBits additional WFAU post-processing error bits in Ks int ksSeqNum the running number of the Ks detection int ksXi Offset of Ks detection from master position (+east/-west) arcsec float ksEta Offset of Ks detection from master position (+north/-south) arcsec float videoDetectionContains the individual VIDEO source detections for each frame multiframeID the UID of the relevant multiframe long extNum the extension number of this frame int cuEventID UID of curation event giving rise to this record int seqNum int filterID UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks,8=blank) int isoFlux ADU float isoMag Calibrated isophotal magnitude mag float x pixels float xErr pixels float y pixels float yErr pixels float gauSig pixels float ell float pa deg float aProf1 pixel2 float aProf2 pixel2 int aProf3 pixel2 int aProf4 pixel2 int aProf5 pixel2 int aProf6 pixel2 int aProf7 pixel2 int aProf8 pixel2 int pHeight ADU float pHeightErr ADU float aperFlux1 ADU float aperFlux1err ADU float aperMagNoAperCorr1 Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1 mag float aperMag1 Calibrated and corrected aperture magnitude 1 mag float aperMag1err Error in calibrated aperture magnitude 1 mag float aperFlux2 ADU float aperFlux2err ADU float aperMagNoAperCorr2 Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 2 mag float aperMag2 Calibrated and corrected aperture magnitude 2 mag float aperMag2err Error in calibrated aperture magnitude 2 mag float aperFlux3 ADU float aperFlux3err ADU float aperMagNoAperCorr3 Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 3 mag float aperMag3 Calibrated and corrected aperture magnitude 3 mag float aperMag3err Error in calibrated aperture magnitude 3 mag float aperFlux4 ADU float aperFlux4err ADU float aperMagNoAperCorr4 Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 4 mag float aperMag4 Calibrated and corrected aperture magnitude 4 mag float aperMag4err Error in calibrated aperture magnitude 4 mag float aperFlux5 ADU float aperFlux5err ADU float aperMagNoAperCorr5 Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 5 mag float aperMag5 Calibrated and corrected aperture magnitude 5 mag float aperMag5err Error in calibrated aperture magnitude 5 mag float aperFlux6 ADU float aperFlux6err ADU float aperMagNoAperCorr6 Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 6 mag float aperMag6 Calibrated and corrected aperture magnitude 6 mag float aperMag6err Error in calibrated aperture magnitude 6 mag float aperFlux7 ADU float aperFlux7err ADU float aperMagNoAperCorr7 Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 7 mag float aperMag7 Calibrated and corrected aperture magnitude 7 mag float aperMag7err Error in calibrated aperture magnitude 7 mag float aperFlux8 ADU float aperFlux8err ADU float aperMag8 Calibrated and corrected aperture magnitude 8 mag float aperMag8err Error in calibrated aperture magnitude 8 mag float aperFlux9 ADU float aperFlux9err ADU float aperMag9 Calibrated and corrected aperture magnitude 9 mag float aperMag9err Error in calibrated aperture magnitude 9 mag float aperFlux10 ADU float aperFlux10err ADU float aperMag10 Calibrated and corrected aperture magnitude 10 mag float aperMag10err Error in calibrated aperture magnitude 10 mag float aperFlux11 ADU float aperFlux11err ADU float aperMag11 Calibrated and corrected aperture magnitude 11 mag float aperMag11err Error in calibrated aperture magnitude 11 mag float aperFlux12 ADU float aperFlux12err ADU float aperMag12 Calibrated and corrected aperture magnitude 12 mag float aperMag12err Error in calibrated aperture magnitude 12 mag float aperFlux13 ADU float aperFlux13err ADU float aperMag13 Calibrated and corrected aperture magnitude 13 mag float aperMag13err Error in calibrated aperture magnitude 13 mag float petroRad pixels float kronRad pixels float halfRad pixels float hlCircRadAs Circular half-light radius computed from curve of growth assuming petrosian flux is 90% of total arcsec float hlCircRadErrAs Error in hlCircRadAs arcsec float hlGeoRadAs Geometric half-light radius arcsec float hlSMnRadAs Half-light semi-minor axis arcsec float hlSMjRadAs Half-light semi-major axis arcsec float hlCorSMnRadAs Seeing corrected Half-light semi-minor axis arcsec float hlCorSMjRadAs Seeing corrected Half-light semi-major axis arcsec float petroFlux ADU float petroFluxErr ADU float petroMag Calibrated Petrosian magnitude within circular aperture r_p mag float petroMagErr error on calibrated Petrosian magnitude mag float kronFlux ADU float kronFluxErr ADU float kronMag Calibrated Kron magnitude within circular aperture r_k mag float kronMagErr error on calibrated Kron magnitude mag float halfFlux ADU float halfFluxErr ADU float halfMag Calibrated magnitude within circular aperture halfRad, not available in SE output mag float halfMagErr Calibrated error on Half magnitude, not available in SE output mag float errBits int sky ADU float skyVar ADU float averageConf float mjd day double ra Celestial Right Ascension deg POS_EQ_RA_MAIN double dec Celestial Declination deg POS_EQ_DEC_MAIN double cx unit vector of spherical co-ordinates double cy unit vector of spherical co-ordinates double cz unit vector of spherical co-ordinates double htmID Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates long l Galactic longitude Degrees double b Galactic latitude Degrees double lambda SDSS system spherical co-ordinate 1 Degrees double eta SDSS system spherical co-ordinate 2 Degrees double class int classStat float psfFlux float psfFluxErr float psfMag Not available in SE output float psfMagErr Not available in SE output float psfFitX float psfFitXerr float psfFitY float psfFitYerr float psfFitChi2 float psfFitDof int SerFlux1D float SerMag1D SExtractor parameter float SerScaleLen1D float SerIdx1D float SerFit1DChi2 float SerFitNu1D float SerFlux2D float SerMag2D SExtractor parameter float SerScaleLen2D float SerIdx2D float SerFit2DChi2 float SerFitNu2D float deltaMag sum of magnitude corrections for faster processing float illumCorr illumination correction float distortCorr distortion correction float saturatCorr saturation correction float ppErrBits additional WFAU post-processing error bits int deprecated Code for a current (=0) or deprecated (!=0) detection int objID Unique identifier for this detection or default for no detection ID_MAIN long ReleaseContains the release details for each survey curated within the VSA surveyID the unique identifier for the survey int releaseNum the release number int releaseDate the release date MM-DD-YYYY char description a brief description of the release char dbName the name of the SQL Server database containing this release char videoVariabilityContains statistical analysis of VIDEO primary sources sourceID UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm long cuEventID UID of curation event giving rise to this record int frameSetID frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure long ra Mean Right Ascension Degrees double dec Mean Declination Degrees double sigRa Uncertainty in mean RA Degrees float sigDec Uncertainty in mean Dec Degrees float expAstErr Rms calculated from polynomial fit to minimum astrometric RMS as a function of magnitude arcsec float epoch Epoch of measurement Years double muRa Proper motion in RA mas/yr float muDec Proper motion in Dec mas/yr float sigMuRa Error on proper motion in RA mas/yr float sigMuDec Error on proper motion in Dec mas/yr float parallax Parallax of star mas float minPllx Lower limit of 90% confidence interval for parallax measurement mas float maxPllx Upper limit of 90% confidence interval for parallax measurement mas float chi2 Chi-squared value of astrometric solution float nFrames Number of frames with good detections used to calculate astrometric fits int znGoodObs Number of good detections in Z band int znFlaggedObs Number of detections in Z band flagged as potentially spurious by videoDetection.ppErrBits int znMissingObs Number of Z band frames that this object should have been detected on and was not int zbestAper Best aperture (1-6) for photometric statistics in the Z band int zminCadence minimum gap between observations days float zmedCadence median gap between observations days float zmaxCadence maximum gap between observations days float ztotalPeriod total period of observations (last obs-first obs) days float zmeanMag Mean Z magnitude mag float zmedianMag Median Z magnitude mag float zMagRms rms of Z magnitude mag float zMagMAD Median Absolute Deviation of Z magnitude mag float zskewness Skewness in Z band (see Sesar et al. 2007) float zMinMag Minimum magnitude in Z band, of good detections float zMaxMag Maximum magnitude in Z band, of good detections float zNgt3sig Number of good detections in Z-band that are more than 3 sigma deviations int zExpRms Rms calculated from polynomial fit to modal RMS as a function of magnitude in Z band mag float zIntRms Intrinsic rms in Z-band mag float zchiSqpd Chi square (per degree of freedom) fit to data (mean and expected rms) float zndof Number of degrees of freedom for chisquare int zprobVar Probability of variable from chi-square (and other data) float zVarClass Classification of variability in this band int ynGoodObs Number of good detections in Y band int ynFlaggedObs Number of detections in Y band flagged as potentially spurious by videoDetection.ppErrBits int ynMissingObs Number of Y band frames that this object should have been detected on and was not int ybestAper Best aperture (1-6) for photometric statistics in the Y band int yminCadence minimum gap between observations days float ymedCadence median gap between observations days float ymaxCadence maximum gap between observations days float ytotalPeriod total period of observations (last obs-first obs) days float ymeanMag Mean Y magnitude mag float ymedianMag Median Y magnitude mag float yMagRms rms of Y magnitude mag float yMagMAD Median Absolute Deviation of Y magnitude mag float yskewness Skewness in Y band (see Sesar et al. 2007) float yMinMag Minimum magnitude in Y band, of good detections float yMaxMag Maximum magnitude in Y band, of good detections float yNgt3sig Number of good detections in Y-band that are more than 3 sigma deviations int yExpRms Rms calculated from polynomial fit to modal RMS as a function of magnitude in Y band mag float yIntRms Intrinsic rms in Y-band mag float ychiSqpd Chi square (per degree of freedom) fit to data (mean and expected rms) float yndof Number of degrees of freedom for chisquare int yprobVar Probability of variable from chi-square (and other data) float yVarClass Classification of variability in this band int jnGoodObs Number of good detections in J band int jnFlaggedObs Number of detections in J band flagged as potentially spurious by videoDetection.ppErrBits int jnMissingObs Number of J band frames that this object should have been detected on and was not int jbestAper Best aperture (1-6) for photometric statistics in the J band int jminCadence minimum gap between observations days float jmedCadence median gap between observations days float jmaxCadence maximum gap between observations days float jtotalPeriod total period of observations (last obs-first obs) days float jmeanMag Mean J magnitude mag float jmedianMag Median J magnitude mag float jMagRms rms of J magnitude mag float jMagMAD Median Absolute Deviation of J magnitude mag float jskewness Skewness in J band (see Sesar et al. 2007) float jMinMag Minimum magnitude in J band, of good detections float jMaxMag Maximum magnitude in J band, of good detections float jNgt3sig Number of good detections in J-band that are more than 3 sigma deviations int jExpRms Rms calculated from polynomial fit to modal RMS as a function of magnitude in J band mag float jIntRms Intrinsic rms in J-band mag float jchiSqpd Chi square (per degree of freedom) fit to data (mean and expected rms) float jndof Number of degrees of freedom for chisquare int jprobVar Probability of variable from chi-square (and other data) float jVarClass Classification of variability in this band int hnGoodObs Number of good detections in H band int hnFlaggedObs Number of detections in H band flagged as potentially spurious by videoDetection.ppErrBits int hnMissingObs Number of H band frames that this object should have been detected on and was not int hbestAper Best aperture (1-6) for photometric statistics in the H band int hminCadence minimum gap between observations days float hmedCadence median gap between observations days float hmaxCadence maximum gap between observations days float htotalPeriod total period of observations (last obs-first obs) days float hmeanMag Mean H magnitude mag float hmedianMag Median H magnitude mag float hMagRms rms of H magnitude mag float hMagMAD Median Absolute Deviation of H magnitude mag float hskewness Skewness in H band (see Sesar et al. 2007) float hMinMag Minimum magnitude in H band, of good detections float hMaxMag Maximum magnitude in H band, of good detections float hNgt3sig Number of good detections in H-band that are more than 3 sigma deviations int hExpRms Rms calculated from polynomial fit to modal RMS as a function of magnitude in H band mag float hIntRms Intrinsic rms in H-band mag float hchiSqpd Chi square (per degree of freedom) fit to data (mean and expected rms) float hndof Number of degrees of freedom for chisquare int hprobVar Probability of variable from chi-square (and other data) float hVarClass Classification of variability in this band int ksnGoodObs Number of good detections in Ks band int ksnFlaggedObs Number of detections in Ks band flagged as potentially spurious by videoDetection.ppErrBits int ksnMissingObs Number of Ks band frames that this object should have been detected on and was not int ksbestAper Best aperture (1-6) for photometric statistics in the Ks band int ksminCadence minimum gap between observations days float ksmedCadence median gap between observations days float ksmaxCadence maximum gap between observations days float kstotalPeriod total period of observations (last obs-first obs) days float ksmeanMag Mean Ks magnitude mag float ksmedianMag Median Ks magnitude mag float ksMagRms rms of Ks magnitude mag float ksMagMAD Median Absolute Deviation of Ks magnitude mag float ksskewness Skewness in Ks band (see Sesar et al. 2007) float ksMinMag Minimum magnitude in Ks band, of good detections float ksMaxMag Maximum magnitude in Ks band, of good detections float ksNgt3sig Number of good detections in Ks-band that are more than 3 sigma deviations int ksExpRms Rms calculated from polynomial fit to modal RMS as a function of magnitude in Ks band mag float ksIntRms Intrinsic rms in Ks-band mag float kschiSqpd Chi square (per degree of freedom) fit to data (mean and expected rms) float ksndof Number of degrees of freedom for chisquare int ksprobVar Probability of variable from chi-square (and other data) float ksVarClass Classification of variability in this band int variableClass Classification of objects across all bands. int videoSourceXStripe82PhotoObjAllCross-neighbours between video and PhotoObjAll masterObjID The unique ID in videoSource (=sourceID) long slaveObjID The unique ID of the neighbour in Stripe82..PhotoObjAll (=objID) long distanceMins Angular separation between neighbours arcminutes float sdssType SDSS type of neighbour: 3=galaxy; 6=star int sdssPrimary SDSS flag for neighbour being primary (1) or secondary (0) int RequiredTileContains details of default stack image products curated in the archive programmeID the unique programme ID int productID A unique identifier assigned to each required stack product entry int name Name of the stacked product char description Description of the product char filterID UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) int ra Right Ascension of stack centre deg double dec Declination of stack centre deg double nustep Amount of microstepping int stackRadius radius within which intermediate stacks are selected for this deep stack. deg float fieldID UID of position on sky. int posAngle Orientation of image x-axis to N-S deg float videoTilePawPrintsContains tile<->paw-print paired detections from videoDetection detectID UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm long cuEventID UID of curation event giving rise to this record int tileSetID UID of the set of frames that this merged source comes from long ra Celestial Right Ascension Degrees double dec Celestial Declination Degrees double cx unit vector of spherical co-ordinates double cy unit vector of spherical co-ordinates double cz unit vector of spherical co-ordinates double htmID Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates long l Galactic longitude Degrees double b Galactic latitude Degrees double lambda SDSS system spherical co-ordinate 1 Degrees double eta SDSS system spherical co-ordinate 2 Degrees double tlExtNum the extension number of the tile detection (should always be 2) int tlSeqNum the running number of the tile detection int tlXi Offset of &As& detection from master position (+east/-west) arcsec float tlEta Offset of &As& detection from master position (+north/-south) arcsec float o1ExtNum the extension number of the O1 detection int o1SeqNum the running number of the O1 detection int o1Xi Offset of O1 detection from master position (+east/-west) arcsec float o1Eta Offset of O1 detection from master position (+north/-south) arcsec float o2ExtNum the extension number of the O2 detection int o2SeqNum the running number of the O2 detection int o2Xi Offset of O2 detection from master position (+east/-west) arcsec float o2Eta Offset of O2 detection from master position (+north/-south) arcsec float o3ExtNum the extension number of the O3 detection int o3SeqNum the running number of the O3 detection int o3Xi Offset of O3 detection from master position (+east/-west) arcsec float o3Eta Offset of O3 detection from master position (+north/-south) arcsec float o4ExtNum the extension number of the O4 detection int o4SeqNum the running number of the O4 detection int o4Xi Offset of O4 detection from master position (+east/-west) arcsec float o4Eta Offset of O4 detection from master position (+north/-south) arcsec float o5ExtNum the extension number of the O5 detection int o5SeqNum the running number of the O5 detection int o5Xi Offset of O5 detection from master position (+east/-west) arcsec float o5Eta Offset of O5 detection from master position (+north/-south) arcsec float o6ExtNum the extension number of the O6 detection int o6SeqNum the running number of the O6 detection int o6Xi Offset of O6 detection from master position (+east/-west) arcsec float o6Eta Offset of O6 detection from master position (+north/-south) arcsec float tileSetSeqNum Running number of the match in this tile set int ProgrammeTableContains details of the set of curated tables for each programme programmeID the unique programme ID int tableID the unique table ID int tableName the name of the table char sourceIDName the name of the source char videoSourceNeighboursNeighbouring sources for each entry in videoSource masterObjID The unique ID in videoSource (=sourceID) long slaveObjID The unique ID of the neighbour in videoSource (=sourceID) long distanceMins Angular separation between neighbours arcminutes float SurveyContains information about the curated surveys within the VSA surveyID The unique identifier for the curated survey int name The short name for the survey char description A concise description of the survey char dbNamePrefix A string that prefixes all database names released for this survey char proprietary Logical flag indicating whether a survey is proprietary or not (1=yes; 0=no) int MultiframeEsoKeysContains details of all hierarchical ESO attributes for the primary HDU multiframeID the UID of the relevant multiframe long cuEventID UID of curation event giving rise to this record int detDit double detNcorrsName char detNdit int dprCatg char dprTech char dprType char insDate char insFilt1Date char insFilt1Enc int insFilt1Error double insFilt1Focus double insFilt1ID char insFilt1Name char insFilt1No int insFilt1Posedge int insFilt1Trayid char insFilt1Wlen double insHb1Swsim int insID char insLsc1Ok int insLsc1Swsim int insLsm1Ok int insLsm1Swsim int insLsm2Ok int insLsm2Swsim int insLsm3Ok int insLsm3Swsim int insPres1ID char insPres1Name char insPres1Unit char insPres1Val double insSw1ID char insSw1Name char insSw1Status char insSw2ID char insSw2Name char insSw2Status char insSw3ID char insSw3Name char insSw3Status char insTemp1ID char insTemp1Name char insTemp1Unit char insTemp1Val double insTemp2ID char insTemp2Name char insTemp2Unit char insTemp2Val double insTemp3ID char insTemp3Name char insTemp3Unit char insTemp3Val double insTemp4ID char insTemp4Name char insTemp4Unit char insTemp4Val double insTemp5ID char insTemp5Name char insTemp5Unit char insTemp5Val double insTemp6ID char insTemp6Name char insTemp6Unit char insTemp6Val double insTemp7ID char insTemp7Name char insTemp7Unit char insTemp7Val double insTemp8ID char insTemp8Name char insTemp8Unit char insTemp8Val double insTemp10ID char insTemp10Name char insTemp10Unit char insTemp10Val double insTemp12ID char insTemp12Name char insTemp12Unit char insTemp12Val double insTemp14ID char insTemp14Name char insTemp14Unit char insTemp14Val double insTemp15ID char insTemp15Name char insTemp15Unit char insTemp15Val double insTemp16ID char insTemp16Name char insTemp16Unit char insTemp16Val double insTemp17ID char insTemp17Name char insTemp17Unit char insTemp17Val double insTemp18ID char insTemp18Name char insTemp18Unit char insTemp18Val double insTemp19ID char insTemp19Name char insTemp19Unit char insTemp19Val double insTemp20ID char insTemp20Name char insTemp20Unit char insTemp20Val double insTemp21ID char insTemp21Name char insTemp21Unit char insTemp21Val double insTemp22ID char insTemp22Name char insTemp22Unit char insTemp22Val double insTemp23ID char insTemp23Name char insTemp23Unit char insTemp23Val double insTemp24ID char insTemp24Name char insTemp24Unit char insTemp24Val double insTemp25ID char insTemp25Name char insTemp25Unit char insTemp25Val double insTemp26ID char insTemp26Name char insTemp26Unit char insTemp26Val double insThermalAmbMean double insThermalCldMean double insThermalDetMean double insThermalDetTarget double insThermalEnable int insThermalFpaMean double insThermalTubMean double insThermalWinMean double insVac1Ok int insVac1Swsim int obsDid char obsExectime int obsGrp char obsID int obsName char obsObserver char obsPiCoiID int obsPiCoiName char obsProgID char obsStart char obsTargName char obsTplno int ocsDet1Imgname char ocsExpno int ocsNexp int ocsRecipe char ocsReqtime double ocsSadtAosa1ID char ocsSadtAosa2ID char ocsSadtAosa3ID char ocsSadtAosa4ID char ocsSadtAosa5ID char ocsSadtAosb1ID char ocsSadtAosb2ID char ocsSadtAosb3ID char ocsSadtAosb4ID char ocsSadtAosb5ID char ocsSadtCatID char ocsSadtGs1ID char ocsSadtGs2ID char ocsSadtGs3ID char ocsSadtGs4ID char ocsSadtGs5ID char ocsSadtIpID char ocsTargAlphaobj double ocsTargDeltaobj double ocsTargX double ocsTargY double telAbsrotEnd double telAbsrotStart double telAgRefx double telAgRefy double telAirmEnd double telAirmStart double telAlt double telAmbiFwhmEnd double telAmbiFwhmStart double telAmbiPresEnd double telAmbiPresStart double telAmbiRhum double telAmbiTau0 double telAmbiTemp double telAmbiWinddir double telAmbiWindsp double telAoAlt double telAoDate char telAoM1Date char telAoM2Date char telAoModes int telAz double telDate char telDid char telDid1 char telDomeStatus char telEcsFlatfield int telEcsMoonscr double telEcsVent1 double telEcsVent2 double telEcsVent3 double telEcsWindscr double telFocuID char telFocuValue double telGeoelev double telGeolat double telGeolon double telGuidDec double telGuidFwhm double telGuidID char telGuidMag double telGuidPeakint double telGuidRa double telGuidStatus char telID char telM2Acentre double telM2Atilt double telM2Bcentre double telM2Btilt double telM2Z double telMoonDec double telMoonRa double telOper char telParangEnd double telParangStart double telPosang double telTargAlpha double telTargCoordtype char telTargDelta double telTargEpoch double telTargEpochsystem char telTargEquinox double telTargParallax double telTargPma double telTargPmd double telTargRadvel double telThM1Temp double telThStrTemp double telTrakStatus char tplDid char tplExpno int tplFileDirname char tplID char tplName char tplNexp int tplPreseq char tplStart char tplVersion char obsAirm float obsAmbiFwhm float obsAmbiTrans char obsContainerID long obsContainerType char obsMoonDist deg? float obsMoonFli float sadtAreaID int sadtSurveyID char sadtMaxJit arcsec float sadtOverlapX arcsec float sadtOverlapY arcsec float sadtPattern char sadtTileRa HHMMSS.TTT float sadtTileDec DDMMSS.TTT float sadtTileOffAngle deg float sadtTileID char videoSourceXwise_allskyscCross-neighbours between video and wise_allskysc masterObjID The unique ID in videoSource (=sourceID) long slaveObjID The unique ID of the neighbour in WISE..wise_allskysc (=cntr) long distanceMins Angular separation between neighbours arcminutes float CurrentAstrometryContains the current astrometric calibration coefficients multiframeID the UID of the relevant multiframe long extNum the extension number of this frame int cuEventID UID of curation event giving rise to this record int cTypeX char cTypeY char crValX double crValY double crUnit1 char crUnit2 char crPixX pixels double crPixY pixels double cd11 double cd21 double cd12 double cd22 double pv21 double pv22 double pv23 double pv24 double pv25 double projp1 double projp3 double projp5 double tc33 double tc35 double tc53 double tc55 double tcrpx3 double tcrpx5 double tcrvl3 double tcrvl5 double tctyp3 char tctyp5 char tv51 double tv52 double tv53 double tv54 double tv55 double wcsPass int numRms int stdCRms double refRaShift01 arcsec double refDecShift01 arcsec double refRaShift02 arcsec double refDecShift02 arcsec double refRaShift12 arcsec double refDecShift12 arcsec double refRaShift22 arcsec double refDecShift22 arcsec double distortMap filename of 2d non-linear distortion map char centralRa RA (J2000) at device centre Degrees double centralDec Dec (J2000) at device centre Degrees double cx unit vector of spherical co-ordinates of device centre double cy unit vector of spherical co-ordinates of device centre double cz unit vector of spherical co-ordinates of device centre double htmID Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates of device centre long posAngle orientation of image x-axis to N-S Degrees double l Galactic longitude of device centre Degrees double b Galactic latitude of device centre Degrees double lambda SDSS system spherical co-ordinate 1 of device centre Degrees double eta SDSS system spherical co-ordinate 2 of device centre Degrees double imageExtent The maximum angular extent from the central position Arcminutes float minRa The minimum RA (J2000) on the device Degrees double minDec The minimum Dec (J2000) on the device Degrees double maxRa The maximum RA (J2000) on the device Degrees double maxDec The maximum Dec (J2000) on the device Degrees double xPixSize Angular size of pixels in X Arcseconds float yPixSize Angular size of pixels in Y Arcseconds float MultiframeDetectorEsoKeysContains details of all hierarchical ESO attributes for secondary HDUs multiframeID the UID of the relevant multiframe long extNum the extension number of this frame int cuEventID UID of curation event giving rise to this record int detChipID char detChipLive int detChipName char detChipNo int detChipNx int detChipNy int detChipPxspace double detChipType char detChipVignetd int detChipX int detChipY int detChopFreq int detConOpmode char detDid char detDitdelay double detExpName char detExpNo int detExpUtc char detFileCubeSt int detFramNo int detFramType char detFramUtc char detIraceAdc1Delay int detIraceAdc1Enable int detIraceAdc1Filter1 int detIraceAdc1Filter2 int detIraceAdc1Header int detIraceAdc1Name char detIraceAdc2Delay int detIraceAdc2Enable int detIraceAdc2Filter1 int detIraceAdc2Filter2 int detIraceAdc2Header int detIraceAdc2Name char detIraceAdc3Delay int detIraceAdc3Enable int detIraceAdc3Filter1 int detIraceAdc3Filter2 int detIraceAdc3Header int detIraceAdc3Name char detIraceAdc4Delay int detIraceAdc4Enable int detIraceAdc4Filter1 int detIraceAdc4Filter2 int detIraceAdc4Header int detIraceAdc4Name char detIraceAdc5Delay int detIraceAdc5Enable int detIraceAdc5Filter1 int detIraceAdc5Filter2 int detIraceAdc5Header int detIraceAdc5Name char detIraceAdc6Delay int detIraceAdc6Enable int detIraceAdc6Filter1 int detIraceAdc6Filter2 int detIraceAdc6Header int detIraceAdc6Name char detIraceAdc7Delay int detIraceAdc7Enable int detIraceAdc7Filter1 int detIraceAdc7Filter2 int detIraceAdc7Header int detIraceAdc7Name char detIraceAdc8Delay int detIraceAdc8Enable int detIraceAdc8Filter1 int detIraceAdc8Filter2 int detIraceAdc8Header int detIraceAdc8Name char detIraceAdc9Delay int detIraceAdc9Enable int detIraceAdc9Filter1 int detIraceAdc9Filter2 int detIraceAdc9Header int detIraceAdc9Name char detIraceAdc10Delay int detIraceAdc10Enable int detIraceAdc10Filter1 int detIraceAdc10Filter2 int detIraceAdc10Header int detIraceAdc10Name char detIraceAdc11Delay int detIraceAdc11Enable int detIraceAdc11Filter1 int detIraceAdc11Filter2 int detIraceAdc11Header int detIraceAdc11Name char detIraceAdc12Delay int detIraceAdc12Enable int detIraceAdc12Filter1 int detIraceAdc12Filter2 int detIraceAdc12Header int detIraceAdc12Name char detIraceAdc13Delay int detIraceAdc13Enable int detIraceAdc13Filter1 int detIraceAdc13Filter2 int detIraceAdc13Header int detIraceAdc13Name char detIraceAdc14Delay int detIraceAdc14Enable int detIraceAdc14Filter1 int detIraceAdc14Filter2 int detIraceAdc14Header int detIraceAdc14Name char detIraceAdc15Delay int detIraceAdc15Enable int detIraceAdc15Filter1 int detIraceAdc15Filter2 int detIraceAdc15Header int detIraceAdc15Name char detIraceAdc16Delay int detIraceAdc16Enable int detIraceAdc16Filter1 int detIraceAdc16Filter2 int detIraceAdc16Header int detIraceAdc16Name char detIraceSeqcont int detMindit double detModeName char detNcorrs int detNditskip int detRspeed int detRspeedadd int detWinNx int detWinNy int detWinStartx int detWinStarty int detWinType int videoSourceXDetectionBestMatchLinks each unique source to the best set of possible detections sourceID UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm long multiframeID the UID of the relevant multiframe long extNum the extension number of this frame int cuEventID UID of curation event giving rise to this record int seqNum int modelDistSecs separation from expected position given astrometric model in videoSource variability. arcsec float flag Flag for potential matching problems int RequiredMosaicContains details of default mosaic image products curated in the archive programmeID the unique programme ID int productID A unique identifier assigned to each required mosaic product entry int name Name of the mosaiced product char description Description of the product char filterID UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) int ra Right Ascension of mosaic centre deg double dec Declination of mosaic centre deg double raExtent The angular extent in RA of the mosaic image deg float decExtent The angular extent in Dec of the mosaic image deg float nustep Amount of microstepping int pixelSize The final pixel size of the mosaic arcsec float dualFilterID SEX extraction tool option to run in dual image mode UID of dual image filter (assigned in WSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank) int fieldID UID of position on sky. int posAngle Orientation of image x-axis to N-S deg float FilterContains details of the VISTA infrared camera filters filterID UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) int shortName Short identification name for the filter char name The name of the filter, eg. &quot;MKO J&quot;, &quot;K short&quot; etc. char description a concise description of the filter char cutOn The 50% cut-on wavelength of the filter microns float cutOff The 50% cut-off wavelength of the filter microns float aebv The constant to multiply the Schlegel map E(B-V) by to get the total galactic extinction. float vegaToAB The constant to convert Vega magnitudes to AB magnitudes. mag float oneSecMLVg The Vega magnitude limit of a 1s exposure in this filter mag float videoTilePawTDOnlyvideoTilePawPrints table with only good tile detections only and default detectID UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm long cuEventID UID of curation event giving rise to this record int tileSetID UID of the set of frames that this merged source comes from long ra Celestial Right Ascension Degrees double dec Celestial Declination Degrees double cx unit vector of spherical co-ordinates double cy unit vector of spherical co-ordinates double cz unit vector of spherical co-ordinates double htmID Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates long l Galactic longitude Degrees double b Galactic latitude Degrees double lambda SDSS system spherical co-ordinate 1 Degrees double eta SDSS system spherical co-ordinate 2 Degrees double tlExtNum the extension number of the tile detection (should always be 2) int tlSeqNum the running number of the tile detection int tlXi Offset of &As& detection from master position (+east/-west) arcsec float tlEta Offset of &As& detection from master position (+north/-south) arcsec float o1ExtNum the extension number of the O1 detection int o1SeqNum the running number of the O1 detection int o1Xi Offset of O1 detection from master position (+east/-west) arcsec float o1Eta Offset of O1 detection from master position (+north/-south) arcsec float o2ExtNum the extension number of the O2 detection int o2SeqNum the running number of the O2 detection int o2Xi Offset of O2 detection from master position (+east/-west) arcsec float o2Eta Offset of O2 detection from master position (+north/-south) arcsec float o3ExtNum the extension number of the O3 detection int o3SeqNum the running number of the O3 detection int o3Xi Offset of O3 detection from master position (+east/-west) arcsec float o3Eta Offset of O3 detection from master position (+north/-south) arcsec float o4ExtNum the extension number of the O4 detection int o4SeqNum the running number of the O4 detection int o4Xi Offset of O4 detection from master position (+east/-west) arcsec float o4Eta Offset of O4 detection from master position (+north/-south) arcsec float o5ExtNum the extension number of the O5 detection int o5SeqNum the running number of the O5 detection int o5Xi Offset of O5 detection from master position (+east/-west) arcsec float o5Eta Offset of O5 detection from master position (+north/-south) arcsec float o6ExtNum the extension number of the O6 detection int o6SeqNum the running number of the O6 detection int o6Xi Offset of O6 detection from master position (+east/-west) arcsec float o6Eta Offset of O6 detection from master position (+north/-south) arcsec float tileSetSeqNum Running number of the match in this tile set int ArchiveCurationHistoryContains details of the matrix of the Archives' required curation tasks cuEventID UID of curation event giving rise to this record int cuID the unique curation task ID int logFile filename of verbose logged task output char resultsFile filename of any results file char timeStamp Time of the completion of the whole task UTC char curator The archive curation scientist responsible for this event char comment Comment string supplied by the curator char rolledBack Flag for roll-back of this event: 0=no, 1 = yes int CurationTaskContains a list of all curation tasks that are used within the VSA cuID the unique curation task ID int description description in words for this task char videoSourceXSSASourceCross-neighbours between video and Source masterObjID The unique ID in videoSource (=sourceID) long slaveObjID The unique ID of the neighbour in SSA..Source (=objID) long distanceMins Angular separation between neighbours arcminutes float SurveyProgrammesContains details of which programme(s) belong to which survey(s surveyID The unique identifier for the curated survey int programmeID int delPropData Logical flag indicating that proprietary data should be removed on release (1=yes; 0=no) int ProgrammeFrameContains details of which image(s) belong to which Programme(s programmeID int multiframeID the UID of the relevant multiframe long cuEventID UID of curation event giving rise to this record int ppErrBitsStatus Bit flag to denote whether detection quality flagging has been done on this multiframe for this programme. int productID long releaseNum int videoSourceXDetectionCross-neighbours between master source list, videoSource table, and the individual epoch detections, videoDetection table masterObjID The unique ID in videoSource (=sourceID) long slaveObjID The unique ID of the neighbour in videoDetection table (=objID) long distanceMins Angular separation between neighbours arcminutes float RequiredDiffImageContains details of default difference image products curated in the archive programmeID the unique programme ID int productID A unique identifier assigned to each required difference image product entry int filter1 UID of narrow band (primary) filter int filter2 UID of broad band (reference) filter to be subtracted int wcs CASU difference image tool option to specify use of implicit WCS in the input files (y/n; recommended value=y) char method CASU difference image tool option string specifying the method to employ (recommended value=adaptive/back/zerosky) char RequiredNeighboursDetails programmes/survey tables that have default joins within the VSA programmeID the unique programme ID int tableID the unique identifier for the programme table int surveyID the unique identifier for the survey int extTableID the unique table ID int joinCriterion the join criterion (search radius for matches) arcminutes float neighbourTable the name of the neighbour join table char extProgID the unique programme ID for second table if there are multiple programmes in the neighbour survey int ExternalSurveyTableContains information about the external surveys tables surveyID the unique identifier for the survey int extTableID the unique table ID int extTableName the name of the table char sourceIDName The source unique identifier in the table char coord1 The attribute name of the first (longitudinal) spherical co-ordinate, e.g. equatorial RA char coord2 The attribute name of the second (latitudinal) spherical co-ordinate, e.g. equatorial Dec char MultiframeDetectorContains details of individual detector frames that are part of a multiframe multiframeID the UID of the relevant multiframe long extNum the extension number of this frame int cuEventID UID of curation event giving rise to this record int compFile Filename of the compressed image of this image frame, eg. server:/path/filename.jpg char julianDayNum Julian days int camNum int deviceID char filterID int runID char creationDate MM-DD-YYYY:hh:mm:ss.sss char imageExtName char bitsPerPix FITS bitpix int dataScale float dataZero float numAxes Number of data axes; eg. 2 int axis1Length int axis2Length int imagePcount int imageGcount int detectorType char detRows int detCols int CIRMED float CIR_BVAR float cirVers char ditherOffsetX float ditherOffsetY float lincor char nbad int nditcor int nCombine int groutedFlag int destripe int strprms float tpaoff float tpdoff float tpnmatch int skyCorrExt float extinctionExt mags float skyCorrCat float photZPCat mags float photZPErrCat mags float extinctionCat mags float numZPCat int nightZPCat mags float nightZPErrCat mags float nightZPNum mags int medPa float nbsize int tableExtName char tableWidth bytes int tableRows int tablePcount int tableGcount int tableFields int catCreationDate MM-DD-YYYY:hh:mm:ss.sss char aperCorPeak float aperCor1 float aperCor2 float aperCor3 float aperCor4 float aperCor5 float aperCor6 float aperCor7 float crowdedFlag int minImageSize int xSize int ySize int coreRadius float skyLevel counts/pixel float skyNoise counts float seeing pixels float avStellarEll float avSaturLevel float thresholdIsoph float deprecated Code for a current (=0) or deprecated (!=0) multiframe detector int decurtainRange float skySubScale double morphClassFlag int smoothing pixels float totalExpTime Total exposure time for this detector seconds float dribble char gainCor float templRotation Degrees float abMagLim mag float abSatMag mag float ebmvMed float mjdMean days double PreviousMFDZPContains previous zeropoints for each multiframe and detector combination multiframeID the UID of the relevant multiframe long extNum the extension number of this frame int versNum the version number of the calibration int photZPCat Photometric zeropoint for default extinction in catalogue header mag float photZPErrCat Photometric zeropoint error in catalogue header mag float numZPCat Number of standards used in determining photZP and photZPErr int nightZPCat Average photometric zero point for night mags float nightZPErrCat Photometric zero point sigma for night mags float nightZPNum Number of ZP in band used to calculate nightZPCat mags int videoVarFrameSetInfoContains fitting information for each frameSet frameSetID frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure long cuEventID UID of curation event giving rise to this record int motionModel Motion model used to produce BestMatch table. Values: static;proper motion;proper motion and parallax. char zaStratAst Strateva parameter, a, in fit to astrometric rms vs magnitude in Z band, see Sesar et al. 2007. float zbStratAst Strateva parameter, b, in fit to astrometric rms vs magnitude in Z band, see Sesar et al. 2007. float zcStratAst Strateva parameter, c, in fit to astrometric rms vs magnitude in Z band, see Sesar et al. 2007. float zchiSqAst Goodness of fit of Strateva function to astrometric data in Z band float znDofAst Number of degrees of freedom of astrometric fit in Z band. int zisDefAst Use a default model for the astrometric noise in Z band. int zaStratPht Strateva parameter, a, in fit to photometric rms vs magnitude in Z band, see Sesar et al. 2007. float zbStratPht Strateva parameter, b, in fit to photometric rms vs magnitude in Z band, see Sesar et al. 2007. float zcStratPht Strateva parameter, c, in fit to photometric rms vs magnitude in Z band, see Sesar et al. 2007. float zchiSqPht Goodness of fit of Strateva function to photometric data in Z band float znDofPht Number of degrees of freedom of photometric fit in Z band. int zisDefPht Use a default model for the photometric noise in Z band. int zexpML Expected magnitude limit of frameSet in this in Z band. float yaStratAst Strateva parameter, a, in fit to astrometric rms vs magnitude in Y band, see Sesar et al. 2007. float ybStratAst Strateva parameter, b, in fit to astrometric rms vs magnitude in Y band, see Sesar et al. 2007. float ycStratAst Strateva parameter, c, in fit to astrometric rms vs magnitude in Y band, see Sesar et al. 2007. float ychiSqAst Goodness of fit of Strateva function to astrometric data in Y band float ynDofAst Number of degrees of freedom of astrometric fit in Y band. int yisDefAst Use a default model for the astrometric noise in Y band. int yaStratPht Strateva parameter, a, in fit to photometric rms vs magnitude in Y band, see Sesar et al. 2007. float ybStratPht Strateva parameter, b, in fit to photometric rms vs magnitude in Y band, see Sesar et al. 2007. float ycStratPht Strateva parameter, c, in fit to photometric rms vs magnitude in Y band, see Sesar et al. 2007. float ychiSqPht Goodness of fit of Strateva function to photometric data in Y band float ynDofPht Number of degrees of freedom of photometric fit in Y band. int yisDefPht Use a default model for the photometric noise in Y band. int yexpML Expected magnitude limit of frameSet in this in Y band. float jaStratAst Strateva parameter, a, in fit to astrometric rms vs magnitude in J band, see Sesar et al. 2007. float jbStratAst Strateva parameter, b, in fit to astrometric rms vs magnitude in J band, see Sesar et al. 2007. float jcStratAst Strateva parameter, c, in fit to astrometric rms vs magnitude in J band, see Sesar et al. 2007. float jchiSqAst Goodness of fit of Strateva function to astrometric data in J band float jnDofAst Number of degrees of freedom of astrometric fit in J band. int jisDefAst Use a default model for the astrometric noise in J band. int jaStratPht Strateva parameter, a, in fit to photometric rms vs magnitude in J band, see Sesar et al. 2007. float jbStratPht Strateva parameter, b, in fit to photometric rms vs magnitude in J band, see Sesar et al. 2007. float jcStratPht Strateva parameter, c, in fit to photometric rms vs magnitude in J band, see Sesar et al. 2007. float jchiSqPht Goodness of fit of Strateva function to photometric data in J band float jnDofPht Number of degrees of freedom of photometric fit in J band. int jisDefPht Use a default model for the photometric noise in J band. int jexpML Expected magnitude limit of frameSet in this in J band. float haStratAst Strateva parameter, a, in fit to astrometric rms vs magnitude in H band, see Sesar et al. 2007. float hbStratAst Strateva parameter, b, in fit to astrometric rms vs magnitude in H band, see Sesar et al. 2007. float hcStratAst Strateva parameter, c, in fit to astrometric rms vs magnitude in H band, see Sesar et al. 2007. float hchiSqAst Goodness of fit of Strateva function to astrometric data in H band float hnDofAst Number of degrees of freedom of astrometric fit in H band. int hisDefAst Use a default model for the astrometric noise in H band. int haStratPht Strateva parameter, a, in fit to photometric rms vs magnitude in H band, see Sesar et al. 2007. float hbStratPht Strateva parameter, b, in fit to photometric rms vs magnitude in H band, see Sesar et al. 2007. float hcStratPht Strateva parameter, c, in fit to photometric rms vs magnitude in H band, see Sesar et al. 2007. float hchiSqPht Goodness of fit of Strateva function to photometric data in H band float hnDofPht Number of degrees of freedom of photometric fit in H band. int hisDefPht Use a default model for the photometric noise in H band. int hexpML Expected magnitude limit of frameSet in this in H band. float ksaStratAst Strateva parameter, a, in fit to astrometric rms vs magnitude in Ks band, see Sesar et al. 2007. float ksbStratAst Strateva parameter, b, in fit to astrometric rms vs magnitude in Ks band, see Sesar et al. 2007. float kscStratAst Strateva parameter, c, in fit to astrometric rms vs magnitude in Ks band, see Sesar et al. 2007. float kschiSqAst Goodness of fit of Strateva function to astrometric data in Ks band float ksnDofAst Number of degrees of freedom of astrometric fit in Ks band. int ksisDefAst Use a default model for the astrometric noise in Ks band. int ksaStratPht Strateva parameter, a, in fit to photometric rms vs magnitude in Ks band, see Sesar et al. 2007. float ksbStratPht Strateva parameter, b, in fit to photometric rms vs magnitude in Ks band, see Sesar et al. 2007. float kscStratPht Strateva parameter, c, in fit to photometric rms vs magnitude in Ks band, see Sesar et al. 2007. float kschiSqPht Goodness of fit of Strateva function to photometric data in Ks band float ksnDofPht Number of degrees of freedom of photometric fit in Ks band. int ksisDefPht Use a default model for the photometric noise in Ks band. int ksexpML Expected magnitude limit of frameSet in this in Ks band. float videoAstrometricInfoContains astrometric information that will be used by BestMatc multiframeID the UID of the relevant multiframe long extNum the extension number of this frame int cuEventID UID of curation event giving rise to this record int detedgeinnerpos1NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos1NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos1NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos1Const Offset of halfspace along the unit normal vector describing the DETEDGEINNERPOS1 detector boundary. If the detector boundary is straight, with no distortion this is zero. double detedgeinnerpos2NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos2NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos2NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos2Const Offset of halfspace along the unit normal vector describing the DETEDGEINNERPOS2 detector boundary. If the detector boundary is straight, with no distortion this is zero. double detedgeinnerpos3NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos3NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos3NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos3Const Offset of halfspace along the unit normal vector describing the DETEDGEINNERPOS3 detector boundary. If the detector boundary is straight, with no distortion this is zero. double detedgeinnerpos4NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos4NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos4NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,) double detedgeinnerpos4Const Offset of halfspace along the unit normal vector describing the DETEDGEINNERPOS4 detector boundary. If the detector boundary is straight, with no distortion this is zero. double detedgeouterpos1NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,) double detedgeouterpos1NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,) double detedgeouterpos1NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,) double detedgeouterpos1Const Offset of halfspace along the unit normal vector describing the DETEDGEOUTERPOS1 detector boundary. If the detector boundary is straight, with no distortion this is zero. double detedgeouterpos2NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,) double detedgeouterpos2NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,) double detedgeouterpos2NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,) double detedgeouterpos2Const Offset of halfspace along the unit normal vector describing the DETEDGEOUTERPOS2 detector boundary. If the detector boundary is straight, with no distortion this is zero. double detedgeouterpos3NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,) double detedgeouterpos3NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,) double detedgeouterpos3NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,) double detedgeouterpos3Const Offset of halfspace along the unit normal vector describing the DETEDGEOUTERPOS3 detector boundary. If the detector boundary is straight, with no distortion this is zero. double detedgeouterpos4NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,) double detedgeouterpos4NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,) double detedgeouterpos4NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,) double detedgeouterpos4Const Offset of halfspace along the unit normal vector describing the DETEDGEOUTERPOS4 detector boundary. If the detector boundary is straight, with no distortion this is zero. double dithedgeinnerpos1NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos1NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos1NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos1Const Offset of halfspace along the unit normal vector describing the DITHEDGEINNERPOS1 detector boundary. If the detector boundary is straight, with no distortion this is zero. double dithedgeinnerpos2NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos2NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos2NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos2Const Offset of halfspace along the unit normal vector describing the DITHEDGEINNERPOS2 detector boundary. If the detector boundary is straight, with no distortion this is zero. double dithedgeinnerpos3NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos3NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos3NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos3Const Offset of halfspace along the unit normal vector describing the DITHEDGEINNERPOS3 detector boundary. If the detector boundary is straight, with no distortion this is zero. double dithedgeinnerpos4NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos4NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos4NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,) double dithedgeinnerpos4Const Offset of halfspace along the unit normal vector describing the DITHEDGEINNERPOS4 detector boundary. If the detector boundary is straight, with no distortion this is zero. double dithedgeouterpos1NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos1NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos1NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos1Const Offset of halfspace along the unit normal vector describing the DITHEDGEOUTERPOS1 detector boundary. If the detector boundary is straight, with no distortion this is zero. double dithedgeouterpos2NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos2NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos2NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos2Const Offset of halfspace along the unit normal vector describing the DITHEDGEOUTERPOS2 detector boundary. If the detector boundary is straight, with no distortion this is zero. double dithedgeouterpos3NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos3NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos3NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos3Const Offset of halfspace along the unit normal vector describing the DITHEDGEOUTERPOS3 detector boundary. If the detector boundary is straight, with no distortion this is zero. double dithedgeouterpos4NormX Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos4NormY Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos4NormZ Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,) double dithedgeouterpos4Const Offset of halfspace along the unit normal vector describing the DITHEDGEOUTERPOS4 detector boundary. If the detector boundary is straight, with no distortion this is zero. double xifitrms RMS errors in fit for xi arcsec double xnfitrms RMS errors in fit for xn arcsec double xizp Zeropoint offset in xi arcsec double siga Error on coefficient a arcsec double xnzp Zeropoint offset in xn arcsec double sigd Error on coefficient d arcsec double xisc Scale factor in xi double xnsc Scale factor in xn double orient Orientation of axes deg double nonperp Non-perpendicularity of axes deg double chi2s Reduced chi-squared of fit double isComplete Level of completeness: 0 redo both parts 1; halfspace calculation complete; 2 Astrometric correction complete; 3 All complete int RequiredStackContains details of default stack image products curated in the archive programmeID the unique programme ID int productID A unique identifier assigned to each required stack product entry int name Name of the stacked product char description Description of the product char filterID UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) int ra Right Ascension of stack centre deg double dec Declination of stack centre deg double numberStk Number of intermediate stacks. If default, stack all good quality stacks int nustep Amount of microstepping int offsetPos Identity of offset position [1: -1,-1;2: -1,0; 3: -1,1; 4: 1,-1; 5: 1,0; 6: 1,1] int stackRadius radius within which intermediate stacks are selected for this deep stack. deg float fieldID UID of position on sky. int posAngle Orientation of image x-axis to N-S deg float ProvenanceDescribes the provenance of all combined frames in the archive combiframeID the UID of the combined frame (=combiframe) long multiframeID the UID of the component frame long cuEventID UID of curation event giving rise to this record int videoSourceXtwomass_xscCross-neighbours between video and twomass_xsc masterObjID The unique ID in videoSource (=sourceID) long slaveObjID The unique ID of the neighbour in TWOMASS..twomass_xsc (=ext_key) long distanceMins Angular separation between neighbours arcminutes float ProgrammeCurationHistoryContains details of the matrix of programmes and required curation tasks programmeID the unique programme ID int cuEventID UID of curation event giving rise to this record int timeStamp Time of individual programme curation completion UTC char status successful (1) or unsuccessful (0) int MultiframeContains details of all multiframes stored in the archive multiframeID UID of the multiframe (assigned sequentially by the archive ingest process) long vistaRunNo Original VISTA run number (from filename) int creationDate MM-DD-YYYY char frameType The type of multiframe (e.g. stack|tile|mosaic etc.) char cuEventID UID of curation event giving rise to this record int julianDayNum The Julian Day number of the VISTA night Julian days int fileTimeStamp Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness long filterName char filterID UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) int project Time-allocation code char telescope char instrument char arcfile char utDate Observation date (MM-DD-YYYY) MM-DD-YYYY char dateObs char mjdObs double equinox years float lst float utc float raBase hours double decBase deg double raDecSys char expTime seconds float jitterID int jitterX float jitterY float grpNum int tileNum int jitterName char masktype int naxis int njitter int noffsets int nuStep int object char observer char numDetectors The number of &quot;detectors&quot; (=image extensions in FITS file) int obsNum int obstype char offsetID int offsetX float offsetY float offSetNum int offsetName char origfile char origin char picoi char previewv char recipe char reqtime float skyAlgorithm char sLevNum int uStepNum int uStepID int uStepName char uStepX float uStepY float wfrtype char amStart float amEnd float esoRaMoon double esoDecMoon double raMoon Geocentric J2000 FK5 Mean Right ascension of the Moon hours double decMoon Geocentric J2000 FK5 Mean Declination of the Moon deg double illumMoon Illumination of the Moon double raMoonTopo Apparent topocentric Right ascension of the Moon (including precession, nutation, and annual aberration) hours double decMoonTopo Apparent topocentric Declination of the Moon (including precession, nutation, and annual aberration) deg double fileName the filename for the multiframe, eg. server:/path/filename.fit char catName the filename of the associated catalogue MEF, eg. server:/path/filename.fits char versionNum a version number for this frame (if available) float darkID long confID long flatID long frinID UID of library calibration fringe frame long skyID long maskID long deprecated Code for a current (=0) or deprecated (!=0) multiframe int newlyIngested Curation flag for internal use only (0=no, 1=yes) int illumFile File name of CASU created photometric illumination correction used on catalogue data from this file char unfilteredID UID of original unfiltered frame corresponding to this filtered frame long casuVers char obStatus char esoGrade char mjdEnd double totalExpTimeSum Total integration time of all exposures (s) --K TEXPSUM float reqMaxAirmass float reqMaxSeeing float reqSkyTrans char containerID long containerType char minMoonDist deg float maxMoonFli float areaID int surveyIDString char maxJitSize arcsec float tileOverlapX arcsec float tileOverlapY arcsec float patternString char tileRa HHMMSS.TTT float tileDec DDMMSS.TTT float tileOffAngle deg float tileIDString char RequiredListDrivenProductContains programmes/surveys required for list-driven co-located photometry programmeID the unique programme ID int tableID the unique ID of the table with the source list driving the remeasurements int surveyID the unique ID of the external survey (if applicable) int transFile CASU list-driven photometry tool option specifying the source of the driving list (e.g. &quot;use=radeclist&quot;) char aperture CASU list-driven photometry tool option specifying the fixed radius to be used for photometry pixels float filterID filterID of the data that the list is driven from. If 0, then take the source list. int extractor CASU list driven or SExtractor dual image mode char AstrCalVersContains a record for every astrometric calibration version in the archive versNum Version number of current astrometric solution int cuEventID UID of curation event giving rise to this record int startDate MJD of the start time for this version of the calibration Julian days double endDate MJD of the end time for this version of the calibration Julian days double videoSourceXtwomass_pscCross-neighbours between video and twomass_psc masterObjID The unique ID in videoSource (=sourceID) long slaveObjID The unique ID of the neighbour in TWOMASS..twomass_psc (=pts_key) long distanceMins Angular separation between neighbours arcminutes float ExternalSurveyA list of all externally produced survey products held in the archive surveyID the unique identifier for the survey int surveyName The short name of the survey, eg. 2MASS, GLIMPSE etc. char databaseName The name of the database within the VSA char description A brief description of the survey char imagesLocation Pathname to the pixels (eg. for list-driven remeasurement) char videoMergeLogContains frame set details of merged VIDEO MultiframeDetector images frameSetID frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure long cuEventID UID of curation event giving rise to this record int ra Right Ascension of field centre deg double dec Declination of field centre deg double cx unit vector of spherical co-ordinates double cy unit vector of spherical co-ordinates double cz unit vector of spherical co-ordinates double htmID Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates long zmfID the UID of the relevant Z multiframe long zeNum the extension number of this Z frame int newZframe new/old flag (1/0) of this detector image int listProcZ Frame has been list processed (0=no; 1=yes) int ymfID the UID of the relevant Y multiframe long yeNum the extension number of this Y frame int newYframe new/old flag (1/0) of this detector image int listProcY Frame has been list processed (0=no; 1=yes) int jmfID the UID of the relevant J multiframe long jeNum the extension number of this J frame int newJframe new/old flag (1/0) of this detector image int listProcJ Frame has been list processed (0=no; 1=yes) int hmfID the UID of the relevant H multiframe long heNum the extension number of this H frame int newHframe new/old flag (1/0) of this detector image int listProcH Frame has been list processed (0=no; 1=yes) int ksmfID the UID of the relevant Ks multiframe long kseNum the extension number of this Ks frame int newKsframe new/old flag (1/0) of this detector image int listProcKs Frame has been list processed (0=no; 1=yes) int mergeSwVersion version number of the software used to merge the frames float newFrameSet Flag used internally by curation applications int deprecated frame set deprecation flag (1=deprecated) int ProductLinksContains links between different products, e.g. tiles and stacks, mosaics and tiles, mosaics and stack programmeID the unique programme ID int combiProductID Product ID of combination frame int intProductID Product ID of intermediate frame int combiProdType Type (stack,tile,mosaic) of combination frame char intProdType Type (stack,tile,mosaic) of intermediate frame char ProgrammeContains details of the VISTA public survey programmes programmeID UID of the archived programme coded as above int title a short title for the programme, eg. &quot;VISTA Hemisphere Survey&quot; char description a concise description of the programme char reference a web reference (URL) for the programme char propPeriod the proprietory period for any data taken for this programme in months, e.g. 12 for open time. months int dfsIDString The description used within the data flow system (i.e. the value of the appropriate FITS keyword) char catalogueSchema Script file that describes the catalogue schema char detectionTable Table name of detections char sourceTable Table name of merged sources char listRemeasTable Table name of individual passband list re-measurements char sourceRemeasTable Table name of co-located list re-measurements char mergeLogTable Table name of curation log for source merging char frameSetTolerance The match tolerance for different passband frames Degrees float pairingCriterion The pairing criterion for associating detections into merged sources Degrees float adjacentFrameTolerance The match tolerance for adjacent frames in the survey Degrees float neighboursSchema Script file that describes the neighbour tables schema for this programme char synopticSourceTable Table name of merged variable sources char synopticBestMatchTable Table name of merged variable sources char variabilityTable Table name of merged variable sources char mosaicTool Name of mosaicing tool to be used char extractTool Name of extraction tool to be used char bandMergingCriterion maximum timespan over which different filters are merged into sources in the synoptic source table. minutes float isLowGalacticLat Is this a low galactic latitude field (No=0/Yes=1) int sourceProdType The product type to be used to create the source table. (stack, tile, mosaic) char epochFrameType The frame type to be used for each epoch (stack, tile) char posAngleTolerance The position angle tolerance used when creating deep stacks and tiles Degrees float synopticSetUp A string describing the synoptic setup for more complicated surveys char PhotCalVersContains details of all photometric calibration versions in the VSA versNum the version number of the calibration int cuEventID UID of curation event giving rise to this record int startDate Date time of start time for this version of the calibration (MM-DD-YYYY) MM-DD-YYYY char endDate Date time of end time for this version of the calibration (MM-DD-YYYY) MM-DD-YYYY char videoTileSetContains tile set details for VIDEO Multiframe paw-print images tileSetID frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure long cuEventID UID of curation event giving rise to this record int ra Right Ascension of field centre deg double dec Declination of field centre deg double cx unit vector of spherical co-ordinates double cy unit vector of spherical co-ordinates double cz unit vector of spherical co-ordinates double htmID Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates long tlmfID the UID of the relevant tile multiframe long o1mfID the UID of the relevant offset O1 multiframe long o2mfID the UID of the relevant offset O2 multiframe long o3mfID the UID of the relevant offset O3 multiframe long o4mfID the UID of the relevant offset O4 multiframe long o5mfID the UID of the relevant offset O5 multiframe long o6mfID the UID of the relevant offset O6 multiframe long mergeSwVersion version number of the software used to merge the frames float newFrameSet Flag used internally by curation applications int deprecated frame set deprecation flag (1=deprecated) int RequiredFiltersContains required filters used for every programme held in the VSA programmeID the unique programme ID int filterID UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) int nPass the number of passes that will be made int isSynoptic is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE) int