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

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
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified 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 Flag Meaning 1 The object has neighbours, bright enough and close enough to significantly bias the MAG_AUTO photometry or bad pixels (more than 10% of photometry affected). 2 The object was originally blended with another 4 At least one pixel is saturated (or very close to) 8 The object is truncated (too close to an image boundary) 16 Object's aperture data are incomplete or corrupted 32 Object'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. 64 Memory overflow occurred during deblending 128 Memory 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 Flag Meaning 1 The object has neighbours, bright enough and close enough to significantly bias the MAG_AUTO photometry or bad pixels (more than 10% of photometry affected). 2 The object was originally blended with another 4 At least one pixel is saturated (or very close to) 8 The object is truncated (too close to an image boundary) 16 Object's aperture data are incomplete or corrupted 32 Object'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. 64 Memory overflow occurred during deblending 128 Memory 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