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

P

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
pa Detection SSA Celestial position angle (E of N) smallint 2 degrees   POS_POS-ANG
pa calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA ellipse fit orientation to x axis {catalogue TType keyword: Position_angle} real 4 degrees   POS_POS-ANG
pa firstSource FIRST position angle (east of north) derived from the elliptical Gaussian model for the source real 4 degrees   POS_POS-ANG
pa u05a18Detection WSA ellipse fit orientation to x axis {catalogue TType keyword: Position_angle}
Angle of ellipse major axis wrt x axis.
real 4 degrees   POS_POS-ANG
pairingCriterion Programme WSA The pairing criterion for associating detections into merged sources real 4 Degrees   ??
parentID Detection SSA objID of parent object, = objID for parent/undeblended (ie. not child) object bigint 8     ID_PARENT
pCut Plate SSA Threshold "percentage cut" for pixel analysis real 4 percent   STAT_%REJECT
petroFlux calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA flux within circular aperture r_p {catalogue TType keyword: Petr_flux} real 4 ADU   PHOT_INTENSITY_ADU
petroFlux u05a18Detection WSA flux within circular aperture to k × r_p ; k = 2 {catalogue TType keyword: Petr_flux} real 4 ADU   PHOT_INTENSITY_ADU
petroFluxErr calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA error on Petrosian flux {catalogue TType keyword: Petr_flux_err} real 4 ADU   ERROR
petroMag calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA Calibrated Petrosian magnitude within circular aperture r_p real 4 mag   PHOT_INT-MAG
petroMagErr calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA error on calibrated Petrosian magnitude real 4 mag   ERROR
petroRad calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA r_p {catalogue TType keyword: Petr_radius} real 4 pixels   EXTENSION_RAD
petroRad u05a18Detection WSA r_p as defined in Yasuda et al. 2001 AJ 112 1104 {catalogue TType keyword: Petr_radius} real 4 pixels   EXTENSION_RAD
pFlag rosat_bsc, rosat_fsc ROSAT possible problem with position determination varchar 1     CODE_MISC
pGalaxy commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA Probability that the source is a galaxy real 4     STAT_PROP
ph_qual twomass_psc 2MASS Photometric quality flag. varchar 3     CODE_QUALITY
phaRange rosat_bsc, rosat_fsc ROSAT PHA range with highest detection likelihood varchar 1     CODE_MISC
pHeight calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA Highest pixel value above sky {catalogue TType keyword: Peak_height} real 4 ADU   PHOT_COUNTS_MISC
pHeight u05a18Detection WSA Highest pixel value above sky {catalogue TType keyword: Peak_height}
In counts relative to local value of sky - also zeroth order aperture flux.
real 4 ADU   PHOT_COUNTS_MISC
pHeightErr calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA Error in peak height {catalogue TType keyword: Peak_height_err} real 4 ADU   ERROR
phi_opt twomass_psc 2MASS Position angle on the sky of the vector from the the associated optical source to the TWOMASS source position, in degrees East of North. smallint 2 degrees   POS_POS-ANG
pixelScale MultiframeDetector WSA Pixel size {image extension keyword: PIXLSIZE} real 4 arcsec per pixel INST_PIXSIZE
plateID Detection SSA Plate ID of the plate that this detection came from int 4     ID_PLATE
plateID Plate SSA Unique identifier of the plate: surveyID plus field number combo int 4     ID_PLATE
plateNum Plate SSA Plate number assigned by observatory smallint 2     ID_PLATE
plateScale Survey SSA Nominal plate scale real 4 arcsec/mm   INST_SCALE
plxCol Plate SSA Name of parallax column in reference catalogue varchar 16     REMARKS
pNearH iras_psc IRAS Number of nearby hours-confirmed point sources tinyint 1     NUMBER
pNearW iras_psc IRAS Number of nearby weeks-confirmed point sources tinyint 1     NUMBER
pNoise commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA Probability that the source is noise real 4     STAT_PROP
pointingID Multiframe WSA Pointing ID within survey {image primary HDU keyword: SURVEY_I} varchar 64   NONE ??
pos iras_asc IRAS Position Angle from IRAS Source to Association (E of N) smallint 2 degrees   POS_POS-ANG
posAng iras_psc IRAS Uncertainty ellipse position angle (East of North) smallint 2 degrees   POS_POS-ANG
posAngle CurrentAstrometry WSA orientation of image x-axis to N-S float 8 Degrees   POS_POS-ANG
posAngle PreviousAstrometry WSA orientation of image y-axis to N-S float 8 Degrees   POS_POS-ANG
postProb JunkDetection SSA Posterior probability of detection being junk real 4     STAT_PROBABILITY
ppErrBits calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA additional WFAU post-processing error bits (place holder for now) {catalogue TType keyword: Error_bit_flag} int 4     CODE_MISC
prfMag Detection SSA Profile magnitude real 4 instrumental units   PHOT_PHG_MAG
prfStat Detection SSA Profile statistic real 4 N(0,1)   CLASS_STAR/GALAXY
prfStatB Source SSA Profile statistic from B band detection real 4 N(0,1) -0.99999995e9 CLASS_STAR/GALAXY
prfStatI Source SSA Profile statistic from I band detection real 4 N(0,1) -0.99999995e9 CLASS_STAR/GALAXY
prfStatR1 Source SSA Profile statistic from R1 band detection real 4 N(0,1) -0.99999995e9 CLASS_STAR/GALAXY
prfStatR2 Source SSA Profile statistic from R2 band detection real 4 N(0,1) -0.99999995e9 CLASS_STAR/GALAXY
priFlgLb rosat_bsc, rosat_fsc ROSAT priority flag L-broad tinyint 1     CODE_MISC
priFlgLh rosat_bsc, rosat_fsc ROSAT priority flag L-hard tinyint 1     CODE_MISC
priFlgLs rosat_bsc, rosat_fsc ROSAT priority flag L-soft tinyint 1     CODE_MISC
priFlgMb rosat_bsc, rosat_fsc ROSAT priority flag M-broad tinyint 1     CODE_MISC
priFlgMh rosat_bsc, rosat_fsc ROSAT priority flag M-hard tinyint 1     CODE_MISC
priFlgMs rosat_bsc, rosat_fsc ROSAT priority flag M-soft tinyint 1     CODE_MISC
priOrSec commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates). bigint 8   -99999999 CODE_MISC
priOrSec dxsSourceRemeasurement, gcsSourceRemeasurement, gpsSourceRemeasurement, lasSourceRemeasurement, udsSourceRemeasurement WSA Seam code for a unique (=0) or duplicated (!=0) source (eg. flags overlap duplicates). bigint 8     CODE_MISC
productID RequiredDiffImage, RequiredStack WSA A unique identifier assigned to each required stack product entry int 4     ??
productID RequiredMosaic WSA A unique identifier assigned to each required mosaic product entry int 4     ??
programmeID Programme WSA UID of the archived programme coded as above int 4     ID_SURVEY
programmeID ProgrammeCurationHistory, ProgrammeTable, RequiredCurationTask, RequiredFilters WSA the unique programme ID int 4     ID_SURVEY
programmeID ProgrammeFrame, SurveyProgrammes WSA WSA assigned programme UID {image primary HDU keyword: PROJECT} int 4   -99999999 ID_SURVEY
programmeID RequiredDiffImage, RequiredListDrivenProduct, RequiredMosaic, RequiredNeighbours, RequiredStack WSA The unique programme ID int 4     ID_SURVEY
project Multiframe WSA Time-allocation code {image primary HDU keyword: PROJECT} varchar 64   NONE REFER_CODE
projection RequiredMosaic WSA CASU mosaic tool option to specify output WCS projection type (TAN for gnomonic, ZPN for zenithal polynomial) varchar 3     ??
propPeriod Programme WSA the proprietory period for any data taken for this programme in months, e.g. 12 for open time. int 4 months   TIME_PERIOD
proprietary Survey WSA Logical flag indicating whether a survey is proprietary or not (1=yes; 0=no) tinyint 1     ??
prox twomass_psc, twomass_xsc 2MASS Proximity. real 4 arcsec   POS_ANG_DIST_GENERAL
pSaturated commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA Probability that the source is saturated real 4     STAT_PROP
psfFitChi2 calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA standard normalised variance of PSF fit {catalogue TType keyword: PSF_fit_chi2} real 4   -0.9999995e9 FIT_STDEV
psfFitDof calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA no. of degrees of freedom of PSF fit {catalogue TType keyword: PSF_fit_dof} smallint 2   -9999 STAT_N-DOF
psfFitX calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA PSF-fitted X coordinate {catalogue TType keyword: PSF_fit_X} real 4 pixels -0.9999995e9 POS_PLATE_X
psfFitXerr calDetection, u05a18Detection WSA Error on PSF-fitted X coordinate {catalogue TType keyword: PSF_fit_X_error} real 4 pixels -0.9999995e9 ERROR
psfFitXerr commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA Error on PSF-fitted X coordinate {catalogue TType keyword: PSF_fit_X_err} real 4 pixels -0.9999995e9 ERROR
psfFitY calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA PSF-fitted Y coordinate {catalogue TType keyword: PSF_fit_Y} real 4 pixels -0.9999995e9 POS_PLATE_Y
psfFitYerr calDetection, u05a18Detection WSA Error on PSF-fitted Y coordinate {catalogue TType keyword: PSF_fit_y_error} real 4 pixels -0.9999995e9 ERROR
psfFitYerr commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA Error on PSF-fitted Y coordinate {catalogue TType keyword: PSF_fit_y_err} real 4 pixels -0.9999995e9 ERROR
psfFlux calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA PSF-fitted flux {catalogue TType keyword: PSF_flux} real 4 ADU -0.9999995e9 PHOT_INTENSITY_ADU
psfFluxErr calDetection, u05a18Detection WSA Error on PSF-fitted flux {catalogue TType keyword: PSF_flux_error} real 4 ADU -0.9999995e9 ERROR
psfFluxErr commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA Error on PSF-fitted flux {catalogue TType keyword: PSF_flux_err} real 4 ADU -0.9999995e9 ERROR
psfMag calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA PSF-fitted calibrated magnitude real 4 mag -0.9999995e9 PHOT_PROFILE
psfMagErr calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, u05a18Detection, udsDetection, udsListRemeasurement WSA Error on PSF-fitted calibrated magnitude real 4 mag -0.9999995e9 ERROR
pStar commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA Probability that the source is a star real 4     STAT_PROP
pts_key twomass_psc 2MASS A unique identification number for the PSC source. int 4     ID_NUMBER
pts_key twomass_xsc 2MASS key to point source data DB record. int 4     ID_NUMBER
pv21 CurrentAstrometry, PreviousAstrometry WSA Coefficient for r term {image extension keyword: PV2_1} float 8   0 POS_TRANSF_PARAM
pv23 CurrentAstrometry, PreviousAstrometry WSA Coefficient for r**3 term {image extension keyword: PV2_3} float 8   0 POS_TRANSF_PARAM
pxcntr twomass_psc 2MASS The pts_key value of the nearest source in the PSC. int 4     NUMBER
pxcntr twomass_xsc 2MASS ext_key value of nearest XSC source. int 4     NUMBER
pxpa twomass_psc, twomass_xsc 2MASS The position angle on the sky of the vector from the source to the nearest neighbor in the PSC, in degrees East of North. smallint 2 degrees   POS_POS-ANG



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