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

Glossary of WSA NonSurvey attributes (UKIDSSDR2)

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

C

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
camNum [nspid]MultiframeDetector WSA NonSurvey Number of WFCAM camera (1, 2, 3 or 4) {image extension keyword: CAMNUM} int 4     ID_PLATE
camPower [nspid]MultiframeDetector WSA NonSurvey Camera power (On|Off) {image extension keyword: CAMPOWER} varchar 3   --- ??
camReadOut [nspid]MultiframeDetector WSA NonSurvey Camera readout (CDS|NDR|SAR|RRR) {image extension keyword: READOUT} varchar 3   --- ??
camRole [nspid]MultiframeDetector WSA NonSurvey Camera role (master|slave|unsync) {image extension keyword: CAMROLE} varchar 8   NONE ??
catalogueSchema [nspid]Programme WSA NonSurvey Script file that describes the catalogue schema varchar 64     ??
catCreationDate [nspid]MultiframeDetector WSA NonSurvey Creation date/time of catalogue file {catalogue extension keyword:  DATE} datetime 8 MM-DD-YYYY:hh:mm:ss.sss 12-31-9999 ??
catName [nspid]Multiframe WSA NonSurvey the filename of the associated catalogue MEF, eg. server:/path/filename.fits varchar 256     ID_CATALOG
ccdHeaterLevel [nspid]Multiframe WSA NonSurvey AG CCD heater level (in percent) {image primary HDU keyword: CCD_HTP} real 4   -0.9999995e9  
ccdTemp [nspid]Multiframe WSA NonSurvey AG CCD temperature {image primary HDU keyword: CCD_TEMP} real 4 degrees_Kelvin -0.9999995e9  
ccdTempSetPt [nspid]Multiframe WSA NonSurvey AG CCD temperature setpoint {image primary HDU keyword: CCDTEMPS} real 4   -0.9999995e9  
cd11 [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Element of the linear transformation matrix (with scale) {image extension keyword: CD1_1} float 8     POS_TRANSF_PARAM
cd12 [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Element of the linear transformation matrix (with scale) {image extension keyword: CD1_2} float 8     POS_TRANSF_PARAM
cd21 [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Element of the linear transformation matrix (with scale) {image extension keyword: CD2_1} float 8     POS_TRANSF_PARAM
cd22 [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Element of the linear transformation matrix (with scale) {image extension keyword: CD2_2} float 8     POS_TRANSF_PARAM
centralDec [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Dec (J2000) at device centre float 8 Degrees -0.9999995e9 POS_EQ_DEC_MAIN
centralRa [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey RA (J2000) at device centre float 8 Degrees -0.9999995e9 POS_EQ_RA_MAIN
chi2 [nspid]Source WSA NonSurvey Chi-squared value of proper motion solution real 4   -0.9999995e9 FIT_CHI2
CIR_BVAR [nspid]MultiframeDetector WSA NonSurvey Latest estimate of background variance {image extension keyword: CIR_BVAR} real 4   -0.9999995e9 INST_BACKGROUND
CIR_SCAL [nspid]MultiframeDetector WSA NonSurvey Background scale relative to group maximum {image extension keyword: CIR_SCAL} real 4   -0.9999995e9 INST_BACKGROUND
CIR_ZERO [nspid]MultiframeDetector WSA NonSurvey Pedestal value relative to group average {image extension keyword: CIR_ZERO} real 4   -0.9999995e9 FIT_PARAM_VALUE
CIRMED [nspid]MultiframeDetector WSA NonSurvey Latest estimate of background {image extension keyword: CIRMED} real 4   -0.9999995e9 INST_BACKGROUND
class [nspid]Detection WSA NonSurvey 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 (e.g. stellar) and extended (e.g. galaxy) images. The class assignments are as follows:
FlagMeaningGenerally satisfies
-2Probable star+2.0≤classStat≤+3.0
-1Star-3.0≤classStat≤+2.0
0NoiseclassStat≤-3.0
+1GalaxyclassStat≥+3.0

but these are also moderated by ellipticity overrides (e.g. ellipticity≥0.9 is flagged as class 0) and magnitude-dependent information (e.g. near or at saturation objects are preferentailly flagged as class -1). Hence class is conservative in the sense that it defines galaxy samples optimised for completeness, and conversely point-source 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 point/extended samples, see the Views predefined in the WSA schema (these can be examined using the schema browser). For much more information concerning the class attribute, see the CASU standard source extraction documentation.
classStat [nspid]Detection WSA NonSurvey N(0,1) stellarness-of-profile statistic {catalogue TType keyword: Statistic} real 4     STAT_PROP
An equivalent N(0,1) measure of how point-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=-1 is based on a cut of -3.0≤classStat≤+2.0 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 point or extended samples, see the Views predefined in the WSA schema (these can be examined using the schema browser).
classStd [nspid]CurrentStdStarInfo, [nspid]PreviousStdStarInfo WSA NonSurvey type of standard: primary, secondary, variable tinyint 1   1 ????
clip [nspid]RequiredStack WSA NonSurvey CASU stacking tool option to perform 3-sigma (robustly estimated) clipping before stacking pixels (y/n; recommended value=y) varchar 1     ??
coeffA [nspid]CurrentNightlyExt, [nspid]PreviousNightlyExt WSA NonSurvey the first-order extinction coefficient float 8   0.0 PHOT_ATM_EXT
coeffB [nspid]CurrentNightlyExt, [nspid]PreviousNightlyExt WSA NonSurvey the second-order extinction coefficient float 8   0.0 PHOT_ATM_EXT
coeffC [nspid]CurrentNightlyExt, [nspid]PreviousNightlyExt WSA NonSurvey colour dependent extinction coefficient float 8   0.0 PHOT_ATM_EXT
combiframeID [nspid]Provenance WSA NonSurvey the UID of the combined frame (=combiframe) bigint 8     ID_FRAME
comment [nspid]ArchiveCurationHistory WSA NonSurvey Comment string supplied by the curator varchar 256     ??
compFile [nspid]MultiframeDetector WSA NonSurvey Filename of the compressed image of this image frame, eg. server:/path/filename.jpg varchar 256     ID_FILE
confID [nspid]Multiframe WSA NonSurvey UID of library calibration confidence frame {image extension keyword: CIR_CPM} bigint 8   -99999999 ID_FRAME
configIndex [nspid]MultiframeDetector WSA NonSurvey Configuration index {image extension keyword: CNFINDEX} int 4   -99999999 SPECT_INDEX_MISC
confLimit [nspid]RequiredMosaic WSA NonSurvey CASU mosaic tool option to override the default 10% minimum confidence level for a contributing pixel tinyint 1 percent   ??
convFilter [nspid]RequiredMosaic, [nspid]RequiredStack WSA NonSurvey SEX source extraction tool option - name of convolution filter to be used varchar 20     ??
coord1 [nspid]ExternalSurveyTable WSA NonSurvey The attribute name of the first (longitudinal) spherical co-ordinate, e.g. equatorial RA varchar 32     ??
coord2 [nspid]ExternalSurveyTable WSA NonSurvey The attribute name of the second (latitudinal) spherical co-ordinate, e.g. equatorial Dec varchar 32     ??
coreRadius [nspid]MultiframeDetector WSA NonSurvey Core radius for default profile fit {catalogue extension keyword:  RCORE} real 4 pixels -0.9999995e9 ??
Tunable 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 [nspid]Multiframe WSA NonSurvey Cor plate temperature {image primary HDU keyword: CP_TEMP} real 4 degrees_Kelvin -0.9999995e9  
creationDate [nspid]DifferenceImage WSA NonSurvey 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 [nspid]Multiframe WSA NonSurvey 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 [nspid]MultiframeDetector WSA NonSurvey Creation date/time of file {image extension keyword: DATE} datetime 8 MM-DD-YYYY:hh:mm:ss.sss 12-31-9999 ??
crowd [nspid]RequiredMosaic, [nspid]RequiredStack WSA NonSurvey CASU source extraction tool option to switch on/off (1/0) crowded field analysis (recommended value=1) tinyint 1   0 ??
crowdedFlag [nspid]MultiframeDetector WSA NonSurvey Crowded field analysis flag (0 none, 1 active) {catalogue extension keyword:  CROWDED} tinyint 1   0 CODE_MISC
Tunable 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 [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Pixel coordinate of the reference point on axis 1 {image extension keyword: CRPIX1} float 8 pixels   POS_CCD_X
crPixY [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Pixel coordinate of the reference point on axis 2 {image extension keyword: CRPIX2} float 8 pixels   POS_CCD_Y
crUnit1 [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Unit of right ascension co-ordinates {image extension keyword: CRUNIT1} varchar 8   NONE  
crUnit2 [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Unit of declination co-ordinates {image extension keyword: CRUNIT2} varchar 8   NONE  
crValX [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Coordinate value at reference point on axis 1 {image extension keyword: CRVAL1} float 8   -0.9999995e9 POS_CCD_X
crValY [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey Coordinate value at reference point on axis 2 {image extension keyword: CRVAL2} float 8   -0.9999995e9 POS_CCD_Y
cryostPres [nspid]Multiframe WSA NonSurvey Cryostat Pressure {image primary HDU keyword: CC_PRES} float 8 millibar -0.9999995e9  
cTypeX [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey G&C WCS type, eg 'RA---ZPN' {image extension keyword: CTYPE1} varchar 8     POS_EQ_RA_MAIN
cTypeY [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey G&C WCS type, eg 'DEC--ZPN' {image extension keyword: CTYPE2} varchar 8     POS_EQ_DEC_MAIN
cuEventID [nspid]ArchiveCurationHistory, [nspid]AstrCalVers, [nspid]CurrentAstrometry, [nspid]CurrentNightlyExt, [nspid]CurrentPhtSoln, [nspid]CurrentSpatialMap, [nspid]CurrentStdStarInfo, [nspid]Detection, [nspid]DetectorSetUp, [nspid]DifferenceImage, [nspid]MergeLog, [nspid]Multiframe, [nspid]MultiframeDetector, [nspid]MultiframeSetUp, [nspid]PhotCalVers, [nspid]PreviousAstrometry, [nspid]PreviousNightlyExt, [nspid]PreviousPhtSoln, [nspid]PreviousSpatialMap, [nspid]PreviousStdStarInfo, [nspid]ProgrammeCurationHistory, [nspid]ProgrammeFrame, [nspid]Provenance, [nspid]Source WSA NonSurvey UID of curation event giving rise to this record int 4     REFER_CODE
cuID [nspid]ArchiveCurationHistory, [nspid]CurationTask, [nspid]RequiredCurationTask WSA NonSurvey the unique curation task ID smallint 2     REFER_CODE
curator [nspid]ArchiveCurationHistory WSA NonSurvey The archive curation scientist responsible for this event varchar 16     ??
cutOff [nspid]Filter WSA NonSurvey The 50% cut-off wavelength of the filter real 4 microns   ??
cutOn [nspid]Filter WSA NonSurvey The 50% cut-on wavelength of the filter real 4 microns   ??
cx [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey unit vector of spherical co-ordinates of device centre float 8     POS_EQ_X
cx [nspid]Detection, [nspid]MergeLog, [nspid]Source WSA NonSurvey unit vector of spherical co-ordinates float 8     POS_EQ_X
cx [nspid]Detection, [nspid]Source WSA NonSurvey unit vector of spherical co-ordinate float 8     POS_EQ_X
cy [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey unit vector of spherical co-ordinates of device centre float 8     POS_EQ_Y
cy [nspid]Detection, [nspid]MergeLog, [nspid]Source WSA NonSurvey unit vector of spherical co-ordinates float 8     POS_EQ_Y
cy [nspid]Detection, [nspid]Source WSA NonSurvey unit vector of spherical co-ordinate float 8     POS_EQ_Y
cz [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey unit vector of spherical co-ordinates of device centre float 8     POS_EQ_Z
cz [nspid]Detection, [nspid]MergeLog, [nspid]Source WSA NonSurvey unit vector of spherical co-ordinates float 8     POS_EQ_Z
cz [nspid]Detection, [nspid]Source WSA NonSurvey unit vector of spherical co-ordinate 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