| View of Multiframe table showing only VIDEO data |
| This view is just a select of Multiframe for the VIDEO 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 | UID of the multiframe (assigned sequentially by the archive ingest process) | obs.field | ||
| vistaRunNo | int | 4 | Original VISTA run number (from filename) | meta.bib | ||
| creationDate | datetime | 8 | MM-DD-YYYY | File creation date (YYYY-MM-DD HH:MM:SS) | 12-31-9999 | time.epoch |
| frameType | varchar | 64 | The type of multiframe (e.g. stack|tile|mosaic etc.) | normal | meta.code.class | |
| cuEventID | int | 4 | UID of curation event giving rise to this record | meta.bib | ||
| julianDayNum | int | 4 | Julian days | The Julian Day number of the VISTA night | time.epoch | |
| fileTimeStamp | bigint | 8 | Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness | ?? | ||
| filterName | varchar | 16 | VISTA combined filter name | ?? | ||
| filterID | tinyint | 1 | UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) | meta.code;instr.filter | ||
| project | varchar | 64 | Time-allocation code | NONE | meta.bib | |
| telescope | varchar | 16 | ESO telescope name | NONE | ||
| instrument | varchar | 8 | Instrument name | NONE | ||
| arcfile | varchar | 64 | Archive File Name | NONE | ||
| utDate | datetime | 8 | MM-DD-YYYY | Observation date (MM-DD-YYYY) | 12-31-9999 | time.epoch |
| dateObs | datetime | 8 | Observing date | 12-31-9999 | time.epoch | |
| mjdObs | float | 8 | Modified Julian Date of the observation start | -0.9999995e9 | time.epoch | |
| equinox | real | 4 | years | Equinox of object position (Standard FK5) | -0.9999995e9 | time.equinox |
| lst | real | 4 | LST at start (sec) | -0.9999995e9 | ||
| utc | real | 4 | UTC at start (sec) | -0.9999995e9 | ||
| raBase | float | 8 | hours | Right ascension of base position (J2000) | -0.9999995e9 | pos.eq.ra;meta.main |
| decBase | float | 8 | degrees | Declination of base position (J2000) | -0.9999995e9 | pos.eq.dec;meta.main |
| raDecSys | varchar | 4 | Coordinate reference frame | NONE | ||
| expTime | real | 4 | seconds | Integration time per exposure (corrected to ndit = 1) | -0.9999995e9 | time.duration;obs.exposure |
| jitterID | smallint | 2 | Sequence number of jitter | -9999 | ||
| jitterX | real | 4 | X offset in jitter pattern [arcsec] | -0.9999995e9 | ||
| jitterY | real | 4 | Y offset in jitter pattern [arcsec] | -0.9999995e9 | ||
| grpNum | int | 4 | Value of 1st OBSNUM in jitter sequence (i.e. group number applied to all members) | -99999999 | ||
| tileNum | int | 4 | Tile number applied to all members | -99999999 | ||
| jitterName | varchar | 8 | Name of jitter pattern | NONE | ||
| masktype | tinyint | 1 | Mask type | 0 | ||
| naxis | tinyint | 1 | # of axes in data array | 0 | ||
| njitter | smallint | 2 | Number of jitter positions | -9999 | ||
| noffsets | smallint | 2 | Number of offset positions | -9999 | ||
| nuStep | tinyint | 1 | Number of microstep positions | 0 | ||
| object | varchar | 32 | Original target. | NONE | ||
| observer | varchar | 64 | Name of observer. | NONE | ||
| numDetectors | tinyint | 1 | The number of "detectors" (=image extensions in FITS file) | ?? | ||
| obsNum | int | 4 | Observation number | -99999999 | ||
| obstype | varchar | 32 | Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) | NONE | ||
| offsetID | smallint | 2 | Sequence number of offset | -9999 | ||
| offsetX | real | 4 | X offset [arcsec] | -0.9999995e9 | ||
| offsetY | real | 4 | Y offset [arcsec] | -0.9999995e9 | ||
| offSetNum | int | 4 | First OBSNUM in offset sequence | -99999999 | ||
| offsetName | varchar | 8 | Name of offset pattern | NONE | ||
| origfile | varchar | 32 | Original File Name | NONE | ||
| origin | varchar | 4 | European Southern Observatory | NONE | ||
| picoi | varchar | 64 | PI-COI name. | NONE | ||
| previewv | varchar | 64 | Version of previ | NONE | ||
| recipe | varchar | 8 | Data reduction recipe to be used | NONE | ||
| reqtime | real | 4 | Requested integration time [s] | -0.9999995e9 | ||
| skyAlgorithm | varchar | 64 | Sky estimation algorithm | NONE | ||
| sLevNum | tinyint | 1 | Level 0 sky | 0 | ||
| uStepNum | int | 4 | Value of 1st OBSNUM in ustep seq | -99999999 | ||
| uStepID | tinyint | 1 | Sequence number of ustep | 0 | ||
| uStepName | varchar | 8 | Name of ustep pattern | NONE | ||
| uStepX | real | 4 | X offset in ustep pattern [arcsec] | -0.9999995e9 | ||
| uStepY | real | 4 | Y offset in ustep pattern [arcsec] | -0.9999995e9 | ||
| wfrtype | varchar | 4 | Mean sky frame | NONE | ||
| amStart | real | 4 | Airmass at start of observation | -0.9999995e9 | obs.airMass | |
| amEnd | real | 4 | Airmass at end of observation | -0.9999995e9 | obs.airMass | |
| esoRaMoon | float | 8 | Right ascension of the Moon (J2000) (deg) | -0.9999995e9 | pos.eq.ra;meta.main | |
| esoDecMoon | float | 8 | Declination of the Moon (J2000) (deg) | -0.9999995e9 | pos.eq.dec;meta.main | |
| raMoon | float | 8 | hours | Geocentric J2000 FK5 Mean Right ascension of the Moon | -0.9999995e9 | pos.eq.ra;meta.main |
| decMoon | float | 8 | degrees | Geocentric J2000 FK5 Mean Declination of the Moon | -0.9999995e9 | pos.eq.dec;meta.main |
| illumMoon | float | 8 | Illumination of the Moon | -0.9999995e9 | ?? | |
| raMoonTopo | float | 8 | hours | Apparent topocentric Right ascension of the Moon (including precession, nutation, and annual aberration) | -0.9999995e9 | pos.eq.ra;meta.main |
| decMoonTopo | float | 8 | degrees | Apparent topocentric Declination of the Moon (including precession, nutation, and annual aberration) | -0.9999995e9 | pos.eq.dec;meta.main |
| fileName | varchar | 256 | the filename for the multiframe, eg. server:/path/filename.fit | meta.id;meta.file | ||
| catName | varchar | 256 | the filename of the associated catalogue MEF, eg. server:/path/filename.fits | meta.id;meta.dataset | ||
| versionNum | real | 4 | a version number for this frame (if available) | -0.9999995e9 | meta.id | |
| darkID | bigint | 8 | UID of library calibration dark frame | -99999999 | obs.field | |
| confID | bigint | 8 | UID of library calibration confidence frame | -99999999 | obs.field | |
| flatID | bigint | 8 | UID of library calibration flatfield frame | -99999999 | obs.field | |
| frinID | bigint | 8 | UID of library calibration fringe frame | -99999999 | obs.field | |
| skyID | bigint | 8 | UID of library calibration sky sub frame | -99999999 | obs.field | |
| maskID | bigint | 8 | UID of library object mask frame | -99999999 | obs.field | |
| deprecated | smallint | 2 | Code for a current (=0) or deprecated (!=0) multiframe | 0 | meta.code | |
| newlyIngested | tinyint | 1 | Curation flag for internal use only (0=no, 1=yes) | 1 | ?? | |
| illumFile | varchar | 256 | File name of CASU created photometric illumination correction used on catalogue data from this file | NONE | ||
| unfilteredID | bigint | 8 | UID of original unfiltered frame corresponding to this filtered frame | -99999999 | obs.field | |
| casuVers | varchar | 64 | CASU Release Version Number | NONE | meta.id | |
| obStatus | varchar | 32 | OB status, can be 'Completed', 'Executed' (which means it has to be repeated) or 'Aborted'. | NONE | ?? | |
| esoGrade | varchar | 4 | ESO QC grade: 'A' if fully under constrains, 'B' if mostly (90%) under constrains, 'C' if out of constrains and 'R' rejected. | NONE | ?? | |
| mjdEnd | float | 8 | Modified Julian Date of the observation end | -0.9999995e9 | time.epoch | |
| totalExpTimeSum | real | 4 | Total integration time of all exposures (s) --K TEXPSUM | -0.9999995e9 | ||
| reqMaxAirmass | real | 4 | Requested maximum airmass | -0.9999995e9 | ||
| reqMaxSeeing | real | 4 | Requested maximum seeing | -0.9999995e9 | ||
| reqSkyTrans | varchar | 64 | Requested sky transparency | NONE | ||
| containerID | bigint | 8 | Scheduling container ID | -99999999 | ||
| containerType | varchar | 64 | Scheduling container type | NONE | ||
| minMoonDist | real | 4 | deg | Requested minimum angular distance to the moon | -0.9999995e9 | |
| maxMoonFli | real | 4 | Requested maximum fractional lunar illumination | -0.9999995e9 | ||
| areaID | int | 4 | SADT Survey area ID | -99999999 | ||
| surveyIDString | varchar | 64 | SADT survey ID | NONE | ||
| maxJitSize | real | 4 | arcsec | SADT maximum jitter size | -0.9999995e9 | |
| tileOverlapX | real | 4 | arcsec | SADT tile overlap in X | -0.9999995e9 | |
| tileOverlapY | real | 4 | arcsec | SADT tile overlap in Y | -0.9999995e9 | |
| patternString | varchar | 64 | SADT pattern ID | NONE | ||
| tileRa | real | 4 | HHMMSS.TTT | SADT tile RA | -0.9999995e9 | |
| tileDec | real | 4 | DDMMSS.TTT | SADT tile declination | -0.9999995e9 | |
| tileOffAngle | real | 4 | deg | SADT tile rotator offset angle | -0.9999995e9 | |
| tileIDString | varchar | 64 | SADT tile ID within survey area | NONE | ||
| Total length | 2162 |