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

Create a monolithic subset of the Stripe82 catalogs and image files for testing SUIT implementations

    XMLWordPrintable

    Details

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

      Description

      Create a self-consistent subset of the large Stripe82 catalog and relevant image files (in the FITS format) in order to test SUIT implementations. The subset will cover 100% of the SDSS patch 366,0 in an area processed at NCSA:

      • 9.50 < RA < 9.25
      • -1.00 < DECL < -1.25

      The catalog should include:

      • deep coads along with the relevant metadata
      • objects detected on the coadds
      • forced sources detected on calexps at the locations around the relevant objects
      • calexps on which the sources were detected, as well as the relevant metadata tables (for calexps)

      The database catalog will be placed at a MySQL/MariaDB server:

      • host name: lsst-db.ncsa.illinois.edu
      • database name: gapon_sdss_stripe92_patch366_0

      An image repository with FITS referenced by the corresponding catalog tables:

      • coadds
      • calexps

        Attachments

          Activity

          Hide
          gapon Igor Gaponenko added a comment -

          Both catalogs and the relevant FITS images have been prepared put at their destinations. Further details found in the comments to this issue.

          Show
          gapon Igor Gaponenko added a comment - Both catalogs and the relevant FITS images have been prepared put at their destinations. Further details found in the comments to this issue.
          Hide
          gapon Igor Gaponenko added a comment - - edited

          FITS images of the coadds

          There are 5 images in total spread in between 5 base folders (one per each filter band):

          /datasets/gapon/data/SDRP/data/coadd_u_dir/
          /datasets/gapon/data/SDRP/data/coadd_g_dir/
          /datasets/gapon/data/SDRP/data/coadd_r_dir/
          /datasets/gapon/data/SDRP/data/coadd_i_dir/
          /datasets/gapon/data/SDRP/data/coadd_z_dir/
          

          Relative location of an image in question (as per the catalog):

          deepCoadd-results/u/0/366,0/calexp-u-0-366,0.fits.gz
          deepCoadd-results/g/0/366,0/calexp-g-0-366,0.fits.gz
          deepCoadd-results/r/0/366,0/calexp-r-0-366,0.fits.gz
          deepCoadd-results/i/0/366,0/calexp-i-0-366,0.fits.gz
          deepCoadd-results/z/0/366,0/calexp-z-0-366,0.fits.gz
          

          Hence the full path of an image would look like this:

          /datasets/gapon/data/SDRP/data/coadd_u_dir/deepCoadd-results/u/0/366,0/calexp-u-0-366,0.fits.gz
          

          The relevant SQL query:

          SELECT path FROM gapon_sdss_stripe92_patch366_0.DeepCoadd;
          

          +---------------------------------------------------+
          | path                                              |
          +---------------------------------------------------+
          | deepCoadd-results/u/0/366,0/calexp-u-0-366,0.fits |
          | deepCoadd-results/g/0/366,0/calexp-g-0-366,0.fits |
          | deepCoadd-results/r/0/366,0/calexp-r-0-366,0.fits |
          | deepCoadd-results/i/0/366,0/calexp-i-0-366,0.fits |
          | deepCoadd-results/z/0/366,0/calexp-z-0-366,0.fits |
          +---------------------------------------------------+
          

          FITS images of calexps

          Base file path is:

          /datasets/gapon/data/SDRP_2014_NCSA/calexp_dir/
          

          To figure out the relative locations of the images locations of images one should be using the following query:

          SELECT path FROM gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure;
          

          Images are spread between the following runs:

          SELECT run,count(*) FROM gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure GROUP BY run;
          

          +------+----------+
          | run  | count(*) |
          +------+----------+
          | 1755 |       10 |
          | 2650 |       10 |
          ...
          | 7177 |       10 |
          | 7183 |       10 |
          | 7195 |        9 |
          | 7199 |       10 |
          | 7202 |       10 |
          +------+----------+
          145 rows in set (0.01 sec)
          

          NOTE: Practically all runs in the NCSA range of the processing have been reported by this query.

          Show
          gapon Igor Gaponenko added a comment - - edited FITS images of the coadds There are 5 images in total spread in between 5 base folders (one per each filter band): /datasets/gapon/data/SDRP/data/coadd_u_dir/ /datasets/gapon/data/SDRP/data/coadd_g_dir/ /datasets/gapon/data/SDRP/data/coadd_r_dir/ /datasets/gapon/data/SDRP/data/coadd_i_dir/ /datasets/gapon/data/SDRP/data/coadd_z_dir/ Relative location of an image in question (as per the catalog): deepCoadd-results/u/0/366,0/calexp-u-0-366,0.fits.gz deepCoadd-results/g/0/366,0/calexp-g-0-366,0.fits.gz deepCoadd-results/r/0/366,0/calexp-r-0-366,0.fits.gz deepCoadd-results/i/0/366,0/calexp-i-0-366,0.fits.gz deepCoadd-results/z/0/366,0/calexp-z-0-366,0.fits.gz Hence the full path of an image would look like this: /datasets/gapon/data/SDRP/data/coadd_u_dir/deepCoadd-results/u/0/366,0/calexp-u-0-366,0.fits.gz The relevant SQL query: SELECT path FROM gapon_sdss_stripe92_patch366_0.DeepCoadd; +---------------------------------------------------+ | path | +---------------------------------------------------+ | deepCoadd-results/u/0/366,0/calexp-u-0-366,0.fits | | deepCoadd-results/g/0/366,0/calexp-g-0-366,0.fits | | deepCoadd-results/r/0/366,0/calexp-r-0-366,0.fits | | deepCoadd-results/i/0/366,0/calexp-i-0-366,0.fits | | deepCoadd-results/z/0/366,0/calexp-z-0-366,0.fits | +---------------------------------------------------+ FITS images of calexps Base file path is: /datasets/gapon/data/SDRP_2014_NCSA/calexp_dir/ To figure out the relative locations of the images locations of images one should be using the following query: SELECT path FROM gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure; Images are spread between the following runs: SELECT run, count (*) FROM gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure GROUP BY run; +------+----------+ | run | count(*) | +------+----------+ | 1755 | 10 | | 2650 | 10 | ... | 7177 | 10 | | 7183 | 10 | | 7195 | 9 | | 7199 | 10 | | 7202 | 10 | +------+----------+ 145 rows in set (0.01 sec) NOTE : Practically all runs in the NCSA range of the processing have been reported by this query.
          Hide
          gapon Igor Gaponenko added a comment -

          Transferring the catalog to the public MySQL server (lsst-db.ncsa.illinois.edu)

          The database has been transferred from the Nebula instance to the final destination at lsst-db.ncsa.illinois.edu.

          ATTENTION: apart from the greater stability of this service, another reason why this has to be done is because the destination server has the scisql extension installed. It may be required by the SUIT applications.

          Show
          gapon Igor Gaponenko added a comment - Transferring the catalog to the public MySQL server (lsst-db.ncsa.illinois.edu) The database has been transferred from the Nebula instance to the final destination at lsst-db.ncsa.illinois.edu . ATTENTION : apart from the greater stability of this service, another reason why this has to be done is because the destination server has the scisql extension installed. It may be required by the SUIT applications.
          Hide
          gpdf Gregory Dubois-Felsmann added a comment -

          +1
          Thank you!

          Show
          gpdf Gregory Dubois-Felsmann added a comment - +1 Thank you!
          Hide
          gapon Igor Gaponenko added a comment - - edited

          Building the subset of the catalog

          The subset has been assembled using a MriaDB service run on a NEBULA instance lsst-gapon-0 (floating IP address 141.142.211.152) at NCSA. A complete description of the procedure follows below:

          CREATE DATABASE gapon_sdss_stripe92_patch366_0;
          

          Deep coadds

          CREATE TABLE    gapon_sdss_stripe92_patch366_0.DeepCoadd LIKE gapon_SDRP_Stripe82.DeepCoadd;
          CREATE TABLE    gapon_sdss_stripe92_patch366_0.DeepCoadd_Metadata LIKE gapon_SDRP_Stripe82.DeepCoadd_Metadata;
           
          CREATE TABLE    gapon_sdss_stripe92_patch366_0.DeepCoadd_To_Htm10 LIKE gapon_SDRP_Stripe82.DeepCoadd_To_Htm10;
          SELECT * FROM merge_info.ncsa_DeepCoadd_overlap WHERE patch='366,0';
          

          +-------------+-------+-------+----------+
          | deepCoaddId | tract | patch | filterId |
          +-------------+-------+-------+----------+
          |    23986176 |     0 | 366,0 |        0 |
          |    23986178 |     0 | 366,0 |        2 |
          |    23986180 |     0 | 366,0 |        4 |
          |    23986177 |     0 | 366,0 |        1 |
          |    23986179 |     0 | 366,0 |        3 |
          +-------------+-------+-------+----------+
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.DeepCoadd          SELECT * FROM gapon_SDRP_Stripe82.DeepCoadd          WHERE deepCoaddId IN (23986176, 23986178, 23986180, 23986177, 23986179);
          INSERT INTO gapon_sdss_stripe92_patch366_0.DeepCoadd_Metadata SELECT * FROM gapon_SDRP_Stripe82.DeepCoadd_Metadata WHERE deepCoaddId IN (23986176, 23986178, 23986180, 23986177, 23986179);
          INSERT INTO gapon_sdss_stripe92_patch366_0.DeepCoadd_To_Htm10 SELECT * FROM gapon_SDRP_Stripe82.DeepCoadd_To_Htm10 WHERE deepCoaddId IN (23986176, 23986178, 23986180, 23986177, 23986179);
          

          Objects

          CREATE TABLE gapon_sdss_stripe92_patch366_0.RunDeepSource LIKE gapon_SDRP_Stripe82.RunDeepSource;
          SELECT COUNT(*) FROM gapon_SDRP_Stripe82.RunDeepSource WHERE coadd_id IN (23986176, 23986178, 23986180, 23986177, 23986179);
          

          +----------+
          | COUNT(*) |
          +----------+
          |    34802 |
          +----------+
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepSource SELECT * FROM gapon_SDRP_Stripe82.RunDeepSource WHERE coadd_id IN (23986176, 23986178, 23986180, 23986177, 23986179);
          

          Forced sources

          CREATE TABLE gapon_sdss_stripe92_patch366_0.RunDeepForcedSource LIKE daues_SDRP_dedupe_byfilter_0.RunDeepForcedSource;
          INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_0.RunDeepForcedSource WHERE objectId IN (SELECT id FROM  gapon_sdss_stripe92_patch366_0.RunDeepSource);
          

          Query OK, 511197 rows affected (1 hour 14 min 29.06 sec)
          Records: 511197  Duplicates: 0  Warnings: 0
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_1.RunDeepForcedSource WHERE objectId IN (SELECT id FROM  gapon_sdss_stripe92_patch366_0.RunDeepSource);
          

          Query OK, 511072 rows affected (1 hour 31 min 34.98 sec)
          Records: 511072  Duplicates: 0  Warnings: 0
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_2.RunDeepForcedSource WHERE objectId IN (SELECT id FROM  gapon_sdss_stripe92_patch366_0.RunDeepSource);
          

          Query OK, 510441 rows affected (1 hour 38 min 7.73 sec)
          Records: 510441  Duplicates: 0  Warnings: 0
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_3.RunDeepForcedSource WHERE objectId IN (SELECT id FROM  gapon_sdss_stripe92_patch366_0.RunDeepSource);
          

          Query OK, 510079 rows affected (1 hour 42 min 11.82 sec)
          Records: 510079  Duplicates: 0  Warnings: 0
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_4.RunDeepForcedSource WHERE objectId IN (SELECT id FROM  gapon_sdss_stripe92_patch366_0.RunDeepSource);
          

          Query OK, 509765 rows affected (1 hour 44 min 21.06 sec)
          Records: 509765  Duplicates: 0  Warnings: 0
          

          Calexps

          CREATE TABLE gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure          LIKE gapon_SDRP_Stripe82.Science_Ccd_Exposure;
          CREATE TABLE gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure_Metadata LIKE gapon_SDRP_Stripe82.Science_Ccd_Exposure_Metadata;
          CREATE TABLE gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure_To_Htm10 LIKE gapon_SDRP_Stripe82.Science_Ccd_Exposure_To_Htm10;
          SELECT exposure_id,COUNT(*) FROM gapon_sdss_stripe92_patch366_0.RunDeepForcedSource GROUP BY exposure_id;
          

          +-------------+----------+
          | exposure_id | COUNT(*) |
          +-------------+----------+
          |  1755010439 |     4034 |
          |  1755010440 |     2701 |
          |  1755110439 |     4024 |
          |  1755110440 |     2715 |
          |  1755210439 |     4076 |
          ...
          |  7202210365 |      204 |
          |  7202210366 |      261 |
          |  7202310365 |      204 |
          |  7202310366 |      260 |
          |  7202410365 |      202 |
          |  7202410366 |      260 |
          +-------------+----------+
          1854 rows in set (0.47 sec)
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure SELECT * FROM gapon_SDRP_Stripe82.Science_Ccd_Exposure WHERE scienceCcdExposureId IN (SELECT DISTINCT exposure_id FROM gapon_sdss_stripe92_patch366_0.RunDeepForcedSource);
          

          Query OK, 1854 rows affected (2.30 sec)
          Records: 1854  Duplicates: 0  Warnings: 0
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure_Metadata SELECT * FROM gapon_SDRP_Stripe82.Science_Ccd_Exposure_Metadata WHERE scienceCcdExposureId IN (SELECT scienceCcdExposureId FROM gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure);
          

          Query OK, 216918 rows affected (2 min 3.78 sec)
          Records: 216918  Duplicates: 0  Warnings: 0
          

          INSERT INTO gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure_To_Htm10 SELECT * FROM gapon_SDRP_Stripe82.Science_Ccd_Exposure_To_Htm10 WHERE scienceCcdExposureId IN (SELECT scienceCcdExposureId FROM gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure);
          

          Query OK, 35194 rows affected (7.77 sec)
          Records: 35194  Duplicates: 0  Warnings: 0
          

          Other tables

          CREATE TABLE gapon_sdss_stripe92_patch366_0.Filter             LIKE gapon_SDRP_Stripe82.Filter;
          CREATE TABLE gapon_sdss_stripe92_patch366_0.LeapSeconds        LIKE gapon_SDRP_Stripe82.LeapSeconds;
          CREATE TABLE gapon_sdss_stripe92_patch366_0.ZZZ_Db_Description LIKE gapon_SDRP_Stripe82.ZZZ_Db_Description;
           
          INSERT INTO gapon_sdss_stripe92_patch366_0.Filter             SELECT * FROM gapon_SDRP_Stripe82.Filter;
          INSERT INTO gapon_sdss_stripe92_patch366_0.LeapSeconds        SELECT * FROM gapon_SDRP_Stripe82.LeapSeconds;
          INSERT INTO gapon_sdss_stripe92_patch366_0.ZZZ_Db_Description SELECT * FROM gapon_SDRP_Stripe82.ZZZ_Db_Description;
          

          Show
          gapon Igor Gaponenko added a comment - - edited Building the subset of the catalog The subset has been assembled using a MriaDB service run on a NEBULA instance lsst-gapon-0 (floating IP address 141.142.211.152 ) at NCSA. A complete description of the procedure follows below: CREATE DATABASE gapon_sdss_stripe92_patch366_0; Deep coadds CREATE TABLE gapon_sdss_stripe92_patch366_0.DeepCoadd LIKE gapon_SDRP_Stripe82.DeepCoadd; CREATE TABLE gapon_sdss_stripe92_patch366_0.DeepCoadd_Metadata LIKE gapon_SDRP_Stripe82.DeepCoadd_Metadata;   CREATE TABLE gapon_sdss_stripe92_patch366_0.DeepCoadd_To_Htm10 LIKE gapon_SDRP_Stripe82.DeepCoadd_To_Htm10; SELECT * FROM merge_info.ncsa_DeepCoadd_overlap WHERE patch= '366,0' ; +-------------+-------+-------+----------+ | deepCoaddId | tract | patch | filterId | +-------------+-------+-------+----------+ | 23986176 | 0 | 366,0 | 0 | | 23986178 | 0 | 366,0 | 2 | | 23986180 | 0 | 366,0 | 4 | | 23986177 | 0 | 366,0 | 1 | | 23986179 | 0 | 366,0 | 3 | +-------------+-------+-------+----------+ INSERT INTO gapon_sdss_stripe92_patch366_0.DeepCoadd SELECT * FROM gapon_SDRP_Stripe82.DeepCoadd WHERE deepCoaddId IN (23986176, 23986178, 23986180, 23986177, 23986179); INSERT INTO gapon_sdss_stripe92_patch366_0.DeepCoadd_Metadata SELECT * FROM gapon_SDRP_Stripe82.DeepCoadd_Metadata WHERE deepCoaddId IN (23986176, 23986178, 23986180, 23986177, 23986179); INSERT INTO gapon_sdss_stripe92_patch366_0.DeepCoadd_To_Htm10 SELECT * FROM gapon_SDRP_Stripe82.DeepCoadd_To_Htm10 WHERE deepCoaddId IN (23986176, 23986178, 23986180, 23986177, 23986179); Objects CREATE TABLE gapon_sdss_stripe92_patch366_0.RunDeepSource LIKE gapon_SDRP_Stripe82.RunDeepSource; SELECT COUNT (*) FROM gapon_SDRP_Stripe82.RunDeepSource WHERE coadd_id IN (23986176, 23986178, 23986180, 23986177, 23986179); +----------+ | COUNT(*) | +----------+ | 34802 | +----------+ INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepSource SELECT * FROM gapon_SDRP_Stripe82.RunDeepSource WHERE coadd_id IN (23986176, 23986178, 23986180, 23986177, 23986179); Forced sources CREATE TABLE gapon_sdss_stripe92_patch366_0.RunDeepForcedSource LIKE daues_SDRP_dedupe_byfilter_0.RunDeepForcedSource; INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_0.RunDeepForcedSource WHERE objectId IN ( SELECT id FROM gapon_sdss_stripe92_patch366_0.RunDeepSource); Query OK, 511197 rows affected (1 hour 14 min 29.06 sec) Records: 511197 Duplicates: 0 Warnings: 0 INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_1.RunDeepForcedSource WHERE objectId IN ( SELECT id FROM gapon_sdss_stripe92_patch366_0.RunDeepSource); Query OK, 511072 rows affected (1 hour 31 min 34.98 sec) Records: 511072 Duplicates: 0 Warnings: 0 INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_2.RunDeepForcedSource WHERE objectId IN ( SELECT id FROM gapon_sdss_stripe92_patch366_0.RunDeepSource); Query OK, 510441 rows affected (1 hour 38 min 7.73 sec) Records: 510441 Duplicates: 0 Warnings: 0 INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_3.RunDeepForcedSource WHERE objectId IN ( SELECT id FROM gapon_sdss_stripe92_patch366_0.RunDeepSource); Query OK, 510079 rows affected (1 hour 42 min 11.82 sec) Records: 510079 Duplicates: 0 Warnings: 0 INSERT INTO gapon_sdss_stripe92_patch366_0.RunDeepForcedSource SELECT * FROM daues_SDRP_dedupe_byfilter_4.RunDeepForcedSource WHERE objectId IN ( SELECT id FROM gapon_sdss_stripe92_patch366_0.RunDeepSource); Query OK, 509765 rows affected (1 hour 44 min 21.06 sec) Records: 509765 Duplicates: 0 Warnings: 0 Calexps CREATE TABLE gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure LIKE gapon_SDRP_Stripe82.Science_Ccd_Exposure; CREATE TABLE gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure_Metadata LIKE gapon_SDRP_Stripe82.Science_Ccd_Exposure_Metadata; CREATE TABLE gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure_To_Htm10 LIKE gapon_SDRP_Stripe82.Science_Ccd_Exposure_To_Htm10; SELECT exposure_id, COUNT (*) FROM gapon_sdss_stripe92_patch366_0.RunDeepForcedSource GROUP BY exposure_id; +-------------+----------+ | exposure_id | COUNT(*) | +-------------+----------+ | 1755010439 | 4034 | | 1755010440 | 2701 | | 1755110439 | 4024 | | 1755110440 | 2715 | | 1755210439 | 4076 | ... | 7202210365 | 204 | | 7202210366 | 261 | | 7202310365 | 204 | | 7202310366 | 260 | | 7202410365 | 202 | | 7202410366 | 260 | +-------------+----------+ 1854 rows in set (0.47 sec) INSERT INTO gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure SELECT * FROM gapon_SDRP_Stripe82.Science_Ccd_Exposure WHERE scienceCcdExposureId IN ( SELECT DISTINCT exposure_id FROM gapon_sdss_stripe92_patch366_0.RunDeepForcedSource); Query OK, 1854 rows affected (2.30 sec) Records: 1854 Duplicates: 0 Warnings: 0 INSERT INTO gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure_Metadata SELECT * FROM gapon_SDRP_Stripe82.Science_Ccd_Exposure_Metadata WHERE scienceCcdExposureId IN ( SELECT scienceCcdExposureId FROM gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure); Query OK, 216918 rows affected (2 min 3.78 sec) Records: 216918 Duplicates: 0 Warnings: 0 INSERT INTO gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure_To_Htm10 SELECT * FROM gapon_SDRP_Stripe82.Science_Ccd_Exposure_To_Htm10 WHERE scienceCcdExposureId IN ( SELECT scienceCcdExposureId FROM gapon_sdss_stripe92_patch366_0.Science_Ccd_Exposure); Query OK, 35194 rows affected (7.77 sec) Records: 35194 Duplicates: 0 Warnings: 0 Other tables CREATE TABLE gapon_sdss_stripe92_patch366_0.Filter LIKE gapon_SDRP_Stripe82.Filter; CREATE TABLE gapon_sdss_stripe92_patch366_0.LeapSeconds LIKE gapon_SDRP_Stripe82.LeapSeconds; CREATE TABLE gapon_sdss_stripe92_patch366_0.ZZZ_Db_Description LIKE gapon_SDRP_Stripe82.ZZZ_Db_Description;   INSERT INTO gapon_sdss_stripe92_patch366_0.Filter SELECT * FROM gapon_SDRP_Stripe82.Filter; INSERT INTO gapon_sdss_stripe92_patch366_0.LeapSeconds SELECT * FROM gapon_SDRP_Stripe82.LeapSeconds; INSERT INTO gapon_sdss_stripe92_patch366_0.ZZZ_Db_Description SELECT * FROM gapon_SDRP_Stripe82.ZZZ_Db_Description;

            People

            Assignee:
            gapon Igor Gaponenko
            Reporter:
            gapon Igor Gaponenko
            Watchers:
            Gregory Dubois-Felsmann, Igor Gaponenko, Xiuqin Wu [X] (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: