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

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
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified 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: Flag Meaning Probability (%) Star Galaxy Noise Saturated -9 Saturated 0.0 0.0 5.0 95.0 -3 Probable galaxy 25.0 70.0 5.0 0.0 -2 Probable star 70.0 25.0 5.0 0.0 -1 Star 90.0 5.0 5.0 0.0 0 Noise 5.0 5.0 90.0 0.0 +1 Galaxy 5.0 90.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