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

Glossary of WSA attributes

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

I

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
IAUNAME twoxmm, twoxmm_v1_2 XMM The IAU name assigned to the unique SRCID. varchar 21      
IAUNAME twoxmmi_dr3_v1_0 XMM The IAU name assigned to the unique SRCID. varchar 30      
IAUNAME xmm3dr4 XMM The IAU name assigned to the unique SRCID. varchar 50      
ic hipparcos_new_reduction GAIADR1 Entry in one of the supplementary catalogues int 4     meta.id.cross
icrf2_match aux_qso_icrf2_match GAIADR1 ICRF2 designation of the source matched to this Gaia source varchar 32     meta.id.cross
id twomass_xsc 2MASS source ID number (unique within scan, coadd). int 4     NUMBER
id tycho2 GAIADR1 Tycho2 identifier (constructed from the GSC region number) varchar 32     meta.id;meta.main
id_cat twomass_xsc 2MASS matched galaxy's catalog name. varchar 20     NAME
id_epc igsl_source_catalog_ids GAIADR1 Identifier in Ecliptic Poles Catalogue varchar 20     meta.id;meta.dataset
id_flg twomass_xsc 2MASS type/galaxy ID flag (0=non-catalog, 1=catalog, 2=LCSB). smallint 2     CODE_MISC
id_gsc23 igsl_source_catalog_ids GAIADR1 Identifier in GSC2.3 bigint 8     meta.id;meta.dataset
id_hip igsl_source_catalog_ids GAIADR1 Identifier in Hipparcos int 4     meta.id;meta.dataset
id_lqrf igsl_source_catalog_ids GAIADR1 Identifier in LQRF int 4     meta.id;meta.dataset
id_ogle igsl_source_catalog_ids GAIADR1 Identifier in OGLE bigint 8     meta.id;meta.dataset
id_ppmxl igsl_source_catalog_ids GAIADR1 Identifier in PPMXL bigint 8     meta.id;meta.dataset
id_sdss igsl_source_catalog_ids GAIADR1 Identifier in SDSS bigint 8     meta.id;meta.dataset
id_tmass igsl_source_catalog_ids GAIADR1 Identifier in 2MASS PSC bigint 8     meta.id;meta.dataset
id_tycho igsl_source_catalog_ids GAIADR1 Identifier in Tycho bigint 8     meta.id;meta.dataset
id_tycho tycho2 GAIADR1 Numerical Tycho2 identifier bigint 8     meta.id;meta.dataset
id_ucac igsl_source_catalog_ids GAIADR1 Identifier in UCAC int 4     meta.id;meta.dataset
idCand rosat_bsc ROSAT number of identification candidates in the correlation catalogue smallint 2     NUMBER
idCand rosat_fsc ROSAT number of identification candidates in the correlation catalogue tinyint 1     NUMBER
idType iras_psc IRAS Type of Object tinyint 1     CLASS_OBJECT
iFlag rosat_bsc, rosat_fsc ROSAT broad band image available varchar 1     CODE_MISC
ignore Multiframe WSA Ignore this file in group process {image primary HDU keyword: IGNORE} tinyint 1   0 meta.code
ignore Multiframe WSACalib Ignore this file in group process {image primary HDU keyword: IGNORE} tinyint 1   0 meta.code
ignore Multiframe WSATransit Ignore this file in group process {image primary HDU keyword: IGNORE} tinyint 1   0 meta.code
ignore Multiframe WSAUHS Ignore this file in group process {image primary HDU keyword: IGNORE} tinyint 1   0 meta.code
illumFile Multiframe WSA File name of CASU created photometric illumination correction used on catalogue data from this file varchar 256   NONE  
illumFile Multiframe WSACalib File name of CASU created photometric illumination correction used on catalogue data from this file varchar 256   NONE  
illumFile Multiframe WSATransit File name of CASU created photometric illumination correction used on catalogue data from this file varchar 256   NONE  
illumFile Multiframe WSAUHS File name of CASU created photometric illumination correction used on catalogue data from this file varchar 256   NONE  
illumMoon Multiframe WSA Illumination of the Moon float 8   -0.9999995e9 ??
illumMoon Multiframe WSACalib Illumination of the Moon float 8   -0.9999995e9 ??
illumMoon Multiframe WSATransit Illumination of the Moon float 8   -0.9999995e9 ??
illumMoon Multiframe WSAUHS Illumination of the Moon float 8   -0.9999995e9 ??
im_nx twomass_xsc 2MASS size of postage stamp image in pixels. smallint 2     INST_DET_SIZE
iMag ukirtFSstars WSA I band total magnitude real 4 mag -0.9999995e9 PHOT_INT-MAG
iMag ukirtFSstars WSACalib I band total magnitude real 4 mag -0.9999995e9 PHOT_INT-MAG
iMag ukirtFSstars WSAUHS I band total magnitude real 4 mag -0.9999995e9 PHOT_INT-MAG
imageExtent CurrentAstrometry WSACalib The maximum angular extent from the central position real 4 Arcminutes -0.9999995e9 pos.angDistance
imageExtent CurrentAstrometry WSATransit The maximum angular extent from the central position real 4 Arcminutes -0.9999995e9 pos.angDistance
imageExtent CurrentAstrometry WSAUHS The maximum angular extent from the central position real 4 Arcminutes -0.9999995e9 pos.angDistance
imageExtent CurrentAstrometry, PreviousAstrometry WSA The maximum angular extent from the central position real 4 Arcminutes -0.9999995e9 pos.angDistance
imageExtName MultiframeDetector WSA Extension name in source FITS image file {image extension keyword: XTENSION} varchar 16   NONE ??
imageExtName MultiframeDetector WSACalib Extension name in source FITS image file {image extension keyword: XTENSION} varchar 16   NONE ??
imageExtName MultiframeDetector WSATransit Extension name in source FITS image file {image extension keyword: XTENSION} varchar 16   NONE ??
imageExtName MultiframeDetector WSAUHS Extension name in source FITS image file {image extension keyword: XTENSION} varchar 16   NONE ??
imageGcount MultiframeDetector WSA FITS image extension required keyword (always 1 for uncompressed images) {image extension keyword: GCOUNT} int 4     meta.number
imageGcount MultiframeDetector WSACalib FITS image extension required keyword (always 1 for uncompressed images) {image extension keyword: GCOUNT} int 4     meta.number
imageGcount MultiframeDetector WSATransit FITS image extension required keyword (always 1 for uncompressed images) {image extension keyword: GCOUNT} int 4     meta.number
imageGcount MultiframeDetector WSAUHS FITS image extension required keyword (always 1 for uncompressed images) {image extension keyword: GCOUNT} int 4     meta.number
imagePcount MultiframeDetector WSA FITS image extension required keyword (always 0 for uncompressed images) {image extension keyword: PCOUNT} int 4     meta.number
imagePcount MultiframeDetector WSACalib FITS image extension required keyword (always 0 for uncompressed images) {image extension keyword: PCOUNT} int 4     meta.number
imagePcount MultiframeDetector WSATransit FITS image extension required keyword (always 0 for uncompressed images) {image extension keyword: PCOUNT} int 4     meta.number
imagePcount MultiframeDetector WSAUHS FITS image extension required keyword (always 0 for uncompressed images) {image extension keyword: PCOUNT} int 4     meta.number
imagesLocation ExternalSurvey WSA Pathname to the pixels (eg. for list-driven remeasurement) varchar 256     ??
imagesLocation ExternalSurvey WSACalib Pathname to the pixels (eg. for list-driven remeasurement) varchar 256     ??
imagesLocation ExternalSurvey WSATransit Pathname to the pixels (eg. for list-driven remeasurement) varchar 256     ??
imagesLocation ExternalSurvey WSAUHS Pathname to the pixels (eg. for list-driven remeasurement) varchar 256     ??
INEXR mgcBrightSpec MGC Exclusion region flag (0 exclude/ 1 keep) tinyint 1      
instrument Multiframe WSA Instrument name {image primary HDU keyword: INSTRUME} varchar 32   NONE  
instrument Multiframe WSACalib Instrument name {image primary HDU keyword: INSTRUME} varchar 32   NONE  
instrument Multiframe WSATransit Instrument name {image primary HDU keyword: INSTRUME} varchar 32   NONE  
instrument Multiframe WSAUHS Instrument name {image primary HDU keyword: INSTRUME} varchar 32   NONE  
int_average_g cepheid, rrlyrae GAIADR1 Intensity-averaged magnitude in the G band float 8 mag   phot.mag;em.opt
int_average_g_error cepheid, rrlyrae GAIADR1 Uncertainty on the intensity-averaged magnitude in the G band float 8 mag   stat.error;phot.mag;em.opt
intProdType ProductLinks WSA Type (stack,tile,mosaic) of intermediate frame varchar 8     ??
intProdType ProductLinks WSAUHS Type (stack,tile,mosaic) of intermediate frame varchar 8     ??
intProductID ProductLinks WSA Product ID of intermediate frame int 4     ??
intProductID ProductLinks WSAUHS Product ID of intermediate frame int 4     ??
iqr phot_variable_time_series_g_fov_statistical_parameters GAIADR1 Inter-quartile range of the G-band time series values float 8 mag   phot.mag;stat.value
isComplete dxsAstrometricInfo, udsAstrometricInfo WSA Level of completeness: 0 redo both parts 1; halfspace calculation complete; 2 Astrometric correction complete; 3 All complete tinyint 1   0  
isComplete uhsAstrometricInfo WSAUHS Level of completeness: 0 redo both parts 1; halfspace calculation complete; 2 Astrometric correction complete; 3 All complete tinyint 1   0  
isLowGalacticLat Programme WSA Is this a low Galactic latitude field where Schlegel maps don't work (No=0/Yes=1) tinyint 1   0  
isLowGalacticLat Programme WSACalib Is this a low Galactic latitude field where Schlegel maps don't work (No=0/Yes=1) tinyint 1   0  
isLowGalacticLat Programme WSATransit Is this a low Galactic latitude field where Schlegel maps don't work (No=0/Yes=1) tinyint 1   0  
isLowGalacticLat Programme WSAUHS Is this a low Galactic latitude field where Schlegel maps don't work (No=0/Yes=1) tinyint 1   0  
ISOAREA_IMAGE mgcDetection MGC Isophotal area above analysis threshold int 4 pixel^2    
ISOAREA_WORLD mgcDetection MGC Isophotal area above analysis threshold real 4 deg^2    
isoFlux UKIDSSDetection WSA Instrumental isophotal flux counts real 4 ADU   PHOT_INTENSITY_ADU
isoFlux calDetection WSACalib Instrumental isophotal flux counts {catalogue TType keyword: Isophotal_flux} real 4 ADU   PHOT_INTENSITY_ADU
Standard definition of summed flux within detection isophote, apart from detection filter is used to define pixel connectivity and hence which pixels to include. This helps to reduce edge effects for all isophotally derived parameters.
isoFlux dxsDetection, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement WSA Instrumental isophotal flux counts {catalogue TType keyword: Isophotal_flux} real 4 ADU   PHOT_INTENSITY_ADU
Standard definition of summed flux within detection isophote, apart from detection filter is used to define pixel connectivity and hence which pixels to include. This helps to reduce edge effects for all isophotally derived parameters.
isoFlux ptsDetection WSATransit Instrumental isophotal flux counts {catalogue TType keyword: Isophotal_flux} real 4 ADU   PHOT_INTENSITY_ADU
Standard definition of summed flux within detection isophote, apart from detection filter is used to define pixel connectivity and hence which pixels to include. This helps to reduce edge effects for all isophotally derived parameters.
isoFlux udsDetection WSA Instrumental isophotal flux counts (SE: FLUX_ISO) {catalogue TType keyword: Isophotal_flux} real 4 ADU   PHOT_INTENSITY_ADU
Standard definition of summed flux within detection isophote, apart from detection filter is used to define pixel connectivity and hence which pixels to include. This helps to reduce edge effects for all isophotally derived parameters.
isoFlux uhsDetection, uhsDetectionAll WSAUHS Instrumental isophotal flux counts {catalogue TType keyword: Isophotal_flux} real 4 ADU   PHOT_INTENSITY_ADU
Standard definition of summed flux within detection isophote, apart from detection filter is used to define pixel connectivity and hence which pixels to include. This helps to reduce edge effects for all isophotally derived parameters.
isoMag dxsDetection, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, UKIDSSDetection, udsDetection WSA Calibrated isophotal magnitude real 4 mag   PHOT_INT-MAG
isoMag calDetection WSACalib Calibrated isophotal magnitude real 4 mag   PHOT_INT-MAG
isoMag ptsDetection WSATransit Calibrated isophotal magnitude real 4 mag   PHOT_INT-MAG
isoMag uhsDetection, uhsDetectionAll WSAUHS Calibrated isophotal magnitude real 4 mag   PHOT_INT-MAG
isSynoptic RequiredFilters WSA is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE) tinyint 1   0  
isSynoptic RequiredFilters WSACalib is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE) tinyint 1   0  
isSynoptic RequiredFilters WSATransit is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE) tinyint 1   0  
isSynoptic RequiredFilters WSAUHS is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE) tinyint 1   0  
isu2Port Multiframe WSA ISU2 port name {image primary HDU keyword: ISU2PORT} varchar 32   NONE  
isu2Port Multiframe WSACalib ISU2 port name {image primary HDU keyword: ISU2PORT} varchar 32   NONE  
isu2Port Multiframe WSATransit ISU2 port name {image primary HDU keyword: ISU2PORT} varchar 32   NONE  
isu2Port Multiframe WSAUHS ISU2 port name {image primary HDU keyword: ISU2PORT} varchar 32   NONE  
isu2PortOffset Multiframe WSA ISU2 port offset {image primary HDU keyword: ISU2POFF} int 4   -99999999  
isu2PortOffset Multiframe WSACalib ISU2 port offset {image primary HDU keyword: ISU2POFF} int 4   -99999999  
isu2PortOffset Multiframe WSATransit ISU2 port offset {image primary HDU keyword: ISU2POFF} int 4   -99999999  
isu2PortOffset Multiframe WSAUHS ISU2 port offset {image primary HDU keyword: ISU2POFF} int 4   -99999999  
isu2TiltOffset Multiframe WSA ISU2 tilt offset {image primary HDU keyword: ISU2TOFF} int 4   -99999999  
isu2TiltOffset Multiframe WSACalib ISU2 tilt offset {image primary HDU keyword: ISU2TOFF} int 4   -99999999  
isu2TiltOffset Multiframe WSATransit ISU2 tilt offset {image primary HDU keyword: ISU2TOFF} int 4   -99999999  
isu2TiltOffset Multiframe WSAUHS ISU2 tilt offset {image primary HDU keyword: ISU2TOFF} int 4   -99999999  
itb rosat_fsc ROSAT start time of observation (MM-DD-YYYY HH:MM:SS) datetime 8 mm-dd-yyyy hh:mm:ss   TIME_DATE
ite rosat_fsc ROSAT end time of observation (MM-DD-YYYY HH:MM:SS) datetime 8 mm-dd-yyyy hh:mm:ss   TIME_DATE
iz10 Multiframe WSA Trefoil: IZ10 {image primary HDU keyword: IZ10} real 4   -0.9999995e9  
iz10 Multiframe WSACalib Trefoil: IZ10 {image primary HDU keyword: IZ10} real 4   -0.9999995e9  
iz10 Multiframe WSATransit Trefoil: IZ10 {image primary HDU keyword: IZ10} real 4   -0.9999995e9  
iz10 Multiframe WSAUHS Trefoil: IZ10 {image primary HDU keyword: IZ10} real 4   -0.9999995e9  
iz5 Multiframe WSA Astigmatism: IZ5 {image primary HDU keyword: IZ5} real 4   -0.9999995e9  
iz5 Multiframe WSACalib Astigmatism: IZ5 {image primary HDU keyword: IZ5} real 4   -0.9999995e9  
iz5 Multiframe WSATransit Astigmatism: IZ5 {image primary HDU keyword: IZ5} real 4   -0.9999995e9  
iz5 Multiframe WSAUHS Astigmatism: IZ5 {image primary HDU keyword: IZ5} real 4   -0.9999995e9  
iz6 Multiframe WSA Astigmatism: IZ6 {image primary HDU keyword: IZ6} real 4   -0.9999995e9  
iz6 Multiframe WSACalib Astigmatism: IZ6 {image primary HDU keyword: IZ6} real 4   -0.9999995e9  
iz6 Multiframe WSATransit Astigmatism: IZ6 {image primary HDU keyword: IZ6} real 4   -0.9999995e9  
iz6 Multiframe WSAUHS Astigmatism: IZ6 {image primary HDU keyword: IZ6} real 4   -0.9999995e9  
iz9 Multiframe WSA Trefoil: IZ9 {image primary HDU keyword: IZ9} real 4   -0.9999995e9  
iz9 Multiframe WSACalib Trefoil: IZ9 {image primary HDU keyword: IZ9} real 4   -0.9999995e9  
iz9 Multiframe WSATransit Trefoil: IZ9 {image primary HDU keyword: IZ9} real 4   -0.9999995e9  
iz9 Multiframe WSAUHS Trefoil: IZ9 {image primary HDU keyword: IZ9} real 4   -0.9999995e9  



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

wsa-support@roe.ac.uk
07/11/2017