Home | Overview | Browser | Access | Login | Cookbook | nonSurvey 
 
   WSA logo

Glossary of WSA attributes

This Glossary alphabetically lists all attributes used in the UKIDSSDR9 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR9 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

T

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
tableExtName MultiframeDetector WSA Extension name of source FITS binary table {catalogue extension keyword:  EXTNAME} varchar 16   NONE ??
tableExtName MultiframeDetector WSACalib Extension name of source FITS binary table {catalogue extension keyword:  EXTNAME} varchar 16   NONE ??
tableExtName MultiframeDetector WSATransit Extension name of source FITS binary table {catalogue extension keyword:  EXTNAME} varchar 16   NONE ??
tableFields MultiframeDetector WSA No. of fields per row in source FITS binary table {catalogue extension keyword:  TFIELDS} smallint 2   -9999 ??
tableFields MultiframeDetector WSACalib No. of fields per row in source FITS binary table {catalogue extension keyword:  TFIELDS} smallint 2   -9999 ??
tableFields MultiframeDetector WSATransit No. of fields per row in source FITS binary table {catalogue extension keyword:  TFIELDS} smallint 2   -9999 ??
tableGcount MultiframeDetector WSA FITS binary table required keyword {catalogue extension keyword:  GCOUNT} smallint 2   -9999 ??
tableGcount MultiframeDetector WSACalib FITS binary table required keyword {catalogue extension keyword:  GCOUNT} smallint 2   -9999 ??
tableGcount MultiframeDetector WSATransit FITS binary table required keyword {catalogue extension keyword:  GCOUNT} smallint 2   -9999 ??
tableID ProgrammeTable WSA the unique table ID int 4     ID_MAIN
tableID ProgrammeTable WSACalib the unique table ID int 4     ID_MAIN
tableID ProgrammeTable WSATransit the unique table ID int 4     ID_MAIN
tableID RequiredListDrivenProduct WSA the unique ID of the table with the source list driving the remeasurements int 4     ID_MAIN
tableID RequiredListDrivenProduct WSACalib the unique ID of the table with the source list driving the remeasurements int 4     ID_MAIN
tableID RequiredListDrivenProduct WSATransit the unique ID of the table with the source list driving the remeasurements int 4     ID_MAIN
tableID RequiredNeighbours WSA the unique identifier for the programme table int 4     ID_SURVEY
tableID RequiredNeighbours WSACalib the unique identifier for the programme table int 4     ID_SURVEY
tableID RequiredNeighbours WSATransit the unique identifier for the programme table int 4     ID_SURVEY
tableName ProgrammeTable WSA the name of the table varchar 256     ID_TABLE
tableName ProgrammeTable WSACalib the name of the table varchar 256     ID_TABLE
tableName ProgrammeTable WSATransit the name of the table varchar 256     ID_TABLE
tablePcount MultiframeDetector WSA FITS binary table required keyword {catalogue extension keyword:  PCOUNT} smallint 2   -9999 ??
tablePcount MultiframeDetector WSACalib FITS binary table required keyword {catalogue extension keyword:  PCOUNT} smallint 2   -9999 ??
tablePcount MultiframeDetector WSATransit FITS binary table required keyword {catalogue extension keyword:  PCOUNT} smallint 2   -9999 ??
tableRows MultiframeDetector WSA No. of rows in source FITS binary table {catalogue extension keyword:  NAXIS2} int 4   -99999999 ??
tableRows MultiframeDetector WSACalib No. of rows in source FITS binary table {catalogue extension keyword:  NAXIS2} int 4   -99999999 ??
tableRows MultiframeDetector WSATransit No. of rows in source FITS binary table {catalogue extension keyword:  NAXIS2} int 4   -99999999 ??
tableWidth MultiframeDetector WSA Row size of source FITS binary table {catalogue extension keyword:  NAXIS1} smallint 2 bytes -9999 ??
tableWidth MultiframeDetector WSACalib Row size of source FITS binary table {catalogue extension keyword:  NAXIS1} smallint 2 bytes -9999 ??
tableWidth MultiframeDetector WSATransit Row size of source FITS binary table {catalogue extension keyword:  NAXIS1} smallint 2 bytes -9999 ??
tauCSO Multiframe WSA Tau at 225 GHz from CSO {image primary HDU keyword: CSOTAU} real 4   -0.9999995e9 PHYS_OPTICAL-DEPTH
tauCSO Multiframe WSACalib Tau at 225 GHz from CSO {image primary HDU keyword: CSOTAU} real 4   -0.9999995e9 PHYS_OPTICAL-DEPTH
tauCSO Multiframe WSATransit Tau at 225 GHz from CSO {image primary HDU keyword: CSOTAU} real 4   -0.9999995e9 PHYS_OPTICAL-DEPTH
tauDate Multiframe WSA Time and date of Tau reading {image primary HDU keyword: TAUDATE} datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
tauDate Multiframe WSACalib Time and date of Tau reading {image primary HDU keyword: TAUDATE} datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
tauDate Multiframe WSATransit Time and date of Tau reading {image primary HDU keyword: TAUDATE} datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
tauSource Multiframe WSA Source of opacity data {image primary HDU keyword: TAUSRC} varchar 64   NONE DATA_LINK
tauSource Multiframe WSACalib Source of opacity data {image primary HDU keyword: TAUSRC} varchar 64   NONE DATA_LINK
tauSource Multiframe WSATransit Source of opacity data {image primary HDU keyword: TAUSRC} varchar 64   NONE DATA_LINK
TDFGRS_BJG mgcBrightSpec MGC 2dFGRS final b_J magnitude real 4      
TDFGRS_CLASS mgcBrightSpec MGC MGC translation of TDFGRS_IGAL smallint 2      
TDFGRS_DEC mgcBrightSpec MGC 2dFGRS object declination in deg (J2000) float 8      
TDFGRS_N mgcBrightSpec MGC Number of 2dFGRS objects/spectra for this MGC object smallint 2      
TDFGRS_NAME mgcBrightSpec MGC 2dFGRS object name varchar 10      
TDFGRS_RA mgcBrightSpec MGC 2dFGRS object right ascension in deg (J2000) float 8      
TDFGRS_SBBJMAG mgcBrightSpec MGC SSS b_J magnitude real 4      
TDFGRS_SEQNUM mgcBrightSpec MGC 2dFGRS sequence number bigint 8      
TDFGRS_SEQNUM mgcGalaxyStruct MGC 2dFGRS Serial number bigint 8   0  
TDFGRS_SRRMAG mgcBrightSpec MGC SSS R magnitude real 4      
TDFGRS_UKST mgcBrightSpec MGC UKST survey field number int 4      
TDFGRS_ZHELIO mgcBrightSpec MGC 2dFGRS heliocentric redshift real 4      
TDFGRS_ZQUAL mgcBrightSpec MGC 2dFGRS redshift quality tinyint 1      
TDGRS_BJSEL mgcBrightSpec MGC 2dFGRS final extinction corrected b_J magnitude real 4      
TDGRS_IGAL mgcBrightSpec MGC 2dFGRS classification tinyint 1      
tel_temp twomass_scn 2MASS Telescope girdle temperature at beginning of scan. real 4 degC   PHYS_TEMP_MISC
tel_temp twomass_sixx2_scn 2MASS telescope tube girdle temperature (deg C) at beg. of scan real 4 degC    
telDec Multiframe WSA Current telescope declination {image primary HDU keyword: TELDEC} float 8 degrees -0.9999995e9 POS_EQ_DEC_MAIN
telDec Multiframe WSACalib Current telescope declination {image primary HDU keyword: TELDEC} float 8 degrees -0.9999995e9 POS_EQ_DEC_MAIN
telDec Multiframe WSATransit Current telescope declination {image primary HDU keyword: TELDEC} float 8 degrees -0.9999995e9 POS_EQ_DEC_MAIN
telescope Multiframe WSA Telescope name {image primary HDU keyword: TELESCOP} varchar 32   NONE  
telescope Multiframe WSACalib Telescope name {image primary HDU keyword: TELESCOP} varchar 32   NONE  
telescope Multiframe WSATransit Telescope name {image primary HDU keyword: TELESCOP} varchar 32   NONE  
telFocus Multiframe WSA Telescope focus {image primary HDU keyword: TCS_FOC} real 4   -0.9999995e9  
telFocus Multiframe WSACalib Telescope focus {image primary HDU keyword: TCS_FOC} real 4   -0.9999995e9  
telFocus Multiframe WSATransit Telescope focus {image primary HDU keyword: TCS_FOC} real 4   -0.9999995e9  
telRa Multiframe WSA Current telescope right ascension {image primary HDU keyword: TELRA} float 8 hours -0.9999995e9 POS_EQ_RA_MAIN
telRa Multiframe WSACalib Current telescope right ascension {image primary HDU keyword: TELRA} float 8 hours -0.9999995e9 POS_EQ_RA_MAIN
telRa Multiframe WSATransit Current telescope right ascension {image primary HDU keyword: TELRA} float 8 hours -0.9999995e9 POS_EQ_RA_MAIN
THETA_IMAGE mgcDetection MGC Position angle wrt x axis real 4 deg    
THRESH mgcDetection MGC Detection threshold above background real 4 count    
thresholdIsoph MultiframeDetector WSA Isophotal analysis threshold {catalogue extension keyword:  THRESHOL} real 4 counts -0.9999995e9 ??
Tunable parameter, the default is to set this to 1.5 skynoise as a compromise between detecting close to the limit of the data and not being swamped by spurious sources. It is possible to push the data limit fainter but at the expense of a large increase in spurious sources. LSBG detection requires a more subtle add-on to the catalogue and could be added given suitable demand.
thresholdIsoph MultiframeDetector WSACalib Isophotal analysis threshold {catalogue extension keyword:  THRESHOL} real 4 counts -0.9999995e9 ??
Tunable parameter, the default is to set this to 1.5 skynoise as a compromise between detecting close to the limit of the data and not being swamped by spurious sources. It is possible to push the data limit fainter but at the expense of a large increase in spurious sources. LSBG detection requires a more subtle add-on to the catalogue and could be added given suitable demand.
thresholdIsoph MultiframeDetector WSATransit Isophotal analysis threshold {catalogue extension keyword:  THRESHOL} real 4 counts -0.9999995e9 ??
Tunable parameter, the default is to set this to 1.5 skynoise as a compromise between detecting close to the limit of the data and not being swamped by spurious sources. It is possible to push the data limit fainter but at the expense of a large increase in spurious sources. LSBG detection requires a more subtle add-on to the catalogue and could be added given suitable demand.
tile twomass_scn 2MASS Tile identification number. int 4     ID_NUMBER
tile twomass_sixx2_scn 2MASS tile ID number int 4      
tileNum Multiframe WSA Tile number applied to all members {image primary HDU keyword: TILENUM} int 4   -99999999  
tileNum Multiframe WSACalib Tile number applied to all members {image primary HDU keyword: TILENUM} int 4   -99999999  
tileNum Multiframe WSATransit Tile number applied to all members {image primary HDU keyword: TILENUM} int 4   -99999999  
timeStamp ArchiveCurationHistory WSA Time of the completion of the whole task datetime 8 UTC   TIME_DATE
timeStamp ArchiveCurationHistory WSACalib Time of the completion of the whole task datetime 8 UTC   TIME_DATE
timeStamp ArchiveCurationHistory WSATransit Time of the completion of the whole task datetime 8 UTC   TIME_DATE
timeStamp ProgrammeCurationHistory WSA Time of individual programme curation completion datetime 8 UTC   TIME_DATE
timeStamp ProgrammeCurationHistory WSACalib Time of individual programme curation completion datetime 8 UTC   TIME_DATE
timeStamp ProgrammeCurationHistory WSATransit Time of individual programme curation completion datetime 8 UTC   TIME_DATE
title Programme WSA a short title for the programme, eg. "UKIDSS Large Area Survey" varchar 32     NOTE
title Programme WSACalib a short title for the programme, eg. "UKIDSS Large Area Survey" varchar 32     NOTE
title Programme WSATransit a short title for the programme, eg. "UKIDSS Large Area Survey" varchar 32     NOTE
tmass_key wise_prelimsc WISE Unique identifier of the closest source in the 2MASS Point Source Catalog (PSC) that falls within 3" of the position of this WISE source
This is equivalent to the pts_key in the 2MASS PSC entry. This column is default if there is no 2MASS PSC source within 3" of the WISE source position. The number of 2MASS PSC sources within 3" of the WISE position is given in n_2mass		 bigint 8   -99999999
tmassID glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE Unique identification number for the 2MASS source from the 2MASS All-Sky PSC int 4      
tmassName glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE Source name from 2MASS All-Sky point source catalog (PSC) varchar 32     ID_MAIN
topAirTempNW Multiframe WSA Top air NW {image primary HDU keyword: TOPAIRNW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
topAirTempNW Multiframe WSACalib Top air NW {image primary HDU keyword: TOPAIRNW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
topAirTempNW Multiframe WSATransit Top air NW {image primary HDU keyword: TOPAIRNW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
topRingTemp Multiframe WSA Top ring temperature {image primary HDU keyword: TR_TEMP} real 4 degrees_Kelvin -0.9999995e9  
topRingTemp Multiframe WSACalib Top ring temperature {image primary HDU keyword: TR_TEMP} real 4 degrees_Kelvin -0.9999995e9  
topRingTemp Multiframe WSATransit Top ring temperature {image primary HDU keyword: TR_TEMP} real 4 degrees_Kelvin -0.9999995e9  
totalExpTime MultiframeDetector WSA Total exposure time for this detector real 4 seconds -0.9999995e9  
totalExpTime MultiframeDetector WSACalib Total exposure time for this detector real 4 seconds -0.9999995e9  
totalExpTime MultiframeDetector WSATransit Total exposure time for this detector real 4 seconds -0.9999995e9  
TQZ_BJ mgcBrightSpec MGC 2QZ bJ magnitude real 4      
TQZ_BJMR mgcBrightSpec MGC 2QZ bJ-R colour real 4      
TQZ_CLASS mgcBrightSpec MGC MGC translation of TQZ_IDENT smallint 2      
TQZ_DEC mgcBrightSpec MGC 2QZ object declination in deg (J2000) float 8      
TQZ_DUST mgcBrightSpec MGC 2QZ E(B-V) real 4      
TQZ_IDENT mgcBrightSpec MGC 2QZ identification varchar 10      
TQZ_NAME mgcBrightSpec MGC 2QZ object name varchar 20      
TQZ_NOBS mgcBrightSpec MGC Number of 2QZ spectra for this MGC object tinyint 1      
TQZ_RA mgcBrightSpec MGC 2QZ object right ascension in deg (J2000) float 8      
TQZ_UKST mgcBrightSpec MGC UKST survey field number int 4      
TQZ_UMBJ mgcBrightSpec MGC 2QZ U-bJ colour real 4      
TQZ_ZQUAL mgcBrightSpec MGC 2QZ redshift quality tinyint 1      
trackSys Multiframe WSA Telescope tracking coordinate system {image primary HDU keyword: TRACKSYS} varchar 64   NONE TIME_EQUINOX
trackSys Multiframe WSACalib Telescope tracking coordinate system {image primary HDU keyword: TRACKSYS} varchar 64   NONE TIME_EQUINOX
trackSys Multiframe WSATransit Telescope tracking coordinate system {image primary HDU keyword: TRACKSYS} varchar 64   NONE TIME_EQUINOX
transFile RequiredListDrivenProduct WSA CASU list-driven photometry tool option specifying the source of the driving list (e.g. "use=radeclist") varchar 16     ??
transFile RequiredListDrivenProduct WSACalib CASU list-driven photometry tool option specifying the source of the driving list (e.g. "use=radeclist") varchar 16     ??
transFile RequiredListDrivenProduct WSATransit CASU list-driven photometry tool option specifying the source of the driving list (e.g. "use=radeclist") varchar 16     ??
trefAmpl Multiframe WSA Trefoil: Amplitude {image primary HDU keyword: TAMP} real 4   -0.9999995e9  
trefAmpl Multiframe WSACalib Trefoil: Amplitude {image primary HDU keyword: TAMP} real 4   -0.9999995e9  
trefAmpl Multiframe WSATransit Trefoil: Amplitude {image primary HDU keyword: TAMP} real 4   -0.9999995e9  
trefPhi Multiframe WSA Trefoil: angle {image primary HDU keyword: TPHI} real 4   -0.9999995e9  
trefPhi Multiframe WSACalib Trefoil: angle {image primary HDU keyword: TPHI} real 4   -0.9999995e9  
trefPhi Multiframe WSATransit Trefoil: angle {image primary HDU keyword: TPHI} real 4   -0.9999995e9  
trussTempENE Multiframe WSA Truss leg ENE {image primary HDU keyword: TRUSSENE} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
trussTempENE Multiframe WSACalib Truss leg ENE {image primary HDU keyword: TRUSSENE} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
trussTempENE Multiframe WSATransit Truss leg ENE {image primary HDU keyword: TRUSSENE} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
trussTempWSW Multiframe WSA Truss leg WSW {image primary HDU keyword: TRUSSWSW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
trussTempWSW Multiframe WSACalib Truss leg WSW {image primary HDU keyword: TRUSSWSW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
trussTempWSW Multiframe WSATransit Truss leg WSW {image primary HDU keyword: TRUSSWSW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
TSERIES twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 XMM The flag is set to True if this source has a time series made in at least one exposure. varchar 5      
tSnr_100 iras_psc IRAS ten times the minimum signal-to-noise ratio (100 micron) smallint 2   INST_S/N  
tSnr_12 iras_psc IRAS ten times the minimum signal-to-noise ratio (12 micron) smallint 2   INST_S/N  
tSnr_25 iras_psc IRAS ten times the minimum signal-to-noise ratio (25 micron) smallint 2   INST_S/N  
tSnr_60 iras_psc IRAS ten times the minimum signal-to-noise ratio (60 micron) smallint 2   INST_S/N  
twomassMag first08Jul16Source FIRST 2MASS K magnitude real 4 mag    
twomassMatches first08Jul16Source FIRST number of matches within a fiducial radius (8 arcsec) with 2MASS int 4      
twomassSep first08Jul16Source FIRST separation of the nearest match in 2MASS from the FIRST position real 4 arcsec    
type iras_asc IRAS Source Type/Spectral Class varchar 5     SPECT_TYPE_GENERAL


Home | Overview | Browser | Access | Login | Cookbook | nonSurvey
Listing | Region | MenuQuery | 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)

wsa-support@roe.ac.uk
04/04/2012