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