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

Glossary of WSA attributes

This Glossary alphabetically lists all attributes used in the UKIDSSEDR database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSEDR Schema Browser (other Browser versions).
A B C D E F G H I J K L M
N O P Q R S T U V W X Y Z

C

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
c_strat twomass_scn 2MASS Flag indicating the calibration strategy for this night's data. smallint 2     CODE_MISC
calType Plate SSA Intensity calibration wedge fit type, eg. SPLINE varchar 16     INST_PARAM
CalXK Plate SSA Stationary point in profile cal. curve real 4 inst. profile mag   FIT_PARAM_VALUE
camNum MultiframeDetector WSA Number of WFCAM camera (1, 2, 3 or 4) {image extension keyword: CAMNUM} int 4     ID_PLATE
camPower MultiframeDetector WSA Camera power (On|Off) {image extension keyword: CAMPOWER} varchar 3   --- ??
camReadOut MultiframeDetector WSA Camera readout (CDS|NDR|SAR|RRR) {image extension keyword: READOUT} varchar 3   --- ??
camRole MultiframeDetector WSA Camera role (master|slave|unsync) {image extension keyword: CAMROLE} varchar 8   NONE ??
catalogueSchema Programme WSA Script file that describes the catalogue schema varchar 64     ??
catCreationDate MultiframeDetector WSA Creation date/time of catalogue file {catalogue extension keyword:  DATE} datetime 8 MM-DD-YYYY:hh:mm:ss.sss 12-31-9999 ??
catName Multiframe WSA the filename of the associated catalogue MEF, eg. server:/path/filename.fits varchar 256     ID_CATALOG
catName iras_assoc_cats IRAS Source Name varchar 32     ID_MAIN
catNo iras_asc, iras_assoc_cats IRAS Catalog number tinyint 1     ID_CATALOG
cc_100 iras_psc IRAS point source correlation coefficient (100 micron). varchar 1     REMARKS
cc_12 iras_psc IRAS point source correlation coefficient (12 micron). varchar 1     REMARKS
cc_25 iras_psc IRAS point source correlation coefficient (25 micron). varchar 1     REMARKS
cc_60 iras_psc IRAS point source correlation coefficient (60 micron). varchar 1     REMARKS
cc_flg twomass_psc 2MASS Contamination and confusion flag. varchar 3     CODE_MISC
cc_flg twomass_xsc 2MASS indicates artifact contamination and/or confusion. varchar 1     CODE_MISC
ccdHeaterLevel Multiframe WSA AG CCD heater level (in percent) {image primary HDU keyword: CCD_HTP} real 4   -0.9999995e9  
ccdTemp Multiframe WSA AG CCD temperature {image primary HDU keyword: CCD_TEMP} real 4 degrees_Kelvin -0.9999995e9  
ccdTempSetPt Multiframe WSA AG CCD temperature setpoint {image primary HDU keyword: CCDTEMPS} real 4   -0.9999995e9  
cd11 CurrentAstrometry, PreviousAstrometry WSA Element of the linear transformation matrix (with scale) {image extension keyword: CD1_1} float 8     POS_TRANSF_PARAM
cd12 CurrentAstrometry, PreviousAstrometry WSA Element of the linear transformation matrix (with scale) {image extension keyword: CD1_2} float 8     POS_TRANSF_PARAM
cd21 CurrentAstrometry, PreviousAstrometry WSA Element of the linear transformation matrix (with scale) {image extension keyword: CD2_1} float 8     POS_TRANSF_PARAM
cd22 CurrentAstrometry, PreviousAstrometry WSA Element of the linear transformation matrix (with scale) {image extension keyword: CD2_2} float 8     POS_TRANSF_PARAM
centralDec CurrentAstrometry, PreviousAstrometry WSA Dec (J2000) at device centre float 8 Degrees -0.9999995e9 POS_EQ_DEC_MAIN
centralRa CurrentAstrometry, PreviousAstrometry WSA RA (J2000) at device centre float 8 Degrees -0.9999995e9 POS_EQ_RA_MAIN
centrePitch FieldSystem SSA The pitch of the field centres real 4 degrees   OBS_DIFF
cEpoch Plate SSA Catalogue epoch real 4 year   TIME_EPOCH
cEpTSys Plate SSA Catalogue epoch time system, eg. JULIAN varchar 16     NOTE
cEqTSys Plate SSA Catalogue equinox time system, eg. JULIAN varchar 16     NOTE
cEquinox Plate SSA Catalogue equinox real 4 year   TIME_EQUINOX
chi2 Source SSA Chi-squared value of proper motion solution real 4   -0.99999995e9 FIT_CHI2
chi2 gcsSource, gpsSource, lasSource WSA Chi-squared value of proper motion solution real 4   -0.9999995e9 FIT_CHI2
CIR_BVAR MultiframeDetector WSA Latest estimate of background variance {image extension keyword: CIR_BVAR} real 4   -0.9999995e9 INST_BACKGROUND
CIR_SCAL MultiframeDetector WSA Background scale relative to group maximum {image extension keyword: CIR_SCAL} real 4   -0.9999995e9 INST_BACKGROUND
CIR_ZERO MultiframeDetector WSA Pedestal value relative to group average {image extension keyword: CIR_ZERO} real 4   -0.9999995e9 FIT_PARAM_VALUE
CIRMED MultiframeDetector WSA Latest estimate of background {image extension keyword: CIRMED} real 4   -0.9999995e9 INST_BACKGROUND
cirr1 iras_psc IRAS Number of nearby 100 micron only WSDB sources tinyint 1     NUMBER
cirr2 iras_psc IRAS Spatially filtered 100 micron sky brightness ratio to flux density of point source tinyint 1     PHOT_FLUX_RATIO
cirr3 iras_psc IRAS Total 100 micron sky surface brightness smallint 2 MJy/sr   PHOT_SB_IR-100
class Detection SSA Classification flag tinyint 1     CLASS_OBJECT
class dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA Flag indicating most probable morphological classification {catalogue TType keyword: Classification}
-1 stellar, +1 non--stellar, 0 noise, -2 borderline stellar, -3 boderline galaxy, -9 saturated
smallint 2     CLASS_MISC
A discrete classification code for each detected image, based on various cuts on morphological parameters (see the Glossary entries for classStat and ell for further details). It is primarily based on cuts on the stellar profile statistic classStat and necessarily trades-off completeness against reliability between point-like (stellar) and extended (galaxian) images. The class assignments are as follows:
FlagMeaning
-9Saturated
-3Probable galaxy
-2Probable star
-1Star
0Noise
+1Galaxy

Note that the assignment of the discrete classification flag class is based on a -3.0≤class≤+2.5 (??) cut on this statistic (along with ellipticity and magnitude information??) and hence is conservative in the sense that it defines galaxy samples optimised for completeness, and conversely stellar samples optimised for reliability. For examples of the use of the various classification attributes in sample selection, especially with respect to the trade-off between completeness and reliability for stellar/galaxian samples, see the Views predefined in the WSA schema (these can be examined using the schema browser).
classB Source SSA Image classification from B band detection tinyint 1   0 CLASS_OBJECT
classI Source SSA Image classification from I band detection tinyint 1   0 CLASS_OBJECT
classMagB Source SSA B band magnitude selected by B image class real 4 mag -99.999995 PHOT_PHG_BJ
classMagI Source SSA I band magnitude selected by I image class real 4 mag -99.999995 PHOT_PHG_I
classMagR1 Source SSA R1 band magnitude selected by R1 image class real 4 mag -99.999995 PHOT_PHG_R
classMagR2 Source SSA R2 band magnitude selected by R2 image class real 4 mag -99.999995 PHOT_PHG_R
classR1 Source SSA Image classification from R1 band detection tinyint 1   0 CLASS_OBJECT
classR2 Source SSA Image classification from R2 band detection tinyint 1   0 CLASS_OBJECT
classStat dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA N(0,1) stellarness-of-profile statistic {catalogue TType keyword: Statistic} real 4     STAT_PROP
An equivalent N(0,1) measure of how stellar-like an image is, used in deriving the class attribute in a 'necessary but not sufficient' sense. Derived mainly from the curve-of-growth of flux using the well-defined stellar locus as a function of magnitude as a benchmark (see Irwin et al. 1994 SPIE 5493 411 for more details). Note that the assignment of the discrete classification flag class is based on a cut of -3.0≤class≤+2.5 (??) cut on this statistic (along with ellipticity and magnitude information??) and hence is conservative in the sense that it defines galaxy samples optimised for completeness, and conversely stellar samples optimised for reliability. For examples of the use of the various classification attributes in sample selection, especially with respect to the trade-off between completeness and reliability for stellar/galaxian samples, see the Views predefined in the WSA schema (these can be examined using the schema browser).
classStd CurrentStdStarInfo, PreviousStdStarInfo WSA type of standard: primary, secondary, variable tinyint 1   1 ????
cld twomass_scn 2MASS Special flag indicating whether or not a cloud was found in the scan after comparison of its photometry to that of overlapping scans in the database. smallint 2     CODE_MISC
clip RequiredStack WSA CASU stacking tool option to perform 3-sigma (robustly estimated) clipping before stacking pixels (y/n; recommended value=y) varchar 1     ??
coadd twomass_psc 2MASS Sequence number of the Atlas Image in which the position of this source falls. smallint 2     NUMBER
coadd twomass_xsc 2MASS 3-digit coadd number (unique within scan). smallint 2     NUMBER
coadd_key twomass_psc 2MASS Unique identification number of the record in the Atlas Image Data Table (NOT YET AVAILABLE) that corresponds to Image in which the position of this source falls. int 4     ID_NUMBER
coadd_key twomass_xsc 2MASS key to coadd data record in "scan DB". int 4     ID_NUMBER
coeffA CurrentNightlyExt, PreviousNightlyExt WSA the first-order extinction coefficient float 8   0.0 PHOT_ATM_EXT
coeffB CurrentNightlyExt, PreviousNightlyExt WSA the second-order extinction coefficient float 8   0.0 PHOT_ATM_EXT
coeffC CurrentNightlyExt, PreviousNightlyExt WSA colour dependent extinction coefficient float 8   0.0 PHOT_ATM_EXT
coeffs1 Plate SSA 1st coefficient of astrometric fit for XY to obs. xi,eta float 8     FIT_PARAM_VALUE
coeffs2 Plate SSA 2nd coefficient of astrometric fit for XY to obs. xi,eta float 8     FIT_PARAM_VALUE
coeffs3 Plate SSA 3rd coefficient of astrometric fit for XY to obs. xi,eta float 8     FIT_PARAM_VALUE
coeffs4 Plate SSA 4th coefficient of astrometric fit for XY to obs. xi,eta float 8     FIT_PARAM_VALUE
coeffs5 Plate SSA 5th coefficient of astrometric fit for XY to obs. xi,eta float 8     FIT_PARAM_VALUE
coeffs6 Plate SSA 6th coefficient of astrometric fit for XY to obs. xi,eta float 8     FIT_PARAM_VALUE
colour Survey SSA Survey colour, eg. blue, red or near-infrared varchar 16     OBS_BAND
combiframeID Provenance WSA the UID of the combined frame (=combiframe) bigint 8     ID_FRAME
comment ArchiveCurationHistory WSA Comment string supplied by the curator varchar 256     ??
compFile MultiframeDetector WSA Filename of the compressed image of this image frame, eg. server:/path/filename.jpg varchar 256     ID_FILE
conf glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Confusion flag smallint 2   -9 CODE_MISC
confID Multiframe WSA UID of library calibration confidence frame {image extension keyword: CIR_CPM} bigint 8   -99999999 ID_FRAME
configIndex MultiframeDetector WSA Configuration index {image extension keyword: CNFINDEX} int 4   -99999999 SPECT_INDEX_MISC
confLimit RequiredMosaic WSA CASU mosaic tool option to override the default 10% minimum confidence level for a contributing pixel tinyint 1 percent   ??
confuse_100 iras_psc IRAS Confusion flag (100 micron) tinyint 1     REMARKS
confuse_12 iras_psc IRAS Confusion flag (12 micron) tinyint 1     REMARKS
confuse_25 iras_psc IRAS Confusion flag (25 micron) tinyint 1     REMARKS
confuse_60 iras_psc IRAS Confusion flag (60 micron) tinyint 1     REMARKS
contam_flg twomass_xsc 2MASS contamination flag: 0=no stars, 1=stellar flux incl. in mag. smallint 2     CODE_MISC
coreRadius MultiframeDetector WSA Core radius for default profile fit {catalogue extension keyword:  RCORE} real 4 pixels -0.9999995e9 ??
User-selectable parameter, aperture flux designed to match median seeing of survey data. It is straighforward to show that if rcore = FWHM then for typical profiles encountered the rcore flux estimate has between 80-90% of the accuracy of an idealised perfectly known PSF model method.
corPlateTemp Multiframe WSA Cor plate temperature {image primary HDU keyword: CP_TEMP} real 4 degrees_Kelvin -0.9999995e9  
cosmag Detection SSA Isophotal magnitude real 4 instrumental units   PHOT_PHG_MAG
creationDate DifferenceImage, MosaicImage, StackImage WSA the date that this difference image was created in the format MM-DD-YYYY-Thh.mm.ss datetime 8 MM-DD-YYYY-Thh.mm.ss   TIME_DATE
creationDate Multiframe WSA File creation date (YYYY-MM-DD HH:MM:SS) {image primary HDU keyword: DATE} datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
creationDate MultiframeDetector WSA Creation date/time of file {image extension keyword: DATE} datetime 8 MM-DD-YYYY:hh:mm:ss.sss 12-31-9999 ??
crowd RequiredMosaic, RequiredStack WSA CASU source extraction tool option to switch on/off (1/0) crowded field analysis (recommended value=1) tinyint 1   0 ??
crowdedFlag MultiframeDetector WSA Crowded field analysis flag (0 none, 1 active) {catalogue extension keyword:  CROWDED} tinyint 1   0 CODE_MISC
User-selectable parameter, detection algorithm tried to disentangle overlapping images or images supperposed on the "slowly" varying background of other large images (default) otherwise just straighforward isophotal detection.
crPixX CurrentAstrometry, PreviousAstrometry WSA Pixel coordinate of the reference point on axis 1 {image extension keyword: CRPIX1} float 8 pixels   POS_CCD_X
crPixY CurrentAstrometry, PreviousAstrometry WSA Pixel coordinate of the reference point on axis 2 {image extension keyword: CRPIX2} float 8 pixels   POS_CCD_Y
crUnit1 CurrentAstrometry, PreviousAstrometry WSA Unit of right ascension co-ordinates {image extension keyword: CRUNIT1} varchar 8   NONE  
crUnit2 CurrentAstrometry, PreviousAstrometry WSA Unit of declination co-ordinates {image extension keyword: CRUNIT2} varchar 8   NONE  
crValX CurrentAstrometry, PreviousAstrometry WSA Coordinate value at reference point on axis 1 {image extension keyword: CRVAL1} float 8   -0.9999995e9 POS_CCD_X
crValY CurrentAstrometry, PreviousAstrometry WSA Coordinate value at reference point on axis 2 {image extension keyword: CRVAL2} float 8   -0.9999995e9 POS_CCD_Y
cryostPres Multiframe WSA Cryostat Pressure {image primary HDU keyword: CC_PRES} float 8 millibar -0.9999995e9  
cTypeX CurrentAstrometry, PreviousAstrometry WSA G&C WCS type, eg 'RA---ZPN' {image extension keyword: CTYPE1} varchar 8     POS_EQ_RA_MAIN
cTypeY CurrentAstrometry, PreviousAstrometry WSA G&C WCS type, eg 'DEC--ZPN' {image extension keyword: CTYPE2} varchar 8     POS_EQ_DEC_MAIN
cubicDist Plate SSA Cubic coefficient of radial distortion float 8     FIT_PARAM_VALUE
cuEventID ArchiveCurationHistory, AstrCalVers, CurrentAstrometry, CurrentNightlyExt, CurrentSpatialMap, CurrentStdStarInfo, CurrentZP, DetectorSetUp, DifferenceImage, dxsDetection, dxsListRemeasurement, dxsMergeLog, dxsSource, dxsSourceRemeasurement, gcsDetection, gcsListRemeasurement, gcsMergeLog, gcsSource, gcsSourceRemeasurement, gpsDetection, gpsListRemeasurement, gpsMergeLog, gpsSource, gpsSourceRemeasurement, lasDetection, lasListRemeasurement, lasMergeLog, lasSource, lasSourceRemeasurement, MosaicImage, Multiframe, MultiframeDetector, MultiframeSetUp, PhotCalVers, PreviousAstrometry, PreviousNightlyExt, PreviousSpatialMap, PreviousStdStarInfo, PreviousZP, ProgrammeCurationHistory, ProgrammeFrame, Provenance, StackImage, udsDetection, udsListRemeasurement, udsMergeLog, udsSource, udsSourceRemeasurement WSA UID of curation event giving rise to this record int 4     REFER_CODE
cuID ArchiveCurationHistory, CurationTask, RequiredCurationTask WSA the unique curation task ID smallint 2     REFER_CODE
curator ArchiveCurationHistory WSA The archive curation scientist responsible for this event varchar 16     ??
cutOff Filter WSA The 50% cut-off wavelength of the filter real 4 microns   ??
cutOn Filter WSA The 50% cut-on wavelength of the filter real 4 microns   ??
cx CurrentAstrometry, PreviousAstrometry WSA unit vector of spherical co-ordinates of device centre float 8     POS_EQ_X
cx Detection, Field, Source SSA Cartesian x of unit (ra,dec) vector on celestial sphere float 8     POS_EQ_X
cx dxsDetection, dxsListRemeasurement, dxsMergeLog, dxsSource, dxsSourceRemeasurement, gcsDetection, gcsListRemeasurement, gcsMergeLog, gcsSource, gcsSourceRemeasurement, gpsDetection, gpsListRemeasurement, gpsMergeLog, gpsSource, gpsSourceRemeasurement, lasDetection, lasListRemeasurement, lasMergeLog, lasSource, lasSourceRemeasurement, udsDetection, udsListRemeasurement, udsMergeLog, udsSource, udsSourceRemeasurement WSA unit vector of spherical co-ordinates float 8     POS_EQ_X
cx firstSource FIRST unit vector of spherical co-ordinates float 8     POS_EQ_X
cx glimpse_hrc_inter, glimpse_mca_inter GLIMPSE unit vector of spherical co-ordinates float 8     POS_EQ_X
cx iras_psc IRAS unit vector of spherical co-ordinates float 8     POS_EQ_X
cx rosat_bsc, rosat_fsc ROSAT unit vector of spherical co-ordinates float 8     POS_EQ_X
cx twomass_psc, twomass_scn, twomass_xsc 2MASS unit vector of spherical co-ordinates float 8     POS_EQ_X
cy CurrentAstrometry, PreviousAstrometry WSA unit vector of spherical co-ordinates of device centre float 8     POS_EQ_Y
cy Detection, Field, Source SSA Cartesian y of unit (ra,dec) vector on celestial sphere float 8     POS_EQ_Y
cy dxsDetection, dxsListRemeasurement, dxsMergeLog, dxsSource, dxsSourceRemeasurement, gcsDetection, gcsListRemeasurement, gcsMergeLog, gcsSource, gcsSourceRemeasurement, gpsDetection, gpsListRemeasurement, gpsMergeLog, gpsSource, gpsSourceRemeasurement, lasDetection, lasListRemeasurement, lasMergeLog, lasSource, lasSourceRemeasurement, udsDetection, udsListRemeasurement, udsMergeLog, udsSource, udsSourceRemeasurement WSA unit vector of spherical co-ordinates float 8     POS_EQ_Y
cy firstSource FIRST unit vector of spherical co-ordinates float 8     POS_EQ_Y
cy glimpse_hrc_inter, glimpse_mca_inter GLIMPSE unit vector of spherical co-ordinates float 8     POS_EQ_Y
cy iras_psc IRAS unit vector of spherical co-ordinates float 8     POS_EQ_Y
cy rosat_bsc, rosat_fsc ROSAT unit vector of spherical co-ordinates float 8     POS_EQ_Y
cy twomass_psc, twomass_scn, twomass_xsc 2MASS unit vector of spherical co-ordinates float 8     POS_EQ_Y
cz CurrentAstrometry, PreviousAstrometry WSA unit vector of spherical co-ordinates of device centre float 8     POS_EQ_Z
cz Detection, Field, Source SSA Cartesian z of unit (ra,dec) vector on celestial sphere float 8     POS_EQ_Z
cz dxsDetection, dxsListRemeasurement, dxsMergeLog, dxsSource, dxsSourceRemeasurement, gcsDetection, gcsListRemeasurement, gcsMergeLog, gcsSource, gcsSourceRemeasurement, gpsDetection, gpsListRemeasurement, gpsMergeLog, gpsSource, gpsSourceRemeasurement, lasDetection, lasListRemeasurement, lasMergeLog, lasSource, lasSourceRemeasurement, udsDetection, udsListRemeasurement, udsMergeLog, udsSource, udsSourceRemeasurement WSA unit vector of spherical co-ordinates float 8     POS_EQ_Z
cz firstSource FIRST unit vector of spherical co-ordinates float 8     POS_EQ_Z
cz glimpse_hrc_inter, glimpse_mca_inter GLIMPSE unit vector of spherical co-ordinates float 8     POS_EQ_Z
cz iras_psc IRAS unit vector of spherical co-ordinates float 8     POS_EQ_Z
cz rosat_bsc, rosat_fsc ROSAT unit vector of spherical co-ordinates float 8     POS_EQ_Z
cz twomass_psc, twomass_scn, twomass_xsc 2MASS unit vector of spherical co-ordinates float 8     POS_EQ_Z



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

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

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