Home | Overview | Browser | Access | Login | Cookbook 
  VSA logo

Glossary of VSA attributes

This Glossary alphabetically lists all attributes used in the VSAv20110218 database(s) held in the VSA. If you would like to have more information about the schema tables please use the VSAv20110218 Schema Browser (other Browser versions).
A B C D E F G H I J K L M
N O P Q R S T U V W X Y Z

F

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
F1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Flux in IRAC band 1 real 4 mJy -999.9  
F1_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE 1sigma flux error (IRAC band 1) real 4 mJy -999.9  
F1_rms glimpse_hrc_inter, glimpse_mca_inter GLIMPSE RMS dev. of detection from F1 real 4 mJy -999.9  
F2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Flux in IRAC band 2 real 4 mJy -999.9  
F24umMag spitzer_smcSource SPITZER The SPITZER F24μm band magnitude. real 4 mag    
F2_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE 1sigma flux error (IRAC band 2) real 4 mJy -999.9  
F2_rms glimpse_hrc_inter, glimpse_mca_inter GLIMPSE RMS dev. of detection from F2 real 4 mJy -999.9  
F3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Flux in IRAC band 3 real 4 mJy -999.9  
F3_6 glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 3.6um IRAC (Band 1) flux real 4 mJy -999.9  
F3_6_err glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 3.6um IRAC (Band 1) 1 sigma error real 4 mJy -999.9  
F3_6_rms glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE RMS deviation of the individual detections from the final flux for 3.6um IRAC (Band 1) real 4 mJy -999.9  
F3_6umMag spitzer_smcSource SPITZER The SPITZER F3.6μm band magnitude. real 4 mag    
F3_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE 1sigma flux error (IRAC band 3) real 4 mJy -999.9  
F3_rms glimpse_hrc_inter, glimpse_mca_inter GLIMPSE RMS dev. of detection from F3 real 4 mJy -999.9  
F4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Flux in IRAC band 4 real 4 mJy -999.9  
F4_5 glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 4.5um IRAC (Band 2) flux real 4 mJy -999.9  
F4_5_err glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 4.5um IRAC (Band 2) 1 sigma error real 4 mJy -999.9  
F4_5_rms glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE RMS deviation of the individual detections from the final flux for 4.5um IRAC (Band 2) real 4 mJy -999.9  
F4_5umMag spitzer_smcSource SPITZER The SPITZER F4.5μm band magnitude. real 4 mag    
F4_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE 1sigma flux error (IRAC band 4) real 4 mJy -999.9  
F4_rms glimpse_hrc_inter, glimpse_mca_inter GLIMPSE RMS dev. of detection from F4 real 4 mJy -999.9  
F5_8 glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 5.8um IRAC (Band 3) flux real 4 mJy -999.9  
F5_8_err glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 5.8um IRAC (Band 3) 1 sigma error real 4 mJy -999.9  
F5_8_rms glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE RMS deviation of the individual detections from the final flux for 5.8um IRAC (Band 3) real 4 mJy -999.9  
F5_8umMag spitzer_smcSource SPITZER The SPITZER F5.8μm band magnitude. real 4 mag    
F70umMag spitzer_smcSource SPITZER The SPITZER F70μm band magnitude. real 4 mag    
F8_0 glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 8.0um IRAC (Band 4) flux real 4 mJy -999.9  
F8_0_err glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 8.0um IRAC (Band 4) 1 sigma error real 4 mJy -999.9  
F8_0_rms glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE RMS deviation of the individual detections from the final flux for 8.0um IRAC (Band 4) real 4 mJy -999.9  
F8_0umMag spitzer_smcSource SPITZER The SPITZER F8.0μm band magnitude. real 4 mag    
f_resFlux nvssSource NVSS [PS* ] Residual Code varchar 2     CODE_MISC
fCor_100 iras_psc IRAS Flux correction factor applied (times 1000, 100 micron) smallint 2     INST_CORR-FACTOR
fCor_12 iras_psc IRAS Flux correction factor applied (times 1000, 12 micron) smallint 2     INST_CORR-FACTOR
fCor_25 iras_psc IRAS Flux correction factor applied (times 1000, 25 micron) smallint 2     INST_CORR-FACTOR
fCor_60 iras_psc IRAS Flux correction factor applied (times 1000, 60 micron) smallint 2     INST_CORR-FACTOR
fg_flg twomass_xsc 2MASS flux-growth convergence flag. varchar 6     CODE_MISC
FH glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 2MASS All-Sky PSC H Band flux real 4 mJy -999.9  
FH_err glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 2MASS All-Sky PSC H Band 1 sigma error real 4 mJy -999.9  
FIBRE_R spectra SIXDF fibre number (row on CCD) smallint 2      
FIBRE_V spectra SIXDF fibre number (row on CCD) smallint 2      
field nvssSource NVSS Name of the original survey image field from which the component was derived. varchar 8     ID_FIELD
field1 iras_asc IRAS object field #1 (magnitude/other) smallint 2     ID_FIELD
field2 iras_asc IRAS object field #2 (magnitude/other) smallint 2     ID_FIELD
field3 iras_asc IRAS object field #3 (size/other) smallint 2     ID_FIELD
fieldID RequiredMosaic VSASVORION UID of position on sky. int 4   -99999999 ??
fieldID RequiredMosaic VSAUltraVISTA UID of position on sky. int 4   -99999999 ??
fieldID RequiredMosaic VSAVHS UID of position on sky. int 4   -99999999 ??
fieldID RequiredMosaic VSAVIDEO UID of position on sky. int 4   -99999999 ??
fieldID RequiredMosaic VSAVIKING UID of position on sky. int 4   -99999999 ??
fieldID RequiredMosaic VSAVMC UID of position on sky. int 4   -99999999 ??
fieldID RequiredMosaic VSAVVV UID of position on sky. int 4   -99999999 ??
fieldID RequiredMosaic, RequiredStack, RequiredTile VSASVNGC253 UID of position on sky. int 4   -99999999 ??
fieldID StdFieldInfo VSASVNGC253 The fieldID is a UID identifying each of the 43 standard fields that are observed as part of the calibration observations int 4     ID_FIELD
fieldID StdFieldInfo VSASVORION The fieldID is a UID identifying each of the 43 standard fields that are observed as part of the calibration observations int 4     ID_FIELD
fieldID StdFieldInfo VSAUltraVISTA The fieldID is a UID identifying each of the 43 standard fields that are observed as part of the calibration observations int 4     ID_FIELD
fieldID StdFieldInfo VSAVHS The fieldID is a UID identifying each of the 43 standard fields that are observed as part of the calibration observations int 4     ID_FIELD
fieldID StdFieldInfo VSAVIDEO The fieldID is a UID identifying each of the 43 standard fields that are observed as part of the calibration observations int 4     ID_FIELD
fieldID StdFieldInfo VSAVIKING The fieldID is a UID identifying each of the 43 standard fields that are observed as part of the calibration observations int 4     ID_FIELD
fieldID StdFieldInfo VSAVMC The fieldID is a UID identifying each of the 43 standard fields that are observed as part of the calibration observations int 4     ID_FIELD
fieldID StdFieldInfo VSAVVV The fieldID is a UID identifying each of the 43 standard fields that are observed as part of the calibration observations int 4     ID_FIELD
fieldID rosat_bsc, rosat_fsc ROSAT identification number of SASS field varchar 8     ID_FIELD
fieldName StdFieldInfo VSASVNGC253 reference name of field varchar 16   NONE ????
fieldName StdFieldInfo VSASVORION reference name of field varchar 16   NONE ????
fieldName StdFieldInfo VSAUltraVISTA reference name of field varchar 16   NONE ????
fieldName StdFieldInfo VSAVHS reference name of field varchar 16   NONE ????
fieldName StdFieldInfo VSAVIDEO reference name of field varchar 16   NONE ????
fieldName StdFieldInfo VSAVIKING reference name of field varchar 16   NONE ????
fieldName StdFieldInfo VSAVMC reference name of field varchar 16   NONE ????
fieldName StdFieldInfo VSAVVV reference name of field varchar 16   NONE ????
fieldName first08Jul16Source, firstSource FIRST Name of the coadded image containing the source (encodes the position of the field center). varchar 12     ID_IMAGE
fileName Multiframe VSASVNGC253 the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileName Multiframe VSASVORION the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileName Multiframe VSAUltraVISTA the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileName Multiframe VSAVHS the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileName Multiframe VSAVIDEO the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileName Multiframe VSAVIKING the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileName Multiframe VSAVMC the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileName Multiframe VSAVVV the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileName ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC the filename for the multiframe, eg. server:/path/filename.fit varchar 256     ID_FILE
fileTimeStamp Multiframe VSASVNGC253 Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
fileTimeStamp Multiframe VSASVORION Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
fileTimeStamp Multiframe VSAUltraVISTA Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
fileTimeStamp Multiframe VSAVHS Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
fileTimeStamp Multiframe VSAVIDEO Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
fileTimeStamp Multiframe VSAVIKING Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
fileTimeStamp Multiframe VSAVMC Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
fileTimeStamp Multiframe VSAVVV Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
fileTimeStamp ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC Time stamp digits (from the original CASU directory name and file time stamp) for enforcing uniqueness bigint 8     ??
filter1 RequiredDiffImage VSASVNGC253 UID of narrow band (primary) filter tinyint 1     INST_FILTER_CODE
filter1 RequiredDiffImage VSASVORION UID of narrow band (primary) filter tinyint 1     INST_FILTER_CODE
filter1 RequiredDiffImage VSAUltraVISTA UID of narrow band (primary) filter tinyint 1     INST_FILTER_CODE
filter1 RequiredDiffImage VSAVHS UID of narrow band (primary) filter tinyint 1     INST_FILTER_CODE
filter1 RequiredDiffImage VSAVIDEO UID of narrow band (primary) filter tinyint 1     INST_FILTER_CODE
filter1 RequiredDiffImage VSAVIKING UID of narrow band (primary) filter tinyint 1     INST_FILTER_CODE
filter1 RequiredDiffImage VSAVMC UID of narrow band (primary) filter tinyint 1     INST_FILTER_CODE
filter1 RequiredDiffImage VSAVVV UID of narrow band (primary) filter tinyint 1     INST_FILTER_CODE
filter1_bfilmax machoLMCSource, machoSMCSource MACHO Filter 1, blue: max value of optimum filter for LC real 4      
filter1_bfiltime machoLMCSource, machoSMCSource MACHO Filter 1, blue: LC time at which maximum occurred real 4      
filter1_bNhi machoLMCSource, machoSMCSource MACHO Filter 1, blue: number points sigmathreshold high within duration of filter at peak (bfiltime) smallint 2      
filter1_rfilmax machoLMCSource, machoSMCSource MACHO Filter 1, red: max value of optimum filter for LC real 4      
filter1_rfiltime machoLMCSource, machoSMCSource MACHO Filter 1, red: LC time at which maximum occurred real 4      
filter1_rNhi machoLMCSource, machoSMCSource MACHO Filter 1, red: number points sigmathreshold high within duration of filter at peak (rfiltime) smallint 2      
filter2 RequiredDiffImage VSASVNGC253 UID of broad band (reference) filter to be subtracted tinyint 1     INST_FILTER_CODE
filter2 RequiredDiffImage VSASVORION UID of broad band (reference) filter to be subtracted tinyint 1     INST_FILTER_CODE
filter2 RequiredDiffImage VSAUltraVISTA UID of broad band (reference) filter to be subtracted tinyint 1     INST_FILTER_CODE
filter2 RequiredDiffImage VSAVHS UID of broad band (reference) filter to be subtracted tinyint 1     INST_FILTER_CODE
filter2 RequiredDiffImage VSAVIDEO UID of broad band (reference) filter to be subtracted tinyint 1     INST_FILTER_CODE
filter2 RequiredDiffImage VSAVIKING UID of broad band (reference) filter to be subtracted tinyint 1     INST_FILTER_CODE
filter2 RequiredDiffImage VSAVMC UID of broad band (reference) filter to be subtracted tinyint 1     INST_FILTER_CODE
filter2 RequiredDiffImage VSAVVV UID of broad band (reference) filter to be subtracted tinyint 1     INST_FILTER_CODE
filter2_bfilmax machoLMCSource, machoSMCSource MACHO Filter 2, blue: max value of optimum filter for LC real 4      
filter2_bfiltime machoLMCSource, machoSMCSource MACHO Filter 2, blue: LC time at which maximum occurred real 4      
filter2_bNhi machoLMCSource, machoSMCSource MACHO Filter 2, blue: number points sigmathreshold high within duration of filter at peak (bfiltime) smallint 2      
filter2_rfilmax machoLMCSource, machoSMCSource MACHO Filter 2, red: max value of optimum filter for LC real 4      
filter2_rfiltime machoLMCSource, machoSMCSource MACHO Filter 2, red: LC time at which maximum occurred real 4      
filter2_rNhi machoLMCSource, machoSMCSource MACHO Filter 2, red: number points sigmathreshold high within duration of filter at peak (rfiltime) smallint 2      
filter3_bfilmax machoLMCSource, machoSMCSource MACHO Filter 3, blue: max value of optimum filter for LC real 4      
filter3_bfiltime machoLMCSource, machoSMCSource MACHO Filter 3, blue: LC time at which maximum occurred real 4      
filter3_bNhi machoLMCSource, machoSMCSource MACHO Filter 3, blue: number points sigmathreshold high within duration of filter at peak (bfiltime) smallint 2      
filter3_rfilmax machoLMCSource, machoSMCSource MACHO Filter 3, red: max value of optimum filter for LC real 4      
filter3_rfiltime machoLMCSource, machoSMCSource MACHO Filter 3, red: LC time at which maximum occurred real 4      
filter3_rNhi machoLMCSource, machoSMCSource MACHO Filter 3, red: number points sigmathreshold high within duration of filter at peak (rfiltime) smallint 2      
filterID Filter VSASVORION UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID Filter VSAUltraVISTA UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID Filter VSAVHS UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID Filter VSAVIDEO UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID Filter VSAVIKING UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID Filter VSAVMC UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID Filter VSAVVV UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID Filter, Multiframe, RequiredMosaic VSASVNGC253 UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID Filter, RequiredFilters, RequiredStack, RequiredTile, ultravistaMultiframe, ultravistaMultiframeDetector, vhsMultiframe, vhsMultiframeDetector, videoMultiframe, videoMultiframeDetector, vikingMultiframe, vikingMultiframeDetector, vmcMultiframe, vmcMultiframeDetector, vvvMultiframe, vvvMultiframeDetector VSAQC UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) tinyint 1     INST_FILTER_CODE
filterID MultiframeDetector VSASVNGC253 UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} tinyint 1     INST_FILTER_CODE
filterID MultiframeDetector VSASVORION UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} tinyint 1     INST_FILTER_CODE
filterID MultiframeDetector VSAUltraVISTA UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} tinyint 1     INST_FILTER_CODE
filterID MultiframeDetector VSAVHS UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} tinyint 1     INST_FILTER_CODE
filterID MultiframeDetector VSAVIDEO UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} tinyint 1     INST_FILTER_CODE
filterID MultiframeDetector VSAVIKING UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} tinyint 1     INST_FILTER_CODE
filterID MultiframeDetector VSAVMC UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} tinyint 1     INST_FILTER_CODE
filterID MultiframeDetector VSAVVV UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} tinyint 1     INST_FILTER_CODE
filterID svNgc253Detection VSASVNGC253 UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks,8=blank) tinyint 1     INST_FILTER_CODE
filterID svOrionDetection VSASVORION UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks,8=blank) tinyint 1     INST_FILTER_CODE
filterID ultravistaDetection VSAUltraVISTA UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks,8=blank) tinyint 1     INST_FILTER_CODE
filterID ultravistaDetection, vhsDetection, videoDetection, vikingDetection, vmcDetection, vvvDetection VSAQC UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks,8=blank) tinyint 1     INST_FILTER_CODE
filterID ultravistaListRemeasurement VSAUltraVISTA UID of combined filter (assigned in WSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank) tinyint 1     INST_FILTER_CODE
filterID ultravistaListRemeasurement, vhsListRemeasurement, videoListRemeasurement, vikingListRemeasurement, vvvListRemeasurement VSAQC UID of combined filter (assigned in WSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank) tinyint 1     INST_FILTER_CODE
filterID vmcListRemeasurement VSAQC UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank) tinyint 1     INST_FILTER_CODE
filterID vmcListRemeasurement VSAVMC UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank) tinyint 1     INST_FILTER_CODE
filterN machoLMCSource, machoSMCSource MACHO number of filters applied; always 3 smallint 2      
filterName Multiframe VSASVNGC253 VISTA combined filter name {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} varchar 16     ??
filterName Multiframe VSASVORION VISTA combined filter name {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} varchar 16     ??
filterName Multiframe VSAUltraVISTA VISTA combined filter name {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} varchar 16     ??
filterName Multiframe VSAVHS VISTA combined filter name {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} varchar 16     ??
filterName Multiframe VSAVIDEO VISTA combined filter name {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} varchar 16     ??
filterName Multiframe VSAVIKING VISTA combined filter name {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} varchar 16     ??
filterName Multiframe VSAVMC VISTA combined filter name {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} varchar 16     ??
filterName Multiframe VSAVVV VISTA combined filter name {image primary HDU keyword: HIERARCH ESO INS FILT1 NAME} varchar 16     ??
filterName ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC VISTA combined filter name varchar 16     ??
fInt first08Jul16Source, firstSource FIRST integrated flux densities real 4 mJy   PHOT_FLUX_RADIO_1.4G
FJ glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 2MASS All-Sky PSC J Band flux real 4 mJy -999.9  
FJ_err glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 2MASS All-Sky PSC J Band 1 sigma error real 4 mJy -999.9  
FKs glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 2MASS All-Sky PSC Ks Band flux real 4 mJy -999.9  
FKs_err glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE 2MASS All-Sky PSC Ks Band 1 sigma error real 4 mJy -999.9  
flag ultravistaSourceXDetectionBestMatch VSAUltraVISTA Flag for potential matching problems tinyint 1   0  
flag=1 if the same intermediate stack detection is linked to two different unique sources. This can happen in images where the seeing was poorer than average or if a source has moved over time and overlaps with another source. flag=2 no intermediate stack detection, but the expected location is in 1 dither offset of the edge of the stack.
flag ultravistaSourceXDetectionBestMatch, videoSourceXDetectionBestMatch, vikingSourceXDetectionBestMatch, vvvSourceXDetectionBestMatch VSAQC Flag for potential matching problems tinyint 1   0  
flag=1 if the same intermediate stack detection is linked to two different unique sources. This can happen in images where the seeing was poorer than average or if a source has moved over time and overlaps with another source. flag=2 no intermediate stack detection, but the expected location is in 1 dither offset of the edge of the stack.
flag vmcSourceXSynopticSourceBestMatch VSAQC Flag for potential matching problems int 4   0  
flag=1 if the same intermediate stack detection is linked to two different unique sources. This can happen in images where the seeing was poorer than average or if a source has moved over time and overlaps with another source. flag=2 no intermediate stack detection, but the expected location is in 1 dither offset of the edge of the stack.
flag vmcSourceXSynopticSourceBestMatch VSAVMC Flag for potential matching problems int 4   0  
flag=1 if the same intermediate stack detection is linked to two different unique sources. This can happen in images where the seeing was poorer than average or if a source has moved over time and overlaps with another source. flag=2 no intermediate stack detection, but the expected location is in 1 dither offset of the edge of the stack.
flag160 sage_lmcMips160Source SPITZER How many times a source was observed by different AORs in a single epoch int 4      
flag24 sage_lmcMips24Source SPITZER How many times a source was observed by different AORs in a single epoch int 4      
flag70 sage_lmcMips70Source SPITZER How many times a source was observed by different AORs in a single epoch int 4      
FLAGS mgcDetection MGC Extraction flags int 4      
flatID Multiframe VSASVNGC253 UID of library calibration flatfield frame {image extension keyword: FLATCOR} bigint 8   -99999999 ID_FRAME
flatID Multiframe VSASVORION UID of library calibration flatfield frame {image extension keyword: FLATCOR} bigint 8   -99999999 ID_FRAME
flatID Multiframe VSAUltraVISTA UID of library calibration flatfield frame {image extension keyword: FLATCOR} bigint 8   -99999999 ID_FRAME
flatID Multiframe VSAVHS UID of library calibration flatfield frame {image extension keyword: FLATCOR} bigint 8   -99999999 ID_FRAME
flatID Multiframe VSAVIDEO UID of library calibration flatfield frame {image extension keyword: FLATCOR} bigint 8   -99999999 ID_FRAME
flatID Multiframe VSAVIKING UID of library calibration flatfield frame {image extension keyword: FLATCOR} bigint 8   -99999999 ID_FRAME
flatID Multiframe VSAVMC UID of library calibration flatfield frame {image extension keyword: FLATCOR} bigint 8   -99999999 ID_FRAME
flatID Multiframe VSAVVV UID of library calibration flatfield frame {image extension keyword: FLATCOR} bigint 8   -99999999 ID_FRAME
flatID ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC UID of library calibration flatfield frame bigint 8   -99999999 ID_FRAME
flux160 sage_lmcMips160Source SPITZER 160um flux float 8 mJy    
flux24 sage_lmcMips24Source SPITZER 24um flux float 8 mJy    
flux3_6 sage_lmcIracSource SPITZER 3.6um flux real 4 mJy    
flux4_5 sage_lmcIracSource SPITZER 4.5um flux real 4 mJy    
flux5_8 sage_lmcIracSource SPITZER 5.8um flux real 4 mJy    
flux70 sage_lmcMips70Source SPITZER 70um flux float 8 mJy    
flux8_0 sage_lmcIracSource SPITZER 8.0um flux real 4 mJy    
flux_100 iras_psc IRAS Averaged non-color corrected 100 micron flux density real 4 Jansky (1.0E-26 W/m**2/Hz)   PHOT_FLUX_IR_100
flux_12 iras_psc IRAS Averaged non-color corrected 12 micron flux density real 4 Jansky (1.0E-26 W/m**2/Hz)   PHOT_FLUX_IR_12
flux_25 iras_psc IRAS Averaged non-color corrected 25 micron flux density real 4 Jansky (1.0E-26 W/m**2/Hz)   PHOT_FLUX_IR_25
flux_60 iras_psc IRAS Averaged non-color corrected 60 micron flux density real 4 Jansky (1.0E-26 W/m**2/Hz)   PHOT_FLUX_IR_60
fluxH sage_lmcIracSource SPITZER H band flux real 4 mJy    
fluxJ sage_lmcIracSource SPITZER J band flux real 4 mJy    
fluxK sage_lmcIracSource SPITZER K band flux real 4 mJy    
FMAG grs_ngpSource, grs_ranSource, grs_sgpSource TWODFGRS Unmatched raw APM 2" profile integrated mag real 4      
fMaj first08Jul16Source, firstSource FIRST major axes derived from the elliptical Gaussian model for the source before deconvolution. real 4 arcsec   EXTENSION_FWHM_MAJ
fMin first08Jul16Source, firstSource FIRST minor axes derived from the elliptical Gaussian model for the source before deconvolution. real 4 arcsec   EXTENSION_FWHM_MIN
focus twomass_scn 2MASS Focus setting of telescope at beginning of scan. smallint 2     TEL_FOCAL-LENGTH
focus twomass_sixx2_scn 2MASS telescope focus setting smallint 2      
FOCUS_R spectra SIXDF R frame spectrograph focus value real 4      
FOCUS_V spectra SIXDF V frame spectrograph focus value real 4      
fPA first08Jul16Source, firstSource FIRST position angle (east of north) derived from the elliptical Gaussian model for the source before deconvolution. real 4 degrees   POS_POS-ANG
fPeak first08Jul16Source, firstSource FIRST peak flux densities real 4 mJy   PHOT_FLUX_RADIO_1.4G
fQual_100 iras_psc IRAS 100 micron flux density quality. smallint 2     CODE_QUALITY
fQual_12 iras_psc IRAS 12 micron flux density quality. smallint 2     CODE_QUALITY
fQual_25 iras_psc IRAS 25 micron flux density quality. smallint 2     CODE_QUALITY
fQual_60 iras_psc IRAS 60 micron flux density quality. smallint 2     CODE_QUALITY
frameCode svNgc253Detection VSASVNGC253 Code for frameType of science frame from which these data were extracted tinyint 1   0  
Post-processing bit flag assigned to represent the frameType of the image that the detections were extracted from. Catalogues come from frames that are interleaved (leav) and stacked or simply stacked (stack). These may be filtered (filt) to remove variations in the background at certain scales. 6 VISTA pawprint stacks are typically tiled (tile) to make a 1.5 square degree tile. Pawprints or tiles may be stacked to produce deep stacks or tiles (deep) and multiple tiles may be mosaicked together to produce a mosaic (mosaic). Thus a science image may be one of several types and the catalogue data from these images may or may not be used in different curation use cases or by different users. The error bit flag allows users to select or reject different data.
BitFrameType
DecimalHexadecimal
-- NONE 0 0x00000000
0 leav 1 0x00000001
1 stack 2 0x00000010
2 filt 4 0x00000100
3 tile 8 0x00001000
4 deep 16 0x00010000
5 mosaic 32 0x00100000

Different frame types can be built up from these bit flags. E.g., a mosaicdeepstack would be 0x00110010 or 50 in decimal. A tile would always have bit 3 set to 1. The decimal threshold (column 4) gives the minimum value of the quality flag for a detection having the given condition (since other bits in the flag may be set also; the corresponding hexadecimal value, where each digit corresponds to 4 bits in the flag, can be easier to compute when writing SQL queries to test for a given condition). For example, to exclude all detections in the VHS from tile frames, but not deep tile frames, include a predicate ... AND frameCode & 0x00001000 = 1 AND frameCode & 0x00010000 = 0. See the SQL Cookbook and other online pages for further information. All other frameTypes, such as normal, sky, dark, conf have frameCode=0.
frameCode svOrionDetection VSASVORION Code for frameType of science frame from which these data were extracted tinyint 1   0  
Post-processing bit flag assigned to represent the frameType of the image that the detections were extracted from. Catalogues come from frames that are interleaved (leav) and stacked or simply stacked (stack). These may be filtered (filt) to remove variations in the background at certain scales. 6 VISTA pawprint stacks are typically tiled (tile) to make a 1.5 square degree tile. Pawprints or tiles may be stacked to produce deep stacks or tiles (deep) and multiple tiles may be mosaicked together to produce a mosaic (mosaic). Thus a science image may be one of several types and the catalogue data from these images may or may not be used in different curation use cases or by different users. The error bit flag allows users to select or reject different data.
BitFrameType
DecimalHexadecimal
-- NONE 0 0x00000000
0 leav 1 0x00000001
1 stack 2 0x00000010
2 filt 4 0x00000100
3 tile 8 0x00001000
4 deep 16 0x00010000
5 mosaic 32 0x00100000

Different frame types can be built up from these bit flags. E.g., a mosaicdeepstack would be 0x00110010 or 50 in decimal. A tile would always have bit 3 set to 1. The decimal threshold (column 4) gives the minimum value of the quality flag for a detection having the given condition (since other bits in the flag may be set also; the corresponding hexadecimal value, where each digit corresponds to 4 bits in the flag, can be easier to compute when writing SQL queries to test for a given condition). For example, to exclude all detections in the VHS from tile frames, but not deep tile frames, include a predicate ... AND frameCode & 0x00001000 = 1 AND frameCode & 0x00010000 = 0. See the SQL Cookbook and other online pages for further information. All other frameTypes, such as normal, sky, dark, conf have frameCode=0.
frameCode ultravistaDetection VSAUltraVISTA Code for frameType of science frame from which these data were extracted tinyint 1   0  
Post-processing bit flag assigned to represent the frameType of the image that the detections were extracted from. Catalogues come from frames that are interleaved (leav) and stacked or simply stacked (stack). These may be filtered (filt) to remove variations in the background at certain scales. 6 VISTA pawprint stacks are typically tiled (tile) to make a 1.5 square degree tile. Pawprints or tiles may be stacked to produce deep stacks or tiles (deep) and multiple tiles may be mosaicked together to produce a mosaic (mosaic). Thus a science image may be one of several types and the catalogue data from these images may or may not be used in different curation use cases or by different users. The error bit flag allows users to select or reject different data.
BitFrameType
DecimalHexadecimal
-- NONE 0 0x00000000
0 leav 1 0x00000001
1 stack 2 0x00000010
2 filt 4 0x00000100
3 tile 8 0x00001000
4 deep 16 0x00010000
5 mosaic 32 0x00100000

Different frame types can be built up from these bit flags. E.g., a mosaicdeepstack would be 0x00110010 or 50 in decimal. A tile would always have bit 3 set to 1. The decimal threshold (column 4) gives the minimum value of the quality flag for a detection having the given condition (since other bits in the flag may be set also; the corresponding hexadecimal value, where each digit corresponds to 4 bits in the flag, can be easier to compute when writing SQL queries to test for a given condition). For example, to exclude all detections in the VHS from tile frames, but not deep tile frames, include a predicate ... AND frameCode & 0x00001000 = 1 AND frameCode & 0x00010000 = 0. See the SQL Cookbook and other online pages for further information. All other frameTypes, such as normal, sky, dark, conf have frameCode=0.
frameCode ultravistaDetection, vhsDetection, videoDetection, vikingDetection, vmcDetection, vvvDetection VSAQC Code for frameType of science frame from which these data were extracted tinyint 1   0  
Post-processing bit flag assigned to represent the frameType of the image that the detections were extracted from. Catalogues come from frames that are interleaved (leav) and stacked or simply stacked (stack). These may be filtered (filt) to remove variations in the background at certain scales. 6 VISTA pawprint stacks are typically tiled (tile) to make a 1.5 square degree tile. Pawprints or tiles may be stacked to produce deep stacks or tiles (deep) and multiple tiles may be mosaicked together to produce a mosaic (mosaic). Thus a science image may be one of several types and the catalogue data from these images may or may not be used in different curation use cases or by different users. The error bit flag allows users to select or reject different data.
BitFrameType
DecimalHexadecimal
-- NONE 0 0x00000000
0 leav 1 0x00000001
1 stack 2 0x00000010
2 filt 4 0x00000100
3 tile 8 0x00001000
4 deep 16 0x00010000
5 mosaic 32 0x00100000

Different frame types can be built up from these bit flags. E.g., a mosaicdeepstack would be 0x00110010 or 50 in decimal. A tile would always have bit 3 set to 1. The decimal threshold (column 4) gives the minimum value of the quality flag for a detection having the given condition (since other bits in the flag may be set also; the corresponding hexadecimal value, where each digit corresponds to 4 bits in the flag, can be easier to compute when writing SQL queries to test for a given condition). For example, to exclude all detections in the VHS from tile frames, but not deep tile frames, include a predicate ... AND frameCode & 0x00001000 = 1 AND frameCode & 0x00010000 = 0. See the SQL Cookbook and other online pages for further information. All other frameTypes, such as normal, sky, dark, conf have frameCode=0.
frameSetID svNgc253MergeLog VSASVNGC253 frame set ID, unique over the whole WSA via programme ID prefix, assigned by merging procedure bigint 8     ID_FIELD
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID svNgc253Source VSASVNGC253 UID of the set of frames that this merged source comes from bigint 8     REFER_CODE
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID svOrionMergeLog VSASVORION frame set ID, unique over the whole WSA via programme ID prefix, assigned by merging procedure bigint 8     ID_FIELD
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID svOrionSource VSASVORION UID of the set of frames that this merged source comes from bigint 8     REFER_CODE
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID ultravistaMergeLog VSAUltraVISTA frame set ID, unique over the whole WSA via programme ID prefix, assigned by merging procedure bigint 8     ID_FIELD
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID ultravistaMergeLog, ultravistaVarFrameSetInfo, ultravistaVariability, vhsMergeLog, videoMergeLog, videoVarFrameSetInfo, videoVariability, vikingMergeLog, vikingVarFrameSetInfo, vikingVariability, vvvMergeLog, vvvVarFrameSetInfo, vvvVariability VSAQC frame set ID, unique over the whole WSA via programme ID prefix, assigned by merging procedure bigint 8     ID_FIELD
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID ultravistaSource VSAUltraVISTA UID of the set of frames that this merged source comes from bigint 8     REFER_CODE
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID ultravistaSource, vhsSource, videoSource, vikingSource, vmcSource, vvvSource VSAQC UID of the set of frames that this merged source comes from bigint 8     REFER_CODE
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID ultravistaSourceRemeasurement VSAUltraVISTA UID of the set of frames that this remeasured source comes from bigint 8     REFER_CODE
frameSetID ultravistaSourceRemeasurement, vhsSourceRemeasurement, videoSourceRemeasurement, vikingSourceRemeasurement, vmcSourceRemeasurement, vvvSourceRemeasurement VSAQC UID of the set of frames that this remeasured source comes from bigint 8     REFER_CODE
frameSetID vmcMergeLog VSAVMC frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure bigint 8     ID_FIELD
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetID vmcMergeLog, vmcVarFrameSetInfo, vmcVariability VSAQC frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure bigint 8     ID_FIELD
Each merged source in the merged source tables come from a set of individual passband frames (with different filters and/or different epochs of observation). In the WSA, a frame is generally the image provided by one detector (dither-stacked and interlaced as appropriate); hence a frame set comprises a set of individual detector frames in different passbands and/or at different observation epochs. Each frame set is uniquely identified by the attribute frameSetID, and this references a row in the corresponding merge log for the source table (for example, vhsSource.frameSetID references whsMergeLog.frameSetID. The merge log in turn references the full set of image descriptive data held in the tables MultiframeDetector and ultimately Multiframe (these two tables map directly onto the multi-extension FITS file hierarchy of extension FITS headers beneath a single primary HDU FITS header - primary HDU FITS keys will be found in Multiframe, while the corresponding extension FITS keys for each primary set will be found in table MultiframeDetector). In this way, you can trace the provenance of a merged source record right back to the individual image frames from which it is derived.
frameSetTolerance Programme VSAQC The match tolerance for different passband frames real 4 Degrees   ??
frameSetTolerance Programme VSASVNGC253 The match tolerance for different passband frames real 4 Degrees   ??
frameSetTolerance Programme VSASVORION The match tolerance for different passband frames real 4 Degrees   ??
frameSetTolerance Programme VSAUltraVISTA The match tolerance for different passband frames real 4 Degrees   ??
frameSetTolerance Programme VSAVHS The match tolerance for different passband frames real 4 Degrees   ??
frameSetTolerance Programme VSAVIDEO The match tolerance for different passband frames real 4 Degrees   ??
frameSetTolerance Programme VSAVIKING The match tolerance for different passband frames real 4 Degrees   ??
frameSetTolerance Programme VSAVMC The match tolerance for different passband frames real 4 Degrees   ??
frameSetTolerance Programme VSAVVV The match tolerance for different passband frames real 4 Degrees   ??
frameType Multiframe VSASVNGC253 The type of multiframe (e.g. stack|tile|mosaic etc.)
A multiframe can have a combination of different types.
varchar 64   normal meta.code.class
The frame types and their abbreviations are:
confidence = "conf"dark = "dark" deep = "deep"difference = "diff" filtered = "filt"
flat = "flat" interleaved = "leav"mosaic = "mosaic" sky = "sky"stack = "stack" default value = "normal"
frameType Multiframe VSASVORION The type of multiframe (e.g. stack|tile|mosaic etc.)
A multiframe can have a combination of different types.
varchar 64   normal meta.code.class
The frame types and their abbreviations are:
confidence = "conf"dark = "dark" deep = "deep"difference = "diff" filtered = "filt"
flat = "flat" interleaved = "leav"mosaic = "mosaic" sky = "sky"stack = "stack" default value = "normal"
frameType Multiframe VSAUltraVISTA The type of multiframe (e.g. stack|tile|mosaic etc.)
A multiframe can have a combination of different types.
varchar 64   normal meta.code.class
The frame types and their abbreviations are:
confidence = "conf"dark = "dark" deep = "deep"difference = "diff" filtered = "filt"
flat = "flat" interleaved = "leav"mosaic = "mosaic" sky = "sky"stack = "stack" default value = "normal"
frameType Multiframe VSAVHS The type of multiframe (e.g. stack|tile|mosaic etc.)
A multiframe can have a combination of different types.
varchar 64   normal meta.code.class
The frame types and their abbreviations are:
confidence = "conf"dark = "dark" deep = "deep"difference = "diff" filtered = "filt"
flat = "flat" interleaved = "leav"mosaic = "mosaic" sky = "sky"stack = "stack" default value = "normal"
frameType Multiframe VSAVIDEO The type of multiframe (e.g. stack|tile|mosaic etc.)
A multiframe can have a combination of different types.
varchar 64   normal meta.code.class
The frame types and their abbreviations are:
confidence = "conf"dark = "dark" deep = "deep"difference = "diff" filtered = "filt"
flat = "flat" interleaved = "leav"mosaic = "mosaic" sky = "sky"stack = "stack" default value = "normal"
frameType Multiframe VSAVIKING The type of multiframe (e.g. stack|tile|mosaic etc.)
A multiframe can have a combination of different types.
varchar 64   normal meta.code.class
The frame types and their abbreviations are:
confidence = "conf"dark = "dark" deep = "deep"difference = "diff" filtered = "filt"
flat = "flat" interleaved = "leav"mosaic = "mosaic" sky = "sky"stack = "stack" default value = "normal"
frameType Multiframe VSAVMC The type of multiframe (e.g. stack|tile|mosaic etc.)
A multiframe can have a combination of different types.
varchar 64   normal meta.code.class
The frame types and their abbreviations are:
confidence = "conf"dark = "dark" deep = "deep"difference = "diff" filtered = "filt"
flat = "flat" interleaved = "leav"mosaic = "mosaic" sky = "sky"stack = "stack" default value = "normal"
frameType Multiframe VSAVVV The type of multiframe (e.g. stack|tile|mosaic etc.)
A multiframe can have a combination of different types.
varchar 64   normal meta.code.class
The frame types and their abbreviations are:
confidence = "conf"dark = "dark" deep = "deep"difference = "diff" filtered = "filt"
flat = "flat" interleaved = "leav"mosaic = "mosaic" sky = "sky"stack = "stack" default value = "normal"
frameType ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC The type of multiframe (e.g. stack|tile|mosaic etc.) varchar 64   normal meta.code.class
frinID Multiframe VSASVNGC253 UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
frinID Multiframe VSASVORION UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
frinID Multiframe VSAUltraVISTA UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
frinID Multiframe VSAVHS UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
frinID Multiframe VSAVIDEO UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
frinID Multiframe VSAVIKING UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
frinID Multiframe VSAVMC UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
frinID Multiframe VSAVVV UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
frinID ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC UID of library calibration fringe frame bigint 8   -99999999 ID_FRAME
FWHM_IMAGE mgcDetection MGC FWHM assuming a gaussian core real 4 pixel    



Home | Overview | Browser | Access | Login | Cookbook
Listing | FreeSQL
Links | Credits

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK
Tel +44 131 668 8356 (office)
or +44 131 668 8100 (switchboard)

vsa-support@roe.ac.uk
21/02/2011