Archives of Photographic PLates for Astronomical USE

Crossmatch helper table (applause_dr4.source_xmatch)

The table has 3913953289 rows, 13 columns.


Crossmatch helper table, assembles plate_id, source_id, scan_id, process_id, gaiaedr3_id and crossmatch values like dist, coordinates


If you have made substantial use of the data provided by APPLAUSE DR4, kindly include this acknowledgement

Funding for APPLAUSE has been provided by DFG (German Research Foundation, Grant), Leibniz Institute for Astrophysics Potsdam (AIP), Dr. Remeis Sternwarte Bamberg (University Nürnberg/Erlangen), the Hamburger Sternwarte (University of Hamburg) and Tartu Observatory. Plate material also has been made available from Thüringer Landessternwarte Tautenburg, and from the archives of the Vatican Observatory.


Name Type UCD Unit Description
source_id long

Source identification number. The number is constructed as follows: process_id x 10000000 + source number in the image.

process_id int

Process identification number

scan_id int

Scan identification number

plate_id int

Plate identification number

archive_id int

Archive identification number

dist float
solution_num short meta.number

Number of the solution within the solution set

gaiaedr3_id long
x_gaia double
y_gaia double
flag_xmatch short
timestamp_insert char time.creation Time[yyyy-mm-dd hh:mm:ss]

Timestamp of insert

timestamp_update char time.creation Time[yyyy-mm-dd hh:mm:ss]

Timestamp of update