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 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
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified 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: 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	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