Choose a database in the left panel then select the table you want!
Table: sdss_dr8.galspecinfo
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| dec | Declination of drilled fiber position | REAL |
| e_bv_sfd | E(B-V) of foreground reddening from SFD maps | REAL |
| elat | Ecliptic Latitude | DOUBLE |
| elon | Ecliptic Longitude | DOUBLE |
| fiberid | Fiber number (1 - 640) | SMALLINT |
| glat | Galactic Latitude | DOUBLE |
| glon | Galactic Longitude | DOUBLE |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| mjd | Modified Julian Date of plate observation | INTEGER |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |
| plateid | Plate number | SMALLINT |
| primtarget | Primary Target Flag (MAIN galaxy = 64) | SMALLINT |
| ra | Right Ascension of drilled fiber position | REAL |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| release | Data Release (dr1/dr2/dr3/dr4) | CHAR |
| reliable | has "reliable" line measurements and physical parameters | SMALLINT |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| sdss_joinid | Unique ID based on PLATE, MJD, FIBERID for joining across data releases | BIGINT |
| sectarget | Secondary Target Flag (QA = 8) | SMALLINT |
| sn_median | Median S/N per pixel of the whole spectrum | REAL |
| specobjid | Unique ID | BIGINT |
| spectrotype | idlspec2d pipeline classification of spectrum ... code is only run where this is set to "GALAXY" | CHAR |
| subclass | idlspec2d pipeline subclass from PCA analysis | CHAR |
| targettype | Text version of primary target (GALAXY/QA/QSO/ROSAT_D) | CHAR |
| v_disp | Velocity dispersion from idlspec2d pipeline | REAL |
| v_disp_err | Velocity dispersion error (negative for invalid fit) | REAL |
| z | Redshift from idlspec2d pipeline | REAL |
| z_err | Redshift error | REAL |
| z_warning | Bad redshift if this is non-zero | SMALLINT |
