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

M
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
masterObjID	allSkyNIRSourceNeighbours, allSkyNIRSourceXDR13PhotoObj, allSkyNIRSourceXDR13PhotoObjAll, allSkyNIRSourceXGEDR3gaia_source, allSkyNIRSourceXPS1DR2_objectThin, allSkyNIRSourceXSSASource, allSkyNIRSourceXallwise_sc, allSkyNIRSourceXtwomass_psc, allSkyNIRSourceXtwomass_xsc, allSkyNIRSourceXtwompzPhotoz, allSkyNIRSourceXwiseScosPhotoz, allSkyNIRSourceXwise_allskysc	VULCANiDR	The unique ID in allSkyNIRSource (=sourceID)	bigint	8			meta.id;meta.main
matched_transits	gaia_source	GAIADR3	The number of transits matched to this source	smallint	2			meta.number
matched_transits_removed	gaia_source	GAIADR3	The number of transits removed from an existing source in the current cycle	smallint	2			meta.number
maxDec	CurrentAstrometry	VULCANiDR	The maximum Dec (J2000) on the device	float	8	Degrees	-0.9999995e9	pos.eq.dec;meta.main
maxRa	CurrentAstrometry	VULCANiDR	The maximum RA (J2000) on the device	float	8	Degrees	-0.9999995e9	pos.eq.ra
mdetID	catwise_2020, catwise_prelim	WISE	source ID in mdet list	int	4
MeanObsMJD	catwise_2020, catwise_prelim	WISE	mean observation epoch	float	8	MJD
mergedClass	allSkyNIRSource	VULCANiDR	Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated)	smallint	2			meta.code
			Individual detection classifications are combined in the source merging process to produce a set of attributes for each merged source as follows. Presently, a basic classification table is defined that assigns reasonably accurate, self-consistent probability values for a given classification code: Flag Meaning Probability (%) Star Galaxy Noise Saturated -9 Saturated 0.0 0.0 5.0 95.0 -3 Probable galaxy 25.0 70.0 5.0 0.0 -2 Probable star 70.0 25.0 5.0 0.0 -1 Star 90.0 5.0 5.0 0.0 0 Noise 5.0 5.0 90.0 0.0 +1 Galaxy 5.0 90.0 5.0 0.0 Then, each separately available classification is combined for a merged source using Bayesian classification rules, assuming each datum is independent: P(classk)=ΠiP(classk)i / ΣkΠiP(classk)i where classk is one of star|galaxy|noise|saturated, and i denotes the ith single detection passband measurement available (the non-zero entries are necessary for the independent measures method to work, since some cases might otherwise be mutually exclusive). For example, if an object is classed in J|H|K as -1|-2|+1 it would have merged classification probabilities of pStar=73.5%, pGalaxy=26.2%, pNoise=0.3% and pSaturated=0.0%. Decision thresholds for the resulting discrete classification flag mergedClass are 90% for definitive and 70% for probable; hence the above example would be classified (not unreasonably) as probably a star (mergedClass=-2). An additional decision rule enforces mergedClass=-9 (saturated) when any individual classification flag indicates saturation.
mergedClassStat	allSkyNIRSource	VULCANiDR	Merged N(0,1) stellarness-of-profile statistic/SExtractor STAR_CLASS	real	4		-0.9999995e9	stat
			This profile classification statistic is a continuously distributed, Gaussian N(0,1) (i.e. zero mean, unit variance) statistic formed from the available individual classification statistics by averaging them and multiplying by N1/2 such that cuts on mergedClassStat result in completeness being independent of number of frames an object appears on, but with reliability improving with the number of frames.
mergeLogTable	Programme	VULCANiDR	Table name of curation log for source merging	varchar	64			??
mh_gspphot	gaia_source	GAIADR3	Iron abundance from GSP-Phot Aeneas best library using BP/RP spectra	real	4			phys.abund.Z
mh_gspphot_lower	gaia_source	GAIADR3	Lower confidence level (16%) of iron abundance from GSP-Phot Aeneas best library using BP/RP spectra	real	4			phys.abund.Z;stat.min
mh_gspphot_upper	gaia_source	GAIADR3	Upper confidence level (84%) of iron abundance from GSP-Phot Aeneas best library using BP/RP spectra	real	4			phys.abund.Z;stat.max
minDec	CurrentAstrometry	VULCANiDR	The minimum Dec (J2000) on the device	float	8	Degrees	-0.9999995e9	pos.eq.dec;meta.main
minRa	CurrentAstrometry	VULCANiDR	The minimum RA (J2000) on the device	float	8	Degrees	-0.9999995e9	pos.eq.ra
momentM3C	Detection	PS1DR2	Cosine of trefoil second moment term: r^2 cos(3 theta) = M_xxx - 3 * M_xyy.	real	4	arcsec^2	-999
momentM3S	Detection	PS1DR2	Sine of trefoil second moment: r^2 sin (3 theta) = 3 * M_xxy - M_yyy.	real	4	arcsec^2	-999
momentM4C	Detection	PS1DR2	Cosine of quadrupole second moment: r^2 cos (4 theta) = M_xxxx - 6 * M_xxyy + M_yyyy.	real	4	arcsec^2	-999
momentM4S	Detection	PS1DR2	Sine of quadrupole second moment: r^2 sin (4 theta) = 4 * M_xxxy - 4 * M_xyyy.	real	4	arcsec^2	-999
momentR1	Detection	PS1DR2	First radial moment.	real	4	arcsec	-999
momentRH	Detection	PS1DR2	Half radial moment (r^0.5 weighting).	real	4	arcsec^0.5	-999
momentXX	Detection	PS1DR2	Second moment M_xx.	real	4	arcsec^2	-999
momentXY	Detection	PS1DR2	Second moment M_xy.	real	4	arcsec^2	-999
momentYY	Detection	PS1DR2	Second moment M_yy.	real	4	arcsec^2	-999
moon_lev	allwise_sc	WISE	Scattered moonlight contamination flag. This is a four-character string, one character per band, in which the value is an integer indicates the fraction of single-exposure frames on which the source was measured that were possibly contaminated by scattered moonlight. The value in each band is given by [ceiling(#frmmoon/#frames*10)], with a maximum value of 9, where #frmmoon is the number of affected frames and #frames is the total number of frames on which the source was measured.	varchar	4
moon_lev	wise_allskysc	WISE	Scattered moonlight contamination flag. This is a four-character string, one character per band, in which the value is an integer indicates the fraction of single-exposure frames on which the source was measured that were possibly contaminated by scattered moonlight. The value in each band is given by [ceiling(#frmmoon/#frames*10)], with a maximum value of 9, where #frmmoon is the number of affected frames and #frames is the total number of frames on which the source was measured.	char	4
mp_flg	twomass_psc	TWOMASS	Minor Planet Flag.	smallint	2			meta.code
mp_flg	twomass_sixx2_psc	TWOMASS	src is positionally associated with an asteroid, comet, etc	smallint	2
mp_key	twomass_xsc	TWOMASS	key to minor planet prediction DB record.	int	4			meta.id
muDec	allSkyNIRSource	VULCANiDR	Proper motion in Dec direction	real	4	mas/yr	-0.9999995e9	pos.eq.dec;pos.pm
multiframeID	AstrometricInfo	VULCANiDR	the UID of the relevant multiframe	bigint	8			meta.id;obs.field
multiframeID	CurrentAstrometry, MultiframeDetector	VULCANiDR	the UID of the relevant multiframe	bigint	8		-99999999	obs.field
multiframeID	Multiframe	VULCANiDR	UID of the multiframe (assigned sequentially by the archive ingest process)	bigint	8		-99999999	meta.main;meta.id
muRa	allSkyNIRSource	VULCANiDR	Proper motion in RA direction	real	4	mas/yr	-0.9999995e9	pos.eq.ra;pos.pm