Changeset 39029 for trunk/ippToPsps/config/tables.FG.vot

Timestamp:

Nov 2, 2015, 4:32:17 PM (11 years ago)

Author:

watersc1

Message:

As per discussion, drop ForcedSummaryToImage and ForcedSummaryMeta tables, as they duplicate information better accesed via the ForcedWarp/Stack tables. Changed XforcedSummaryID to XstackImageID to the link back to stack information, and to match the IMAGE_ID populated from DVO. Change forcedgalaxybatch.py to know this column name change, and cut commented code that was to implement the dropped tables from forcedwarpbatch.py.

File:

• trunk/ippToPsps/config/tables.FG.vot (modified) (7 diffs)

trunk/ippToPsps/config/tables.FG.vot

@@ -3 +3 @@
 <VOTABLE version="1.1">
   <RESOURCE>
-    <TABLE name="ForcedSummaryMeta">
-      <DESCRIPTION>Contains the metadata linking the stacked image used to generate sources to the summary of the single epoch forced warp photometry.</DESCRIPTION>
-      <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>
-      <FIELD name="forcedSummaryID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique forced warp summary identifier.</DESCRIPTION>
-      </FIELD>
-      <FIELD name="batchID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Internal database batch identifier.</DESCRIPTION>
-      </FIELD>
-      <FIELD name="surveyID" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="NA">
-        <DESCRIPTION>Survey identifier.  Details in the Survey table.</DESCRIPTION>
-      </FIELD>
-      <FIELD name="filterID" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="NA">
-        <DESCRIPTION>Filter identifier.  Details in the Filter table.</DESCRIPTION>
-      </FIELD>
-      <FIELD name="stackMetaID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique stack identifier.</DESCRIPTION>
-      </FIELD>
-      <FIELD name="processingVersion" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="NA">
-        <DESCRIPTION>Data release version.</DESCRIPTION>
-      </FIELD>
-      <DATA>
-        <TABLEDATA></TABLEDATA>
-      </DATA>
-    </TABLE>
     <TABLE name="ForcedGalaxyShape">
       <DESCRIPTION>Contains the extended source galaxy shape parameters.  All filters are matched into a single row.  References:  Sersic, J. L. 1963, Boletin de la Asociacion Argentina de Astronomia La Plata Argentina, 6, 41.</DESCRIPTION>
@@ -53 +28 @@
         <DESCRIPTION>IPP internal detection identifier.</DESCRIPTION>
       </FIELD>
-      <FIELD name="gforcedSummaryID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique forced warp summary identifier.</DESCRIPTION>
+      <FIELD name="gstackImageID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
+        <DESCRIPTION>Unique stack identifier for the g filter stack that was the original detection source.</DESCRIPTION>
       </FIELD>
       <FIELD name="gGalMajor" arraysize="1" datatype="float" unit="arcsec" default="-999">
@@ -81 +56 @@
         <DESCRIPTION>IPP internal detection identifier.</DESCRIPTION>
       </FIELD>
-      <FIELD name="rforcedSummaryID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique forced warp summary identifier.</DESCRIPTION>
+      <FIELD name="rstackImageID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
+        <DESCRIPTION>Unique stack identifier for the r filter stack that was the original detection source.</DESCRIPTION>
       </FIELD>
       <FIELD name="rGalMajor" arraysize="1" datatype="float" unit="arcsec" default="-999">
@@ -110 +85 @@
       </FIELD>
       <FIELD name="iforcedSummaryID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique forced warp summary identifier.</DESCRIPTION>
+        <DESCRIPTION>Unique stack identifier for the i filter stack that was the original detection source.</DESCRIPTION>
       </FIELD>
       <FIELD name="iGalMajor" arraysize="1" datatype="float" unit="arcsec" default="-999">
@@ -137 +112 @@
         <DESCRIPTION>IPP internal detection identifier.</DESCRIPTION>
       </FIELD>
-      <FIELD name="zforcedSummaryID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique forced warp summary identifier.</DESCRIPTION>
+      <FIELD name="zstackImageID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
+        <DESCRIPTION>Unique stack identifier for the z filter stack that was the original detection source.</DESCRIPTION>
       </FIELD>
       <FIELD name="zGalMajor" arraysize="1" datatype="float" unit="arcsec" default="-999">
@@ -165 +140 @@
         <DESCRIPTION>IPP internal detection identifier.</DESCRIPTION>
       </FIELD>
-      <FIELD name="yforcedSummaryID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique forced warp summary identifier.</DESCRIPTION>
+      <FIELD name="ystackImageID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
+        <DESCRIPTION>Unique stack identifier for the z filter stack that was the original detection source.</DESCRIPTION>
       </FIELD>
       <FIELD name="yGalMajor" arraysize="1" datatype="float" unit="arcsec" default="-999">
@@ -193 +168 @@
       </DATA>
     </TABLE>
-    <TABLE name="ForcedSummaryToImage">
-      <DESCRIPTION>Contains the mapping of which input images were used for the forced photometry summary.</DESCRIPTION>
-      <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>
-      <FIELD name="forcedSummaryID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique forced warp summary identifier.</DESCRIPTION>
-      </FIELD>
-      <FIELD name="imageID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
-        <DESCRIPTION>Unique image identifier.  Constructed as (100 * frameID + ccdID).</DESCRIPTION>
-      </FIELD>
-      <DATA>
-        <TABLEDATA></TABLEDATA>
-      </DATA>
-    </TABLE>
    </RESOURCE>
 </VOTABLE>