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

Obtaining ra, dec of DiaForcedSources

    XMLWordPrintable

    Details

    • Type: Story
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Design Documents
    • Labels:
    • 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

            There are no comments yet on this issue.

              People

              Assignee:
              Unassigned 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:

                  Jenkins

                  No builds found.