SBX ivo://astro.ulb.ac.be/sbx-tap IAA Thibault Merle thibault.merle@ulb.be +32 (0)2 650 57 34 Spectroscopic binary stars The SBX TAP service provides programmatic access to the eXtended Catalogue of Spectroscopic Binary Orbits (SBX), the successor of the SB9 catalogue, a curated and continuously updated database of orbital solutions for spectroscopic binary stars. https://astro.ulb.ac.be/sbx/tap/ https://astro.ulb.ac.be:443/sbx/tap ADQL 2.0 ADQL 2.0 text/plain text text/csv csv text/tab-separated-values tsv text/html html application/fits fits application/x-votable+xml votable 0 0 240 3600 1000000 1000000 https://astro.ulb.ac.be:443/sbx/tap/tables https://astro.ulb.ac.be:443/sbx/tap/capabilities https://astro.ulb.ac.be:443/sbx/tap/examples https://astro.ulb.ac.be:443/sbx/tap/availability public Default schema for the SBX database aliasIdentifiers of spectroscopic binaries "catalog" Name of the astronomical catalog meta.id;meta.curation;meta.table;meta.dataset VARCHAR primary identifier Identifier within the catalog meta.id VARCHAR primary sn SBX system number meta.id INTEGER primary version Version of the astronomical catalog meta.version VARCHAR systems sn sn Link alias to its system configurationsConfiguration of higher-order systems child1 First child SBX system number meta.id INTEGER child2 Second child SBX system number meta.id INTEGER family Array of system family members meta.id.parent VARCHAR in_high_order 'True' if SBX system is part of a high-order multiple configuration meta.code VARCHAR in_quadruple 'True' if SBX system is part of a quadruple configuration meta.code VARCHAR in_triple 'True' if SBX system is part of a triple configuration meta.code VARCHAR parent Parent SBX system number meta.id.parent INTEGER sn SBX system number meta.id INTEGER primary systems child1 sn Link configuration child1 to system systems child2 sn Link configuration child2 to system systems parent sn Link configuration parent to system duplicatesKnown duplicate systems from SB9 catalog sn SBX system number meta.id INTEGER primary sn_duplicate SB9 system number of the duplicate entry meta.id INTEGER systems sn sn Link duplicate entry to its system orbitsOrbital parameters data of spectroscopic binaries accessibility_legacy Legacy accessibility information meta.version VARCHAR apparent_systemic_velocity_1 Apparent systemic velocity for component 1 km/s phys.veloc DOUBLE apparent_systemic_velocity_2 Apparent systemic velocity for component 2 km/s phys.veloc DOUBLE apparent_systemic_velocity_error_1 Error in apparent systemic velocity for component 1 km/s phys.veloc DOUBLE apparent_systemic_velocity_error_2 Error in apparent systemic velocity for component 2 km/s phys.veloc DOUBLE bibcode Bibliographic reference for the orbit meta.bib.bibcode VARCHAR contributor Contributor of the orbit solution meta.bib.author VARCHAR eccentricity Orbital eccentricity src.orbital.eccentricity DOUBLE eccentricity_error Error in orbital eccentricity src.orbital.eccentricity DOUBLE epoch_reference Reference adopted for the times (JD or MJD) meta.ref VARCHAR grade Grade of the orbit solution meta.code.qual DOUBLE grade_legacy Legacy grade of the orbit solution meta.code.qual VARCHAR K1 Velocity semi-amplitude of component 1 km/s phys.veloc.orbital DOUBLE K1_error Error in velocity semi-amplitude of component 1 km/s phys.veloc.orbital DOUBLE K2 Velocity semi-amplitude of component 2 km/s phys.veloc.orbital DOUBLE K2_error Error in velocity semi-amplitude of component 2 km/s phys.veloc.orbital DOUBLE note Notes or comments about the orbit meta.note VARCHAR num_RV1 Number of Radial Velocity measurements for component 1 count meta.number INTEGER num_RV2 Number of Radial Velocity measurements for component 2 count meta.number INTEGER "on" Orbit number meta.id INTEGER periastron_argument Argument of periastron deg pos.posAng DOUBLE periastron_argument_error Error in argument of periastron deg pos.posAng DOUBLE periastron_time Time of periastron passage d src.var.index DOUBLE periastron_time_error Error in time of periastron passage d src.var.index DOUBLE periastron_time_flag Flag for periastron time meta.code.qual DOUBLE period Orbital period d time.period DOUBLE period_error Error in orbital period d stat.error;time.period DOUBLE rms_RV1 Root Mean Square of Radial Velocities for component 1 km/s phys.veloc DOUBLE rms_RV2 Root Mean Square of Radial Velocities for component 2 km/s phys.veloc DOUBLE sn SBX system number meta.id INTEGER primary systemic_velocity Systemic velocity km/s phys.veloc DOUBLE systemic_velocity_error Error in systemic velocity km/s phys.veloc DOUBLE systems sn sn Link orbit to its system systemsAstrometric, photometric and spectral type data about spectroscopic binary systems band1 Photometric band for Magnitude 1 instr.bandpass VARCHAR primary band2 Photometric band for Magnitude 2 instr.bandpass VARCHAR primary component Component identifier for the system meta.id.part VARCHAR primary coordinates_1900_legacy Legacy coordinates for epoch 1900 pos.eq VARCHAR primary coordinates_2000_legacy Legacy coordinates for epoch 2000 pos.eq VARCHAR primary dec Declination deg pos.eq.dec;meta.main DOUBLE primary dec_error Error in Declination deg stat.error;pos.eq.dec DOUBLE primary mag1 Magnitude 1 mag phot.mag DOUBLE primary mag1_source Source of Magnitude 1 data meta.bib;phot.mag VARCHAR primary mag2 Magnitude 2 mag phot.mag DOUBLE primary mag2_source Source of Magnitude 2 data meta.bib;phot.mag VARCHAR primary parallax Stellar parallax mas pos.parallax DOUBLE primary parallax_error Error in parallax mas stat.error;pos.parallax DOUBLE primary parallax_source Source of parallax data meta.bib;pos.parallax VARCHAR primary pmdec Proper motion in Declination mas/yr pos.pm;pos.eq.dec DOUBLE primary pmdec_error Error in proper motion in Declination mas/yr stat.error;pos.pm;pos.eq.dec DOUBLE primary pm_epoch Epoch of proper motion measurement yr time.epoch DOUBLE primary pmra Proper motion in Right Ascension mas/yr pos.pm;pos.eq.ra DOUBLE primary pmra_error Error in proper motion in Right Ascension mas/yr stat.error;pos.pm;pos.eq.ra DOUBLE primary pm_source Source of proper motion data meta.bib;pos.pm VARCHAR primary position_epoch Epoch of position measurement yr time.epoch DOUBLE primary position_source Source of position data meta.bib;pos VARCHAR primary ra Right Ascension deg pos.eq.ra;meta.main DOUBLE primary ra_error Error in Right Ascension deg stat.error;pos.eq.ra DOUBLE primary sn SBX system number meta.id INTEGER primary st1 Spectral type 1 src.spType VARCHAR primary st1_bibcode Bibliographic reference for spectral type 1 meta.bib.bibcode VARCHAR primary st2 Spectral type 2 src.spType VARCHAR primary st2_bibcode Bibliographic reference for spectral type 2 meta.bib.bibcode VARCHAR primary velocitiesRadial velocity time series measurements of spectroscopic binaries comment_legacy Legacy comment for velocity meta.note VARCHAR component Component identifier for the velocity measurement meta.id.part VARCHAR epoch Epoch of velocity measurement d time.epoch DOUBLE offset_legacy Legacy offset for velocity pos.posAng DOUBLE "on" Orbit number meta.record INTEGER radial_velocity Radial velocity km/s phys.veloc DOUBLE radial_velocity_error Error in radial velocity km/s phys.veloc DOUBLE sn SBX system number meta.id INTEGER primary velocity_source Source of velocity data meta.bib;phys.veloc VARCHAR weight Weight of the velocity measurement stat.weight DOUBLE TAP_SCHEMA Set of tables listing and describing the schemas, tables and columns published in this TAP service. coosysList of coordinate systems of coordinate columns published in this TAP service. epoch Epoch of the positions (if necessary). VARCHAR equinox Required to fix the equatorial or ecliptic systems (as e.g. J2000 as the default for eq_FK5 or B1950 as the default for eq_FK4). VARCHAR id ID of the coordinate system definition as it must be in the VOTable. VARCHAR indexed primary system The coordinate system among: ICRS, eq_FK5, eq_FK4, ecl_FK4, ecl_FK5, galactic, supergalactic, xy, barycentric, geo_app. VARCHAR index_columnsList of columns part of indexes for tables published in this TAP service. column_name column name from TAP_SCHEMA.columns VARCHAR indexed primary index_name index name from TAP_SCHEMA.indexes VARCHAR indexed primary ordinal ordinal position of column in index INTEGER schema_name schema name from TAP_SCHEMA.schemas VARCHAR indexed primary table_name table name from TAP_SCHEMA.tables VARCHAR indexed primary utype utype of index column VARCHAR indexesList of indexes for tables published in this TAP service. description brief description of index VARCHAR index_name index name VARCHAR indexed primary schema_name schema name from TAP_SCHEMA.schemas VARCHAR indexed primary table_name table name from TAP_SCHEMA.tables VARCHAR indexed primary type type of index (e.g., BTREE) VARCHAR "unique" is the index unique; true or false SMALLINT utype utype of index VARCHAR TAP_SCHEMA.columnsList of columns of all tables listed in TAP_SCHEMA.TABLES and published in this TAP service. column_name column name VARCHAR indexed primary coosys_id ID of the used coordinate systems (if any). VARCHAR datatype ADQL datatype as in section 2.5 VARCHAR description brief description of column VARCHAR indexed an indexed column; 1 means true, 0 means false INTEGER nullable is the column nullable; true or false SMALLINT principal a principal column; 1 means true, 0 means false INTEGER schema_name schema name from TAP_SCHEMA.schemas VARCHAR indexed primary "size" length of variable length datatypes INTEGER std a standard column; 1 means true, 0 means false INTEGER table_name table name from TAP_SCHEMA.tables VARCHAR indexed primary ucd UCD of column if any VARCHAR unit unit in VO standard format VARCHAR utype UTYPE of column if any VARCHAR TAP_SCHEMA.key_columnsList all foreign keys but provides just the columns linked by the foreign key. To know the table of these columns, see in TAP_SCHEMA.keys using the key_id. from_column key column name in the from_table VARCHAR primary key_id unique key identifier VARCHAR indexed primary target_column key column name in the target_table VARCHAR TAP_SCHEMA.keysList all foreign keys but provides just the tables linked by the foreign key. To know which columns of these tables are linked, see in TAP_SCHEMA.key_columns using the key_id. description description of this key VARCHAR from_table fully qualified table name VARCHAR key_id unique key identifier VARCHAR indexed primary target_table fully qualified table name VARCHAR utype utype of this key VARCHAR TAP_SCHEMA.schemasList of schemas published in this TAP service. dbname Name of the database VARCHAR description brief description of schema VARCHAR schema_name schema name, possibly qualified VARCHAR indexed primary utype UTYPE if schema corresponds to a data model VARCHAR TAP_SCHEMA.tablesList of tables published in this TAP service. dbname Name of the database VARCHAR description brief description of table VARCHAR schema_name the schema name from TAP_SCHEMA.schemas VARCHAR indexed primary table_name table name as it should be used in queries VARCHAR indexed primary table_type one of: table, view VARCHAR utype UTYPE if table corresponds to a data model VARCHAR