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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • 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:

                Jenkins

                No builds found.