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

          kennylo Kenny Lo created issue -
          kennylo Kenny Lo made changes -
          Field Original Value New Value
          Watchers Kenny Lo [ Kenny Lo ] Fritz Mueller, Kenny Lo, Tatiana Goldina [ Fritz Mueller, Kenny Lo, Tatiana Goldina ]
          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
          kennylo Kenny Lo made changes -
          Reviewers Fritz Mueller, Kenny Lo [ fritzm, kennylo ] Kenny Lo [ kennylo ]
          kennylo Kenny Lo made changes -
          Watchers Fritz Mueller, Kenny Lo, Tatiana Goldina [ Fritz Mueller, Kenny Lo, Tatiana Goldina ] Fritz Mueller, Kenny Lo, Kian-Tat Lim, Tatiana Goldina [ Fritz Mueller, Kenny Lo, Kian-Tat Lim, Tatiana Goldina ]
          xiuqin Xiuqin Wu [X] (Inactive) made changes -
          Labels pdac
          swinbank John Swinbank made changes -
          Team Data Access and Database [ 10204 ]
          jgates John Gates made changes -
          Status To Do [ 10001 ] In Progress [ 3 ]
          jgates John Gates made changes -
          Status In Progress [ 3 ] In Review [ 10004 ]
          kennylo Kenny Lo made changes -
          Status In Review [ 10004 ] Reviewed [ 10101 ]
          jgates John Gates made changes -
          Resolution Done [ 10000 ]
          Status Reviewed [ 10101 ] Done [ 10002 ]

            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.