Changeset 37167

Timestamp:

Aug 1, 2014, 5:10:30 PM (12 years ago)

Author:

eugene

Message:

add some notes

Location:

branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES

Files:

• Fundamental_IPP_Data_Product_Tables/StackModelFitPet (modified) (1 diff)
• Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (modified) (2 diffs)
• MetaData_Tables/StackMeta (modified) (1 diff)

branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitPet

@@ -12 +12 @@
 dataRelease      dimensionless  TINYINT 1       NA      Data release when this table was loaded
 -------------------------------------------------------- replicate below for all filters (grizy)
-gippObjID         dimensionless  BIGINT  8       NA      ipp object identifier
 gippDetectID    dimensionless   BIGINT  8       NA      ipp detect identifier
 gstackDetectID  dimensionless   BIGINT  8       NA      ODM detection identifier

branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt

@@ -1 +1 @@
                   
 objID              = dvo = average.extID   [calculated in addstar]
-gcObjID            = dvo = average.extIDgc [calculated in addstar]
+gcObjID            = dvo = average.extIDgc [not done]
 ippObjID           = dvo = average.objID + (average.catID << 32)
 surveyID           = ipptopsps
 skyCellID          = ipptopsps / smf header
-randomStackObjID   = ipptopsps
+randomStackObjID   = ipptopsps (RANDOM on sql into mysql)
 stackDetectRowID   = PSPS ?
 primaryDetection   = dvo 
@@ -25 +25 @@
 gdecErr            = dvo = average.dDstk [relastro]
 gzp                = dvo [relphot] -- XXX define this more exactly
-gPSFMag            = smf
-gPSFMagErr         = smf
-gApMag             = smf
-gApMagErr          = smf
-gKronMag           = smf (calculated)
-gKronMagErr        = smf (calculated)
+gPSFMag            = dvo
+gPSFMagErr         = dvo
+gApMag             = dvo
+gApMagErr          = dvo
+gKronMag           = dvo
+gKronMagErr        = dvo
 gsky               = smf
 gskyErr            = smf

branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta

@@ -9 +9 @@
 analVer     dimensionless   SMALLINT 2 -999 analysis version index
 expTime     seconds         REAL 4 -999 exposure time
-nP2Images   dimensionless   SMALLINT 2 -999 number of P2 images contributing to this cell
+nP2Images   dimensionless   SMALLINT 2 -999 number of P2 images contributing to this cell 
 completMag  magnitudes      REAL 4 -999 95% completion level in mag
 astroScat   dimensionless   REAL 4 -999 astrometric scatter for chip