dp2_prompt

Version: 1.1.1

Prompt products tables from Data Preview 2 for testing in the PPDB BigQuery database.

Tables

name	description	columns
DiaSource	Properties of transient-object detections on the single-epoch difference images.	90
DiaObject	Properties of time-varying astronomical objects based on association of data from one or more spatially-related DiaSource detections on individual single-epoch difference images.	64
ForcedSourceOnDiaObject	Point-source forced-photometry measurements on individual single-epoch visit images and difference images, based on and linked to the entries in the DiaObject table.	26
SSObject	LSST-computed per-object quantities.	80
SSSource	LSST-computed per-source quantities. 1::1 relationship with DiaSource.	39
mpc_orbits	Table of orbital elements and related information of known (sun-orbiting and unbound) Solar System objects. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.	53
current_identifications	All single-designations, and all identifications between designations. Always uses primary provisional designation (even for numbered objects). Includes all comets and satellites. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.	10
numbered_identifications	The numbered identification table contains all the numbered objects (minor planets, comets and natural satellites) with their primary provisional designations. The table is continously updated everytime a new object is numbered. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.	9