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

Glossary of WSA NonSurvey attributes (UKIDSSDR11)

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

E

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
eBV [nspid]DxsSource, [nspid]ExtendedSource, [nspid]JKsource, [nspid]LasPointSource, [nspid]PointSource, [nspid]Source, [nspid]UdsSource, [nspid]YJHKsource WSA NonSurvey The galactic dust extinction value measured from the Schlegel, Finkbeiner & Davis (1998) maps. This uses the correction given in Bonifacio, Monai & Beers (2000). This correction reduces the extinction value in regions of high extinction (E(B-V)>0.1) real 4   -0.9999995e9  
eccentricity [nspid]SatelliteOrbits WSA NonSurvey Eccentricity float 8      
ell [nspid]Detection WSA NonSurvey 1-b/a, where a/b=semi-major/minor axes (SE: THETA_IMAGE) {catalogue TType keyword: Ellipticity} real 4     PHYS_ELLIPTICITY
ell [nspid]Detection WSA NonSurvey 1-b/a, where a/b=semi-major/minor axes {catalogue TType keyword: Ellipticity} real 4     PHYS_ELLIPTICITY
ell [nspid]MapRemeasAver WSA NonSurvey Averaged 1-b/a, where a/b=semi-major/minor axes (SE: THETA_IMAGE) real 4     src.ellipticity
ell [nspid]MapRemeasurement WSA NonSurvey 1-b/a, where a/b=semi-major/minor axes (SE: THETA_IMAGE) {catalogue TType keyword: Ellipticity} real 4     src.ellipticity
ell [nspid]SatelliteDetection WSA NonSurvey 1-b/a, where a/b=semi-major/minor axes in the normal image real 4     PHYS_ELLIPTICITY
ell [nspid]UKIDSSDetection WSA NonSurvey 1-b/a, where a/b=semi-major/minor axes real 4     PHYS_ELLIPTICITY
ellDash [nspid]SatelliteDetection WSA NonSurvey 1-b/a, where a/b=semi-major/minor axes in the scrunched image {catalogue TType keyword: Ellipticity} real 4     PHYS_ELLIPTICITY
endCol [nspid]MultiframeDetector WSA NonSurvey End column of array readout {image extension keyword: RDOUT_X2} smallint 2     meta.number
endDate [nspid]AstrCalVers WSA NonSurvey MJD of the end time for this version of the calibration float 8 Julian days   time.epoch
endDate [nspid]PhotCalVers WSA NonSurvey Date time of end time for this version of the calibration (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 time.epoch
endRow [nspid]MultiframeDetector WSA NonSurvey End row of array readout {image extension keyword: RDOUT_Y2} smallint 2     meta.number
epoch [nspid]ExtendedSource, [nspid]GcsPointSource, [nspid]GpsPointSource, [nspid]JHKsource, [nspid]LasPointSource, [nspid]PointSource, [nspid]Source, [nspid]YJHKsource, [nspid]ZYJHKsource WSA NonSurvey Epoch of position measurement float 8 Years   TIME_EPOCH
epoch [nspid]FSstars WSA NonSurvey The epoch of columns ra and dec real 4 years -0.9999995e9  
epoch [nspid]RequiredMergeLogMultiEpoch WSA NonSurvey Epoch number in MergeLog table tinyint 1      
epoch [nspid]SatelliteOrbits WSA NonSurvey Epoch (in MJD) float 8 days    
epoch [nspid]Variability WSA NonSurvey Epoch of measurement float 8 Years   TIME_EPOCH
The Variability table contains statistics from the set of observations of each source. At present, the mean ra and dec and the error in two tangential directions are calculated. The "ra" direction is defined as tangential to both the radial direction and the cartesian z-axis and the "dec" direction is defined as both the radial direction and the "ra" direction. Since the current model is just the mean and standard deviation of the data, then the chi-squared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in non-synoptic filters: the one observation in these bands can help. In future releases a fit will be made to the rms data as a function of magnitude in each band, as has already happened for photometric data and a motion model that incorporates proper motion (and possibly parallax) will be used. The motion model is a parameter in the VarFrameSetInfo table.
epochFrameType [nspid]Programme WSA NonSurvey The frame type to be used for each epoch (stack, tile) varchar 16   NONE  
epochTolerance [nspid]Programme WSA NonSurvey Minimum separation of epochs for proper motion calculation real 4 days -0.9999995e9 ??
equinox [nspid]Multiframe WSA NonSurvey Equinox of object position {image primary HDU keyword: EQUINOX} real 4 years -0.9999995e9 time.equinox
errBits [nspid]Detection WSA NonSurvey processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} int 4     CODE_MISC
This uses the FLAGS attribute in SE. The individual bit flags that this can be decomposed into are as follows:
Bit FlagMeaning
1The object has neighbours, bright enough and close enough to significantly bias the MAG_AUTO photometry or bad pixels (more than 10% of photometry affected).
2The object was originally blended with another
4At least one pixel is saturated (or very close to)
8The object is truncated (too close to an image boundary)
16Object's aperture data are incomplete or corrupted
32Object's isophotal data are imcomplete or corrupted. This is an old flag inherited from SE v1.0, and is kept for compatability reasons. It doesn't have any consequence for the extracted parameters.
64Memory overflow occurred during deblending
128Memory overflow occurred during extraction

errBits [nspid]Detection WSA NonSurvey processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} int 4     CODE_MISC
Apparently not actually an error bit flag, but a count of the number of zero confidence pixels in the default (2 arcsec diameter) aperture.
errBits [nspid]MapRemeasurement WSA NonSurvey processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} int 4     meta.code
This uses the FLAGS attribute in SE. The individual bit flags that this can be decomposed into are as follows:
Bit FlagMeaning
1The object has neighbours, bright enough and close enough to significantly bias the MAG_AUTO photometry or bad pixels (more than 10% of photometry affected).
2The object was originally blended with another
4At least one pixel is saturated (or very close to)
8The object is truncated (too close to an image boundary)
16Object's aperture data are incomplete or corrupted
32Object's isophotal data are imcomplete or corrupted. This is an old flag inherited from SE v1.0, and is kept for compatability reasons. It doesn't have any consequence for the extracted parameters.
64Memory overflow occurred during deblending
128Memory overflow occurred during extraction

errBits [nspid]UKIDSSDetection WSA NonSurvey processing warning/error bitwise flags int 4     CODE_MISC
eta [nspid]CurrentAstrometry, [nspid]PreviousAstrometry WSA NonSurvey SDSS system spherical co-ordinate 2 of device centre float 8 Degrees   pos
eta [nspid]Detection, [nspid]DxsSource, [nspid]ExtendedSource, [nspid]GcsPointSource, [nspid]GpsPointSource, [nspid]JHKsource, [nspid]JKsource, [nspid]LasPointSource, [nspid]PointSource, [nspid]Source, [nspid]SynopticSource, [nspid]UKIDSSDetection, [nspid]UdsSource, [nspid]YJHKsource, [nspid]ZYJHKsource WSA NonSurvey SDSS system spherical co-ordinate 2 float 8 Degrees   POS
eta [nspid]MapRemeasAver, [nspid]MapRemeasurement WSA NonSurvey SDSS system spherical co-ordinate 2 float 8 Degrees   pos
expAstErr [nspid]Variability WSA NonSurvey Rms calculated from polynomial fit to minimum astrometric RMS as a function of magnitude real 4 arcsec -0.9999995e9  
The Variability table contains statistics from the set of observations of each source. At present, the mean ra and dec and the error in two tangential directions are calculated. The "ra" direction is defined as tangential to both the radial direction and the cartesian z-axis and the "dec" direction is defined as both the radial direction and the "ra" direction. Since the current model is just the mean and standard deviation of the data, then the chi-squared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in non-synoptic filters: the one observation in these bands can help. In future releases a fit will be made to the rms data as a function of magnitude in each band, as has already happened for photometric data and a motion model that incorporates proper motion (and possibly parallax) will be used. The motion model is a parameter in the VarFrameSetInfo table.
expTime [nspid]Multiframe WSA NonSurvey Integration time per exposure {image primary HDU keyword: EXP_TIME} real 4 seconds -0.9999995e9 time.duration;obs.exposure
extinction [nspid]Multiframe WSA NonSurvey Extinction coefficient {image primary HDU keyword: EXTINCT} real 4 mag -0.9999995e9  
extinctionCat [nspid]MultiframeDetector WSA NonSurvey Extinction coefficient for the catalogue data {catalogue extension keyword:  EXTINCT} real 4 mags -0.9999995e9 ??
For WFCAM these are currently set to a constant clear night level, which within the current measuring error is the same for all passbands. Note that the frame-by-frame derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view.
extinctionExt [nspid]MultiframeDetector WSA NonSurvey Extinction coefficient of the detector {image extension keyword: EXTINCT} real 4 mags -0.9999995e9 ??
For WFCAM these are currently set to a constant clear night level, which within the current measuring error is the same for all passbands. Note that the frame-by-frame derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view.
extinctionMapList [nspid]Programme WSA NonSurvey A list of 3D extinction maps that should be matched to this survey varchar 32   NONE meta.id
extNum [nspid]AstrometricInfo, [nspid]Detection, [nspid]FrameSets, [nspid]Orphan, [nspid]SatelliteDetection, [nspid]SourceXDetectionBestMatch, [nspid]UKIDSSDetection WSA NonSurvey the extension number of this frame tinyint 1     NUMBER
extNum [nspid]CurrentAstrometry, [nspid]EpochFrameStatus, [nspid]MapRemeasurement, [nspid]MultiframeDetector, [nspid]PreviousAstrometry, [nspid]PreviousMFDZP WSA NonSurvey the extension number of this frame tinyint 1     meta.number
extNum [nspid]MapRemeasAver WSA NonSurvey the extension number of this frame. tinyint 1     meta.number
extProgID [nspid]RequiredNeighbours WSA NonSurvey the unique programme ID for second table if there are multiple programmes in the neighbour survey int 4   -99999999 meta.id
extractor [nspid]RequiredMatchedApertureProduct WSA NonSurvey CASU list driven or SExtractor dual image mode varchar 16      
extractor [nspid]RequiredMosaicTopLevel WSA NonSurvey Extraction software (e.g. SExtractor) varchar 16      
extractParamTemp [nspid]RequiredMosaicTopLevel WSA NonSurvey Template file for SWARP parameters varchar 32   NONE  
extractTool [nspid]Programme WSA NonSurvey Name of extraction tool to be used varchar 8   NONE ??
extTableID [nspid]ExternalSurveyTable, [nspid]RequiredNeighbours WSA NonSurvey the unique table ID int 4     meta.id;meta.main
extTableName [nspid]ExternalSurveyTable WSA NonSurvey the name of the table varchar 256     meta.id;meta.dataset



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

wsa-support@roe.ac.uk
17/01/2022