Archive

Archive Team

This wiki area should be used as the main source of communication for this operations group. The group's email address is archive_@_pessto.org and the group's google drive area can be found here:

http://is.gd/uLn03g

and can be used as sandbox area to hash out ideas, project plans and draft documents.

Please note that everything published via this wiki is public, but everything published to google drive is viewable by pessto members only.

Team Leader : O. Yaron

Team members : R. Kotak (lead science input), S. Valenti, S. Benetti, A. Pastorello, M. Sullivan A. Gal-Yam, S. Smartt, R. Smareglia, C. Knapic, M. Molinaro

Phase 3 Date Product Standards

Marshall Development

Data reduced archive @ IA2 Development

Sample queries for executing in WISeREP My-SQL-Query page

Copy the required query from below, paste in: My-SQL-Query page and click submit. (Make sure you're logged in with the pessto username.)

            SELECT typ.name as type, count(*) as spectra FROM spectra spec JOIN objects obj on spec.objid=obj.id LEFT JOIN objtypes typ on obj.objtypeid=typ.id WHERE spec.progid=22 GROUP BY typ.name

            SELECT typ.name as type, count(*) as objects FROM objects obj LEFT JOIN objtypes typ on obj.objtypeid=typ.id where typ.name like '%SN%' and obj.progid=22 and exists (select s.id from spectra s where s.objid=obj.id) GROUP BY typ.name

       SELECT typ.name as type, count(*) as spectra FROM spectra spec JOIN objects obj on spec.objid=obj.id LEFT JOIN objtypes typ on obj.objtypeid=typ.id WHERE spec.progid=22 and spec.public='Y' GROUP BY typ.name