TABLE VIEW  UKIDSSDetection

This view is simply a union of all UKIDSS detections from all of the component subsurveys. Use this view if you are interested in any single passband detections regardless of the original subsurvey in which they originate. The details and SQL SELECT corresponding to this view are available here.

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
multiframeID	bigint	8		the UID of the relevant multiframe		ID_FRAME
extNum	tinyint	1		the extension number of this frame		NUMBER
cuEventID	int	4		UID of curation event giving rise to this record		REFER_CODE
seqNum	int	4		the running number of this detection		ID_NUMBER
filterID	tinyint	1		UID of combined filter (assigned in WSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank)		INST_FILTER_CODE
isoFlux	real	4	ADU	Instrumental isophotal flux counts		PHOT_INTENSITY_ADU
isoMag	real	4	mag	Calibrated isophotal magnitude		PHOT_INT-MAG
x	real	4	pixels	X coordinate of detection		POS_PLATE_X
xErr	real	4	pixels	Error in X coordinate		ERROR
y	real	4	pixels	Y coordinate of detection		POS_PLATE_Y
yErr	real	4	pixels	Error in Y coordinate		ERROR
gauSig	real	4	pixels	RMS of axes of ellipse fit		MORPH_PARAM
ell	real	4		1-b/a, where a/b=semi-major/minor axes		PHYS_ELLIPTICITY
pa	real	4	degrees	ellipse fit orientation to x axis		POS_POS-ANG
aProf1	real	4	pixels	No. of pixels above rethreshold 1 (can be non-integer for deblends)		NUMBER
aProf2	int	4	pixels	No. of pixels above rethreshold 2		NUMBER
aProf3	int	4	pixels	No. of pixels above rethreshold 3		NUMBER
aProf4	int	4	pixels	No. of pixels above rethreshold 4		NUMBER
aProf5	int	4	pixels	No. of pixels above rethreshold 5		NUMBER
aProf6	int	4	pixels	No. of pixels above rethreshold 6		NUMBER
aProf7	int	4	pixels	No. of pixels above rethreshold 7		NUMBER
aProf8	int	4	pixels	No. of pixels above rethreshold 8		NUMBER
pHeight	real	4	ADU	Highest pixel value above sky		PHOT_COUNTS_MISC
pHeightErr	real	4	ADU	Error in peak height		ERROR
aperFlux1	real	4	ADU	Default aperture flux counts 1		PHOT_INTENSITY_ADU
aperFlux1err	real	4	ADU	Error in aperture flux counts 1		ERROR
aperMag1	real	4	mag	Calibrated and corrected aperture magnitude 1		PHOT_INT-MAG
aperMag1err	real	4	mag	Error in calibrated aperture magnitude 1		ERROR
aperFlux2	real	4	ADU	Default aperture flux 2		PHOT_INTENSITY_ADU
aperFlux2err	real	4	ADU	Error in aperture flux 2		ERROR
aperMag2	real	4	mag	Calibrated and corrected aperture magnitude 2		PHOT_INT-MAG
aperMag2err	real	4	mag	Error in calibrated aperture magnitude 2		ERROR
aperFlux3	real	4	ADU	default aperture flux 3		PHOT_INTENSITY_ADU
aperFlux3err	real	4	ADU	Error in aperture flux 3		ERROR
aperMag3	real	4	mag	Calibrated and corrected aperture magnitude 3		PHOT_INT-MAG
aperMag3err	real	4	mag	Error in calibrated aperture magnitude 3		ERROR
aperFlux4	real	4	ADU	default aperture flux 4		PHOT_INTENSITY_ADU
aperFlux4err	real	4	ADU	Error in aperture flux 4		ERROR
aperMag4	real	4	mag	Calibrated and corrected aperture magnitude 4		PHOT_INT-MAG
aperMag4err	real	4	mag	Error in calibrated aperture magnitude 4		ERROR
aperFlux5	real	4	ADU	default aperture flux 5		PHOT_INTENSITY_ADU
aperFlux5err	real	4	ADU	Error in aperture flux 5		ERROR
aperMag5	real	4	mag	Calibrated and corrected aperture magnitude 5		PHOT_INT-MAG
aperMag5err	real	4	mag	Error in calibrated aperture magnitude 5		ERROR
aperFlux6	real	4	ADU	default aperture flux 6		PHOT_INTENSITY_ADU
aperFlux6err	real	4	ADU	Error in aperture flux 6		ERROR
aperMag6	real	4	mag	Calibrated and corrected aperture magnitude 6		PHOT_INT-MAG
aperMag6err	real	4	mag	Error in calibrated aperture magnitude 6		ERROR
aperFlux7	real	4	ADU	default aperture flux 7		PHOT_INTENSITY_ADU
aperFlux7err	real	4	ADU	Error in aperture flux 7		ERROR
aperMag7	real	4	mag	Calibrated and corrected aperture magnitude 7		PHOT_INT-MAG
aperMag7err	real	4	mag	Error in calibrated aperture magnitude 7		ERROR
aperFlux8	real	4	ADU	default aperture flux 8		PHOT_INTENSITY_ADU
aperFlux8err	real	4	ADU	Error in aperture flux 8		ERROR
aperMag8	real	4	mag	Calibrated and corrected aperture magnitude 8		PHOT_INT-MAG
aperMag8err	real	4	mag	Error in calibrated aperture magnitude 8		ERROR
aperFlux9	real	4	ADU	default aperture flux 9		PHOT_INTENSITY_ADU
aperFlux9err	real	4	ADU	Error in aperture flux 9		ERROR
aperMag9	real	4	mag	Calibrated and corrected aperture magnitude 9		PHOT_INT-MAG
aperMag9err	real	4	mag	Error in calibrated aperture magnitude 9		ERROR
aperFlux10	real	4	ADU	default aperture flux 10		PHOT_INTENSITY_ADU
aperFlux10err	real	4	ADU	Error in aperture flux 10		ERROR
aperMag10	real	4	mag	Calibrated and corrected aperture magnitude 10		PHOT_INT-MAG
aperMag10err	real	4	mag	Error in calibrated aperture magnitude 10		ERROR
aperFlux11	real	4	ADU	default aperture flux 11		PHOT_INTENSITY_ADU
aperFlux11err	real	4	ADU	Error in aperture flux 11		ERROR
aperMag11	real	4	mag	Calibrated and corrected aperture magnitude 11		PHOT_INT-MAG
aperMag11err	real	4	mag	Error in calibrated aperture magnitude 11		ERROR
aperFlux12	real	4	ADU	default aperture flux 12		PHOT_INTENSITY_ADU
aperFlux12err	real	4	ADU	Error in aperture flux 12		ERROR
aperMag12	real	4	mag	Calibrated and corrected aperture magnitude 12		PHOT_INT-MAG
aperMag12err	real	4	mag	Error in calibrated aperture magnitude 12		ERROR
aperFlux13	real	4	ADU	default aperture flux 13		PHOT_INTENSITY_ADU
aperFlux13err	real	4	ADU	Error in aperture flux 13		ERROR
aperMag13	real	4	mag	Calibrated and corrected aperture magnitude 13		PHOT_INT-MAG
aperMag13err	real	4	mag	Error in calibrated aperture magnitude 13		ERROR
petroRad	real	4	pixels	r_p as defined in Yasuda et al. 2001 AJ 112 1104		EXTENSION_RAD
kronRad	real	4	pixels	r_k as defined in Bertin and Arnouts 1996 A&A Supp 117 393		EXTENSION_RAD
hallRad	real	4	pixels	r_h image scale radius eg. Hall & Mackay 1984 MNRAS 210 979		EXTENSION_RAD
petroFlux	real	4	ADU	flux within circular aperture to k × r_p ; k = 2		PHOT_INTENSITY_ADU
petroFluxErr	real	4	ADU	error on Petrosian flux		ERROR
petroMag	real	4	mag	Calibrated Petrosian magnitude within circular aperture r_p		PHOT_INT-MAG
petroMagErr	real	4	mag	error on calibrated Petrosian magnitude		ERROR
kronFlux	real	4	ADU	flux within circular aperture to k × r_k ; k = 2		PHOT_INTENSITY_ADU
kronFluxErr	real	4	ADU	error on Kron flux		ERROR
kronMag	real	4	mag	Calibrated Kron magnitude within circular aperture r_k		PHOT_INT-MAG
kronMagErr	real	4	mag	error on calibrated Kron magnitude		ERROR
hallFlux	real	4	ADU	flux within circular aperture to k × r_h; k = 5; alternative total flux		PHOT_INTENSITY_ADU
hallFluxErr	real	4	ADU	error on Hall flux		ERROR
hallMag	real	4	mag	Calibrated magnitude within circular aperture r_hall		PHOT_INT-MAG
hallMagErr	real	4	mag	Calibrated error on Hall magnitude		ERROR
errBits	int	4		processing warning/error bitwise flags		CODE_MISC
sky	real	4	ADU	local interpolated sky level from background tracker		INST_SKY_LEVEL
skyVar	real	4	ADU	local estimate of variation in sky level around image		INST_SKY_LEVEL
deblend	int	4		Placeholder flag for parent or part of deblended deconstruct (redundant since only deblended images are kept)	-99999999	CODE_MISC
ra	float	8	Degrees	Celestial Right Ascension		POS_EQ_RA_MAIN
dec	float	8	Degrees	Celestial Declination		POS_EQ_DEC_MAIN
cx	float	8		unit vector of spherical co-ordinates		POS_EQ_X
cy	float	8		unit vector of spherical co-ordinates		POS_EQ_Y
cz	float	8		unit vector of spherical co-ordinates		POS_EQ_Z
htmID	bigint	8		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates		POS_GENERAL
l	float	8	Degrees	Galactic longitude		POS_GAL_LON
b	float	8	Degrees	Galactic latitude		POS_GAL_LAT
lambda	float	8	Degrees	SDSS system spherical co-ordinate 1		POS
eta	float	8	Degrees	SDSS system spherical co-ordinate 2		POS
class	smallint	2		Flag indicating most probable morphological classification		CLASS_MISC
classStat	real	4		N(0,1) stellarness-of-profile statistic		STAT_PROP
psfFlux	real	4	ADU	PSF-fitted flux	-0.9999995e9	PHOT_INTENSITY_ADU
psfFluxErr	real	4	ADU	Error on PSF-fitted flux	-0.9999995e9	ERROR
psfMag	real	4	mag	PSF-fitted calibrated magnitude	-0.9999995e9	PHOT_PROFILE
psfMagErr	real	4	mag	Error on PSF-fitted calibrated magnitude	-0.9999995e9	ERROR
psfFitX	real	4	pixels	PSF-fitted X coordinate	-0.9999995e9	POS_PLATE_X
psfFitXerr	real	4	pixels	Error on PSF-fitted X coordinate	-0.9999995e9	ERROR
psfFitY	real	4	pixels	PSF-fitted Y coordinate	-0.9999995e9	POS_PLATE_Y
psfFitYerr	real	4	pixels	Error on PSF-fitted Y coordinate	-0.9999995e9	ERROR
psfFitChi2	real	4		standard normalised variance of PSF fit	-0.9999995e9	FIT_STDEV
psfFitDof	smallint	2		no. of degrees of freedom of PSF fit	-9999	STAT_N-DOF
SerFlux1D	real	4	ADU	1D Sersic flux	-0.9999995e9	PHOT_INTENSITY_ADU
SerMag1D	real	4	mag	Calibrated 1D Sersic flux	-0.9999995e9	PHOT_PROFILE
SerScaleLen1D	real	4		Scale length	-0.9999995e9	PHOT_PROFILE_PAR
SerIdx1D	real	4		Power law index	-0.9999995e9	PHOT_PROFILE_PAR
SerFit1DChi2	real	4		Error in 1D fit	-0.9999995e9	PHOT_PROFILE_PAR
SerFitNu1D	real	4		No. of degrees of freedom for 1D Sersic fit	-0.9999995e9	STAT_N-DOF
SerFlux2D	real	4	ADU	2D Sersic flux	-0.9999995e9	PHOT_INTENSITY_ADU
SerMag2D	real	4	mag	Calibrated 2D Sersic flux	-0.9999995e9	PHOT_PROFILE
SerScaleLen2D	real	4		Scale length	-0.9999995e9	PHOT_PROFILE_PAR
SerIdx2D	real	4		Power law index	-0.9999995e9	PHOT_PROFILE_PAR
SerFit2DChi2	real	4		Error in 2D fit	-0.9999995e9	PHOT_PROFILE_PAR
SerFitNu2D	real	4		No. of degrees of freedom for 2D Sersic fit	-0.9999995e9	STAT_N-DOF
ppErrBits	int	4		additional WFAU post-processing error bits	0	CODE_MISC
deprecated	tinyint	1		Code for a current (=0) or deprecated (!=0) detection	0	CODE_MISC
objID	bigint	8		Unique identifier for this detection or default for no detection	-99999999	ID_MAIN
Total length		563