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 UKIDSSR1 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSR1 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 Source SSA The great-circle distance of the source from the Galactic centre real 4 degrees   POS_ANG_DIST_REL
darkID Multiframe WSA UID of library calibration dark frame {image extension keyword: DARKCOR} bigint 8   -99999999 ID_FRAME
databaseName ExternalSurvey WSA The name of the database within the WSA varchar 16     ID_DATABASE
dataScale MultiframeDetector WSA Scaling of pixel values {image extension keyword: BSCALE} real 4   1.0 ??
dataZero MultiframeDetector WSA Zeropoint of pixel values {image extension keyword: BZERO} real 4   0.0 ??
date twomass_psc, twomass_xsc 2MASS The observation reference date for this source expressed in ISO standard format. (YYYY-MM-DD) datetime 8 yyyy-mm-dd   TIME_DATE
date twomass_scn 2MASS The observation reference date for this scan expressed in ISO standard format. (YYYY-MM-DD) datetime 8 yyyy-mm-dd   TIME_DATE
dateEnd Multiframe WSA Date and time (UTC) of end of obs {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 obs {image primary HDU keyword: DATE-OBS} datetime 8   12-31-9999 TIME_DATE
dbAcut Plate SSA Minimum area of deblended object detection tinyint 1 pixels   REDUCT_PARAM
dbAmax Plate SSA Maximum area of parent image that can be deblended int 4 pixels   REDUCT_PARAM
dbAmin Plate SSA Minimum area of parent image that can be deblended tinyint 1 pixels   REDUCT_PARAM
dbLevel Plate SSA No. of rethresholding levels for deblending tinyint 1     REDUCT_PARAM
dbName Release WSA the name of the SQL Server database containing this release varchar 16     ??
dbNamePrefix Survey WSA A string that prefixes all database names released for this survey varchar 8     ??
dbParam Plate SSA Deblending parameter real 4     REDUCT_PARAM
deblend calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA flag indicating parent/child relation {catalogue TType keyword: Parent_or_child} int 4     CODE_MISC
deblend u05a18Detection WSA flag for parent or part of deblended deconstruct (redundant since only deblended images are kept) {catalogue TType keyword: Parent_or_child} int 4     CODE_MISC
dec Detection SSA Celestial Declination float 8 degrees   POS_EQ_DEC_MAIN
dec RequiredMosaic WSA Declination of mosaic centre float 8 degrees   POS_EQ_DEC_MAIN
dec RequiredStack WSA Declination of stack centre float 8 degrees   POS_EQ_DEC_MAIN
dec Source SSA Mean Dec, computed from detections merged in this catalogue float 8 degrees   POS_EQ_DEC_MAIN
dec calDetection WSA Celestial Declination {catalogue TType keyword: DEC} float 8 Degrees   POS_EQ_DEC_MAIN
dec calMergeLog, commMergeLog, dxsMergeLog, gcsMergeLog, gpsMergeLog, lasMergeLog, udsMergeLog WSA Declination of field centre float 8 degrees   POS_EQ_DEC_MAIN
dec commDetection, commSource, 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
dec firstSource FIRST J2000 Celestial Declination float 8 degrees   POS_EQ_DEC_MAIN
dec iras_psc IRAS J2000 Celestial Declination float 8 degrees   POS_EQ_DEC_MAIN
dec rosat_bsc, rosat_fsc ROSAT Declination (decimal degrees; J2000) float 8 degrees   POS_EQ_DEC_MAIN
dec twomass_psc 2MASS J2000 declination with respect to the ICRS float 8 degrees   POS_EQ_DEC_MAIN
dec twomass_scn 2MASS Declination of scan center for equinox J2000. float 8 degrees   POS_EQ_DEC_MAIN
dec twomass_xsc 2MASS Declination (J2000 decimal deg) based on peak pixel. float 8 degrees   POS_EQ_DEC_MAIN
dec u05a18Detection 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_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
decBase Multiframe WSA Declination of base position {image primary HDU keyword: DECBASE} float 8 degrees   POS_EQ_DEC_MAIN
decCol Plate SSA Name of Dec column in reference catalogue varchar 16     REMARKS
decExtent RequiredMosaic WSA The angular extent in Dec of the mosaic image real 4 degrees   ??
decMax Survey SSA Northern (Dec) limit of survey float 8 degrees   POS_EQ_DEC
decMin Survey SSA Southern (Dec) limit of survey float 8 degrees   POS_EQ_DEC
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
delPropData SurveyProgrammes WSA Logical flag indicating that proprietary data should be removed on release (1=yes; 0=no) tinyint 1     ??
density twomass_xsc 2MASS Coadd log(density) of stars with k<14 mag. real 4     PHYS_DENSITY_NUMBER
deprecated Multiframe, MultiframeDetector WSA Is the frame superseded by reprocessing (0=no, 1=yes)? tinyint 1   0 ??
deprecated calDetection, commDetection, dxsDetection, gcsDetection, gpsDetection, lasDetection, u05a18Detection, udsDetection WSA code for a current (=0) or deprecated (!=0) detection. tinyint 1   0 CODE_MISC
deprecated calMergeLog, commMergeLog, dxsMergeLog, gcsMergeLog, gpsMergeLog, lasMergeLog, udsMergeLog WSA frame set deprecation flag (1=deprecated) tinyint 1     CODE_MISC
deprecated dxsListRemeasurement, gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, udsListRemeasurement WSA code for a current (=0) or repeat (!=0) detection. tinyint 1     CODE_MISC
description CurationTask WSA description in words for this task varchar 256     NOTE
description ExternalSurvey WSA A brief description of the survey varchar 256     NOTE
description Filter WSA a concise description of the filter varchar 256     NOTE
description Programme WSA a concise description of the programme varchar 256     NOTE
description Release WSA a brief description of the release varchar 256     NOTE
description RequiredMosaic, RequiredStack WSA Description of the product varchar 256     ??
description Survey WSA A concise description of the survey varchar 512     ??
designation twomass_psc 2MASS Sexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...]. varchar 17     NAME
designation twomass_xsc 2MASS Source designation formed from sexigesimal coordinates. varchar 17     NAME
detCols MultiframeDetector WSA Number of detector columns {image extension keyword: DCOLUMNS} smallint 2 pixels   NUMBER
detectionObjID Programme WSA The attribute name(s) of the UID for detections varchar 64     ??
detectionTable Programme WSA Table name of detections varchar 64     ??
detectorTable Programme WSA Name of table containing frame detector metadata varchar 64     ??
detectorType MultiframeDetector WSA Detector array used, eg. Aladdin {image extension keyword: DETECTOR} varchar 16   NONE INST_ID
detRows MultiframeDetector WSA Number of detector rows {image extension keyword: DROWS} smallint 2 pixels   NUMBER
deviceID CurrentNightlyZP, DetectorSetUp WSA the device UID {image extension keyword: CAMNUM} tinyint 1     ID_PLATE
deviceID Device WSA Device UID identifying every IR device (or combination of devices) {image primary HDU keyword: CAMNUM} tinyint 1     ID_PLATE
deviceID MultiframeDetector WSA Device UID identifying every IR device {image extension keyword: CAMNUM} tinyint 1     ID_PLATE
deviceID PreviousNightlyZP WSA the device UID tinyint 1     ID_PLATE
dewPoint Multiframe WSA Dewpoint {image primary HDU keyword: DEWPOINT} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
dFlag rosat_bsc, rosat_fsc ROSAT complex diffuse emission pattern varchar 1     CODE_MISC
dfsIDString Programme WSA The description used within the data flow system (ie. the value of the appropriate FITS keyword) varchar 64     ??
diffimID DifferenceImage WSA the unique ID number identifying all stored difference images bigint 8     ID_FRAME
directory Plate SSA Name of directory in flat-file system of source data. varchar 80     ID_FILE
disc_100 iras_psc IRAS Discrepant Fluxes flag (100 micron) tinyint 1     REMARKS
disc_12 iras_psc IRAS Discrepant Fluxes flag (12 micron) tinyint 1     REMARKS
disc_25 iras_psc IRAS Discrepant Fluxes flag (25 micron) tinyint 1     REMARKS
disc_60 iras_psc IRAS Discrepant Fluxes flag (60 micron) tinyint 1     REMARKS
dist_edge_ew twomass_psc 2MASS The distance from the source to the nearest East or West scan edge. int 4 arcsec   INST_PLATE_DIST
dist_edge_ew twomass_xsc 2MASS The distance from the source to the nearest East or West scan edge. smallint 2 arcsec   INST_PLATE_DIST
dist_edge_flg twomass_psc 2MASS Two character flag that specifies to which scan edges a source lies closest, and to which edges the dist_edge_ns and dist_edge_ew values refer. varchar 2     INST_PLATE_DIST
dist_edge_flg twomass_xsc 2MASS flag indicating which edges ([n|s][e|w]) are nearest to src. varchar 2     INST_PLATE_DIST
dist_edge_ns twomass_psc, twomass_xsc 2MASS The distance from the source to the nearest North or South scan edge. int 4 arcsec   INST_PLATE_DIST
dist_opt twomass_psc 2MASS Distance separating TWOMASS source position and associated optical source within 5". real 4 arcsec   INST_PLATE_DIST
distanceMins commSourceNeighbours, commSourceXDR2PhotoObj, commSourceXSSASource, commSourceXfirstSource, commSourceXiras_psc, commSourceXrosat_bsc, commSourceXrosat_fsc, commSourceXtwomass_psc, commSourceXusnob_psc, dxsSourceNeighbours, gcsSourceNeighbours, gcsSourceXtwomass_psc, gpsSourceNeighbours, gpsSourceXtwomass_psc, lasSourceNeighbours, lasSourceXDR2PhotoObj, lasSourceXSSASource, lasSourceXfirstSource, lasSourceXiras_psc, lasSourceXrosat_bsc, lasSourceXrosat_fsc, lasSourceXtwomass_psc, lasSourceXusnob_psc, udsSourceNeighbours WSA Angular separation between neighbours real 4 arcminutes   POS_ANG_DIST_GENERAL
distortMap CurrentAstrometry, PreviousAstrometry WSA filename of 2d non-linear distortion map varchar 256   NONE ID_FILE
distType Plate SSA Radial distortion term in solution, eg. R/TAN(R) varchar 80     MODEL_CORRECTION
ditherOffsetX MultiframeDetector WSA Dither offset X {image extension keyword: CIR_XOFF} real 4   -0.9999995e9 POS_OFFSET
ditherOffsetY MultiframeDetector WSA Dither offset Y {image extension keyword: CIR_YOFF} real 4   -0.9999995e9 POS_OFFSET
domeHumid Plate SSA Dome relative humidity at obsevation time real 4     OBS_CONDITIONS
domePressure Plate SSA Dome pressure at observation real 4 mBar   OBS_CONDITIONS
domeTemp Multiframe WSA Dome temperature {image primary HDU keyword: DOMETEMP} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
domeTemp Plate SSA Dome temp at observation real 4 Kelvin   OBS_CONDITIONS
dum rosat_bsc, rosat_fsc ROSAT dummy flag varchar 1     CODE_MISC
dup_src twomass_psc, twomass_xsc 2MASS Duplicate source flag. smallint 2     CODE_MISC



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