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

Obtaining ra, dec of DiaForcedSources

    Details

    • Type: Story
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Design Documents
    • Labels:
    • Templates:
    • Team:
      DM Science

      Description

      As specified in RFC-517, the schema for the DiaForcedSource table in the PPDB does not include the ra/dec at which force photometry was performed; that information is instead stored in the DiaObject record that was valid at the time of force photometry. It thus requires a semi-complicated join to extract the force photometry coordinates for a light curve, which could be important for diagnosing photometric issues if the centroid is moving substantially between epochs. 

      At the time of RFC-517, we decided that this join is feasible enough, and the storage costs of adding ra/dec to DiaForcedSource are significant enough, that this schema is acceptable. However, as our prototypes of the PPDB become more advanced, we may wish to revisit this question with more quantitative performance measurements.

      This ticket is meant to remind us to reevaluate this topic.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                ctslater Colin Slater
                Watchers:
                Colin Slater, Eric Bellm, Leanne Guy
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:

                  Summary Panel