SBX TAP Examples

Simple Table Select

Description: Retrieve metadata from the TAP_SCHEMA.

SELECT TOP 10 * FROM TAP_SCHEMA.tables

SB2 in SBX

Description: Find all SB2 in SBX and their associated Gaia DR3 Identifier when it exists.>

SELECT DISTINCT 'SBX', o.sn AS sn, a."catalog", a.version, a.identifier
FROM orbits o LEFT JOIN alias a 
ON o.sn = a.sn AND a."catalog" = 'Gaia' AND a.version = 'DR3'
WHERE o.K1 IS NOT NULL AND o.K2 IS NOT NULL
ORDER BY sn; 

Gaia DR3 identifiers of SBX binaries

Description: Find all Gaia DR3 identifiers of SBX binaries with periods and eccentricities, sorted by the brightness of the primaries.>

SELECT sn, "catalog", version, identifier, mag1, period, eccentricity
FROM orbits JOIN systems USING(sn) JOIN alias USING(sn)
WHERE "catalog" = 'Gaia' AND version = 'DR3'
ORDER BY mag1

Spectroscopic binaries in triple systems

Description: Find spectroscopic binaries that are part of triple systems.>

SELECT sn, ra, dec, mag1, family, parent, child1
FROM systems JOIN configurations USING(sn)
WHERE configurations.in_triple = 'True';

Orbits references

Description: Find all orbits referenced with individual RV data in SBX>

SELECT DISTINCT sn, o."on", bibcode, contributor
FROM orbits o
LEFT JOIN velocities v USING(sn)
WHERE v.sn IS NOT NULL
ORDER BY sn;