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

B
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
b	CurrentAstrometry, calDetection, calSourceEpochs, calSourceMeans, commDetection, commSource, dxsDetection, dxsListRemeasurement, dxsSource, dxsSourceRemeasurement, gcsDetection, gcsListRemeasurement, gcsSource, gcsSourceRemeasurement, gpsDetection, gpsListRemeasurement, gpsSource, gpsSourceRemeasurement, lasDetection, lasListRemeasurement, lasSource, lasSourceRemeasurement, PreviousAstrometry, udsDetection, udsListRemeasurement, udsSource, udsSourceRemeasurement	WSA	Galactic latitude	float	8	Degrees		POS_GAL_LAT
b	Source	SSA	The Galactic latitude of the source	real	4	degrees		POS_GAL_LAT
b_m_opt	twomass_psc	2MASS	Blue magnitude of associated optical source.	real	4	mag		SPECT_FLUX_VALUE
beamNS	Multiframe	WSA	Topend: N-S beam {image primary HDU keyword: NSBEAM}	real	4		-0.9999995e9
beamWE	Multiframe	WSA	Topend: W-E beam {image primary HDU keyword: WEBEAM}	real	4		-0.9999995e9
bgrCpsa	rosat_bsc, rosat_fsc	ROSAT	background countrate, vignetting corrected	real	4	counts/sec/arcmin**2		INST_BACKGROUND
bI	Detection	SSA	Semi-minor axis of intensity-weighted fitted ellip.	real	4	microns		EXTENSION_SMIN
bitsPerPix	MultiframeDetector	WSA	Number of bits per data pixel, eg. +32 = 4 byte integers {image extension keyword: BITPIX}	smallint	2	FITS bitpix		NUMBER
bl_flg	twomass_psc	2MASS	Blend flag.	varchar	3			CODE_MISC
bl_sub_flg	twomass_xsc	2MASS	blanked/subtracted src description flag.	smallint	2			CODE_MISC
blend	Detection	SSA	Deblend flag: -n=parent of n children; +n = nth child of a parent	int	4			CODE_MULT_INDEX
blendB	Source	SSA	Blend flag from B band detection	int	4		-99999999	CODE_MULT_INDEX
blendI	Source	SSA	Blend flag from I band detection	int	4		-99999999	CODE_MULT_INDEX
blendR1	Source	SSA	Blend flag from R1 band detection	int	4		-99999999	CODE_MULT_INDEX
blendR2	Source	SSA	Blend flag from R2 band detection	int	4		-99999999	CODE_MULT_INDEX
blk_fac	twomass_xsc	2MASS	LCSB blocking factor (1, 2, 4, 8).	smallint	2			FIT_PARAM
brAperMag3	calSourceEpochs, calSourceMeans, commSource	WSA	Extended source Br mag (2.0 arcsec aperture diameter)	real	4	mag	-0.9999995e9	PHOT_MAG
brAperMag3Err	calSourceEpochs, calSourceMeans, commSource	WSA	Error in extended source Br mag (2.0 arcsec aperture diameter)	real	4	mag	-0.9999995e9	ERROR
brAperMag4	calSourceEpochs, calSourceMeans, commSource	WSA	Extended source Br mag (2.8 arcsec aperture diameter)	real	4	mag	-0.9999995e9	PHOT_MAG
brAperMag4Err	calSourceEpochs, calSourceMeans, commSource	WSA	Error in extended source Br mag (2.8 arcsec aperture diameter)	real	4	mag	-0.9999995e9	ERROR
brAperMag6	calSourceEpochs, calSourceMeans, commSource	WSA	Extended source Br mag (5.7 arcsec aperture diameter)	real	4	mag	-0.9999995e9	PHOT_MAG
brAperMag6Err	calSourceEpochs, calSourceMeans, commSource	WSA	Error in extended source Br mag (5.7 arcsec aperture diameter)	real	4	mag	-0.9999995e9	ERROR
brClass	calSourceEpochs, commSource	WSA	discrete image classification flag in Br	smallint	2		-9999	CLASS_MISC
brClassStat	calSourceEpochs, commSource	WSA	N(0,1) stellarness-of-profile statistic in Br	real	4		-0.9999995e9	STAT_PROP
brDeblend	calSourceEpochs, commSource	WSA	flag indicating parent/child relation in Br	int	4		-99999999	CODE_MISC
brEll	calSourceEpochs, commSource	WSA	1-b/a, where a/b=semi-major/minor axes in Br	real	4		-0.9999995e9	PHYS_ELLIPTICITY
breNum	calMergeLogEpochs, commMergeLog	WSA	the extension number of this Br frame (ep1)	tinyint	1			NUMBER
brErrBits	calSourceEpochs, commSource	WSA	processing warning/error bitwise flags in Br	int	4		-99999999	CODE_MISC
brEta	calSourceEpochs, commSource	WSA	Offset of Br detection from master position (+north/-south)	real	4	arcsec	-0.9999995e9	POS_EQ_DEC_OFF
			When associating individual passband detections into merged sources, a generous (in terms of the positional uncertainties) pairing radius of typically 5 arcseconds is used, enabling pairing of moving sources when epoch separations may be several years. Such a large association criterion can of course lead to spurious pairings in the merged sources lists (although note that between passband pairs, handshake pairing is done: both passbands must agree that the candidate pair is their nearest neighbour for the pair to propagate through into the merged source table). In order to help filter spurious pairings out, and assuming that large positional offsets between the different passband detections are not expected (e.g. because of source motion, or larger than usual positional uncertainties) then the attributes Xi and Eta can be used to filter any pairings with suspiciously large offsets in one or more bands. For example, for a clean sample of QSOs, you might wish to insist that the offsets in the selected sample are all below 1 arcsecond: simply add WHERE clauses into the SQL sample selection script to exclude all Xi and Eta values larger than the threshold you want.
brGausig	calSourceEpochs, commSource	WSA	RMS of axes of ellipse fit in Br	real	4	pixels	-0.9999995e9	MORPH_PARAM
brgMag	CurrentStdStarInfo, PreviousStdStarInfo	WSA	BrG band total magnitude of star (from external sources if primary)	real	4	mag		PHOT_INT-MAG
brgMagErr	CurrentStdStarInfo, PreviousStdStarInfo	WSA	BrG band magnitude error of star	real	4	mag		ERROR
brHallMag	calSourceEpochs, calSourceMeans, commSource	WSA	Point source Br mag	real	4	mag	-0.9999995e9	PHOT_MAG
brHallMagErr	calSourceEpochs, calSourceMeans, commSource	WSA	Error in point source Br mag	real	4	mag	-0.9999995e9	ERROR
brightLim	Plate	SSA	Bright mag limit for selected astrometric refstars	real	4			PHOT_MAG_LIMIT
brightObjID	JunkDetection	SSA	The Detection.objID of the artifact-inducing bright star	bigint	8		0	ID_ASSOCIATED
brmfID	calMergeLogEpochs, commMergeLog	WSA	the UID of the relevant Br multiframe (ep1)	bigint	8			ID_FRAME
brObjID	calSourceEpochs, commSource	WSA	the UID of the Br detection	bigint	8		-99999999	ID_NUMBER
brPA	calSourceEpochs, commSource	WSA	ellipse fit celestial orientation in Br	real	4	Degrees	-0.9999995e9	POS_POS-ANG
brPetroMag	calSourceEpochs, calSourceMeans, commSource	WSA	Extended source Br mag (Petrosian)	real	4	mag	-0.9999995e9	PHOT_MAG
brPetroMagErr	calSourceEpochs, calSourceMeans, commSource	WSA	Error in extended source Br mag (Petrosian)	real	4	mag	-0.9999995e9	ERROR
brppErrBits	calSourceEpochs, commSource	WSA	additional WFAU post-processing error bits in Br	int	4		-99999999	CODE_MISC
brPsfMag	calSourceEpochs, calSourceMeans, commSource	WSA	Point source profile-fitted Br mag	real	4	mag	-0.9999995e9	PHOT_MAG
brPsfMagErr	calSourceEpochs, calSourceMeans, commSource	WSA	Error in point source profile-fitted Br mag	real	4	mag	-0.9999995e9	ERROR
brSeqNum	calSourceEpochs, commSource	WSA	the running number of the Br detection	int	4		-99999999	ID_NUMBER
brSerMag2D	calSourceEpochs, calSourceMeans, commSource	WSA	Extended source Br mag (profile-fitted)	real	4	mag	-0.9999995e9	PHOT_MAG
brSerMag2DErr	calSourceEpochs, calSourceMeans, commSource	WSA	Error in extended source Br mag (profile-fitted)	real	4	mag	-0.9999995e9	ERROR
brXi	calSourceEpochs, commSource	WSA	Offset of Br detection from master position (+east/-west)	real	4	arcsec	-0.9999995e9	POS_EQ_RA_OFF
			When associating individual passband detections into merged sources, a generous (in terms of the positional uncertainties) pairing radius of typically 5 arcseconds is used, enabling pairing of moving sources when epoch separations may be several years. Such a large association criterion can of course lead to spurious pairings in the merged sources lists (although note that between passband pairs, handshake pairing is done: both passbands must agree that the candidate pair is their nearest neighbour for the pair to propagate through into the merged source table). In order to help filter spurious pairings out, and assuming that large positional offsets between the different passband detections are not expected (e.g. because of source motion, or larger than usual positional uncertainties) then the attributes Xi and Eta can be used to filter any pairings with suspiciously large offsets in one or more bands. For example, for a clean sample of QSOs, you might wish to insist that the offsets in the selected sample are all below 1 arcsecond: simply add WHERE clauses into the SQL sample selection script to exclude all Xi and Eta values larger than the threshold you want.
bU	Detection	SSA	Semi-minor axis of unweighted fitted ellipse	real	4	microns		EXTENSION_SMIN