Been pulling some of the simulated LPCs out of DP0.3 and came across an object, ssObjectId 3682069804451782440, that has detections in diaSource that are down to 40th magnitude, with SNR<1. Did a few basic checks, and joining the query onto ssObject as to filter out require sso.flags < 2048 didn’t charge any of the returned detections. Simple query:
service = get_tap_service("ssotap")
lpc3 = service.search("SELECT dia.band, dia.ra, dia.dec, dia.mag, dia.magErr, dia.midPointMjdTai, SSS.heliocentricX, SSS.heliocentricY, SSS.heliocentricZ, SSS.heliocentricDist, dia.snr "
"FROM dp03_catalogs_10yr.Diasource as dia "
"JOIN dp03_catalogs_10yr.SSSource as SSS "
"ON dia.diaSourceId = SSS.diaSourceId "
"AND dia.ssObjectId = 3682069804451782440").to_table().to_pandas()
A couple plots to illustrate the issue: