APASS DR9 Join (gaiaedr3.apassdr9_join)

The table has 61176394 rows, 2 columns.


Convenience table to be used to join the APASS DR9 catalogue with the cross-match results. The table links the external catalogue original sourceId (originalExtSourceId) to the corresponding additional numerical identifier (cleanApassdr9Oid).Both originalExtSourceId and cleanApassdr9Oid are present in the cross-match output tables (Apassdr9BestNeighbour and Apassdr9Neighbourhood). However, in case there are suspected duplicates in the external catalogue, different originalExtSourceId will correspond to the same cleanApassdr9Oid.In the cross-match output table only the originalExtSourceId of the source with the best astrometry among the suspected duplicates will be listed. In practice, users may use the originalExtSourceId in the original catalogue to find the matching source with the best astrometry. Users interested in all matching suspected duplicates should instead use the cleanApassdr9Oid in the join with the cross-match result tables.See ChapterĀ [chap:crossmatch] for more details on the duplicates in the external catalogues and their treatment in the cross-match computations.


If you have used Gaia data in your research, please use the following acknowledgement:

This work has made use of data from the European Space Agency (ESA) mission Gaia (https://www.cosmos.esa.int/gaia), processed by the Gaia Data Processing and Analysis Consortium (DPAC, https://www.cosmos.esa.int/web/gaia/dpac/consortium). Funding for the DPAC has been provided by national institutions, in particular the institutions participating in the Gaia Multilateral Agreement.

More information can be found on the credit and citation instructions page.


Name Type UCD Unit Description
original_ext_source_id long meta.id.cross

Original External Catalogue source identifier

clean_apassdr9_oid int meta.id.cross

External Catalogue source identifier