| Spectrum and SpecFrame combination |
| Extended details for each spectrum: all the columns from table 'Spectrum' combined with some columns from its parent 'SpecFrame'. The details and SQL SELECT corresponding to this view are available here. |
| Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
|---|---|---|---|---|---|---|
| specID | bigint | 8 | Spectrum identifier: unique identifier for each spectrum (4 MSB are the specFrameID; 4 LSB are the nSpec) | -99999999 | ||
| specFrameID | int | 4 | SpecFrame identifier of the SpecFrame from which the spectrum was extracted | -99999999 | ||
| targetID | bigint | 8 | Target identifer of the star being observed | -99999999 | ||
| fileName | varchar | 256 | The GES Science Archive filename at WFAU for the specFrame, eg. /path/filename.fits. Only for UVES SingleSpec files. | 'NONE' | meta.id;meta.file | |
| nSpec | int | 4 | The number of the spectrum | -99999999 | ||
| nSpecOld | int | 4 | The number of the spectrum before unused fibres were culled (equivalent to the number of the fibre) | -99999999 | ||
| cName | varchar | 16 | Object name formed from the coordinates of the object (can be used in place of object to give a unique name) | 'NONE' | ||
| type | varchar | 32 | M for programme objects or S for sky fibres | 'NONE' | ||
| spClass | varchar | 8 | The spectral class (STAR, SKY or LOWSN; the latter two classes do not have spectral fits done for them) | 'NONE' | ||
| mag | real | 4 | mag | A magnitude estimate | -9.999995e+08 | |
| priority | int | 4 | Observation priority | -99999999 | ||
| snr | real | 4 | The mean signal-to-noise ratio in the spectrum | -9.999995e+08 | ||
| skyOff | real | 4 | pixels | Offset to get the mean sky into coincidence with the current spectrum | -9.999995e+08 | |
| skyScale | real | 4 | The scaling factor applied to the mean sky before subtracting from the current spectrum | -9.999995e+08 | ||
| expTime | real | 4 | seconds | Total integration time | ||
| rmsTrace | real | 4 | pixels | The RMS of the fit to the curvature of the spectrum on the detector | -9.999995e+08 | |
| rmsArc | real | 4 | Angstroms | The RMS of the wavelength solution | -9.999995e+08 | |
| resArc | real | 4 | The resolution of the arclines | -9.999995e+08 | ||
| fwhmArc | real | 4 | The FWHM of the arclines | -9.999995e+08 | ||
| ccfMax | real | 4 | The peak value of the cross correlation function | -9.999995e+08 | ||
| ccfWidth | real | 4 | km/s | Width of the peak of the cross correlation function | -9.999995e+08 | |
| rvRedshift | real | 4 | km/s | The radial velocity measured from the cross correlation | -9.999995e+08 | |
| rv | float | 8 | km/s | The measured radial velocity from the cross correlation | -9.999995e+08 | |
| rvErr | float | 8 | km/s | Error on the measured radial velocity from the cross correlation | -9.999995e+08 | |
| rvVar | float | 8 | km/s | Variance? on the measured radial velocity from the cross correlation | -9.999995e+08 | |
| vRot | float | 8 | km/s | The best fit rotational velocity | -9.999995e+08 | |
| vRotErr | float | 8 | km/s | Error on vRot | -9.999995e+08 | |
| helioCor | real | 4 | km/s | The heliocentric correction | -9.999995e+08 | |
| simcalCor | real | 4 | km/s | The correction to be applied to correct for wavelength drift calculated from simcal observations | -9.999995e+08 | |
| simcalRms | real | 4 | km/s | The RMS on simcalCor | -9.999995e+08 | |
| skylineCor | real | 4 | km/s | The correction to be applied to correct for wavelength drift calculated from the sky lines in the observations | -9.999995e+08 | |
| skylineRms | real | 4 | km/s | The RMS on skylineCor | -9.999995e+08 | |
| vacuumCor | real | 4 | km/s | The correction to be applied to the measured redshift if the spectral features in the template are defined in vacuum rather than at STP | -9.999995e+08 | |
| bestTempl | varchar | 64 | A designation for the best fitting radial velocity template | 'NONE' | ||
| tmplTemp | real | 4 | K | The temperature for the best fitting radial velocity template | -9.999995e+08 | |
| tmplLogg | real | 4 | The value of log(g) for the best fitting radial velocity template | -9.999995e+08 | ||
| tmplFeH | real | 4 | The value of [Fe/H] for the best fitting radial velocity template | -9.999995e+08 | ||
| chi2dof | real | 4 | Chi-squared of the template fit | -9.999995e+08 | ||
| chi2cont | real | 4 | Chi-squared of the continuum-only fit | -9.999995e+08 | ||
| templDist | real | 4 | Something to do with the radial velocity template | -9.999995e+08 | ||
| logg | real | 4 | The value of log(g) of the best fitting template | -9.999995e+08 | ||
| logTeff | real | 4 | The value of log(Teff) of the best fitting template | -9.999995e+08 | ||
| FeH | real | 4 | The value of [Fe/H] of the best fitting template | -9.999995e+08 | ||
| deprecated | int | 4 | Deprecated flag: coded as current=0 or deprecated !=0 | meta.code | ||
| instrument | varchar | 8 | Instrument name | 'NONE' | ||
| grating | varchar | 5 | nm | Grating central wavelength (as string to guarantee formatting) | 'NONE' | |
| gesType | varchar | 8 | GES Type | 'NONE' | ||
| object | varchar | 64 | Name of the frame (often the name of the guide star or a bright nearby object) | 'NONE' | ||
| Total length | 645 |