TABLE gaia_source

Contains the parameters provided for each source in Gaia Data Release 2.

Main Gaia catalogue containing astrometric and photometric information
for each source. The table has an entry for every Gaia observed source as
listed in the Main Database accumulating catalogue version from which the
catalogue release has been generated. It contains the basic source parameters,
that is only final data (no epoch data) and no spectra (neither final nor epoch).

Required constraints:
Primary key is (source_id)

Name Type Length Unit Description Default Value Unified Content Descriptor

solution_id bigint 8 Solution identifier meta.id;meta.version

designation char 32 Unique source designation (unique across all Data Releases) meta.id;meta.main

source_id bigint 8 Unique source identifier (unique within a particular Data Release) meta.id

random_index bigint 8 Random index used to select subsets meta.code

ref_epoch real 4 Julian years Reference epoch meta.ref;time.epoch

ra float 8 degrees Celestial Right Ascension pos.eq.ra;meta.main

ra_error float 8 milliarcsec Standard error of Right Ascension stat.error;pos.eq.ra

dec float 8 degrees Celestial Declination pos.eq.dec;meta.main

dec_error float 8 milliarcsec Standard error of Declination stat.error;pos.eq.dec

parallax float 8 milliarcsec Parallax pos.parallax

parallax_error float 8 milliarcsec Standard error of parallax stat.error;pos.parallax

parallax_over_error real 4 Parallax divided by standard error arith.ratio

pmra float 8 milliarcsec/year Proper motion in Right Ascension direction pos.pm;.pos.eq.ra

pmra_error float 8 milliarcsec/year Error of proper motion in Right Ascension direction stat.error;pos.pm;.pos.eq.ra

pmdec float 8 milliarcsec/year Proper motion in Declination direction pos.pm;.pos.eq.dec

pmdec_error float 8 milliarcsec/year Error of proper motion in Declination direction stat.error;pos.pm;.pos.eq.dec

ra_dec_corr real 4 Correlation between Right Ascension and Declination stat.correlation;pos.eq.ra;pos.eq.dec

ra_parallax_corr real 4 Correlation between Right Ascension and parallax stat.correlation;pos.eq.ra;pos.parallax

ra_pmra_corr real 4 Correlation between Right Ascension and proper motion in Right Ascension stat.correlation;pos.eq.ra;pos.pm;pos.eq.ra

ra_pmdec_corr real 4 Correlation between Right Ascension and proper motion in Declination stat.correlation;pos.eq.ra;pos.pm;pos.eq.dec

dec_parallax_corr real 4 Correlation between Declination and parallax stat.correlation;pos.eq.dec;pos.parallax

dec_pmra_corr real 4 Correlation between Declination and proper motion in Right Ascension stat.correlation;pos.eq.dec;pos.pm;pos.eq.ra

dec_pmdec_corr real 4 Correlation between Declination and proper motion in Declination stat.correlation;pos.eq.dec;pos.pm;pos.eq.dec

parallax_pmra_corr real 4 Correlation between parallax and proper motion in Right Ascension stat.correlation;pos.parallax;pos.pm;pos.eq.ra

parallax_pmdec_corr real 4 Correlation between parallax and proper motion in Declination stat.correlation;pos.parallax;pos.pm;pos.eq.dec

pmra_pmdec_corr real 4 Correlation between proper motion in Right Ascension and proper motion in Declination stat.correlation;pos.pm;pos.eq.ra;pos.pm;pos.eq.dec

astrometric_n_obs_al int 4 Total number of observations in the Along-Scan direction meta.number

astrometric_n_obs_ac int 4 Total number of observations in the Across-Scan direction meta.number

astrometric_n_good_obs_al int 4 Number of good observations in the Along-Scan direction meta.number

astrometric_n_bad_obs_al int 4 Number of bad observations in the Along-Scan direction meta.number

astrometric_gof_al real 4 Goodness of fit statistic of model wrt Along-Scan observations stat.fit.goodness

astrometric_chi2_al real 4 Along-Scan chi-square value stat.fit.chi2

astrometric_excess_noise float 8 milliarcsec Excess noise of the source stat.value

astrometric_excess_noise_sig float 8 Significance of the excess noise stat.value

astrometric_params_solved tinyint 1 Which parameters have been solved for? meta.number

astrometric_primary_flag tinyint 1 Primary or secondary meta.code.status

astrometric_weight_al real 4 mas^-2 Mean astrometric weight of the source Along-Scan stat.weight;stat.mean

astrometric_pseudo_colour real 4 micron^-1 Astrometrically determined pseudocolour of the source em.wavenumber

astrometric_pseudo_colour_error real 4 micron^-1 STandard error of the pseudocolour of the source em.wavenumber

mean_varpi_factor_al real 4 Mean parallax factor Along-Scan stat.mean;pos.parallax;arith.factor

astrometric_matched_observations smallint 2 Matched FoV transits used in the AGIS solution meta.number

visibility_periods_used smallint 2 Number of visibility periods uased in the astrometric solution meta.number

astrometric_sigma_5d_max real 4 mas The longest semi-major axis of the 5d error ellipsoid pos.errorEllipse;stat.max

frame_rotator_object_type int 4 The type of the source mainly used for frame rotation meta.code

matched_observations smallint 2 The number of observations matched to this source meta.number

duplicated_source tinyint 1 Source with duplicated sources meta.code.status

phot_g_n_obs int 4 Number of observations contributing to G band photometry meta.number

phot_g_mean_flux float 8 electrons/s G-band mean flux phot.flux;stat.mean;em.opt

phot_g_mean_flux_error float 8 electrons/s Error on G-band mean flux stat.error;phot.flux;stat.mean;em.opt

phot_g_mean_flux_over_error float 8 G-band mean flux divided by its standard error arith.ratio

phot_g_mean_mag real 4 mag G-band mean magnitude phot.mag;stat.mean;em.opt

phot_bp_n_obs int 4 Number of observations contributing to BP photometry meta.number

phot_bp_mean_flux float 8 electrons/s Integrated BP mean flux phot.flux;stat.mean

phot_bp_mean_flux_error float 8 electrons/s Standard error on the integrated BP mean flux stat.error;phot.flux;stat.mean

phot_bp_mean_flux_over_error real 4 Integrated mean BP flux divided by its standard error arith.ratio

phot_bp_mean_mag real 4 mag Integrated BP mean magnitude phot.mag;stat.mean

phot_rp_n_obs int 4 Number of observations contributing to RP photometry meta.number

phot_rp_mean_flux float 8 electrons/s Integrated RP mean flux phot.flux;stat.mean

phot_rp_mean_flux_error float 8 electrons/s Standard error on the integrated RP mean flux stat.error;phot.flux;stat.mean

phot_rp_mean_flux_over_error real 4 Integrated mean RP flux divided by its standard error arith.ratio

phot_rp_mean_mag real 4 mag Integrated RP mean magnitude phot.mag;stat.mean

phot_bp_rp_excess_factor real 4 Combined BP and RP excess factor

phot_proc_mode tinyint 1 Photometry processing mode meta.code

bp_rp real 4 mag BP-RP colour phot.colour

bp_g real 4 mag BP-G colour phot.colour

g_rp real 4 mag G-RP colour phot.colour

radial_velocity real 4 km/s Radial velocity spect.dopplerVeloc.opt

radial_velocity_error real 4 km/s Standard error on the radial velocity stat.error;spect.dopplerVeloc.opt

rv_nb_transits int 4 Number of transits used to compute the radial velocity meta.number

rv_template_teff real 4 K Teff of the template used to compute radial velocity stat.fit.param

rv_template_logg real 4 log cgs log g of the template used to compute the radial velocity stat.fit.param

rv_template_fe_h real 4 dex Fe/H of the template used to compute radial velocity stat.fit.param

phot_variable_flag char 16 Photometric variability flag meta.code;src.var

l float 8 degrees Galactic longitude pos.galactic.lon

b float 8 degrees Galactic latitude pos.galactic.lat

ecl_lon float 8 degrees Ecliptic longitude pos.ecliptic.lon

ecl_lat float 8 degrees Ecliptic latitude pos.ecliptic.lat

priam_flags bigint 8 Flags from Apsis-Priam analysis meta.code

teff_val real 4 K Stellar effective temperature phys.temperature.effective

teff_percentile_lower real 4 K Lower uncertainty on teff_val phys.temperature.effective;stat.min

teff_percentile_upper real 4 K Upper uncertainty on teff_val phys.temperature.effective;stat.max

a_g_val real 4 mag Line-of-sight extinction in the G band, A_G phys.absorption.gal

a_g_percentile_lower real 4 mag Lower uncertainty on A_G phys.absorption.gal;stat.min

a_g_percentile_upper real 4 mag Upper uncertainty on A_G phys.absorption.gal;stat.max

e_bp_min_rp_val real 4 mag Line-of-sight reddening E(BP-RP)

e_bp_min_rp_percentile_lower real 4 mag Lower uncertainty on e_bp_min_rp_val

e_bp_min_rp_percentile_Upper real 4 mag Upper uncertainty on e_bp_min_rp_val

flame_flags bigint 8 Flags from Apsis-FLAME analysis meta.code

radius_val real 4 Solar radius Stellar radius phys.size.radius

radius_percentile_lower real 4 Solar radius Lower uncertainty on stellar radius phys.size.radius;stat.min

radius_percentile_upper real 4 Solar radius Upper uncertainty on stellar radius phys.size.radius;stat.max

lum_val real 4 Solar luminosity Stellar luminosity phys.luminosity

lum_percentile_lower real 4 Solar luminosity Lower uncertainty on stellar luminosity phys.luminosity;stat.min

lum_percentile_upper real 4 Solar luminosity Upper uncertainty on stellar luminosity phys.luminosity;stat.max

cx float 8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.x

cy float 8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.y

cz float 8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.z

htmID bigint 8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates pos.eq

Total length 542

Name	Type	Length	Unit	Description	Unified Content Descriptor
solution_id	bigint	8		Solution identifier	meta.id;meta.version
designation	char	32		Unique source designation (unique across all Data Releases)	meta.id;meta.main
source_id	bigint	8		Unique source identifier (unique within a particular Data Release)	meta.id
random_index	bigint	8		Random index used to select subsets	meta.code
ref_epoch	real	4	Julian years	Reference epoch	meta.ref;time.epoch
ra	float	8	degrees	Celestial Right Ascension	pos.eq.ra;meta.main
ra_error	float	8	milliarcsec	Standard error of Right Ascension	stat.error;pos.eq.ra
dec	float	8	degrees	Celestial Declination	pos.eq.dec;meta.main
dec_error	float	8	milliarcsec	Standard error of Declination	stat.error;pos.eq.dec
parallax	float	8	milliarcsec	Parallax	pos.parallax
parallax_error	float	8	milliarcsec	Standard error of parallax	stat.error;pos.parallax
parallax_over_error	real	4		Parallax divided by standard error	arith.ratio
pmra	float	8	milliarcsec/year	Proper motion in Right Ascension direction	pos.pm;.pos.eq.ra
pmra_error	float	8	milliarcsec/year	Error of proper motion in Right Ascension direction	stat.error;pos.pm;.pos.eq.ra
pmdec	float	8	milliarcsec/year	Proper motion in Declination direction	pos.pm;.pos.eq.dec
pmdec_error	float	8	milliarcsec/year	Error of proper motion in Declination direction	stat.error;pos.pm;.pos.eq.dec
ra_dec_corr	real	4		Correlation between Right Ascension and Declination	stat.correlation;pos.eq.ra;pos.eq.dec
ra_parallax_corr	real	4		Correlation between Right Ascension and parallax	stat.correlation;pos.eq.ra;pos.parallax
ra_pmra_corr	real	4		Correlation between Right Ascension and proper motion in Right Ascension	stat.correlation;pos.eq.ra;pos.pm;pos.eq.ra
ra_pmdec_corr	real	4		Correlation between Right Ascension and proper motion in Declination	stat.correlation;pos.eq.ra;pos.pm;pos.eq.dec
dec_parallax_corr	real	4		Correlation between Declination and parallax	stat.correlation;pos.eq.dec;pos.parallax
dec_pmra_corr	real	4		Correlation between Declination and proper motion in Right Ascension	stat.correlation;pos.eq.dec;pos.pm;pos.eq.ra
dec_pmdec_corr	real	4		Correlation between Declination and proper motion in Declination	stat.correlation;pos.eq.dec;pos.pm;pos.eq.dec
parallax_pmra_corr	real	4		Correlation between parallax and proper motion in Right Ascension	stat.correlation;pos.parallax;pos.pm;pos.eq.ra
parallax_pmdec_corr	real	4		Correlation between parallax and proper motion in Declination	stat.correlation;pos.parallax;pos.pm;pos.eq.dec
pmra_pmdec_corr	real	4		Correlation between proper motion in Right Ascension and proper motion in Declination	stat.correlation;pos.pm;pos.eq.ra;pos.pm;pos.eq.dec
astrometric_n_obs_al	int	4		Total number of observations in the Along-Scan direction	meta.number
astrometric_n_obs_ac	int	4		Total number of observations in the Across-Scan direction	meta.number
astrometric_n_good_obs_al	int	4		Number of good observations in the Along-Scan direction	meta.number
astrometric_n_bad_obs_al	int	4		Number of bad observations in the Along-Scan direction	meta.number
astrometric_gof_al	real	4		Goodness of fit statistic of model wrt Along-Scan observations	stat.fit.goodness
astrometric_chi2_al	real	4		Along-Scan chi-square value	stat.fit.chi2
astrometric_excess_noise	float	8	milliarcsec	Excess noise of the source	stat.value
astrometric_excess_noise_sig	float	8		Significance of the excess noise	stat.value
astrometric_params_solved	tinyint	1		Which parameters have been solved for?	meta.number
astrometric_primary_flag	tinyint	1		Primary or secondary	meta.code.status
astrometric_weight_al	real	4	mas^-2	Mean astrometric weight of the source Along-Scan	stat.weight;stat.mean
astrometric_pseudo_colour	real	4	micron^-1	Astrometrically determined pseudocolour of the source	em.wavenumber
astrometric_pseudo_colour_error	real	4	micron^-1	STandard error of the pseudocolour of the source	em.wavenumber
mean_varpi_factor_al	real	4		Mean parallax factor Along-Scan	stat.mean;pos.parallax;arith.factor
astrometric_matched_observations	smallint	2		Matched FoV transits used in the AGIS solution	meta.number
visibility_periods_used	smallint	2		Number of visibility periods uased in the astrometric solution	meta.number
astrometric_sigma_5d_max	real	4	mas	The longest semi-major axis of the 5d error ellipsoid	pos.errorEllipse;stat.max
frame_rotator_object_type	int	4		The type of the source mainly used for frame rotation	meta.code
matched_observations	smallint	2		The number of observations matched to this source	meta.number
duplicated_source	tinyint	1		Source with duplicated sources	meta.code.status
phot_g_n_obs	int	4		Number of observations contributing to G band photometry	meta.number
phot_g_mean_flux	float	8	electrons/s	G-band mean flux	phot.flux;stat.mean;em.opt
phot_g_mean_flux_error	float	8	electrons/s	Error on G-band mean flux	stat.error;phot.flux;stat.mean;em.opt
phot_g_mean_flux_over_error	float	8		G-band mean flux divided by its standard error	arith.ratio
phot_g_mean_mag	real	4	mag	G-band mean magnitude	phot.mag;stat.mean;em.opt
phot_bp_n_obs	int	4		Number of observations contributing to BP photometry	meta.number
phot_bp_mean_flux	float	8	electrons/s	Integrated BP mean flux	phot.flux;stat.mean
phot_bp_mean_flux_error	float	8	electrons/s	Standard error on the integrated BP mean flux	stat.error;phot.flux;stat.mean
phot_bp_mean_flux_over_error	real	4		Integrated mean BP flux divided by its standard error	arith.ratio
phot_bp_mean_mag	real	4	mag	Integrated BP mean magnitude	phot.mag;stat.mean
phot_rp_n_obs	int	4		Number of observations contributing to RP photometry	meta.number
phot_rp_mean_flux	float	8	electrons/s	Integrated RP mean flux	phot.flux;stat.mean
phot_rp_mean_flux_error	float	8	electrons/s	Standard error on the integrated RP mean flux	stat.error;phot.flux;stat.mean
phot_rp_mean_flux_over_error	real	4		Integrated mean RP flux divided by its standard error	arith.ratio
phot_rp_mean_mag	real	4	mag	Integrated RP mean magnitude	phot.mag;stat.mean
phot_bp_rp_excess_factor	real	4		Combined BP and RP excess factor
phot_proc_mode	tinyint	1		Photometry processing mode	meta.code
bp_rp	real	4	mag	BP-RP colour	phot.colour
bp_g	real	4	mag	BP-G colour	phot.colour
g_rp	real	4	mag	G-RP colour	phot.colour
radial_velocity	real	4	km/s	Radial velocity	spect.dopplerVeloc.opt
radial_velocity_error	real	4	km/s	Standard error on the radial velocity	stat.error;spect.dopplerVeloc.opt
rv_nb_transits	int	4		Number of transits used to compute the radial velocity	meta.number
rv_template_teff	real	4	K	Teff of the template used to compute radial velocity	stat.fit.param
rv_template_logg	real	4	log cgs	log g of the template used to compute the radial velocity	stat.fit.param
rv_template_fe_h	real	4	dex	Fe/H of the template used to compute radial velocity	stat.fit.param
phot_variable_flag	char	16		Photometric variability flag	meta.code;src.var
l	float	8	degrees	Galactic longitude	pos.galactic.lon
b	float	8	degrees	Galactic latitude	pos.galactic.lat
ecl_lon	float	8	degrees	Ecliptic longitude	pos.ecliptic.lon
ecl_lat	float	8	degrees	Ecliptic latitude	pos.ecliptic.lat
priam_flags	bigint	8		Flags from Apsis-Priam analysis	meta.code
teff_val	real	4	K	Stellar effective temperature	phys.temperature.effective
teff_percentile_lower	real	4	K	Lower uncertainty on teff_val	phys.temperature.effective;stat.min
teff_percentile_upper	real	4	K	Upper uncertainty on teff_val	phys.temperature.effective;stat.max
a_g_val	real	4	mag	Line-of-sight extinction in the G band, A_G	phys.absorption.gal
a_g_percentile_lower	real	4	mag	Lower uncertainty on A_G	phys.absorption.gal;stat.min
a_g_percentile_upper	real	4	mag	Upper uncertainty on A_G	phys.absorption.gal;stat.max
e_bp_min_rp_val	real	4	mag	Line-of-sight reddening E(BP-RP)
e_bp_min_rp_percentile_lower	real	4	mag	Lower uncertainty on e_bp_min_rp_val
e_bp_min_rp_percentile_Upper	real	4	mag	Upper uncertainty on e_bp_min_rp_val
flame_flags	bigint	8		Flags from Apsis-FLAME analysis	meta.code
radius_val	real	4	Solar radius	Stellar radius	phys.size.radius
radius_percentile_lower	real	4	Solar radius	Lower uncertainty on stellar radius	phys.size.radius;stat.min
radius_percentile_upper	real	4	Solar radius	Upper uncertainty on stellar radius	phys.size.radius;stat.max
lum_val	real	4	Solar luminosity	Stellar luminosity	phys.luminosity
lum_percentile_lower	real	4	Solar luminosity	Lower uncertainty on stellar luminosity	phys.luminosity;stat.min
lum_percentile_upper	real	4	Solar luminosity	Upper uncertainty on stellar luminosity	phys.luminosity;stat.max
cx	float	8		unit vector of spherical co-ordinates	pos.distance;pos.cartesian.x
cy	float	8		unit vector of spherical co-ordinates	pos.distance;pos.cartesian.y
cz	float	8		unit vector of spherical co-ordinates	pos.distance;pos.cartesian.z
htmID	bigint	8		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates	pos.eq
Total length		542