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 UKIDSSR2 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSR2 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
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  
M3Temp Multiframe WSA M3 temperature {image primary HDU keyword: M3_TEMP} real 4 degrees_Kelvin -0.9999995e9  
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 commSourceNeighbours, commSourceXDR2PhotoObj, commSourceXSSASource, commSourceXfirstSource, commSourceXiras_psc, commSourceXrosat_bsc, commSourceXrosat_fsc, commSourceXtwomass_psc, commSourceXusnob_psc WSA The unique ID in commSource (=sourceID) bigint 8     ID_MAIN
masterObjID gcsSourceNeighbours, gcsSourceXtwomass_psc WSA The unique ID in gcsSource (=sourceID) bigint 8     ID_MAIN
masterObjID gpsSourceNeighbours, 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, lasSourceXusnob_psc WSA The unique ID in lasSource (=sourceID) bigint 8     ID_MAIN
maxDec CurrentAstrometry WSA The maximum Dec (J2000) on the device float 8 Degrees -0.9999995e9 POS_EQ_DEC_MAIN
maxDec PreviousAstrometry WSA The maximum Dec (J2000) on the device float 8 Degrees   POS_EQ_DEC_MAIN
maxIter Plate SSA Maximum no. of iterations for non-linear astrometric fit int 4     NUMBER
maxRa CurrentAstrometry WSA The maximum RA (J2000) on the device float 8 Degrees -0.9999995e9 POS_EQ_RA_OTHER
maxRa PreviousAstrometry WSA The maximum RA (J2000) on the device float 8 Degrees   POS_EQ_RA_OTHER
meanClass Source SSA Estimate of image class based on unit-weighted mean of individual classes tinyint 1     CLASS_OBJECT
meanMjdObs calMultiEpochLog WSA mean MJD of frameSet float 8 Julian days   TIME_DATE
mergedClass calSourceEpochs, commSource, 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 calSourceMeans WSA Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated) smallint 2     CODE_MISC
mergedClass dxsSourceRemeasurement, gcsSourceRemeasurement, gpsSourceRemeasurement, lasSourceRemeasurement, udsSourceRemeasurement WSA Class flag based on list remeasurement prescription smallint 2     CODE_MISC
mergedClassStat calSourceEpochs, calSourceMeans, commSource, 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 calMergeLogEpochs, commMergeLog, 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     ??
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 WSA The minimum Dec (J2000) on the device float 8 Degrees -0.9999995e9 POS_EQ_DEC_MAIN
minDec PreviousAstrometry WSA The minimum Dec (J2000) on the device float 8 Degrees   POS_EQ_DEC_MAIN
minImageSize MultiframeDetector WSA Minimum size for images {catalogue extension keyword:  MINPIX} int 4 pixels -99999999 ??
minor iras_psc IRAS Uncertainty ellipse minor axis smallint 2 arcsec   ERROR
minRa CurrentAstrometry WSA The minimum RA (J2000) on the device float 8 Degrees -0.9999995e9 POS_EQ_RA_OTHER
minRa PreviousAstrometry WSA The minimum RA (J2000) on the device float 8 Degrees   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
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 calSourceEpochs, calSourceMeans, commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA Proper motion in Dec direction real 4 mas/yr -0.9999995e9 POS_EQ_PMDEC
multiframeID CurrentAstrometry, calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, PreviousAstrometry, 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 MultiframeDetector WSA UID of the relevant multiframe bigint 8     ID_FRAME
multiframeID ProgrammeFrame WSA UID of the multiframe: 6-digit UKIRT run number; 8-digit UT date observed; 5-digit "WSA day number" of processing bigint 8     ID_FRAME
multiframeID Provenance WSA the UID of the component frame bigint 8     ID_FRAME
muRa calSourceEpochs, calSourceMeans, commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource 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