Obscore 1.1 Example: Advanced Use-cases

Show me a list of all data matching a particular event (e.g. gamma ray burst) in time interval and space:
1.DataType=time series
2.RA includes 16.00 hours
3.DEC includes +41.00
4.Time start > MJD 54221 and Time stop < MJD 55800
5.Number of time slots > 1000

Tested in TapHandle on ObsTAP services

SELECT TOP 100 ivoa.ObsCore.access_url,ivoa.ObsCore.obs_id FROM ivoa.ObsCore
WHERE (CONTAINS(POINT('ICRS', ivoa.ObsCore.s_ra, ivoa.ObsCore.s_dec), CIRCLE('ICRS', 10.684667, +41.268750, 0.016666666666666666)) = 1)
AND ivoa.ObsCore.dataproduct_type = 'timeseries'_
_AND ivoa.ObsCore.t_resolution
_AND ivoa.ObsCore.t_min > 54221_
_AND ivoa.ObsCore.t_max < 55800_
AND t_dim > 1000

* Event list use-cases

Show me a list of all event lists observed in the XMM data collection within the region covered by a particular image of GALEX data collection.

1.!DataType = event list
2.Region contains polygon P1 extracted from the foot print of a particular GALEX image
3.Data collection= XMM
4.Instrument name=EPN

SELECT xmm.access_url,xmm.obs_id FROM ivoa.ObsCore AS xmm
JOIN ivoa.ObsCore as galex ON (CONTAINS(REGION(galex.s_region), REGION(xmm.s_region)) = 1)
WHERE xmm.dataproduct_type = 'eventlist'
AND galex.facility_name = ‘GALEX’
AND galex.dataproduct_type = 'image'
AND xmm.facility_name = ‘XMM’
AND xmm.instrument_name = ‘EPN’

* From object list use-cases

Show me a list of all data, for a selected list of SDSS objects that satisfies:

1.!DataType=Cube with 3 dimensions dataproduct_type = cube
2.Axes includes WAVE em_ucd=em.wl
3.Axes includes more than 200 pixels along each spatial axis s_xel1 and s_xel2 > 200
4.Spatial resolution better than 2 arcsec s_resolution <2

<-- set -->