| 302 | | |
| 303 | | |
| 304 | | |
| | 302 | ooooh... 2 interesting reasons why this didn't work: |
| | 303 | |
| | 304 | * I forgot about the oof guys and queued them up |
| | 305 | * default recipe for convolve does crazy stuff (maybe because of the oofs, maybe for other reasons) |
| | 306 | |
| | 307 | Here is a picture of unconv and conv stack. It's actually not too bad, considering... |
| | 308 | |
| | 309 | Here is the proper query to get what we want (fwhm < 5): |
| | 310 | {{{ |
| | 311 | select warpRun.label,skycell_id, filter, warpSkyfile.quality, count(*) from rawExp join chipRun using (exp_id) join camRun using (chip_id) join |
| | 312 | camProcessedExp using (cam_id) join fakeRun using (cam_id) join warpRun using (fake_id) join warpSkyfile using (warp_id) where warpRun.label = 'SAS.v1' |
| | 313 | and warpRun.state = 'full' and warpSkyfile.quality = 0 and fwhm_major < 5 group by skycell_id, filter, warpRun.label; |
| | 314 | +--------+--------------+--------+---------+----------+ |
| | 315 | | label | skycell_id | filter | quality | count(*) | |
| | 316 | +--------+--------------+--------+---------+----------+ |
| | 317 | | sas.v1 | skycell.1224 | g | 0 | 34 | |
| | 318 | | sas.v1 | skycell.1224 | i | 0 | 52 | |
| | 319 | | sas.v1 | skycell.1224 | r | 0 | 32 | |
| | 320 | | sas.v1 | skycell.1224 | z | 0 | 5 | |
| | 321 | | sas.v1 | skycell.1225 | g | 0 | 115 | |
| | 322 | | sas.v1 | skycell.1225 | i | 0 | 212 | |
| | 323 | | sas.v1 | skycell.1225 | r | 0 | 115 | |
| | 324 | | sas.v1 | skycell.1225 | z | 0 | 16 | |
| | 325 | | sas.v1 | skycell.1226 | g | 0 | 95 | |
| | 326 | | sas.v1 | skycell.1226 | i | 0 | 182 | |
| | 327 | | sas.v1 | skycell.1226 | r | 0 | 104 | |
| | 328 | | sas.v1 | skycell.1226 | z | 0 | 15 | |
| | 329 | | sas.v1 | skycell.1227 | g | 0 | 32 | |
| | 330 | | sas.v1 | skycell.1227 | i | 0 | 60 | |
| | 331 | | sas.v1 | skycell.1227 | r | 0 | 33 | |
| | 332 | | sas.v1 | skycell.1227 | z | 0 | 3 | |
| | 333 | | sas.v1 | skycell.1314 | g | 0 | 106 | |
| | 334 | | sas.v1 | skycell.1314 | i | 0 | 208 | |
| | 335 | | sas.v1 | skycell.1314 | r | 0 | 100 | |
| | 336 | | sas.v1 | skycell.1314 | z | 0 | 26 | |
| | 337 | | sas.v1 | skycell.1315 | g | 0 | 253 | |
| | 338 | | sas.v1 | skycell.1315 | i | 0 | 496 | |
| | 339 | | sas.v1 | skycell.1315 | r | 0 | 250 | |
| | 340 | | sas.v1 | skycell.1315 | z | 0 | 58 | |
| | 341 | | sas.v1 | skycell.1316 | g | 0 | 214 | |
| | 342 | | sas.v1 | skycell.1316 | i | 0 | 446 | |
| | 343 | | sas.v1 | skycell.1316 | r | 0 | 204 | |
| | 344 | | sas.v1 | skycell.1316 | y | 0 | 1 | |
| | 345 | | sas.v1 | skycell.1316 | z | 0 | 60 | |
| | 346 | | sas.v1 | skycell.1317 | g | 0 | 68 | |
| | 347 | | sas.v1 | skycell.1317 | i | 0 | 134 | |
| | 348 | | sas.v1 | skycell.1317 | r | 0 | 70 | |
| | 349 | | sas.v1 | skycell.1317 | z | 0 | 13 | |
| | 350 | | sas.v1 | skycell.1404 | g | 0 | 125 | |
| | 351 | | sas.v1 | skycell.1404 | i | 0 | 217 | |
| | 352 | | sas.v1 | skycell.1404 | r | 0 | 100 | |
| | 353 | | sas.v1 | skycell.1404 | z | 0 | 21 | |
| | 354 | | sas.v1 | skycell.1405 | g | 0 | 253 | |
| | 355 | | sas.v1 | skycell.1405 | i | 0 | 492 | |
| | 356 | | sas.v1 | skycell.1405 | r | 0 | 228 | |
| | 357 | | sas.v1 | skycell.1405 | y | 0 | 1 | |
| | 358 | | sas.v1 | skycell.1405 | z | 0 | 69 | |
| | 359 | | sas.v1 | skycell.1406 | g | 0 | 214 | |
| | 360 | | sas.v1 | skycell.1406 | i | 0 | 450 | |
| | 361 | | sas.v1 | skycell.1406 | r | 0 | 201 | |
| | 362 | | sas.v1 | skycell.1406 | y | 0 | 1 | |
| | 363 | | sas.v1 | skycell.1406 | z | 0 | 66 | |
| | 364 | | sas.v1 | skycell.1407 | g | 0 | 72 | |
| | 365 | | sas.v1 | skycell.1407 | i | 0 | 148 | |
| | 366 | | sas.v1 | skycell.1407 | r | 0 | 69 | |
| | 367 | | sas.v1 | skycell.1407 | z | 0 | 16 | |
| | 368 | | sas.v1 | skycell.1493 | g | 0 | 44 | |
| | 369 | | sas.v1 | skycell.1493 | i | 0 | 65 | |
| | 370 | | sas.v1 | skycell.1493 | r | 0 | 37 | |
| | 371 | | sas.v1 | skycell.1493 | z | 0 | 7 | |
| | 372 | | sas.v1 | skycell.1494 | g | 0 | 110 | |
| | 373 | | sas.v1 | skycell.1494 | i | 0 | 173 | |
| | 374 | | sas.v1 | skycell.1494 | r | 0 | 84 | |
| | 375 | | sas.v1 | skycell.1494 | z | 0 | 18 | |
| | 376 | | sas.v1 | skycell.1495 | g | 0 | 102 | |
| | 377 | | sas.v1 | skycell.1495 | i | 0 | 186 | |
| | 378 | | sas.v1 | skycell.1495 | r | 0 | 94 | |
| | 379 | | sas.v1 | skycell.1495 | z | 0 | 18 | |
| | 380 | | sas.v1 | skycell.1496 | g | 0 | 44 | |
| | 381 | | sas.v1 | skycell.1496 | i | 0 | 63 | |
| | 382 | | sas.v1 | skycell.1496 | r | 0 | 41 | |
| | 383 | | sas.v1 | skycell.1496 | z | 0 | 1 | |
| | 384 | | sas.v1 | skycell.1582 | g | 0 | 1 | |
| | 385 | | sas.v1 | skycell.1582 | i | 0 | 1 | |
| | 386 | | sas.v1 | skycell.1583 | i | 0 | 3 | |
| | 387 | | sas.v1 | skycell.1583 | r | 0 | 2 | |
| | 388 | | sas.v1 | skycell.1584 | g | 0 | 3 | |
| | 389 | | sas.v1 | skycell.1584 | i | 0 | 9 | |
| | 390 | | sas.v1 | skycell.1584 | r | 0 | 2 | |
| | 391 | | sas.v1 | skycell.1585 | i | 0 | 1 | |
| | 392 | +--------+--------------+--------+---------+----------+ |
| | 393 | 75 rows in set (0.05 sec) |
| | 394 | }}} |
| | 395 | |
| | 396 | |
| | 397 | That has a max fwhm of 5.... I shuffled the old stacks to SAS.v0.nocut, so I will requeue with the fwhm cut to see how that turns out... |
| | 398 | |
| | 399 | {{{ |
| | 400 | stacktool -definebyquery -set_workdir neb://@HOST@.0/isp/sas.v0 -set_label SAS.v0 -select_skycell_id skycell.1496 -select_label sas.v1 -dbname isp -min_num 2 -select_fwhm_major_max 5 |
| | 401 | }}} |
