name | type | text |
apogeeDesign | Contains the plate design information for APOGEE plates. This table contains all the design parameters used in designing plates for APOGEE spectra. | |
apogeeField | Contains the basic information for an APOGEE field. This table contains the name, location and number of visits expected for an APOGEE field. | |
apogeeObject | SPECTRO | Contains the targeting information for an APOGEE object. This table contains all the parameters that went into targeting objects for APOGEE spectra. |
apogeePlate | SPECTRO | Contains all the information associated with an APOGEE plate. This table contains the parameters for an APOGEE spectral plate |
apogeeStar | SPECTRO | Contains data for an APOGEE star combined spectrum. This table contains the data in the combined spectrum for an APOGEE star. |
apogeeStarAllVisit | SPECTRO | 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. |
apogeeStarVisit | SPECTRO | 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. |
apogeeVisit | SPECTRO | Contains data for a particular APOGEE spectrum visit. This table corresponds to the data in a single spectrum visit in APOGEE |
aspcapStar | SPECTRO | Contains data for an APOGEE star ASPCAP entry. This table contains the data in the ASPCAP entry for an APOGEE star. |
aspcapStarCovar | SPECTRO | 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. |
AtlasOutline | PHOTO | 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. |
DataConstants | META | The table stores the values of various enumerated and bitmask columns. |
DBColumns | META | Every column of every table has a description in this table |
DBObjects | META | Every SkyServer database object has a one line description in this table |
DBViewCols | META | The columns of each view are stored for the auto-documentation * means that every column from the parent is propagated. |
Dependency | META | Contains the detailed inventory of database objects The objects are tracked by module |
detectionIndex | PHOTO | 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. |
Diagnostics | META | 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. |
emissionLinesPort | SPECTRO | 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). |
Field | PHOTO | 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. |
FieldProfile | PHOTO | The mean PSF profile for the field as determined from bright stars. For the profile radii, see the ProfileDefs table. |
FileGroupMap | META | 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. |
FIRST | PHOTO | SDSS objects that match to FIRST objects have their match parameters stored here |
Frame | PHOTO | 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. |
galSpecExtra | SPECTRO | Estimated physical parameters for all galaxies in the MPA-JHU spectroscopic catalogue. These parameters give the probability distribution of each parameter in terms of its percent quantiles. These estimates are derived in the manner described in Brinchmann et al. 2004 |
galSpecIndx | SPECTRO | 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. |
galSpecInfo | SPECTRO | 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. |
galSpecLine | SPECTRO | 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). |
HalfSpace | REGION | 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 |
History | META | Contains the detailed history of schema changes The changes are tracked by module |
IndexMap | META | 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. |
Inventory | META | Contains the detailed inventory of database objects The objects are tracked by module |
LoadHistory | META | Tracks the loading history of the database Binds the loadversion value to dates and Task names |
marvelsStar | SPECTRO | Contains data for a MARVELS star. This table corresponds to the data for a star whose velocity curve is measured in MARVELS. |
marvelsVelocityCurveUF1D | SPECTRO | Contains data for a particular MARVELS velocity curve using UF1D technique. This table corresponds to the data in a single velocity curve measurement |
Mask | PHOTO | Contains a record describing the each mask object |
MaskedObject | PHOTO | 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. |
Neighbors | NEIGHBORS | 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. |
PartitionMap | META | Shows the names of partitions/filegroups and their relative sizes |
PhotoObjAll | PHOTO | 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:
The table has indices that cover the popular columns. |
PhotoObjAll | SCHEMA | 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:
The table has indices that cover the popular columns. |
PhotoObjDR7 | PHOTO | 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. |
PhotoPrimaryDR7 | PHOTO | 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. |
PhotoProfile | PHOTO | The annulus-averaged flux profiles of SDSS photo objects For the profile radii, see the ProfileDefs table. |
Photoz | PHOTO | 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. |
PhotozErrorMap | PHOTO | 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. |
Plate2Target | 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. | |
PlateX | SPECTRO | 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. |
ProfileDefs | META | 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 |
ProperMotions | PHOTO | 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 |
PubHistory | META | 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. |
QueryResults | META | Store the results of performance tests here |
RC3 | PHOTO | 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. |
RecentQueries | META | 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). |
Region | REGION | 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.
|
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 | |
RegionArcs | REGION | 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. |
RegionPatch | REGION | 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 | ||
Rmatrix | REGION | Contains various rotation matrices between spherical coordinate systems The mode field is a 3-letter code indicating the transformation:
|
ROSAT | PHOTO | 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. | |
RunShift | META | 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 | |
SDSSConstants | META | This table contains most relevant survey constants and their physical units |
sdssImagingHalfSpaces | REGION | 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. |
sdssPolygon2Field | REGION | Matched list of polygons and fields Each row in this table corresponds to |
sdssPolygons | REGION | 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. | |
sdssTargetParam | TILES | Contains the parameters used for a version of the target selection code |
sdssTileAll | TILES | 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. |
sdssTiledTargetAll | TILES | 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. |
sdssTilingGeometry | TILES | Information about boundary and mask regions in SDSS-I and SDSS-II This table contains both tiling boundary and mask information. |
sdssTilingInfo | TILES | 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. |
sdssTilingRun | TILES | Contains basic information for a run of tiling Contains basic information for a run of tiling |
segueTargetAll | SPECTRO | 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. |
SiteConstants | META | 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). | |
SiteDiagnostics | META | 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. | |
SpecDR7 | SPECTRO | 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. |
SpecObjAll | SPECTRO | 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. |
SpecPhotoAll | FINISH | 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. |
sppLines | SPECTRO | 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. |
sppParams | SPECTRO | 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. |
sppTargets | 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). | |
stellarMassFSPSGranEarlyDust | SPECTRO | 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. |
stellarMassFSPSGranEarlyNoDust | SPECTRO | 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. |
stellarMassFSPSGranWideDust | SPECTRO | 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. |
stellarMassFSPSGranWideNoDust | SPECTRO | 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. |
stellarMassPassivePort | SPECTRO | 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. |
stellarMassPCAWiscBC03 | SPECTRO | 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 |
stellarMassPCAWiscM11 | SPECTRO | 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 |
stellarMassStarformingPort | SPECTRO | 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. |
StripeDefs | PHOTO | 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. |
Target | TILES | 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. |
TargetInfo | TILES | Unique information for an object every time it is targeted |
thingIndex | PHOTO | 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. |
TwoMass | PHOTO | 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. |
TwoMassXSC | PHOTO | 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. |
USNO | PHOTO | 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. |
Versions | META | Tracks the versioning history of the database This is a log of all major changes that happened to the DB since its creation. |
WISE_allsky | FINISH | 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_allsky | PHOTO | 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_xmatch | PHOTO | 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' |
Zone | ZONE | 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. |
zoo2MainPhotoz | PHOTO | 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. |
zoo2MainSpecz | SPECTRO | 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. |
zoo2Stripe82Coadd1 | SPECTRO | 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. |
zoo2Stripe82Coadd2 | SPECTRO | 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. |
zoo2Stripe82Normal | SPECTRO | 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. |
zooConfidence | SPECTRO | 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. |
zooMirrorBias | PHOTO | 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. |
zooMonochromeBias | PHOTO | 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. |
zooNoSpec | PHOTO | 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. |
zooSpec | SPECTRO | 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. |
zooVotes | PHOTO | 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. |