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

Glossary of WSA NonSurvey attributes (UKIDSSDR2)

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

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified 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 the observation {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 the observation {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 32     ??
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, [nspid]Source 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]FSstars WSA NonSurvey Declination of star at Equinox J2000.0 float 8 degrees   POS_EQ_DEC_MAIN
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
decCentre [nspid]CurrentStdStarInfo, [nspid]PreviousStdStarInfo, [nspid]StdFieldInfo WSA NonSurvey Declination of field centre float 8 degrees   POS_EQ_RA_MAIN
decExtent [nspid]RequiredMosaic WSA NonSurvey The angular extent in Dec of the mosaic image real 4 degrees   ??
decMoon [nspid]Multiframe WSA NonSurvey Geocentric J2000 FK5 Mean Declination of the Moon float 8 degrees -0.9999995e9 POS_EQ_DEC_MAIN
decMoonTopo [nspid]Multiframe WSA NonSurvey Apparent topocentric Declination of the Moon (including precession, nutation, and annual aberration) float 8 degrees -0.9999995e9 POS_EQ_DEC_MAIN
decStar [nspid]CurrentStdStarInfo, [nspid]PreviousStdStarInfo WSA NonSurvey Declination of star float 8 degrees   POS_EQ_DEC_MAIN
decTelOff [nspid]Multiframe WSA NonSurvey Declination telescope offset {image primary HDU keyword: TDECOFF} real 4 arcsec -0.9999995e9 POS_EQ_DEC_OFF
decurtainRange [nspid]MultiframeDetector WSA NonSurvey Range of decurtain correction {image extension keyword: CURTNRNG} real 4   -0.9999995e9 ??
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]Detection WSA NonSurvey Code for a current (=0) or deprecated (!=0) detection tinyint 1   0 CODE_MISC
The deprecation attribute in all tables indicates if the record in question (be it an image or catalogue detection record) has been deprecated by some curation process in the archive. All data having deprecated=0 are nominally good data; the following flags indicate a quality issue and any data having those flags should not be used for scientific purposes (in many instances, deprecated data will be deleted from public survey released database products):
FlagMeaning
1 Stack frames that have no catalogue or other frameTypes deprecated at ingest (e.g. because a reprocessed frame supercedes it)
2 Dead detector frames
3 Undefined and or non-sensible critical image metadata attributes
4 Sky subtraction not OK (via pipeline sky sub scale factor) NB. not used from October 2005 onwards
5 Incorrect combination of expTime,numExp,numInts for survey specific projects
6 Incorrect frame complements within groups/nights (for incomplete MSBs)
7 Undefined values of critical catalogue attributes for stacks
8 Seeing=0.0 for a stack
9 High value of sky that compromises the depth, or otherwise invalid sky level (e.g. sky < 0)
10 Seeing outside specified maximum
11 Photometric zeropoint too bright
12 Average stellar ellipticity too high (> 0.25)
13 Depth (as calculated from sky noise and 5sigma detection in fixed aperture) is too shallow compared to overall histogram distribution (i.e. shallower than ~0.5mag wrt the modal value) OR sky noise is too high given the sky level
14 AperCor3 outlying in aperCor3 versus seeing distribution
15 Pipeline MAGZPT inconsistent between image PHDU, extension HDUs and/or catalogue extension HDUs (from attributes photZP, photZPExt and photZPCat)
16 Difference in detector sky level wrt to mean of all 4 detectors is outlying in the distribution of the same.
18 Provenance indicates that a constituent frame of a combined frame product includes a deprecated frame.
19 Inconsistent provenance for a stack or leav product indicating something wrong with the image product (usually screwed up FITS keywords confusing the pipeline)
20 Detector number counts indicate some problem (loads of crud images)
21 5-sigma depth of detector frame more than 0.4mag brighter than modal value for a given filter/project/exposure time
22 Basic astrometry check (pixel size and/or aspect ratio) indicates something is wrong with the image
26 Deprecated because frame is flagged as ignored in pipeline processing
40 Science (*stack) frame is not part of a survey (e.g. high latitude sky frames in the GPS)
60 Eyeball check deprecation - trailed
61 Eyeball check deprecation - multiple bad channels
62 Eyeball check deprecation - Moon ghost
63 Eyeball check deprecation - Sky subtraction problem
64 Eyeball check deprecation - Disaster (catchall category for the indescribable)
65 Eyeball check deprecation - Empty detector frame
66 Eyeball check deprecation - Flat field problem
67 Eyeball check deprecation - Malfunction in crosstalk correction
70 Eyeball check deprecation, but this is the best that can be done so should not be reobserved (e.g. very bright star in FOV)
80 Deprecated because observation (MSB,object,filter) has been repeated later (shallow surveys only). The latest duplicate in each case is kept
81 Deprecated because observation (MSB,object,filter) has been repeated in a later Semester (shallow surveys only). The deepest duplicate in each case is kept
99 Manually deprecated because of some DFS issue (e.g. pipeline screw-up)
100 Multiframe deprecated because all detectors have been previously deprecated (and the MF not already deprecated)
101 MultiframeDetectors deprecated because parent Multiframe is deprecated (and the MFD not already deprecated)
102 *Detection deprecated because parent MFD deprecated
≥128 Frame deprecated because reprocessing supercedes it

Note: for deprecation values of 128 or greater, the most significant bit of the byte has been set in order to preserve the deprecation value set by any previous quality control flagging run on the previous processed version.
deprecated [nspid]MergeLog WSA NonSurvey frame set deprecation flag (1=deprecated) tinyint 1     CODE_MISC
deprecated [nspid]Multiframe WSA NonSurvey Code for a current (=0) or deprecated (!=0) multiframe tinyint 1   0 CODE_MISC
The deprecation attribute in all tables indicates if the record in question (be it an image or catalogue detection record) has been deprecated by some curation process in the archive. All data having deprecated=0 are nominally good data; the following flags indicate a quality issue and any data having those flags should not be used for scientific purposes (in many instances, deprecated data will be deleted from public survey released database products):
FlagMeaning
1 Stack frames that have no catalogue or other frameTypes deprecated at ingest (e.g. because a reprocessed frame supercedes it)
2 Dead detector frames
3 Undefined and or non-sensible critical image metadata attributes
4 Sky subtraction not OK (via pipeline sky sub scale factor) NB. not used from October 2005 onwards
5 Incorrect combination of expTime,numExp,numInts for survey specific projects
6 Incorrect frame complements within groups/nights (for incomplete MSBs)
7 Undefined values of critical catalogue attributes for stacks
8 Seeing=0.0 for a stack
9 High value of sky that compromises the depth, or otherwise invalid sky level (e.g. sky < 0)
10 Seeing outside specified maximum
11 Photometric zeropoint too bright
12 Average stellar ellipticity too high (> 0.25)
13 Depth (as calculated from sky noise and 5sigma detection in fixed aperture) is too shallow compared to overall histogram distribution (i.e. shallower than ~0.5mag wrt the modal value) OR sky noise is too high given the sky level
14 AperCor3 outlying in aperCor3 versus seeing distribution
15 Pipeline MAGZPT inconsistent between image PHDU, extension HDUs and/or catalogue extension HDUs (from attributes photZP, photZPExt and photZPCat)
16 Difference in detector sky level wrt to mean of all 4 detectors is outlying in the distribution of the same.
18 Provenance indicates that a constituent frame of a combined frame product includes a deprecated frame.
19 Inconsistent provenance for a stack or leav product indicating something wrong with the image product (usually screwed up FITS keywords confusing the pipeline)
20 Detector number counts indicate some problem (loads of crud images)
21 5-sigma depth of detector frame more than 0.4mag brighter than modal value for a given filter/project/exposure time
22 Basic astrometry check (pixel size and/or aspect ratio) indicates something is wrong with the image
26 Deprecated because frame is flagged as ignored in pipeline processing
40 Science (*stack) frame is not part of a survey (e.g. high latitude sky frames in the GPS)
60 Eyeball check deprecation - trailed
61 Eyeball check deprecation - multiple bad channels
62 Eyeball check deprecation - Moon ghost
63 Eyeball check deprecation - Sky subtraction problem
64 Eyeball check deprecation - Disaster (catchall category for the indescribable)
65 Eyeball check deprecation - Empty detector frame
66 Eyeball check deprecation - Flat field problem
67 Eyeball check deprecation - Malfunction in crosstalk correction
70 Eyeball check deprecation, but this is the best that can be done so should not be reobserved (e.g. very bright star in FOV)
80 Deprecated because observation (MSB,object,filter) has been repeated later (shallow surveys only). The latest duplicate in each case is kept
81 Deprecated because observation (MSB,object,filter) has been repeated in a later Semester (shallow surveys only). The deepest duplicate in each case is kept
99 Manually deprecated because of some DFS issue (e.g. pipeline screw-up)
100 Multiframe deprecated because all detectors have been previously deprecated (and the MF not already deprecated)
101 MultiframeDetectors deprecated because parent Multiframe is deprecated (and the MFD not already deprecated)
102 *Detection deprecated because parent MFD deprecated
≥128 Frame deprecated because reprocessing supercedes it

Note: for deprecation values of 128 or greater, the most significant bit of the byte has been set in order to preserve the deprecation value set by any previous quality control flagging run on the previous processed version.
deprecated [nspid]MultiframeDetector WSA NonSurvey Code for a current (=0) or deprecated (!=0) multiframe detector tinyint 1   0 CODE_MISC
The deprecation attribute in all tables indicates if the record in question (be it an image or catalogue detection record) has been deprecated by some curation process in the archive. All data having deprecated=0 are nominally good data; the following flags indicate a quality issue and any data having those flags should not be used for scientific purposes (in many instances, deprecated data will be deleted from public survey released database products):
FlagMeaning
1 Stack frames that have no catalogue or other frameTypes deprecated at ingest (e.g. because a reprocessed frame supercedes it)
2 Dead detector frames
3 Undefined and or non-sensible critical image metadata attributes
4 Sky subtraction not OK (via pipeline sky sub scale factor) NB. not used from October 2005 onwards
5 Incorrect combination of expTime,numExp,numInts for survey specific projects
6 Incorrect frame complements within groups/nights (for incomplete MSBs)
7 Undefined values of critical catalogue attributes for stacks
8 Seeing=0.0 for a stack
9 High value of sky that compromises the depth, or otherwise invalid sky level (e.g. sky < 0)
10 Seeing outside specified maximum
11 Photometric zeropoint too bright
12 Average stellar ellipticity too high (> 0.25)
13 Depth (as calculated from sky noise and 5sigma detection in fixed aperture) is too shallow compared to overall histogram distribution (i.e. shallower than ~0.5mag wrt the modal value) OR sky noise is too high given the sky level
14 AperCor3 outlying in aperCor3 versus seeing distribution
15 Pipeline MAGZPT inconsistent between image PHDU, extension HDUs and/or catalogue extension HDUs (from attributes photZP, photZPExt and photZPCat)
16 Difference in detector sky level wrt to mean of all 4 detectors is outlying in the distribution of the same.
18 Provenance indicates that a constituent frame of a combined frame product includes a deprecated frame.
19 Inconsistent provenance for a stack or leav product indicating something wrong with the image product (usually screwed up FITS keywords confusing the pipeline)
20 Detector number counts indicate some problem (loads of crud images)
21 5-sigma depth of detector frame more than 0.4mag brighter than modal value for a given filter/project/exposure time
22 Basic astrometry check (pixel size and/or aspect ratio) indicates something is wrong with the image
26 Deprecated because frame is flagged as ignored in pipeline processing
40 Science (*stack) frame is not part of a survey (e.g. high latitude sky frames in the GPS)
60 Eyeball check deprecation - trailed
61 Eyeball check deprecation - multiple bad channels
62 Eyeball check deprecation - Moon ghost
63 Eyeball check deprecation - Sky subtraction problem
64 Eyeball check deprecation - Disaster (catchall category for the indescribable)
65 Eyeball check deprecation - Empty detector frame
66 Eyeball check deprecation - Flat field problem
67 Eyeball check deprecation - Malfunction in crosstalk correction
70 Eyeball check deprecation, but this is the best that can be done so should not be reobserved (e.g. very bright star in FOV)
80 Deprecated because observation (MSB,object,filter) has been repeated later (shallow surveys only). The latest duplicate in each case is kept
81 Deprecated because observation (MSB,object,filter) has been repeated in a later Semester (shallow surveys only). The deepest duplicate in each case is kept
99 Manually deprecated because of some DFS issue (e.g. pipeline screw-up)
100 Multiframe deprecated because all detectors have been previously deprecated (and the MF not already deprecated)
101 MultiframeDetectors deprecated because parent Multiframe is deprecated (and the MFD not already deprecated)
102 *Detection deprecated because parent MFD deprecated
≥128 Frame deprecated because reprocessing supercedes it

Note: for deprecation values of 128 or greater, the most significant bit of the byte has been set in order to preserve the deprecation value set by any previous quality control flagging run on the previous processed version.
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]CurrentPhtSoln, [nspid]CurrentSpatialMap, [nspid]DetectorSetUp, [nspid]PreviousSpatialMap WSA NonSurvey Numerical device UID identifying every IR device {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]PreviousPhtSoln WSA NonSurvey Numerical device UID identifying every IR device 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
dualFilterID [nspid]RequiredMosaic, [nspid]RequiredStack WSA NonSurvey SEX extraction tool option to run in dual image mode UID of dual image filter (assigned in WSA: 1=Z,2=Y,3=J,4=H,5=K,6=H2,7=Br,8=blank) tinyint 1   0 INST_FILTER_CODE


Home | Overview | Browser | Access | Login | Cookbook | nonSurvey
Listing | Region | MenuQuery | FreeSQL
Links | Credits

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK
Tel +44 131 668 8356 (office)
or +44 131 668 8100 (switchboard)

wsa-support@roe.ac.uk
27/01/2009