Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-11596

Reversing bouding box issue with r filter of stripe82 deepcoadd images.

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Templates:
    • Team:
      Data Access and Database

      Description

      For deepcoadd images of 'r' filter, some image queries for cutouts centered on ra, dec are returning None, due to the patch being returned via metaserv SQL is wrong, in the sense that the patch does NOT actually contain the ra, dec specified.

      Known ra,dec that show the issue (reported by Tatiana @ SUIT team): 9.6, -1.1

      On PDAC database:
      /datasets/sdss/preprocessed/dr7/sdss_stripe82_00

      Metaserv SQL:

      SELECT ra,decl,run,camcol,field,filterName,(power((ra - 9.6),2) + power((decl - -1.1),2)) as distance FROM Science_Ccd_Exposure WHERE filtername = 'r' AND scisql_s2PtInBox(9.6, -1.1, corner1Ra, corner1Decl, corner3Ra, corner3Decl) = 1 order by distance LIMIT 1

        Attachments

          Activity

            People

            • Assignee:
              jgates John Gates
              Reporter:
              kennylo Kenny Lo
              Reviewers:
              Kenny Lo
              Watchers:
              Fritz Mueller, John Gates, Kenny Lo, Kian-Tat Lim, Tatiana Goldina, Xiuqin Wu [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Summary Panel