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.)
  • All PESSTO spectra by type (not only SNe):

            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

  • All PESSTO SNe (having a spectrum/a) by type

            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

  • All PUBLIC PESSTO spectra by type (not only SNe)
       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