Sloan Digital Sky Survey
SkyServer DR14  
Not logged in Login Help
 

DR14 Help
 Start Here
 FAQ
 Cooking with Sloan
 Contact Help Desk
 
 Searching SDSS
 SQL Tutorial
 SQL in SkyServer
 Sample SQL Queries
 Query Limits
 Searching Advice
 
 About the Database
 Table Descriptions
 Schema Browser
 Glossary
 Algorithms
 API/Tools
Table Descriptions
       A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

nametypetext
apogeeDesignSPECTRO Contains the plate design information for APOGEE plates.
This table contains all the design parameters used in designing plates for APOGEE spectra.
apogeeFieldSPECTRO Contains the basic information for an APOGEE field.
This table contains the name, location and number of visits expected for an APOGEE field.
apogeeObjectSPECTRO Contains the targeting information for an APOGEE object.
This table contains all the parameters that went into targeting objects for APOGEE spectra.
apogeePlateSPECTRO Contains all the information associated with an APOGEE plate.
This table contains the parameters for an APOGEE spectral plate
apogeeStarSPECTRO Contains data for an APOGEE star combined spectrum.
This table contains the data in the combined spectrum for an APOGEE star.
apogeeStarAllVisitSPECTRO Links an APOGEE combined star spectrum with all visits for that star.
This is a linking table that links an APOGEE combined star spectrum with all the visits for that star, including good, bad, commsssioning, not, etc.
apogeeStarVisitSPECTRO Links an APOGEE combined star spectrum with the visits used to create it.
This is a linking table that links an APOGEE combined star spectrum with the visits that were used to create the combined spectrum.
apogeeVisitSPECTRO Contains data for a particular APOGEE spectrum visit.
This table corresponds to the data in a single spectrum visit in APOGEE
aspcapStarSPECTRO Contains data for an APOGEE star ASPCAP entry.
This table contains the data in the ASPCAP entry for an APOGEE star.
aspcapStarCovarSPECTRO Contains the covariance information for an APOGEE star ASPCAP entry.
This table contains selected covariance matrix fields for the ASPCAP entry for an APOGEE star.
AtlasOutlinePHOTO Contains a record describing each AtlasOutline object
The table contains the outlines of each object over a 4x4 pixel grid, and the bounding rectangle of the object within the frame.
cannonStarSPECTRO Contains the stellar parameters obtained from the Cannon.
The Cannon (named by David Hogg, after Annie Jump Cannon) is a data-driven approach to determining stellar parameters. This table contains the parameters resulting froom applying that method. More information can be found at https://arxiv.org/abs/1501.07604.
DataConstantsMETA The table stores the values of various enumerated and bitmask columns.
DBColumnsMETA Every column of every table has a description in this table
DBObjectsMETA Every SkyServer database object has a one line description in this table
DBViewColsMETA The columns of each view are stored for the auto-documentation
* means that every column from the parent is propagated.
DependencyMETA Contains the detailed inventory of database objects
The objects are tracked by module
detectionIndexPHOTO Full list of all detections, with associated 'thing' assignment.
Each row in this table corresponds to a single catalog entry, or 'detection' in the SDSS imaging. For each one, this table lists a 'thingId', which is common among all detections of the same object in the catalog.
DiagnosticsMETA This table stores a full diagnostic snapshot of the database.
The table contains the names of all the tables, views, stored procedures and user defined functions in the database. We leave out the Diagnostics itself, QueryResults and LoadEvents, etc these can be dynamically updated. We compute the row counts for each table and view. This is generated by running the stored procedure spMakeDiagnostics. The table was replicated upon the creation of the database into SiteDiagnostics.
emissionLinesPortSPECTRO Emission line kinematics results for SDSS and BOSS galaxies using GANDALF
We fit galaxies using an adaptation of the publicly available Gas AND Absorption Line Fitting (GANDALF, Sarzi et al. 2006) and penalised PiXel Fitting (pPXF, Cappellari & Emsellem 2004). Stellar population models for the continuum are from of Maraston & Strömbäck (2011) and Thomas, Maraston & Johansson (2011).
FieldPHOTO All the measured parameters and calibrations of a photometric field
A field is a 2048x1489 pixel section of a camera column. This table contains summary results of the photometric and calibration pipelines for each field.
FieldProfilePHOTO The mean PSF profile for the field as determined from bright stars.
For the profile radii, see the ProfileDefs table.
FileGroupMapMETA For 'big' databases, maps big tables to their own file groups
In big databases we only put core objects in the primary file group. Other objects are grouped into separate file groups. For really big files, the indices are put in even different groups. This table is truncated in the Task databases.
FIRSTPHOTO SDSS objects that match to FIRST objects have their match parameters stored here
FramePHOTO Contains JPEG images of fields at various zoom factors, and their astrometry.
The frame is the basic image unit. The table contains false color JPEG images of the fields, and their most relevant parameters, in particular the coefficients of the astrometric transformation, and position info. The images are stored at several zoom levels.
galSpecExtraSPECTRO Estimated physical parameters for all galaxies in the MPA-JHU spectroscopic catalogue.
The estimates for stellar mass are derived using the methodology described in Kauffmann et al (2003), applied to photometric data as described in Salim et al (2007). The star formation rates are derived as discussed in Brinchmann et al (2004), but the aperture corrections are done by estimating SFRs from SED fits to the photometry outside the fiber following the methodology in Salim et al (2007).
galSpecIndxSPECTRO Index measurements of spectra from the MPA-JHU spectroscopic catalogue.
For each index, we give our estimate and error bar. Measurements performed as described in Brinchmann et al. 2004.
galSpecInfoSPECTRO General information for the MPA-JHU spectroscopic re-analysis
This table contains one entry per spectroscopic observation It may be joined with the other galSpec tables with the measurements, or to specObjAll, using specObjId. Numbers given here are for the version of data used by the MPA-JHU and may not be in perfect agreement with specObjAll.
galSpecLineSPECTRO Emission line measurements from MPA-JHU spectroscopic reanalysis
The table contains one entry per spectroscopic observation derived as described in Tremonti et al (2004) and Brinchmann et al (2004).
HalfSpaceREGION The constraints for boundaries of the the different regions
Boundaries are represented as the equation of a 3D plane, intersecting the unit sphere. These intersections are great and small circles. THe representation is in terms of a 4-vector, (x,y,z,c), where (x,y,z) are the components of a 3D normal vector pointing along the normal of the plane into the half-scape inside our boundary, and c is the shift of the plane along the normal from the origin. Thus, c=0 constraints represent great circles. If c<0, the small circle contains more than half of the sky. See also the Region and RegionConvex tables
HistoryMETA Contains the detailed history of schema changes
The changes are tracked by module
IndexMapMETA Table containing the definition of all indices
Contains all information necessary to build the indices including the list of fields. Drives both index creation and data validation.
InventoryMETA Contains the detailed inventory of database objects
The objects are tracked by module
LoadHistoryMETA Tracks the loading history of the database
Binds the loadversion value to dates and Task names
mangaDrpAllSPECTRO Final summary file of the MaNGA Data Reduction Pipeline (DRP).
Contains all of the information required to find a given set of spectra for a target.
mangaFireflySPECTRO Contains the measured stellar population parameters for each MaNGA galaxy.
This is a base table containing spectroscopic information and the results of the FIREFLY fits on the MaNGA Voronoi binned spectra with S/N threshold of 10. This run has been computed using Maraston & Stromback (M11, 2011) models with the MILES stellar library and a Kroupa stellar initial mass function.
mangaPipe3DSPECTRO Data products of MaNGA cubes derived using Pipe3D.
Contains all the information of each data product.
mangatargetSPECTRO MaNGA Target Catalog
The MaNGA targeting catalog, v1_2_18. This table contains the details of the three main MaNGA samples, Primary, Secondary and Color-Enhanced, as well as the ancillary targets. In addition to the targeting information there are details of the tile and IFU allocation as of 03/10/2016. This tiling and allocation details may change slightly as the survey evolves. Also included are various useful parameters from the NASA-Sloan Atlas (NSA) catalog, v1_0_1, which was used to select almost all of the targets. A few ancillary targets may have been selected from elsewhere. Targets cover the full SDSS spectroscopic DR7 region, although only approximately 1/3 will be observed in the final survey.
marvelsStarSPECTRO Contains data for a MARVELS star.
This table corresponds to the data for a star whose velocity curve is measured in MARVELS.
marvelsVelocityCurveUF1DSPECTRO Contains data for a particular MARVELS velocity curve using UF1D technique.
This table corresponds to the data in a single velocity curve measurement
MaskPHOTO Contains a record describing the each mask object
MaskedObjectPHOTO Contains the objects inside a specific mask
This is a list of all masked objects. Each object may appear multiple times, if it is masked for multiple reasons.
NeighborsNEIGHBORS All PhotoObj pairs within 0.5 arcmins
SDSS objects within 0.5 arcmins and their match parameters stored here. Make sure to filter out unwanted PhotoObj, like secondaries.
nsatlasSPECTRO NASA-Sloan Atlas catalog
The NASA-Sloan Atlas (NSA) catalog, v1_0_1. This NSA sample was selected to include virtually all known redshifts out to about z < 0.15 for galaxies within the coverage of SDSS DR11. For each such galaxy, we have created image mosaics from SDSS and GALEX and rephotometered the ugriz bands plus the far and near ultraviolet bands in a self-consistent manner. After cleaning a number of suspicious cases the final catalog contains about 640,000 galaxies. See http://nsatlas.org for more information.

We recommend the use of the elliptical Petrosian photometry from this catalog. K-corrected absolute magnitudes are provided using kcorrect v4_2.

There are cases of elliptical Petrosian quantities in this file with _r_original suffices (e.g. petro_flux_r_original), to indicate that these are the original quantities determined for the r-band, without corrections. They differ from the r-band values in the arrays (e.g. petro_flux_r_original) in those cases where the Petrosian radius was undefined in the r-band. In those cases, the quantities in the arrays assume a Petrosian radius of 5 arcsec.

All absolute magnitudes are given with H0 = 100 h km s-1 Mpc-1, so should be interpreted as M - 5 log10 h.
PartitionMapMETA Shows the names of partitions/filegroups and their relative sizes
PhotoObjAllPHOTO The full photometric catalog quantities for SDSS imaging.
This table contains one entry per detection, with the associated photometric parameters measured by PHOTO, and astrometrically and photometrically calibrated.

The table has the following views:

  • PhotoObj: all primary and secondary objects; essentially this is the view you should use unless you want a specific type of object.
  • PhotoPrimary: all photo objects that are primary (the best version of the object).
    • Star: Primary objects that are classified as stars.
    • Galaxy: Primary objects that are classified as galaxies.
    • Sky:Primary objects which are sky samples.
    • Unknown:Primary objects which are no0ne of the above
  • PhotoSecondary: all photo objects that are secondary (secondary detections)
  • PhotoFamily: all photo objects which are neither primary nor secondary (blended)

The table has indices that cover the popular columns.

PhotoObjAllSCHEMA The full photometric catalog quantities for SDSS imaging.
This table contains one entry per detection, with the associated photometric parameters measured by PHOTO, and astrometrically and photometrically calibrated.

The table has the following views:

  • PhotoObj: all primary and secondary objects; essentially this is the view you should use unless you want a specific type of object.
  • PhotoPrimary: all photo objects that are primary (the best version of the object).
    • Star: Primary objects that are classified as stars.
    • Galaxy: Primary objects that are classified as galaxies.
    • Sky:Primary objects which are sky samples.
    • Unknown:Primary objects which are no0ne of the above
  • PhotoSecondary: all photo objects that are secondary (secondary detections)
  • PhotoFamily: all photo objects which are neither primary nor secondary (blended)

The table has indices that cover the popular columns.

PhotoObjDR7PHOTO Contains the spatial cross-match between DR8 photoobj and DR7 photoobj.
This is a unique match between a DR8 photoobj and a DR7 photoobj, and matches are restricted to the same run/camcol/field. The match radius is 1 arcsec, and within this radius preference is given to a photoprimary match over a secondary. If no primary match exists, the nearest secondary match is chosen. If more than one match of a given mode exists, the nearest one is chosen. The table contains the DR8 and DR7 objids and modes, the distance between them, and the DR7 phototag quantities.
PhotoPrimaryDR7PHOTO Contains the spatial cross-match between DR8 primaries and DR7 primaries.
This is a unique match between a DR8 photoprimary and a DR7 photoprimary, and matches between different run/camcol/field are allowed. The match radius is 1 arcsec. The table contains the DR8 and DR7 objids, the distance between them and the DR7 phototag quantities.
PhotoProfilePHOTO The annulus-averaged flux profiles of SDSS photo objects
For the profile radii, see the ProfileDefs table.
PhotozPHOTO The photometrically estimated redshifts for all objects in the GalaxyTag view.
Estimation is based on a robust fit on spectroscopically observed objects with similar colors and r magnitude.
Please see the Photometric Redshifts entry in Algorithms for more information about this table.
NOTE: This table may be empty initially because the values are computed in a separate calculation after the main data release.
PhotozErrorMapPHOTO The error map of the photometric redshift estimation
This is a supplementary table to the Photoz table, providing information about the dependence of estimation errors on the location in color/magnitude space.
All numbers are based on the results of the training set, and evaluated on a grid in r magnitude, and g-r, r-i colors.
NOTE: This table may be empty initially because the values are computed in a separate calculation after the main data release.
Plate2TargetTILES Which objects are in the coverage area of which plates?
This table has an entry for each case of a target from the sppTargets table having been targetable by a given plate. Can be joined with plateX on the PLATEID column, and with sppTargets on the OBJID column. Some plates are included that were never observed; the PLATEID values for these will not match any entries in the plateX table.
PlateXSPECTRO Contains data from a given plate used for spectroscopic observations.
Each SDSS spectrograph plate has 640 observed spectra, whereas each BOSS spectrograph plate has 1000 observed spectra.
ProfileDefsMETA This table contains the radii for the Profiles table
Radii of boundaries of annuli, and number of pixels involved. aAnn is the area of the annulus, and aDisk is the area of the disk out to rOuter. The second column gives the first cell in the annulus, and the third indicates if the values in that annulus are derived from sinc shifting the image to center it on a pixel.
for details see http://www.astro.princeton.edu/~rhl/photomisc/profiles.ps
ProperMotionsPHOTO Proper motions combining SDSS and recalibrated USNO-B astrometry.
These results are based on the technique described in Munn et al. 2004, AJ, 127, 3034
PubHistoryMETA This table keeps the record of publishing into a table
this table only gets written into if this is a destination database. The table contains the names of the tables which were published into The table is wrttien by the publisher. It can be compared at the end to the contents of the Diagnostics table.
qsoVarPTFSPECTRO Variability information on eBOSS quasar targets using PTF lightcurves.
The table 'qsoVarPTF' contains variability informations for most DR13 QSO targets (EBOSS_TARGET1=0,9,10,11,12), derived from the combination of SDSS and PTF photometries, on a large fraction of the eBOSS footprint. Due to the inhomogeneity of the PTF sky survey, the sensitivity of these variability measurements is highly variable as a function of sky coordinates.
qsoVarStripeSPECTRO Variability information on eBOSS quasar targets using SDSS stripe 82 data.
The table 'qsoVarStripe' contains additional informations derived from essentially all multi-epoq SDSS photometry carried out in the Stripe 82 region.
QueryResultsMETA Store the results of performance tests here
RC3PHOTO RC3 information for matches to SDSS photometry
All matches to the Third Reference Source Catalog within 6 arcsec are included. RC3 positions were updated with latest NED positions in 2008.
RecentQueriesMETA Record the ipAddr and timestamps of the last n queries
Query log table to record last n query IPs and timestamps so that queries can be restricted to a certain number per minute per IP to prevent crawlers from hogging the system (see spExecuteSQL).
RegionREGION Definition of the different regions
We have various boundaries in the survey, represented by equations of 3D planes, intersecting the unit sphere, describing great and small circles, respectively. This table stores the description of a region, the details are in the HalfSpace table.
  • CHUNK - the boundary of a given Chunk
  • STRIPE - the boundary of the whole stripe
  • STAVE - the unique boundary of the whole stripe, agrees with STRIPE for Southern stripes
  • PRIMARY - the primary region of a given CHUNK
  • SEGMENT - the idealized boundary of a segment
  • CAMCOL - the real boundary of a segment
  • PLATE - the boundary of a plate
  • TILE - the boundary of a circular tile
  • TIGEOM - the boundary of a Tiling Run, also includes inverse regions, which must be excluded
  • RUN - the union of the CAMCOLs making up a Run
  • WEDGE -- intersection of tiles as booleans.
  • TILEBOX -- intersection of TIGEOM respecting masks (these are positive convex TIGEOM)
  • SKYBOX -- intersection and union of TILEBOX to cover the sky with positive disjoin convex regions.
  • SECTORLETS -- intersection of Skyboxes with wedges. These are the areas that have targets.
  • SECTORS -- collects together all the sectorlets with the same covering (and excluded) tiles.
    See also the RegionConvex and Halfspace tables
Region2Box Tracks the parentage which regions contribute to which boxes
For the sector computation, Region2Box tracks the parentage of which regions contribute to which boxs. TileRegions contribute to TileBoxes TileRegions and TileBoxes contribute to SkyBoxes Wedges and SkyBoxes contribute to Sectorlets Sectorlets contribute to Sectors
RegionArcsREGION Contains the arcs of a Region with their endpoints
An arc has two endpoints, specified via their equatorial coordinates, and the equation of the circle (x,y,z,c) of the arc. The arc is directed, the first point is the beginning, the second is the end. The arc belongs to a Region, a Convex and a patch. A patch is a contigous area of the sky. Within a patch the consecutive arcids represent a counterclockwise ordering of the vertices.
RegionPatchREGION Defines the attributes of the patches of a given region
Regions are the union of convex hulls and are defined in the Region table. Convexes are the intersection of halfspaces defined by the HalfSpace table. Each convex is then broken up into a set of Patches, with their own bounding circle. See also the Region table
RegionTypes
RmatrixREGION Contains various rotation matrices between spherical coordinate systems
The mode field is a 3-letter code indicating the transformation:
  • S2J - Survey-to-J2000
  • G2J - Galactic-to-J2000
  • J2G - J2000-to-Galactic
  • J2S - J2000-to-Survey
ROSATPHOTO ROSAT All-Sky Survey information for matches to SDSS photometry
All matches of SDSS photometric catalog objects to ROSAT All Sky Survey. Both faint and bright sources used here (indicated as 'faint' or 'bright' in CAT column. See detailed documentation at http://www.xray.mpe.mpg.de/rosat/survey/rass-bsc/
Run Contains the basic parameters associated with a run
A run corresponds to a single drift scan.
RunShiftMETA The table contains values of the various manual nu shifts for runs
In the early runs the telescope was sometimes not tracking correctly. The boundaries of some of the runs had thus to be shifted by a small amount, determined by hand. This table contains these manual corrections. These should be applied to the nu values derived for these runs. Only those runs are here, for which such a correction needs to be applied.
sdssBestTarget2Sector Map PhotoObj which are potential targets to sectors
PhotoObj should only appear once in this list because any ra,dec should belong to a unique sector
SDSSConstantsMETA This table contains most relevant survey constants and their physical units
sdssImagingHalfSpacesREGION Half-spaces (caps) describing the SDSS imaging geometry
Each row in this table corresponds to a single polygon in the SDSS imaging data window function.
sdssPolygon2FieldREGION Matched list of polygons and fields
Each row in this table corresponds to
sdssPolygonsREGION Polygons describing SDSS imaging data window function
Each row in this table corresponds to a single polygon in the SDSS imaging data window function.
sdssSector Stores the information about set of unique Sector regions
A Sector is defined as a distinct intersection of tiles and TilingGeometries, characterized by a unique combination of intersecting tiles and a list of tilingVersions. The sampling rate for any targets is unambgously defined by the number of tiles involved (nTiles) and the combination of targetVersion.
sdssSector2Tile Match tiles to sectors, wedges adn sectorlets, and vice versa.
This table is designed to be queried in either direction - one can get all the tiles associated with a sector, or one can find all the sectors to which a tile belongs.
sdssTargetParamTILES Contains the parameters used for a version of the target selection code
sdssTileAllTILES Contains information about each individual tile on the sky.
Each 'tile' corresponds to an SDSS-I or -II spectroscopic observation. The tile covers a region of the 1.49 deg in radius, and corresponds to one or more observed plates. At the time the tile was created, all of the 'tiled target' categories (galaxies, quasars, and some very special categories of star) were assigned fibers; later other targets were assigned fibers on the plate.
sdssTiledTargetAllTILES Information on all targets run through tiling for SDSS-I and SDSS-II
This table is the full list of all targets that were run through the SDSS tiling routines. targetID refers to the SDSS object ID associated with the CAS DR7.
sdssTilingGeometryTILES Information about boundary and mask regions in SDSS-I and SDSS-II
This table contains both tiling boundary and mask information.
sdssTilingInfoTILES Results of individual tiling runs for each tiled target
This table has entry for each time a target was input into the SDSS tiling routines. targetID refers to the SDSS object ID associated with the CAS DR7. To get target information, join this table with sdssTiledTargets on targetID.
sdssTilingRunTILES Contains basic information for a run of tiling Contains basic information for a run of tiling
segueTargetAllSPECTRO SEGUE-1 and SEGUE-2 target selection run on all imaging data
This table gives the results for SEGUE target selection algorithms for the full photometric catalog. The target flags in these files are not the ones actually used for the SEGUE-1 and SEGUE-2 survey. Instead, they are derived from the final photometric data set from DR8. Only objects designated RUN_PRIMARY have target selection flags set.
SiteConstantsMETA Table holding site specific constants
SiteDBs Table containing the list of DBs at this CAS site.
The SiteDBs table contains the name, short description and status of each db available for user access in this CAS server. This is used to auto-generate the list of available user databases on the SkyServer front page (at least for the collab and astro sites).
SiteDiagnosticsMETA This table stores the full diagnostic snapshot after the last revision
The table contains the names of all the tables, views, stored procedures and user defined functions in the database. We leave out the Diagnostics itself, QueryResults and LoadEvents, these can be dynamically updated. This was generated from the Diagnostics table when the DB was created.
SkipFinishPhases List the FINISH step phases that should be skipped
For various reasons (especially in incremental loading mode), it is necessary to skip one or more phases in spFinishStep. This table provides a way to do that by listing those phase names here. This is an admin-only table, not for user consumption.
SpecDR7SPECTRO Contains the spatial cross-match between DR8 SpecObjAll and DR7 primaries.
This is a unique match between a DR8 SpecObjAll and a DR7 photoprimary within 1 arcsec. DR7 PhotoTag columns and relevant DR7 ProperMotions are also included for convenience.
SpecObjAllSPECTRO Contains the measured parameters for a spectrum.
This is a base table containing ALL the spectroscopic information, including a lot of duplicate and bad data. Use the SpecObj view instead, which has the data properly filtered for cleanliness. These tables contain both the BOSS and SDSS spectrograph data. NOTE: The RA and Dec in this table refer to the DR8 coordinates, which have errors in the region north of 41 deg in Dec. This change does not affect the matching to the photometric catalog.
SpecPhotoAllFINISH The combined spectro and photo parameters of an object in SpecObjAll
This is a precomputed join between the PhotoObjAll and SpecObjAll tables. The photo attibutes included cover about the same as PhotoTag. The table also includes certain attributes from Tiles.
sppLinesSPECTRO Contains outputs from the SEGUE Stellar Parameter Pipeline (SSPP).
Spectra for over 500,000 Galactic stars of all common spectral types are available with DR8. These Spectra were processed with a pipeline called the SEGUE Stellar Parameter Pipeline (SSPP, Lee et al. 2008) that computes line indices for a wide range of common features at the radial velocity of the star in question. Note that the line indices for TiO5, TiO8, CaH1, CaH2, and CaH3 are calculated following the prescription given by the Hammer program (Covey et al. 2007). UVCN and BLCN line indices are computed by he equations given in Smith & Norris (1982), and FeI_4 and FeI_5 indices by the recipe in Friel (1987). FeI_1, FeI_2, FeI_3, and SrII line indices are only computed from the local continuum. Thus, these line indices calculated from different methods report the same values for both the local continuum and the global continuum. These outputs are stored in this table, and indexed on the specObjID key index parameter for queries joining to other tables such as specobjall and photoobjall. See the Sample Queries in SkyServer for examples of such queries.
sppParamsSPECTRO Contains outputs from the SEGUE Stellar Parameter Pipeline (SSPP).
Spectra for over 500,000 Galactic stars of all common spectral types are available with DR8. These Spectra were processed with a pipeline called the SEGUE Stellar Parameter Pipeline' (SSPP, Lee et al. 2008) that computes standard stellar atmospheric parameters such as [Fe/H], log g and Teff for each star by a variety of methods. These outputs are stored in this table, and indexed on the specObjID' key index parameter for queries joining to other tables such as specobjall and photoobjall. bestobjid is also added (and indexed?) Note that all values of -9999 indicate missing or no values. See the Sample Queries in SkyServer for examples of such queries.
sppTargetsSPECTRO Derived quantities calculated by the SEGUE-2 target selection pipeline.
There are one of these files per plate. The file has one HDU. That HDU has one row for every object in photoObjAll that is classified as a star inside a 94.4 arcmin radius of the center of the plate. The data for each object are elements of the photoObjAll, specObjAll, sppPrams and propermotions tables taken unaltered from the CAS and derived quantities calculated by the segue-2 target selection code. Appended to the end are the two target selection bitmasks, segue2_target1 and segue2_target2, as set by the target selection code.

Columns from OBJID through PSFMAGERR_:
These are taken directly from photoObjAll

Columns from PLATEID through SEGUE2_TARGET2:
These are taken from the specObjAll and sppParams tables for any objects in this file that have matches in that specObjAll. For objects without matches in specObjAll, values are set to -9999. The names from SpecObjAll are unchanged.

Columns from MATCH through DIST20:
These are taken from the propermotions table, the USNOB proper motions as recalibrated with the SDSS by Jeff Munn. For objects without matches in the ProperMotions table, values are set to -9999. The names are unchanged from the propermotions table.

Columns from uMAG0 through VTOT_GALRADREST:
These are the derived quanitites calculated by the procedure calderivedquantities in derivedquant.pro in the segue-2 target selection code. With the addition of these, this file contains all the quanitites that the selection code operates on when choosing targets.

Columns MG_TOHV through V1SIGMAERR_TOHV:
These were added for the November 2008 drilling run and after. The earlier files will be retrofit (eventually).
stellarMassFSPSGranEarlyDustSPECTRO Estimated stellar masses for SDSS and BOSS galaxies (Granada method, early-star-formation with dust)
Stellar masses using FSPS models of Conroy et al. (2009) fit to SDSS photometry in ugriz. The fit is carried out on extinction corrected model magnitudes that are scaled to the i-band c-model magnitude. This 'early-star-formation' version restricts the assumption about when the star-formation in the galaxy could occur to within 2 Gyrs of the Big Bang. This version also fits for dust extinction.
stellarMassFSPSGranEarlyNoDustSPECTRO Estimated stellar masses for SDSS and BOSS galaxies (Granada method, early-star-formation with dust)
Stellar masses using FSPS models of Conroy et al. (2009) fit to SDSS photometry in ugriz. The fit is carried out on extinction corrected model magnitudes that are scaled to the i-band c-model magnitude. This 'early-star-formation' version restricts the assumption about when the star-formation in the galaxy could occur to within 2 Gyrs of the Big Bang. This version assumes no dust extinction.
stellarMassFSPSGranWideDustSPECTRO Estimated stellar masses for SDSS and BOSS galaxies (Granada method, early-star-formation with dust)
Stellar masses using FSPS models of Conroy et al. (2009) fit to SDSS photometry in ugriz. The fit is carried out on extinction corrected model magnitudes that are scaled to the i-band c-model magnitude. This 'wide-star-formation' version allows an extended star-formation history. This version also fits for dust extinction.
stellarMassFSPSGranWideNoDustSPECTRO Estimated stellar masses for SDSS and BOSS galaxies (Granada method, early-star-formation with dust)
Stellar masses using FSPS models of Conroy et al. (2009) fit to SDSS photometry in ugriz. The fit is carried out on extinction corrected model magnitudes that are scaled to the i-band c-model magnitude. This 'wide-star-formation' version allows an extended star-formation history. This version assumes no dust extinction.
stellarMassPassivePortSPECTRO Estimated stellar masses for SDSS and BOSS galaxies (Portsmouth method, passive model)
Stellar masses using the method of Maraston et al. (2009). These fit passive stellar evolution models to the SDSS photometry, using the known redshifts. The model is a instantaneous burst stellar population whose age is fit for (with a minimum allowed age of 3 Gyrs). The population is 97% solar metallicity and 3% metal-poor, by mass. In this table we assume the Kroupa IMF.
stellarMassPCAWiscBC03SPECTRO Estimated stellar masses for SDSS and BOSS galaxies (Wisconsin method, Bruzual-Charlot models)
Stellar masses using the method of Chen et al. (2012). In this table, the best estimate of stellar mass is 'mstellar_median'. This version of the table uses the Bruzual and Charlot (2003) stellar population synthesis models. Please use the 'warning' values to check for data quality: warning = 0 : Results correspond to a best-fit PCA spectrum (no problems detected) warning = 1 : Target redshift too small (z < 0.05) warning = 2 : Target redshift too large (z > 0.80) warning = 3 : READSPEC cannot get wavelength vector warning = 4 : Available wavelengths all outside PCA coverage warning = 5 : Unable to project projection wavelength range warning = 6 : Unable to select projection wavelength range warning = 7 : Minimum chi^2 less than zero warning = 8 : Total of log mass PDF equal to zero warning = 9 : Total of velocity dispersion PDF equal to zero
stellarMassPCAWiscM11SPECTRO Estimated stellar masses for SDSS and BOSS galaxies (Wisconsin method, Maraston models)
Stellar masses using the method of Chen et al. (2012). In this table, the best estimate of stellar mass is 'mstellar_median'. This version of the table uses the Maraston and Stromback (2011) stellar population synthesis models. Please use the 'warning' values to check for data quality: warning = 0 : Results correspond to a best-fit PCA spectrum (no problems detected) warning = 1 : Target redshift too small (z < 0.05) warning = 2 : Target redshift too large (z > 0.80) warning = 3 : READSPEC cannot get wavelength vector warning = 4 : Available wavelengths all outside PCA coverage warning = 5 : Unable to project projection wavelength range warning = 6 : Unable to select projection wavelength range warning = 7 : Minimum chi^2 less than zero warning = 8 : Total of log mass PDF equal to zero warning = 9 : Total of velocity dispersion PDF equal to zero
stellarMassStarformingPortSPECTRO Estimated stellar masses for SDSS and BOSS galaxies (Portsmouth method, star-forming model).
Stellar masses using the method of Maraston et al. (2006). These fit stellar evolution models to the SDSS photometry, using the known BOSS redshifts. The star-formation model uses a metallicity (specified in the 'metallicity' column) and one of three star-formation histories: constant, truncated, and exponentially declining ('tau'). The type, and relevant time scale, are given in the 'SFH' column. The 'age' listed gives the start time for the onset of star-formation in each model. In this table we assume the Kroupa IMF.
StripeDefsPHOTO This table contains the definitions of the survey layout as planned
The lower and upper limits of the actual stripes may differ from these values. The actual numbers are found in the Segment and Chunk tables.
TargetTILES Keeps track of objects chosen by target selection and need to be tiled.
Objects are added whenever target selection is run on a new chunk. Objects are also added when southern target selection is run. In the case where an object (meaning run,rerun,camcol,field,id) is targetted more than once, there will be only one row in Target for that object, but there will multiple entries for that Target in the TargetInfo table.
TargetInfoTILES Unique information for an object every time it is targeted
thingIndexPHOTO Full list of all 'things': unique objects in the SDSS imaging
Each row in this table corresponds to a single 'thing' observed by the SDSS imaging survey. By joining with the 'detectionIndex' table one can retrieve all of the observations of a particular thing. NOTE: The RA and Dec in this table refer to the DR8 coordinates, which have errors in the region north of 41 deg in Dec, since those were used for the resolving of the survey. These errors should have a very small effect on the decision about which objects are matched to each other.
TwoMassPHOTO 2MASS point-source catalog quantities for matches to SDSS photometry
This table contains one entry for each match between the SDSS photometric catalog (photoObjAll) and the 2MASS point-source catalog (PSC). See http://tdc-www.harvard.edu/catalogs/tmc.format.html for full documentation.
TwoMassXSCPHOTO 2MASS extended-source catalog quantities for matches to SDSS photometry
This table contains one entry for each match between the SDSS photometric catalog (photoObjAll) and the 2MASS extended-source catalog (XSC). See http://tdc-www.harvard.edu/catalogs/tmx.format.html for full documentation.
USNOPHOTO SDSS objects that match to USNO-B objects have their match parameters stored here
The source for this is the USNO-B1.0 catalog (Monet et al. 2003, AJ, 125, 984). This is simply the closest matching USNO-B1.0 object. See the ProperMotions table for proper motions after recalibrating USNO and SDSS astrometry. USNO-B contains five imaging surveys, two early epochs from POSS-I, and three later epochs from POSS-II, SERC and AAO.
VersionsMETA Tracks the versioning history of the database
This is a log of all major changes that happened to the DB since its creation.
WISE_allskyFINISH WISE All-Sky Data Release catalog
The WISE catalog. The columns have mostly been copied without modification from the WISE catalog distributed by IRSA, so that documentation (mostly copied here) largely applies; http://wise2.ipac.caltech.edu/docs/release/allsky/expsup/sec2_2a.html Exceptions include some gratuitous column renames: w*sigsk -> w*sigsky w*gerr -> w*siggmag And some WISE columns have been combined: ext_bit, na, nb -> blend_ext_flags ph_qual, det_bit -> phqual_det_* And some WISE columns have been unpacked into 4 columns, one per band: var_flg, moon_lev, satnum Null values are represented with: w*mjd{min,max,mean}: -9999 w*snr: -9999 w*{flux,sky}: -9999 all others: 9999
WISE_allskyPHOTO WISE All-Sky Data Release catalog
The WISE catalog. The columns have mostly been copied without modification from the WISE catalog distributed by IRSA, so that documentation (mostly copied here) largely applies; http://wise2.ipac.caltech.edu/docs/release/allsky/expsup/sec2_2a.html Exceptions include some gratuitous column renames: w*sigsk -> w*sigsky w*gerr -> w*siggmag And some WISE columns have been combined: ext_bit, na, nb -> blend_ext_flags ph_qual, det_bit -> phqual_det_* And some WISE columns have been unpacked into 4 columns, one per band: var_flg, moon_lev, satnum Null values are represented with: w*mjd{min,max,mean}: -9999 w*snr: -9999 w*{flux,sky}: -9999 all others: 9999
WISE_xmatchPHOTO Astrometric cross-matches between SDSS and WISE objects.
This is a 'join table' which contains 'pointers' to the matched objects in the SDSS and WISE tables. The SDSS objects appear in the PhotoObjAll, PhotoObj,and PhotoTag tables. The WISE objects appear in the WISE_allsky table. Eg, to get r- and W1-band magnitudes of matched objects: 'select s.psfmag_r as r, w.w1mpro as w1 from wise_xmatch as xm join photoObjAll as s on xm.sdss_objid = s.objid join wise_allsky as w on xm.wise_cntr = w.cntr'
wiseForcedTargetPHOTO WISE forced-photometry of SDSS primary sources.
This table contains one entry for each SDSS primary object. See http://arxiv.org/abs/1410.7397 for the method.
ZoneZONE Table to organize objects into declination zones
In order to speed up all-sky corss-correlations, this table organizes the PhotoObj into 0.5 arcmin zones, indexed by the zone number and ra.
zoo2MainPhotozPHOTO Description: Morphological classifications of main-sample galaxies with photometric redshifts only from Galaxy Zoo 2
This table includes galaxies without spectra in SDSS Data Release 7. Several columns give data that can be used to cross-match rows with other SDSS tables, including objIDs and positions of the galaxies. Morphological classifications include six parameters for each category: unweighted and weighted versions of both the total number of votes and the vote fraction for that response, the vote fraction after being debiased, and flags for systems identified as being in clean samples. Reference: The project and data release are described in Willett et al. (2013, in prep). Please cite this paper if making use of any data in this table in publications.
zoo2MainSpeczSPECTRO Morphological classifications of main-sample spectroscopic galaxies from Galaxy Zoo 2.
This table includes galaxies with spectra in SDSS Data Release 7. Several columns give data that can be used to cross-match rows with other SDSS tables, including objIDs and positions of the galaxies. Morphological classifications include six parameters for each category: unweighted and weighted versions of both the total number of votes and the vote fraction for that response, the vote fraction after being debiased, and flags for systems identified as being in clean samples. Note that this table and zoo2Stripe82Normal contain some of the same galaxies (with r < 17.0). Reference: The project and data release are described in Willett et al. (2013, in prep). Please cite this paper if making use of any data in this table in publications.
zoo2Stripe82Coadd1SPECTRO Morphological classifications of Stripe 82, coadded (sample 1) spectroscopic galaxies from Galaxy Zoo 2
This table includes classifications from coadded images of Stripe 82 galaxies in SDSS Data Release 7. The co-addition method is described in Willett et al.; it differs from the second sample in that these images did NOT desaturate color in their noisy background pixels. Several columns give data that can be used to cross-match rows with other SDSS tables, including objIDs and positions of the galaxies. Morphological classifications include six parameters for each category: unweighted and weighted versions of both the total number of votes and the vote fraction for that response, the vote fraction after being debiased, and flags for systems identified as being in clean samples. Reference: The project and data release are described in Willett et al. (2013, in prep). Please cite this paper if making use of any data in this table in publications.
zoo2Stripe82Coadd2SPECTRO Morphological classifications of Stripe 82, coadded (sample 2) spectroscopic galaxies from Galaxy Zoo 2
This table includes classifications from coadded images of Stripe 82 galaxies in SDSS Data Release 7. Sky background pixels for these co-added images were desaturated to attempt and avoid bias by classifiers, as described in Willett et al. Several columns give data that can be used to cross-match rows with other SDSS tables, including objIDs and positions of the galaxies. Morphological classifications include six parameters for each category: unweighted and weighted versions of both the total number of votes and the vote fraction for that response, the vote fraction after being debiased, and flags for systems identified as being in clean samples. Reference: The project and data release are described in Willett et al. (2013, in prep). Please cite this paper if making use of any data in this table in publications.
zoo2Stripe82NormalSPECTRO Morphological classifications of Stripe 82 normal-depth, spectroscopic galaxies from Galaxy Zoo 2
This table includes Stripe 82 galaxies with spectra in SDSS Data Release 7. Several columns give data that can be used to cross-match rows with other SDSS tables, including objIDs and positions of the galaxies. Morphological classifications include six parameters for each category: unweighted and weighted versions of both the total number of votes and the vote fraction for that response, the vote fraction after being debiased, and flags for systems identified as being in clean samples. Note that this table and zoo2MainSpecz contain some of the same galaxies (with r < 17.0). Reference: The project and data release are described in Willett et al. (2013, in prep). Please cite this paper if making use of any data in this table in publications.
zooConfidenceSPECTRO Measures of classification confidence from Galaxy Zoo.
Only galaxies with spectra in DR7 are included (those in the zooSpec table). This information is identical to that in Galaxy Zoo 1 Table 4. The project is described in Lintott et al., 2008, MNRAS, 389, 1179 and the data release is described in Lintott et al. 2010. Anyone making use of the data should cite at least one of these papers in any resulting publications.
zooMirrorBiasPHOTO Results from the bias study using mirrored images from Galaxy Zoo
This information is identical to that in Galaxy Zoo 1 Table 5. The project is described in Lintott et al., 2008, MNRAS, 389, 1179 and the data release is described in Lintott et al. 2010. Anyone making use of the data should cite at least one of these papers in any resulting publications.
zooMonochromeBiasPHOTO Results from the bias study that introduced monochrome images in Galaxy Zoo.
This information is identical to that in Galaxy Zoo 1 Table 6. The project is described in Lintott et al., 2008, MNRAS, 389, 1179 and the data release is described in Lintott et al. 2010. Anyone making use of the data should cite at least one of these papers in any resulting publications.
zooNoSpecPHOTO Morphology classifications of galaxies without spectra from Galaxy Zoo
This information is identical to that in Galaxy Zoo 1 Table 3. Some objects may have spectroscopic matches in DR8 (though they did not in DR7) It is not possible to estimate the bias in the sample, and so only the fraction of the vote in each of the six categories is given. The project is described in Lintott et al., 2008, MNRAS, 389, 1179 and the data release is described in Lintott et al. 2010. Anyone making use of the data should cite at least one of these papers in any resulting publications.
zooSpecSPECTRO Morphological classifications of spectroscopic galaxies from Galaxy Zoo
This information is identical to that in Galaxy Zoo 1 Table 2. This table includes galaxies with spectra in SDSS Data Release 7. The fraction of the vote in each of the six categories is given, along with debiased votes in elliptical and spiral categories and flags identifying systems as classified as spiral, elliptical or uncertain. The project is described in Lintott et al., 2008, MNRAS, 389, 1179 and the data release is described in Lintott et al. 2010. Anyone making use of the data should cite at least one of these papers in any resulting publications.
zooVotesPHOTO Vote breakdown in Galaxy Zoo results.
Fraction of votes in each of the six categories, combining results from the main and bias studies. This information is identical to that in Galaxy Zoo 1 Table 7. The project is described in Lintott et al., 2008, MNRAS, 389, 1179 and the data release is described in Lintott et al. 2010. Anyone making use of the data should cite at least one of these papers in any resulting publications.