Examples for Kolonica TAP examples

Find objects that have VSX names

Find lightcurves of objects having VSX names in the ↗upjs_ts.objects table; these are known variable stars:

SELECT TOP 100 o.vsx_name, s.* FROM upjs_ts.ts_ssa s
NATURAL JOIN upjs_ts.objects o WHERE vsx_name IS NOT NULL

Cone search using ssa_location

Find timeseries for object by simbad resolvable name using ssa_location (↗upjs_ts.ts_ssa):

SELECT TOP 10 * FROM upjs_ts.ts_ssa
    WHERE 1=CONTAINS(ivo_simbadpoint('VY UMi'), CIRCLE(ssa_location, ssa_aperture))

Cone search using ssa_region

Find timeseries for object by simbad resolvable name using ssa_region (↗upjs_ts.ts_ssa):

SELECT TOP 10 * FROM upjs_ts.ts_ssa
    WHERE 1=CONTAINS(ivo_simbadpoint('BT Tau'), ssa_region)