Date: Thu, 28 Mar 2024 10:05:21 +0000 (UTC) Message-ID: <265016052.18916.1711620326563@confluence> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_18915_1836012300.1711620321555" ------=_Part_18915_1836012300.1711620321555 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
This page will list the database tables provided in the LSST sim= ulations database and the columns they contain.
As discussed on this page, sub-= classes of DBObject give the user access to database tables. The following = is a list of classes (all found in sims_catUtils/python/lsst/sims/catUtils/= baseCatalogModels/) and the tables they link to
Note: because galaxies are so dense on the sky, most galaxy classes only= return results on a small patch of sky. GalaxyTileObj and the classe= s that inherit from it (GalaxyBulgeObj, GalaxyDiskObj, GalaxyAgnObj) repeat= this patch over the whole sky to simulate a full-sky distribution of galax= ies.
Note: see the first section of this page for a discussion of which stellar tables are based on physically meaningf= ul models.
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
PK |
20-deep hierarchical trangular mesh ID |
|
bigint |
8 |
|
True |
PK |
unique identifier |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
varchar |
10 |
True |
|
|
Identifier for catalog run: Star_Model.ID = |
|
float |
8 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
float |
8 |
True |
|
|
Distance from sun (kpc) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
int |
4 |
True |
|
|
Identifier of SED: Spectrum_meta.ID |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Absolute magnitude in r |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
B-V extinction |
|
int |
4 |
True |
|
|
Id of reddenning spectrum in spectrum table= p> |
|
int |
4 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
int |
4 |
True |
|
|
Identifier of model type (0=3DKurucz, 1=3DM-D= warf) |
|
float |
8 |
True |
|
|
Surface temperature of the model (K) |
|
float |
8 |
True |
|
|
Metallicity of the model |
|
float |
8 |
True |
|
|
log(g) for the model |
|
float |
8 |
True |
|
|
Velocity in R coordinate (cylindrical) |
|
float |
8 |
True |
|
|
Velocity in phi coordinate (cylindrical) <= /td> |
|
float |
8 |
True |
|
|
Velocity in z coordinate (cylindrical) |
|
int |
4 |
True |
|
|
|
|
int |
4 |
True |
|
|
ID of variable source. zero if not variable. = isvar =3D StarVar.ID |
|
float |
8 |
True |
|
|
Time scale of variability (days). If the ligh= tcurve is non-periodic, this is understood to be the lightcurve lifetime. Z= ero if not variable. |
|
float |
8 |
True |
|
|
Amplitude of deviation in magnitude. Zero = |
|
float |
8 |
True |
|
|
Time in MJD of beginning of variability. <= /td> |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) +X toward GC |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
int |
4 |
True |
|
|
|
|
int |
4 |
True |
|
|
|
|
None |
-1 |
True |
|
|
Binary representation of position (Microsoft = Spatial) |
|
text |
16 |
True |
|
|
Variability parameters in JSON format |
|
bigint |
8 |
True |
|
|
|
Indexes
Index Name |
Columns |
---|---|
|
|
|
|
|
|
|
|
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
PK |
20-deep hierarchical trangular mesh ID |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
varchar |
10 |
True |
|
|
Identifier for catalog run: Star_Model.ID = |
|
real |
4 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
real |
4 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
real |
4 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
float |
8 |
True |
|
|
Distance from sun (kpc) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
int |
4 |
True |
|
|
Identifier of SED: Spectrum_meta.ID |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Absolute magnitude in r |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
B-V extinction |
|
tinyint |
1 |
True |
|
|
Id of reddenning spectrum in spectrum table= p> |
|
tinyint |
1 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
tinyint |
1 |
True |
|
|
Identifier of model type (0=3DKurucz, 1=3DM-D= warf) |
|
float |
8 |
True |
|
|
Surface temperature of the model (K) |
|
real |
4 |
True |
|
|
Metallicity of the model |
|
real |
4 |
True |
|
|
log(g) for the model |
|
real |
4 |
True |
|
|
Velocity in R coordinate (cylindrical) |
|
real |
4 |
True |
|
|
Velocity in phi coordinate (cylindrical) <= /td> |
|
real |
4 |
True |
|
|
Velocity in z coordinate (cylindrical) |
|
tinyint |
1 |
True |
|
|
|
|
tinyint |
1 |
True |
|
|
ID of variable source. zero if not variable. = isvar =3D StarVar.ID |
|
float |
8 |
True |
|
|
Time scale of variability (days). If the ligh= tcurve is non-periodic, this is understood to be the lightcurve lifetime. Z= ero if not variable. |
|
float |
8 |
True |
|
|
Amplitude of deviation in magnitude. Zero = |
|
float |
8 |
True |
|
|
Time in MJD of beginning of variability. <= /td> |
|
real |
4 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) +X toward GC |
|
real |
4 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
real |
4 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
int |
4 |
True |
|
|
|
|
int |
4 |
True |
|
|
|
|
None |
-1 |
True |
|
|
Binary representation of position (Microsoft = Spatial) |
|
varchar |
-1 |
True |
|
|
Variability parameters in JSON format |
|
bigint |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
int |
4 |
|
True |
PK |
unique identifier |
Indexes
Index Name |
Columns |
---|---|
|
|
|
|
|
|
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
PK |
20-deep hierarchical trangular mesh ID |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
varchar |
10 |
True |
|
|
Identifier for catalog run: Star_Model.ID = |
|
real |
4 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
real |
4 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
real |
4 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
float |
8 |
True |
|
|
Distance from sun (kpc) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
int |
4 |
True |
|
|
Identifier of SED: Spectrum_meta.ID |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Absolute magnitude in r |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
B-V extinction |
|
tinyint |
1 |
True |
|
|
Id of reddenning spectrum in spectrum table= p> |
|
tinyint |
1 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
tinyint |
1 |
True |
|
|
Identifier of model type (0=3DKurucz, 1=3DM-D= warf) |
|
float |
8 |
True |
|
|
Surface temperature of the model (K) |
|
real |
4 |
True |
|
|
Metallicity of the model |
|
real |
4 |
True |
|
|
log(g) for the model |
|
real |
4 |
True |
|
|
Velocity in R coordinate (cylindrical) |
|
real |
4 |
True |
|
|
Velocity in phi coordinate (cylindrical) <= /td> |
|
real |
4 |
True |
|
|
Velocity in z coordinate (cylindrical) |
|
tinyint |
1 |
True |
|
|
|
|
tinyint |
1 |
True |
|
|
ID of variable source. zero if not variable. = isvar =3D StarVar.ID |
|
float |
8 |
True |
|
|
Time scale of variability (days). If the ligh= tcurve is non-periodic, this is understood to be the lightcurve lifetime. Z= ero if not variable. |
|
float |
8 |
True |
|
|
Amplitude of deviation in magnitude. Zero = |
|
float |
8 |
True |
|
|
Time in MJD of beginning of variability. <= /td> |
|
real |
4 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) +X toward GC |
|
real |
4 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
real |
4 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
int |
4 |
True |
|
|
|
|
int |
4 |
True |
|
|
|
|
None |
-1 |
True |
|
|
Binary representation of position (Microsoft = Spatial) |
|
varchar |
-1 |
True |
|
|
Variability parameters in JSON format |
|
bigint |
8 |
True |
|
|
|
|
int |
4 |
|
True |
PK |
unique identifier |
Indexes
Index Name |
Columns |
---|---|
|
|
|
|
|
|
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
PK |
20-deep hierarchical trangular mesh ID |
|
bigint |
8 |
|
True |
PK |
unique identifier |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
varchar |
10 |
True |
|
|
Identifier for catalog run: Star_Model.ID = |
|
float |
8 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
float |
8 |
True |
|
|
Distance from sun (kpc) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
int |
4 |
True |
|
|
Identifier of SED: Spectrum_meta.ID |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Absolute magnitude in r |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
B-V extinction |
|
int |
4 |
True |
|
|
Id of reddenning spectrum in spectrum table= p> |
|
int |
4 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
int |
4 |
True |
|
|
Identifier of model type (0=3DKurucz, 1=3DM-D= warf) |
|
float |
8 |
True |
|
|
Surface temperature of the model (K) |
|
float |
8 |
True |
|
|
Metallicity of the model |
|
float |
8 |
True |
|
|
log(g) for the model |
|
float |
8 |
True |
|
|
Velocity in R coordinate (cylindrical) |
|
float |
8 |
True |
|
|
Velocity in phi coordinate (cylindrical) <= /td> |
|
float |
8 |
True |
|
|
Velocity in z coordinate (cylindrical) |
|
int |
4 |
True |
|
|
|
|
int |
4 |
True |
|
|
ID of variable source. zero if not variable. = isvar =3D StarVar.ID |
|
float |
8 |
True |
|
|
Time scale of variability (days). If the ligh= tcurve is non-periodic, this is understood to be the lightcurve lifetime. Z= ero if not variable. |
|
float |
8 |
True |
|
|
Amplitude of deviation in magnitude. Zero = |
|
float |
8 |
True |
|
|
Time in MJD of beginning of variability. <= /td> |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) +X toward GC |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
int |
4 |
True |
|
|
|
|
int |
4 |
True |
|
|
|
|
None |
-1 |
True |
|
|
Binary representation of position (Microsoft = Spatial) |
|
ntext |
16 |
True |
|
|
Variability parameters in JSON format |
|
bigint |
8 |
True |
|
|
|
Indexes
Index Name |
Columns |
---|---|
|
|
|
|
|
|
|
|
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
PK |
20-deep hierarchical trangular mesh ID |
|
bigint |
8 |
|
True |
PK |
unique identifier |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
varchar |
10 |
True |
|
|
Identifier for catalog run: Star_Model.ID = |
|
float |
8 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
float |
8 |
True |
|
|
Distance from sun (kpc) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
int |
4 |
True |
|
|
Identifier of SED: Spectrum_meta.ID |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Absolute magnitude in r |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z, extincted = by O'Donnell 94 dust model, std. atm. |
|
float |
8 |
True |
|
|
B-V extinction |
|
int |
4 |
True |
|
|
Id of reddenning spectrum in spectrum table= p> |
|
int |
4 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
int |
4 |
True |
|
|
Identifier of model type (0=3DKurucz, 1=3DM-D= warf) |
|
float |
8 |
True |
|
|
Surface temperature of the model (K) |
|
float |
8 |
True |
|
|
Metallicity of the model |
|
float |
8 |
True |
|
|
log(g) for the model |
|
float |
8 |
True |
|
|
Velocity in R coordinate (cylindrical) |
|
float |
8 |
True |
|
|
Velocity in phi coordinate (cylindrical) <= /td> |
|
float |
8 |
True |
|
|
Velocity in z coordinate (cylindrical) |
|
int |
4 |
True |
|
|
|
|
int |
4 |
True |
|
|
ID of variable source. zero if not variable. = isvar =3D StarVar.ID |
|
float |
8 |
True |
|
|
Time scale of variability (days). If the ligh= tcurve is non-periodic, this is understood to be the lightcurve lifetime. Z= ero if not variable. |
|
float |
8 |
True |
|
|
Amplitude of deviation in magnitude. Zero = |
|
float |
8 |
True |
|
|
Time in MJD of beginning of variability. <= /td> |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) +X toward GC |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
float |
8 |
True |
|
|
Cartesian coordinate in heliocentric galactic= coordinates (pc) |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
int |
4 |
True |
|
|
|
|
int |
4 |
True |
|
|
|
|
None |
-1 |
True |
|
|
Binary representation of position (Microsoft = Spatial) |
|
text |
16 |
True |
|
|
Variability parameters in JSON format |
|
bigint |
8 |
True |
|
|
|
Indexes
Index Name |
Columns |
---|---|
|
|
|
|
|
|
|
|
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
|
20-deep hierarchical trangular mesh ID |
|
bigint |
8 |
|
|
|
unique identifier |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
float |
8 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
B-V extinction |
|
int |
4 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
ntext |
16 |
True |
|
|
Variability parameters in JSON format |
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
|
20-deep hierarchical trangular mesh ID |
|
bigint |
8 |
|
|
|
unique identifier |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
float |
8 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
float |
8 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
B-V extinction |
|
int |
4 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
ntext |
16 |
True |
|
|
Variability parameters in JSON format |
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
|
20-deep hierarchical trangular mesh ID |
|
bigint |
8 |
|
|
|
unique identifier |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
real |
4 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
real |
4 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
real |
4 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
B-V extinction |
|
tinyint |
1 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
varchar |
-1 |
True |
|
|
Variability parameters in JSON format |
Columns
Name |
Data Type |
Max Length (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
|
20-deep hierarchical trangular mesh ID |
|
bigint |
8 |
|
|
|
unique identifier |
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
real |
4 |
True |
|
|
Proper motion in RA (milliarcsec/yr) |
|
real |
4 |
True |
|
|
Proper motion in DEC (milliarcsec/yr) |
|
real |
4 |
True |
|
|
Radial velocity (km/s) |
|
float |
8 |
True |
|
|
Parallax (milliarcsec) |
|
varchar |
-1 |
True |
|
|
Filename of SED for star |
|
float |
8 |
True |
|
|
Scaling constant to be applied to the SED = |
|
float |
8 |
True |
|
|
Apparent magnitude in u (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in g (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in r (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in i (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in z (extincted, std. atm.= ) |
|
float |
8 |
True |
|
|
Apparent magnitude in y (extincted, std. atm.= ) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in u (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in g (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in r (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in i (un-extinct= ed, std. atm.) |
|
real |
4 |
True |
|
|
Observed magnitude from SDSS in z (un-extinct= ed, std. atm.) |
|
float |
8 |
True |
|
|
B-V extinction |
|
tinyint |
1 |
True |
|
|
Population (0=3DThin Disk, 1=3DThick Disk, |
|
float |
8 |
True |
|
|
X position on unit sphere |
|
float |
8 |
True |
|
|
Y position on unit sphere |
|
float |
8 |
True |
|
|
Z position on unit sphere |
|
varchar |
-1 |
True |
|
|
Variability parameters in JSON format |
Param: @ApertureStr =3D String describing search region (www.skyserver.o= rg/htm/HtmPrimer/regiongrammar.html)
Param: @ColumnNames =3D String containing list of columns (What goes bet= ween SELECT and FROM in a simple query.)
Param: @WhereClause =3D String containing constraints. Use columns names= from galaxy base table. Do not include the word "WHERE"
Param: @ComponentSubset =3D One of ['ALL', 'BULGE', 'DISK' or 'AGN'] ret= urn only rows which containing that component. Default=3D'ALL'
Param: @ApertureStr =3D String describing search region (www.skyserver.o= rg/htm/HtmPrimer/regiongrammar.html)
Param: @ColumnNames =3D String containing list of columns (What goes bet= ween SELECT and FROM in a simple query.)
Param: @WhereClause =3D String containing constraints. Use columns names= from galaxy base table. Do not include the word "WHERE"
Param: @RaSearch =3D R.A Coord of search cone center (deg)
Param: @DecSearch =3D Dec. Coord of search cone center (deg)
Param: @apertureRadius =3D Radius of search cone (arcminutes)
Param: @ColumnNames =3D String containing a list of columns wanted (What= goes between SELECT and FROM in a simple query.)
Param: @WhereClause =3D String containing constraints. Must begin with W= HERE, and column names are given names.
Param: @RaSearch =3D R.A. Coord of search cone center (deg)
Param: @DecSearch =3D Dec. Coord of search cone center (deg)
Param: @apertureRadius =3D Radius of search cone (arcminutes)
Param: @ColumnNames =3D String containing a list of columns wanted (What= goes between SELECT and FROM in a simple query.)
Param: @WhereClause =3D String containing constraints. Use columns names= from galaxy base table. Do not include the word "WHERE"
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
PK |
20-deep hierarchical trangular mesh ID |
|
varchar |
30 |
True |
|
|
|
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Redshift |
|
float |
8 |
True |
|
|
Peculiar velocity in the radial direction (km= / |
|
float |
8 |
True |
|
|
Apparent AB magnitude in u (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in g (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in r (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in i (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in z (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in y (extincted) |
|
int |
4 |
True |
|
|
ID of bulge SED metadata: Spectrum_meta.ID |
|
int |
4 |
True |
|
|
ID of disk SED metadata: Spectrum_meta.ID = |
|
int |
4 |
True |
|
|
ID of agn SED metadata: Spectrum_meta.ID <= /td> |
|
float |
8 |
True |
|
|
Reddening value for bulge of galaxy (0.0) = |
|
float |
8 |
True |
|
|
R_v for extinction model for bulge (3.1) <= /td> |
|
varchar |
10 |
True |
|
|
Extinction model identifier ('ccm') |
|
float |
8 |
True |
|
|
Reddening value for disk of galaxy |
|
float |
8 |
True |
|
|
R_v for extinction model for disk (3.1) = td> |
|
varchar |
10 |
True |
|
|
Extinction model identifier for disk ('ccm')<= /p> |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Position angle of bulge (deg) |
|
float |
8 |
True |
|
|
Position angle of disk (deg) |
|
float |
8 |
True |
|
|
Inclination of bulge to line of sight (deg)= p> |
|
float |
8 |
True |
|
|
Inclination of disk to line of sight (deg) |
|
float |
8 |
True |
|
|
Semi-major axis of bulge (arcsec) |
|
float |
8 |
True |
|
|
Semi-minor axis of bulge (arcsec) |
|
float |
8 |
True |
|
|
Sersic index of bulge (4) |
|
float |
8 |
True |
|
|
RA of bulge center (deg) |
|
float |
8 |
True |
|
|
Dec of bulge center (deg) |
|
float |
8 |
True |
|
|
Semi-major axis of disk (arcsec) |
|
float |
8 |
True |
|
|
Semi-minor axis of disk (arcsec) |
|
float |
8 |
True |
|
|
Sersic index of disk (1) |
|
float |
8 |
True |
|
|
RA of disk center (deg) |
|
float |
8 |
True |
|
|
Dec of disk center (deg) |
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
ID of simulation version: Galaxy_Model.ID = |
|
float |
8 |
True |
|
|
Multiplicative scaling factor to apply to the= bulge SED |
|
float |
8 |
True |
|
|
Multiplicative scaling factor to apply to the= AGN SED |
|
float |
8 |
True |
|
|
Absolute magnitude in r |
|
float |
8 |
True |
|
|
Type determined from color (u-r?) |
|
float |
8 |
True |
|
|
Stellar mass |
|
float |
8 |
True |
|
|
Gas mass |
|
float |
8 |
True |
|
|
Halo mass |
|
float |
8 |
True |
|
|
Restframe color u-g |
|
float |
8 |
True |
|
|
Restframe color g-r |
|
float |
8 |
True |
|
|
Restframe color r-i |
|
float |
8 |
True |
|
|
Restframe color i-z |
|
float |
8 |
True |
|
|
Restframe color z-y |
|
int |
4 |
True |
|
|
ID of AGN; zero if none present; isagn =3D AG= N_VAR.ID |
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
X Cartesian position |
|
float |
8 |
True |
|
|
Y Cartesian position |
|
float |
8 |
True |
|
|
Z Cartesian position |
|
None |
-1 |
True |
|
|
Binary representation of position (Microsoft = Spatial) |
|
varchar |
25 |
True |
|
|
filename of the AGN SED |
|
varchar |
25 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
|
bigint |
8 |
True |
|
|
|
|
ntext |
16 |
True |
|
|
Variability parameters in JSON format |
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
bigint |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
int |
4 |
|
|
PK |
Primary index of catalog |
|
int |
4 |
True |
|
|
|
Indexes
Index Name |
Columns |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
PK |
20-deep hierarchical trangular mesh ID |
|
varchar |
30 |
True |
|
|
|
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Redshift |
|
float |
8 |
True |
|
|
Peculiar velocity in the radial direction (km= / |
|
float |
8 |
True |
|
|
Apparent AB magnitude in u (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in g (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in r (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in i (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in z (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in y (extincted) |
|
int |
4 |
True |
|
|
ID of bulge SED metadata: Spectrum_meta.ID |
|
int |
4 |
True |
|
|
ID of disk SED metadata: Spectrum_meta.ID = |
|
int |
4 |
True |
|
|
ID of agn SED metadata: Spectrum_meta.ID <= /td> |
|
float |
8 |
True |
|
|
Reddening value for bulge of galaxy (0.0) = |
|
float |
8 |
True |
|
|
R_v for extinction model for bulge (3.1) <= /td> |
|
varchar |
10 |
True |
|
|
Extinction model identifier ('ccm') |
|
float |
8 |
True |
|
|
Reddening value for disk of galaxy |
|
float |
8 |
True |
|
|
R_v for extinction model for disk (3.1) = td> |
|
varchar |
10 |
True |
|
|
Extinction model identifier for disk ('ccm')<= /p> |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Position angle of bulge (deg) |
|
float |
8 |
True |
|
|
Position angle of disk (deg) |
|
float |
8 |
True |
|
|
Inclination of bulge to line of sight (deg)= p> |
|
float |
8 |
True |
|
|
Inclination of disk to line of sight (deg) |
|
float |
8 |
True |
|
|
Semi-major axis of bulge (arcsec) |
|
float |
8 |
True |
|
|
Semi-minor axis of bulge (arcsec) |
|
float |
8 |
True |
|
|
Sersic index of bulge (4) |
|
float |
8 |
True |
|
|
RA of bulge center (deg) |
|
float |
8 |
True |
|
|
Dec of bulge center (deg) |
|
float |
8 |
True |
|
|
Semi-major axis of disk (arcsec) |
|
float |
8 |
True |
|
|
Semi-minor axis of disk (arcsec) |
|
float |
8 |
True |
|
|
Sersic index of disk (1) |
|
float |
8 |
True |
|
|
RA of disk center (deg) |
|
float |
8 |
True |
|
|
Dec of disk center (deg) |
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
ID of simulation version: Galaxy_Model.ID = |
|
float |
8 |
True |
|
|
Multiplicative scaling factor to apply to the= bulge SED |
|
float |
8 |
True |
|
|
Multiplicative scaling factor to apply to the= AGN SED |
|
float |
8 |
True |
|
|
Absolute magnitude in r |
|
float |
8 |
True |
|
|
Type determined from color (u-r?) |
|
float |
8 |
True |
|
|
Stellar mass |
|
float |
8 |
True |
|
|
Gas mass |
|
float |
8 |
True |
|
|
Halo mass |
|
float |
8 |
True |
|
|
Restframe color u-g |
|
float |
8 |
True |
|
|
Restframe color g-r |
|
float |
8 |
True |
|
|
Restframe color r-i |
|
float |
8 |
True |
|
|
Restframe color i-z |
|
float |
8 |
True |
|
|
Restframe color z-y |
|
int |
4 |
True |
|
|
ID of AGN; zero if none present; isagn =3D AG= N_VAR.ID |
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
X Cartesian position |
|
float |
8 |
True |
|
|
Y Cartesian position |
|
float |
8 |
True |
|
|
Z Cartesian position |
|
None |
-1 |
True |
|
|
Binary representation of position (Microsoft = Spatial) |
|
varchar |
25 |
|
|
|
filename of the AGN SED |
|
varchar |
25 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
|
bigint |
8 |
True |
|
|
|
|
ntext |
16 |
True |
|
|
Variability parameters in JSON format |
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
bigint |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
int |
4 |
|
|
|
|
|
int |
4 |
|
|
PK |
Primary index of catalog |
Indexes
Index Name |
Columns |
---|---|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
bigint |
8 |
|
|
PK |
20-deep hierarchical trangular mesh ID |
|
varchar |
30 |
True |
|
|
|
|
float |
8 |
True |
|
|
Right Ascension (deg) |
|
float |
8 |
True |
|
|
Declination (deg) |
|
float |
8 |
True |
|
|
Redshift |
|
float |
8 |
True |
|
|
Peculiar velocity in the radial direction (km= / |
|
float |
8 |
True |
|
|
Apparent AB magnitude in u (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in g (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in r (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in i (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in z (extincted) |
|
float |
8 |
True |
|
|
Apparent AB magnitude in y (extincted) |
|
int |
4 |
True |
|
|
ID of bulge SED metadata: Spectrum_meta.ID |
|
int |
4 |
True |
|
|
ID of disk SED metadata: Spectrum_meta.ID = |
|
int |
4 |
True |
|
|
ID of agn SED metadata: Spectrum_meta.ID <= /td> |
|
float |
8 |
True |
|
|
Reddening value for bulge of galaxy (0.0) = |
|
float |
8 |
True |
|
|
R_v for extinction model for bulge (3.1) <= /td> |
|
varchar |
10 |
True |
|
|
Extinction model identifier ('ccm') |
|
float |
8 |
True |
|
|
Reddening value for disk of galaxy |
|
float |
8 |
True |
|
|
R_v for extinction model for disk (3.1) = td> |
|
varchar |
10 |
True |
|
|
Extinction model identifier for disk ('ccm')<= /p> |
|
float |
8 |
True |
|
|
Galactic longitude (deg) |
|
float |
8 |
True |
|
|
Galactic latitude (deg) |
|
float |
8 |
True |
|
|
Position angle of bulge (deg) |
|
float |
8 |
True |
|
|
Position angle of disk (deg) |
|
float |
8 |
True |
|
|
Inclination of bulge to line of sight (deg)= p> |
|
float |
8 |
True |
|
|
Inclination of disk to line of sight (deg) |
|
float |
8 |
True |
|
|
Semi-major axis of bulge (arcsec) |
|
float |
8 |
True |
|
|
Semi-minor axis of bulge (arcsec) |
|
float |
8 |
True |
|
|
Sersic index of bulge (4) |
|
float |
8 |
True |
|
|
RA of bulge center (deg) |
|
float |
8 |
True |
|
|
Dec of bulge center (deg) |
|
float |
8 |
True |
|
|
Semi-major axis of disk (arcsec) |
|
float |
8 |
True |
|
|
Semi-minor axis of disk (arcsec) |
|
float |
8 |
True |
|
|
Sersic index of disk (1) |
|
float |
8 |
True |
|
|
RA of disk center (deg) |
|
float |
8 |
True |
|
|
Dec of disk center (deg) |
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
ID of simulation version: Galaxy_Model.ID = |
|
float |
8 |
True |
|
|
Multiplicative scaling factor to apply to the= bulge SED |
|
float |
8 |
True |
|
|
Multiplicative scaling factor to apply to the= AGN SED |
|
float |
8 |
True |
|
|
Absolute magnitude in r |
|
float |
8 |
True |
|
|
Type determined from color (u-r?) |
|
float |
8 |
True |
|
|
Stellar mass |
|
float |
8 |
True |
|
|
Gas mass |
|
float |
8 |
True |
|
|
Halo mass |
|
float |
8 |
True |
|
|
Restframe color u-g |
|
float |
8 |
True |
|
|
Restframe color g-r |
|
float |
8 |
True |
|
|
Restframe color r-i |
|
float |
8 |
True |
|
|
Restframe color i-z |
|
float |
8 |
True |
|
|
Restframe color z-y |
|
int |
4 |
True |
|
|
ID of AGN; zero if none present; isagn =3D AG= N_VAR.ID |
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
X Cartesian position |
|
float |
8 |
True |
|
|
Y Cartesian position |
|
float |
8 |
True |
|
|
Z Cartesian position |
|
None |
-1 |
True |
|
|
Binary representation of position (Microsoft = Spatial) |
|
varchar |
25 |
True |
|
|
filename of the AGN SED |
|
varchar |
25 |
|
|
|
|
|
varchar |
25 |
True |
|
|
|
|
bigint |
8 |
True |
|
|
|
|
ntext |
16 |
True |
|
|
Variability parameters in JSON format |
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
bigint |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
int |
4 |
|
|
|
|
|
int |
4 |
|
|
PK |
Primary index of catalog |
Indexes
Index Name |
Columns |
---|---|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
Columns
Name |
Data Type |
Max Len (Bytes) |
Allow Nulls |
Identity |
PK |
Descriptions |
---|---|---|---|---|---|---|
|
int |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
real |
4 |
True |
|
|
|
|
float |
8 |
True |
|
|
|
|
varchar |
25 |
True |
|
|
|
See = this page for a discussion of the physical basis for the different data= base tables.