wiki:DbDC3bSimSchema
Last modified 9 years ago Last modified on 02/25/2010 09:50:03 AM

DC3b Database Schema - Simulation

LSST Database

The current simulator schema can be found in Simulator_meta_v3.pdf, or see latest ascii dump. [Note that this is not the final version, eg. moving sources are missing, but it is close to final]

The simulator schema will be reformatted prior to ingesting into the LSST core schema. Some columns will be mapped to Object and Source tables, some will go to a new table that we will create that describe basic information about simulation (placeholder name used below: SimInfo), and some will be omitted. Further details are described below.

Galaxy table --> Object

Proposed mapping of the Galaxy table to the LSST Object schema:

sim column sim type LSST Object type comments
ID BIGINT objectId BIGINT
ra DOUBLE ra_SG DOUBLE
decl DOUBLE decl_SG DOUBLE
redshift FLOAT ? ? not in schema!
u,g,r,i,z,y FLOAT uFlux_SG, ... FLOAT
SEDfilename VARCHAR(25) SimInfo table?
SEDID INT SimInfo table?
glon FLOAT SimInfo table?
glat FLOAT SimInfo table?
pa FLOAT SimInfo table?
inclination FLOAT SimInfo table?
SB_eb, r_eb, nb, rab, decb uSersicN_SG, uE1_SG, uE2_SG, uRadius_SG *
SB_eb, r_eb, nb, rab, decb uSersicN_SG, uE1_SG, uE2_SG, uRadius_SG *
versionID INT SimInfo table?
fluxnorm FLOAT SimInfo table?
norm_lambda FLOAT SimInfo table?
absmag_r FLOAT SimInfo table?
type FLOAT SimInfo table?
mass_stellar FLOAT SimInfo table?
mass_gas FLOAT SimInfo table?
mass_halo FLOAT SimInfo table?
color_* FLOAT do not save?
cx, cy, cz FLOAT ?
pixid BIGINT ?
  • In the LSST Object table sersicN, e1, e2, radius are per filter, and we do not differentiate between disk and bulge.

Star table --> Object

Proposed mapping of the Star table to the LSST Object schema:

sim column sim type LSST Object type comments
ID BIGINT objectId BIGINT
ra DOUBLE ra_SG DOUBLE
decl DOUBLE decl_SG DOUBLE
versionID INT SimInfo table?
muRa FLOAT muRa_PS DOUBLE unit: deg/s vs deg/year||
muDec FLOAT muDecl_PS DOUBLE unit: deg/s vs deg/year||
Vrad FLOAT ?
parallax FLOAT parallax_PS DOUBLE unit: arcsec vs deg/year
SEDfilename VARCHAR(25) SimInfo table?
SEDID INT SimInfo table?
fluxnorm FLOAT ?
u,g,r,i,z,y FLOAT uFlux_SG, ... FLOAT
r_sdss FLOAT ?
i_sdss FLOAT ?
Mr FLOAT ?
pop TINYINT ?
type TINYINT ?
T FLOAT ?
Fe_H FLOAT ?
log_g FLOAT ?
VR FLOAT ?
Vphi FLOAT ?
Vz FLOAT ?
isvar FLOAT ?
period FLOAT ?
amplitude FLOAT ?
t0 FLOAT ?
cx, cy, cy FLOAT ?
pixid BIGINT ?

Galaxy table --> Source

Proposed mapping of the Star table to the LSST Source schema:

[TBD]

Star table --> Source

Proposed mapping of the Star table to the LSST Source schema:

[TBD]

Do we need to map to DiaSource, ForcedSource too?

Attachments