SSSource

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

Columns

name datatype description unit nullable ivoa:ucd
phaseAngle float Phase angle deg true
heliocentricDist float Heliocentric distance AU true
topocentricDist float Topocentric distace AU true
heliocentricX float Cartesian heliocentric X coordinate (at the emit time) AU true
heliocentricY float Cartesian heliocentric Y coordinate (at the emit time) AU true
heliocentricZ float Cartesian heliocentric Z coordinate (at the emit time) AU true
heliocentricVX float Cartesian heliocentric X velocity (at the emit time) AU true
heliocentricVY float Cartesian heliocentric Y velocity (at the emit time) AU true
heliocentricVZ float Cartesian heliocentric Z velocity (at the emit time) AU true
topocentricX float Cartesian topocentric X coordinate (at the emit time) AU true
topocentricY float Cartesian topocentric Y coordinate (at the emit time) AU true
topocentricZ float Cartesian topocentric Z coordinate (at the emit time) AU true
topocentricVX float Cartesian topocentric X velocity (at the emit time) AU true
topocentricVY float Cartesian topocentric Y velocity (at the emit time) AU true
topocentricVZ float Cartesian topocentric Z velocity (at the emit time) AU true
ssObjectId foreign key indexed long Unique identifier of the object. true meta.id;src
residualRa double Residual R.A. vs. ephemeris deg true
residualDec double Residual Dec vs. ephemeris deg true
diaSourceId primary key foreign key indexed long Unique identifier of the observation true meta.id;src
galacticL double Galactic longitude deg true
galacticB double Galactic latitute deg true
eclipticLambda double Ecliptic longitude deg true
eclipticBeta double Ecliptic latitude deg true

Indexes

Index Definition Description
idx_SSSource_diaSourceId diaSourceId Unique index on the diaSourceId column; accelerates joins between DiaSource and SSSource
idx_SSSource_ssObjectId ssObjectId Non-unique index on the ssObjectId column; accelerates retrieval of single-epoch data for SSObjects

Constraints

Constraint Type Definition Description
fk_SSSource_DiaSource ForeignKey
Columns: diaSourceId
References: DiaSource.diaSourceId
Link an SSSource to its associated DiaSource
fk_SSSource_SSObject ForeignKey
Columns: ssObjectId
References: SSObject.ssObjectId
Link an SSObject to its associated SSSources