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

Glossary of WSA attributes

This Glossary alphabetically lists all attributes used in the UKIDSSDR6 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR6 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 ID_TARGET
object Multiframe WSACalib Object name from telescope {image primary HDU keyword: OBJECT} varchar 64   NONE ID_TARGET
object Multiframe WSATransit Object name from telescope {image primary HDU keyword: OBJECT} varchar 64   NONE ID_TARGET
objID dxsListRemeasurement, gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, UKIDSSDetection, udsListRemeasurement 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 calListRemeasurement WSACalib Unique identifier for this detection, or default for no detection bigint 8   -99999999 ID_MAIN
objID dxsDetection, gcsDetection, gpsDetection, lasDetection, 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 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 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      
OBS_CLASS twoxmm 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      
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  
observer Multiframe WSA Observers names {image primary HDU keyword: OBSERVER} varchar 64   NONE ID_HUMAN
observer Multiframe WSACalib Observers names {image primary HDU keyword: OBSERVER} varchar 64   NONE ID_HUMAN
observer Multiframe WSATransit Observers names {image primary HDU keyword: OBSERVER} varchar 64   NONE ID_HUMAN
OBSID twoxmm XMM The XMM-Newton observation identification. varchar 10      
obsNum Multiframe WSA Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 NUMBER
obsNum Multiframe WSACalib Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 NUMBER
obsNum Multiframe WSATransit Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 NUMBER
obsref Multiframe WSA PATT or other reference {image primary HDU keyword: OBSREF} varchar 64   NONE REFER_CODE
obsref Multiframe WSACalib PATT or other reference {image primary HDU keyword: OBSREF} varchar 64   NONE REFER_CODE
obsref Multiframe WSATransit PATT or other reference {image primary HDU keyword: OBSREF} varchar 64   NONE REFER_CODE
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     ??
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  
orgDate rosat_bsc, rosat_fsc ROSAT date when source was included (MM-DD-YYYY) datetime 8 mm-dd-yyyy   TIME_DATE
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  



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
14/04/2010