Home | Overview | Browser | Access | Login | Cookbook | nonSurvey 
** Announcement - Workshop: Science from UKIDSS II, 15-17 Dec 2008, London UK **
  WSA logo

Glossary of WSA attributes

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

M

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
M1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Number of detections for band 1 int 4   -9  
M2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Number of detections for band 2 int 4   -9  
m2u Multiframe WSA Raw position of M2 U (N-S tilt) {image primary HDU keyword: M2_U} real 4 mrad -0.9999995e9  
m2v Multiframe WSA Raw position of M2 V (E-W tilt) {image primary HDU keyword: M2_V} real 4 mrad -0.9999995e9  
m2w Multiframe WSA Raw position of M2 W (axial rotation) {image primary HDU keyword: M2_W} real 4 mrad -0.9999995e9  
m2x Multiframe WSA Raw position of M2 X (E-W) {image primary HDU keyword: M2_X} real 4 millimetres -0.9999995e9  
m2y Multiframe WSA Raw position of M2 Y (N-S) {image primary HDU keyword: M2_Y} real 4 millimetres -0.9999995e9  
m2z Multiframe WSA Raw position of M2 Z (focus) {image primary HDU keyword: M2_Z} real 4 millimetres -0.9999995e9  
M3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Number of detections for band 3 int 4   -9  
M3Temp Multiframe WSA M3 temperature {image primary HDU keyword: M3_TEMP} real 4 degrees_Kelvin -0.9999995e9  
M4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Number of detections for band 4 int 4   -9  
mag1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Magnitude in IRAC band 1 real 4 mag 99.999  
mag1_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE 1sigma mag error (IRAC band 1) real 4 mag 99.999  
mag2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Magnitude in IRAC band 2 real 4 mag 99.999  
mag2_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE 1sigma mag error (IRAC band 2) real 4 mag 99.999  
mag3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Magnitude in IRAC band 3 real 4 mag 99.999  
mag3_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE 1sigma mag error (IRAC band 3) real 4 mag 99.999  
mag4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Magnitude in IRAC band 4 real 4 mag 99.999  
mag4_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE 1sigma mag error (IRAC band 4) real 4 mag 99.999  
magCol Plate SSA Name of magnitude column in reference catalogue varchar 16     REMARKS
magLimit Survey SSA Nominal mag limit of survey, eg. 22.5 for Bj real 4     PHOT_MAG_LIMIT
magMax Plate SSA Maximum instrumental mag in IAM file real 4     PHOT_MAG_LIMIT
magMin Plate SSA Minimum instrumental mag in IAM file real 4     PHOT_MAG_LIMIT
maj firstSource FIRST major axes derived from the elliptical Gaussian model for the source after deconvolution. real 4 arcsec   EXTENSION_FWHM_MAJ
major iras_psc IRAS Uncertainty ellipse major axis smallint 2 arcsec   ERROR
maskID Multiframe WSA UID of library object mask frame {image extension keyword: CIR_OPM} bigint 8   -99999999 ID_FRAME
masterObjID dxsSourceNeighbours, dxsSourceXtwomass_psc WSA The unique ID in dxsSource (=sourceID) bigint 8     ID_MAIN
masterObjID gcsSourceNeighbours, gcsSourceXtwomass_psc WSA The unique ID in gcsSource (=sourceID) bigint 8     ID_MAIN
masterObjID gpsSourceNeighbours, gpsSourceXglimpse_hrc_inter, gpsSourceXglimpse_mca_inter, gpsSourceXtwomass_psc WSA The unique ID in gpsSource (=sourceID) bigint 8     ID_MAIN
masterObjID lasSourceNeighbours, lasSourceXDR2PhotoObj, lasSourceXSSASource, lasSourceXfirstSource, lasSourceXiras_psc, lasSourceXrosat_bsc, lasSourceXrosat_fsc, lasSourceXtwomass_psc, lasSourceXtwomass_xsc WSA The unique ID in lasSource (=sourceID) bigint 8     ID_MAIN
masterObjID udsSourceNeighbours, udsSourceXtwomass_psc WSA The unique ID in udsSource (=sourceID) bigint 8     ID_MAIN
maxDec CurrentAstrometry, PreviousAstrometry WSA The maximum Dec (J2000) on the device float 8 Degrees -0.9999995e9 POS_EQ_DEC_MAIN
maxIter Plate SSA Maximum no. of iterations for non-linear astrometric fit int 4     NUMBER
maxRa CurrentAstrometry, PreviousAstrometry WSA The maximum RA (J2000) on the device float 8 Degrees -0.9999995e9 POS_EQ_RA_OTHER
meanClass Source SSA Estimate of image class based on unit-weighted mean of individual classes tinyint 1     CLASS_OBJECT
mergedClass dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated) smallint 2     CODE_MISC
Individual detection classifications are combined in the source merging process to produce a set of attributes for each merged source as follows. Presently, a basic classification table is defined that assigns reasonably accurate, self-consistent probability values for a given classification code:
FlagMeaning
Probability (%)
StarGalaxyNoiseSaturated
-9Saturated 0.0 0.0 5.095.0
-3Probable galaxy25.070.0 5.0 0.0
-2Probable star70.025.0 5.0 0.0
-1Star90.0 5.0 5.0 0.0
0Noise 5.0 5.090.0 0.0
+1Galaxy 5.090.0 5.0 0.0

Then, each separately available classification is combined for a merged source using Bayesian classification rules, assuming each datum is independent:

P(classk)=ΠiP(classk)i / ΣkΠiP(classk)i
where classk is one of star|galaxy|noise|saturated, and i denotes the ith single detection passband measurement available (the non-zero entries are necessary for the independent measures method to work, since some cases might otherwise be mutually exclusive). For example, if an object is classed in J|H|K as -1|-2|+1 it would have merged classification probabilities of pStar=73.5%, pGalaxy=26.2%, pNoise=0.3% and pSaturated=0.0%. Decision thresholds for the resulting discrete classification flag mergedClass are 90% for definitive and 70% for probable; hence the above example would be classified (not unreasonably) as probably a star (mergedClass=-2). An additional decision rule enforces mergedClass=-9 (saturated) when any individual classification flag indicates saturation.

mergedClass dxsSourceRemeasurement, gcsSourceRemeasurement, gpsSourceRemeasurement, lasSourceRemeasurement, udsSourceRemeasurement WSA Class flag based on list remeasurement prescription smallint 2     CODE_MISC
mergedClassStat dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA Merged N(0,1) stellarness-of-profile statistic real 4   -0.9999995e9 STAT_PROP
This profile classification statistic is a continuously distributed, Gaussian N(0,1) (i.e. zero mean, unit variance) statistic formed from the available individual classification statistics by averaging them and dividing by N1/2.
mergeLogTable Programme WSA Table name of curation log for source merging varchar 64     ??
mergeSwVersion dxsMergeLog, gcsMergeLog, gpsMergeLog, lasMergeLog, udsMergeLog WSA version number of the software used to merge the frames real 4     ID_VERSION
method RequiredDiffImage WSA CASU difference image tool option string specifying the method to employ (recommended value=adaptive/back/zerosky) varchar 64     ??
MF1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Flux calc mathod flag for band 1 flux int 4   -9  
MF2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Flux calc mathod flag for band 2 flux int 4   -9  
MF3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Flux calc mathod flag for band 3 flux int 4   -9  
MF4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Flux calc mathod flag for band 4 flux int 4   -9  
mFlag rosat_bsc, rosat_fsc ROSAT source missed by SASS varchar 1     CODE_MISC
mHcon iras_psc IRAS Possible number of HCONs tinyint 1     NUMBER
min firstSource FIRST minor axes derived from the elliptical Gaussian model for the source after deconvolution. real 4 arcsec   EXTENSION_FWHM_MIN
minDec CurrentAstrometry, PreviousAstrometry WSA The minimum Dec (J2000) on the device float 8 Degrees -0.9999995e9 POS_EQ_DEC_MAIN
minImageSize MultiframeDetector WSA Minimum size for images {catalogue extension keyword:  MINPIX} int 4 pixels -99999999 ??
User-selectable parameter, in conjunction with the threshold above this determines how deep and how small "real" images can be. This default precludes many of the few pixel-hit cosmic rays from being considered since "real" images must have 4 contiguous simply-connected pixels in the union of the detection filter and data domains. For more details on image detection and parametersiation see the papers in CASU WFCAM/VISTA Publications.
minor iras_psc IRAS Uncertainty ellipse minor axis smallint 2 arcsec   ERROR
minRa CurrentAstrometry, PreviousAstrometry WSA The minimum RA (J2000) on the device float 8 Degrees -0.9999995e9 POS_EQ_RA_OTHER
mirrBottTempNW Multiframe WSA Mirror bottom temp. NW {image primary HDU keyword: MIRRBTNW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
mirrTempNE Multiframe WSA Mirror temperature NE {image primary HDU keyword: MIRRNE} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
mirrTempNW Multiframe WSA Mirror temperature NW {image primary HDU keyword: MIRRNW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
mirrTempSE Multiframe WSA Mirror temperature SE {image primary HDU keyword: MIRRSE} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
mirrTempSW Multiframe WSA Mirror temperature SW {image primary HDU keyword: MIRRSW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
mirrTopTempNW Multiframe WSA Mirror top temp. NW {image primary HDU keyword: MIRRTPNW} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
mjd Plate SSA Modified Julian Date at mid exposure float 8 Julian days   TIME_DATE
mjdObs Multiframe WSA Modified Julian Date of the observation {image primary HDU keyword: MJD-OBS} float 8   -0.9999995e9 TIME_DATE
modDate rosat_bsc, rosat_fsc ROSAT date when source properties were changed (MM-DD-YYYY) datetime 8 mm-dd-yyyy   TIME_DATE
morphClassFlag MultiframeDetector WSA Image morphological classifier flag, set if the classifier has been run. If so an object classification flag and a stellarness index is included in the binary table columns. {catalogue extension keyword:  CLASSIFD} tinyint 1   0 CODE_MISC
mosaicID MosaicImage WSA the unique ID number identifying all stored mosaic images bigint 8     ID_FRAME
mosaicStacks RequiredMosaic WSA Indicates if stacks are to be mosaiced (=1) or not (=0) tinyint 1     ??
mp_flg twomass_psc 2MASS Minor Planet Flag. smallint 2     CODE_MISC
mp_key twomass_xsc 2MASS key to minor planet prediction DB record. int 4     ID_NUMBER
msbID Multiframe WSA Id min.-schedulable block {image primary HDU keyword: MSBID} varchar 64   NONE ID_NUMBER
muAcosD Source SSA Proper motion in RA direction real 4 mas/yr -0.99999995e9 POS_EQ_PMRA
muD Source SSA Proper motion in Dec direction real 4 mas/yr -0.99999995e9 POS_EQ_PMDEC
muDec gcsSource, gpsSource, lasSource WSA Proper motion in Dec direction real 4 mas/yr -0.9999995e9 POS_EQ_PMDEC
multiframeID CurrentAstrometry, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, MultiframeDetector, PreviousAstrometry, ProgrammeFrame, udsDetection, udsListRemeasurement WSA the UID of the relevant multiframe bigint 8     ID_FRAME
multiframeID Multiframe WSA UID of the multiframe (assigned sequentially by the archive ingest process) bigint 8     ID_FRAME
multiframeID Provenance WSA the UID of the component frame bigint 8     ID_FRAME
muRa gcsSource, gpsSource, lasSource WSA Proper motion in RA direction real 4 mas/yr -0.9999995e9 POS_EQ_PMRA



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
27/01/2009