'Slow Nuclear transients' filter results
'Slow Nuclear transients' filter results
Based on the r0b_lvra filter, designed for slow nuclear transients. Requires the max r band flux is at least twice the min, and the latest detection is at least 30 days older than the earliest, and the latest flux is higher than the mean flux (i.e. the object has not declined too far) ordered so the latest is first. The filter is streamed via email .
Run Filter Duplicate 

SELECT objects.diaObjectId,
       r0b_lvra.classification AS r0b_score,
       objects.lastDiaSourceMjdTai AS latest_MJD,
       objects.timestamp AS Alert_arrival_time,
       objects.latestR,
       objects.nDiaSources,
       objects.ebv,
       objects.ra,
       objects.decl,
       objects.tns_name,
       objects.firstDiaSourceMjdTai,
       objects.r_psfFluxMax AS r_flux_max,
       objects.r_psfFluxMin AS r_flux_min,
       sherlock_classifications.separationArcsec,
       sherlock_classifications.direct_distance,
       sherlock_classifications.distance,
       sherlock_classifications.z,
       sherlock_classifications.photoZ,
       sherlock_classifications.photoZErr,
       sherlock_classifications.physical_separation_kpc,
       sherlock_classifications.classification AS sherlock_classifications,
       r0b_lvra.timestamp AS VRAtimestamp
FROM objects,
     sherlock_classifications,
     annotations AS r0b_lvra
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
  AND objects.diaObjectId=r0b_lvra.diaObjectId
  AND r0b_lvra.topic="r0b_lvra"
  AND objects.diaObjectId=sherlock_classifications.diaObjectId
  AND objects.diaObjectId=r0b_lvra.diaObjectId
  AND r0b_lvra.topic="r0b_lvra"
  AND objects.nDiaSources > 2
  AND r0b_lvra.classification>0.9
  AND mjdnow() - objects.lastDiaSourceMjdTai < 7
  AND (sherlock_classifications.classification ="NT"
       OR (sherlock_classifications.classification ="SN"
           AND sherlock_classifications.separationArcsec <0.5))
  AND (objects.lastDiaSourceMjdTai - objects.firstDiaSourceMjdTai)>30
ORDER BY objects.lastDiaSourceMjdTai DESC

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