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

Glossary of WSA attributes

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

O

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
object Multiframe WSA Object name from telescope {image primary HDU keyword: OBJECT} varchar 64   NONE meta.id
object Multiframe WSACalib Object name from telescope {image primary HDU keyword: OBJECT} varchar 64   NONE meta.id
object Multiframe WSATransit Object name from telescope {image primary HDU keyword: OBJECT} varchar 64   NONE meta.id
object Multiframe WSAUHS Object name from telescope {image primary HDU keyword: OBJECT} varchar 64   NONE meta.id
objID gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, UKIDSSDetection WSA Unique identifier for this detection, or default for no detection bigint 8   -99999999 ID_MAIN
objID calDetection WSACalib Unique identifier for this detection or default for no detection bigint 8   -99999999 ID_MAIN
This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information.
objID dxsDetection, udsDetection WSA Unique identifier for this detection or default for no detection bigint 8   -99999999 ID_MAIN
This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information.
objID gcsDetection, gpsDetection, lasDetection WSA Unique identifier for this detection, or default for no detection bigint 8   -99999999 ID_MAIN
This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information.
objID ptsDetection WSATransit Unique identifier for this detection or default for no detection bigint 8   -99999999 ID_MAIN
This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information.
objID uhsDetection, uhsDetectionAll WSAUHS Unique identifier for this detection or default for no detection bigint 8   -99999999 ID_MAIN
This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information.
objID ukirtFSstars WSA Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563) bigint 8      
objID ukirtFSstars WSACalib Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563) bigint 8      
objID ukirtFSstars WSAUHS Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563) bigint 8      
OBS_CLASS twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 XMM Quality classification of the whole observation based on the area flagged as bad in the manual flagging process as compared to the whole detection area. 0 means nothing has been flagged; 1 indicates that 0% < area < 0.1% of the total detection mask has been flagged; 2 indicates that 0.1% <= area < 1% has been flagged; 3 indicates that 1% <= area < 10% has been flagged; 4 indicates that 10% <= area < 100% has been flagged; and 5 means that the whole field was flagged as bad. int 4      
OBS_CLASS xmm3dr4 XMM Quality classification of the whole observation based on the area flagged as bad in the manual flagging process as compared to the whole detection area. 0 means nothing has been flagged; 1 indicates that 0% < area < 0.1% of the total detection mask has been flagged; 2 indicates that 0.1% <= area < 1% has been flagged; 3 indicates that 1% <= area < 10% has been flagged; 4 indicates that 10% <= area < 100% has been flagged; and 5 means that the whole field was flagged as bad. smallint 2      
OBS_ID xmm3dr4 XMM The XMM-Newton observation identification. varchar 50      
observation_time phot_variable_time_series_g_fov GAIADR1 Barycentric light-travle time corrected timestamp for each FoV observation float 8 Barycentric JD in TCB - 2455197.5 days   time.epoch
observed StdFieldInfo WSA yes or no identifier - have the secondary standards been set up? tinyint 1   0  
observed StdFieldInfo WSACalib yes or no identifier - have the secondary standards been set up? tinyint 1   0  
observed StdFieldInfo WSAUHS yes or no identifier - have the secondary standards been set up? tinyint 1   0  
observer Multiframe WSA Observers names {image primary HDU keyword: OBSERVER} varchar 64   NONE obs.observer
observer Multiframe WSACalib Observers names {image primary HDU keyword: OBSERVER} varchar 64   NONE obs.observer
observer Multiframe WSATransit Observers names {image primary HDU keyword: OBSERVER} varchar 64   NONE obs.observer
observer Multiframe WSAUHS Observers names {image primary HDU keyword: OBSERVER} varchar 64   NONE obs.observer
OBSID twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 XMM The XMM-Newton observation identification. varchar 10      
obsNum Multiframe WSA Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 meta.number
obsNum Multiframe WSACalib Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 meta.number
obsNum Multiframe WSATransit Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 meta.number
obsNum Multiframe WSAUHS Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 meta.number
obsref Multiframe WSA PATT or other reference {image primary HDU keyword: OBSREF} varchar 64   NONE meta.bib
obsref Multiframe WSACalib PATT or other reference {image primary HDU keyword: OBSREF} varchar 64   NONE meta.bib
obsref Multiframe WSATransit PATT or other reference {image primary HDU keyword: OBSREF} varchar 64   NONE meta.bib
obsref Multiframe WSAUHS PATT or other reference {image primary HDU keyword: OBSREF} varchar 64   NONE meta.bib
obstype Multiframe WSA Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} varchar 32     ??
obstype Multiframe WSACalib Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} varchar 32     ??
obstype Multiframe WSATransit Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} varchar 32     ??
obstype Multiframe WSAUHS Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} varchar 32     ??
oneSecMLVg Filter WSA The Vega magnitude limit of a 1s exposure in this filter real 4 mag -0.9999995e9  
oneSecMLVg Filter WSACalib The Vega magnitude limit of a 1s exposure in this filter real 4 mag -0.9999995e9  
oneSecMLVg Filter WSATransit The Vega magnitude limit of a 1s exposure in this filter real 4 mag -0.9999995e9  
oneSecMLVg Filter WSAUHS The Vega magnitude limit of a 1s exposure in this filter real 4 mag -0.9999995e9  
orgDate rosat_bsc, rosat_fsc ROSAT date when source was included (MM-DD-YYYY) datetime 8 mm-dd-yyyy   TIME_DATE
orient dxsAstrometricInfo, udsAstrometricInfo WSA Orientation of axes float 8 degrees -0.9999995e9 ??
orient uhsAstrometricInfo WSAUHS Orientation of axes float 8 radians -0.9999995e9 ??
origin Multiframe WSA Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} varchar 32   NONE  
origin Multiframe WSACalib Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} varchar 32   NONE  
origin Multiframe WSATransit Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} varchar 32   NONE  
origin Multiframe WSAUHS Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} varchar 32   NONE  
original_ext_source_id gaia_hip_tycho2_match GAIADR1 Original source identified in Hipparcos/Tycho2 varchar 16     id.cross



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

wsa-support@roe.ac.uk
07/11/2017