20.4.5 apassdr9_join

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

Columns description:

original_ext_source_id : Original External Catalogue source identifier (long)

The unique source identifier in the original external catalogue.

clean_apassdr9_oid : External Catalogue source identifier (int)

The additional numeric source identifier of the external catalogue, increasing with Declination.