Home | Overview | Browser | Access | Login | Cookbook | nonSurvey 
** Announcement - Workshop: Science from UKIDSS II, 15-17 Dec 2008, London UK **
  WSA logo

Glossary of WSA NonSurvey attributes (UKIDSSDR2)

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

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified 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 FWVM {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
sequence [nspid]RequiredCurationTask WSA NonSurvey Indicates the order in which the tasks are to be executed smallint 2     ??
SerFit1DChi2 [nspid]Detection WSA NonSurvey Error in 1D fit {catalogue TType keyword: 1D_Sersic_fit_chi2}
[For numerical stability the Sersic fits will use the previously derived x-y coordinates]
real 4   -0.9999995e9 PHOT_PROFILE_PAR
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}
[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 1D Sersic fit nu {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
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 2D Sersic fit nu {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
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]Source WSA NonSurvey Uncertainty in Dec real 4 Degrees -0.9999995e9 ERROR
sigMuDec [nspid]Source WSA NonSurvey Error on proper motion in Dec direction real 4 mas/yr -0.9999995e9 ERROR
sigMuRa [nspid]Source WSA NonSurvey Error on proper motion in RA direction real 4 mas/yr -0.9999995e9 ERROR
sigRa [nspid]Source WSA NonSurvey Uncertainty in RA real 4 Degrees -0.9999995e9 ERROR
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
sourceID [nspid]Source 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
sourceObjID [nspid]Programme WSA NonSurvey The attribute name(s) of the UID for merged sources varchar 64     ??
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, [nspid]CurrentSpatialMap, [nspid]PreviousSpatialMap, [nspid]PreviousStdStarInfo 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
stkType [nspid]RequiredStack WSA NonSurvey Type of stack [Normal or Variable (stack of 5 best seeing)] varchar 8   'Normal'  
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     ??
swVersion [nspid]DifferenceImage WSA NonSurvey version number of the difference image software used to create the image real 4     ID_VERSION



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