SqlSearch
Back to current versionRestore this version

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:
#

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

Haven't figure out how to choose "exposure time", any help?

-Jian, 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 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 normal quote marks, as you would use in IDL. But when they are processed and displayed by the Wiki, they appear to change to the kind of quote marks that 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, 17-Mar-2008