Examples for OCA Data Center TAP service

tap_schema: List tables

Return tables available on this server.

SELECT * FROM tap_schema.tables

Describe the columns of the best table in the mp3c_main schema:

SELECT * FROM tap_schema.columns
  WHERE table_name='mp3c_main.best'

Return names and best albedo of bodies with a known albedo.

SELECT name, albedo FROM mp3c_main.best
  JOIN mp3c_main.body USING (bid)
  WHERE albedo IS NOT NULL

Return names and best albedo of bodies with a known albedo and a best diameter greater than 20 km.

SELECT name, albedo FROM mp3c_main.best
  JOIN mp3c_main.body USING (bid)
  WHERE albedo IS NOT NULL AND diameter > 20

Return proper orbital parameters for bodies with best family set to Baptistina.

SELECT a_p, e_p, i_p FROM mp3c_main.best
  WHERE parent_name='Baptistina'

Return proper orbital parameters for bodies with at least a family measurement set to Baptistina.

SELECT a_p, e_p, i_p FROM mp3c_main.best
  WHERE bid IN (SELECT DISTINCT bid FROM mp3c_main.prop_family WHERE parent_name='Baptistina')

Return orbital parameters from MPC for bodies with best family set to Baptistina.

SELECT a, e, sin_i FROM mp3c_main.best
  JOIN mp3c_main.mpcorb USING (bid)
  WHERE parent_name='Baptistina'

Return data to plot the V-shape of family Erigone.

SELECT a_p, inverse_diameter FROM mp3c_main.best
  WHERE parent_name='Erigone'