Archives of Photographic PLates for Astronomical USE

Crossmatch helper table (applause_dr4.source_xmatch)

The table has 3913953289 rows, 13 columns.

Description

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

Attribution

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.

Columns

Name Type UCD Unit Description
source_id long meta.id
meta.main

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

process_id int meta.id

Process identification number

scan_id int meta.id

Scan identification number

plate_id int meta.id

Plate identification number

archive_id int meta.id

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