TABLE VIEW  videoCurrentAstrometry

View of CurrentAstrometry table showing only VIDEO data

This view is just a select of CurrentAstrometry for the VIDEO
and Calib programmes for access to pre-release data
The details and SQL SELECT corresponding to this view are available here.

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
multiframeIDbigint8 the UID of the relevant multiframeobs.field
extNumtinyint1 the extension number of this framemeta.number
cuEventIDint4 UID of curation event giving rise to this recordmeta.bib
cTypeXvarchar8 G&C WCS type, eg 'RA---ZPN'pos.eq.ra;meta.main
cTypeYvarchar8 G&C WCS type, eg 'DEC--ZPN'pos.eq.dec;meta.main
crValXfloat8 Coordinate value at reference point on axis 1-0.9999995e9pos.cartesian.x;instr.det
crValYfloat8 Coordinate value at reference point on axis 2-0.9999995e9pos.cartesian.y;instr.det
crUnit1varchar8 Unit of right ascension co-ordinatesdeg 
crUnit2varchar8 Unit of declination co-ordinatesdeg 
crPixXfloat8pixelsPixel coordinate of the reference point on axis 1pos.cartesian.x;instr.det
crPixYfloat8pixelsPixel coordinate of the reference point on axis 2pos.cartesian.y;instr.det
cd11float8 Element of the linear transformation matrix (with scale)pos.wcs.cdmatrix
cd21float8 Element of the linear transformation matrix (with scale)pos.wcs.cdmatrix
cd12float8 Element of the linear transformation matrix (with scale)pos.wcs.cdmatrix
cd22float8 Element of the linear transformation matrix (with scale)pos.wcs.cdmatrix
pv21float8 Coefficient for r term (use only with ZPN projection)-0.9999995e9pos.wcs.cdmatrix
pv22float8 Coefficient for r**2 term (use only with ZPN projection)-0.9999995e9pos.wcs.cdmatrix
pv23float8 Coefficient for r**3 term (use only with ZPN projection)-0.9999995e9pos.wcs.cdmatrix
pv24float8 Coefficient for r**4 term (use only with ZPN projection)-0.9999995e9pos.wcs.cdmatrix
pv25float8 Coefficient for r**5 term (use only with ZPN projection)-0.9999995e9pos.wcs.cdmatrix
projp1float8 Old style WCS-9.999995e+08 
projp3float8 Old style WCS-9.999995e+08 
projp5float8 Old style WCS-9.999995e+08 
tc33float8 WCS transform matrix element-0.9999995e9 
tc35float8 WCS transform matrix element-0.9999995e9 
tc53float8 WCS transform matrix element-0.9999995e9 
tc55float8 WCS transform matrix element-0.9999995e9 
tcrpx3float8 Pixel coordinate at ref point-0.9999995e9 
tcrpx5float8 Pixel coordinate at ref point-0.9999995e9 
tcrvl3float8 Coordinate value at ref pixel-0.9999995e9 
tcrvl5float8 Coordinate value at ref pixel-0.9999995e9 
tctyp3varchar8 Coordinate/projection typeNONE 
tctyp5varchar8 Coordinate/projection typeNONE 
tv51float8 WCS parameter value term-0.9999995e9 
tv52float8 WCS parameter value term-0.9999995e9 
tv53float8 WCS parameter value term-0.9999995e9 
tv54float8 WCS parameter value term-0.9999995e9 
tv55float8 WCS parameter value term-0.9999995e9 
wcsPasstinyint1 Pass level of WCS0pos.wcs.cdmatrix
numRmsint4 No. of astrometric standards used in fit-99999999stat.fit.param
stdCRmsfloat8 RMS residual of fit to astrometric standards-0.9999995e9stat.fit.residual
refRaShift01float8arcsecRef RA shift pass 0 to 1 (new - old)-0.9999995e9??
refDecShift01float8arcsecRef Dec shift pass 0 to 1 (new - old)-0.9999995e9??
refRaShift02float8arcsecRef RA shift pass 0 to 2 (new - old)-0.9999995e9??
refDecShift02float8arcsecRef Dec shift pass 0 to 2 (new - old)-0.9999995e9??
refRaShift12float8arcsecRef RA shift pass 1 to 2 (new - old)-0.9999995e9??
refDecShift12float8arcsecRef Dec shift pass 1 to 2 (new - old)-0.9999995e9??
refRaShift22float8arcsecRef RA shift pass 2 to 2 (new - old)-0.9999995e9??
refDecShift22float8arcsecRef Dec shift pass 2 to 2 (new - old)-0.9999995e9??
distortMapvarchar256 filename of 2d non-linear distortion mapNONEmeta.id;meta.file
centralRafloat8DegreesRA (J2000) at device centre-0.9999995e9pos.eq.ra;meta.main
centralDecfloat8DegreesDec (J2000) at device centre-0.9999995e9pos.eq.dec;meta.main
cxfloat8 unit vector of spherical co-ordinates of device centrepos.distance;pos.cartesian.x
cyfloat8 unit vector of spherical co-ordinates of device centrepos.distance;pos.cartesian.y
czfloat8 unit vector of spherical co-ordinates of device centrepos.distance;pos.cartesian.z
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates of device centre-99999999pos.eq
posAnglefloat8Degreesorientation of image x-axis to N-S-0.9999995e9pos.posAng
lfloat8DegreesGalactic longitude of device centrepos.galactic.lon
bfloat8DegreesGalactic latitude of device centrepos.galactic.lat
lambdafloat8DegreesSDSS system spherical co-ordinate 1 of device centrepos
etafloat8DegreesSDSS system spherical co-ordinate 2 of device centrepos
imageExtentreal4ArcminutesThe maximum angular extent from the central position-0.9999995e9pos.angDistance
minRafloat8DegreesThe minimum RA (J2000) on the device-0.9999995e9pos.eq.ra
minDecfloat8DegreesThe minimum Dec (J2000) on the device-0.9999995e9pos.eq.dec;meta.main
maxRafloat8DegreesThe maximum RA (J2000) on the device-0.9999995e9pos.eq.ra
maxDecfloat8DegreesThe maximum Dec (J2000) on the device-0.9999995e9pos.eq.dec;meta.main
xPixSizereal4ArcsecondsAngular size of pixels in X-0.9999995e9pos.angDistance
yPixSizereal4ArcsecondsAngular size of pixels in Y-0.9999995e9pos.angDistance
Total length758