16. TAP: Uploads 2

Then we change the TAP Service to http://dc.zah.uni-heidelberg.de/tap and perform the following query:

SELECT TOP 100
   tgas.*, sdss.u, sdss.i, sdss.r, sdss.g
   FROM sdssdr7.sources AS sdss
   JOIN TAP_UPLOAD.t1 AS tgas
   ON 1=CONTAINS(
         POINT('ICRS', sdss.ra, sdss.dec),
         CIRCLE('ICRS', tgas.ra, tgas.dec, 3./3600.))

You must replace the 1 in tap_upload.t1 with the index of the table you want to match.

You may also need to adjust the column names of RA and Dec for your table, and the match radius.


Markus Demleitner

Copyright Notice