View of MultiframeDetector table showing only VMC data |
This view is just a select of MultiframeDetector for the VMC and Calib programmes for access to pre-release data The details and SQL SELECT corresponding to this view are available here. |
Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
---|---|---|---|---|---|---|
multiframeID | bigint | 8 | the UID of the relevant multiframe | obs.field | ||
extNum | tinyint | 1 | the extension number of this frame | meta.number | ||
cuEventID | int | 4 | UID of curation event giving rise to this record | meta.bib | ||
compFile | varchar | 256 | Filename of the compressed image of this image frame, eg. server:/path/filename.jpg | NONE | meta.id;meta.file | |
julianDayNum | int | 4 | Julian days | The Julian Day number of the VISTA night | time.epoch | |
camNum | smallint | 2 | Number of VISTA camera (1 to 16) | -9999 | obs.field | |
deviceID | varchar | 32 | Device UID identifying every IR device | NONE | obs.field | |
filterID | tinyint | 1 | UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) | meta.code;instr.filter | ||
runID | varchar | 256 | Name of CASU raw data file | NONE | meta.id;meta.file | |
creationDate | datetime | 8 | MM-DD-YYYY:hh:mm:ss.sss | Creation date/time of file | 12-31-9999 | ?? |
imageExtName | varchar | 16 | Extension name in source FITS image file | NONE | ?? | |
bitsPerPix | smallint | 2 | FITS bitpix | Number of bits per data pixel, eg. +32 = 4 byte integers | meta.number | |
dataScale | real | 4 | Scale factor | -0.9999995e9 | ||
dataZero | real | 4 | Offset factor | -0.9999995e9 | ||
numAxes | tinyint | 1 | Number of data axes; eg. 2 | meta.number | ||
axis1Length | int | 4 | length of data axis 1 (X-axis size) {image extension keyword: (Z)NAXIS1} | meta.number | ||
axis2Length | int | 4 | length of data axis 2 (Y-axis size) {image extension keyword: (Z)NAXIS2} | meta.number | ||
imagePcount | int | 4 | FITS image extension required keyword (always 0 for uncompressed images) | meta.number | ||
imageGcount | int | 4 | FITS image extension required keyword (always 1 for uncompressed images) | meta.number | ||
detectorType | varchar | 8 | Detector name | NONE | ||
detRows | smallint | 2 | Pixels in X | -9999 | ||
detCols | smallint | 2 | Pixels in Y | -9999 | ||
CIRMED | real | 4 | Latest estimate of background | -0.9999995e9 | ||
CIR_BVAR | real | 4 | Latest estimate of background variance | -0.9999995e9 | ||
cirVers | varchar | 32 | CIRDR Version | NONE | ||
ditherOffsetX | real | 4 | Dither offset X | -0.9999995e9 | pos;arith.diff | |
ditherOffsetY | real | 4 | Dither offset Y | -0.9999995e9 | pos;arith.diff | |
lincor | varchar | 32 | Linearity LUT used | NONE | ||
nbad | int | 4 | Number of bad pixels | -99999999 | ||
nditcor | tinyint | 1 | Corrected to ndit=1 | 0 | ||
nCombine | smallint | 2 | Number of images in this stack | 0 | ||
groutedFlag | tinyint | 1 | Table has been grouted | 0 | ||
destripe | tinyint | 1 | stripe pattern removed (0/1) | 0 | ||
strprms | real | 4 | RMS of stripe pattern removed | -0.9999995e9 | ||
tpaoff | real | 4 | Tangent point offset (RA) | -0.9999995e9 | ||
tpdoff | real | 4 | Tangent point offset (Dec) | -0.9999995e9 | ||
tpnmatch | int | 4 | Number of objects used for TP offset | -99999999 | ||
skyCorrExt | real | 4 | Percentage sky correction of the detector | -0.9999995e9 | ?? | |
extinctionExt | real | 4 | mags | Extinction coefficient of the detector | -0.9999995e9 | ?? |
skyCorrCat | real | 4 | Percentage sky correction for the catalogue data | -0.9999995e9 | ?? | |
photZPCat | real | 4 | mags | Photometric zero point for default extinction for the catalogue data | -0.9999995e9 | ?? |
photZPErrCat | real | 4 | mags | Photometric zero point error for the catalogue data | -0.9999995e9 | ?? |
extinctionCat | real | 4 | mags | Extinction coefficient for the catalogue data | -0.9999995e9 | ?? |
numZPCat | int | 4 | Number of standards used in determining photZPCat and photZPCatErr | -99999999 | ||
nightZPCat | real | 4 | mags | Average photometric zero point for night | -0.9999995e9 | ?? |
nightZPErrCat | real | 4 | mags | Photometric zero point sigma for night | -0.9999995e9 | ?? |
nightZPNum | int | 4 | mags | Number of ZP in band used to calculate nightZPCat | -99999999 | ?? |
medPa | real | 4 | [deg] Mean PA from N to E | -0.9999995e9 | ||
nbsize | smallint | 2 | Smoothing box size for background | 0 | ||
tableExtName | varchar | 16 | Extension name of source FITS binary table | NONE | ?? | |
tableWidth | smallint | 2 | bytes | Row size of source FITS binary table | -9999 | ?? |
tableRows | int | 4 | No. of rows in source FITS binary table | -99999999 | ?? | |
tablePcount | int | 4 | FITS binary table required keyword | -9999 | ?? | |
tableGcount | int | 4 | FITS binary table required keyword | -9999 | ?? | |
tableFields | smallint | 2 | No. of fields per row in source FITS binary table | -9999 | ?? | |
catCreationDate | datetime | 8 | MM-DD-YYYY:hh:mm:ss.sss | Creation date/time of catalogue file | 12-31-9999 | ?? |
aperCorPeak | real | 4 | Stellar aperture correction: peak height | -0.9999995e9 | ?? | |
aperCor1 | real | 4 | Stellar aperture correction: 1⁄2 × core flux | -0.9999995e9 | ?? | |
aperCor2 | real | 4 | Stellar aperture correction: 1⁄√2 core flux | -0.9999995e9 | ?? | |
aperCor3 | real | 4 | Stellar aperture correction: core flux | -0.9999995e9 | ?? | |
aperCor4 | real | 4 | Stellar aperture correction: √2 × core flux | -0.9999995e9 | ?? | |
aperCor5 | real | 4 | Stellar aperture correction: 2 × core flux | -0.9999995e9 | ?? | |
aperCor6 | real | 4 | Stellar aperture correction: 2√2 × core flux | -0.9999995e9 | ?? | |
aperCor7 | real | 4 | Stellar aperture correction: 4 × core flux | -0.9999995e9 | ?? | |
crowdedFlag | tinyint | 1 | Crowded field analysis flag (0 none, 1 active) | 0 | ||
minImageSize | tinyint | 1 | Minimum size for images (pixels) | 0 | ||
xSize | int | 4 | X-axis size of image | -9999 | ||
ySize | int | 4 | Y-axis size of image | -9999 | ||
coreRadius | real | 4 | [pixels] Core radius for default profile fit | -0.9999995e9 | ||
skyLevel | real | 4 | counts/pixel | Median sky brightness | -0.9999995e9 | ?? |
skyNoise | real | 4 | counts | Pixel noise at sky level | -0.9999995e9 | ?? |
seeing | real | 4 | pixels | Average FWHM | -0.9999995e9 | ?? |
avStellarEll | real | 4 | Average stellar ellipticity (1-b/a) | -0.9999995e9 | src.ellipticity | |
avSaturLevel | real | 4 | Average saturation level in frame | -0.9999995e9 | ||
thresholdIsoph | real | 4 | Isophotal analysis threshold (counts) | -0.9999995e9 | ||
deprecated | smallint | 2 | Code for a current (=0) or deprecated (!=0) multiframe detector | 0 | meta.code | |
decurtainRange | real | 4 | Range of decurtain correction | -0.9999995e9 | ?? | |
skySubScale | float | 8 | Scale factor applied to sky subtraction image | -0.9999995e9 | ?? | |
morphClassFlag | tinyint | 1 | Image morphological classifier flag, set if the classifier has been run. If so an object classification flag and a stellarness index is included in the binary table columns. | 0 | meta.code | |
smoothing | real | 4 | pixels | FWHM of the smoothing kernel | -0.9999995e9 | |
totalExpTime | real | 4 | seconds | Total exposure time for this detector | -0.9999995e9 | |
dribble | varchar | 64 | Interpolation method | NONE | ||
gainCor | real | 4 | Gain correction factor | -0.9999995e9 | ||
templRotation | real | 4 | Degrees | Rotation between this and template | -0.9999995e9 | |
abMagLim | real | 4 | mag | 5-sigma limiting AB magnitude for point sources | -0.9999995e9 | |
abSatMag | real | 4 | mag | Saturation limit for point sources (AB magnitude) | -0.9999995e9 | |
ebmvMed | real | 4 | Median modified E(B-V) | -0.9999995e9 | ||
mjdMean | float | 8 | days | Mean MJD of all images comprising this image | -0.9999995e9 | |
Total length | 1003 |