Data Preview 2
This schema is being provided early as a preview of the upcoming release, but
should not be considered final until the DP2 data themselves have been
released.
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 |
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 |
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 |
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 |
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 |
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 |
Metadata about the pointings of the telescope, largely associated with the boresight of the LSSTComCam 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 |
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 VisitDetector table. |
idx_VisitDetector_visitId_detector |
| Column Name |
Data Type |
Unit |
Description |
UCD |
Order |
Principal |
LSST-computed per-object quantities.
Indexes
| Columns |
Description |
Reference Name |
|
ssObjectId
| Unique index on the ssObjectId column. |
idx_SSObject_ssObjectId |
| Column Name |
Data Type |
Unit |
Description |
UCD |
Order |
Principal |
LSST-computed per-source quantities. 1::1 relationship with DiaSource.
Indexes
| Columns |
Description |
Reference Name |
|
diaSourceId
| Unique index on the diaSourceId column; accelerates joins between DiaSource and SSSource. |
idx_SSSource_diaSourceId |
|
ssObjectId
| Non-unique index on the ssObjectId column; accelerates retrieval of single-epoch data for SSObjects. |
idx_SSSource_ssObjectId |
| Column Name |
Data Type |
Unit |
Description |
UCD |
Order |
Principal |
Descriptions of shear objects detected and measured on coadds with metadetection.
Indexes
| Columns |
Description |
Reference Name |
|
shearObjectId
| Unique index on the shearObjectId column. |
idx_ShearObject_shearObjectId |
| Column Name |
Data Type |
Unit |
Description |
UCD |
Order |
Principal |
Position, proper motion, and parallax for isolated stars, fit using associated source measurements, with positions for associated reference objects if available.
Indexes
| Columns |
Description |
Reference Name |
|
isolated_star_id
| Unique index on the isolated_star_id column. |
idx_IsolatedStarStellarMotions_isolated_star_id |
|
referenceId
| Non-unique index on the referenceId column; accelerates retrieval of stellar motions for reference objects. |
idx_IsolatedStarStellarMotions_referenceId |
| Column Name |
Data Type |
Unit |
Description |
UCD |
Order |
Principal |
SDM Schemas is maintained by
Rubin Observatory.