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