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