| Home | Browser | Access | Login | FreeSQL |
|
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 |
S | ||||||||
|---|---|---|---|---|---|---|---|---|
| Name | Schema Table | Database | Description | Type | Length | Unit | Default Value | Unified Content Descriptor |
| satnum | allwise_sc | WISE | Minimum sample at which saturation occurs in each band. Four character string, one character per band, that indicates the minimum SUTR sample in which any pixel in the profile-fitting area in all of the single-exposure images used to characterize this source was flagged as having reached the saturation level in the on-board WISE payload processing. If no pixels in a given band are flagged as saturated, the value for that band is "0". | varchar | 4 | |||
| satnum | wise_allskysc | WISE | Minimum sample at which saturation occurs in each band. Four character string, one character per band, that indicates the minimum SUTR sample in which any pixel in the profile-fitting area in all of the single-exposure images used to characterize this source was flagged as having reached the saturation level in the on-board WISE payload processing. If no pixels in a given band are flagged as saturated, the value for that band is "0". |
char | 4 | |||
| satnum | wise_prelimsc | WISE | Minimum sample at which saturation occurs in each band Four character string, one character per band, that indicates the minimum SUTR sample in which any pixel in the profile-fitting area in all of the single-exposure images used to characterize this source was flagged as having reached the saturation level in the on-board WISE payload processing. If no pixels in a given band are flagged as saturated, the value for that band is "0". |
char | 4 | |||
| scan | twomass_psc | TWOMASS | The nightly scan number in which the source was detected. | smallint | 2 | meta.number | ||
| scan | twomass_scn | TWOMASS | Scan number (unique within date). | smallint | 2 | meta.number | ||
| scan | twomass_sixx2_scn | TWOMASS | scan number (unique within date) | smallint | 2 | |||
| scan | twomass_xsc | TWOMASS | scan number (unique within date). | smallint | 2 | meta.number | ||
| scan_direction_mean_k1 | gaia_source | GAIADR3 | Mean position angle of scan directions across the source | real | 4 | degrees | pos.posAng;stat.mean | |
| scan_direction_mean_k2 | gaia_source | GAIADR3 | Mean position angle of scan directions across the source | real | 4 | degrees | pos.posAng;stat.mean | |
| scan_direction_mean_k3 | gaia_source | GAIADR3 | Mean position angle of scan directions across the source | real | 4 | degrees | pos.posAng;stat.mean | |
| scan_direction_mean_k4 | gaia_source | GAIADR3 | Mean position angle of scan directions across the source | real | 4 | degrees | pos.posAng;stat.mean | |
| scan_direction_strength_k1 | gaia_source | GAIADR3 | Degree of concentration of scan directions across the source | real | 4 | stat.value | ||
| scan_direction_strength_k2 | gaia_source | GAIADR3 | Degree of concentration of scan directions across the source | real | 4 | stat.value | ||
| scan_direction_strength_k3 | gaia_source | GAIADR3 | Degree of concentration of scan directions across the source | real | 4 | stat.value | ||
| scan_direction_strength_k4 | gaia_source | GAIADR3 | Degree of concentration of scan directions across the source | real | 4 | stat.value | ||
| scan_key | twomass_psc | TWOMASS | 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 | meta.id | ||
| scan_key | twomass_scn | TWOMASS | the unique identification number for this scan. | int | 4 | meta.id | ||
| scan_key | twomass_sixx2_xsc | TWOMASS | key to scan data record in "scan DB" | int | 4 | |||
| scan_key | twomass_xsc | TWOMASS | key to scan data record in "scan DB". | int | 4 | meta.id | ||
| sd | twomass_scn | TWOMASS | Scanning direction: "n" = north-going, "s" = south-going. | varchar | 1 | pos.posAng | ||
| sd | twomass_sixx2_scn | TWOMASS | direction of scan -- north/south-bound (n/s) | varchar | 1 | |||
| sdet | twomass_sixx2_psc, twomass_sixx2_xsc | TWOMASS | # of scans in which src was detected in >=1 band | smallint | 2 | |||
| sdssPrimary | allSkyNIRSourceXDR13PhotoObj, allSkyNIRSourceXDR13PhotoObjAll | VULCANiDR | SDSS flag for neighbour being primary (1) or secondary (0) | tinyint | 1 | 255 | meta.code | |
| sdssType | allSkyNIRSourceXDR13PhotoObj, allSkyNIRSourceXDR13PhotoObjAll | VULCANiDR | SDSS type of neighbour: 3=galaxy; 6=star | tinyint | 1 | 255 | src.class | |
| seqNum | twomass_sixx2_psc | TWOMASS | Sequential number (unique object ID) | int | 4 | |||
| shortName | Filter | VULCANiDR | Short identification name for the filter | varchar | 10 | ?? | ||
| sigDec | allSkyNIRSource | VULCANiDR | Uncertainty in Dec | real | 4 | Degrees | -0.9999995e9 | stat.error |
| sigdec | allwise_sc | WISE | One-sigma uncertainty in declination coordinate from the non-moving source extraction. | float | 8 | arcsec | ||
| sigdec | catwise_2020, catwise_prelim | WISE | uncertainty in dec (arcsec) | real | 4 | arcsec | ||
| sigdec | wise_allskysc | WISE | One-sigma uncertainty in declination coordinate | real | 4 | arcsec | ||
| sigdec | wise_prelimsc | WISE | One-sigma uncertainty in declination coordinate CAUTION: The declination uncertainty is overestimated for the majority of sources in the Preliminary Release Source Catalog. Sigdec was computed by adding 0.5 arcsec in quadrature to the extraction measurement uncertainty to reflect the impact of the declination bias error known to affect a fraction of source fainter than W1~13.0 mag |
real | 4 | arcsec | ||
| sigdec_pm | allwise_sc | WISE | One-sigma uncertainty in declination from the profile-fitting measurement model that includes motion. This column is null if the motion-fit failed to converge or was not attempted. | float | 8 | arcsec | ||
| sigdec_pm | catwise_2020, catwise_prelim | WISE | uncertainty in dec_pm | real | 4 | arcsec | ||
| sigMuDec | allSkyNIRSource | VULCANiDR | Error on proper motion in Dec direction | real | 4 | mas/yr | -0.9999995e9 | stat.error |
| sigMuRa | allSkyNIRSource | VULCANiDR | Error on proper motion in RA direction | real | 4 | mas/yr | -0.9999995e9 | stat.error |
| sigPMDec | catwise_2020, catwise_prelim | WISE | uncertainty in PMDec | real | 4 | arcsec/yr | ||
| sigpmdec | allwise_sc | WISE | Uncertainty in the Dec motion estimated for this source. This column is null if the motion fit failed to converge or was not attempted. | int | 4 | mas/year | ||
| sigPMRA | catwise_2020, catwise_prelim | WISE | uncertainty in PMRA | real | 4 | arcsec/yr | ||
| sigpmra | allwise_sc | WISE | Uncertainty in the RA motion estimation. This column is null if the motion fit failed to converge or was not attempted. | int | 4 | mas/year | ||
| sigRa | allSkyNIRSource | VULCANiDR | Uncertainty in RA | real | 4 | Degrees | -0.9999995e9 | stat.error |
| sigra | allwise_sc | WISE | One-sigma uncertainty in right ascension coordinate from the non-moving source extraction. | float | 8 | arcsec | ||
| sigra | catwise_2020, catwise_prelim | WISE | uncertainty in ra (arcsec) | real | 4 | arcsec | ||
| sigra | wise_allskysc, wise_prelimsc | WISE | One-sigma uncertainty in right ascension coordinate | real | 4 | arcsec | ||
| sigra_pm | allwise_sc | WISE | One-sigma uncertainty in right ascension from the profile-fitting measurement model that includes motion. This column is null if the motion-fit failed to converge or was not attempted. | float | 8 | arcsec | ||
| sigra_pm | catwise_2020, catwise_prelim | WISE | uncertainty in ra_pm | real | 4 | arcsec | ||
| sigradec | allwise_sc | WISE | The co-sigma of the equatorial position uncertainties, sigra, sigdec (σα, σδ). The covariance between the position errors, Vαδ, can be derived from the quoted co-sigma, σαδ, by the formula Vαδ = σαδ×|σαδ|. This maintains the sign information for the covariance since σαδ may be negative. It is more natural to carry the co-sigma along with the other uncertainties instead of the covariance because the former is in the same units as the other uncertainties. | float | 8 | arcsec | ||
| sigradec | catwise_2020, catwise_prelim | WISE | uncertainty cross-term (arcsec) | real | 4 | arcsec | ||
| sigradec | wise_allskysc | WISE | The co-sigma of the equatorial position uncertainties, sig_ra, sig_dec (σα, σδ). The co-sigma is related to the covariance between the position errors Vαδ by the formula Vαδ = σαδ×|σαδ|. This maintains the sign information for the correlation, since σαδ may be negative. It is more natural to carry the co-sigma along with the other uncertainties instead of the covariance because the former is in the same units as the other uncertainties. | real | 4 | degrees | ||
| sigradec | wise_prelimsc | WISE | The co-sigma of the equatorial position uncertainties, (sig_ra, sig_dec) | real | 4 | degrees | ||
| sigradec_pm | allwise_sc | WISE | The co-sigma of the equatorial position uncertainties from the profile-fitting measurement model that includes motion, sigra_pm, sigdec_pm (σα_pm, σδ_pm). The covariance between the position errors, Vα_pmδ_pm, can be derived from the quoted co-sigma, σα_pmδ_pm, by the formula α_pmδ_pm = σα_pmδ_pm×|σα_pmδ_pm|. This maintains the sign information for the covariance since σα_pmδ_pm may be negative. It is more natural to carry the co-sigma along with the other uncertainties instead of the covariance because the former is in the same units as the other uncertainties. This column is null if the motion-fit failed to converge or was not attempted. | float | 8 | arcsec | ||
| sigradec_pm | catwise_2020, catwise_prelim | WISE | uncertainty cross-term | real | 4 | arcsec | ||
| sky | Detection | PS1DR2 | Background sky level. | real | 4 | Janskys/arcsec^2 | -999 | |
| skyCellID | ObjectThin | PS1DR2 | Skycell region identifier. | tinyint | 1 | 255 | meta.id | |
| skyCellID | StackObjectThin | PS1DR2 | Skycell region identifier. | tinyint | 1 | 255 | ||
| skyErr | Detection | PS1DR2 | Error in background sky level. | real | 4 | Janskys/arcsec^2 | -999 | |
| slaveObjID | allSkyNIRSourceNeighbours | VULCANiDR | The unique ID of the neighbour in allSkyNIRSource (=sourceID) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXDR13PhotoObj | VULCANiDR | The unique ID of the neighbour in BestDR13..PhotoObj (=objID) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXDR13PhotoObjAll | VULCANiDR | The unique ID of the neighbour in BestDR13..PhotoObjAll (=objID) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXGEDR3gaia_source | VULCANiDR | The unique ID of the neighbour in GAIAEDR3..gaia_source (=source_id) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXPS1DR2_objectThin | VULCANiDR | The unique ID of the neighbour in PS1DR2..objectThin (=objID) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXSSASource | VULCANiDR | The unique ID of the neighbour in SSA..Source (=objID) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXallwise_sc | VULCANiDR | The unique ID of the neighbour in WISE..allwise_sc (=cntr) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXtwomass_psc | VULCANiDR | The unique ID of the neighbour in TWOMASS..twomass_psc (=pts_key) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXtwomass_xsc | VULCANiDR | The unique ID of the neighbour in TWOMASS..twomass_xsc (=ext_key) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXtwompzPhotoz | VULCANiDR | The unique ID of the neighbour in TWOMPZ..twompzPhotoz (=twomassID) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXwiseScosPhotoz | VULCANiDR | The unique ID of the neighbour in WISExSCOSPZ..wiseScosPhotoz (=wiseID) | bigint | 8 | meta.id;meta.dataset | ||
| slaveObjID | allSkyNIRSourceXwise_allskysc | VULCANiDR | The unique ID of the neighbour in WISE..wise_allskysc (=cntr) | bigint | 8 | meta.id;meta.dataset | ||
| solution_id | gaia_source | GAIADR3 | Solution identifier | bigint | 8 | meta.id;meta.version | ||
| source_id | allwise_sc | WISE | Unique source ID, formed from a combination of the Atlas Tile ID, coadd_id, and sequential extracted source number, src, within the Tile. | varchar | 28 | |||
The source_id string has the form RRRRsDDD_[trev]-IIIIII where:
For example, the first source extracted in AllWISE Tile 3041m137_ac51 has a source_id of 3041m137_ac51-000001. NOTE: AllWISE Catalog and Reject Table entries are cross-referenced with the Multiepoch Photometry (MEP) Database via the source_id identifier. The Catalog/Reject Table cntr value is referred to as source_id in the MEP Database. | ||||||||
| source_id | catwise_2020, catwise_prelim | WISE | tile name + processing code + wphot index | varchar | 25 | |||
| source_id | gaia_source | GAIADR3 | Unique source identifier (unique within a particular Data Release) | bigint | 8 | meta.id | ||
| source_id | wise_allskysc | WISE | Unique source ID, formed from a combination of the Atlas Tile ID, coadd_id, and sequential extracted source number, src, within the Tile. | char | 28 | |||
| source_id | wise_prelimsc | WISE | Unique source ID, formed from a combination of the Atlas Tile ID, coadd_id, and sequential extracted source number, src, within the Tile | char | 28 | |||
| source_name | catwise_2020, catwise_prelim | WISE | source hexagesimal designation | varchar | 21 | |||
| sourceID | allSkyNIRSource | VULCANiDR | UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm | bigint | 8 | meta.id;meta.main | ||
| sourceIDName | ExternalSurveyTable | VULCANiDR | The source unique identifier in the table | varchar | 256 | meta.id | ||
| sourceIDName | ProgrammeTable | VULCANiDR | the name of the source | varchar | 256 | meta.id | ||
| sourceTable | Programme | VULCANiDR | Table name of merged sources | varchar | 64 | ?? | ||
| spos | twomass_sixx2_psc, twomass_sixx2_xsc | TWOMASS | # of scans in which src position falls inside coverage area | smallint | 2 | |||
| spt_ind | allwise_sc | WISE | Level 7 HTM spatial index key | int | 4 | |||
| src | allwise_sc | WISE | Sequential number of the source extraction in the Atlas Tile from in which this source detected and measured, in approximate descending order of W1 source brightness. | int | 4 | |||
| src | wise_allskysc | WISE | Sequential number of this source extraction in the Atlas Tile from which this source was extracted, in approximate descending order of W1 source brightness. | bigint | 8 | |||
| src | wise_prelimsc | WISE | Sequential number of this source extraction in the Atlas Tile from which this source was extracted, in approximate descending order of W1 source brightness | bigint | 8 | |||
| status | ProgrammeCurationHistory | VULCANiDR | successful (1) or unsuccessful (0) | tinyint | 1 | meta.code | ||
| sup_ba | twomass_sixx2_xsc | TWOMASS | minor/major axis ratio fit to 3-sig. super-coadd isophote | real | 4 | |||
| sup_ba | twomass_xsc | TWOMASS | Minor/major axis ratio fit to 3-sig. super-coadd isophote. | real | 4 | phys.size.axisRatio | ||
| sup_chif_ellf | twomass_xsc | TWOMASS | super-coadd % chi-fraction for ellip. fit to 3-sig isophote. | real | 4 | stat.fit.param | ||
| sup_dec | twomass_xsc | TWOMASS | Super-coadd centroid Dec (J2000 decimal deg). | float | 8 | degrees | pos.eq.dec;meta.main | |
| sup_phi | twomass_sixx2_xsc | TWOMASS | super-coadd angle to major axis (E of N) | smallint | 2 | deg | ||
| sup_phi | twomass_xsc | TWOMASS | Super-coadd angle to major axis (E of N). | smallint | 2 | degrees | pos.posAng | |
| sup_r_3sig | twomass_xsc | TWOMASS | Super-coadd 3-sigma isophotal semi-major axis radius. | real | 4 | arcsec | stat.error | |
| sup_ra | twomass_xsc | TWOMASS | Super-coadd centroid RA (J2000 decimal deg). | float | 8 | degrees | pos.eq.ra;meta.main | |
| surveyID | Detection, StackObjectThin | PS1DR2 | Survey identifier. Details in the Survey table. | tinyint | 1 | |||
| surveyID | ExternalSurvey, ExternalSurveyTable, Release, RequiredNeighbours | VULCANiDR | the unique identifier for the survey | int | 4 | meta.id | ||
| surveyID | ObjectThin | PS1DR2 | Survey identifier. Details in the Survey table. | tinyint | 1 | meta.id | ||
| surveyID | Survey, SurveyProgrammes | VULCANiDR | The unique identifier for the curated survey | int | 4 | meta.id | ||
| surveyName | ExternalSurvey | VULCANiDR | The short name of the survey, eg. 2MASS, GLIMPSE etc. | varchar | 32 | ?? | ||
| surveyName | allSkyNIRFrameSetInfo | VULCANiDR | Name of survey, e.g. VHS, LAS, etc | varchar | 16 | |||
| sys_flg | twomass_xsc | TWOMASS | system flag: 0=no system, 1=nearby galaxy flux incl. in mag. | smallint | 2 | meta.code | ||