skip to main content

gaia data release 3 documentation

20.15 Differences between the Gaia DR3 and EDR3/DR2 data models

20.15.3 Table changes between Gaia EDR3 and Gaia DR2

The following differences in the preliminary Gaia EDR3 with respect to Gaia DR2 should be noted (some of these older changes have been superseded in Gaia DR3 of course — see above):

Main catalogue tables

The following Gaia DR2 table was not present in Gaia EDR3:

  • ruwe.

The single parameter contained therein, namely the renormalised unit–weight error, was included in gaia_source No further tables have been added in this part of the data model.

Solar system object tables

The following Gaia DR2 tables were not present in Gaia EDR3:

  • sso_observation;

  • sso_source.

No further tables were added in this part of the data model.

Variability tables

The following Gaia DR2 tables were not present in Gaia EDR3:

  • vari_cepheid;

  • vari_classifier_class_definition;

  • vari_classifier_definition;

  • vari_classifier_result;

  • vari_long_period_variable;

  • vari_rotation_modulation;

  • vari_rrlyrae;

  • vari_short_timescale;

  • vari_time_series_statistics.

No further tables have been added in this part of the data model.

External catalogues

External catalogue tables added at Gaia EDR3 were:

  • tycho2_tdsc_merge: a merge of the Tycho2 (Høg et al. 2000) and Tycho Double Star (TDSC; Fabricius et al. 2002) catalogues

At Gaia DR2 the data model descriptions for external catalogues served through the Gaia archive included those released and documented with Gaia DR1. For Gaia EDR3 we did not duplicate these descriptions, but users should note that the external catalogue tables themselves remain available in the archive for use in conjunction with the crossmatch tables. Moreover the associated online data model documentation remains available (Hambly et al. 2018a).

Crossmatches

The following Gaia DR2 tables are no longer present from Gaia EDR3 onwards:

  • sdssdr9_best_neighbour (superseded by SDSS DR13 – see below);

  • sdssdr9_neighbourhood (superseded by SDSS DR13 – see below);

  • tmass_best_neighbour (superseded by 2MASS PSC/XSC combined – see below);

  • tmass_neighbourhood (superseded by 2MASS PSC/XSC combined – see below);

  • tycho2_best_neighbour (superseded by Tycho2/TDSC combined – see below);

  • tycho2_neighbourhood (superseded by Tycho2/TDSC combined – see below).

The following tables were added at Gaia EDR3:

  • panstarrs1_join;

  • sdssdr13_best_neighbour;

  • sdssdr13_neighbourhood;

  • sdssdr13_join;

  • skymapperdr2_best_neighbour;

  • skymapperdr2_neighbourhood;

  • skymapperdr2_join;

  • tycho2_tdsc_merge_best_neighbour;

  • tycho2_tdsc_merge_neighbourhood;

  • tmass_psc_xsc_best_neighbour;

  • tmass_psc_xsc_neighbourhood;

  • tmass_psc_xsc_join;

  • allwise_best_neighbour;

  • allwise_neighbourhood;

  • apassdr9_best_neighbour;

  • apassdr9_neighbourhood;

  • gsc23_best_neighbour;

  • gsc23_neighbourhood;

  • gsc23_join;

  • ravedr5_best_neighbour;

  • ravedr5_neighbourhood;

  • ravedr5_join.

Auxiliary tables

The following Gaia DR2 tables were not present in Gaia EDR3:

  • aux_allwise_agn_gdr2_cross_id (superseded – see below);

  • aux_iers_gdr2_cross_id (superseded – see below);

  • aux_sso_orbit_residuals;

  • aux_sso_orbits;

  • dr1_neighbourhood (superseded – see below).

The following Gaia EDR3 tables were added:

  • agn_cross_id;

  • commanded_scan_law;

  • dr2_neighbourhood;

  • frame_rotator_source;

  • gaia_source_simulation (see Section 2.3);

  • gaia_universe_model (see Section 2.2).

Datalink tables

The following Gaia DR2 tables were not present in Gaia EDR3:

  • light_curve;

  • epoch_photometry.

Datalink resources (enormously expanded over those available at Gaia DR2) appear in Gaia DR3.