'Supernovae near (but not in core of) galaxies' filter results
'Supernovae near (but not in core of) galaxies' filter results
Find supernova near known galaxies with a prejudice against nuclear transients to minimize AGN and bad subtractions. Objects must have at least 2 detections in at least 2 filters over at least 2 days. The filter is not active.
Run Filter Duplicate 

SELECT objects.diaObjectId,
       objects.g_psfFluxMax,
       objects.r_psfFluxMax,
       objects.i_psfFluxMax,
       objects.z_psfFluxMax,
       objects.lastDiaSourceMjdTai,
       objects.nSourcesGood AS "latest detection",
       sherlock_classifications.classification AS "predicted classification"
FROM objects,
     sherlock_classifications,
     area_hits
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
  AND objects.diaObjectId=area_hits.diaObjectId
  AND area_hits.ar_id=6
  AND objects.nSourcesGood > 4
  AND sherlock_classifications.separationArcsec > 0.5
  AND sherlock_classifications.separationArcsec < 5.0
  AND ((objects.ngSources > 2
        AND objects.nrSources > 2)
       OR (objects.nrSources > 2
           AND objects.niSources > 2)
       OR (objects.niSources > 2
           AND objects.nzSources > 2))
  AND (objects.g_psfFluxMax > 0
       OR objects.r_psfFluxMax > 0
       OR objects.i_psfFluxMax > 0
       OR objects.z_psfFluxMax > 0)
  AND (objects.lastDiaSourceMjdTai - objects.firstDiaSourceMjdTai) > 2
  AND objects.medianR > 0.75

Filter Results

ZERO MATCHES

Click on the run button above to execute your filter.
Need Help?

Start with our documentation on readthedocs, you might find the FAQ section especially useful.

If you still have questions, want to report a bug, or make a feature request, please reach out to us on the Lasair topic on the Rubin Community pages.

 readthedocs Lasair Community
Help