LSSTCam Data Release

Default schema for outputs of the LSSTCam Data Release Production Pipeline. It is used in the CI testing of the pipelines, and as basis for specific data release schemas.

Object

Descriptions of static astronomical objects (or the static aspects of variable and slowly-moving objects) detected and measured on coadds.

Indexes
Columns Description Reference Name
objectId Unique index on objectId column idx_Object_objectId
Column Name Data Type Unit Description UCD Order Principal

Source

Properties of detections on the single-epoch visit images, performed independently of the Object detections on coadded images.

Indexes
Columns Description Reference Name
sourceId Unique index on sourceId column idx_Source_sourceId
Column Name Data Type Unit Description UCD Order Principal

ForcedSource

Forced-photometry measurements on individual single-epoch visit images and difference images, based on and linked to the entries in the Object table. Point-source PSF photometry is performed, based on coordinates from a reference band chosen for each Object and reported in the Object.refBand column.

Indexes
Columns Description Reference Name
objectId Non-unique index on the objectId column; accelerates retrieval of light curves for Objects idx_ForcedSource_objectId
Column Name Data Type Unit Description UCD Order Principal

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.

Indexes
Columns Description Reference Name
diaObjectId Unique index on the diaObjectId column idx_DiaObject_diaObjectId
Column Name Data Type Unit Description UCD Order Principal

DiaSource

Properties of transient-object detections on the single-epoch difference images.

Indexes
Columns Description Reference Name
diaObjectId Non-unique index on the diaObjectId column; accelerates retrieval of light curves for DiaObjects idx_DiaSource_diaObjectId
Column Name Data Type Unit Description UCD Order Principal

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.

Indexes
Columns Description Reference Name
diaObjectId Non-unique index on the diaObjectId column; accelerates retrieval of light curves for DiaObjects idx_ForcedSourceOnDiaObject_diaObjectId
Column Name Data Type Unit Description UCD Order Principal

CoaddPatches

Static information about the subset of tracts and patches from the standard LSST skymap that apply to coadds in these catalogs

Indexes
Columns Description Reference Name
lsst_patch Non-unique index on the lsst_patch column idx_CoaddPatches_lsst_patch
lsst_tract Non-unique index on the lsst_tract column idx_CoaddPatches_lsst_tract
Column Name Data Type Unit Description UCD Order Principal

Visit

Metadata about the pointings of the telescope, largely associated with the boresight of the LSSTCam focal plane as a whole.

Indexes
Columns Description Reference Name
visit Unique index on the visit column idx_Visit_visit
Column Name Data Type Unit Description UCD Order Principal

VisitDetector

Per-detector metadata and metrics associated with each visit

Indexes
Columns Description Reference Name
visitId Non-unique index on visitId column; accelerates retrieval of data for all detectors for a visit idx_VisitDetector_visitId
visitId, detector Unique index on visit and detector columns in CcdVisit table idx_VisitDetector_visitId_detector
Column Name Data Type Unit Description UCD Order Principal

SSObject

LSST-computed per-object quantities.

Indexes
Columns Description Reference Name
MOIDEarth Index on the MOIDEarth column idx_SSObject_MOIDEarth
Column Name Data Type Unit Description UCD Order Principal

SSSource

LSST-computed per-source quantities. 1::1 relationship with DiaSource.

Indexes
Columns Description Reference Name
ssObjectId Non-unique index on the ssObjectId column; accelerates retrieval of single-epoch data for SSObjects. idx_SSSource_ssObjectId
designation Non-unique index on the designation column; accelerates retrieval of single-epoch data for SSObjects. idx_SSSource_designation
Column Name Data Type Unit Description UCD Order Principal

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.

Column Name Data Type Unit Description UCD Order Principal

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.

Column Name Data Type Unit Description UCD Order Principal

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.

Column Name Data Type Unit Description UCD Order Principal

Parent

Descriptions of the parent objects in the deblending hierarchy.

Column Name Data Type Unit Description UCD Order Principal

ShearObject

Descriptions of shear objects detected and measured on coadds with metadetection.

Column Name Data Type Unit Description UCD Order Principal

IsolatedStarStellarMotions

Position, proper motion, and parallax for isolated stars, fit using associated source measurements, with positions for associated reference objects if available.

Column Name Data Type Unit Description UCD Order Principal

SDM Schemas is maintained by Rubin Observatory.