This page (revision-16) was last changed on 30-Aug-2024 13:08 by Mike Smith

This page was created on 07-Mar-2008 10:49 by JianSun

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
16 30-Aug-2024 13:08 2 KB Mike Smith to previous
15 30-Aug-2024 13:08 2 KB Mike Smith to previous | to last
14 07-Dec-2016 14:14 2 KB David R Williams to previous | to last
13 07-Apr-2008 11:34 2 KB David Pérez-Suárez to previous | to last Astrogrid tip
12 17-Mar-2008 03:01 1 KB David R Williams to previous | to last
11 17-Mar-2008 02:58 1 KB David R Williams to previous | to last
10 17-Mar-2008 02:57 1 KB David R Williams to previous | to last
9 17-Mar-2008 02:55 1 KB David R Williams to previous | to last
8 17-Mar-2008 02:53 1 KB David R Williams to previous | to last
7 12-Mar-2008 12:38 884 bytes JianSun to previous | to last
6 12-Mar-2008 12:37 918 bytes JianSun to previous | to last
5 10-Mar-2008 17:58 865 bytes David Pérez-Suárez to previous | to last
4 10-Mar-2008 17:55 730 bytes David Pérez-Suárez to previous | to last Possible solution..
3 07-Mar-2008 10:50 359 bytes JianSun to previous | to last
2 07-Mar-2008 10:50 353 bytes JianSun to previous | to last
1 07-Mar-2008 10:49 291 bytes JianSun to last

Page References

Incoming links Outgoing links
SqlSearch
SqlSearch

Version management

Difference between version and

At line 1 changed 3 lines
sit and stare data
exposure time < 20 secs
target = active region.
[{ALLOW edit EISMainUsers}]
[{ALLOW view Anonymous}]
!!! Searching the EIS Data Archive using SQL
At line 5 changed one line
select * from eis_level0 where FMIR_SS="0" and TARGET="active region" and (date_obs between "2007-03-15" and "2007-03-20") and slit_id=1 order by date_obs
The following is an example of how to search the EIS Data Archive using SQL search. This is a very powerful tool: we deliberately included all header keywords in the archive database so that you can search on pretty much anything, provided you format your search correctly.
At line 7 changed one line
Haven't figure out how to choose "exposure time", any help?
!! Search requirements:\\
sit and stare data\\
exposure time < 20 secs\\
target = active region.\\
!! One can search for the above like this:\\
{{select * from eis_level0 where FMIR_SS="0" and TARGET="active region" and (date_obs between "2007-03-15" and "2007-03-20") and slit_id=1 order by date_obs}}
%%(color:#ff6600;)Haven't figure out how to choose "exposure time", any help?%%
-[Jian|JianSun], 8-Mar-2008
I think that in that way it works, but I didn't find any for the dates that you said:\\
{{select * from eis_level0 where FMIR_SS='0' and TARGET='active region' and (date_obs between '2007-03-15' and '2007-04-20') and slit_id=1 and (obt_end-obt_time)/512/nexp <20 order by date_obs}}
Note: For some reason you cannot just copy the previous line, you have to rewrite the ' or " symbols, if not it gives a syntax error.
-[David Pérez-Suárez|DavidPS] 11-Mar-2008
I once had something similar to this copy-and-paste problem. Looking at it now, I think that it may be due to how the Wiki displays opening and closing quote marks. In the raw source, they are [straight quote marks|http://en.wikipedia.org/wiki/Quotation_mark_glyphs], as you would use in IDL. But when they are processed and displayed by the Wiki, they appear to change to the kind of curved quote marks that (for example) MS Word uses, i.e., "sixes and nines". Try Just substituting normal quote marks for those that appear. For example, when I do that, I get 34 results with the above search.
-[Dave|DavidRWilliams], 17-Mar-2008
You can use [AstroGrid|http://www.astrogrid.org/] to search for available data (and if you use it with python you could do even more complicated searches between different databases!). In order to do the previous query, after choose the "Hinode EIS Level 0 and Level 2" service from the solar examples, you should write this query:
{{Select * From eis_level0 as aa Where aa.slit_id=1 And ( ( (aa.obt_end-aa.obt_time ) /aa.nexp ) /512.0 ) <20 And aa.DATE_OBS>'2007-03-15' And aa.DATE_OBS<='2007-04-20' And aa.TARGET='active region' And aa.FMIR_SS='0'}}
-[David Pérez-Suárez|DavidPS], 7-Apr-2008
This page (revision-16) was last changed on 30-Aug-2024 13:08 by Mike SmithTop