Home | Overview | Browser | Access | Login | Cookbook | nonSurvey 
  WSA logo

Glossary of WSA attributes

This Glossary alphabetically lists all attributes used in the UKIDSSDR4 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR4 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
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 128     ??
dbName Release WSATransit the name of the SQL Server database containing this release varchar 128     ??
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 Placeholder flag for parent or part of deblended deconstruct (redundant since only deblended images are kept) int 4     CODE_MISC
deblend dxsDetection, gcsDetection, gpsDetection, lasDetection WSA Placeholder 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
This CASU pipeline processing source extraction flag is a placeholder only, and is always set to zero. If you need to know when a particular image detection is a component of a deblend or not, test bit 4 of attribute ppErrBits (see corresponding glossary entry) which is set by WFAU's post-processing software based on testing the areal profiles aprof2-8 (these are set by CASU to -1 for deblended components, or positive values for non-deblended detections). We encode this in an information bit of ppErrBits for convenience when querying the detection and source tables.
deblend dxsListRemeasurement, gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, udsListRemeasurement WSA placeholder 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 Placeholder 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
This CASU pipeline processing source extraction flag is a placeholder only, and is always set to zero. If you need to know when a particular image detection is a component of a deblend or not, test bit 4 of attribute ppErrBits (see corresponding glossary entry) which is set by WFAU's post-processing software based on testing the areal profiles aprof2-8 (these are set by CASU to -1 for deblended components, or positive values for non-deblended detections). We encode this in an information bit of ppErrBits for convenience when querying the detection and source tables.
deblend udsDetection WSA Not available in SE output {catalogue TType keyword: Parent_or_child} int 4   -99999999  
DEC twoxmm XMM Corrected Declination of the detection in degrees (J2000) after statistical correlation of the emldetect coordinates, RA_UNC and DEC_UNC, with the USNO B1.0 optical source catalogue using the SAS task eposcorr. In case where the cross-correlation is determined to be unreliable no correction is applied and this value is therefore the same as DEC_UNC. float 8 degrees    
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, reliableUdsSource, UKIDSSDetection WSA Celestial Declination float 8 Degrees   POS_EQ_DEC_MAIN
dec dxsDetection, dxsListRemeasurement, dxsSource, dxsSourceRemeasurement, dxsVariability, gcsDetection, gcsListRemeasurement, gcsSource, gcsSourceRemeasurement, gpsDetection, gpsListRemeasurement, gpsSource, gpsSourceRemeasurement, lasDetection, lasListRemeasurement, lasSource, lasSourceRemeasurement, udsDetection, udsListRemeasurement, udsSource, udsSourceRemeasurement, udsVariability 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
DEC_UNC twoxmm XMM Declination of the source in degrees (J2000) as determined by the SAS task emldetect by fitting a detection simultaneously in all cameras and energy bands. float 8 degrees    
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 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
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):
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
27 Deprecated because frame is flagged as part of a summit-rejected MSB
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
110 Intermediate stack frame photometry found to be poor wrt run of all stacks in a deep field
≥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):
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
27 Deprecated because frame is flagged as part of a summit-rejected MSB
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
110 Intermediate stack frame photometry found to be poor wrt run of all stacks in a deep field
≥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):
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
27 Deprecated because frame is flagged as part of a summit-rejected MSB
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
110 Intermediate stack frame photometry found to be poor wrt run of all stacks in a deep field
≥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):
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
27 Deprecated because frame is flagged as part of a summit-rejected MSB
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
110 Intermediate stack frame photometry found to be poor wrt run of all stacks in a deep field
≥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):
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
27 Deprecated because frame is flagged as part of a summit-rejected MSB
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
110 Intermediate stack frame photometry found to be poor wrt run of all stacks in a deep field
≥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):
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
27 Deprecated because frame is flagged as part of a summit-rejected MSB
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
110 Intermediate stack frame photometry found to be poor wrt run of all stacks in a deep field
≥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
detectionTable Programme WSA Table name of detections varchar 64     ??
detectionTable Programme WSATransit Table name of detections 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  
DETID twoxmm XMM A consecutive number which identifies each entry (detection) in the catalogue. int 4      
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 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
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  
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_NN twoxmm XMM The distance to the nearest detection.
An internal threshold of 6 arseconds (before positional fitting) is used for splitting a source into two.
real 4 arcsec    
dist_opt twomass_psc 2MASS Distance separating TWOMASS source position and associated optical source within 5". real 4 arcsec   INST_PLATE_DIST
distanceMins dxsSourceNeighbours, dxsSourceXDetection, dxsSourceXtwomass_psc, dxsSourceXtwoxmm, gcsSourceNeighbours, gcsSourceXDR5PhotoObj, gcsSourceXtwomass_psc, gcsSourceXtwoxmm, gpsSourceNeighbours, gpsSourceXglimpse_hrc_inter, gpsSourceXglimpse_mca_inter, gpsSourceXtwomass_psc, gpsSourceXtwoxmm, lasSourceNeighbours, lasSourceXDR2PhotoObj, lasSourceXDR3PhotoObj, lasSourceXDR5PhotoObj, lasSourceXDR5PhotoObjAll, lasSourceXSegueDR6PhotoObj, lasSourceXSegueDR6PhotoObjAll, lasSourceXfirstSource, lasSourceXiras_psc, lasSourceXmgcDetection, lasSourceXnvssSource, lasSourceXrosat_bsc, lasSourceXrosat_fsc, lasSourceXtwomass_psc, lasSourceXtwomass_xsc, lasSourceXtwoxmm WSA 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



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
03/04/2009