Panstarrs1 Join (gaiaedr3.panstarrs1_join)

The table has 2264263168 rows, 2 columns.


Convenience table to be used to join Pan-STARRS1 DR1.1 catalogue with the cross-match results. The table links the external catalogue original sourceId (originalExtSourceId) to the corresponding the additional numerical identifier (cleanPanstarrs1Oid). Both originalExtSourceId and cleanPanstarrs1Oid are present in the cross-match output tables (panstarrs1BestNeighbour and panstarrs1Neighbourhood). However, in case there are suspected duplicates in the external catalogue, different originalExtSourceId will correspond to the same cleanPanstarrs1Oid. 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 to find all matching suspected duplicates should instead use the cleanPanstarrs1Oid in the join with the cross-match result tables.

See Documentation, Chapter 8, 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 (, processed by the Gaia Data Processing and Analysis Consortium (DPAC, 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 Dimensionless Original External Catalogue source identifier
clean_panstarrs1_oid long Dimensionless External Catalogue source identifier