- Created by Scott Daniel, last modified on Aug 08, 2016
This page will list the database tables provided in the LSST simulations 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
- OpSim3_61DBObject links to the table 'output_opsim3_61' (found in Opsim3_61DBObject.py)
- SolarSystemObj calls the table valued SQL funciton fSSMAllBase, which returns all types of solar system objects (found in SsmModels.py)
- ExampleGalaxyObj links to the table 'galaxies' (found in GalaxyModels.py)
Note: because galaxies are so dense on the sky, most galaxy classes only return results on a small patch of sky. GalaxyTileObj and the classes that inherit from it (GalaxyBulgeObj, GalaxyDiskObj, GalaxyAgnObj) repeat this patch over the whole sky to simulate a full-sky distribution of galaxies.
- GalaxyObj links to the table 'galaxy' (found in GalaxyModels.py)
- GalaxyTileObj links to the table 'galaxy' (found in GalaxyModels.py)
- GalaxyBulgeObj links to the table 'galaxy_bulge' (found in GalaxyModels.py) - do not trust this class; the best way to get galaxy information is with GalaxyTileObj
- GalaxyDiskObj links to the table 'galaxy' (found in GalaxyModels.py) - do not trust this class; the best way to get galaxy information is with GalaxyTileObj
- GalaxyAgnObj links to the table 'galaxy_agn' (found in GalaxyModels.py) - do not trust this class; the best way to get galaxy information is with GalaxyTileObj
- ImageAgnObj links to the table 'image' (found in GalaxyModels.py)
- LensGalaxyObj links to the table 'lens' (found in GalaxyModels.py)
Note: see the first section of this page for a discussion of which stellar tables are based on physically meaningful models.
- StarObj links to the table valued function StarAllForceseek (found in StarModels.py)
- MsStarObj links to the table valued function StarMSRGBForceseek (found in StarModels.py)
- WdStarObj links to the table 'StarWhiteDwarf' (found in StarModels.py)
- RRLyStarObj links to the table 'StarRRLy' (found in StarModels.py)
- BhbStarObj links to the table 'StarBHB' (found in StarModels.py)
- EbStarObj links to the table 'StarEclipsingBinary' (found in StarModels.py)
- CepheidStarObj links to the table 'StarCepheid' (found in StarModels.py)
- EasterEggStarObj links to the table 'AstromEasterEggs' (found in StarModels.py)
- DwarfGalStarObj links to the table 'StarDwarfGalaxy' (found in StarModels.py)
Stars
- Object Type: TABLE
- Last Modified: Jan 20 2016 10:40PM
- Row Count: 917277
- Description: Blue horizonal branch stars
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-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in z (un-extincted, 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 |
| int | 4 | True |
|
| Population (0=Thin Disk, 1=Thick Disk, |
| int | 4 | True |
|
| Identifier of model type (0=Kurucz, 1=M-Dwarf) |
| 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) |
| float | 8 | True |
|
| Velocity in z coordinate (cylindrical) |
| int | 4 | True |
|
|
|
| int | 4 | True |
|
| ID of variable source. zero if not variable. isvar = StarVar.ID |
| float | 8 | True |
|
| Time scale of variability (days). If the lightcurve is non-periodic, this is understood to be the lightcurve lifetime. Zero if not variable. |
| float | 8 | True |
|
| Amplitude of deviation in magnitude. Zero |
| float | 8 | True |
|
| Time in MJD of beginning of variability. |
| 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 |
---|---|
|
|
|
|
|
|
|
|
- Object Type: TABLE
- Last Modified: Jan 20 2016 10:34PM
- Row Count: 263
- Description: Cepheid variable stars
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-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in z (un-extincted, 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 |
| tinyint | 1 | True |
|
| Population (0=Thin Disk, 1=Thick Disk, |
| tinyint | 1 | True |
|
| Identifier of model type (0=Kurucz, 1=M-Dwarf) |
| 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) |
| real | 4 | True |
|
| Velocity in z coordinate (cylindrical) |
| tinyint | 1 | True |
|
|
|
| tinyint | 1 | True |
|
| ID of variable source. zero if not variable. isvar = StarVar.ID |
| float | 8 | True |
|
| Time scale of variability (days). If the lightcurve is non-periodic, this is understood to be the lightcurve lifetime. Zero if not variable. |
| float | 8 | True |
|
| Amplitude of deviation in magnitude. Zero |
| float | 8 | True |
|
| Time in MJD of beginning of variability. |
| 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 |
---|---|
|
|
|
|
|
|
- Object Type: TABLE
- Last Modified: Jan 20 2016 10:34PM
- Row Count: 1842
- Description: Eclipsing binary stars
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-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in z (un-extincted, 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 |
| tinyint | 1 | True |
|
| Population (0=Thin Disk, 1=Thick Disk, |
| tinyint | 1 | True |
|
| Identifier of model type (0=Kurucz, 1=M-Dwarf) |
| 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) |
| real | 4 | True |
|
| Velocity in z coordinate (cylindrical) |
| tinyint | 1 | True |
|
|
|
| tinyint | 1 | True |
|
| ID of variable source. zero if not variable. isvar = StarVar.ID |
| float | 8 | True |
|
| Time scale of variability (days). If the lightcurve is non-periodic, this is understood to be the lightcurve lifetime. Zero if not variable. |
| float | 8 | True |
|
| Amplitude of deviation in magnitude. Zero |
| float | 8 | True |
|
| Time in MJD of beginning of variability. |
| 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 |
---|---|
|
|
|
|
|
|
- Object Type: TABLE
- Last Modified: Jan 20 2016 10:40PM
- Row Count: 945116
- Description: RR Lyrae stars
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-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in z (un-extincted, 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 |
| int | 4 | True |
|
| Population (0=Thin Disk, 1=Thick Disk, |
| int | 4 | True |
|
| Identifier of model type (0=Kurucz, 1=M-Dwarf) |
| 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) |
| float | 8 | True |
|
| Velocity in z coordinate (cylindrical) |
| int | 4 | True |
|
|
|
| int | 4 | True |
|
| ID of variable source. zero if not variable. isvar = StarVar.ID |
| float | 8 | True |
|
| Time scale of variability (days). If the lightcurve is non-periodic, this is understood to be the lightcurve lifetime. Zero if not variable. |
| float | 8 | True |
|
| Amplitude of deviation in magnitude. Zero |
| float | 8 | True |
|
| Time in MJD of beginning of variability. |
| 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 |
---|---|
|
|
|
|
|
|
|
|
- Object Type: TABLE
- Last Modified: Jan 20 2016 10:40PM
- Row Count: 124130489
- Description: White dwarfs
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-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in z (un-extincted, 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 |
| int | 4 | True |
|
| Population (0=Thin Disk, 1=Thick Disk, |
| int | 4 | True |
|
| Identifier of model type (0=Kurucz, 1=M-Dwarf) |
| 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) |
| float | 8 | True |
|
| Velocity in z coordinate (cylindrical) |
| int | 4 | True |
|
|
|
| int | 4 | True |
|
| ID of variable source. zero if not variable. isvar = StarVar.ID |
| float | 8 | True |
|
| Time scale of variability (days). If the lightcurve is non-periodic, this is understood to be the lightcurve lifetime. Zero if not variable. |
| float | 8 | True |
|
| Amplitude of deviation in magnitude. Zero |
| float | 8 | True |
|
| Time in MJD of beginning of variability. |
| 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 |
---|---|
|
|
|
|
|
|
|
|
- Object Type: VIEW
- Last Modified: Jan 20 2016 10:41PM
- Row Count:
- Description: Union of MS/RGB, white dwarf, RR Lyrae, and BHB stars
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-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in z (un-extincted, std. atm.) |
| float | 8 | True |
|
| B-V extinction |
| int | 4 | True |
|
| Population (0=Thin Disk, 1=Thick 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 |
- Object Type: VIEW
- Last Modified: Jan 20 2016 10:41PM
- Row Count:
- Description: Same as starsALL except includes forceseek query hint to ensure proper query plan for spatial search criteria.
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-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| float | 8 | True |
|
| Observed magnitude from SDSS in z (un-extincted, std. atm.) |
| float | 8 | True |
|
| B-V extinction |
| int | 4 | True |
|
| Population (0=Thin Disk, 1=Thick 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 |
- Object Type: VIEW
- Last Modified: Jan 20 2016 10:43PM
- Row Count:
- Description: All MS/RGB stars (union of base tables partitioned by htmId)
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-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in z (un-extincted, std. atm.) |
| float | 8 | True |
|
| B-V extinction |
| tinyint | 1 | True |
|
| Population (0=Thin Disk, 1=Thick 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 |
- Object Type: VIEW
- Last Modified: Jan 20 2016 10:44PM
- Row Count:
- Description: StarMSRGB for spatial queries using htmId
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-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in g (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in r (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in i (un-extincted, std. atm.) |
| real | 4 | True |
|
| Observed magnitude from SDSS in z (un-extincted, std. atm.) |
| float | 8 | True |
|
| B-V extinction |
| tinyint | 1 | True |
|
| Population (0=Thin Disk, 1=Thick 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 |
Galaxies
- Object Type: STORED_PROCEDURE
- Last Modified: Apr 15 2015 1:48PM
- Row Count:
- Description: Return galaxies in an arbitrarily shaped search region.
Param: @ApertureStr = String describing search region (www.skyserver.org/htm/HtmPrimer/regiongrammar.html)
Param: @ColumnNames = String containing list of columns (What goes between SELECT and FROM in a simple query.)
Param: @WhereClause = String containing constraints. Use columns names from galaxy base table. Do not include the word "WHERE"
Param: @ComponentSubset = One of ['ALL', 'BULGE', 'DISK' or 'AGN'] return only rows which containing that component. Default='ALL'
- Object Type: STORED_PROCEDURE
- Last Modified: Jul 25 2014 3:44PM
- Row Count:
- Description: Return galaxies in an arbitrarily shaped search region.
Param: @ApertureStr = String describing search region (www.skyserver.org/htm/HtmPrimer/regiongrammar.html)
Param: @ColumnNames = String containing list of columns (What goes between SELECT and FROM in a simple query.)
Param: @WhereClause = String containing constraints. Use columns names from galaxy base table. Do not include the word "WHERE"
- Object Type: STORED_PROCEDURE
- Last Modified: Mar 14 2013 5:36PM
- Row Count:
- Description: Return galaxies in a search cone.
Param: @RaSearch = R.A Coord of search cone center (deg)
Param: @DecSearch = Dec. Coord of search cone center (deg)
Param: @apertureRadius = Radius of search cone (arcminutes)
Param: @ColumnNames = String containing a list of columns wanted (What goes between SELECT and FROM in a simple query.)
Param: @WhereClause = String containing constraints. Must begin with WHERE, and column names are given names.
- Object Type: STORED_PROCEDURE
- Last Modified: Oct 10 2013 11:52PM
- Row Count:
- Description: Return galaxies in a search cone. Same as GalaxySearchSpecColsConstraint, but with alternative interface
Param: @RaSearch = R.A. Coord of search cone center (deg)
Param: @DecSearch = Dec. Coord of search cone center (deg)
Param: @apertureRadius = Radius of search cone (arcminutes)
Param: @ColumnNames = String containing a list of columns wanted (What goes between SELECT and FROM in a simple query.)
Param: @WhereClause = String containing constraints. Use columns names from galaxy base table. Do not include the word "WHERE"
- Object Type: TABLE
- Last Modified: Oct 15 2013 12:17PM
- Row Count: 17428284
- Description: Galaxy base table (8 sq. deg. centered on R.A=0, Dec=0). For tiled positions, use stored procedures GalaxySearchSpecColsConstraint, GalaxySearchSpecColsConstraint2013, GalaxySearch2014
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 |
| float | 8 | True |
|
| Reddening value for bulge of galaxy (0.0) |
| float | 8 | True |
|
| R_v for extinction model for bulge (3.1) |
| 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) |
| varchar | 10 | True |
|
| Extinction model identifier for disk ('ccm') |
| 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) |
| 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 = AGN_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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- Object Type: TABLE
- Last Modified: Mar 1 2013 5:41PM
- Row Count: 181599
- Description: Materialized view of galaxy table containing only rows with AGN
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 |
| float | 8 | True |
|
| Reddening value for bulge of galaxy (0.0) |
| float | 8 | True |
|
| R_v for extinction model for bulge (3.1) |
| 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) |
| varchar | 10 | True |
|
| Extinction model identifier for disk ('ccm') |
| 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) |
| 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 = AGN_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 |
---|---|
|
|
- Object Type: TABLE
- Last Modified: Mar 1 2013 5:40PM
- Row Count: 5287342
- Description: Materialized view of galaxy table containing only rows with bulges
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 |
| float | 8 | True |
|
| Reddening value for bulge of galaxy (0.0) |
| float | 8 | True |
|
| R_v for extinction model for bulge (3.1) |
| 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) |
| varchar | 10 | True |
|
| Extinction model identifier for disk ('ccm') |
| 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) |
| 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 = AGN_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 |
---|---|
|
|
Asteroids
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Apr 12 2012 4:37AM
- Row Count:
- Description: Return union of fSSMMBA, fSSMComet, fSSMNEO, fSSMnonMBA
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Jul 21 2014 4:34AM
- Row Count:
- Description: Return union of fSSMMBABase, fSSMCometBase, fSSMNEOBase, fSSMnonMBABase. Args: @MJD(float), @RegionStr (string)
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Apr 19 2012 12:02PM
- Row Count:
- Description: Return Comets intersecting circular search region at MJD
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Jul 21 2014 2:17AM
- Row Count:
- Description: Return Comets intersecting region described by RegionStr at MJD. Args: @MJD(float), @RegionStr (string)
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Apr 12 2012 5:54AM
- Row Count:
- Description: Return Main Belt Asteroids intersecting circular search region at MJD
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Jul 21 2014 4:05AM
- Row Count:
- Description: Return Main Belt Asteroids intersecting region described by RegionStr at MJD. Args: @MJD(float), @RegionStr (string)
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Apr 16 2012 1:50PM
- Row Count:
- Description: Return Near Earth Objects intersecting circular search region at MJD
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Jul 21 2014 4:14AM
- Row Count:
- Description: Return Near Earth Objects intersecting region described by RegionStr at MJD. Args: @MJD(float), @RegionStr (string)
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Apr 19 2012 1:25AM
- Row Count:
- Description: Return Trans-Neptune Objects, Scattered disk objects and all Trojans intersecting circular search region at MJD
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 |
|
|
|
- Object Type: TABLE_VALUED_FUNCTION
- Last Modified: Jul 21 2014 4:27AM
- Row Count:
- Description: Return Trans-Neptune Objects, Scattered disk objects and all Trojans intersecting region described by RegionStr at MJD. Args: @MJD(float), @RegionStr (string)
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 database tables.
- No labels