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 UKIDSSR1 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSR1 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

D
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
d	Source	SSA	The great-circle distance of the source from the Galactic centre	real	4	degrees		POS_ANG_DIST_REL
darkID	Multiframe	WSA	UID of library calibration dark frame {image extension keyword: DARKCOR}	bigint	8		-99999999	ID_FRAME
databaseName	ExternalSurvey	WSA	The name of the database within the WSA	varchar	16			ID_DATABASE
dataScale	MultiframeDetector	WSA	Scaling of pixel values {image extension keyword: BSCALE}	real	4		1.0	??
dataZero	MultiframeDetector	WSA	Zeropoint of pixel values {image extension keyword: BZERO}	real	4		0.0	??
date	twomass_psc, twomass_xsc	2MASS	The observation reference date for this source expressed in ISO standard format. (YYYY-MM-DD)	datetime	8	yyyy-mm-dd		TIME_DATE
date	twomass_scn	2MASS	The observation reference date for this scan expressed in ISO standard format. (YYYY-MM-DD)	datetime	8	yyyy-mm-dd		TIME_DATE
dateEnd	Multiframe	WSA	Date and time (UTC) of end of obs {image primary HDU keyword: DATE-END}	datetime	8		12-31-9999	TIME_DATE
dateMeas	Plate	SSA	Measurement date	datetime	8	MM-DD-YYYY	12-31-9999	TIME_DATE
dateObs	Multiframe	WSA	Date and time (UTC) of start of obs {image primary HDU keyword: DATE-OBS}	datetime	8		12-31-9999	TIME_DATE
dbAcut	Plate	SSA	Minimum area of deblended object detection	tinyint	1	pixels		REDUCT_PARAM
dbAmax	Plate	SSA	Maximum area of parent image that can be deblended	int	4	pixels		REDUCT_PARAM
dbAmin	Plate	SSA	Minimum area of parent image that can be deblended	tinyint	1	pixels		REDUCT_PARAM
dbLevel	Plate	SSA	No. of rethresholding levels for deblending	tinyint	1			REDUCT_PARAM
dbName	Release	WSA	the name of the SQL Server database containing this release	varchar	16			??
dbNamePrefix	Survey	WSA	A string that prefixes all database names released for this survey	varchar	8			??
dbParam	Plate	SSA	Deblending parameter	real	4			REDUCT_PARAM
deblend	calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement	WSA	flag indicating parent/child relation {catalogue TType keyword: Parent_or_child}	int	4			CODE_MISC
deblend	u05a18Detection	WSA	flag for parent or part of deblended deconstruct (redundant since only deblended images are kept) {catalogue TType keyword: Parent_or_child}	int	4			CODE_MISC
dec	Detection	SSA	Celestial Declination	float	8	degrees		POS_EQ_DEC_MAIN
dec	RequiredMosaic	WSA	Declination of mosaic centre	float	8	degrees		POS_EQ_DEC_MAIN
dec	RequiredStack	WSA	Declination of stack centre	float	8	degrees		POS_EQ_DEC_MAIN
dec	Source	SSA	Mean Dec, computed from detections merged in this catalogue	float	8	degrees		POS_EQ_DEC_MAIN
dec	calDetection	WSA	Celestial Declination {catalogue TType keyword: DEC}	float	8	Degrees		POS_EQ_DEC_MAIN
dec	calMergeLog, commMergeLog, dxsMergeLog, gcsMergeLog, gpsMergeLog, lasMergeLog, udsMergeLog	WSA	Declination of field centre	float	8	degrees		POS_EQ_DEC_MAIN
dec	commDetection, commSource, dxsDetection, dxsListRemeasurement, dxsSource, dxsSourceRemeasurement, gcsDetection, gcsListRemeasurement, gcsSource, gcsSourceRemeasurement, gpsDetection, gpsListRemeasurement, gpsSource, gpsSourceRemeasurement, lasDetection, lasListRemeasurement, lasSource, lasSourceRemeasurement, udsDetection, udsListRemeasurement, udsSource, udsSourceRemeasurement	WSA	Celestial Declination	float	8	Degrees		POS_EQ_DEC_MAIN
dec	firstSource	FIRST	J2000 Celestial Declination	float	8	degrees		POS_EQ_DEC_MAIN
dec	iras_psc	IRAS	J2000 Celestial Declination	float	8	degrees		POS_EQ_DEC_MAIN
dec	rosat_bsc, rosat_fsc	ROSAT	Declination (decimal degrees; J2000)	float	8	degrees		POS_EQ_DEC_MAIN
dec	twomass_psc	2MASS	J2000 declination with respect to the ICRS	float	8	degrees		POS_EQ_DEC_MAIN
dec	twomass_scn	2MASS	Declination of scan center for equinox J2000.	float	8	degrees		POS_EQ_DEC_MAIN
dec	twomass_xsc	2MASS	Declination (J2000 decimal deg) based on peak pixel.	float	8	degrees		POS_EQ_DEC_MAIN
dec	u05a18Detection	WSA	Celestial Declination	float	8	Degrees		POS_EQ_DEC_MAIN
			Celestial Declination as computed in the processing pipeline, accurate to of order 0.1 arcsec. Note that original catalogue data has only r*4 storage precision, accurate only to ≈ 50mas. RA and Dec in the database are derived more precisely from WCS in the header and x and y attributes.
dec_1	twomass_scn	2MASS	J2000 declination of the eastern corner at start of scan.	float	8	degrees		POS_EQ_DEC_MAIN
dec_2	twomass_scn	2MASS	J2000 declination of the western corner at start of scan.	float	8	degrees		POS_EQ_DEC_MAIN
dec_3	twomass_scn	2MASS	J2000 declination of the eastern corner at end of scan.	float	8	degrees		POS_EQ_DEC_MAIN
dec_4	twomass_scn	2MASS	J2000 declination of the western corner at end of scan.	float	8	degrees		POS_EQ_DEC_MAIN
decBase	Multiframe	WSA	Declination of base position {image primary HDU keyword: DECBASE}	float	8	degrees		POS_EQ_DEC_MAIN
decCol	Plate	SSA	Name of Dec column in reference catalogue	varchar	16			REMARKS
decExtent	RequiredMosaic	WSA	The angular extent in Dec of the mosaic image	real	4	degrees		??
decMax	Survey	SSA	Northern (Dec) limit of survey	float	8	degrees		POS_EQ_DEC
decMin	Survey	SSA	Southern (Dec) limit of survey	float	8	degrees		POS_EQ_DEC
decPMCol	Plate	SSA	Name of Dec proper motion column in reference catalogue	varchar	16			REMARKS
decPnt	Plate	SSA	Mean plate centre Dec	real	4	degrees		POS_EQ_DEC_MAIN
decTelOff	Multiframe	WSA	Declination telescope offset {image primary HDU keyword: TDECOFF}	real	4	arcsec	-0.9999995e9	POS_EQ_DEC_OFF
delPropData	SurveyProgrammes	WSA	Logical flag indicating that proprietary data should be removed on release (1=yes; 0=no)	tinyint	1			??
density	twomass_xsc	2MASS	Coadd log(density) of stars with k<14 mag.	real	4			PHYS_DENSITY_NUMBER
deprecated	Multiframe, MultiframeDetector	WSA	Is the frame superseded by reprocessing (0=no, 1=yes)?	tinyint	1		0	??
deprecated	calDetection, commDetection, dxsDetection, gcsDetection, gpsDetection, lasDetection, u05a18Detection, udsDetection	WSA	code for a current (=0) or deprecated (!=0) detection.	tinyint	1		0	CODE_MISC
deprecated	calMergeLog, commMergeLog, dxsMergeLog, gcsMergeLog, gpsMergeLog, lasMergeLog, udsMergeLog	WSA	frame set deprecation flag (1=deprecated)	tinyint	1			CODE_MISC
deprecated	dxsListRemeasurement, gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, udsListRemeasurement	WSA	code for a current (=0) or repeat (!=0) detection.	tinyint	1			CODE_MISC
description	CurationTask	WSA	description in words for this task	varchar	256			NOTE
description	ExternalSurvey	WSA	A brief description of the survey	varchar	256			NOTE
description	Filter	WSA	a concise description of the filter	varchar	256			NOTE
description	Programme	WSA	a concise description of the programme	varchar	256			NOTE
description	Release	WSA	a brief description of the release	varchar	256			NOTE
description	RequiredMosaic, RequiredStack	WSA	Description of the product	varchar	256			??
description	Survey	WSA	A concise description of the survey	varchar	512			??
designation	twomass_psc	2MASS	Sexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...].	varchar	17			NAME
designation	twomass_xsc	2MASS	Source designation formed from sexigesimal coordinates.	varchar	17			NAME
detCols	MultiframeDetector	WSA	Number of detector columns {image extension keyword: DCOLUMNS}	smallint	2	pixels		NUMBER
detectionObjID	Programme	WSA	The attribute name(s) of the UID for detections	varchar	64			??
detectionTable	Programme	WSA	Table name of detections	varchar	64			??
detectorTable	Programme	WSA	Name of table containing frame detector metadata	varchar	64			??
detectorType	MultiframeDetector	WSA	Detector array used, eg. Aladdin {image extension keyword: DETECTOR}	varchar	16		NONE	INST_ID
detRows	MultiframeDetector	WSA	Number of detector rows {image extension keyword: DROWS}	smallint	2	pixels		NUMBER
deviceID	CurrentNightlyZP, DetectorSetUp	WSA	the device UID {image extension keyword: CAMNUM}	tinyint	1			ID_PLATE
deviceID	Device	WSA	Device UID identifying every IR device (or combination of devices) {image primary HDU keyword: CAMNUM}	tinyint	1			ID_PLATE
deviceID	MultiframeDetector	WSA	Device UID identifying every IR device {image extension keyword: CAMNUM}	tinyint	1			ID_PLATE
deviceID	PreviousNightlyZP	WSA	the device UID	tinyint	1			ID_PLATE
dewPoint	Multiframe	WSA	Dewpoint {image primary HDU keyword: DEWPOINT}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
dFlag	rosat_bsc, rosat_fsc	ROSAT	complex diffuse emission pattern	varchar	1			CODE_MISC
dfsIDString	Programme	WSA	The description used within the data flow system (ie. the value of the appropriate FITS keyword)	varchar	64			??
diffimID	DifferenceImage	WSA	the unique ID number identifying all stored difference images	bigint	8			ID_FRAME
directory	Plate	SSA	Name of directory in flat-file system of source data.	varchar	80			ID_FILE
disc_100	iras_psc	IRAS	Discrepant Fluxes flag (100 micron)	tinyint	1			REMARKS
disc_12	iras_psc	IRAS	Discrepant Fluxes flag (12 micron)	tinyint	1			REMARKS
disc_25	iras_psc	IRAS	Discrepant Fluxes flag (25 micron)	tinyint	1			REMARKS
disc_60	iras_psc	IRAS	Discrepant Fluxes flag (60 micron)	tinyint	1			REMARKS
dist_edge_ew	twomass_psc	2MASS	The distance from the source to the nearest East or West scan edge.	int	4	arcsec		INST_PLATE_DIST
dist_edge_ew	twomass_xsc	2MASS	The distance from the source to the nearest East or West scan edge.	smallint	2	arcsec		INST_PLATE_DIST
dist_edge_flg	twomass_psc	2MASS	Two character flag that specifies to which scan edges a source lies closest, and to which edges the dist_edge_ns and dist_edge_ew values refer.	varchar	2			INST_PLATE_DIST
dist_edge_flg	twomass_xsc	2MASS	flag indicating which edges ([n|s][e|w]) are nearest to src.	varchar	2			INST_PLATE_DIST
dist_edge_ns	twomass_psc, twomass_xsc	2MASS	The distance from the source to the nearest North or South scan edge.	int	4	arcsec		INST_PLATE_DIST
dist_opt	twomass_psc	2MASS	Distance separating TWOMASS source position and associated optical source within 5".	real	4	arcsec		INST_PLATE_DIST
distanceMins	commSourceNeighbours, commSourceXDR2PhotoObj, commSourceXSSASource, commSourceXfirstSource, commSourceXiras_psc, commSourceXrosat_bsc, commSourceXrosat_fsc, commSourceXtwomass_psc, commSourceXusnob_psc, dxsSourceNeighbours, gcsSourceNeighbours, gcsSourceXtwomass_psc, gpsSourceNeighbours, gpsSourceXtwomass_psc, lasSourceNeighbours, lasSourceXDR2PhotoObj, lasSourceXSSASource, lasSourceXfirstSource, lasSourceXiras_psc, lasSourceXrosat_bsc, lasSourceXrosat_fsc, lasSourceXtwomass_psc, lasSourceXusnob_psc, udsSourceNeighbours	WSA	Angular separation between neighbours	real	4	arcminutes		POS_ANG_DIST_GENERAL
distortMap	CurrentAstrometry, PreviousAstrometry	WSA	filename of 2d non-linear distortion map	varchar	256		NONE	ID_FILE
distType	Plate	SSA	Radial distortion term in solution, eg. R/TAN(R)	varchar	80			MODEL_CORRECTION
ditherOffsetX	MultiframeDetector	WSA	Dither offset X {image extension keyword: CIR_XOFF}	real	4		-0.9999995e9	POS_OFFSET
ditherOffsetY	MultiframeDetector	WSA	Dither offset Y {image extension keyword: CIR_YOFF}	real	4		-0.9999995e9	POS_OFFSET
domeHumid	Plate	SSA	Dome relative humidity at obsevation time	real	4			OBS_CONDITIONS
domePressure	Plate	SSA	Dome pressure at observation	real	4	mBar		OBS_CONDITIONS
domeTemp	Multiframe	WSA	Dome temperature {image primary HDU keyword: DOMETEMP}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
domeTemp	Plate	SSA	Dome temp at observation	real	4	Kelvin		OBS_CONDITIONS
dum	rosat_bsc, rosat_fsc	ROSAT	dummy flag	varchar	1			CODE_MISC
dup_src	twomass_psc, twomass_xsc	2MASS	Duplicate source flag.	smallint	2			CODE_MISC