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

U

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
UbMag combo17CDFSSource COMBO17 Absolute restframe magnitude in Bessell U (calculated from redshifted best_fit template, depending on redshift and filter extrapolation outside the COMBO-17 filter set can be necessary, only calculated for objects classified as galaxies) real 4 mag    
UF_F combo17CDFSSource COMBO17 flux in filter U in run F (21.09.-30.09.2000) float 8      
UF_G combo17CDFSSource COMBO17 flux in filter U in run G (19.01.-20.01.2001) float 8      
UF_S combo17CDFSSource COMBO17 combined flux in filter U; corrected for the gain of the CCD and only applied to objects without variability flag float 8      
UjMag combo17CDFSSource COMBO17 Absolute restframe magnitude in Johnson U (calculated from redshifted best_fit template, depending on redshift and filter extrapolation outside the COMBO-17 filter set can be necessary, only calculated for objects classified as galaxies) real 4 mag    
Umag mcps_lmcSource, mcps_smcSource MCPS The U band magnitude. (0.00 if star not detected.) real 4 mag    
unfilteredID Multiframe VSASVNGC253 UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
unfilteredID Multiframe VSASVORION UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
unfilteredID Multiframe VSAUltraVISTA UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
unfilteredID Multiframe VSAVHS UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
unfilteredID Multiframe VSAVIDEO UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
unfilteredID Multiframe VSAVIKING UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
unfilteredID Multiframe VSAVMC UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
unfilteredID Multiframe VSAVVV UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
unfilteredID ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC UID of original unfiltered frame corresponding to this filtered frame bigint 8   -99999999 ID_FRAME
UR_BULGE mgcGalaxyStruct MGC Bulge (u-r) colour real 4 AB mag -99.9  
UR_DISK mgcGalaxyStruct MGC Disk (u-r) colour real 4 AB mag -99.9  
UR_TOTAL mgcGalaxyStruct MGC Total (u-r) Colour real 4 AB mag -99.9  
use_src twomass_psc, twomass_xsc 2MASS Use source flag. smallint 2     CODE_MISC
usMag combo17CDFSSource COMBO17 Absolute restframe magnitude in SDSS u (calculated from redshifted best_fit template, depending on redshift and filter extrapolation outside the COMBO-17 filter set can be necessary, only calculated for objects classified as galaxies) real 4 mag    
uStepID Multiframe VSASVNGC253 Sequence number of ustep {image primary HDU keyword: USTEP_I} tinyint 1   0  
uStepID Multiframe VSASVORION Sequence number of ustep {image primary HDU keyword: USTEP_I} tinyint 1   0  
uStepID Multiframe VSAUltraVISTA Sequence number of ustep {image primary HDU keyword: USTEP_I} tinyint 1   0  
uStepID Multiframe VSAVHS Sequence number of ustep {image primary HDU keyword: USTEP_I} tinyint 1   0  
uStepID Multiframe VSAVIDEO Sequence number of ustep {image primary HDU keyword: USTEP_I} tinyint 1   0  
uStepID Multiframe VSAVIKING Sequence number of ustep {image primary HDU keyword: USTEP_I} tinyint 1   0  
uStepID Multiframe VSAVMC Sequence number of ustep {image primary HDU keyword: USTEP_I} tinyint 1   0  
uStepID Multiframe VSAVVV Sequence number of ustep {image primary HDU keyword: USTEP_I} tinyint 1   0  
uStepID ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC Sequence number of ustep tinyint 1   0  
uStepName Multiframe VSASVNGC253 Name of ustep pattern {image primary HDU keyword: USTEP_ID} varchar 8   NONE  
uStepName Multiframe VSASVORION Name of ustep pattern {image primary HDU keyword: USTEP_ID} varchar 8   NONE  
uStepName Multiframe VSAUltraVISTA Name of ustep pattern {image primary HDU keyword: USTEP_ID} varchar 8   NONE  
uStepName Multiframe VSAVHS Name of ustep pattern {image primary HDU keyword: USTEP_ID} varchar 8   NONE  
uStepName Multiframe VSAVIDEO Name of ustep pattern {image primary HDU keyword: USTEP_ID} varchar 8   NONE  
uStepName Multiframe VSAVIKING Name of ustep pattern {image primary HDU keyword: USTEP_ID} varchar 8   NONE  
uStepName Multiframe VSAVMC Name of ustep pattern {image primary HDU keyword: USTEP_ID} varchar 8   NONE  
uStepName Multiframe VSAVVV Name of ustep pattern {image primary HDU keyword: USTEP_ID} varchar 8   NONE  
uStepName ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC Name of ustep pattern varchar 8   NONE  
uStepNum Multiframe VSASVNGC253 Value of 1st OBSNUM in ustep seq {image primary HDU keyword: USTEPNUM} int 4   -99999999  
uStepNum Multiframe VSASVORION Value of 1st OBSNUM in ustep seq {image primary HDU keyword: USTEPNUM} int 4   -99999999  
uStepNum Multiframe VSAUltraVISTA Value of 1st OBSNUM in ustep seq {image primary HDU keyword: USTEPNUM} int 4   -99999999  
uStepNum Multiframe VSAVHS Value of 1st OBSNUM in ustep seq {image primary HDU keyword: USTEPNUM} int 4   -99999999  
uStepNum Multiframe VSAVIDEO Value of 1st OBSNUM in ustep seq {image primary HDU keyword: USTEPNUM} int 4   -99999999  
uStepNum Multiframe VSAVIKING Value of 1st OBSNUM in ustep seq {image primary HDU keyword: USTEPNUM} int 4   -99999999  
uStepNum Multiframe VSAVMC Value of 1st OBSNUM in ustep seq {image primary HDU keyword: USTEPNUM} int 4   -99999999  
uStepNum Multiframe VSAVVV Value of 1st OBSNUM in ustep seq {image primary HDU keyword: USTEPNUM} int 4   -99999999  
uStepNum ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC Value of 1st OBSNUM in ustep seq int 4   -99999999  
uStepX Multiframe VSASVNGC253 X offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_X} real 4   -0.9999995e9  
uStepX Multiframe VSASVORION X offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_X} real 4   -0.9999995e9  
uStepX Multiframe VSAUltraVISTA X offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_X} real 4   -0.9999995e9  
uStepX Multiframe VSAVHS X offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_X} real 4   -0.9999995e9  
uStepX Multiframe VSAVIDEO X offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_X} real 4   -0.9999995e9  
uStepX Multiframe VSAVIKING X offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_X} real 4   -0.9999995e9  
uStepX Multiframe VSAVMC X offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_X} real 4   -0.9999995e9  
uStepX Multiframe VSAVVV X offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_X} real 4   -0.9999995e9  
uStepX ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC X offset in ustep pattern [arcsec] real 4   -0.9999995e9  
uStepY Multiframe VSASVNGC253 Y offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_Y} real 4   -0.9999995e9  
uStepY Multiframe VSASVORION Y offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_Y} real 4   -0.9999995e9  
uStepY Multiframe VSAUltraVISTA Y offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_Y} real 4   -0.9999995e9  
uStepY Multiframe VSAVHS Y offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_Y} real 4   -0.9999995e9  
uStepY Multiframe VSAVIDEO Y offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_Y} real 4   -0.9999995e9  
uStepY Multiframe VSAVIKING Y offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_Y} real 4   -0.9999995e9  
uStepY Multiframe VSAVMC Y offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_Y} real 4   -0.9999995e9  
uStepY Multiframe VSAVVV Y offset in ustep pattern [arcsec] {image primary HDU keyword: USTEP_Y} real 4   -0.9999995e9  
uStepY ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC Y offset in ustep pattern [arcsec] real 4   -0.9999995e9  
ut twomass_scn 2MASS Universal Time (UT) at beginning of scan. float 8 hr   TIME_DATE
ut twomass_sixx2_scn 2MASS beginning UT of scan data float 8 hrs    
utc Multiframe VSASVNGC253 UTC at start (sec) {image primary HDU keyword: UTC} real 4   -0.9999995e9  
utc Multiframe VSASVORION UTC at start (sec) {image primary HDU keyword: UTC} real 4   -0.9999995e9  
utc Multiframe VSAUltraVISTA UTC at start (sec) {image primary HDU keyword: UTC} real 4   -0.9999995e9  
utc Multiframe VSAVHS UTC at start (sec) {image primary HDU keyword: UTC} real 4   -0.9999995e9  
utc Multiframe VSAVIDEO UTC at start (sec) {image primary HDU keyword: UTC} real 4   -0.9999995e9  
utc Multiframe VSAVIKING UTC at start (sec) {image primary HDU keyword: UTC} real 4   -0.9999995e9  
utc Multiframe VSAVMC UTC at start (sec) {image primary HDU keyword: UTC} real 4   -0.9999995e9  
utc Multiframe VSAVVV UTC at start (sec) {image primary HDU keyword: UTC} real 4   -0.9999995e9  
utc ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC UTC at start (sec) real 4   -0.9999995e9  
utDate Multiframe VSASVNGC253 Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
utDate Multiframe VSASVORION Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
utDate Multiframe VSAUltraVISTA Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
utDate Multiframe VSAVHS Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
utDate Multiframe VSAVIDEO Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
utDate Multiframe VSAVIKING Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
utDate Multiframe VSAVMC Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
utDate Multiframe VSAVVV Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
utDate ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe VSAQC Observation date (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
UTDATE_R spectra SIXDF UT date in R frame datetime 8 MM-DD-YYYY    
UTDATE_V spectra SIXDF UT date in V frame datetime 8 MM-DD-YYYY    
UTSTRT_R spectra SIXDF UT start time of R reference frame varchar 15 HH-MM-SS    
UTSTRT_V spectra SIXDF UT start time of V reference frame varchar 15 HH-MM-SS    


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