eLSST UW OpSim Database

Instructions on inputting mysql file into your mysql server:

You need to set up a database to hold the operations output table. The names 'db_name' and 'opsim_table' name below are placeholders for what you describe. The opsim1.29.sql file available here will expand to output_opsim1_29 unless you alter it. The UW cronos92.sql file available here will expand to pointing_meta unless changed.

Start your mysql server.
Log into MySQL as the root mysql user.
Create a database for the opsim output (You only have to do this once).
mysql> CREATE database db_name;
Grant permissions to a user to access the table. (Again, only has to be done once)
mysql> GRANT all on db_name.* to user@localhost identified by 'passwd';
Input the database file into a mysql instance (from your shell).
$> mysql -u user -p db_name < lsst_db.mysql
password: ******
Now you should be able to query the table from within mysql.
$> mysql -u user -p db_name
password: ******
mysql> select * from opsim_table limit 0,10;

New reference survey

Download the opsim1.29 database. This is opsim1.29 with some extras (such as dithering).

Old reference survey - this is only still available for comparison purposes, if required.

Download the UW Cronos92 database. This is cronos92 plus some extras (such as 5-sigma limiting magnitude). Be aware that the cronos92 database expands to almost a Gigabyte, although the gzipped file is only 192M. Use the same username/passwd as for this site.

If you need more detailed instructions on how to install the database into your version of SQL, please contact krughoff at astro.washington.edu.