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

Reconcile L1DB schema with latest DPDD

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: cat, L1 Database
    • Labels:
      None
    • Templates:
    • Sprint:
      DB_F16_10
    • Team:
      Data Access and Database

      Description

      The level 1 db prototype schema from here: https://github.com/lsst-dm/l1dbproto/blob/master/python/lsst/l1dbproto/l1db.py and https://github.com/lsst/cat/blob/master/sql/baselineSchema.sql has some inconsistencies with the latest version of the DPDD (from 9/26/2016).

      I've just looked through diaSource and diaObject, mainly. The biggest things for the diaSource table are that dipole measurement fields in the DPDD are not in the schema and it is unclear how some fields like the second moments of intensity and some covariance terms match up between the schema vs DPDD.

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  salnikov Andy Salnikov
                  Reporter:
                  mtpatter Maria Patterson [X] (Inactive)
                  Reviewers:
                  Maria Patterson [X] (Inactive)
                  Watchers:
                  Andy Salnikov, Colin Slater, Darko Jevremovic, Gregory Dubois-Felsmann, John Swinbank, Kian-Tat Lim, Maria Patterson [X] (Inactive), Scott Daniel, Tim Jenness, Veljko Vujcic
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  10 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Summary Panel