Example Solar Queries

EGSO/SEC Queries

select * from sgas_event AS s where s.nar>9850 and s.nar<9880 and
s.xray_class>'M5'

SELECT * FROM hessi_flare AS s WHERE s.flare_number =  2072805

Tool used to send any of the above queries via a workflow is sec_dsa.

SOHO/EIT Query

SELECT * FROM EITData AS T1 where T1.Keywords/DATE_OBS > "2002-07-28T01:00:00.000" 
and T1.Keywords/DATE_OBS <= "2002-07-28T06:00:00.000" and T1.Keywords/WAVELNTH = 195

Tool to send this query: trace_dsa (soon to be renamed solar_dsa).

TRACE Query

SELECT * FROM TraceData AS T1 where T1.Keywords/img_time > "2002-07-28T05:00:00.000" 
and T1.Keywords/img_time <= "2002-07-28T06:00:00.000"

Tool to send this query: trace_dsa (soon to be renamed solar_dsa).


-- SilviaDalla - 06 Feb 2005

Topic revision: r1 - 2005-02-06 - 16:58:00 - SilviaDalla
 
AstroGrid Service Click here for the
AstroGrid Service Web
This is the AstroGrid
Development Wiki

This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback