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

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

J
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
jAperMag3	[nspid]Source	WSA NonSurvey	Extended source J mag (2.0 arcsec aperture diameter)	real	4	mag	-0.9999995e9	PHOT_MAG
jAperMag3Err	[nspid]Source	WSA NonSurvey	Error in extended source J mag (2.0 arcsec aperture diameter)	real	4	mag	-0.9999995e9	ERROR
jAperMag4	[nspid]Source	WSA NonSurvey	Extended source J mag (2.8 arcsec aperture diameter)	real	4	mag	-0.9999995e9	PHOT_MAG
jAperMag4Err	[nspid]Source	WSA NonSurvey	Error in extended source J mag (2.8 arcsec aperture diameter)	real	4	mag	-0.9999995e9	ERROR
jAperMag6	[nspid]Source	WSA NonSurvey	Extended source J mag (5.7 arcsec aperture diameter)	real	4	mag	-0.9999995e9	PHOT_MAG
jAperMag6Err	[nspid]Source	WSA NonSurvey	Error in extended source J mag (5.7 arcsec aperture diameter)	real	4	mag	-0.9999995e9	ERROR
jClass	[nspid]Source	WSA NonSurvey	discrete image classification flag in J	smallint	2		-9999	CLASS_MISC
jClassStat	[nspid]Source	WSA NonSurvey	N(0,1) stellarness-of-profile statistic in J	real	4		-0.9999995e9	STAT_PROP
jDeblend	[nspid]Source	WSA NonSurvey	flag indicating parent/child relation in J	int	4		-99999999	CODE_MISC
jEll	[nspid]Source	WSA NonSurvey	1-b/a, where a/b=semi-major/minor axes in J	real	4		-0.9999995e9	PHYS_ELLIPTICITY
jeNum	[nspid]MergeLog	WSA NonSurvey	the extension number of this J detector	tinyint	1			NUMBER
jErrBits	[nspid]Source	WSA NonSurvey	processing warning/error bitwise flags in J	int	4		-99999999	CODE_MISC
jEta	[nspid]Source	WSA NonSurvey	Offset of J 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.
jGausig	[nspid]Source	WSA NonSurvey	RMS of axes of ellipse fit in J	real	4	pixels	-0.9999995e9	MORPH_PARAM
jHallMag	[nspid]Source	WSA NonSurvey	Point source J mag	real	4	mag	-0.9999995e9	PHOT_MAG
jHallMagErr	[nspid]Source	WSA NonSurvey	Error in point source J mag	real	4	mag	-0.9999995e9	ERROR
jitterID	[nspid]Multiframe	WSA NonSurvey	Serial number in this telescope jitter pattern {image primary HDU keyword: JITTER_I}	smallint	2		-9999	ID_NUMBER
jitterX	[nspid]Multiframe	WSA NonSurvey	X (RA) offset in tel jitter pattern {image primary HDU keyword: JITTER_X}	real	4	arcsec	-0.9999995e9	POS_EQ_RA_OFF
jitterY	[nspid]Multiframe	WSA NonSurvey	Y (Dec) offset in tel jitter pattern {image primary HDU keyword: JITTER_Y}	real	4	arcsec	-0.9999995e9	POS_EQ_DEC_OFF
jmfID	[nspid]MergeLog	WSA NonSurvey	the UID of the relevant J multiframe	bigint	8			ID_FRAME
jmhExt	[nspid]Source	WSA NonSurvey	Extended source colour J-H	real	4	mag	-0.9999995e9	PHOT_COLOR
			Default colours from pairs of adjacent passbands within a given set (e.g. Y-J, J-H and H-K for YJHK) are recorded in the merged source table for ease of querying and speedy querying via indexing of these attributes. Presently, the point-source colours are computed from the seeing-matched aperture measure (the "Hall" magnitude) while the extended source colours are computed from the fixed 2 arcsec aperture diameter measures (for consistent measurement across all passbands). At some point in the future, this may be changed such that point-source colours will be computed from the PSF-fitted measures and extended source colours computed from the 2-d Sersic model profile fits.
jmhExtErr	[nspid]Source	WSA NonSurvey	Error on extended source colour J-H	real	4	mag	-0.9999995e9	ERROR
			Default colours from pairs of adjacent passbands within a given set (e.g. Y-J, J-H and H-K for YJHK) are recorded in the merged source table for ease of querying and speedy querying via indexing of these attributes. Presently, the point-source colours are computed from the seeing-matched aperture measure (the "Hall" magnitude) while the extended source colours are computed from the fixed 2 arcsec aperture diameter measures (for consistent measurement across all passbands). At some point in the future, this may be changed such that point-source colours will be computed from the PSF-fitted measures and extended source colours computed from the 2-d Sersic model profile fits.
jmhPnt	[nspid]Source	WSA NonSurvey	Point source colour J-H	real	4	mag	-0.9999995e9	PHOT_COLOR
			Default colours from pairs of adjacent passbands within a given set (e.g. Y-J, J-H and H-K for YJHK) are recorded in the merged source table for ease of querying and speedy querying via indexing of these attributes. Presently, the point-source colours are computed from the seeing-matched aperture measure (the "Hall" magnitude) while the extended source colours are computed from the fixed 2 arcsec aperture diameter measures (for consistent measurement across all passbands). At some point in the future, this may be changed such that point-source colours will be computed from the PSF-fitted measures and extended source colours computed from the 2-d Sersic model profile fits.
jmhPntErr	[nspid]Source	WSA NonSurvey	Error on point source colour J-H	real	4	mag	-0.9999995e9	ERROR
			Default colours from pairs of adjacent passbands within a given set (e.g. Y-J, J-H and H-K for YJHK) are recorded in the merged source table for ease of querying and speedy querying via indexing of these attributes. Presently, the point-source colours are computed from the seeing-matched aperture measure (the "Hall" magnitude) while the extended source colours are computed from the fixed 2 arcsec aperture diameter measures (for consistent measurement across all passbands). At some point in the future, this may be changed such that point-source colours will be computed from the PSF-fitted measures and extended source colours computed from the 2-d Sersic model profile fits.
jmkExt	[nspid]Source	WSA NonSurvey	Extended source colour J-K	real	4	mag	-0.9999995e9	PHOT_COLOR
			Default colours from pairs of adjacent passbands within a given set (e.g. Y-J, J-H and H-K for YJHK) are recorded in the merged source table for ease of querying and speedy querying via indexing of these attributes. Presently, the point-source colours are computed from the seeing-matched aperture measure (the "Hall" magnitude) while the extended source colours are computed from the fixed 2 arcsec aperture diameter measures (for consistent measurement across all passbands). At some point in the future, this may be changed such that point-source colours will be computed from the PSF-fitted measures and extended source colours computed from the 2-d Sersic model profile fits.
jmkExtErr	[nspid]Source	WSA NonSurvey	Error on extended source colour J-K	real	4	mag	-0.9999995e9	ERROR
			Default colours from pairs of adjacent passbands within a given set (e.g. Y-J, J-H and H-K for YJHK) are recorded in the merged source table for ease of querying and speedy querying via indexing of these attributes. Presently, the point-source colours are computed from the seeing-matched aperture measure (the "Hall" magnitude) while the extended source colours are computed from the fixed 2 arcsec aperture diameter measures (for consistent measurement across all passbands). At some point in the future, this may be changed such that point-source colours will be computed from the PSF-fitted measures and extended source colours computed from the 2-d Sersic model profile fits.
jmkPnt	[nspid]Source	WSA NonSurvey	Point source colour J-K	real	4	mag	-0.9999995e9	PHOT_COLOR
			Default colours from pairs of adjacent passbands within a given set (e.g. Y-J, J-H and H-K for YJHK) are recorded in the merged source table for ease of querying and speedy querying via indexing of these attributes. Presently, the point-source colours are computed from the seeing-matched aperture measure (the "Hall" magnitude) while the extended source colours are computed from the fixed 2 arcsec aperture diameter measures (for consistent measurement across all passbands). At some point in the future, this may be changed such that point-source colours will be computed from the PSF-fitted measures and extended source colours computed from the 2-d Sersic model profile fits.
jmkPntErr	[nspid]Source	WSA NonSurvey	Error on point source colour J-K	real	4	mag	-0.9999995e9	ERROR
			Default colours from pairs of adjacent passbands within a given set (e.g. Y-J, J-H and H-K for YJHK) are recorded in the merged source table for ease of querying and speedy querying via indexing of these attributes. Presently, the point-source colours are computed from the seeing-matched aperture measure (the "Hall" magnitude) while the extended source colours are computed from the fixed 2 arcsec aperture diameter measures (for consistent measurement across all passbands). At some point in the future, this may be changed such that point-source colours will be computed from the PSF-fitted measures and extended source colours computed from the 2-d Sersic model profile fits.
jObjID	[nspid]Source	WSA NonSurvey	the UID of the J detection	bigint	8		-99999999	ID_NUMBER
joinCriterion	[nspid]RequiredNeighbours	WSA NonSurvey	The join criterion (search radius for matches)	real	4	arcminutes		??
joinType	[nspid]RequiredNeighbours	WSA NonSurvey	The type of join: 0 (default) or N for special join	smallint	2			??
jPA	[nspid]Source	WSA NonSurvey	ellipse fit celestial orientation in J	real	4	Degrees	-0.9999995e9	POS_POS-ANG
jPetroMag	[nspid]Source	WSA NonSurvey	Extended source J mag (Petrosian)	real	4	mag	-0.9999995e9	PHOT_MAG
jPetroMagErr	[nspid]Source	WSA NonSurvey	Error in extended source J mag (Petrosian)	real	4	mag	-0.9999995e9	ERROR
jppErrBits	[nspid]Source	WSA NonSurvey	additional WFAU post-processing error bits in J	int	4		-99999999	CODE_MISC
jPsfMag	[nspid]Source	WSA NonSurvey	Point source profile-fitted J mag	real	4	mag	-0.9999995e9	PHOT_MAG
jPsfMagErr	[nspid]Source	WSA NonSurvey	Error in point source profile-fitted J mag	real	4	mag	-0.9999995e9	ERROR
jSeqNum	[nspid]Source	WSA NonSurvey	the running number of the J detection	int	4		-99999999	ID_NUMBER
jSerMag2D	[nspid]Source	WSA NonSurvey	Extended source J mag (profile-fitted)	real	4	mag	-0.9999995e9	PHOT_MAG
jSerMag2DErr	[nspid]Source	WSA NonSurvey	Error in extended source J mag (profile-fitted)	real	4	mag	-0.9999995e9	ERROR
julianDayNum	[nspid]CurrentNightlyExt, [nspid]DetectorSetUp, [nspid]MultiframeSetUp, [nspid]PreviousNightlyExt	WSA NonSurvey	the Julian Day number of the UKIRT night {image primary HDU keyword: UTDATE}	int	4	Julian days		TIME_DATE
julianDayNum	[nspid]Multiframe	WSA NonSurvey	the Julian Day number of the UKIRT night	int	4	Julian days		TIME_DATE
julianDayNum	[nspid]MultiframeDetector	WSA NonSurvey	Julian Day number of the UKIRT night {image primary HDU keyword: UTDATE}	int	4	Julian days		TIME_DATE
jXi	[nspid]Source	WSA NonSurvey	Offset of J 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.