The SOPHIE archive

Display this selection as plain text
Show all the observations, even for long series
Search the spectra for the same objects
Apply the same selection to the Elodie archive
Get the wget commands to download all the selected crosscorrelation functions	Explanations

Sky search

in a	of by arcmin half-side

Constrain any fields, choose the fields to display, and order the recordsSQL
Field		Constraint	Show	Sort
seq
objname
date
slen
mask
ccf_offline
rv	rv err
fwhm
span
maxcpp
contrast
lines
view_head
get_ccf
view_ccf
ra
dec
sseq
dvrms
obstype
expno
nexp
sn26
targetname
target_sptype
target_mv
mjd
bjd

Choose the fields to display, set SQL constrains, and order the recordsfield constraints
SELECT [List of fields to display]
seq,$link[objname],date,$link[slen],mask,ccf_offline,$field[rv],fwhm,span,maxcpp,contrast,lines,$link['view_head'],$link['get_ccf'],$link['view_ccf']
FROM sophiescc WHERE [SQL constraints]

ORDER BY [Sort key]

Query Description

Type of request:                 Extract data from a table
Name of the selected table:      sophiescc
Description of the table:        Cross-correlation functions (series truncated to the first observation)
SQL constraint on fields:        [seq =1244350]

Home

The SOPHIE archive

document.write(table_description);

Query Description