- Created by Scott Daniel, last modified on Aug 08, 2016
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 20 Current »
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 |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| 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 |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| 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 |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| 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 |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| 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 |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| float | 8 | True |
|
|
|
| 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