WFCAM Science Archive

Glossary of WSA attributes

This Glossary alphabetically lists all attributes used in the UKIDSSDR2 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR2 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 CompleteStars, ReliableGalaxies, ReliableStars, Source SSA The great-circle distance of the source from the Galactic centre real 4 degrees POS_ANG_DIST_REL

D_MODULUS mgcGalaxyStruct MGC B proper distance to the object (h=1) real 4 Mpc

darkID Multiframe WSA UID of library calibration dark frame {image extension keyword: DARKCOR} bigint 8 -99999999 ID_FRAME

darkID Multiframe WSATransit 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

databaseName ExternalSurvey WSATransit 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 ??

dataScale MultiframeDetector WSATransit 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 ??

dataZero MultiframeDetector WSATransit 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

dateEnd Multiframe WSATransit 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

dateObs Multiframe WSATransit 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 ??

dbName Release WSATransit 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 ??

dbNamePrefix Survey WSATransit A string that prefixes all database names released for this survey varchar 32 ??

dbParam Plate SSA Deblending parameter real 4 REDUCT_PARAM

deblend UKIDSSDetection WSA flag for parent or part of deblended deconstruct (redundant since only deblended images are kept) int 4 CODE_MISC

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

deblend ptsDetection WSATransit 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

deblend udsDetection WSA Not available in SE output {catalogue TType keyword: Parent_or_child} int 4 -99999999

dec CompleteStars, ReliableGalaxies, ReliableStars, Source SSA Mean Dec, computed from detections merged in this catalogue float 8 degrees POS_EQ_DEC_MAIN

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 RequiredMosaic WSATransit 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 RequiredStack WSATransit Declination of stack centre float 8 degrees POS_EQ_DEC_MAIN

dec dxsJKsource, gcsPointSource, gcsZYJHKsource, gpsJHKsource, gpsPointSource, lasExtendedSource, lasPointSource, lasYJHKsource, reliableDxsSource, reliableGcsPointSource, reliableGpsPointSource, reliableLasPointSource, UKIDSSDetection WSA Celestial Declination 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 dxsJKmergeLog, dxsMergeLog, gcsMergeLog, gcsZYJHKmergeLog, gpsJHKmergeLog, gpsMergeLog, lasMergeLog, lasYJHKmergeLog, 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 mgcDetection MGC Object declination (J2000) float 8 deg

dec nvssSource NVSS J2000 Celestial Declination float 8 degrees POS_EQ_DEC_MAIN

dec ptsDetection WSATransit 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 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 ukirtFSstars WSA Declination of star at Equinox J2000.0 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

decB1950 mgcDetection MGC Object declination (B1950) float 8 deg

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

decBase Multiframe WSATransit 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 ??

decExtent RequiredMosaic WSATransit 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

decMoon Multiframe WSATransit 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

decMoonTopo Multiframe WSATransit 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

decTelOff Multiframe WSATransit 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 ??

decurtainRange MultiframeDetector WSATransit 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 ??

decurtFlag MultiframeDetector WSATransit 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 ??

delPropData SurveyProgrammes WSATransit 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) 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 Multiframe WSATransit 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) 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 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) 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 MultiframeDetector WSATransit 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) 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 UKIDSSDetection WSA Code for a current (=0) or deprecated (!=0) detection tinyint 1 0 CODE_MISC

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) 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 dxsJKmergeLog, dxsMergeLog, gcsMergeLog, gcsZYJHKmergeLog, gpsJHKmergeLog, gpsMergeLog, lasMergeLog, lasYJHKmergeLog, udsMergeLog WSA frame set deprecation flag (1=deprecated) tinyint 1 CODE_MISC

deprecated ptsDetection WSATransit 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) 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 CurationTask WSA description in words for this task varchar 256 NOTE

description CurationTask WSATransit description in words for this task varchar 256 NOTE

description ExternalSurvey WSA A brief description of the survey varchar 256 NOTE

description ExternalSurvey WSATransit A brief description of the survey varchar 256 NOTE

description Filter WSA a concise description of the filter varchar 256 NOTE

description Filter WSATransit a concise description of the filter varchar 256 NOTE

description Programme WSA a concise description of the programme varchar 256 NOTE

description Programme WSATransit a concise description of the programme varchar 256 NOTE

description Release WSA a brief description of the release varchar 256 NOTE

description Release WSATransit a brief description of the release varchar 256 NOTE

description RequiredMosaic WSATransit Description of the product varchar 256 ??

description RequiredMosaic, RequiredStack WSA Description of the product varchar 256 ??

description Survey WSA A concise description of the survey varchar 512 ??

description Survey WSATransit 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

detCols MultiframeDetector WSATransit 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 ??

detectionObjID Programme WSATransit The attribute name(s) of the UID for detections varchar 64 ??

detectionTable Programme WSA Table name of detections varchar 64 ??

detectionTable Programme WSATransit Table name of detections varchar 64 ??

detectorTable Programme WSA Name of table containing frame detector metadata varchar 64 ??

detectorTable Programme WSATransit 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 ??

detectorTemp MultiframeDetector WSATransit 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

detectorType MultiframeDetector WSATransit 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

detHeaterLevel Multiframe WSATransit 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

detRows MultiframeDetector WSATransit 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

detTempAlt Multiframe WSATransit 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

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

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

deviceID DetectorSetUp WSATransit 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 MultiframeDetector WSATransit Device UID identifying every IR device {image extension keyword: DETECTID} varchar 32 ID_PLATE

deviceID PreviousPhtSoln 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

dewPoint Multiframe WSATransit 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 ??

dfsIDString Programme WSATransit 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

dhsVersion Multiframe WSATransit 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

diffimID DifferenceImage WSATransit 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

DISK_I mgcGalaxyStruct MGC Disk Inclination (0=face-on) real 4 99.99

DISK_Im mgcGalaxyStruct MGC Disk Inclination error (-) real 4 99.99

DISK_Ip mgcGalaxyStruct MGC Disk Inclination error (+) real 4 99.99

DISK_PA mgcGalaxyStruct MGC Disk Position Angle real 4 99.99

DISK_PAm mgcGalaxyStruct MGC Disk Position Angle error (-) real 4 99.99

DISK_PAp mgcGalaxyStruct MGC Disk Position Angle error (+) real 4 99.99

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, lasSourceXDR3PhotoObj, lasSourceXDR5PhotoObj, lasSourceXSSASource, lasSourceXfirstSource, lasSourceXiras_psc, lasSourceXmgcDetection, lasSourceXnvssSource, lasSourceXrosat_bsc, lasSourceXrosat_fsc, lasSourceXtwomass_psc, lasSourceXtwomass_xsc, udsSourceNeighbours, udsSourceXtwomass_psc WSA Angular separation between neighbours real 4 arcminutes POS_ANG_DIST_GENERAL

distanceMins ptsDetectionNeighbours, ptsDetectionXtwomass_psc WSATransit Angular separation between neighbours real 4 arcminutes POS_ANG_DIST_GENERAL

distortMap CurrentAstrometry WSATransit filename of 2d non-linear distortion map varchar 256 NONE ID_FILE

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

ditherOffsetX MultiframeDetector WSATransit 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

ditherOffsetY MultiframeDetector WSATransit 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 Multiframe WSATransit 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

dualFilterID RequiredMosaic WSATransit 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

dualFilterID RequiredMosaic, RequiredStack WSA 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

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