This page (revision-14) was last changed on 07-Dec-2016 14:14 by David R Williams

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
14 07-Dec-2016 14:14 2 KB David R Williams to previous
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

Version management

Difference between version and

At line 1 added 8 lines
[{ALLOW edit EISMainUsers}]
[{ALLOW view Anonymous}]
!!! Searching the EIS Data Archive using SQL
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.
!! Search requirements:\\
At line 13 added 2 lines
!! One can search for the above like this:\\
At line 7 changed one line
Haven't figure out how to choose "exposure time", any help?
%%(color:#ff6600;)Haven't figure out how to choose "exposure time", any help?%%
At line 9 changed 2 lines
Jian -
[{CurrentTimePlugin format='dd MMM yyyy' }]
-[Jian|JianSun], 8-Mar-2008
At line 26 added one line
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.
At line 18 changed 2 lines
-[David Pérez-Suárez|DavidPS],
[{CurrentTimePlugin format='dd MMM yyyy' }]
-[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