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

Glossary of WSA attributes

This Glossary alphabetically lists all attributes used in the UKIDSSDR5 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR5 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

N

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
N1 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Possible number of detections for band 1 int 4   -9  
N2 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Possible number of detections for band 2 int 4   -9  
N3 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Possible number of detections for band 3 int 4   -9  
N3_6 glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE Number of possible detections for 3.6um IRAC (Band 1) int 4   -9  
N4 glimpse_hrc_inter, glimpse_mca_inter GLIMPSE Possible number of detections for band 4 int 4   -9  
N4_5 glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE Number of possible detections for 4.5um IRAC (Band 2) int 4   -9  
N5_8 glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE Number of possible detections for 5.8um IRAC (Band 3) int 4   -9  
N8_0 glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca GLIMPSE Number of possible detections for 8.0um IRAC (Band 4) int 4   -9  
n_blank twomass_xsc 2MASS number of blanked source records. smallint 2     NUMBER
N_DETECTIONS twoxmm XMM The number of detections of the unique source SRCID used to derive the averaged values. int 4      
n_ext twomass_scn 2MASS Number of regular extended sources detected in scan. int 4     NUMBER
N_SPEC mgcBrightSpec MGC Total number of spectra for this object smallint 2      
n_sub twomass_xsc 2MASS number of subtracted source records. smallint 2     NUMBER
name FieldSystem SSA The name of the system, eg. "ESO/SRC", "POSS-I" etc. varchar 32     NOTE
name Filter WSA The name of the filter, eg. "MKO J", "WFCAM Y" etc. varchar 16     NOTE
name Filter WSATransit The name of the filter, eg. "MKO J", "WFCAM Y" etc. varchar 16     NOTE
name RequiredMosaic WSA Name of the mosaiced product varchar 64     ??
name RequiredMosaic WSATransit Name of the mosaiced product varchar 64     ??
name RequiredStack WSA Name of the stacked product varchar 64     ??
name RequiredStack WSATransit Name of the stacked product varchar 64     ??
name Survey WSA The short name for the survey varchar 128     ??
name Survey WSATransit The short name for the survey varchar 128     ??
name iras_asc, iras_psc IRAS Source Name varchar 11     ID_MAIN
name ukirtFSstars WSA reference name of field varchar 16   NONE ????
nBlockSize RequiredMosaic WSATransit CASU/SEX source extraction tool option to override the default background blockdown size (=64, the recommended value) smallint 2 pixels -9999 ??
nBlockSize RequiredMosaic, RequiredStack WSA CASU/SEX source extraction tool option to override the default background blockdown size (=64, the recommended value) smallint 2 pixels -9999 ??
nCalCoeffs Plate SSA No. of photometric calibration coefficients tinyint 1     FIT_PARAM_VALUE
ndet twomass_psc 2MASS Frame detection statistics. varchar 6     NUMBER
NED_CLASS mgcBrightSpec MGC MGC translation of NED_IDENT smallint 2      
NED_DEC mgcBrightSpec MGC NED object declination in deg (J2000) float 8      
NED_IDENT mgcBrightSpec MGC NED identification varchar 4      
NED_N mgcBrightSpec MGC Number of NED objects matched to this MGC object smallint 2      
NED_NAME mgcBrightSpec MGC NED object name varchar 32      
NED_RA mgcBrightSpec MGC NED object right ascension in deg (J2000) float 8      
NED_ZHELIO mgcBrightSpec MGC NED heliocentric redshift real 4      
NED_ZQUAL mgcBrightSpec MGC NED redshift quality tinyint 1      
neighboursSchema Programme WSA Script file that describes the neighbour tables schema for this programme varchar 64     ??
neighboursSchema Programme WSATransit Script file that describes the neighbour tables schema for this programme varchar 64     ??
neighbourTable RequiredNeighbours WSA the name of the neighbour join table varchar 256     ID_TABLE
neighbourTable RequiredNeighbours WSATransit the name of the neighbour join table varchar 256     ID_TABLE
newFrameSet dxsJKmergeLog, dxsMergeLog, gcsMergeLog, gcsZYJHKmergeLog, gpsJHKmergeLog, gpsMergeLog, lasMergeLog, lasYJHKmergeLog, udsMergeLog WSA Flag used internally by curation applications tinyint 1     CODE_MISC
newH2frame gpsJHKmergeLog, gpsMergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newHframe dxsJKmergeLog, dxsMergeLog, gcsMergeLog, gcsZYJHKmergeLog, gpsJHKmergeLog, gpsMergeLog, lasMergeLog, lasYJHKmergeLog, udsMergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newJ_1frame lasMergeLog, lasYJHKmergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newJ_2frame lasMergeLog, lasYJHKmergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newJframe dxsJKmergeLog, dxsMergeLog, gcsMergeLog, gcsZYJHKmergeLog, gpsJHKmergeLog, gpsMergeLog, udsMergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newK_1frame gcsMergeLog, gcsZYJHKmergeLog, gpsJHKmergeLog, gpsMergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newK_2frame gcsMergeLog, gcsZYJHKmergeLog, gpsJHKmergeLog, gpsMergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newKframe dxsJKmergeLog, dxsMergeLog, lasMergeLog, lasYJHKmergeLog, udsMergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newlyIngested Multiframe WSA Curation flag for internal use only (0=no, 1=yes) tinyint 1   1 ??
newlyIngested Multiframe WSATransit Curation flag for internal use only (0=no, 1=yes) tinyint 1   1 ??
newYframe gcsMergeLog, gcsZYJHKmergeLog, lasMergeLog, lasYJHKmergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
newZframe gcsMergeLog, gcsZYJHKmergeLog WSA new/old flag (1/0) of this detector image tinyint 1     CODE_MISC
nFlag rosat_bsc, rosat_fsc ROSAT nearby sources affecting SASS flux determination varchar 1     CODE_MISC
nFoc Multiframe WSA Number of positions in focus scan {image primary HDU keyword: NFOC} smallint 2   -9999 NUMBER
nFoc Multiframe WSATransit Number of positions in focus scan {image primary HDU keyword: NFOC} smallint 2   -9999 NUMBER
nFocScan Multiframe WSA Number of focus scans in focus test {image primary HDU keyword: NFOCSCAN} smallint 2   -9999 NUMBER
nFocScan Multiframe WSATransit Number of focus scans in focus test {image primary HDU keyword: NFOCSCAN} smallint 2   -9999 NUMBER
nFrames dxsVariability, udsVariability WSA Number of frames with good detections used to calculate astrometric fits int 4   0 NUMBER
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.
nFrames gcsPointSource, gcsSource, gcsZYJHKsource, gpsJHKsource, gpsPointSource, gpsSource, lasExtendedSource, lasPointSource, lasSource, lasYJHKsource, reliableGcsPointSource, reliableGpsPointSource, reliableLasPointSource WSA No. of frames used for this proper motion measurement tinyint 1   0 NUMBER
nhcon iras_psc IRAS Number of times observed (<25) tinyint 1     NUMBER
nId iras_psc IRAS Number of positional associations (<25). tinyint 1     NUMBER
night_key twomass_xsc 2MASS key to night data record in "scan DB". smallint 2     ID_NUMBER
nightZPCat MultiframeDetector WSA Average photometric zero point for night {catalogue extension keyword:  NIGHTZPT} real 4 mags -0.9999995e9 ??
nightZPCat MultiframeDetector WSATransit Average photometric zero point for night {catalogue extension keyword:  NIGHTZPT} real 4 mags -0.9999995e9 ??
nightZPCat PreviousMFDZP WSA Average photometric zero point for night real 4 mags -0.9999995e9 ??
nightZPErrCat MultiframeDetector WSA Photometric zero point sigma for night {catalogue extension keyword:  NIGHTZRR}
<0.05 mags for a good night
real 4 mags -0.9999995e9 ??
nightZPErrCat MultiframeDetector WSATransit Photometric zero point sigma for night {catalogue extension keyword:  NIGHTZRR}
<0.05 mags for a good night
real 4 mags -0.9999995e9 ??
nightZPErrCat PreviousMFDZP WSA Photometric zero point sigma for night
<0.05 mags for a good night
real 4 mags -0.9999995e9 ??
nightZPNum MultiframeDetector WSA Number of ZP in band used to calculate nightZPCat {catalogue extension keyword:  NIGHTNUM} int 4 mags -99999999 ??
nightZPNum MultiframeDetector WSATransit Number of ZP in band used to calculate nightZPCat {catalogue extension keyword:  NIGHTNUM} int 4 mags -99999999 ??
nightZPNum PreviousMFDZP WSA Number of ZP in band used to calculate nightZPCat int 4 mags -99999999 ??
njitter Multiframe WSA Number of positions in telescope pattern {image primary HDU keyword: NJITTER} smallint 2   -9999 NUMBER
njitter Multiframe WSATransit Number of positions in telescope pattern {image primary HDU keyword: NJITTER} smallint 2   -9999 NUMBER
nLrs iras_psc IRAS Number of significant LRS spectra tinyint 1     NUMBER
nominalDec Field SSA Nominal field centre Dec float 8 degrees   POS_EQ_DEC_MAIN
nominalRA Field SSA Nominal field centre RA float 8 degrees   POS_EQ_RA_MAIN
nopt_mchs twomass_psc 2MASS The number of USNO-A2.0 or Tycho 2 optical sources found within a 5" radius of the TWOMASS position. smallint 2     NUMBER
nParents Plate SSA No. of parent objects detected on plate int 4     NUMBER
nPass RequiredFilters WSA the number of passes that will be made smallint 2     NUMBER
nPass RequiredFilters WSATransit the number of passes that will be made smallint 2     NUMBER
nPixels RequiredMosaic WSATransit CASU/SEX source extraction tool option for minimum number of connected pixels in a detected source (recommended value=4) smallint 2   -9999 ??
nPixels RequiredMosaic, RequiredStack WSA CASU/SEX source extraction tool option for minimum number of connected pixels in a detected source (recommended value=4) smallint 2   -9999 ??
Nplates CompleteStars, ReliableGalaxies, ReliableStars, Source SSA No. of plates used for this proper motion measurement tinyint 1     NUMBER
nSteps Plate SSA No. of intensity calibration wedge steps tinyint 1     INST_PARAM
numAxes MultiframeDetector WSA Number of data axes; eg. 2 tinyint 1     NUMBER
numAxes MultiframeDetector WSATransit Number of data axes; eg. 2 tinyint 1     NUMBER
numberStk RequiredStack WSA Number of intermediate stacks. If default, stack all good quality stacks int 4   -99999999  
numberStk RequiredStack WSATransit Number of intermediate stacks. If default, stack all good quality stacks int 4   -99999999  
numDetectors Multiframe WSA The number of "detectors" (=image extensions in FITS file) tinyint 1     ??
numDetectors Multiframe WSATransit The number of "detectors" (=image extensions in FITS file) tinyint 1     ??
numExp Multiframe WSA Number of exposures in integration {image primary HDU keyword: NEXP} smallint 2   -9999 NUMBER
numExp Multiframe WSATransit Number of exposures in integration {image primary HDU keyword: NEXP} smallint 2   -9999 NUMBER
numFields Survey SSA No. of fields in the survey int 4     NUMBER
numInts Multiframe WSA Number of integrations in observation {image primary HDU keyword: NINT} smallint 2     NUMBER
numInts Multiframe WSATransit Number of integrations in observation {image primary HDU keyword: NINT} smallint 2     NUMBER
numReads Multiframe WSA Number of reads per exposure {image primary HDU keyword: NREADS} smallint 2   -9999 NUMBER
numReads Multiframe WSATransit Number of reads per exposure {image primary HDU keyword: NREADS} smallint 2   -9999 NUMBER
numRms CurrentAstrometry WSATransit No. of astrometric standards used in fit {image extension keyword: NUMBRMS} int 4   -99999999 FIT_PARAM_VALUE
numRms CurrentAstrometry, PreviousAstrometry WSA No. of astrometric standards used in fit {image extension keyword: NUMBRMS} int 4   -99999999 FIT_PARAM_VALUE
numZPCat MultiframeDetector WSA Number of standards used in determining photZPCat and photZPCatErr {catalogue extension keyword:  NUMZPT} int 4   -99999999  
numZPCat MultiframeDetector WSATransit Number of standards used in determining photZPCat and photZPCatErr {catalogue extension keyword:  NUMZPT} int 4   -99999999  
numZPCat PreviousMFDZP WSA Number of standards used in determining photZP and photZPErr int 4   -99999999  
nuStep Multiframe WSA Number of positions in microstep pattern {image primary HDU keyword: NUSTEP} smallint 2   -9999 NUMBER
nuStep Multiframe WSATransit Number of positions in microstep pattern {image primary HDU keyword: NUSTEP} smallint 2   -9999 NUMBER
NVSS nvssSource NVSS Source name varchar 14     ID_MAIN



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
30/04/2009