Obscore database going to be available on the RSP?

Hi,

At the SSSC Sprint, it was mentioned that PPDB is not currently planned to have a visits table. It was mentioned this information is in the obscore database, but the speaker wasn’t able to confirm how we get visit information so that we can predict where known comets/active objects are in the Rubin images to confirm/test that the real-bogus vetting is not removing active Solar System objects. Is the obscore database going to be made available on the RSP? Is it already available in the RSP now? How will visit information (ra, dec, time, airmass, etc) for observations successfully processed and not successfully processed by the Rubin DM pipelines be accessible to users?

Hi Meg, thanks for flagging this. I’ve taken a quick initial look and ObsCore is currently available on RSP, but only for DP1 and DP2 images (see DP2 tutorial 103.3). These are useful questions and I’m raising this with the Rubin Team to look into further.

Thanks @jrob93 The other issue is that to look for comets that were missed in the alert stream, we’d want to know what the limiting mag of the exposure, airmass, and seeing are . That’s something that obscode doesn’t provide but Visit and VisitDectector tables provide. So does the SSSC get that information per observation for nightly PVIs when they are accessible?

Yes, I agree that these are all important cases that would require ObsCore/Visit/VisitDetector. The intention is that this sort of information will be available, but I think there are still some decisions to be made in the exact implementation and expected delivery time. E.g. right now there is just a placeholder for a table with some of this information on the prompt products docs (no limiting magnitude in that schema though, I agree it would be useful…).

The RSP team will be discussing this in their next meeting so we should be able to get an accurate answer in the next couple days.

Thanks, @jrob93 . I see the placeholder table in the docs, but then if you look at the draft PPDB schema sent around to the SSSC, these place holders table aren’t listed. It would be helpful to get confirmation from DM that these are coming/there’s a ticket in to complete these if they are not going to be available when the PPDB launches

(sorry for the slow response)

The short answer is indeed yes, see below for ETAs.

The plan for the visit table being in PPDB is that it is bundled with the release of prompt images (PVIs) as most join usecases center around image data as you outline.

In parallel, there is a plan to incrementally make all our telemetry (scalar quantities such as engineering data and metrics) available in an additional TAP-queriable database, as there are usecases for it that are independent of prompt image publication. At the current trajectory, it is likely that some of that information, including visit summaries, could be available before the full prompt image release, but after PPDB “day 1” preview.

Hope that helps.