Choose a database in the left panel then select the table you want!
Table: sdss_dr8.galspecextra
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| bptclass | Emission line classification based on the BPT diagram using the methodology described in Brinchmann et al (2004). -1 means unclassifiable, 1 is star-forming, 2 means low S/N star-forming, 3 is composite, 4 AGN (excluding liners) and 5 is a low S/N LINER. | SMALLINT |
| fiberid | Fiber number (1 - 640) | SMALLINT |
| lgm_fib_p16 | The 16th percentile of the Log stellar mass within the fibre PDF using fibre photometry. | REAL |
| lgm_fib_p2p5 | The 2.5 percentile of the Log stellar mass within the fibre PDF using fibre photometry. | REAL |
| lgm_fib_p50 | The median estimate of the Log stellar mass within the fibre PDF using fibre photometry. | REAL |
| lgm_fib_p84 | The 84th percentile of the Log stellar mass within the fibre PDF using fibre photometry. | REAL |
| lgm_fib_p97p5 | The 97.5 percentile of the Log stellar mass within the fibre PDF using fibre photometry. | REAL |
| lgm_tot_p16 | The 16th percentile of the Log total stellar mass PDF using model photometry. | REAL |
| lgm_tot_p2p5 | The 2.5 percentile of the Log total stellar mass PDF using model photometry. | REAL |
| lgm_tot_p50 | The median estimate of the Log total stellar mass PDF using model photometry. | REAL |
| lgm_tot_p84 | The 84th percentile of the Log total stellar mass PDF using model photometry. | REAL |
| lgm_tot_p97p5 | The 97.5 percentile of the Log total stellar mass PDF using model photometry. | REAL |
| mjd | Modified Julian Date of plate observation | INTEGER |
| oh_entropy | The entropy (Sum p*lg(p)) of the PDF of 12 + Log O/H | REAL |
| oh_p16 | The 16 percentile of the Oxygen abundance derived using Charlot & Longhetti models. The values are reported as 12 + Log O/H. See Tremonti et al (2004) and Brinchmann et al (2004) for details. | REAL |
| oh_p2p5 | The 2.5 percentile of the Oxygen abundance derived using Charlot & Longhetti models. The values are reported as 12 + Log O/H. See Tremonti et al (2004) and Brinchmann et al (2004) for details. | REAL |
| oh_p50 | The median estimate of the Oxygen abundance derived using Charlot & Longhetti models. The values are reported as 12 + Log O/H. See Tremonti et al (2004) and Brinchmann et al (2004) for details. | REAL |
| oh_p84 | The 84th percentile of the Oxygen abundance derived using Charlot & Longhetti models. The values are reported as 12 + Log O/H. See Tremonti et al (2004) and Brinchmann et al (2004) for details. | REAL |
| oh_p97p5 | The 97.5 percentile of the Oxygen abundance derived using Charlot & Longhetti models. The values are reported as 12 + Log O/H. See Tremonti et al (2004) and Brinchmann et al (2004) for details. | REAL |
| plateid | Plate number | SMALLINT |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| sdss_joinid | Unique ID based on PLATE, MJD, FIBERID for joining across data releases | BIGINT |
| sfr_fib_entropy | The entropy (Sum p*lg(p)) of the PDF of the fiber SFR | REAL |
| sfr_fib_p16 | The 16th percentile of the Log SFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| sfr_fib_p2p5 | The 2.5 percentile of the Log SFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| sfr_fib_p50 | The median estimate of the Log SFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| sfr_fib_p84 | The 84th percentile of the Log SFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| sfr_fib_p97p5 | The 97.5 percentile of the Log SFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| sfr_tot_entropy | The entropy (Sum p*lg(p)) of the PDF of the total SFR | REAL |
| sfr_tot_p16 | The 16th percentile of the Log total SFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| sfr_tot_p2p5 | The 2.5 percentile of the Log total SFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| sfr_tot_p50 | The median estimate of the Log total SFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| sfr_tot_p84 | The 84th percentile of the Log total SFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| sfr_tot_p97p5 | The 97.5 percentile of the Log total SFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| specobjid | Unique ID | BIGINT |
| specsfr_fib_entropy | The entropy (Sum p*lg(p)) of the PDF of the fiber SPECSFR | REAL |
| specsfr_fib_p16 | The 16th percentile of the Log SPECSFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| specsfr_fib_p2p5 | The 2.5 percentile of the Log SPECSFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| specsfr_fib_p50 | The median estimate of the Log SPECSFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| specsfr_fib_p84 | The 84th percentile of the Log SPECSFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| specsfr_fib_p97p5 | The 97.5 percentile of the Log SPECSFR within the fiber PDF. For galaxies of the star-forming class, emission lines were used (c.f. Brinchmann et al 2004) while for others models were fit to the fibre photometry.. | REAL |
| specsfr_tot_entropy | The entropy (Sum p*lg(p)) of the PDF of the total SPECSFR | REAL |
| specsfr_tot_p16 | The 16th percentile of the Log total SPECSFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| specsfr_tot_p2p5 | The 2.5 percentile of the Log total SPECSFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| specsfr_tot_p50 | The median estimate of the Log total SPECSFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| specsfr_tot_p84 | The 84th percentile of the Log total SPECSFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
| specsfr_tot_p97p5 | The 97.5 percentile of the Log total SPECSFR PDF. This is derived by combining emission line measurements from within the fibre where possible and aperture corrections are done by fitting models ala Gallazzi et al (2005), Salim et al (2007) to the photometry outside the fibre. For those objects where the emission lines within the fibre do not provide an estimate of the SFR, model fits were made to the integrated photometry. | REAL |
