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

D
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
darkID	[nspid]Multiframe	WSA NonSurvey	UID of library calibration dark frame {image extension keyword: DARKCOR}	bigint	8		-99999999	ID_FRAME
databaseName	[nspid]ExternalSurvey	WSA NonSurvey	The name of the database within the WSA	varchar	16			ID_DATABASE
dataScale	[nspid]MultiframeDetector	WSA NonSurvey	Scaling of pixel values {image extension keyword: BSCALE}	real	4		1.0	??
dataZero	[nspid]MultiframeDetector	WSA NonSurvey	Zeropoint of pixel values {image extension keyword: BZERO}	real	4		0.0	??
dateEnd	[nspid]Multiframe	WSA NonSurvey	Date and time (UTC) of end of obs {image primary HDU keyword: DATE-END}	datetime	8		12-31-9999	TIME_DATE
dateObs	[nspid]Multiframe	WSA NonSurvey	Date and time (UTC) of start of obs {image primary HDU keyword: DATE-OBS}	datetime	8		12-31-9999	TIME_DATE
			The date and time is written in the specific SQL Server datetime format: YYYY-MM-DD HH:MM:SS.s
dbName	[nspid]Release	WSA NonSurvey	the name of the SQL Server database containing this release	varchar	16			??
dbNamePrefix	[nspid]Survey	WSA NonSurvey	A string that prefixes all database names released for this survey	varchar	8			??
deblend	[nspid]Detection	WSA NonSurvey	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	[nspid]Detection	WSA NonSurvey	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	[nspid]MergeLog	WSA NonSurvey	Declination of field centre	float	8	degrees		POS_EQ_DEC_MAIN
dec	[nspid]RequiredMosaic	WSA NonSurvey	Declination of mosaic centre	float	8	degrees		POS_EQ_DEC_MAIN
dec	[nspid]RequiredStack	WSA NonSurvey	Declination of stack centre	float	8	degrees		POS_EQ_DEC_MAIN
dec	[nspid]Source	WSA NonSurvey	Celestial Declination	float	8	Degrees		POS_EQ_DEC_MAIN
decBase	[nspid]Multiframe	WSA NonSurvey	Declination of base position {image primary HDU keyword: DECBASE}	float	8	degrees	-0.9999995e9	POS_EQ_DEC_MAIN
decExtent	[nspid]RequiredMosaic	WSA NonSurvey	The angular extent in Dec of the mosaic image	real	4	degrees		??
decTelOff	[nspid]Multiframe	WSA NonSurvey	Declination telescope offset {image primary HDU keyword: TDECOFF}	real	4	arcsec	-0.9999995e9	POS_EQ_DEC_OFF
decurtFlag	[nspid]MultiframeDetector	WSA NonSurvey	De-curtaining flag {image extension keyword: DECURTN}	varchar	32		NONE	??
delPropData	[nspid]SurveyProgrammes	WSA NonSurvey	Logical flag indicating that proprietary data should be removed on release (1=yes; 0=no)	tinyint	1			??
deprecated	[nspid]Detection	WSA NonSurvey	code for a current (=0) or deprecated (!=0) detection.	tinyint	1		0	CODE_MISC
deprecated	[nspid]MergeLog	WSA NonSurvey	frame set deprecation flag (1=deprecated)	tinyint	1			CODE_MISC
deprecated	[nspid]Multiframe, [nspid]MultiframeDetector	WSA NonSurvey	Is the frame superseded by reprocessing (0=no, 1=yes)?	tinyint	1		0	??
description	[nspid]CurationTask	WSA NonSurvey	description in words for this task	varchar	256			NOTE
description	[nspid]ExternalSurvey	WSA NonSurvey	A brief description of the survey	varchar	256			NOTE
description	[nspid]Filter	WSA NonSurvey	a concise description of the filter	varchar	256			NOTE
description	[nspid]Programme	WSA NonSurvey	a concise description of the programme	varchar	256			NOTE
description	[nspid]Release	WSA NonSurvey	a brief description of the release	varchar	256			NOTE
description	[nspid]RequiredMosaic, [nspid]RequiredStack	WSA NonSurvey	Description of the product	varchar	256			??
description	[nspid]Survey	WSA NonSurvey	A concise description of the survey	varchar	512			??
detCols	[nspid]MultiframeDetector	WSA NonSurvey	Number of detector columns {image extension keyword: DCOLUMNS}	smallint	2	pixels		NUMBER
detectionObjID	[nspid]Programme	WSA NonSurvey	The attribute name(s) of the UID for detections	varchar	64			??
detectionTable	[nspid]Programme	WSA NonSurvey	Table name of detections	varchar	64			??
detectorTable	[nspid]Programme	WSA NonSurvey	Name of table containing frame detector metadata	varchar	64			??
detectorTemp	[nspid]MultiframeDetector	WSA NonSurvey	Detector array temperature {image extension keyword: DET_TEMP}	real	4	degrees_Kelvin	-0.9999995e9	??
detectorType	[nspid]MultiframeDetector	WSA NonSurvey	Detector array used, eg. Aladdin {image extension keyword: DETECTOR}	varchar	16		NONE	INST_ID
detHeaterLevel	[nspid]Multiframe	WSA NonSurvey	Det heater level (in percent) {image primary HDU keyword: DET_HTP}	real	4		-0.9999995e9
detRows	[nspid]MultiframeDetector	WSA NonSurvey	Number of detector rows {image extension keyword: DROWS}	smallint	2	pixels		NUMBER
detTempAlt	[nspid]Multiframe	WSA NonSurvey	DET_TEMP alternate sensor {image primary HDU keyword: DETTEMPB}	real	4	degrees_Kelvin	-0.9999995e9
detTempSetPt	[nspid]Multiframe	WSA NonSurvey	Det temperature setpoint {image primary HDU keyword: DETTEMPS}	real	4	degrees_Kelvin	-0.9999995e9
deviceID	[nspid]CurrentZP, [nspid]DetectorSetUp	WSA NonSurvey	the device UID {image extension keyword: CAMNUM}	tinyint	1			ID_PLATE
deviceID	[nspid]MultiframeDetector	WSA NonSurvey	Device UID identifying every IR device {image extension keyword: DETECTID}	varchar	32			ID_PLATE
deviceID	[nspid]PreviousZP	WSA NonSurvey	the device UID	tinyint	1			ID_PLATE
dewPoint	[nspid]Multiframe	WSA NonSurvey	Dewpoint {image primary HDU keyword: DEWPOINT}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
dfsIDString	[nspid]Programme	WSA NonSurvey	The description used within the data flow system (ie. the value of the appropriate FITS keyword)	varchar	64			??
dhsVersion	[nspid]Multiframe	WSA NonSurvey	Data handling version {image primary HDU keyword: DHSVER}	varchar	32		NONE
diffimID	[nspid]DifferenceImage	WSA NonSurvey	the unique ID number identifying all stored difference images	bigint	8			ID_FRAME
distortMap	[nspid]CurrentAstrometry, [nspid]PreviousAstrometry	WSA NonSurvey	filename of 2d non-linear distortion map	varchar	256		NONE	ID_FILE
ditherOffsetX	[nspid]MultiframeDetector	WSA NonSurvey	Dither offset X {image extension keyword: CIR_XOFF}	real	4		-0.9999995e9	POS_OFFSET
ditherOffsetY	[nspid]MultiframeDetector	WSA NonSurvey	Dither offset Y {image extension keyword: CIR_YOFF}	real	4		-0.9999995e9	POS_OFFSET
domeTemp	[nspid]Multiframe	WSA NonSurvey	Dome temperature {image primary HDU keyword: DOMETEMP}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC