AstroGrid DSA/Catalogue

© 2002-2010 AstroGrid

Installation notes

• Welcome page
• Documentation index
• Release notes
• Version information

Self-tests

• Apache Axis self-check
• Initial properties check
• Installation self-test
• CEA interface self-test
• SQL syntax test (SLOW!)

Public metadata

• VOSI resources

Server administration

• Generate template metadoc
• View metadata table
• View server status
• View job database

Service fingerprints

• General service fingerprint
• Axis Webservice WSDLs

Self-query interface

• ADQL/XML query
• Cone search
• Multiple cone-search
• TAP query

Table and column metadata

Table Meta-document for VIKING DR4

Table vikingSource

Contains merged sources from detections in vikingDetection

Column	Type	Units	UCD	Error	Description	Links
sourceID	long				UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm
cuEventID	int		meta.bib		UID of curation event giving rise to this record
frameSetID	long		meta.bib		UID of the set of frames that this merged source comes from
ra	double	deg			Celestial Right Ascension
dec	double	deg			Celestial Declination
cx	double		pos.cartesian.x;pos.eq		unit vector of spherical co-ordinates
cy	double		pos.cartesian.y;pos.eq		unit vector of spherical co-ordinates
cz	double		pos.cartesian.z;pos.eq		unit vector of spherical co-ordinates
htmID	long		pos		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates
l	double	Degrees	pos.galactic.lon		Galactic longitude
b	double	Degrees	pos.galactic.lat		Galactic latitude
lambda	double	Degrees	pos		SDSS system spherical co-ordinate 1
eta	double	Degrees	pos		SDSS system spherical co-ordinate 2
priOrSec	long		meta.code		Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates).
zmyPnt	float	mag	phot.color;em.opt.I;em.IR.NIR		Point source colour Z-Y (using aperMag3)
zmyPntErr	float	mag	stat.error;em.opt.I;em.IR.NIR		Error on point source colour Z-Y
ymjPnt	float	mag	phot.color;em.IR.NIR;em.IR.J		Point source colour Y-J (using aperMag3)
ymjPntErr	float	mag	stat.error;em.IR.NIR;em.IR.J		Error on point source colour Y-J
jmhPnt	float	mag	phot.color;em.IR.J;em.IR.H		Point source colour J-H (using aperMag3)
jmhPntErr	float	mag	stat.error;em.IR.J;em.IR.H		Error on point source colour J-H
hmksPnt	float	mag	phot.color;em.IR.H;em.IR.K		Point source colour H-Ks (using aperMag3)
hmksPntErr	float	mag	stat.error;em.IR.H;em.IR.K		Error on point source colour H-Ks
zmyExt	float	mag	phot.color;em.opt.I;em.IR.NIR		Extended source colour Z-Y (using aperMagNoAperCorr3)
zmyExtErr	float	mag	stat.error;em.opt.I;em.IR.NIR		Error on extended source colour Z-Y
ymjExt	float	mag	phot.color;em.IR.NIR;em.IR.J		Extended source colour Y-J (using aperMagNoAperCorr3)
ymjExtErr	float	mag	stat.error;em.IR.NIR;em.IR.J		Error on extended source colour Y-J
jmhExt	float	mag	phot.color;em.IR.J;em.IR.H		Extended source colour J-H (using aperMagNoAperCorr3)
jmhExtErr	float	mag	stat.error;em.IR.J;em.IR.H		Error on extended source colour J-H
hmksExt	float	mag	phot.color;em.IR.H;em.IR.K		Extended source colour H-Ks (using aperMagNoAperCorr3)
hmksExtErr	float	mag	stat.error;em.IR.H;em.IR.K		Error on extended source colour H-Ks
mergedClassStat	float		stat		Merged N(0,1) stellarness-of-profile statistic
mergedClass	int		meta.code		Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated)
pStar	float		stat		Probability that the source is a star
pGalaxy	float		stat		Probability that the source is a galaxy
pNoise	float		stat		Probability that the source is noise
pSaturated	float		stat		Probability that the source is saturated
eBV	float		phys.absorption.gal		The galactic dust extinction value measured from the Schlegel, Finkbeiner & Davis (1998) maps. This uses the correction given in Bonifacio, Monai & Beers (2000). This correction reduces the extinction value in regions of high extinction (E(B-V)>0.1)
aZ	float	mag	phys.absorption.gal		The galactic extinction correction in the Z band for extragalactic objects
aY	float	mag	phys.absorption.gal		The galactic extinction correction in the Y band for extragalactic objects
aJ	float	mag	phys.absorption.gal		The galactic extinction correction in the J band for extragalactic objects
aH	float	mag	phys.absorption.gal		The galactic extinction correction in the H band for extragalactic objects
aKs	float	mag	phys.absorption.gal		The galactic extinction correction in the Ks band for extragalactic objects
zPetroMag	float	mag	phot.mag;em.opt.I		Extended source Z mag (Petrosian)
zPetroMagErr	float	mag	stat.error;em.opt.I;phot.mag		Error in extended source Z mag (Petrosian)
zPsfMag	float	mag	phot.mag;em.opt.I		Point source profile-fitted Z mag
zPsfMagErr	float	mag	stat.error;em.opt.I;phot.mag		Error in point source profile-fitted Z mag
zSerMag2D	float	mag	phot.mag;em.opt.I		Extended source Z mag (profile-fitted)
zSerMag2DErr	float	mag	stat.error;em.opt.I;phot.mag		Error in extended source Z mag (profile-fitted)
zAperMag3	float	mag	phot.mag;em.opt.I		Default point source Z aperture corrected mag (2.0 arcsec aperture diameter)
zAperMag3Err	float	mag	stat.error;em.opt.I;phot.mag		Error in default point/extended source Z mag (2.0 arcsec aperture diameter)
zAperMag4	float	mag	phot.mag;em.opt.I		Point source Z aperture corrected mag (2.8 arcsec aperture diameter)
zAperMag4Err	float	mag	stat.error;em.opt.I;phot.mag		Error in point/extended source Z mag (2.8 arcsec aperture diameter)
zAperMag6	float	mag	phot.mag;em.opt.I		Point source Z aperture corrected mag (5.7 arcsec aperture diameter)
zAperMag6Err	float	mag	stat.error;em.opt.I;phot.mag		Error in point/extended source Z mag (5.7 arcsec aperture diameter)
zAperMagNoAperCorr3	float	mag	phot.mag;em.opt.I		Default extended source Z aperture mag (2.0 arcsec aperture diameter)
zAperMagNoAperCorr4	float	mag	phot.mag;em.opt.I		Extended source Z aperture mag (2.8 arcsec aperture diameter)
zAperMagNoAperCorr6	float	mag	phot.mag;em.opt.I		Extended source Z aperture mag (5.7 arcsec aperture diameter)
zHlCorSMjRadAs	float	arcsec	phys.angSize;em.opt.I		Seeing corrected half-light, semi-major axis in Z band
zGausig	float	pixels	src.morph.param;em.opt.I		RMS of axes of ellipse fit in Z
zEll	float		src.ellipticity;em.opt.I		1-b/a, where a/b=semi-major/minor axes in Z
zPA	float	Degrees	pos.posAng;em.opt.I		ellipse fit celestial orientation in Z
zErrBits	int		meta.code;em.opt.I		processing warning/error bitwise flags in Z
zAverageConf	float		stat.likelihood;em.opt.I		average confidence in 2 arcsec diameter default aperture (aper3) Z
zClass	int		src.class;em.opt.I		discrete image classification flag in Z
zClassStat	float		stat;em.opt.I		N(0,1) stellarness-of-profile statistic in Z
zppErrBits	int		meta.code;em.opt.I		additional WFAU post-processing error bits in Z
zSeqNum	int		meta.number;em.opt.I		the running number of the Z detection
zXi	float	arcsec	pos.eq.ra;arith.diff;em.opt.I		Offset of Z detection from master position (+east/-west)
zEta	float	arcsec	pos.eq.dec;arith.diff;em.opt.I		Offset of Z detection from master position (+north/-south)
yPetroMag	float	mag	phot.mag;em.IR.NIR		Extended source Y mag (Petrosian)
yPetroMagErr	float	mag	stat.error;em.IR.NIR;phot.mag		Error in extended source Y mag (Petrosian)
yPsfMag	float	mag	phot.mag;em.IR.NIR		Point source profile-fitted Y mag
yPsfMagErr	float	mag	stat.error;em.IR.NIR;phot.mag		Error in point source profile-fitted Y mag
ySerMag2D	float	mag	phot.mag;em.IR.NIR		Extended source Y mag (profile-fitted)
ySerMag2DErr	float	mag	stat.error;em.IR.NIR;phot.mag		Error in extended source Y mag (profile-fitted)
yAperMag3	float	mag	phot.mag;em.IR.NIR		Default point source Y aperture corrected mag (2.0 arcsec aperture diameter)
yAperMag3Err	float	mag	stat.error;em.IR.NIR;phot.mag		Error in default point/extended source Y mag (2.0 arcsec aperture diameter)
yAperMag4	float	mag	phot.mag;em.IR.NIR		Point source Y aperture corrected mag (2.8 arcsec aperture diameter)
yAperMag4Err	float	mag	stat.error;em.IR.NIR;phot.mag		Error in point/extended source Y mag (2.8 arcsec aperture diameter)
yAperMag6	float	mag	phot.mag;em.IR.NIR		Point source Y aperture corrected mag (5.7 arcsec aperture diameter)
yAperMag6Err	float	mag	stat.error;em.IR.NIR;phot.mag		Error in point/extended source Y mag (5.7 arcsec aperture diameter)
yAperMagNoAperCorr3	float	mag	phot.mag;em.IR.NIR		Default extended source Y aperture mag (2.0 arcsec aperture diameter)
yAperMagNoAperCorr4	float	mag	phot.mag;em.IR.NIR		Extended source Y aperture mag (2.8 arcsec aperture diameter)
yAperMagNoAperCorr6	float	mag	phot.mag;em.IR.NIR		Extended source Y aperture mag (5.7 arcsec aperture diameter)
yHlCorSMjRadAs	float	arcsec	phys.angSize;em.IR.NIR		Seeing corrected half-light, semi-major axis in Y band
yGausig	float	pixels	src.morph.param;em.IR.NIR		RMS of axes of ellipse fit in Y
yEll	float		src.ellipticity;em.IR.NIR		1-b/a, where a/b=semi-major/minor axes in Y
yPA	float	Degrees	pos.posAng;em.IR.NIR		ellipse fit celestial orientation in Y
yErrBits	int		meta.code;em.IR.NIR		processing warning/error bitwise flags in Y
yAverageConf	float		stat.likelihood;em.IR.NIR		average confidence in 2 arcsec diameter default aperture (aper3) Y
yClass	int		src.class;em.IR.NIR		discrete image classification flag in Y
yClassStat	float		stat;em.IR.NIR		N(0,1) stellarness-of-profile statistic in Y
yppErrBits	int		meta.code;em.IR.NIR		additional WFAU post-processing error bits in Y
ySeqNum	int		meta.number;em.IR.NIR		the running number of the Y detection
yXi	float	arcsec	pos.eq.ra;arith.diff;em.IR.NIR		Offset of Y detection from master position (+east/-west)
yEta	float	arcsec	pos.eq.dec;arith.diff;em.IR.NIR		Offset of Y detection from master position (+north/-south)
jPetroMag	float	mag	phot.mag;em.IR.J		Extended source J mag (Petrosian)
jPetroMagErr	float	mag	stat.error;em.IR.J;phot.mag		Error in extended source J mag (Petrosian)
jPsfMag	float	mag	phot.mag;em.IR.J		Point source profile-fitted J mag
jPsfMagErr	float	mag	stat.error;em.IR.J;phot.mag		Error in point source profile-fitted J mag
jSerMag2D	float	mag	phot.mag;em.IR.J		Extended source J mag (profile-fitted)
jSerMag2DErr	float	mag	stat.error;em.IR.J;phot.mag		Error in extended source J mag (profile-fitted)
jAperMag3	float	mag	phot.mag;em.IR.J		Default point source J aperture corrected mag (2.0 arcsec aperture diameter)
jAperMag3Err	float	mag	stat.error;em.IR.J;phot.mag		Error in default point/extended source J mag (2.0 arcsec aperture diameter)
jAperMag4	float	mag	phot.mag;em.IR.J		Point source J aperture corrected mag (2.8 arcsec aperture diameter)
jAperMag4Err	float	mag	stat.error;em.IR.J;phot.mag		Error in point/extended source J mag (2.8 arcsec aperture diameter)
jAperMag6	float	mag	phot.mag;em.IR.J		Point source J aperture corrected mag (5.7 arcsec aperture diameter)
jAperMag6Err	float	mag	stat.error;em.IR.J;phot.mag		Error in point/extended source J mag (5.7 arcsec aperture diameter)
jAperMagNoAperCorr3	float	mag	phot.mag;em.IR.J		Default extended source J aperture mag (2.0 arcsec aperture diameter)
jAperMagNoAperCorr4	float	mag	phot.mag;em.IR.J		Extended source J aperture mag (2.8 arcsec aperture diameter)
jAperMagNoAperCorr6	float	mag	phot.mag;em.IR.J		Extended source J aperture mag (5.7 arcsec aperture diameter)
jHlCorSMjRadAs	float	arcsec	phys.angSize;em.IR.J		Seeing corrected half-light, semi-major axis in J band
jGausig	float	pixels	src.morph.param;em.IR.J		RMS of axes of ellipse fit in J
jEll	float		src.ellipticity;em.IR.J		1-b/a, where a/b=semi-major/minor axes in J
jPA	float	Degrees	pos.posAng;em.IR.J		ellipse fit celestial orientation in J
jErrBits	int		meta.code;em.IR.J		processing warning/error bitwise flags in J
jAverageConf	float		stat.likelihood;em.IR.J		average confidence in 2 arcsec diameter default aperture (aper3) J
jClass	int		src.class;em.IR.J		discrete image classification flag in J
jClassStat	float		stat;em.IR.J		N(0,1) stellarness-of-profile statistic in J
jppErrBits	int		meta.code;em.IR.J		additional WFAU post-processing error bits in J
jSeqNum	int		meta.number;em.IR.J		the running number of the J detection
jXi	float	arcsec	pos.eq.ra;arith.diff;em.IR.J		Offset of J detection from master position (+east/-west)
jEta	float	arcsec	pos.eq.dec;arith.diff;em.IR.J		Offset of J detection from master position (+north/-south)
hPetroMag	float	mag	phot.mag;em.IR.H		Extended source H mag (Petrosian)
hPetroMagErr	float	mag	stat.error;em.IR.H;phot.mag		Error in extended source H mag (Petrosian)
hPsfMag	float	mag	phot.mag;em.IR.H		Point source profile-fitted H mag
hPsfMagErr	float	mag	stat.error;em.IR.H;phot.mag		Error in point source profile-fitted H mag
hSerMag2D	float	mag	phot.mag;em.IR.H		Extended source H mag (profile-fitted)
hSerMag2DErr	float	mag	stat.error;em.IR.H;phot.mag		Error in extended source H mag (profile-fitted)
hAperMag3	float	mag	phot.mag;em.IR.H		Default point source H aperture corrected mag (2.0 arcsec aperture diameter)
hAperMag3Err	float	mag	stat.error;em.IR.H;phot.mag		Error in default point/extended source H mag (2.0 arcsec aperture diameter)
hAperMag4	float	mag	phot.mag;em.IR.H		Point source H aperture corrected mag (2.8 arcsec aperture diameter)
hAperMag4Err	float	mag	stat.error;em.IR.H;phot.mag		Error in point/extended source H mag (2.8 arcsec aperture diameter)
hAperMag6	float	mag	phot.mag;em.IR.H		Point source H aperture corrected mag (5.7 arcsec aperture diameter)
hAperMag6Err	float	mag	stat.error;em.IR.H;phot.mag		Error in point/extended source H mag (5.7 arcsec aperture diameter)
hAperMagNoAperCorr3	float	mag	phot.mag;em.IR.H		Default extended source H aperture mag (2.0 arcsec aperture diameter)
hAperMagNoAperCorr4	float	mag	phot.mag;em.IR.H		Extended source H aperture mag (2.8 arcsec aperture diameter)
hAperMagNoAperCorr6	float	mag	phot.mag;em.IR.H		Extended source H aperture mag (5.7 arcsec aperture diameter)
hHlCorSMjRadAs	float	arcsec	phys.angSize;em.IR.H		Seeing corrected half-light, semi-major axis in H band
hGausig	float	pixels	src.morph.param;em.IR.H		RMS of axes of ellipse fit in H
hEll	float		src.ellipticity;em.IR.H		1-b/a, where a/b=semi-major/minor axes in H
hPA	float	Degrees	pos.posAng;em.IR.H		ellipse fit celestial orientation in H
hErrBits	int		meta.code;em.IR.H		processing warning/error bitwise flags in H
hAverageConf	float		stat.likelihood;em.IR.H		average confidence in 2 arcsec diameter default aperture (aper3) H
hClass	int		src.class;em.IR.H		discrete image classification flag in H
hClassStat	float		stat;em.IR.H		N(0,1) stellarness-of-profile statistic in H
hppErrBits	int		meta.code;em.IR.H		additional WFAU post-processing error bits in H
hSeqNum	int		meta.number;em.IR.H		the running number of the H detection
hXi	float	arcsec	pos.eq.ra;arith.diff;em.IR.H		Offset of H detection from master position (+east/-west)
hEta	float	arcsec	pos.eq.dec;arith.diff;em.IR.H		Offset of H detection from master position (+north/-south)
ksPetroMag	float	mag	phot.mag;em.IR.K		Extended source Ks mag (Petrosian)
ksPetroMagErr	float	mag	stat.error;em.IR.K;phot.mag		Error in extended source Ks mag (Petrosian)
ksPsfMag	float	mag	phot.mag;em.IR.K		Point source profile-fitted Ks mag
ksPsfMagErr	float	mag	stat.error;em.IR.K;phot.mag		Error in point source profile-fitted Ks mag
ksSerMag2D	float	mag	phot.mag;em.IR.K		Extended source Ks mag (profile-fitted)
ksSerMag2DErr	float	mag	stat.error;em.IR.K;phot.mag		Error in extended source Ks mag (profile-fitted)
ksAperMag3	float	mag	phot.mag;em.IR.K		Default point source Ks aperture corrected mag (2.0 arcsec aperture diameter)
ksAperMag3Err	float	mag	stat.error;em.IR.K;phot.mag		Error in default point/extended source Ks mag (2.0 arcsec aperture diameter)
ksAperMag4	float	mag	phot.mag;em.IR.K		Point source Ks aperture corrected mag (2.8 arcsec aperture diameter)
ksAperMag4Err	float	mag	stat.error;em.IR.K;phot.mag		Error in point/extended source Ks mag (2.8 arcsec aperture diameter)
ksAperMag6	float	mag	phot.mag;em.IR.K		Point source Ks aperture corrected mag (5.7 arcsec aperture diameter)
ksAperMag6Err	float	mag	stat.error;em.IR.K;phot.mag		Error in point/extended source Ks mag (5.7 arcsec aperture diameter)
ksAperMagNoAperCorr3	float	mag	phot.mag;em.IR.K		Default extended source Ks aperture mag (2.0 arcsec aperture diameter)
ksAperMagNoAperCorr4	float	mag	phot.mag;em.IR.K		Extended source Ks aperture mag (2.8 arcsec aperture diameter)
ksAperMagNoAperCorr6	float	mag	phot.mag;em.IR.K		Extended source Ks aperture mag (5.7 arcsec aperture diameter)
ksHlCorSMjRadAs	float	arcsec	phys.angSize;em.IR.K		Seeing corrected half-light, semi-major axis in Ks band
ksGausig	float	pixels	src.morph.param;em.IR.K		RMS of axes of ellipse fit in Ks
ksEll	float		src.ellipticity;em.IR.K		1-b/a, where a/b=semi-major/minor axes in Ks
ksPA	float	Degrees	pos.posAng;em.IR.K		ellipse fit celestial orientation in Ks
ksErrBits	int		meta.code;em.IR.K		processing warning/error bitwise flags in Ks
ksAverageConf	float		stat.likelihood;em.IR.K		average confidence in 2 arcsec diameter default aperture (aper3) Ks
ksClass	int		src.class;em.IR.K		discrete image classification flag in Ks
ksClassStat	float		stat;em.IR.K		N(0,1) stellarness-of-profile statistic in Ks
ksppErrBits	int		meta.code;em.IR.K		additional WFAU post-processing error bits in Ks
ksSeqNum	int		meta.number;em.IR.K		the running number of the Ks detection
ksXi	float	arcsec	pos.eq.ra;arith.diff;em.IR.K		Offset of Ks detection from master position (+east/-west)
ksEta	float	arcsec	pos.eq.dec;arith.diff;em.IR.K		Offset of Ks detection from master position (+north/-south)

Table vikingDetection

Contains the individual VIKING source detections for each frame

Column	Type	Units	UCD	Error	Description	Links
multiframeID	long		meta.id;obs.field		the UID of the relevant multiframe
extNum	int		meta.number		the extension number of this frame
cuEventID	int		meta.bib		UID of curation event giving rise to this record
seqNum	int		meta.number
filterID	int		meta.code;instr.filter		UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks,8=blank)
isoFlux	float	ADU	phot.count
isoMag	float	mag	phot.mag		Calibrated isophotal magnitude
x	float	pixels	pos.cartesian.x;instr.plate
xErr	float	pixels	stat.error
y	float	pixels	pos.cartesian.y;instr.plate
yErr	float	pixels	stat.error
gauSig	float	pixels	src.morph.param
ell	float		src.ellipticity
pa	float	deg	pos.posAng
aProf1	float	pixels	meta.number
aProf2	int	pixels	meta.number
aProf3	int	pixels	meta.number
aProf4	int	pixels	meta.number
aProf5	int	pixels	meta.number
aProf6	int	pixels	meta.number
aProf7	int	pixels	meta.number
aProf8	int	pixels	meta.number
pHeight	float	ADU	phot.count
pHeightErr	float	ADU	stat.error
aperFlux1	float	ADU	phot.count
aperFlux1err	float	ADU	stat.error
aperMagNoAperCorr1	float	mag	phot.mag		Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1
aperMag1	float	mag	phot.mag		Calibrated and corrected aperture magnitude 1
aperMag1err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 1
aperFlux2	float	ADU	phot.count
aperFlux2err	float	ADU	stat.error
aperMagNoAperCorr2	float	mag	phot.mag		Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1
aperMag2	float	mag	phot.mag		Calibrated and corrected aperture magnitude 2
aperMag2err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 2
aperFlux3	float	ADU	phot.count
aperFlux3err	float	ADU	stat.error
aperMagNoAperCorr3	float	mag	phot.mag		Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1
aperMag3	float	mag	phot.mag		Calibrated and corrected aperture magnitude 3. aperMag3 has also a saturation correction applied for saturated stars.
aperMag3err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 3
aperFlux4	float	ADU	phot.count
aperFlux4err	float	ADU	stat.error
aperMagNoAperCorr4	float	mag	phot.mag		Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1
aperMag4	float	mag	phot.mag		Calibrated and corrected aperture magnitude 4
aperMag4err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 4
aperFlux5	float	ADU	phot.count
aperFlux5err	float	ADU	stat.error
aperMagNoAperCorr5	float	mag	phot.mag		Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1
aperMag5	float	mag	phot.mag		Calibrated and corrected aperture magnitude 5
aperMag5err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 5
aperFlux6	float	ADU	phot.count
aperFlux6err	float	ADU	stat.error
aperMagNoAperCorr6	float	mag	phot.mag		Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1
aperMag6	float	mag	phot.mag		Calibrated and corrected aperture magnitude 6
aperMag6err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 6
aperFlux7	float	ADU	phot.count
aperFlux7err	float	ADU	stat.error
aperMagNoAperCorr7	float	mag	phot.mag		Calibrated and standard corrected (but no aperture correction applied) aperture magnitude 1
aperMag7	float	mag	phot.mag		Calibrated and corrected aperture magnitude 7
aperMag7err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 7
aperFlux8	float	ADU	phot.count
aperFlux8err	float	ADU	stat.error
aperMag8	float	mag	phot.mag		Calibrated and corrected aperture magnitude 8. No aperture correction applied since it is 0.
aperMag8err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 8
aperFlux9	float	ADU	phot.count
aperFlux9err	float	ADU	stat.error
aperMag9	float	mag	phot.mag		Calibrated and corrected aperture magnitude 9. No aperture correction applied since it is 0.
aperMag9err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 9
aperFlux10	float	ADU	phot.count
aperFlux10err	float	ADU	stat.error
aperMag10	float	mag	phot.mag		Calibrated and corrected aperture magnitude 10. No aperture correction applied since it is 0.
aperMag10err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 10
aperFlux11	float	ADU	phot.count
aperFlux11err	float	ADU	stat.error
aperMag11	float	mag	phot.mag		Calibrated and corrected aperture magnitude 11. No aperture correction applied since it is 0.
aperMag11err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 11
aperFlux12	float	ADU	phot.count
aperFlux12err	float	ADU	stat.error
aperMag12	float	mag	phot.mag		Calibrated and corrected aperture magnitude 12. No aperture correction applied since it is 0.
aperMag12err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 12
aperFlux13	float	ADU	phot.count
aperFlux13err	float	ADU	stat.error
aperMag13	float	mag	phot.mag		Calibrated and corrected aperture magnitude 13. No aperture correction applied since it is 0.
aperMag13err	float	mag	stat.error;phot.mag		Error in calibrated aperture magnitude 13
petroRad	float	pixels	phys.angSize
kronRad	float	pixels	phys.angSize
halfRad	float	pixels	phys.angSize
hlCircRadAs	float	arcsec	phys.angSize		Circular half-light radius computed from curve of growth assuming petrosian flux is 90% of total
hlCircRadErrAs	float	arcsec	phys.angSize		Error in hlCircRadAs
hlGeoRadAs	float	arcsec	phys.angSize		Geometric half-light radius
hlSMnRadAs	float	arcsec	phys.angSize.sminAxis		Half-light semi-minor axis
hlSMjRadAs	float	arcsec	phys.angSize.smajAxis		Half-light semi-major axis
hlCorSMnRadAs	float	arcsec	phys.angSize.sminAxis		Seeing corrected Half-light semi-minor axis
hlCorSMjRadAs	float	arcsec	phys.angSize.smajAxis		Seeing corrected Half-light semi-major axis
petroFlux	float	ADU	phot.count
petroFluxErr	float	ADU	stat.error
petroMag	float	mag	phot.mag		Calibrated Petrosian magnitude within circular aperture r_p
petroMagErr	float	mag	stat.error;phot.mag		error on calibrated Petrosian magnitude
kronFlux	float	ADU	phot.count
kronFluxErr	float	ADU	stat.error
kronMag	float	mag	phot.mag		Calibrated Kron magnitude within circular aperture r_k
kronMagErr	float	mag	stat.error;phot.mag		error on calibrated Kron magnitude
halfFlux	float	ADU	phot.count
halfFluxErr	float	ADU	stat.error
halfMag	float	mag	phot.mag		Calibrated magnitude within circular aperture halfRad
halfMagErr	float	mag	stat.error;phot.mag		Calibrated error on Half magnitude
errBits	int		meta.code
sky	float	ADU	instr.skyLevel
skyVar	float	ADU	instr.skyLevel
averageConf	float		stat.likelihood
mjd	double	day	time.epoch
ra	double	deg			Celestial Right Ascension
dec	double	deg			Celestial Declination
cx	double		pos.cartesian.x;pos.eq		unit vector of spherical co-ordinates
cy	double		pos.cartesian.y;pos.eq		unit vector of spherical co-ordinates
cz	double		pos.cartesian.z;pos.eq		unit vector of spherical co-ordinates
htmID	long		pos		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates
l	double	Degrees	pos.galactic.lon		Galactic longitude
b	double	Degrees	pos.galactic.lat		Galactic latitude
lambda	double	Degrees	pos		SDSS system spherical co-ordinate 1
eta	double	Degrees	pos		SDSS system spherical co-ordinate 2
class	int		src.class
classStat	float		stat
psfFlux	float	ADU	phot.count
psfFluxErr	float	ADU	stat.error
psfMag	float	mag	stat.fit.param;phot.mag		PSF-fitted calibrated magnitude
psfMagErr	float	mag	stat.error;phot.mag		Error on PSF-fitted calibrated magnitude
psfFitX	float	pixels	pos.cartesian.x;instr.plate
psfFitXerr	float	pixels	stat.error
psfFitY	float	pixels	pos.cartesian.y;instr.plate
psfFitYerr	float	pixels	stat.error
psfFitChi2	float		stat.stdev
psfFitDof	int		stat.fit.dof
SerFlux1D	float	ADU	phot.count
SerMag1D	float	mag	stat.fit.param;phot.mag		Calibrated 1D Sersic flux
SerScaleLen1D	float		stat.fit.param
SerIdx1D	float		stat.fit.param
SerFit1DChi2	float		stat.fit.param
SerFitNu1D	float		stat.fit.dof
SerFlux2D	float	ADU	phot.count
SerMag2D	float	mag	stat.fit.param;phot.mag		Calibrated 2D Sersic flux
SerScaleLen2D	float		stat.fit.param
SerIdx2D	float		stat.fit.param
SerFit2DChi2	float		stat.fit.param
SerFitNu2D	float		stat.fit.dof
deltaMag	float		stat.param;phot.mag		sum of magnitude corrections for faster processing
illumCorr	float		stat.fit		illumination correction
distortCorr	float		stat.fit.param		distortion correction
saturatCorr	float		stat.param		saturation correction
ppErrBits	int		meta.code		additional WFAU post-processing error bits
deprecated	int		meta.code		Code for a current (=0) or deprecated (!=0) detection
objID	long				Unique identifier for this detection or default for no detection

Table ArchiveCurationHistory

Contains details of the matrix of the Archives' required curation tasks

Column	Type	Units	UCD	Error	Description	Links
cuEventID	int		meta.bib		UID of curation event giving rise to this record
cuID	int		meta.bib		the unique curation task ID
logFile	string		meta.id;meta.file		filename of verbose logged task output
resultsFile	string		meta.id;meta.file		filename of any results file
timeStamp	dateTime	UTC	time.epoch		Time of the completion of the whole task
curator	string		??		The archive curation scientist responsible for this event
comment	string		??		Comment string supplied by the curator
rolledBack	int		??		Flag for roll-back of this event: 0=no, 1 = yes

Table AstrCalVers

Contains a record for every astrometric calibration version in the archive

Column	Type	Units	UCD	Error	Description	Links
versNum	int		meta.software		Version number of current astrometric solution
cuEventID	int		meta.bib		UID of curation event giving rise to this record
startDate	double	Julian days	time.epoch		MJD of the start time for this version of the calibration
endDate	double	Julian days	time.epoch		MJD of the end time for this version of the calibration

Table CurationTask

Contains a list of all curation tasks that are used within the VSA

Column	Type	Units	UCD	Error	Description	Links
cuID	int		meta.bib		the unique curation task ID
description	string		meta.note		description in words for this task

Table CurrentAstrometry

Contains the current astrometric calibration coefficients

Column	Type	Units	UCD	Error	Description	Links
multiframeID	long		obs.field		the UID of the relevant multiframe
extNum	int		meta.number		the extension number of this frame
cuEventID	int		meta.bib		UID of curation event giving rise to this record
cTypeX	string		pos.eq.ra;meta.main
cTypeY	string		pos.eq.dec;meta.main
crValX	double		pos.cartesian.x;instr.det
crValY	double		pos.cartesian.y;instr.det
crUnit1	string
crUnit2	string
crPixX	double	pixels	pos.cartesian.x;instr.det
crPixY	double	pixels	pos.cartesian.y;instr.det
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	string
tctyp5	string
tv51	double
tv52	double
tv53	double
tv54	double
tv55	double
wcsPass	int
numRms	int		stat.fit.param
stdCRms	double		stat.fit.residual
refRaShift01	double	arcsec	??
refDecShift01	double	arcsec	??
refRaShift02	double	arcsec	??
refDecShift02	double	arcsec	??
refRaShift12	double	arcsec	??
refDecShift12	double	arcsec	??
refRaShift22	double	arcsec	??
refDecShift22	double	arcsec	??
distortMap	string		meta.id;meta.file		filename of 2d non-linear distortion map
centralRa	double	Degrees	pos.eq.ra;meta.main		RA (J2000) at device centre
centralDec	double	Degrees	pos.eq.dec;meta.main		Dec (J2000) at device centre
cx	double		pos.distance;pos.cartesian.x		unit vector of spherical co-ordinates of device centre
cy	double		pos.distance;pos.cartesian.y		unit vector of spherical co-ordinates of device centre
cz	double		pos.distance;pos.cartesian.z		unit vector of spherical co-ordinates of device centre
htmID	long		pos.eq		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates of device centre
posAngle	double	Degrees	pos.posAng		orientation of image x-axis to N-S
l	double	Degrees	pos.galactic.lon		Galactic longitude of device centre
b	double	Degrees	pos.galactic.lat		Galactic latitude of device centre
lambda	double	Degrees	pos		SDSS system spherical co-ordinate 1 of device centre
eta	double	Degrees	pos		SDSS system spherical co-ordinate 2 of device centre
imageExtent	float	Arcminutes	pos.angDistance		The maximum angular extent from the central position
minRa	double	Degrees	pos.eq.ra		The minimum RA (J2000) on the device
minDec	double	Degrees	pos.eq.dec;meta.main		The minimum Dec (J2000) on the device
maxRa	double	Degrees	pos.eq.ra		The maximum RA (J2000) on the device
maxDec	double	Degrees	pos.eq.dec;meta.main		The maximum Dec (J2000) on the device
xPixSize	float	Arcseconds	pos.angDistance		Angular size of pixels in X
yPixSize	float	Arcseconds	pos.angDistance		Angular size of pixels in Y

Table ExternalProduct

Contains details of external products imported into archiv

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
productType	string		??		The product type within the imported directory
description	string		??		Description of the product set
institution	string		??		Name of the institution that created the product
creator	string		??		Name of the individual that created the product
releaseNum	int				Release number of deep stack frame (or intermediate stack if used as a deep stack).
directory	string				Name of directory which these data reside in
fileNameRoot	string				File name root of the products
zeroPoint	float				Zeropoint of each product
zpSystem	string				System of zeropoint (Vega/AB)
sqlSchemaFile	string				Relative path of the schema file containing the table description that the data will be ingested into if necessary
tableName	string				Name of the table that the data will be ingested into if necessary
sourceMatched	int				Does the main ID of the table have an exact 1 - 1 match with the source table
reference	string				Reference paper describing the data

Table ExternalProductCatalogue

Contains original files importe

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
productType	string		??		The product type within the imported directory
fieldID	string		meta.id		ID of field
fileName	string				Filename of file sent from survey team
versNum	int				Version of file sent from survey team
isIngested	int				Has been ingested? 0 NO 1 Yes
centralRa	double	Central right-ascension of field -/U deg
centralDec	double	Central declination of field -/U deg

Table ExternalSurvey

A list of all externally produced survey products held in the archive

Column	Type	Units	UCD	Error	Description	Links
surveyID	int		meta.id		the unique identifier for the survey
surveyName	string		??		The short name of the survey, eg. 2MASS, GLIMPSE etc.
databaseName	string		meta.id;meta.dataset		The name of the database within the VSA
description	string		meta.note		A brief description of the survey
imagesLocation	string		??		Pathname to the pixels (eg. for list-driven remeasurement)

Table ExternalSurveyTable

Contains information about the external surveys tables

Column	Type	Units	UCD	Error	Description	Links
surveyID	int		meta.id		the unique identifier for the survey
extTableID	int		meta.id;meta.main		the unique table ID
extTableName	string		meta.id;meta.dataset		the name of the table
sourceIDName	string		meta.id		The source unique identifier in the table
coord1	string		??		The attribute name of the first (longitudinal) spherical co-ordinate, e.g. equatorial RA
coord2	string		??		The attribute name of the second (latitudinal) spherical co-ordinate, e.g. equatorial Dec

Table Filter

Contains details of the VISTA infrared camera filters

Column	Type	Units	UCD	Error	Description	Links
filterID	int		meta.code;instr.filter		UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks)
shortName	string		??		Short identification name for the filter
name	string		meta.note		The name of the filter, eg. "MKO J", "K short" etc.
description	string		meta.note		a concise description of the filter
cutOn	float	microns	??		The 50% cut-on wavelength of the filter
cutOff	float	microns	??		The 50% cut-off wavelength of the filter
aebv	float				The constant to multiply the Schlegel map E(B-V) by to get the total galactic extinction.
vegaToAB	float	mag			The constant to convert Vega magnitudes to AB magnitudes.
oneSecMLVg	float	mag			The Vega magnitude limit of a 1s exposure in this filter
isSectioned	int				Is the focal plane sectioned into different filters, 0 No, 1 Yes. If so, data for each section in FilterSections and SectionDetectors
filterType	string				The type of filter BROAD, NARROW, BROADLIST

Table FilterSections

Contains details of the different sections of sectioned OMEGACAM filters

Column	Type	Units	UCD	Error	Description	Links
filterID	int		meta.code;instr.filter		UID of combined filter (assigned in OSA: 1=u,2=g,3=r,4=i,5=z,6=blank)
sectionID	int				UID of section of focal plane with different filter
shortName	string		??		Short identification name for the filter section
cutOn	float	microns	??		The 50% cut-on wavelength of the filter
cutOff	float	microns	??		The 50% cut-off wavelength of the filter
aebv	float				The constant to multiply the Schlegel map E(B-V) by to get the total galactic extinction.
vegaToAB	float	mag			The constant to convert Vega magnitudes to AB magnitudes.
oneSecMLVg	float	mag			The Vega magnitude limit of a 1s exposure in this filter

Table Multiframe

Contains details of all multiframes stored in the archive

Column	Type	Units	UCD	Error	Description	Links
multiframeID	long		obs.field		UID of the multiframe (assigned sequentially by the archive ingest process)
vistaRunNo	int		meta.bib		Original VISTA run number (from filename)
creationDate	dateTime	MM-DD-YYYY	time.epoch
frameType	string		meta.code.class		The type of multiframe (e.g. stack|tile|mosaic etc.)
cuEventID	int		meta.bib		UID of curation event giving rise to this record
julianDayNum	int	Julian days	time.epoch		The Julian Day number of the VISTA night
fileTimeStamp	long		??		Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness
filterName	string		??
filterID	int		meta.code;instr.filter		UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks)
project	string		meta.bib		Time-allocation code
telescope	string
instrument	string
arcfile	string
utDate	dateTime	MM-DD-YYYY	time.epoch		Observation date (MM-DD-YYYY)
dateObs	dateTime		time.epoch
mjdObs	double		time.epoch
equinox	float	years	time.equinox
lst	float
utc	float
raBase	double	hours	pos.eq.ra;meta.main
decBase	double	deg	pos.eq.dec;meta.main
raDecSys	string
expTime	float	seconds	time.duration;obs.exposure
jitterID	int
jitterX	float
jitterY	float
grpNum	int
tileNum	int
jitterName	string
masktype	int
naxis	int
njitter	int
noffsets	int
nuStep	int
object	string
observer	string
numDetectors	int		??		The number of "detectors" (=image extensions in FITS file)
obsNum	int
obstype	string
offsetID	int
offsetX	float
offsetY	float
offSetNum	int
offsetName	string
origfile	string
origin	string
picoi	string
previewv	string
recipe	string
reqtime	float
skyAlgorithm	string
sLevNum	int
uStepNum	int
uStepID	int
uStepName	string
uStepX	float
uStepY	float
wfrtype	string
amStart	float		obs.airMass
amEnd	float		obs.airMass
esoRaMoon	double		pos.eq.ra;meta.main
esoDecMoon	double		pos.eq.dec;meta.main
raMoon	double	hours	pos.eq.ra;meta.main		Geocentric J2000 FK5 Mean Right ascension of the Moon
decMoon	double	deg	pos.eq.dec;meta.main		Geocentric J2000 FK5 Mean Declination of the Moon
illumMoon	double		??		Illumination of the Moon
raMoonTopo	double	hours	pos.eq.ra;meta.main		Apparent topocentric Right ascension of the Moon (including precession, nutation, and annual aberration)
decMoonTopo	double	deg	pos.eq.dec;meta.main		Apparent topocentric Declination of the Moon (including precession, nutation, and annual aberration)
fileName	string		meta.id;meta.file		the filename for the multiframe, eg. server:/path/filename.fit
catName	string		meta.id;meta.dataset		the filename of the associated catalogue MEF, eg. server:/path/filename.fits
versionNum	string		meta.id		a version number for this frame (if available)
darkID	long		obs.field
confID	long		obs.field
flatID	long		obs.field
frinID	long		obs.field		UID of library calibration fringe frame
skyID	long		obs.field
maskID	long		obs.field
deprecated	int		meta.code		Code for a current (=0) or deprecated (!=0) multiframe
newlyIngested	int		??		Curation flag for internal use only (0=no, 1=yes)
illumFile	string				File name of CASU created photometric illumination correction used on catalogue data from this file
unfilteredID	long		obs.field		UID of original unfiltered frame corresponding to this filtered frame
casuVers	string		meta.id
obStatus	string		??
esoGrade	string		??
mjdEnd	double		time.epoch
totalExpTimeSum	float				Total integration time of all exposures (s) --K TEXPSUM
reqMaxAirmass	float
reqMaxSeeing	float
reqSkyTrans	string
containerID	long
containerType	string
minMoonDist	float	deg
maxMoonFli	float
areaID	int
surveyIDString	string
maxJitSize	float	arcsec
tileOverlapX	float	arcsec
tileOverlapY	float	arcsec
patternString	string
tileRa	float	HHMMSS.TTT
tileDec	float	DDMMSS.TTT
tileOffAngle	float	deg
tileIDString	string

Table MultiframeDetector

Contains details of individual detector frames that are part of a multiframe

Column	Type	Units	UCD	Error	Description	Links
multiframeID	long		obs.field		the UID of the relevant multiframe
extNum	int		meta.number		the extension number of this frame
cuEventID	int		meta.bib		UID of curation event giving rise to this record
compFile	string		meta.id;meta.file		Filename of the compressed image of this image frame, eg. server:/path/filename.jpg
julianDayNum	int	Julian days	time.epoch
camNum	int		obs.field
deviceID	string		obs.field
filterID	int		meta.code;instr.filter
runID	string		meta.id;meta.file
creationDate	dateTime	MM-DD-YYYY:hh:mm:ss.sss	??
imageExtName	string		??
bitsPerPix	int	FITS bitpix	meta.number
dataScale	float
dataZero	float
numAxes	int		meta.number		Number of data axes; eg. 2
axis1Length	int		meta.number
axis2Length	int		meta.number
imagePcount	int		meta.number
imageGcount	int		meta.number
detectorType	string
detRows	int
detCols	int
CIRMED	float
CIR_BVAR	float
cirVers	string
ditherOffsetX	float		pos;arith.diff
ditherOffsetY	float		pos;arith.diff
lincor	string
nbad	int
nditcor	int
nCombine	int
groutedFlag	int
destripe	int
strprms	float
tpaoff	float
tpdoff	float
tpnmatch	int
skyCorrExt	float		??
extinctionExt	float	mags	??
skyCorrCat	float		??
photZPCat	float	mags	??
photZPErrCat	float	mags	??
extinctionCat	float	mags	??
numZPCat	int
nightZPCat	float	mags	??
nightZPErrCat	float	mags	??
nightZPNum	int	mags	??
medPa	float
nbsize	int
tableExtName	string		??
tableWidth	int	bytes	??
tableRows	int		??
tablePcount	int		??
tableGcount	int		??
tableFields	int		??
catCreationDate	dateTime	MM-DD-YYYY:hh:mm:ss.sss	??
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	float	counts/pixel	??
skyNoise	float	counts	??
seeing	float	pixels	??
avStellarEll	float		src.ellipticity
avSaturLevel	float
thresholdIsoph	float
deprecated	int		meta.code		Code for a current (=0) or deprecated (!=0) multiframe detector
decurtainRange	float		??
skySubScale	double		??
morphClassFlag	int		meta.code
smoothing	float	pixels
totalExpTime	float	seconds			Total exposure time for this detector
dribble	string
gainCor	float
templRotation	float	Degrees
abMagLim	float	mag
abSatMag	float	mag
ebmvMed	float
mjdMean	double	days

Table MultiframeDetectorEsoKeys

Contains details of all hierarchical ESO attributes for secondary HDUs

Column	Type	Units	UCD	Error	Description	Links
multiframeID	long		obs.field		the UID of the relevant multiframe
extNum	int		meta.number		the extension number of this frame
cuEventID	int		meta.bib		UID of curation event giving rise to this record
detChipID	string
detChipLive	int
detChipName	string
detChipNo	int
detChipNx	int
detChipNy	int
detChipPxspace	double
detChipType	string
detChipVignetd	int
detChipX	int
detChipY	int
detChopFreq	int
detConOpmode	string
detDid	string
detDitdelay	double
detExpName	string
detExpNo	int
detExpUtc	dateTime
detFileCubeSt	int
detFramNo	int
detFramType	string
detFramUtc	dateTime
detIraceAdc1Delay	int
detIraceAdc1Enable	int
detIraceAdc1Filter1	int
detIraceAdc1Filter2	int
detIraceAdc1Header	int
detIraceAdc1Name	string
detIraceAdc2Delay	int
detIraceAdc2Enable	int
detIraceAdc2Filter1	int
detIraceAdc2Filter2	int
detIraceAdc2Header	int
detIraceAdc2Name	string
detIraceAdc3Delay	int
detIraceAdc3Enable	int
detIraceAdc3Filter1	int
detIraceAdc3Filter2	int
detIraceAdc3Header	int
detIraceAdc3Name	string
detIraceAdc4Delay	int
detIraceAdc4Enable	int
detIraceAdc4Filter1	int
detIraceAdc4Filter2	int
detIraceAdc4Header	int
detIraceAdc4Name	string
detIraceAdc5Delay	int
detIraceAdc5Enable	int
detIraceAdc5Filter1	int
detIraceAdc5Filter2	int
detIraceAdc5Header	int
detIraceAdc5Name	string
detIraceAdc6Delay	int
detIraceAdc6Enable	int
detIraceAdc6Filter1	int
detIraceAdc6Filter2	int
detIraceAdc6Header	int
detIraceAdc6Name	string
detIraceAdc7Delay	int
detIraceAdc7Enable	int
detIraceAdc7Filter1	int
detIraceAdc7Filter2	int
detIraceAdc7Header	int
detIraceAdc7Name	string
detIraceAdc8Delay	int
detIraceAdc8Enable	int
detIraceAdc8Filter1	int
detIraceAdc8Filter2	int
detIraceAdc8Header	int
detIraceAdc8Name	string
detIraceAdc9Delay	int
detIraceAdc9Enable	int
detIraceAdc9Filter1	int
detIraceAdc9Filter2	int
detIraceAdc9Header	int
detIraceAdc9Name	string
detIraceAdc10Delay	int
detIraceAdc10Enable	int
detIraceAdc10Filter1	int
detIraceAdc10Filter2	int
detIraceAdc10Header	int
detIraceAdc10Name	string
detIraceAdc11Delay	int
detIraceAdc11Enable	int
detIraceAdc11Filter1	int
detIraceAdc11Filter2	int
detIraceAdc11Header	int
detIraceAdc11Name	string
detIraceAdc12Delay	int
detIraceAdc12Enable	int
detIraceAdc12Filter1	int
detIraceAdc12Filter2	int
detIraceAdc12Header	int
detIraceAdc12Name	string
detIraceAdc13Delay	int
detIraceAdc13Enable	int
detIraceAdc13Filter1	int
detIraceAdc13Filter2	int
detIraceAdc13Header	int
detIraceAdc13Name	string
detIraceAdc14Delay	int
detIraceAdc14Enable	int
detIraceAdc14Filter1	int
detIraceAdc14Filter2	int
detIraceAdc14Header	int
detIraceAdc14Name	string
detIraceAdc15Delay	int
detIraceAdc15Enable	int
detIraceAdc15Filter1	int
detIraceAdc15Filter2	int
detIraceAdc15Header	int
detIraceAdc15Name	string
detIraceAdc16Delay	int
detIraceAdc16Enable	int
detIraceAdc16Filter1	int
detIraceAdc16Filter2	int
detIraceAdc16Header	int
detIraceAdc16Name	string
detIraceSeqcont	int
detMindit	double
detModeName	string
detNcorrs	int
detNditskip	int
detRspeed	int
detRspeedadd	int
detWinNx	int
detWinNy	int
detWinStartx	int
detWinStarty	int
detWinType	int

Table MultiframeEsoKeys

Contains details of all hierarchical ESO attributes for the primary HDU

Column	Type	Units	UCD	Error	Description	Links
multiframeID	long		obs.field		the UID of the relevant multiframe
cuEventID	int		meta.bib		UID of curation event giving rise to this record
detDit	double
detNcorrsName	string
detNdit	int
dprCatg	string
dprTech	string
dprType	string
insDate	string
insFilt1Date	dateTime
insFilt1Enc	int
insFilt1Error	double
insFilt1Focus	double
insFilt1ID	string
insFilt1Name	string
insFilt1No	int
insFilt1Posedge	int
insFilt1Trayid	string
insFilt1Wlen	double
insHb1Swsim	int
insID	string
insLsc1Ok	int
insLsc1Swsim	int
insLsm1Ok	int
insLsm1Swsim	int
insLsm2Ok	int
insLsm2Swsim	int
insLsm3Ok	int
insLsm3Swsim	int
insPres1ID	string
insPres1Name	string
insPres1Unit	string
insPres1Val	double
insSw1ID	string
insSw1Name	string
insSw1Status	string
insSw2ID	string
insSw2Name	string
insSw2Status	string
insSw3ID	string
insSw3Name	string
insSw3Status	string
insTemp1ID	string
insTemp1Name	string
insTemp1Unit	string
insTemp1Val	double
insTemp2ID	string
insTemp2Name	string
insTemp2Unit	string
insTemp2Val	double
insTemp3ID	string
insTemp3Name	string
insTemp3Unit	string
insTemp3Val	double
insTemp4ID	string
insTemp4Name	string
insTemp4Unit	string
insTemp4Val	double
insTemp5ID	string
insTemp5Name	string
insTemp5Unit	string
insTemp5Val	double
insTemp6ID	string
insTemp6Name	string
insTemp6Unit	string
insTemp6Val	double
insTemp7ID	string
insTemp7Name	string
insTemp7Unit	string
insTemp7Val	double
insTemp8ID	string
insTemp8Name	string
insTemp8Unit	string
insTemp8Val	double
insTemp10ID	string
insTemp10Name	string
insTemp10Unit	string
insTemp10Val	double
insTemp12ID	string
insTemp12Name	string
insTemp12Unit	string
insTemp12Val	double
insTemp14ID	string
insTemp14Name	string
insTemp14Unit	string
insTemp14Val	double
insTemp15ID	string
insTemp15Name	string
insTemp15Unit	string
insTemp15Val	double
insTemp16ID	string
insTemp16Name	string
insTemp16Unit	string
insTemp16Val	double
insTemp17ID	string
insTemp17Name	string
insTemp17Unit	string
insTemp17Val	double
insTemp18ID	string
insTemp18Name	string
insTemp18Unit	string
insTemp18Val	double
insTemp19ID	string
insTemp19Name	string
insTemp19Unit	string
insTemp19Val	double
insTemp20ID	string
insTemp20Name	string
insTemp20Unit	string
insTemp20Val	double
insTemp21ID	string
insTemp21Name	string
insTemp21Unit	string
insTemp21Val	double
insTemp22ID	string
insTemp22Name	string
insTemp22Unit	string
insTemp22Val	double
insTemp23ID	string
insTemp23Name	string
insTemp23Unit	string
insTemp23Val	double
insTemp24ID	string
insTemp24Name	string
insTemp24Unit	string
insTemp24Val	double
insTemp25ID	string
insTemp25Name	string
insTemp25Unit	string
insTemp25Val	double
insTemp26ID	string
insTemp26Name	string
insTemp26Unit	string
insTemp26Val	double
insThermalAmbMean	double
insThermalCldMean	double
insThermalDetMean	double
insThermalDetTarget	double
insThermalEnable	int
insThermalFpaMean	double
insThermalTubMean	double
insThermalWinMean	double
insVac1Ok	int
insVac1Swsim	int
obsDid	string
obsExectime	int
obsGrp	string
obsID	int
obsName	string
obsObserver	string
obsPiCoiID	int
obsPiCoiName	string
obsProgID	string
obsStart	dateTime
obsTargName	string
obsTplno	int
ocsDet1Imgname	string
ocsExpno	int
ocsNexp	int
ocsRecipe	string
ocsReqtime	double
ocsSadtAosa1ID	string
ocsSadtAosa2ID	string
ocsSadtAosa3ID	string
ocsSadtAosa4ID	string
ocsSadtAosa5ID	string
ocsSadtAosb1ID	string
ocsSadtAosb2ID	string
ocsSadtAosb3ID	string
ocsSadtAosb4ID	string
ocsSadtAosb5ID	string
ocsSadtCatID	string
ocsSadtGs1ID	string
ocsSadtGs2ID	string
ocsSadtGs3ID	string
ocsSadtGs4ID	string
ocsSadtGs5ID	string
ocsSadtIpID	string
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	dateTime
telAoM1Date	dateTime
telAoM2Date	dateTime
telAoModes	int
telAz	double
telDate	string
telDid	string
telDid1	string
telDomeStatus	string
telEcsFlatfield	int
telEcsMoonscr	double
telEcsVent1	double
telEcsVent2	double
telEcsVent3	double
telEcsWindscr	double
telFocuID	string
telFocuValue	double
telGeoelev	double
telGeolat	double
telGeolon	double
telGuidDec	double
telGuidFwhm	double
telGuidID	string
telGuidMag	double
telGuidPeakint	double
telGuidRa	double
telGuidStatus	string
telID	string
telM2Acentre	double
telM2Atilt	double
telM2Bcentre	double
telM2Btilt	double
telM2Z	double
telMoonDec	double
telMoonRa	double
telOper	string
telParangEnd	double
telParangStart	double
telPosang	double
telTargAlpha	double
telTargCoordtype	string
telTargDelta	double
telTargEpoch	double
telTargEpochsystem	string
telTargEquinox	double
telTargParallax	double
telTargPma	double
telTargPmd	double
telTargRadvel	double
telThM1Temp	double
telThStrTemp	double
telTrakStatus	string
tplDid	string
tplExpno	int
tplFileDirname	string
tplID	string
tplName	string
tplNexp	int
tplPreseq	string
tplStart	dateTime
tplVersion	string
obsAirm	float
obsAmbiFwhm	float
obsAmbiTrans	string
obsContainerID	long
obsContainerType	string
obsMoonDist	float	deg?
obsMoonFli	float
sadtAreaID	int
sadtSurveyID	string
sadtMaxJit	float	arcsec
sadtOverlapX	float	arcsec
sadtOverlapY	float	arcsec
sadtPattern	string
sadtTileRa	float	HHMMSS.TTT
sadtTileDec	float	DDMMSS.TTT
sadtTileOffAngle	float	deg
sadtTileID	string

Table PhotCalVers

Contains details of all photometric calibration versions in the VSA

Column	Type	Units	UCD	Error	Description	Links
versNum	int		meta.software		the version number of the calibration
cuEventID	int		meta.bib		UID of curation event giving rise to this record
startDate	dateTime	MM-DD-YYYY	time.epoch		Date time of start time for this version of the calibration (MM-DD-YYYY)
endDate	dateTime	MM-DD-YYYY	time.epoch		Date time of end time for this version of the calibration (MM-DD-YYYY)

Table PreviousMFDZP

Contains previous zeropoints for each multiframe and detector combination

Column	Type	Units	UCD	Error	Description	Links
multiframeID	long		obs.field		the UID of the relevant multiframe
extNum	int		meta.number		the extension number of this frame
versNum	int		meta.software		the version number of the calibration
photZPCat	float	mag			Photometric zeropoint for default extinction in catalogue header
photZPErrCat	float	mag			Photometric zeropoint error in catalogue header
numZPCat	int				Number of standards used in determining photZP and photZPErr
nightZPCat	float	mags	??		Average photometric zero point for night
nightZPErrCat	float	mags	??		Photometric zero point sigma for night
nightZPNum	int	mags	??		Number of ZP in band used to calculate nightZPCat

Table ProductLinks

Contains links between different products, e.g. tiles and stacks, mosaics and tiles, mosaics and stack

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
combiProductID	int		??		Product ID of combination frame
intProductID	int		??		Product ID of intermediate frame
combiProdType	string		??		Type (stack,tile,mosaic) of combination frame
intProdType	string		??		Type (stack,tile,mosaic) of intermediate frame

Table Programme

Contains details of the VISTA public survey programmes

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		UID of the archived programme coded as above
title	string		meta.note		a short title for the programme, eg. "VISTA Hemisphere Survey"
description	string		meta.note		a concise description of the programme
reference	string		meta.bib		a web reference (URL) for the programme
propPeriod	int	months	time.period		the proprietory period for any data taken for this programme in months, e.g. 12 for open time.
dfsIDString	string		??		The description used within the data flow system (i.e. the value of the appropriate FITS keyword)
catalogueSchema	string		??		Script file that describes the catalogue schema
detectionTable	string		??		Table name of detections
sourceTable	string		??		Table name of merged sources
listRemeasTable	string		??		Table name of individual passband list re-measurements
sourceRemeasTable	string		??		Table name of co-located list re-measurements
mergeLogTable	string		??		Table name of curation log for source merging
frameSetTolerance	float	Degrees	??		The match tolerance for different passband frames
pairingCriterion	float	Degrees	??		The pairing criterion for associating detections into merged sources
adjacentFrameTolerance	float	Degrees	??		The match tolerance for adjacent frames in the survey
neighboursSchema	string		??		Script file that describes the neighbour tables schema for this programme
synopticSourceTable	string		??		Table name of merged variable sources
synopticBestMatchTable	string		??		Table name of merged variable sources
variabilityTable	string		??		Table name of merged variable sources
mosaicTool	string		??		Name of mosaicing tool to be used
extractTool	string		??		Name of extraction tool to be used
bandMergingCriterion	float	minutes			maximum timespan over which different filters are merged into sources in the synoptic source table.
isLowGalacticLat	int				Is this a low galactic latitude field (No=0/Yes=1)
sourceProdType	string				The product type to be used to create the source table. (stack, tile, mosaic)
epochFrameType	string				The frame type to be used for each epoch (stack, tile)
posAngleTolerance	float	Degrees	??		The position angle tolerance used when creating deep stacks and tiles
synopticSetUp	string		??		A string describing the synoptic setup for more complicated surveys
extinctionMapList	string		meta.id		A list of 3D extinction maps that should be matched to this survey

Table ProgrammeCurationHistory

Contains details of the matrix of programmes and required curation tasks

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
cuEventID	int		meta.bib		UID of curation event giving rise to this record
timeStamp	dateTime	UTC	time.epoch		Time of individual programme curation completion
status	int		meta.code		successful (1) or unsuccessful (0)

Table ProgrammeFrame

Contains details of which image(s) belong to which Programme(s

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id
multiframeID	long		obs.field		the UID of the relevant multiframe
cuEventID	int		meta.bib		UID of curation event giving rise to this record
ppErrBitsStatus	int				Bit flag to denote whether detection quality flagging has been done on this multiframe for this programme.
productID	long
releaseNum	int

Table ProgrammeTable

Contains details of the set of curated tables for each programme

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
tableID	int		meta.id;meta.main		the unique table ID
tableName	string		meta.id;meta.dataset		the name of the table
sourceIDName	string		meta.id		the name of the source

Table Provenance

Describes the provenance of all combined frames in the archive

Column	Type	Units	UCD	Error	Description	Links
combiframeID	long		obs.field		the UID of the combined frame (=combiframe)
multiframeID	long		obs.field		the UID of the component frame
cuEventID	int		meta.bib		UID of curation event giving rise to this record

Table Release

Contains the release details for each survey curated within the VSA

Column	Type	Units	UCD	Error	Description	Links
surveyID	int		meta.id		the unique identifier for the survey
releaseNum	int		meta.software		the release number
releaseDate	dateTime	MM-DD-YYYY	time.epoch		the release date
description	string		meta.note		a brief description of the release
dbName	string		??		the name of the SQL Server database containing this release

Table RequiredDiffImage

Contains details of default difference image products curated in the archive

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
productID	int		??		A unique identifier assigned to each required difference image product entry
filter1	int		meta.code;instr.filter		UID of narrow band (primary) filter
filter2	int		meta.code;instr.filter		UID of broad band (reference) filter to be subtracted
wcs	string		??		CASU difference image tool option to specify use of implicit WCS in the input files (y/n; recommended value=y)
method	string		??		CASU difference image tool option string specifying the method to employ (recommended value=adaptive/back/zerosky)

Table RequiredFilters

Contains required filters used for every programme held in the VSA

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
filterID	int		meta.code;instr.filter		UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks)
nPass	int		meta.number		the number of passes that will be made
isSynoptic	int				is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE)

Table RequiredMosaic

Contains details of default mosaic image products curated in the archive

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
productID	int		??		A unique identifier assigned to each required mosaic product entry
name	string		??		Name of the mosaiced product
description	string		??		Description of the product
filterID	int		meta.code;instr.filter		UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks)
ra	double	deg	pos.eq.ra;meta.main		Right Ascension of mosaic centre
dec	double	deg	pos.eq.dec;meta.main		Declination of mosaic centre
raExtent	float	deg	??		The angular extent in RA of the mosaic image
decExtent	float	deg	??		The angular extent in Dec of the mosaic image
nustep	int		??		Amount of microstepping
pixelSize	float	arcsec	??		The final pixel size of the mosaic
dualFilterID	int		meta.code;instr.filter		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)
fieldID	int		??		UID of position on sky.
posAngle	float	deg			Orientation of image x-axis to N-S

Table RequiredNeighbours

Details programmes/survey tables that have default joins within the VSA

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
tableID	int		meta.id		the unique identifier for the programme table
surveyID	int		meta.id		the unique identifier for the survey
extTableID	int		meta.id;meta.main		the unique table ID
joinCriterion	float	arcminutes	??		the join criterion (search radius for matches)
neighbourTable	string		meta.id;meta.dataset		the name of the neighbour join table
extProgID	int		meta.id		the unique programme ID for second table if there are multiple programmes in the neighbour survey

Table RequiredStack

Contains details of default stack image products curated in the archive

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
productID	int		??		A unique identifier assigned to each required stack product entry
name	string		??		Name of the stacked product
description	string		??		Description of the product
filterID	int		meta.code;instr.filter		UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks)
ra	double	deg	pos.eq.ra;meta.main		Right Ascension of stack centre
dec	double	deg	pos.eq.dec;meta.main		Declination of stack centre
numberStk	int				Number of intermediate stacks. If default, stack all good quality stacks
nustep	int		??		Amount of microstepping
offsetPos	int				Identity of offset position [1: -1,-1;2: -1,0; 3: -1,1; 4: 1,-1; 5: 1,0; 6: 1,1]
stackRadius	float	deg			radius within which intermediate stacks are selected for this deep stack.
fieldID	int		??		UID of position on sky.
posAngle	float	deg			Orientation of image x-axis to N-S

Table RequiredTile

Contains details of default stack image products curated in the archive

Column	Type	Units	UCD	Error	Description	Links
programmeID	int		meta.id		the unique programme ID
productID	int		??		A unique identifier assigned to each required stack product entry
name	string		??		Name of the stacked product
description	string		??		Description of the product
filterID	int		meta.code;instr.filter		UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks)
ra	double	deg	pos.eq.ra;meta.main		Right Ascension of stack centre
dec	double	deg	pos.eq.dec;meta.main		Declination of stack centre
nustep	int		??		Amount of microstepping
stackRadius	float	deg			radius within which intermediate stacks are selected for this deep stack.
fieldID	int		??		UID of position on sky.
posAngle	float	deg			Orientation of image x-axis to N-S

Table SectionDetectors

Gives which detectors correspond to different sections of sectioned OMEGACAM filters

Column	Type	Units	UCD	Error	Description	Links
sectionID	int				UID of section of focal plane with different filter
camNum	int				UID of camera detector

Table Survey

Contains information about the curated surveys within the VSA

Column	Type	Units	UCD	Error	Description	Links
surveyID	int		meta.id		The unique identifier for the curated survey
name	string		??		The short name for the survey
description	string		??		A concise description of the survey
dbNamePrefix	string		??		A string that prefixes all database names released for this survey
proprietary	int		??		Logical flag indicating whether a survey is proprietary or not (1=yes; 0=no)

Table SurveyProgrammes

Contains details of which programme(s) belong to which survey(s

Column	Type	Units	UCD	Error	Description	Links
surveyID	int		meta.id		The unique identifier for the curated survey
programmeID	int		meta.id
delPropData	int		??		Logical flag indicating that proprietary data should be removed on release (1=yes; 0=no)

Table vikingAstrometricInfo

Contains astrometric information that will be used by BestMatc

Column	Type	Units	UCD	Error	Description	Links
multiframeID	long		meta.id;obs.field		the UID of the relevant multiframe
extNum	int		meta.number		the extension number of this frame
cuEventID	int		meta.bib		UID of curation event giving rise to this record
detedgeinnerpos1NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos1NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos1NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos1Const	double		stat.param		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.
detedgeinnerpos2NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos2NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos2NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos2Const	double		stat.param		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.
detedgeinnerpos3NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos3NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos3NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos3Const	double		stat.param		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.
detedgeinnerpos4NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos4NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos4NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,)
detedgeinnerpos4Const	double		stat.param		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.
detedgeouterpos1NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,)
detedgeouterpos1NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,)
detedgeouterpos1NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,)
detedgeouterpos1Const	double		stat.param		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.
detedgeouterpos2NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,)
detedgeouterpos2NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,)
detedgeouterpos2NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,)
detedgeouterpos2Const	double		stat.param		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.
detedgeouterpos3NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,)
detedgeouterpos3NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,)
detedgeouterpos3NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,)
detedgeouterpos3Const	double		stat.param		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.
detedgeouterpos4NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DETEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,)
detedgeouterpos4NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DETEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,)
detedgeouterpos4NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DETEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,)
detedgeouterpos4Const	double		stat.param		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.
dithedgeinnerpos1NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos1NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos1NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEINNERPOS1 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos1Const	double		stat.param		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.
dithedgeinnerpos2NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos2NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos2NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEINNERPOS2 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos2Const	double		stat.param		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.
dithedgeinnerpos3NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos3NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos3NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEINNERPOS3 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos3Const	double		stat.param		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.
dithedgeinnerpos4NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos4NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos4NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEINNERPOS4 detector boundary (see Budavari et al. 2010,)
dithedgeinnerpos4Const	double		stat.param		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.
dithedgeouterpos1NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos1NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos1NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEOUTERPOS1 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos1Const	double		stat.param		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.
dithedgeouterpos2NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos2NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos2NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEOUTERPOS2 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos2Const	double		stat.param		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.
dithedgeouterpos3NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos3NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos3NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEOUTERPOS3 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos3Const	double		stat.param		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.
dithedgeouterpos4NormX	double		pos.cartesian.x		Cartesian unit normal vector X-coordinate of the halfspace describing the DITHEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos4NormY	double		pos.cartesian.y		Cartesian unit normal vector Y-coordinate of the halfspace describing the DITHEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos4NormZ	double		pos.cartesian.z		Cartesian unit normal vector Z-coordinate of the halfspace describing the DITHEDGEOUTERPOS4 detector boundary (see Budavari et al. 2010,)
dithedgeouterpos4Const	double		stat.param		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.
xifitrms	double	arcsec	stat.error		RMS errors in fit for xi
xnfitrms	double	arcsec	stat.error		RMS errors in fit for xn
xizp	double	arcsec	arith.zp		Zeropoint offset in xi
siga	double	arcsec	stat.fit;stat.stdev		Error on coefficient a
xnzp	double	arcsec	arith.zp		Zeropoint offset in xn
sigd	double	arcsec	stat.fit;stat.stdev		Error on coefficient d
xisc	double		instr.scale		Scale factor in xi
xnsc	double		instr.scale		Scale factor in xn
orient	double	rad	pos.posAng		Orientation of axes
nonperp	double	rad	pos.posAng		Non-perpendicularity of axes
chi2s	double		stat.fit.chi2		Reduced chi-squared of fit
isComplete	int		meta.code.qual		Level of completeness: 0 redo both parts 1; halfspace calculation complete; 2 Astrometric correction complete; 3 All complete

Table vikingMergeLog

Contains frame set details of merged VIKING MultiframeDetector images

Column	Type	Units	UCD	Error	Description	Links
frameSetID	long		meta.id;obs.field		frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure
cuEventID	int		meta.bib		UID of curation event giving rise to this record
ra	double	deg	pos.eq.ra;meta.main		Right Ascension of field centre
dec	double	deg	pos.eq.dec;meta.main		Declination of field centre
cx	double		pos.cartesian.x;pos.eq		unit vector of spherical co-ordinates
cy	double		pos.cartesian.y;pos.eq		unit vector of spherical co-ordinates
cz	double		pos.cartesian.z;pos.eq		unit vector of spherical co-ordinates
htmID	long		pos		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates
zmfID	long		meta.id;obs.field;em.opt.I		the UID of the relevant Z multiframe
zeNum	int		meta.number;em.opt.I		the extension number of this Z frame
newZframe	int		meta.code;em.opt.I		new/old flag (1/0) of this detector image
listProcZ	int		meta.code;em.opt.I		Frame has been list processed (0=no; 1=yes)
ymfID	long		meta.id;obs.field;em.IR.NIR		the UID of the relevant Y multiframe
yeNum	int		meta.number;em.IR.NIR		the extension number of this Y frame
newYframe	int		meta.code;em.IR.NIR		new/old flag (1/0) of this detector image
listProcY	int		meta.code;em.IR.NIR		Frame has been list processed (0=no; 1=yes)
jmfID	long		meta.id;obs.field;em.IR.J		the UID of the relevant J multiframe
jeNum	int		meta.number;em.IR.J		the extension number of this J frame
newJframe	int		meta.code;em.IR.J		new/old flag (1/0) of this detector image
listProcJ	int		meta.code;em.IR.J		Frame has been list processed (0=no; 1=yes)
hmfID	long		meta.id;obs.field;em.IR.H		the UID of the relevant H multiframe
heNum	int		meta.number;em.IR.H		the extension number of this H frame
newHframe	int		meta.code;em.IR.H		new/old flag (1/0) of this detector image
listProcH	int		meta.code;em.IR.H		Frame has been list processed (0=no; 1=yes)
ksmfID	long		meta.id;obs.field;em.IR.K		the UID of the relevant Ks multiframe
kseNum	int		meta.number;em.IR.K		the extension number of this Ks frame
newKsframe	int		meta.code;em.IR.K		new/old flag (1/0) of this detector image
listProcKs	int		meta.code;em.IR.K		Frame has been list processed (0=no; 1=yes)
mergeSwVersion	float		meta.id;meta.software		version number of the software used to merge the frames
newFrameSet	int		meta.code		Flag used internally by curation applications
deprecated	int		meta.code		frame set deprecation flag (1=deprecated)

Table vikingSourceNeighbours

Neighbouring sources for each entry in vikingSource

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in vikingSource (=sourceID)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXDR5lasSource

Cross-neighbours between viking and lasSource

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in UKIDSSDR5PLUS..lasSource (=sourceID)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXDR7PhotoObj

Cross-neighbours between viking and PhotoObj

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in BestDR7..PhotoObj (=objID)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours
sdssType	int		src.class		SDSS type of neighbour: 3=galaxy; 6=star
sdssPrimary	int		meta.code		SDSS flag for neighbour being primary (1) or secondary (0)

Table vikingSourceXDR7PhotoObjAll

Cross-neighbours between viking and PhotoObjAll

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in BestDR7..PhotoObjAll (=objID)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours
sdssType	int		src.class		SDSS type of neighbour: 3=galaxy; 6=star
sdssPrimary	int		meta.code		SDSS flag for neighbour being primary (1) or secondary (0)

Table vikingSourceXDetection

Cross-neighbours between master source list, vikingSource table, and the individual epoch detections, vikingDetection table

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in vikingDetection table (=objID)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXDetectionBestMatch

Links each unique source to the best set of possible detections

Column	Type	Units	UCD	Error	Description	Links
sourceID	long		meta.id;meta.main		UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm
multiframeID	long		meta.id;obs.field		the UID of the relevant multiframe
extNum	int		meta.number		the extension number of this frame
cuEventID	int		meta.bib		UID of curation event giving rise to this record
seqNum	int		meta.number
modelDistSecs	float	arcsec	pos.posAng		separation from expected position given astrometric model in vikingSource variability.
flag	int		meta.code.qual		Flag for potential matching problems

Table vikingSourceXSSASource

Cross-neighbours between viking and Source

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in SSA..Source (=objID)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXStripe82PhotoObjAll

Cross-neighbours between viking and PhotoObjAll

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in Stripe82..PhotoObjAll (=objID)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours
sdssType	int		src.class		SDSS type of neighbour: 3=galaxy; 6=star
sdssPrimary	int		meta.code		SDSS flag for neighbour being primary (1) or secondary (0)

Table vikingSourceXallwise_sc

Cross-neighbours between viking and allwise_sc

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in WISE..allwise_sc (=cntr)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXgrs_ngpSource

Cross-neighbours between viking and grs_ngpSource

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in TWODFGRS..grs_ngpSource (=SEQNUM)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXgrs_ranSource

Cross-neighbours between viking and grs_ranSource

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in TWODFGRS..grs_ranSource (=SEQNUM)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXgrs_sgpSource

Cross-neighbours between viking and grs_sgpSource

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in TWODFGRS..grs_sgpSource (=SEQNUM)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXmgcDetection

Cross-neighbours between viking and mgcDetection

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in MGC..mgcDetection (=MGCID)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXtwomass_psc

Cross-neighbours between viking and twomass_psc

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in TWOMASS..twomass_psc (=pts_key)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXtwomass_xsc

Cross-neighbours between viking and twomass_xsc

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in TWOMASS..twomass_xsc (=ext_key)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingSourceXwise_allskysc

Cross-neighbours between viking and wise_allskysc

Column	Type	Units	UCD	Error	Description	Links
masterObjID	long		meta.id;meta.main		The unique ID in vikingSource (=sourceID)
slaveObjID	long		meta.dataset		The unique ID of the neighbour in WISE..wise_allskysc (=cntr)
distanceMins	float	arcminutes	pos.angDistance		Angular separation between neighbours

Table vikingTilePawPrints

Contains tile<->paw-print paired detections from vikingDetection

Column	Type	Units	UCD	Error	Description	Links
detectID	long		meta.id;meta.main		UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm
cuEventID	int		meta.bib		UID of curation event giving rise to this record
tileSetID	long		meta.bib		UID of the set of frames that this merged source comes from
ra	double	Degrees	pos.eq.ra;meta.main		Celestial Right Ascension
dec	double	Degrees	pos.eq.dec;meta.main		Celestial Declination
cx	double		pos.cartesian.x;pos.eq		unit vector of spherical co-ordinates
cy	double		pos.cartesian.y;pos.eq		unit vector of spherical co-ordinates
cz	double		pos.cartesian.z;pos.eq		unit vector of spherical co-ordinates
htmID	long		pos		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates
l	double	Degrees	pos.galactic.lon		Galactic longitude
b	double	Degrees	pos.galactic.lat		Galactic latitude
lambda	double	Degrees	pos		SDSS system spherical co-ordinate 1
eta	double	Degrees	pos		SDSS system spherical co-ordinate 2
tlExtNum	int		meta.id		the extension number of the tile detection (should always be 2)
tlSeqNum	int		meta.number		the running number of the tile detection
tlXi	float	arcsec	pos.eq.ra;arith.diff		Offset of &As& detection from master position (+east/-west)
tlEta	float	arcsec	pos.eq.dec;arith.diff		Offset of &As& detection from master position (+north/-south)
o1ExtNum	int		meta.id		the extension number of the O1 detection
o1SeqNum	int		meta.number		the running number of the O1 detection
o1Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O1 detection from master position (+east/-west)
o1Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O1 detection from master position (+north/-south)
o2ExtNum	int		meta.id		the extension number of the O2 detection
o2SeqNum	int		meta.number		the running number of the O2 detection
o2Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O2 detection from master position (+east/-west)
o2Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O2 detection from master position (+north/-south)
o3ExtNum	int		meta.id		the extension number of the O3 detection
o3SeqNum	int		meta.number		the running number of the O3 detection
o3Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O3 detection from master position (+east/-west)
o3Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O3 detection from master position (+north/-south)
o4ExtNum	int		meta.id		the extension number of the O4 detection
o4SeqNum	int		meta.number		the running number of the O4 detection
o4Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O4 detection from master position (+east/-west)
o4Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O4 detection from master position (+north/-south)
o5ExtNum	int		meta.id		the extension number of the O5 detection
o5SeqNum	int		meta.number		the running number of the O5 detection
o5Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O5 detection from master position (+east/-west)
o5Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O5 detection from master position (+north/-south)
o6ExtNum	int		meta.id		the extension number of the O6 detection
o6SeqNum	int		meta.number		the running number of the O6 detection
o6Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O6 detection from master position (+east/-west)
o6Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O6 detection from master position (+north/-south)
tileSetSeqNum	int		meta.bib		Running number of the match in this tile set

Table vikingTilePawTDOnly

vikingTilePawPrints table with only good tile detections only and default

Column	Type	Units	UCD	Error	Description	Links
detectID	long		meta.id;meta.main		UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm
cuEventID	int		meta.bib		UID of curation event giving rise to this record
tileSetID	long		meta.bib		UID of the set of frames that this merged source comes from
ra	double	Degrees	pos.eq.ra;meta.main		Celestial Right Ascension
dec	double	Degrees	pos.eq.dec;meta.main		Celestial Declination
cx	double		pos.cartesian.x;pos.eq		unit vector of spherical co-ordinates
cy	double		pos.cartesian.y;pos.eq		unit vector of spherical co-ordinates
cz	double		pos.cartesian.z;pos.eq		unit vector of spherical co-ordinates
htmID	long		pos		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates
l	double	Degrees	pos.galactic.lon		Galactic longitude
b	double	Degrees	pos.galactic.lat		Galactic latitude
lambda	double	Degrees	pos		SDSS system spherical co-ordinate 1
eta	double	Degrees	pos		SDSS system spherical co-ordinate 2
tlExtNum	int		meta.id		the extension number of the tile detection (should always be 2)
tlSeqNum	int		meta.number		the running number of the tile detection
tlXi	float	arcsec	pos.eq.ra;arith.diff		Offset of &As& detection from master position (+east/-west)
tlEta	float	arcsec	pos.eq.dec;arith.diff		Offset of &As& detection from master position (+north/-south)
o1ExtNum	int		meta.id		the extension number of the O1 detection
o1SeqNum	int		meta.number		the running number of the O1 detection
o1Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O1 detection from master position (+east/-west)
o1Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O1 detection from master position (+north/-south)
o2ExtNum	int		meta.id		the extension number of the O2 detection
o2SeqNum	int		meta.number		the running number of the O2 detection
o2Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O2 detection from master position (+east/-west)
o2Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O2 detection from master position (+north/-south)
o3ExtNum	int		meta.id		the extension number of the O3 detection
o3SeqNum	int		meta.number		the running number of the O3 detection
o3Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O3 detection from master position (+east/-west)
o3Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O3 detection from master position (+north/-south)
o4ExtNum	int		meta.id		the extension number of the O4 detection
o4SeqNum	int		meta.number		the running number of the O4 detection
o4Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O4 detection from master position (+east/-west)
o4Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O4 detection from master position (+north/-south)
o5ExtNum	int		meta.id		the extension number of the O5 detection
o5SeqNum	int		meta.number		the running number of the O5 detection
o5Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O5 detection from master position (+east/-west)
o5Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O5 detection from master position (+north/-south)
o6ExtNum	int		meta.id		the extension number of the O6 detection
o6SeqNum	int		meta.number		the running number of the O6 detection
o6Xi	float	arcsec	pos.eq.ra;arith.diff		Offset of O6 detection from master position (+east/-west)
o6Eta	float	arcsec	pos.eq.dec;arith.diff		Offset of O6 detection from master position (+north/-south)
tileSetSeqNum	int		meta.bib		Running number of the match in this tile set

Table vikingTileSet

Contains tile set details for VIKING Multiframe paw-print images

Column	Type	Units	UCD	Error	Description	Links
tileSetID	long		meta.id;obs.field		frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure
cuEventID	int		meta.bib		UID of curation event giving rise to this record
ra	double	deg	pos.eq.ra;meta.main		Right Ascension of field centre
dec	double	deg	pos.eq.dec;meta.main		Declination of field centre
cx	double		pos.cartesian.x;pos.eq		unit vector of spherical co-ordinates
cy	double		pos.cartesian.y;pos.eq		unit vector of spherical co-ordinates
cz	double		pos.cartesian.z;pos.eq		unit vector of spherical co-ordinates
htmID	long		pos		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates
tlmfID	long		meta.id;obs.field		the UID of the relevant tile multiframe
o1mfID	long		meta.id;obs.field		the UID of the relevant offset O1 multiframe
o2mfID	long		meta.id;obs.field		the UID of the relevant offset O2 multiframe
o3mfID	long		meta.id;obs.field		the UID of the relevant offset O3 multiframe
o4mfID	long		meta.id;obs.field		the UID of the relevant offset O4 multiframe
o5mfID	long		meta.id;obs.field		the UID of the relevant offset O5 multiframe
o6mfID	long		meta.id;obs.field		the UID of the relevant offset O6 multiframe
mergeSwVersion	float		meta.id;meta.software		version number of the software used to merge the frames
newFrameSet	int		meta.code		Flag used internally by curation applications
deprecated	int		meta.code		frame set deprecation flag (1=deprecated)

Table vikingVarFrameSetInfo

Contains fitting information for each frameSet

Column	Type	Units	UCD	Error	Description	Links
frameSetID	long		meta.id;obs.field		frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure
cuEventID	int		meta.bib		UID of curation event giving rise to this record
motionModel	string		meta.code.class		Motion model used to produce BestMatch table. Values: static;proper motion;proper motion and parallax.
jaStratAst	float		stat.fit.param;em.IR.J		Strateva parameter, a, in fit to astrometric rms vs magnitude in J band, see Sesar et al. 2007.
jbStratAst	float		stat.fit.param;em.IR.J		Strateva parameter, b, in fit to astrometric rms vs magnitude in J band, see Sesar et al. 2007.
jcStratAst	float		stat.fit.param;em.IR.J		Strateva parameter, c, in fit to astrometric rms vs magnitude in J band, see Sesar et al. 2007.
jchiSqAst	float		stat.fit.goodness;em.IR.J		Goodness of fit of Strateva function to astrometric data in J band
jnDofAst	int		stat.fit.dof;stat.param;em.IR.J		Number of degrees of freedom of astrometric fit in J band.
jisDefAst	int		meta.code;em.IR.J		Use a default model for the astrometric noise in J band.
jaStratPht	float		stat.fit.param;em.IR.J		Strateva parameter, a, in fit to photometric rms vs magnitude in J band, see Sesar et al. 2007.
jbStratPht	float		stat.fit.param;em.IR.J		Strateva parameter, b, in fit to photometric rms vs magnitude in J band, see Sesar et al. 2007.
jcStratPht	float		stat.fit.param;em.IR.J		Strateva parameter, c, in fit to photometric rms vs magnitude in J band, see Sesar et al. 2007.
jchiSqPht	float		stat.fit.goodness;em.IR.J		Goodness of fit of Strateva function to photometric data in J band
jnDofPht	int		stat.fit.dof;stat.param;em.IR.J		Number of degrees of freedom of photometric fit in J band.
jisDefPht	int		meta.code;em.IR.J		Use a default model for the photometric noise in J band.
jexpML	float	mag	phot.mag;em.IR.J;stat.max		Expected magnitude limit of frameSet in this in J band.

Table vikingVariability

Contains statistical analysis of VIKING primary sources

Column	Type	Units	UCD	Error	Description	Links
sourceID	long		meta.id;meta.main		UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm
cuEventID	int		meta.bib		UID of curation event giving rise to this record
frameSetID	long		meta.id;obs.field		frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure
ra	double	Degrees	pos.eq.ra;meta.main		Mean Right Ascension
dec	double	Degrees	pos.eq.dec;meta.main		Mean Declination
sigRa	float	Degrees	stat.error		Uncertainty in mean RA
sigDec	float	Degrees	stat.error		Uncertainty in mean Dec
expAstErr	float	arcsec	stat.error		Rms calculated from polynomial fit to minimum astrometric RMS as a function of magnitude
epoch	double	Years	time.epoch		Epoch of measurement
muRa	float	mas/yr	pos.eq.ra;pos.pm		Proper motion in RA
muDec	float	mas/yr	pos.eq.dec;pos.pm		Proper motion in Dec
sigMuRa	float	mas/yr	stat.error		Error on proper motion in RA
sigMuDec	float	mas/yr	stat.error		Error on proper motion in Dec
parallax	float	mas	pos.parallax		Parallax of star
minPllx	float	mas	pos.parallax;stat.min		Lower limit of 90% confidence interval for parallax measurement
maxPllx	float	mas	pos.parallax;stat.max		Upper limit of 90% confidence interval for parallax measurement
chi2	float		stat.fit.chi2		Chi-squared value of astrometric solution
nFrames	int		meta.number		Number of frames with good detections used to calculate astrometric fits
jnGoodObs	int		meta.number;em.IR.J		Number of good detections in J band
jnFlaggedObs	int		meta.number;em.IR.J		Number of detections in J band flagged as potentially spurious by vikingDetection.ppErrBits
jnMissingObs	int		meta.number;em.IR.J		Number of J band frames that this object should have been detected on and was not
jbestAper	int		meta.code.class;em.IR.J		Best aperture (1-6) for photometric statistics in the J band
jminCadence	float	days	time.interval;obs;stat.min		minimum gap between observations
jmedCadence	float	days	time.interval;obs;stat.median		median gap between observations
jmaxCadence	float	days	time.interval;obs;stat.max		maximum gap between observations
jtotalPeriod	float	days	time.duration		total period of observations (last obs-first obs)
jmeanMag	float	mag	phot.mag;em.IR.J;stat.mean;em.IR.J		Mean J magnitude
jmedianMag	float	mag	phot.mag;em.IR.J;stat.median;em.IR.J		Median J magnitude
jMagRms	float	mag	stat.error;em.IR.J;phot.mag		rms of J magnitude
jMagMAD	float	mag	stat.err;em.IR.J;phot.mag		Median Absolute Deviation of J magnitude
jskewness	float	mag	stat.param;em.IR.J		Skewness in J band (see Sesar et al. 2007)
jMinMag	float	mag	phot.mag;em.IR.J;stat.min		Minimum magnitude in J band, of good detections
jMaxMag	float	mag	phot.mag;em.IR.J;stat.max		Maximum magnitude in J band, of good detections
jNgt3sig	int		meta.number;em.IR.J		Number of good detections in J-band that are more than 3 sigma deviations
jExpRms	float	mag	stat.error;em.IR.J		Rms calculated from polynomial fit to modal RMS as a function of magnitude in J band
jIntRms	float	mag	stat.error;em.IR.J		Intrinsic rms in J-band
jchiSqpd	float		stat.fit.chi2;em.IR.J		Chi square (per degree of freedom) fit to data (mean and expected rms)
jndof	int		stat.fit.dof;em.IR.J		Number of degrees of freedom for chisquare
jprobVar	float		stat.probability;em.IR.J		Probability of variable from chi-square (and other data)
jVarClass	int		meta.code.class;src.var;em.IR.J		Classification of variability in this band
variableClass	int		meta.code.class		Classification of objects across all bands.