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

Glossary of WSA NonSurvey attributes (UKIDSSDR4)
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

S
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
scrunch	[nspid]RequiredMosaic	WSA NonSurvey	CASU mosaic tool mandatory parameter to specifying the no. of pixels to rebin into one pixel in the output image (1=no rebinning)	smallint	2	pixels		??
scTemp	[nspid]Multiframe	WSA NonSurvey	SCSU cab temperature {image primary HDU keyword: SC_TEMP}	real	4	degrees_Kelvin	-0.9999995e9
sdsuNum	[nspid]MultiframeDetector	WSA NonSurvey	Serial number of SDSU controller {image extension keyword: SDSUID}	varchar	32		NONE	??
secondaryTemp	[nspid]Multiframe	WSA NonSurvey	Temperature of secondary {image primary HDU keyword: SECONDAR}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
seeing	[nspid]MultiframeDetector	WSA NonSurvey	Average FWHM {catalogue extension keyword:  SEEING}	real	4	pixels	-0.9999995e9	??
			An average realistic FWHM estimated directly from the stellar images on the frame. Multiply by pixel scale size to convert to arcsec (eg. ×0.400 WFCAM; ×0.333 INT WFC).
seqNum	[nspid]Detection	WSA NonSurvey	the running number of this detection {catalogue TType keyword: Sequence_number} The running number for ease of reference, in strict order of image detections.	int	4			ID_NUMBER
seqNum	[nspid]SourceXDetectionBestMatch	WSA NonSurvey	the running number of this detection {catalogue TType keyword: Sequence_number} The running number for ease of reference, in strict order of image detections.	int	4		-99999999	ID_NUMBER
SerFit1DChi2	[nspid]Detection	WSA NonSurvey	Error in 1D fit {catalogue TType keyword: 1D_Sersic_fit_chi2} standard normalised variance of fit [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4		-0.9999995e9	PHOT_PROFILE_PAR
SerFit2DChi2	[nspid]Detection	WSA NonSurvey	Error in 2D fit {catalogue TType keyword: 2D_Sersic_fit_chi2} standard normalised variance of fit [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4		-0.9999995e9	PHOT_PROFILE_PAR
SerFitNu1D	[nspid]Detection	WSA NonSurvey	No. of degrees of freedom for 1D Sersic fit {catalogue TType keyword: 1D_Sersic_fit_nu} [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4		-0.9999995e9	STAT_N-DOF
SerFitNu2D	[nspid]Detection	WSA NonSurvey	No. of degrees of freedom for 2D Sersic fit {catalogue TType keyword: 2D_Sersic_fit_nu} [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4		-0.9999995e9	STAT_N-DOF
SerFlux1D	[nspid]Detection	WSA NonSurvey	1D Sersic flux {catalogue TType keyword: 1D_Sersic_flux} [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4	ADU	-0.9999995e9	PHOT_INTENSITY_ADU
SerFlux2D	[nspid]Detection	WSA NonSurvey	2D Sersic flux {catalogue TType keyword: 2D_Sersic_flux} [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4	ADU	-0.9999995e9	PHOT_INTENSITY_ADU
SerIdx1D	[nspid]Detection	WSA NonSurvey	Power law index {catalogue TType keyword: 1D_Sersic_index} [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4		-0.9999995e9	PHOT_PROFILE_PAR
SerIdx2D	[nspid]Detection	WSA NonSurvey	Power law index {catalogue TType keyword: 2D_Sersic_index} [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4		-0.9999995e9	PHOT_PROFILE_PAR
SerMag1D	[nspid]Detection	WSA NonSurvey	Calibrated 1D Sersic flux [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4	mag	-0.9999995e9	PHOT_PROFILE
SerMag2D	[nspid]Detection	WSA NonSurvey	Calibrated 2D Sersic flux [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4	mag	-0.9999995e9	PHOT_PROFILE
SerScaleLen1D	[nspid]Detection	WSA NonSurvey	Scale length {catalogue TType keyword: 1D_Sersic_scale_len} [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4		-0.9999995e9	PHOT_PROFILE_PAR
SerScaleLen2D	[nspid]Detection	WSA NonSurvey	Scale length {catalogue TType keyword: 2D_Sersic_scale_len} [For numerical stability the Sersic fits will use the previously derived x-y coordinates]	real	4		-0.9999995e9	PHOT_PROFILE_PAR
server	[nspid]ExternalSurvey	WSA NonSurvey	The location of the database: load or public server	varchar	16			??
shortName	[nspid]Filter	WSA NonSurvey	Short identification name for the filter	varchar	4			??
sigDec	[nspid]Variability	WSA NonSurvey	Uncertainty in mean Dec	real	4	Degrees	-0.9999995e9	ERROR
			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.
sigMuDec	[nspid]Variability	WSA NonSurvey	Error on proper motion in Dec	real	4	mas/yr	-0.9999995e9	ERROR
			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.
sigMuRa	[nspid]Variability	WSA NonSurvey	Error on proper motion in RA	real	4	mas/yr	-0.9999995e9	ERROR
			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.
sigRa	[nspid]Variability	WSA NonSurvey	Uncertainty in mean RA	real	4	Degrees	-0.9999995e9	ERROR
			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.
sky	[nspid]Detection	WSA NonSurvey	local interpolated sky level from background tracker {catalogue TType keyword: Sky_level}	real	4	ADU		INST_SKY_LEVEL
skyCorrCat	[nspid]MultiframeDetector	WSA NonSurvey	Percentage sky correction for the catalogue data {catalogue extension keyword:  PERCORR} corrected photometry = 2.5×log10(flux) + aperCor + skyCorr	real	4		-0.9999995e9	??
			This is a correction based on the median dark sky recorded in science frames compared to the median for all the detectors and as such is an ancillary correction to the gain correction derived from the flatfield (usually twilight flats) data.
skyCorrExt	[nspid]MultiframeDetector	WSA NonSurvey	Percentage sky correction of the detector {image extension keyword: PERCORR} corrected photometry = 2.5×log10(flux) + aperCor + skyCorr	real	4		-0.9999995e9	??
			This is a correction based on the median dark sky recorded in science frames compared to the median for all the detectors and as such is an ancillary correction to the gain correction derived from the flatfield (usually twilight flats) data.
skyID	[nspid]Multiframe	WSA NonSurvey	UID of library calibration sky sub frame {image extension keyword: SKYSUB}	bigint	8		-99999999	ID_FRAME
skyLevel	[nspid]MultiframeDetector	WSA NonSurvey	Median sky brightness {catalogue extension keyword:  SKYLEVEL}	real	4	counts/pixel	-0.9999995e9	??
			An automatic 2D background-following algorithm is used to track and "remove" slowly varying background features such as image gradients etc.. The default scale size for background tracking (NBSIZE) is currently set to 64 pixels, coupled with a smidge of non-linear filtering this gives a background tracking scale of order 100 pixels. (A bilinear interpolator is used to generate pixel resolution background maps internally).
skyNoise	[nspid]MultiframeDetector	WSA NonSurvey	Pixel noise at sky level {catalogue extension keyword:  SKYNOISE}	real	4	counts	-0.9999995e9	??
			Robust MAD estimator for noise scaled to equivalent Gaussian rms value ie. = MAD × 1.48 after removing large scale sky background variations. MAD = Median of the Absolute Deviations about the median.
skySubScale	[nspid]MultiframeDetector	WSA NonSurvey	Scale factor applied to sky subtraction image {image extension keyword: SKYSUB}	float	8		-0.9999995e9	??
skyVar	[nspid]Detection	WSA NonSurvey	local estimate of variation in sky level around image {catalogue TType keyword: Sky_rms}	real	4	ADU		INST_SKY_LEVEL
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u05a37Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u05b15Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u05b7Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u05bd1Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u05bj4Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u06a24Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u06a48Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u06ah43Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u06b13Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u06b24Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u06b36Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u07b29Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u07b36Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u07bd3Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u07bd4Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in u07bh49Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1625Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1636Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1650Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1652Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1672Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1673Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1674Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1678Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1706Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1707Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1708Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1711Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1731Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1741Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1743Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceNeighbours	WSA NonSurvey	The unique ID of the neighbour in userv1761Source (=sourceID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceXDetection	WSA NonSurvey	The unique ID of the neighbour in userv1707Detection (=objID)	bigint	8			ID_CATALOG
slaveObjID	[nspid]SourceXtwomass_psc	WSA NonSurvey	The unique ID of the neighbour in TWOMASS..twomass_psc (=pts_key)	bigint	8			ID_CATALOG
smoothing	[nspid]MultiframeDetector	WSA NonSurvey	FWHM of the smoothing kernel {catalogue extension keyword:  FILTFWHM}	real	4	pixels	-0.9999995e9
sourceID	[nspid]Source, [nspid]SourceXDetectionBestMatch, [nspid]Variability	WSA NonSurvey	UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm	bigint	8			ID_MAIN
sourceIDName	[nspid]ExternalSurveyTable	WSA NonSurvey	The source unique identifier in the table	varchar	256			ID_TARGET
sourceIDName	[nspid]ProgrammeTable	WSA NonSurvey	the name of the source	varchar	256			ID_TARGET
sourceRemeasTable	[nspid]Programme	WSA NonSurvey	Table name of co-located list re-measurements	varchar	64			??
sourceTable	[nspid]Programme	WSA NonSurvey	Table name of merged sources	varchar	64			??
ssTemp	[nspid]Multiframe	WSA NonSurvey	CCC 2nd stage temperature {image primary HDU keyword: SS_TEMP}	real	4	degrees_Kelvin	-0.9999995e9
standard	[nspid]Multiframe	WSA NonSurvey	Is target a standard star observation (0=F, 1=T)? {image primary HDU keyword: STANDARD}	tinyint	1			OBS_ID
startCol	[nspid]MultiframeDetector	WSA NonSurvey	Start column of array readout {image extension keyword: RDOUT_X1}	smallint	2			NUMBER
startDate	[nspid]AstrCalVers	WSA NonSurvey	MJD of the start time for this version of the calibration	float	8	Julian days		TIME_DATE
startDate	[nspid]PhotCalVers	WSA NonSurvey	Date time of start time for this version of the calibration (MM-DD-YYYY)	datetime	8	MM-DD-YYYY	12-31-9999	TIME_DATE
startRow	[nspid]MultiframeDetector	WSA NonSurvey	Start row of array readout {image extension keyword: RDOUT_Y1}	smallint	2			NUMBER
status	[nspid]ProgrammeCurationHistory	WSA NonSurvey	successful (1) or unsuccessful (0)	tinyint	1			CODE_MISC
stdCRms	[nspid]CurrentAstrometry, [nspid]PreviousAstrometry	WSA NonSurvey	RMS residual of fit to astrometric standards {image extension keyword: STDCRMS}	float	8		-0.9999995e9	FIT_RESIDUAL
survey	[nspid]Multiframe	WSA NonSurvey	Survey description {image primary HDU keyword: SURVEY}	varchar	64		NONE	??
surveyID	[nspid]ExternalSurvey, [nspid]ExternalSurveyTable, [nspid]Release, [nspid]RequiredNeighbours	WSA NonSurvey	the unique identifier for the survey	int	4			ID_SURVEY
surveyID	[nspid]RequiredListDrivenProduct	WSA NonSurvey	the unique ID of the external survey (if applicable)	int	4		-99999999	ID_SURVEY
surveyID	[nspid]Survey, [nspid]SurveyProgrammes	WSA NonSurvey	The unique identifier for the curated survey	int	4			ID_SURVEY
surveyName	[nspid]ExternalSurvey	WSA NonSurvey	The short name of the survey, eg. SDSS-EDR, SDSS-DR1, USNOB etc.	varchar	32			??
synopticBestMatchTable	[nspid]Programme	WSA NonSurvey	Table name of merged variable sources	varchar	64			??
synopticSourceTable	[nspid]Programme	WSA NonSurvey	Table name of merged variable sources	varchar	64			??