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

Assemble a complete database with S13 DRP catalogs

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:

      Description

      Create a database populated with complete catalogs resulting from processing of the SDSS Stripe 82 data at both NCSA and IN2P3 sites. The database has to be created at NCSA on the following database server lsst-db.ncsa.illinois.edu

      • 2016-08-10: CORRECTION: that was the original plan. Due to the space limitation on that server the database will be installed on Nebula volume lsst-dm-gapon attached to image lsst-gapon-0 (floating IP address 141.142.211.152). See details on this setup in the comments stream below.)

      The database name will be: gapon_SDRP_Stripe82

      The database will be populated with the contents of the following databases:

      • NCSA (lsst-db.ncsa.illinois.edu):

        daues_SDRP_Stripe82_ncsa
        daues_SDRP_dedupe_byfilter_0
        daues_SDRP_dedupe_byfilter_1
        daues_SDRP_dedupe_byfilter_2
        daues_SDRP_dedupe_byfilter_3
        daues_SDRP_dedupe_byfilter_4
        

      • IN2P3 (ccdb02.in2p3.fr):

        lsst_prod_DC_2013_2
        lsst_prod_dedupe_byfilter_g
        lsst_prod_dedupe_byfilter_i
        lsst_prod_dedupe_byfilter_r
        lsst_prod_dedupe_byfilter_u
        lsst_prod_dedupe_byfilter_z
        

      Additional requirements:

      • The duplicate entries (due to the overlap in the RA range) will need to be carefully assessed and eliminated.
      • the referential integrity of the resulted database will need to be tested

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              gapon Igor Gaponenko
              Reporter:
              gapon Igor Gaponenko
              Watchers:
              Fritz Mueller, Gregory Dubois-Felsmann, Igor Gaponenko
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: