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

Glossary of WSA attributes

This Glossary alphabetically lists all attributes used in the UKIDSSDR5 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR5 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 WSATransit Object name from telescope {image primary HDU keyword: OBJECT} varchar 64   NONE ID_TARGET
objID CompleteStars, ReliableGalaxies, ReliableStars, Source SSA Unique identifier of merged source bigint 8     ID_MAIN
objID Detection SSA Unique object identification number bigint 8     ID_MAIN
objID JunkDetection SSA Unique object identification number from Detection bigint 8     ID_MAIN
objID dxsListRemeasurement, gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, UKIDSSDetection, udsListRemeasurement WSA 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      
objIDB CompleteStars, ReliableGalaxies, ReliableStars, Source SSA objID for B band detection merged into this object bigint 8   0 ID_ASSOCIATED
objIDI CompleteStars, ReliableGalaxies, ReliableStars, Source SSA objID for I band detection merged into this object bigint 8   0 ID_ASSOCIATED
objIDR1 CompleteStars, ReliableGalaxies, ReliableStars, Source SSA objID for R1 band detection merged into this object bigint 8   0 ID_ASSOCIATED
objIDR2 CompleteStars, ReliableGalaxies, ReliableStars, Source SSA objID for R2 band detection merged into this object bigint 8   0 ID_ASSOCIATED
objNum Plate SSA No. of objects detected on plate int 4     NUMBER
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      
obsDecPnt Plate SSA Observed plate centre Dec float 8 radians   POS_EQ_DEC_MAIN
observed StdFieldInfo WSA 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 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 WSATransit Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 NUMBER
obsRaPnt Plate SSA Observed plate centre RA float 8 radians   POS_EQ_RA_MAIN
obsref Multiframe WSA 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 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 WSATransit The Vega magnitude limit of a 1s exposure in this filter real 4 mag -0.9999995e9  
operator Plate SSA Machine operator's username varchar 3     ID_HUMAN
orgDate rosat_bsc, rosat_fsc ROSAT date when source was included (MM-DD-YYYY) datetime 8 mm-dd-yyyy   TIME_DATE
orientation Plate SSA SuperCOSMOS plate orientation, eg. news varchar 4     INST_PARAM
orientMean Plate SSA Mean orientation in IAM file real 4 degrees   POS_POS-ANG
orientMed Plate SSA Median orientation in IAM file real 4 degrees   POS_POS-ANG
orientMode Plate SSA Modal orientation in IAM file real 4 degrees   POS_POS-ANG
origin Multiframe WSA 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
30/04/2009