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
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 |
Reviewers | Fritz Mueller, Kenny Lo [ fritzm, kennylo ] | Kenny Lo [ kennylo ] |
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 ] |
Labels | pdac |
Team | Data Access and Database [ 10204 ] |
Status | To Do [ 10001 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | In Review [ 10004 ] |
Status | In Review [ 10004 ] | Reviewed [ 10101 ] |
Resolution | Done [ 10000 ] | |
Status | Reviewed [ 10101 ] | Done [ 10002 ] |