Home | Browser | Access | Login | FreeSQL     VULCAN logo

Glossary of VULCAN attributes

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

C

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
c_strat twomass_scn TWOMASS Flag indicating the calibration strategy for this night's data. smallint 2     meta.code
c_strat twomass_sixx2_scn TWOMASS calibration strategy, north only (0=old, 1=new) smallint 2      
cat twomass_sixx2_psc, twomass_sixx2_scn, twomass_sixx2_xsc TWOMASS Catalog indicator 1=catalog, 0=not catalog smallint 2      
catalogueSchema Programme VULCANiDR Script file that describes the catalogue schema varchar 64     ??
cc_flags allwise_sc WISE Contamination and confusion flag. Four character string, one character per band [W1/W2/W3/W4], that indicates that the photometry and/or position measurements of a source may be contaminated or biased due to proximity to an image artifact. CAUTION: Non-zero cc_flags values in any band indicate the the measurement in that band may be contaminated and the photometry should be used with caution. varchar 4      
The type of artifact that may contaminate the measurements is denoted by the following codes. Lower-case letters correspond to instances in which the source detection in a band is believed to be real but the measurement may be contaminated by the artifact. Upper-case letters are instances in which the source detection in a band may be a spurious detection of an artifact.
  • D,d - Diffraction spike. Source may be a spurious detection of (D) or contaminated by (d) a diffraction spike from a nearby bright star on the same image, or
  • P,p - Persistence. Source may be a spurious detection of (P) or contaminated by (p) a short-term latent image left by a bright source, or
  • H,h - Halo. Source may be a spurious detection of (H) or contaminated by (h) the scattered light halo surrounding a nearby bright source, or
  • O,o (letter "o") - Optical ghost. Source may be a spurious detection of (O) or contaminated by (o) an optical ghost image caused by a nearby bright source, or
  • 0 (number zero) - Source is unaffected by known artifacts.
A source extraction may be affected by more than one type of artifact or condition. In this event, the cc_flags value in each band is set in the following priority order: D,P,H,O,d,p,h,o,0. The full tally of artifacts affecting a source in each band is given in the w?cc_map and w?cc_map_str columns. A source can appear in the AllWISE Source Catalog even if it is flagged as a spurious artifact detection in a band if there is a reliable detection in another band that is not flagged as a spurious artifact detection. Entries in the AllWISE Reject Table may be flagged as spurious detections of artifacts in all bands.
cc_flags catwise_2020, catwise_prelim WISE worst case 4 character cc_flag from AllWISE varchar 16      
cc_flags wise_allskysc WISE Contamination and confusion flag.
Four character strong, one character per band [W1/W2/W3/W4], that indicates that the photometry and/or position measurements of a source may be contaminated or biased due to proximity to an image artifact. CAUTION: Non-zero cc_flags values in any band indicate the the measurement in that band may be contaminated and the photometry should be used with caution.		 char 4      
cc_flags wise_prelimsc WISE Contamination and confusion flag
Four character strong, one character per band [W1/W2/W3/W4], that indicates that the photometry and/or position measurements of a source may be contaminated or biased due to proximity to an image artifact		 char 4      
cc_flg twomass_psc TWOMASS Contamination and confusion flag. varchar 3     meta.code
cc_flg twomass_sixx2_psc TWOMASS indicates JHK artifact contamination and/or confusion varchar 3      
cc_flg twomass_sixx2_xsc TWOMASS indicates artifact contamination and/or confusion varchar 1      
cc_flg twomass_xsc TWOMASS indicates artifact contamination and/or confusion. varchar 1     meta.code
cd11 CurrentAstrometry VULCANiDR Element of the linear transformation matrix (with scale) {image extension keyword: CD1_1} float 8   -0.9999995e9 pos.wcs.cdmatrix
cd12 CurrentAstrometry VULCANiDR Element of the linear transformation matrix (with scale) {image extension keyword: CD1_2} float 8   -0.9999995e9 pos.wcs.cdmatrix
cd21 CurrentAstrometry VULCANiDR Element of the linear transformation matrix (with scale) {image extension keyword: CD2_1} float 8   -0.9999995e9 pos.wcs.cdmatrix
cd22 CurrentAstrometry VULCANiDR Element of the linear transformation matrix (with scale) {image extension keyword: CD2_2} float 8   -0.9999995e9 pos.wcs.cdmatrix
chi2 allSkyNIRSource VULCANiDR Chi-squared value of proper motion solution real 4   -0.9999995e9 stat.fit.chi2
chi2pmdec catwise_2020, catwise_prelim WISE chi-square for PMRA difference (1 DF) real 4      
chi2pmra catwise_2020, catwise_prelim WISE chi-square for PMRA difference (1 DF) real 4      
classprob_dsc_combmod_binarystar gaia_source GAIADR3 Overall class probability from DSC of being a binary star real 4     stat.probability
classprob_dsc_combmod_galaxy gaia_source GAIADR3 Overall class probability from DSC of being a galaxy real 4     stat.probability
classprob_dsc_combmod_quasar gaia_source GAIADR3 Overall class probability from DSC of being a quasar real 4     stat.probability
classprob_dsc_combmod_star gaia_source GAIADR3 Overall class probability from DSC of being a single star (but not a white dwarf) real 4     stat.probability
classprob_dsc_combmod_whitedwarf gaia_source GAIADR3 Overall class probability from DSC of being a white dwarf real 4     stat.probability
clat twomass_sixx2_psc, twomass_sixx2_scn TWOMASS The computed dec (J2000 EQ) of scan center in sexigesimal. varchar 16      
clat twomass_sixx2_xsc TWOMASS The computed dec (J2000 EQ) in sexigesimal. varchar 16      
cld twomass_scn TWOMASS Special flag indicating whether or not a cloud was found in the scan after comparison of its photometry to that of overlapping scans in the database. smallint 2     meta.code
cld twomass_sixx2_scn TWOMASS downgrade from DB photom. overlap comparison (clouds) (0|1) smallint 2      
clon twomass_sixx2_psc, twomass_sixx2_scn TWOMASS The computed ra (J2000 EQ) of scan center in sexigesimal. varchar 16      
clon twomass_sixx2_xsc TWOMASS The computed ra (J2000 EQ) in sexigesimal. varchar 16      
cntr allwise_sc WISE Unique identification number for this object in the AllWISE Catalog/Reject Table. This number is formed from the source_id, which is in turn formed from the coadd_id and source number, src. bigint 8      
The cntr value is formed by making the source_id into an integer, in the format: RRRRsDDDtrevIIIIII, where
  • RRRR = Tile center RA in deci-degrees, truncated not rounded (e.g. RRRR=int[10*ra]), as in the coadd_id.
  • s = Tile center Declination sign translated from "p" or "m" into "1" or "0", respectively.
  • DDD = Tile center Declination in deci-degrees, as in the coadd_id. For positive declinations, the tenths of a degree is truncated not rounded (e.g. DDD=int[10*dec]). For negative declinations, the tenths of a degree is always truncated leftward on the number line (e.g. DDD=ceil[10*abs(dec)].
  • [trev] = Disambiguation string, translated where necessary into digits corresponding to the letters' places in the alphabet.
    • t - Tile type translated into two digits, zero-filled ("a" = "01").
    • r - Data Release identifier translated into a single digit, (For AllWISE: "c" = "3").
    • e - Survey Phase ("5" = AllWISE [Full cryogenic + 3-Band Cryo + Post-Cryo]).
    • v - Processing version.

    The translated disambiguation string is always 01351 for AllWISE.

  • IIIIII = six-digit, zero-filled, sequential extracted source number, src, within the Tile.

For example, a source in the Tile 3041m137_ac51, with a source_id of '3041m137_ac51-012345', has a cntr value of 3041013701351012345.

NOTE: AllWISE Catalog and Reject Table entries are cross-referenced with the Multiepoch Photometry (MEP) Database via the cntr identifier. The Catalog/Reject Table cntr value is referred to as cntr_mf in the MEP Database.

cntr catwise_2020, catwise_prelim WISE Unique identifier int 4      
cntr twomass_sixx2_scn, twomass_sixx2_xsc TWOMASS entry counter (key) number (unique within table) int 4      
cntr wise_allskysc WISE Unique identification number for the Catalog source
This number is formed entirely from the source_id, which is in turn formed from the coadd_id and source number src. On average, sources with cntr values close to each other are also close to each other on the sky, except at Tile boundaries.		 bigint 8     meta.id;meta.main
cntr wise_prelimsc WISE Unique identification number for the Catalog source
This number is formed entirely from the source_id, which is in turn formed from the coadd_id and source number src. On average, sources with cntr values close to each other are also close to each other on the sky, except at Tile boundaries		 bigint 8     meta.id;meta.main
coadd twomass_psc TWOMASS Sequence number of the Atlas Image in which the position of this source falls. smallint 2     meta.number
coadd twomass_xsc TWOMASS 3-digit coadd number (unique within scan). smallint 2     meta.number
coadd_id allwise_sc WISE Atlas Tile identifier from which source was extracted. varchar 20      
The identifier has the general form: RRRRsDDD_[trev], where
  • RRRR = Tile center RA in deci-degrees, truncated not rounded (e.g. RRRR=int[10*ra]).
  • s = Tile center Declination sign ("p"="+", "m"="-")
  • DDD = Tile center Declination in deci-degrees. For positive declinations, the tenths of a degree is truncated not rounded (e.g. DDD=int[10*dec]). For negative declinations, the tenths of a degree is always truncated leftward on the number line (e.g. DDD=ceil[10*abs(dec)].
  • [trev] = Disambiguation string.
    • t - Tile type ("a" = Atlas)
    • r - Data Release ("c" = AllWISE)
    • e - Survey Phase ("5" = AllWISE [Full Cryogenic + 3-Band Cryo + Post-Cryo])
    • v - Processing version.

    The disambiguation string is always ac51 for Tiles in the AllWISE Release products.

coadd_id wise_allskysc WISE Atlas Tile identifier from which source was extracted. char 20      
coadd_id wise_prelimsc WISE Atlas Tile identifier from which source was extracted char 20      
coadd_key twomass_psc TWOMASS Unique identification number of the record in the Atlas Image Data Table (NOT YET AVAILABLE) that corresponds to Image in which the position of this source falls. int 4     meta.id
coadd_key twomass_xsc TWOMASS key to coadd data record in "scan DB". int 4     meta.id
comment ArchiveCurationHistory VULCANiDR Comment string supplied by the curator varchar 256     ??
contam_flg twomass_xsc TWOMASS contamination flag: 0=no stars, 1=stellar flux incl. in mag. smallint 2     meta.code
coord1 ExternalSurveyTable VULCANiDR The attribute name of the first (longitudinal) spherical co-ordinate, e.g. equatorial RA varchar 32   'ra' ??
coord2 ExternalSurveyTable VULCANiDR The attribute name of the second (latitudinal) spherical co-ordinate, e.g. equatorial Dec varchar 32   'dec' ??
crPixX CurrentAstrometry VULCANiDR Pixel coordinate of the reference point on axis 1 {image extension keyword: CRPIX1} float 8 pixels -0.9999995e9 pos.cartesian.x;instr.det
crPixY CurrentAstrometry VULCANiDR Pixel coordinate of the reference point on axis 2 {image extension keyword: CRPIX2} float 8 pixels -0.9999995e9 pos.cartesian.y;instr.det
crValX CurrentAstrometry VULCANiDR Coordinate value at reference point on axis 1 {image extension keyword: CRVAL1} float 8   -0.9999995e9 pos.cartesian.x;instr.det
crValY CurrentAstrometry VULCANiDR Coordinate value at reference point on axis 2 {image extension keyword: CRVAL2} float 8   -0.9999995e9 pos.cartesian.y;instr.det
cTypeX CurrentAstrometry VULCANiDR G&C WCS type, eg 'RA---ZPN' {image extension keyword: CTYPE1} varchar 8   'NONE' pos.eq.ra;meta.main
cTypeY CurrentAstrometry VULCANiDR G&C WCS type, eg 'DEC--ZPN' {image extension keyword: CTYPE2} varchar 8   'NONE' pos.eq.dec;meta.main
cuEventID ArchiveCurationHistory, AstrometricInfo, ProgrammeCurationHistory VULCANiDR UID of curation event giving rise to this record int 4     meta.bib
cuEventID allSkyNIRFrameSetInfo, allSkyNIRSource VULCANiDR UID of curation event giving rise to this record int 4     meta.id
cuID ArchiveCurationHistory, CurationTask VULCANiDR the unique curation task ID smallint 2     meta.bib
curator ArchiveCurationHistory VULCANiDR The archive curation scientist responsible for this event varchar 16     ??
cutOff Filter VULCANiDR The 50% cut-off wavelength of the filter real 4 microns   ??
cutOn Filter VULCANiDR The 50% cut-on wavelength of the filter real 4 microns   ??
cx ObjectThin PS1DR2 Cartesian x on a unit sphere. float 8     pos.cartesian.x;pos.eq
cx allSkyNIRFrameSetInfo, allSkyNIRSource VULCANiDR unit vector of spherical co-ordinates float 8     pos.cartesian.x;pos.eq
cx catwise_2020, catwise_prelim WISE unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.x
cx gaia_source GAIADR3 unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.x
cx twomass_psc, twomass_scn, twomass_sixx2_psc, twomass_sixx2_scn, twomass_sixx2_xsc, twomass_xsc TWOMASS unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.x
cx wise_allskysc, wise_prelimsc WISE unit vector of spherical co-ordinates (similar to x in IPAC IRSA schema, but recomputed) float 8     pos.distance;pos.cartesian.x
cy ObjectThin PS1DR2 Cartesian y on a unit sphere. float 8     pos.cartesian.y;pos.eq
cy allSkyNIRFrameSetInfo, allSkyNIRSource VULCANiDR unit vector of spherical co-ordinates float 8     pos.cartesian.y;pos.eq
cy catwise_2020, catwise_prelim WISE unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.y
cy gaia_source GAIADR3 unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.y
cy twomass_psc, twomass_scn, twomass_sixx2_psc, twomass_sixx2_scn, twomass_sixx2_xsc, twomass_xsc TWOMASS unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.y
cy wise_allskysc, wise_prelimsc WISE unit vector of spherical co-ordinates (similar to y in IPAC IRSA schema, but recomputed) float 8     pos.distance;pos.cartesian.y
cz ObjectThin PS1DR2 Cartesian z on a unit sphere. float 8     pos.cartesian.y;pos.eq
cz allSkyNIRFrameSetInfo, allSkyNIRSource VULCANiDR unit vector of spherical co-ordinates float 8     pos.cartesian.z;pos.eq
cz catwise_2020, catwise_prelim WISE unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.z
cz gaia_source GAIADR3 unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.z
cz twomass_psc, twomass_scn, twomass_sixx2_psc, twomass_sixx2_scn, twomass_sixx2_xsc, twomass_xsc TWOMASS unit vector of spherical co-ordinates float 8     pos.distance;pos.cartesian.z
cz wise_allskysc, wise_prelimsc WISE unit vector of spherical co-ordinates (similar to z in IPAC IRSA schema, but recomputed) float 8     pos.distance;pos.cartesian.z


Home | Overview | Browser | Access | Login |
FreeSQL
Links | Credits

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK

vsa-support@roe.ac.uk
25/05/2026