[WP3]
Re: Type evolution announcement - Changes related to Astrometry
D.R. Boxhoorn
danny at astro.rug.nl
Fri Oct 28 11:02:56 CEST 2005
Dear reader,
Please note that the changes to AstrometricParameters, PhotSrcCatalog,
ReducedScienceFrame and RegriddedFrame - which require type evolution - will
be committed to CVS today.
Cheers,
Danny
On Wed, Oct 26, 2005 at 04:52:19PM +0200, Danny Boxhoorn wrote:
>
> Dear Astro-Wise database maintainer,
>
> In the very near future the astrometry will be detached from the rest of the
> Image Pipeline in Astro-Wise.
>
> - This will make it possible to redo the astrometry without the need to
> de-bias and flat-field at the same time.
> - This is the first step towards a more accurate astrometric solution that uses
> sources in overlapping areas of images/frames, like, for example, in a dither.
>
> The modified classes - AstrometricParameters, PhotSrcCatalog,
> ReducedScienceFrame, RegriddedFrame - are are now in opipe/Experimental.
> The corresponding type evolution instructions appear below.
>
> We expect to commit these changes to opipe/astro/main this week and we will
> send you an e-mail when we are about to do so.
> If you do not want to evolve the types, please do not forget to suspend your
> automatic cvs updates.
>
> Do not hesitate if you have any questions.
>
> Cheers and good luck,
>
> Danny, Ronald, Kor
>
>
> 1) -----------------------------------------------------------------------------
>
> ALTER TYPE "ReducedScienceFrameParameters$" DROP ATTRIBUTE "RESTORE_BACKGROUND" CASCADE INCLUDING TABLE DATA;
>
> 2) -----------------------------------------------------------------------------
>
> ALTER TYPE "ReducedScienceFrame$" ADD ATTRIBUTE ("is_valid" SMALLINT, "weight" REF "WeightFrame$") CASCADE INCLUDING TABLE DATA;
> UPDATE "ReducedScienceFrame" SET "is_valid"=1;
> UPDATE "ReducedScienceFrame" p SET "weight"=(SELECT TREAT("weight" AS REF "WeightFrame$") FROM "ScienceFrame" q WHERE "reduced"=REF(p));
> UPDATE "ReducedScienceFrame" p SET "filename"=(SELECT "filename" FROM "ScienceFrame" q WHERE "reduced"=REF(p));
> COMMIT;
> --DELETE "Imstat" WHERE OBJECT_ID IN (SELECT "backstat" FROM "ReducedScienceFrame")
> ALTER TYPE "ReducedScienceFrame$" DROP ATTRIBUTE ("backstat", "saturated") CASCADE INCLUDING TABLE DATA;
>
> 3) -----------------------------------------------------------------------------
>
> ALTER TYPE "AstrometricParameters$" ADD ATTRIBUTE (
> "process_status" SMALLINT,
> "quality_flags" SMALLINT,
> "SEEING" DOUBLE PRECISION,
> "CTYPE1" VARCHAR2(297),
> "CRPIX1" DOUBLE PRECISION,
> "CRVAL1" DOUBLE PRECISION,
> "CTYPE2" VARCHAR2(297),
> "CRPIX2" DOUBLE PRECISION,
> "CRVAL2" DOUBLE PRECISION,
> "CD1_1" DOUBLE PRECISION,
> "CD1_2" DOUBLE PRECISION,
> "CD2_1" DOUBLE PRECISION,
> "CD2_2" DOUBLE PRECISION,
> "PV1_0" DOUBLE PRECISION,
> "PV1_1" DOUBLE PRECISION,
> "PV1_2" DOUBLE PRECISION,
> "PV1_3" DOUBLE PRECISION,
> "PV1_4" DOUBLE PRECISION,
> "PV1_5" DOUBLE PRECISION,
> "PV1_6" DOUBLE PRECISION,
> "PV1_7" DOUBLE PRECISION,
> "PV1_8" DOUBLE PRECISION,
> "PV1_9" DOUBLE PRECISION,
> "PV2_0" DOUBLE PRECISION,
> "PV2_1" DOUBLE PRECISION,
> "PV2_2" DOUBLE PRECISION,
> "PV2_3" DOUBLE PRECISION,
> "PV2_4" DOUBLE PRECISION,
> "PV2_5" DOUBLE PRECISION,
> "PV2_6" DOUBLE PRECISION,
> "PV2_7" DOUBLE PRECISION,
> "PV2_8" DOUBLE PRECISION,
> "PV2_9" DOUBLE PRECISION,
> "NREF" SMALLINT,
> "MEAN_DDEC" DOUBLE PRECISION,
> "MEAN_DRA" DOUBLE PRECISION,
> "SIG_DDEC" DOUBLE PRECISION,
> "SIG_DRA" DOUBLE PRECISION,
> "field_err" DOUBLE PRECISION,
> "x_err" DOUBLE PRECISION,
> "y_err" DOUBLE PRECISION,
> "xx_err" DOUBLE PRECISION,
> "xy_err" DOUBLE PRECISION,
> "yy_err" DOUBLE PRECISION
> ) CASCADE INCLUDING TABLE DATA;
>
> UPDATE "AstrometricParameters" p SET
> "CD1_1"=p."astrom"."CD1_1",
> "CD1_2"=p."astrom"."CD1_2",
> "CD2_1"=p."astrom"."CD2_1",
> "CD2_2"=p."astrom"."CD2_2",
> "CRPIX1"=p."astrom"."CRPIX1",
> "CRPIX2"=p."astrom"."CRPIX2",
> "CRVAL1"=p."astrom"."CRVAL1",
> "CRVAL2"=p."astrom"."CRVAL2",
> "CTYPE1"=p."astrom"."CTYPE1",
> "CTYPE2"=p."astrom"."CTYPE2",
> "MEAN_DDEC"=p."astrom"."MEAN_DDEC",
> "MEAN_DRA"=p."astrom"."MEAN_DRA",
> "NREF"=p."astrom"."NREF",
> "PV1_0"=p."astrom"."PV1_0",
> "PV1_1"=p."astrom"."PV1_1",
> "PV1_2"=p."astrom"."PV1_2",
> "PV1_3"=p."astrom"."PV1_3",
> "PV1_4"=p."astrom"."PV1_4",
> "PV1_5"=p."astrom"."PV1_5",
> "PV1_6"=p."astrom"."PV1_6",
> "PV1_7"=p."astrom"."PV1_7",
> "PV1_8"=p."astrom"."PV1_8",
> "PV1_9"=p."astrom"."PV1_9",
> "PV2_0"=p."astrom"."PV2_0",
> "PV2_1"=p."astrom"."PV2_1",
> "PV2_2"=p."astrom"."PV2_2",
> "PV2_3"=p."astrom"."PV2_3",
> "PV2_4"=p."astrom"."PV2_4",
> "PV2_5"=p."astrom"."PV2_5",
> "PV2_6"=p."astrom"."PV2_6",
> "PV2_7"=p."astrom"."PV2_7",
> "PV2_8"=p."astrom"."PV2_8",
> "PV2_9"=p."astrom"."PV2_9",
> "SIG_DDEC"=p."astrom"."SIG_DDEC",
> "SIG_DRA"=p."astrom"."SIG_DRA",
> "field_err"=p."astrom"."field_err",
> "x_err"=p."astrom"."x_err",
> "xx_err"=p."astrom"."xx_err",
> "xy_err"=p."astrom"."xy_err",
> "y_err"=p."astrom"."y_err",
> "yy_err"=p."astrom"."yy_err";
> UPDATE "AstrometricParameters" p SET "SEEING"=(SELECT "SEEING" FROM "ScienceFrame" q WHERE p."reduced"=q."reduced");
> UPDATE "AstrometricParameters" SET "SEEING"=0.0 WHERE "SEEING" IS NULL;
> COMMIT;
>
> ALTER TYPE "AstrometricParameters$" DROP ATTRIBUTE "astrom" CASCADE INCLUDING TABLE DATA;
>
> ALTER TYPE "AstrometricParameters$" ADD ATTRIBUTE "tmpreduced" REF "BaseFrame$"
> CASCADE INCLUDING TABLE DATA;
> UPDATE "AstrometricParameters" SET "tmpreduced"="reduced";
> COMMIT;
> ALTER TYPE "AstrometricParameters$" DROP ATTRIBUTE "reduced" CASCADE INCLUDING TABLE DATA;
> -- DISCONNECT & CONNECT
> ALTER TYPE "AstrometricParameters$" ADD ATTRIBUTE "reduced" REF "BaseFrame$" CASCADE INCLUDING TABLE DATA;
> UPDATE "AstrometricParameters" SET "reduced"="tmpreduced";
> COMMIT;
> ALTER TYPE "AstrometricParameters$" DROP ATTRIBUTE "tmpreduced" CASCADE INCLUDING TABLE DATA;
>
> 4) -----------------------------------------------------------------------------
>
> ALTER TYPE "PhotSrcCatalog$" ADD ATTRIBUTE "astrom_params" REF "AstrometricParameters$" CASCADE INCLUDING TABLE DATA;
>
> 5) -----------------------------------------------------------------------------
>
> ALTER TYPE "RegriddedFrame$" ADD ATTRIBUTE ("photom_params" REF "PhotometricParameters$", "gain" REF "GainLinearity$", "reduced" REF "ReducedScienceFrame$") CASCADE INCLUDING TABLE DATA;
> UPDATE "RegriddedFrame" p SET "photom_params"=p."science_frame"."photom", "gain"=p."science_frame"."gainlin", "reduced"=p."science_frame"."reduced";
> COMMIT;
> ALTER TYPE "RegriddedFrame$" DROP ATTRIBUTE "science_frame" CASCADE INCLUDING TABLE DATA;
>
>
> F) -----------------------------------------------------------------------------
>
> In the `oemapp console' or from the SQL*Plus prompt.
>
> . Recompile invalid VIEWs
> . Recompile invalid TRIGGERs
More information about the WP3
mailing list