This wiki is to track the merge progress of stuff

Zeroth step: remove/rename all prior incantations of LAP.20120706 merge because we had problems. This has been done - basically all old stuff has name of .drop added to it

First step: Kepler. Ken wants to merge kepler and has declared Kepler to consist of ra: 282-300 and dec:40-50 - this is not all of kepler but the majority of it. Kepler exists in slice18 (both skycal and cam). To find whic ones are specifically kepler:

mysql> select minidvodb_name, ra*180/3.1415927 ,decl*180/3.1415927, count(*) from addRun join camRun on stage_id = cam_id join chipRun using (chip_id) join rawExp using (exp_id) where addRun.minidvodb_group = 'LAP.slice18.cam' and stage = 'cam' and ra*180/3.1415927 > 282 and ra*180/3.1415927 < 300 and decl*180/3.1415927 > 40 and decl*180/3.1415927 < 50 group by minidvodb_name;
+----------------------+------------------+--------------------+----------+
| minidvodb_name       | ra*180/3.1415927 | decl*180/3.1415927 | count(*) |
+----------------------+------------------+--------------------+----------+
| LAP.slice18.cam.1802 | 283.532343323818 |   43.8456519204415 |       77 | 
| LAP.slice18.cam.1805 | 299.307475472552 |   40.0563955983218 |       83 | 
| LAP.slice18.cam.1808 | 284.438418767653 |   41.7542987033297 |       32 | 
| LAP.slice18.cam.1810 | 284.438590654989 |   41.7544705906657 |       77 | 
| LAP.slice18.cam.1812 | 283.909578730559 |   48.0151803255718 |      157 | 
| LAP.slice18.cam.1815 | 296.846106116811 |   40.0083244400205 |      143 | 
| LAP.slice18.cam.1818 | 286.823928512439 |   48.9638838287344 |      106 | 
| LAP.slice18.cam.1821 | 292.127741447833 |   44.1639299709348 |      134 | 
| LAP.slice18.cam.1823 | 297.915188050953 |   41.2683732044577 |      140 | 
| LAP.slice18.cam.1825 | 282.540667986655 |   44.6111808192068 |      110 | 
| LAP.slice18.cam.1827 | 299.947698503374 |   46.6876944296439 |       12 | 
| LAP.slice18.cam.1849 | 282.167099509749 |   44.9916820853321 |        1 | 
+----------------------+------------------+--------------------+----------+
12 rows in set (1.42 sec)

Therefore, for the first tests, need to only merge 12 cam minidvodbs (vs 84).