An Example for /examples

This document illustrates how to write a DALI-compliant examples document using TAP's special table and query properties. Apart from the actual examples blocks, you can add arbitrary additional material, for instance, a table of contents:

Use the W3C RDFa validator to see what semantics your RDFa actually conveys.

Query for CALIFA object properties

This example shows how to combine the ↗califadr3.objects table of properties of CALIFA target galaxies with the ↗califadr3.cubes table of data cubes to select bright, early-type spirals:

SELECT target_name, accref, hubtyp, magg
FROM califadr3.cubes
  NATURAL JOIN califadr3.objects
WHERE hubtyp in ('S d', 'S cd', 'S c')
  AND magg<13
    

Query against coverage

When querying against geometric columns, in particular coverage, use ADQL's contains or intersect functions, like this:

SELECT accref, seeing
  FROM cars.images
      WHERE 1=INTERSECTS(coverage, circle('', 34, -4, 2))
      ORDER BY seeing
    

Of course, this concerns all SIAP and SSAP tables (↗cars.images only standing as an example here) as well as ↗ivoa.obscore