WFCAM Science Archive

Glossary of WSA attributes

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

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 32 ??

dbParam Plate SSA Deblending parameter real 4 REDUCT_PARAM

deblend dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement 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 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

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 dxsMergeLog, gcsMergeLog, gpsMergeLog, lasMergeLog, udsMergeLog WSA Declination of field centre float 8 degrees POS_EQ_DEC_MAIN

dec firstSource FIRST J2000 Celestial Declination float 8 degrees POS_EQ_DEC_MAIN

dec glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Declination (J2000) 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_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

dec_err glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Error in Declination float 8 arcsec ERROR

decBase Multiframe WSA Declination of base position {image primary HDU keyword: DECBASE} float 8 degrees -0.9999995e9 POS_EQ_DEC_MAIN

decCentre CurrentStdStarInfo, PreviousStdStarInfo, StdFieldInfo WSA Declination of field centre float 8 degrees POS_EQ_RA_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

decMoon Multiframe WSA Geocentric J2000 FK5 Mean Declination of the Moon float 8 degrees -0.9999995e9 POS_EQ_DEC_MAIN

decMoonTopo Multiframe WSA Apparent topocentric Declination of the Moon (including precession, nutation, and annual aberration) float 8 degrees -0.9999995e9 POS_EQ_DEC_MAIN

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

decStar CurrentStdStarInfo, PreviousStdStarInfo WSA Declination of star float 8 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

decurtainRange MultiframeDetector WSA Range of decurtain correction {image extension keyword: CURTNRNG} real 4 -0.9999995e9 ??

decurtFlag MultiframeDetector WSA De-curtaining flag {image extension keyword: DECURTN} varchar 32 NONE ??

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 WSA 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):

Flag Meaning

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)

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

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

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 " " " - multiple bad channels

62 " " " - Moon ghost

63 " " " - Sky subtraction problem

64 " " " - Disaster (catchall category for the indescribable)

65 " " " - Empty detector frame

66 " " " - Flat field problem

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.

deprecated MultiframeDetector WSA 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):

Flag Meaning

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)

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

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

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 " " " - multiple bad channels

62 " " " - Moon ghost

63 " " " - Sky subtraction problem

64 " " " - Disaster (catchall category for the indescribable)

65 " " " - Empty detector frame

66 " " " - Flat field problem

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.

deprecated dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA 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):

Flag Meaning

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)

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

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

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 " " " - multiple bad channels

62 " " " - Moon ghost

63 " " " - Sky subtraction problem

64 " " " - Disaster (catchall category for the indescribable)

65 " " " - Empty detector frame

66 " " " - Flat field problem

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.

deprecated dxsMergeLog, gcsMergeLog, gpsMergeLog, lasMergeLog, udsMergeLog WSA frame set deprecation flag (1=deprecated) 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 ??

detectorTemp MultiframeDetector WSA Detector array temperature {image extension keyword: DET_TEMP} real 4 degrees_Kelvin -0.9999995e9 ??

detectorType MultiframeDetector WSA Detector array used, eg. Aladdin {image extension keyword: DETECTOR} varchar 16 NONE INST_ID

detHeaterLevel Multiframe WSA Det heater level (in percent) {image primary HDU keyword: DET_HTP} real 4 -0.9999995e9

detRows MultiframeDetector WSA Number of detector rows {image extension keyword: DROWS} smallint 2 pixels NUMBER

detTempAlt Multiframe WSA DET_TEMP alternate sensor {image primary HDU keyword: DETTEMPB} real 4 degrees_Kelvin -0.9999995e9

detTempSetPt Multiframe WSA Det temperature setpoint {image primary HDU keyword: DETTEMPS} real 4 degrees_Kelvin -0.9999995e9

deviceID CurrentSpatialMap, CurrentZP, DetectorSetUp, PreviousSpatialMap WSA Numerical device UID identifying every IR device {image extension keyword: CAMNUM} tinyint 1 ID_PLATE

deviceID MultiframeDetector WSA Device UID identifying every IR device {image extension keyword: DETECTID} varchar 32 ID_PLATE

deviceID PreviousZP WSA Numerical device UID identifying every IR device 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 ??

dhsVersion Multiframe WSA Data handling version {image primary HDU keyword: DHSVER} varchar 32 NONE

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 dxsSourceNeighbours, dxsSourceXtwomass_psc, gcsSourceNeighbours, gcsSourceXtwomass_psc, gpsSourceNeighbours, gpsSourceXglimpse_hrc_inter, gpsSourceXglimpse_mca_inter, gpsSourceXtwomass_psc, lasSourceNeighbours, lasSourceXDR2PhotoObj, lasSourceXSSASource, lasSourceXfirstSource, lasSourceXiras_psc, lasSourceXrosat_bsc, lasSourceXrosat_fsc, lasSourceXtwomass_psc, lasSourceXtwomass_xsc, udsSourceNeighbours, udsSourceXtwomass_psc 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

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