This page describes how to list the recommended and other radial and rotational velocities available for a star in the iDR5 release of the GES Science Archive. As usual the recommended values are tabulated in view RecommendedAstroAnalysis (with a single exception, see below). Recall that it is Consortium policy that only recommended values can be used in publications.

All radial and rotational velocities in the archive are in km/sec. The radial velocities are heliocentric and have the usual convention that positive values correspond to recession. All rotational velocities are, of course, projected rotational velocities.

Recommended Radial and Rotational Velocities

The iDR5 recommended radial and rotational velocities are tabulated in view RecommendedAstroAnalysis (with one exception noted below) as follows:

Quantity	RecommendedAstroAnalysis
Radial velocity	Vrad
Radial velocity error	VradErr
Radial velocity provenance	VRadProv
Offset applied to VRAD calculated as per SETUP to HR10 (details in the WG15 report)	VradOffset
Spectrum file(s) used for determination of VRAD (and SNR, VSINI)	VradFilename
Projected rotational velocity	vsini
Projected rotational velocity error	vsiniErr
Flag on upper limits of vsini	vsiniLim

The exception is that, as noted in the iDR5 known issues, adjustments to the GIRAFFE spectrograph to improve its spectral resolution meant that pipeline rotational velocities determined from GIRAFFE spectra in iDR5 were not reliable. Thus, in iDR5 no GIRAFFE rotational velocities are tabulated in RecommendedAstroAnalysis. In the sole case where no UVES recommended rotational velocity (column vsini) is available for a given star the GIRAFFE rotational velocities values computed for the HR15N setup by node OACT may be used without obtaining the permission of the PIs.

To query the radial and projected rotational velocities tabulated for a given star in RecommendedAstroAnalysis:

SELECT
  cname, instrument, 
  Vrad, VradErr, VradProv, VradOffset, VradFilename,
  vsini, vsiniErr, vsiniLim,
  teff, logg
FROM
  RecommendedAstroAnalysis
WHERE cName ='11053303-7700120';
      

For the OACT node values the WG-parameter/node-analysis (WgNa) analyses should be used rather than the node-parameter/node-analysis (NpNa) ones. The WgNa values are tabulated in view WgNaAstroAnalysis. Node OACT supplied values for working groups WG10 and WG12 and either may be used. To ensure that the OACT values used correspond to the recommended values for a given target star (that is, are computed from the same spectrum group) WgNaAstroAnalysis should be joined to RecommendedAstroAnalysis using the specGroupID. This approach also allows other recommended astrophysical parameters for the target star, including the recommended radial velocity, to be listed. Thus the query is of the form:

SELECT
  racc.cname, wpna.wg, wpna.nodeName, racc.instrument, racc.gratings,
  wpna.vsini, wpna.vsiniErr, wpna.vsiniLim, 
  racc.Vrad, racc.VradErr, racc.VradProv, racc.teff, racc.logg
FROM
  WpNaAstroAnalysis  wpna,
  RecommendedAstroAnalysis  racc
WHERE wpna.specGroupID = racc.specGroupID
  AND wpna.instrument = 'GIRAFFE'
  AND wpna.gratings LIKE '%HR15N%'
  AND wpna.nodeName = 'OACT'
  AND wpna.wg IN ('WG10', 'WG12')
  AND racc.cName ='00001211-2949302';
      

Note that only OACT rotational velocities are being displayed here as these are the quantities that can be used in publications. Similarly, it is possible to list all the OACT velocities that correspond to entries in RecommendedAstroAnalysis:

SELECT
  racc.cname, wpna.wg, wpna.nodeName, racc.instrument, racc.gratings,
  wpna.vsini, wpna.vsiniErr, wpna.vsiniLim, 
  racc.Vrad, racc.VradErr, racc.VradProv, racc.teff, racc.logg
FROM
  WpNaAstroAnalysis  wpna,
  RecommendedAstroAnalysis  racc
WHERE wpna.specGroupID = racc.specGroupID
  AND wpna.instrument = 'GIRAFFE'
  AND wpna.gratings LIKE '%HR15N%'
  AND wpna.nodeName = 'OACT'
  AND wpna.wg IN ('WG10', 'WG12');
      

Perhaps more usefully, additional criteria can be included to limit the entries selected:

SELECT
  racc.cname, wpna.wg, wpna.nodeName, racc.instrument, racc.gratings,
  wpna.vsini, wpna.vsiniErr, wpna.vsiniLim, 
  racc.Vrad, racc.VradErr, racc.VradProv, racc.teff, racc.logg
FROM
  WpNaAstroAnalysis  wpna,
  RecommendedAstroAnalysis  racc
WHERE wpna.specGroupID = racc.specGroupID
  AND wpna.instrument = 'GIRAFFE'
  AND wpna.gratings LIKE '%HR15N%'
  AND wpna.nodeName = 'OACT'
  AND wpna.wg IN ('WG10', 'WG12')
  AND racc.teff > 25000.0;
      

In this example only stars with an effective temperature greater than 25,000 K are selected.

Other Radial and Rotational Velocities

It is Consortium policy that you must obtain permission from the PIs to use the quantities described in this section in publications.

Some working groups, and nodes within those working groups, calculated radial and projected rotational velocities, and these quantities are tabulated, like other astrophysical parameters, in views WGRecommendedAstroAnalysis, WpNaAstroAnalysis and NpNaAstroAnalysis. In addition, velocities were calculated for each spectrum and are tabulated in the Spectrum table. The details of the columns holding the various quantities are as follows:

Quantity	WGRecommendedAstroAnalysis	Spectrum
	WpNaAstroAnalysis
	NpNaAstroAnalysis
Radial velocity	Vrad	rv
Radial velocity error	VradErr	rvErr
Projected rotational velocity	vsini	vRot
Projected rotational velocity error	vsiniErr	vRotErr
Flag on upper limits of vsini	vsiniLim

To query the WGRecommendedAstroAnalysis (working group recommended) values for a given star:

SELECT
  cname, wg, nodeName, instrument, Vrad, VradErr, vsini, vsiniErr, vsiniLim
FROM
  WGRecommendedAstroAnalysis
WHERE cName ='00001211-2949302'
ORDER BY wg;
      

To query the WpNaAstroAnalysis or NpNaAstroAnalysis values simply substitute the name of the required view in the preceding query. To query the values available in Spectrum:

SELECT
  tg.cname, sp.specID, sp.specFrameID, spf.instrument, spf.grating,
  sp.rv, sp.rvErr, sp.vRot, sp.vRotErr
FROM
  Target tg,
  Spectrum sp,
  SpecFrame spf
WHERE tg.targetID = sp.targetID
  AND sp.specFrameID = spf.specFrameID
  AND tg.cName ='11053303-7700120';
      

Note that here the Spectrum table is being joined with the Target and SpecFrame tables so that the star name and the instrument and grating configuration used to acquire the spectrum can also be displayed. It is also possible to display the individual spectrum velocities and the working group recommended or node ones in a single query by joining the Spectrum table with the appropriate analysis table. For example:

SELECT
  wgra.cname, wgra.wg, wgra.nodeName, wgra.instrument,
  wgra.Vrad, wgra.VradErr, wgra.vsini, wgra.vsiniErr, wgra.vsiniLim,
  sp.specID, sp.specFrameID, spf.instrument, spf.grating,
  sp.rv, sp.rvErr, sp.vRot, sp.vRotErr
FROM
  WGRecommendedAstroAnalysis wgra,
  SpectrumGroup spg,
  Spectrum sp,
  SpecFrame spf
WHERE wgra.specGroupID = spg.specGroupID
  AND spg.specID = sp.specID
  AND sp.specFrameID = spf.specFrameID
  AND wgra.cName ='11053303-7700120';
      

Multiple lines can be returned because typically a spectrum group will contain more than one spectrum and also several working groups may have determined velocities.