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

Glossary of WSA NonSurvey attributes (UKIDSSDR10)

This Glossary alphabetically lists all attributes used in the WSA NonSurvey database(s) held in the WSA. If you would like to have more information about the schema tables please use the 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 [nspid]Multiframe WSA NonSurvey Object name from telescope {image primary HDU keyword: OBJECT} varchar 64   NONE meta.id
objectID [nspid]MapApertureIDshighzQsoMap WSA NonSurvey The UID of the object within this survey programme table bigint 8      
objID [nspid]Detection WSA NonSurvey 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 [nspid]Detection WSA NonSurvey 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 [nspid]FSstars WSA NonSurvey Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563) bigint 8      
objID [nspid]ListRemeasurement, [nspid]UKIDSSDetection WSA NonSurvey Unique identifier for this detection, or default for no detection bigint 8   -99999999 ID_MAIN
objIDName [nspid]MapSurveyTables WSA NonSurvey The source unique identifier in the table varchar 16     ID_TARGET
obReqs [nspid]RequiredFilters WSA NonSurvey For wide shallow surveys with small number of epochs, what MSB requirements for each epoch. varchar 32   NONE meta.note
observed [nspid]StdFieldInfo WSA NonSurvey yes or no identifier - have the secondary standards been set up? tinyint 1   0  
observer [nspid]Multiframe WSA NonSurvey Observers names {image primary HDU keyword: OBSERVER} varchar 64   NONE obs.observer
obsNum [nspid]Multiframe WSA NonSurvey Observation number {image primary HDU keyword: OBSNUM} int 4   -99999999 meta.number
obsref [nspid]Multiframe WSA NonSurvey PATT or other reference {image primary HDU keyword: OBSREF} varchar 64   NONE meta.bib
obstype [nspid]Multiframe WSA NonSurvey Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} varchar 32     ??
oneSecMLVg [nspid]Filter WSA NonSurvey The Vega magnitude limit of a 1s exposure in this filter real 4 mag -0.9999995e9  
orbitID [nspid]SatelliteOrbits WSA NonSurvey UID of the orbit as assigned by fitting algorith bigint 8     ID_MAIN
orbitID [nspid]SatelliteOrbitsTrails WSA NonSurvey UID of orbit bigint 8     ID_MAIN
orient [nspid]AstrometricInfo WSA NonSurvey Orientation of axes float 8 degrees -0.9999995e9 ??
orient [nspid]AstrometricInfo WSA NonSurvey Orientation of axes float 8 radians -0.9999995e9 ??
orientation [nspid]RequiredMosaicTopLevel WSA NonSurvey Orientation of image x-axis to N-S. If default, use natural orientation of input images. real 4 deg -0.9999995e9  
origin [nspid]Multiframe WSA NonSurvey Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} varchar 32   NONE  
overLaps [nspid]RequiredMapAverages WSA NonSurvey Average over overlaps (use with average over deep frames and source merging) 0/N N/Y tinyint 1   0  



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
03/09/2018