CollectionXmatchObscoreUsecase < IVOA

IVOA Web>IvoaDataModel>ObsDMCoreComponents>ObsCoreDMvOnedotOne>WorkingExamplesObsCoreOnedotOne>CollectionXmatchObscoreUsecase (2016-01-19, MireilleLouys) (raw view)

EditAttach

---+ Obscore 1.1 Example: Advanced Use-cases

| Use case 4.3 | %RED% POS %ENDCOLOR% | %GREEN% SPECTRAL %ENDCOLOR% | %BLUE% TIME %ENDCOLOR% |  
| | %RED% POS at event %ENDCOLOR% |  | %BLUE% of event %ENDCOLOR% |  
---

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

Tested in TapHandle on ObsTAP services

_SELECT TOP 100 ivoa.ObsCore.access_url,ivoa.ObsCore.obs_id FROM ivoa.ObsCore_ <br /> _WHERE (CONTAINS(POINT('ICRS', ivoa.ObsCore.s_ra, ivoa.ObsCore.s_dec), CIRCLE('ICRS', 10.684667, +41.268750, 0.016666666666666666)) = 1)_ <br /> _AND ivoa.ObsCore.dataproduct_type = 'timeseries'_<br /> _AND ivoa.ObsCore.t_resolution_ <br />_AND ivoa.ObsCore.t_min &gt; 54221_ <br />_AND ivoa.ObsCore.t_max &lt; 55800_ <br /> _AND t_dim &gt; 1000_

* Event list use-cases
| Use case 4.4 | %RED% POS  %ENDCOLOR% | %GREEN% SPECTRAL %ENDCOLOR% | %BLUE% TIME %ENDCOLOR% | %PURPLE%POLARIZATION %ENDCOLOR% | Coll Name | Inst.Name |
|  |  from region | |  |  | XMM | EPN |
---

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<br /> 2.Region contains polygon P1 extracted from the foot print of a particular GALEX image<br /> 3.Data collection= XMM <br />4.Instrument name=EPN

_SELECT xmm.access_url,xmm.obs_id FROM ivoa.ObsCore AS xmm_ <br /> _JOIN ivoa.ObsCore as galex ON (CONTAINS(REGION(galex.s_region), REGION(xmm.s_region)) = 1)_ <br /> _WHERE xmm.dataproduct_type = 'eventlist'_ <br /> _AND galex.facility_name = &lsquo;GALEX&rsquo;_ <br /> _AND galex.dataproduct_type = 'image'_ <br /> _AND xmm.facility_name = &lsquo;XMM&rsquo;_ <br /> _AND xmm.instrument_name = &lsquo;EPN&rsquo;_

* From object list use-cases
| Use case 4.4 | %RED% POS %ENDCOLOR% | %GREEN% SPECTRAL %ENDCOLOR% | %BLUE% TIME %ENDCOLOR% | %PURPLE%POLARIZATION %ENDCOLOR% | Coll Name |
| | %RED% from list%ENDCOLOR% | %GREEN% in wave %ENDCOLOR% | | | |
| | %RED% resolution &gt; 2 arcsec %ENDCOLOR% | | | | |
| | %RED% nb pixels on axis &gt; 200 %ENDCOLOR% | | | | |
---

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<br /> 2.Axes includes WAVE em_ucd=em.wl<br /> 3.Axes includes more than 200 pixels along each spatial axis s_xel1 and s_xel2 &gt; 200<br /> 4.Spatial resolution better than 2 arcsec s_resolution &lt;2

&lt;-- set --&gt;

Topic revision: r1 - 2016-01-19 - MireilleLouys

IVOA

Log in or Register

IVOA.net
Wiki Home
WebChanges
WebTopicList
WebStatistics

Twiki Meta & Help
IVOA
Know
Main
Sandbox
TWiki

TWiki intro
TWiki tutorial
User registration
Notify me

Working Groups

Interest Groups

Time Domain

Committees

Stds&Procs

www.ivoa.net
Documents
Events
Members
XML Schema