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 UKIDSSDR1 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR1 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
scan twomass_psc 2MASS The nightly scan number in which the source was detected. smallint 2     NUMBER
scan twomass_scn 2MASS Scan number (unique within date). smallint 2     NUMBER
scan twomass_xsc 2MASS scan number (unique within date). smallint 2     NUMBER
scan_key twomass_psc 2MASS Unique identification number of the record in the Scan Information Table that corresponds to the survey scan in which this source was detected. int 4     ID_NUMBER
scan_key twomass_scn 2MASS the unique identification number for this scan. int 4     ID_NUMBER
scan_key twomass_xsc 2MASS key to scan data record in "scan DB". int 4     ID_NUMBER
scanlen Plate SSA SuperCOSMOS CCD lane scan length smallint 2 pixels   INST_PARAM
scanMaterial Plate SSA Photographic medium, eg. Original glass, Copy film, Copy glass varchar 16     REMARKS
scdGrid Plate SSA Non-linear distortion mask filename varchar 80     ID_FILE
sCorMagB Source SSA B band magnitude assuming object is star real 4 mag -99.999995 PHOT_PHG_BJ
sCorMagI Source SSA I band magnitude assuming object is star real 4 mag -99.999995 PHOT_PHG_I
sCorMagR1 Source SSA R1 band magnitude assuming object is star real 4 mag -99.999995 PHOT_PHG_R
sCorMagR2 Source SSA R2 band magnitude assuming object is star real 4 mag -99.999995 PHOT_PHG_R
scrunch RequiredMosaic WSA 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   ??
scrunch RequiredMosaic WSATransit 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 Multiframe WSA SCSU cab temperature {image primary HDU keyword: SC_TEMP} real 4 degrees_Kelvin -0.9999995e9  
scTemp Multiframe WSATransit SCSU cab temperature {image primary HDU keyword: SC_TEMP} real 4 degrees_Kelvin -0.9999995e9  
sd twomass_scn 2MASS Scanning direction: "n" = north-going, "s" = south-going. varchar 1     POS_POS-ANG
sdssPrimary lasSourceXDR2PhotoObj, lasSourceXDR3PhotoObj WSA SDSS flag for neighbour being primary (1) or secondary (0) tinyint 1     CODE_MISC
sdssType lasSourceXDR2PhotoObj, lasSourceXDR3PhotoObj WSA SDSS type of neighbour: 3=galaxy; 6=star tinyint 1     CLASS_OBJECT
sdsuNum MultiframeDetector WSA Serial number of SDSU controller {image extension keyword: SDSUID} varchar 32   NONE ??
sdsuNum MultiframeDetector WSATransit Serial number of SDSU controller {image extension keyword: SDSUID} varchar 32   NONE ??
seam Detection SSA Seam index: = zero or SSAfield for seamless selection smallint 2     ID_FIELD
secondaryTemp Multiframe WSA Temperature of secondary {image primary HDU keyword: SECONDAR} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
secondaryTemp Multiframe WSATransit Temperature of secondary {image primary HDU keyword: SECONDAR} real 4 degrees_Celsius -0.9999995e9 PHYS_TEMP_MISC
seeing MultiframeDetector WSA 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).
seeing MultiframeDetector WSATransit 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).
seqNo firstSource FIRST sequential object number int 4     ID_NUMBER
seqNo glimpse_hrc_inter GLIMPSE sequential object number in the HRC int 4     ID_NUMBER
seqNo glimpse_mca_inter GLIMPSE sequential object number in the MCA int 4     ID_NUMBER
seqNo iras_psc IRAS sequential object number int 4     ID_NUMBER
seqNo rosat_bsc ROSAT sequential object number in the BSC int 4     ID_NUMBER
seqNo rosat_fsc ROSAT sequential object number in the FSC int 4     ID_NUMBER
seqNum dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsDetection, udsListRemeasurement WSA 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 ptsDetection WSATransit 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 RequiredCurationTask WSA Indicates the order in which the tasks are to be executed smallint 2     ??
sequence RequiredCurationTask WSATransit Indicates the order in which the tasks are to be executed smallint 2     ??
SerFit1DChi2 dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerFit1DChi2 ptsDetection WSATransit 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
SerFit1DChi2 udsDetection WSA Not available in SE output {catalogue TType keyword: 1D_Sersic_fit_chi2} real 4   -0.9999995e9  
SerFit2DChi2 dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerFit2DChi2 ptsDetection WSATransit 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
SerFit2DChi2 udsDetection WSA Not available in SE output {catalogue TType keyword: 2D_Sersic_fit_chi2} real 4   -0.9999995e9  
SerFitNu1D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerFitNu1D ptsDetection WSATransit 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
SerFitNu1D udsDetection WSA Not available in SE output {catalogue TType keyword: 1D_Sersic_fit_nu} real 4   -0.9999995e9  
SerFitNu2D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerFitNu2D ptsDetection WSATransit 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
SerFitNu2D udsDetection WSA Not available in SE output {catalogue TType keyword: 2D_Sersic_fit_nu} real 4   -0.9999995e9  
SerFlux1D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerFlux1D ptsDetection WSATransit 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
SerFlux1D udsDetection WSA Not available in SE output {catalogue TType keyword: 1D_Sersic_flux} real 4   -0.9999995e9  
SerFlux2D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerFlux2D ptsDetection WSATransit 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
SerFlux2D udsDetection WSA Not available in SE output {catalogue TType keyword: 2D_Sersic_flux} real 4   -0.9999995e9  
SerIdx1D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerIdx1D ptsDetection WSATransit 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
SerIdx1D udsDetection WSA Not available in SE output {catalogue TType keyword: 1D_Sersic_index} real 4   -0.9999995e9  
SerIdx2D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerIdx2D ptsDetection WSATransit 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
SerIdx2D udsDetection WSA Not available in SE output {catalogue TType keyword: 2D_Sersic_index} real 4   -0.9999995e9  
SerMag1D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerMag1D ptsDetection WSATransit 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
SerMag1D udsDetection WSA Not available in SE output real 4   -0.9999995e9  
SerMag2D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerMag2D ptsDetection WSATransit 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
SerMag2D udsDetection WSA Not available in SE output real 4   -0.9999995e9  
SerScaleLen1D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerScaleLen1D ptsDetection WSATransit 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
SerScaleLen1D udsDetection WSA Not available in SE output {catalogue TType keyword: 1D_Sersic_scale_len} real 4   -0.9999995e9  
SerScaleLen2D dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 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
SerScaleLen2D ptsDetection WSATransit 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
SerScaleLen2D udsDetection WSA Not available in SE output {catalogue TType keyword: 2D_Sersic_scale_len} real 4   -0.9999995e9  
server ExternalSurvey WSA The location of the database: load or public server varchar 16     ??
server ExternalSurvey WSATransit The location of the database: load or public server varchar 16     ??
ses1_100 iras_psc IRAS Number of seconds-confirmed nearby small extended sources (100 micron). tinyint 1     INST_PARAM
ses1_12 iras_psc IRAS Number of seconds-confirmed nearby small extended sources (12 micron). tinyint 1     INST_PARAM
ses1_25 iras_psc IRAS Number of seconds-confirmed nearby small extended sources (25 micron). tinyint 1     INST_PARAM
ses1_60 iras_psc IRAS Number of seconds-confirmed nearby small extended sources (60 micron). tinyint 1     INST_PARAM
ses2_100 iras_psc IRAS Number of nearby weeks-confirmed small extended sources (100 micron). tinyint 1     CODE_MISC
ses2_12 iras_psc IRAS Number of nearby weeks-confirmed small extended sources (12 micron). tinyint 1     CODE_MISC
ses2_25 iras_psc IRAS Number of nearby weeks-confirmed small extended sources (25 micron). tinyint 1     CODE_MISC
ses2_60 iras_psc IRAS Number of nearby weeks-confirmed small extended sources (60 micron). tinyint 1     CODE_MISC
shiftPnt Plate SSA Shift of from nominal to fitted plate centre float 8 radians   POS_OFFSET
shortName Filter WSA Short identification name for the filter varchar 4     ??
shortName Filter WSATransit Short identification name for the filter varchar 4     ??
sigDec Source SSA Uncertainty in Dec (formal random error not inc. systematic errors) float 8 degrees   ERROR
sigDec dxsSourceRemeasurement, gcsSource, gcsSourceRemeasurement, gpsSource, gpsSourceRemeasurement, lasSource, lasSourceRemeasurement, udsSourceRemeasurement WSA Uncertainty in Dec real 4 Degrees -0.9999995e9 ERROR
sigMuAcosD Source SSA Error on proper motion in RA direction real 4 mas/yr -0.99999995e9 ERROR
sigMuD Source SSA Error on proper motion in Dec direction real 4 mas/yr -0.99999995e9 ERROR
sigMuDec gcsSource, gpsSource, lasSource WSA Error on proper motion in Dec direction real 4 mas/yr -0.9999995e9 ERROR
sigMuRa gcsSource, gpsSource, lasSource WSA Error on proper motion in RA direction real 4 mas/yr -0.9999995e9 ERROR
sigRA Source SSA Uncertainty in RA (formal random error not inc. systematic errors) float 8 degrees   ERROR
sigRa dxsSourceRemeasurement, gcsSource, gcsSourceRemeasurement, gpsSource, gpsSourceRemeasurement, lasSource, lasSourceRemeasurement, udsSourceRemeasurement WSA Uncertainty in RA real 4 Degrees -0.9999995e9 ERROR
sky dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA local interpolated sky level from background tracker {catalogue TType keyword: Sky_level} real 4 ADU   INST_SKY_LEVEL
sky ptsDetection WSATransit local interpolated sky level from background tracker {catalogue TType keyword: Sky_level} real 4 ADU   INST_SKY_LEVEL
sky udsDetection WSA local interpolated sky level from background tracker (SE: BACKGROUND) {catalogue TType keyword: Sky_level} real 4 ADU   INST_SKY_LEVEL
sky1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Local sky bkg. for band 1 flux real 4 MJy/sr -999.9  
sky2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Local sky bkg. for band 2 flux real 4 MJy/sr -999.9  
sky3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Local sky bkg. for band 3 flux real 4 MJy/sr -999.9  
sky4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Local sky bkg. for band 4 flux real 4 MJy/sr -999.9  
skyCorrCat MultiframeDetector WSA 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.
skyCorrCat MultiframeDetector WSATransit 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 MultiframeDetector WSA 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.
skyCorrExt MultiframeDetector WSATransit 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.
skyDefn Plate SSA Method of defining sky, eg. "median" varchar 16     REDUCT_METHOD
skyFilter Plate SSA Box filter weights for sky determination varchar 16     REDUCT_PARAM
skyID Multiframe WSA UID of library calibration sky sub frame {image extension keyword: SKYSUB} bigint 8   -99999999 ID_FRAME
skyID Multiframe WSATransit UID of library calibration sky sub frame {image extension keyword: SKYSUB} bigint 8   -99999999 ID_FRAME
skyLevel MultiframeDetector WSA 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).
skyLevel MultiframeDetector WSATransit 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 MultiframeDetector WSA 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.
skyNoise MultiframeDetector WSATransit 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.
skySquare Plate SSA Blocksize (one side) of sky background smallint 2 pixels   REDUCT_PARAM
skySubScale MultiframeDetector WSA Scale factor applied to sky subtraction image {image extension keyword: SKYSUB} float 8   -0.9999995e9 ??
skySubScale MultiframeDetector WSATransit Scale factor applied to sky subtraction image {image extension keyword: SKYSUB} float 8   -0.9999995e9 ??
skyVar dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA local estimate of variation in sky level around image {catalogue TType keyword: Sky_rms} real 4 ADU   INST_SKY_LEVEL
skyVar ptsDetection WSATransit local estimate of variation in sky level around image {catalogue TType keyword: Sky_rms} real 4 ADU   INST_SKY_LEVEL
skyVar udsDetection WSA local estimate of variation in sky level around image (SE: THRESHOLD) {catalogue TType keyword: Sky_rms} real 4 ADU   INST_SKY_LEVEL
slaveObjID dxsSourceNeighbours WSA The unique ID of the neighbour in dxsSource (=sourceID) bigint 8     ID_CATALOG
slaveObjID dxsSourceXtwomass_psc, gcsSourceXtwomass_psc, gpsSourceXtwomass_psc, lasSourceXtwomass_psc, udsSourceXtwomass_psc WSA The unique ID of the neighbour in TWOMASS..twomass_psc (=pts_key) bigint 8     ID_CATALOG
slaveObjID gcsSourceNeighbours WSA The unique ID of the neighbour in gcsSource (=sourceID) bigint 8     ID_CATALOG
slaveObjID gpsSourceNeighbours WSA The unique ID of the neighbour in gpsSource (=sourceID) bigint 8     ID_CATALOG
slaveObjID gpsSourceXglimpse_hrc_inter WSA The unique ID of the neighbour in GLIMPSE..glimpse_hrc_inter (=seqNo) bigint 8     ID_CATALOG
slaveObjID gpsSourceXglimpse_mca_inter WSA The unique ID of the neighbour in GLIMPSE..glimpse_mca_inter (=seqNo) bigint 8     ID_CATALOG
slaveObjID lasSourceNeighbours WSA The unique ID of the neighbour in lasSource (=sourceID) bigint 8     ID_CATALOG
slaveObjID lasSourceXDR2PhotoObj WSA The unique ID of the neighbour in BestDR2..PhotoObj (=objID) bigint 8     ID_CATALOG
slaveObjID lasSourceXDR3PhotoObj WSA The unique ID of the neighbour in BestDR3..PhotoObj (=objID) bigint 8     ID_CATALOG
slaveObjID lasSourceXSSASource WSA The unique ID of the neighbour in SSA..Source (=objID) bigint 8     ID_CATALOG
slaveObjID lasSourceXfirstSource WSA The unique ID of the neighbour in FIRST..firstSource (=seqNo) bigint 8     ID_CATALOG
slaveObjID lasSourceXiras_psc WSA The unique ID of the neighbour in IRAS..iras_psc (=seqNo) bigint 8     ID_CATALOG
slaveObjID lasSourceXrosat_bsc WSA The unique ID of the neighbour in ROSAT..rosat_bsc (=seqNo) bigint 8     ID_CATALOG
slaveObjID lasSourceXrosat_fsc WSA The unique ID of the neighbour in ROSAT..rosat_fsc (=seqNo) bigint 8     ID_CATALOG
slaveObjID lasSourceXtwomass_xsc WSA The unique ID of the neighbour in TWOMASS..twomass_xsc (=ext_key) bigint 8     ID_CATALOG
slaveObjID ptsDetectionNeighbours WSATransit The unique ID of the neighbour in ptsDetection (=objID) bigint 8     ID_CATALOG
slaveObjID ptsDetectionXtwomass_psc WSATransit The unique ID of the neighbour in TWOMASS..twomass_psc (=pts_key) bigint 8     ID_CATALOG
slaveObjID udsSourceNeighbours WSA The unique ID of the neighbour in udsSource (=sourceID) bigint 8     ID_CATALOG
sMag Detection SSA Magnitude calculated on assumption object is star real 4 mag   MODEL_MAG_VALUE
SN1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Signal/Noise for band 1 flux real 4   -9.99  
SN2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Signal/Noise for band 2 flux real 4   -9.99  
SN3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Signal/Noise for band 3 flux real 4   -9.99  
SN4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Signal/Noise for band 4 flux real 4   -9.99  
softVersion Plate SSA Software version, eg. /home/scosdev/v033 varchar 18     ID_VERSION
sosp Plate SSA SuperCOSMOS start of scan CCD pixel number smallint 2     INST_PARAM
sourceID Detection SSA objID for corresponding merged record in Source bigint 8     ID_ASSOCIATED
sourceID dxsSource, gcsSource, gpsSource, lasSource, udsSource WSA UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm bigint 8     ID_MAIN
sourceID dxsSourceRemeasurement, gcsSourceRemeasurement, gpsSourceRemeasurement, lasSourceRemeasurement, udsSourceRemeasurement WSA UID (unique over entire WSA via programme ID prefix) of this list remeasurement bigint 8     ID_MAIN
sourceID iras_asc IRAS Source ID varchar 15     ID_ALTERNATIVE
sourceIDName ExternalSurveyTable WSA The source unique identifier in the table varchar 256     ID_TARGET
sourceIDName ExternalSurveyTable WSATransit The source unique identifier in the table varchar 256     ID_TARGET
sourceIDName ProgrammeTable WSA the name of the source varchar 256     ID_TARGET
sourceIDName ProgrammeTable WSATransit the name of the source varchar 256     ID_TARGET
sourceObjID Programme WSA The attribute name(s) of the UID for merged sources varchar 64     ??
sourceObjID Programme WSATransit The attribute name(s) of the UID for merged sources varchar 64     ??
sourceRemeasTable Programme WSA Table name of co-located list re-measurements varchar 64     ??
sourceRemeasTable Programme WSATransit Table name of co-located list re-measurements varchar 64     ??
sourceRowSize Programme WSA The size of the rows in the merged source table smallint 2 bytes   ??
sourceRowSize Programme WSATransit The size of the rows in the merged source table smallint 2 bytes   ??
sourceTable Programme WSA Table name of merged sources varchar 64     ??
sourceTable Programme WSATransit Table name of merged sources varchar 64     ??
SQL1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Source Quality Flag for band 1 flux int 4   -9  
SQL2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Source Quality Flag for band 2 flux int 4   -9  
SQL3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Source Quality Flag for band 3 flux int 4   -9  
SQL4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Source Quality Flag for band 4 flux int 4   -9  
srcCps rosat_bsc, rosat_fsc ROSAT source countrate in the broad energy band, vignetting corrected real 4 counts/sec   PHOT_COUNT-RATE_X
srcdens1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Local source density for band 1 real 4 #/sqamin -9.9  
srcdens2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Local source density for band 2 real 4 #/sqamin -9.9  
srcdens3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Local source density for band 3 real 4 #/sqamin -9.9  
srcdens4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Local source density for band 4 real 4 #/sqamin -9.9  
srcID rosat_bsc, rosat_fsc ROSAT SASS source number (MASOL number) in SASS field varchar 4     ID_NUMBER
srcl rosat_bsc, rosat_fsc ROSAT likelihood of source detection smallint 2     STAT_LIKELIHOOD
srcName glimpse_hrc_inter GLIMPSE GLIMPSE Highly Reliable Catalogue source name varchar 32     ID_MAIN
srcName glimpse_mca_inter GLIMPSE GLIMPSE More Complete Archive source name varchar 32     ID_MAIN
srcName rosat_bsc, rosat_fsc ROSAT ROSAT All-Sky Survey Catalogue source name varchar 16     ID_MAIN
SSAfield Detection SSA SSS field number (ESO/SRC system) that this detection falls in. smallint 2     ID_FIELD
ssTemp Multiframe WSA CCC 2nd stage temperature {image primary HDU keyword: SS_TEMP} real 4 degrees_Kelvin -0.9999995e9  
ssTemp Multiframe WSATransit CCC 2nd stage temperature {image primary HDU keyword: SS_TEMP} real 4 degrees_Kelvin -0.9999995e9  
stackID StackImage WSA the unique ID number identifying all stored stack images bigint 8     ID_FRAME
stackID StackImage WSATransit the unique ID number identifying all stored stack images bigint 8     ID_FRAME
standard Multiframe WSA Is target a standard star observation (0=F, 1=T)? {image primary HDU keyword: STANDARD} tinyint 1     OBS_ID
standard Multiframe WSATransit Is target a standard star observation (0=F, 1=T)? {image primary HDU keyword: STANDARD} tinyint 1     OBS_ID
starCat Plate SSA Name of reference star catalogue used for astrometric fit varchar 80     ID_CATALOG
starsInit Plate SSA No. of refstars in initial astrometric solution int 4     NUMBER
starsSelec Plate SSA No. of refstars initially selected int 4     NUMBER
starsUsed Plate SSA No. of refstars in final astrometric solution int 4     NUMBER
startCol MultiframeDetector WSA Start column of array readout {image extension keyword: RDOUT_X1} smallint 2     NUMBER
startCol MultiframeDetector WSATransit Start column of array readout {image extension keyword: RDOUT_X1} smallint 2     NUMBER
startDate AstrCalVers, CurrentSpatialMap, PhotCalVers, PreviousSpatialMap, PreviousStdStarInfo WSA MJD of the start time for this version of the calibration float 8 Julian days   TIME_DATE
startDate AstrCalVers, PhotCalVers WSATransit MJD of the start time for this version of the calibration float 8 Julian days   TIME_DATE
startRow MultiframeDetector WSA Start row of array readout {image extension keyword: RDOUT_Y1} smallint 2     NUMBER
startRow MultiframeDetector WSATransit Start row of array readout {image extension keyword: RDOUT_Y1} smallint 2     NUMBER
status ProgrammeCurationHistory WSA successful (1) or unsuccessful (0) tinyint 1     CODE_MISC
status ProgrammeCurationHistory WSATransit successful (1) or unsuccessful (0) tinyint 1     CODE_MISC
stdCRms CurrentAstrometry WSATransit RMS residual of fit to astrometric standards {image extension keyword: STDCRMS} float 8   -0.9999995e9 FIT_RESIDUAL
stdCRms CurrentAstrometry, PreviousAstrometry WSA RMS residual of fit to astrometric standards {image extension keyword: STDCRMS} float 8   -0.9999995e9 FIT_RESIDUAL
stepsize Plate SSA SuperCOSMOS nominal pixel size real 4 microns   INST_PIXSIZE
stepWdg Plate SSA Intensity calibration step-wedge type, eg. kpno varchar 16     INST_PARAM
sup_ba twomass_xsc 2MASS Minor/major axis ratio fit to 3-sig. super-coadd isophote. real 4     PHYS_AXIS-RATIO
sup_chif_ellf twomass_xsc 2MASS super-coadd % chi-fraction for ellip. fit to 3-sig isophote. real 4     FIT_PARAM_VALUE
sup_dec twomass_xsc 2MASS Super-coadd centroid Dec (J2000 decimal deg). float 8 degrees   POS_EQ_DEC_MAIN
sup_phi twomass_xsc 2MASS Super-coadd angle to major axis (E of N). smallint 2 degrees   POS_POS-ANG
sup_r_3sig twomass_xsc 2MASS Super-coadd 3-sigma isophotal semi-major axis radius. real 4 arcsec   ERROR
sup_ra twomass_xsc 2MASS Super-coadd centroid RA (J2000 decimal deg). float 8 degrees   POS_EQ_RA_MAIN
survey Multiframe WSA Survey description {image primary HDU keyword: SURVEY} varchar 64   NONE ??
survey Multiframe WSATransit Survey description {image primary HDU keyword: SURVEY} varchar 64   NONE ??
surveyID Detection SSA The survey that collected the data tinyint 1     ID_SURVEY
surveyID ExternalSurvey WSATransit the unique identifier for the survey int 4     ID_SURVEY
surveyID ExternalSurvey, ExternalSurveyTable, Release, RequiredNeighbours WSA the unique identifier for the survey int 4     ID_SURVEY
surveyID Plate SSA Every plate comes from a survey tinyint 1     ID_SURVEY
surveyID RequiredListDrivenProduct WSA the unique ID of the external survey (if applicable) int 4   -99999999 ID_SURVEY
surveyID RequiredListDrivenProduct WSATransit the unique ID of the external survey (if applicable) int 4   -99999999 ID_SURVEY
surveyID Survey SSA Unique survey identifier in the SSA tinyint 1     ID_SURVEY
surveyID Survey WSATransit The unique identifier for the curated survey int 4     ID_SURVEY
surveyID Survey, SurveyProgrammes WSA The unique identifier for the curated survey int 4     ID_SURVEY
surveyName ExternalSurvey WSA The short name of the survey, eg. SDSS-EDR, SDSS-DR1, USNOB etc. varchar 32     ??
surveyName ExternalSurvey WSATransit The short name of the survey, eg. SDSS-EDR, SDSS-DR1, USNOB etc. varchar 32     ??
surveyName Survey SSA Survey name, eg. SERC-J/EJ varchar 16     ID_CATALOG
surveyRef Survey SSA Literature reference for survey varchar 256     REFER_CODE
swVersion DifferenceImage WSATransit version number of the difference image software used to create the image real 4     ID_VERSION
swVersion DifferenceImage, MosaicImage, StackImage WSA version number of the difference image software used to create the image real 4     ID_VERSION
sys_flg twomass_xsc 2MASS system flag: 0=no system, 1=nearby galaxy flux incl. in mag. smallint 2     CODE_MISC
systemID Field SSA Unique identifier of the system of survey field centres tinyint 1     ID_MAIN
systemID FieldSystem SSA The system of survey fields used for the survey tinyint 1     ID_MAIN
systemID Survey SSA The system of survey fields used for the survey tinyint 1     NOTE



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