EuroVO Registry example queries

This document contain a few example queries to illustrate what is possible using TAP and the EuroVO registry. For questions, suggestions or problem reports, contact the Euro-VO Registry Support.

• Find all TAP services
• Cone search service that provide a redshift column
• Find resources published by a specific authority

SELECT ivoid, access_url
FROM rr.capability
NATURAL JOIN rr.interface
WHERE standard_id like 'ivo://ivoa.net/std/tap' AND intf_type='vs:paramhttp'
    

        SELECT ivoid, access_url
FROM rr.capability a
  NATURAL JOIN rr.table_column b
  NATURAL JOIN rr.interface c
WHERE a.standard_id='ivo://ivoa.net/std/conesearch'
  AND c.intf_type='vs:paramhttp'
  AND b.ucd='src.redshift'
    

        SELECT ivoid
FROM rr.resource
WHERE ivoid LIKE 'ivo://org.gavo.dc%'