Changeset 19940

Timestamp:

Oct 7, 2008, 9:53:50 AM (18 years ago)

Author:

eugene

Message:

adding IQ stats, n_psfstars, n_iqstars; set version to 1.1.41

Location:

trunk/dbconfig

Files:

• cam.md (modified) (1 diff)
• changes.txt (modified) (2 diffs)
• chip.md (modified) (1 diff)
• config.md (modified) (1 diff)

trunk/dbconfig/cam.md

@@ -34 +34 @@
     fwhm_major     F32      0.0
     fwhm_minor     F32      0.0
+
+    iq_m2           F32     0.0        
+    iq_m2_err       F32     0.0        
+    iq_m2_lq        F32     0.0        
+    iq_m2_uq        F32     0.0        
+
+    iq_m2c          F32     0.0        
+    iq_m2c_err      F32     0.0        
+    iq_m2c_lq       F32     0.0        
+    iq_m2c_uq       F32     0.0        
+
+    iq_m2s          F32     0.0        
+    iq_m2s_err      F32     0.0        
+    iq_m2s_lq       F32     0.0        
+    iq_m2s_uq       F32     0.0        
+
+    iq_m3           F32     0.0        
+    iq_m3_err       F32     0.0        
+    iq_m3_lq        F32     0.0        
+    iq_m3_uq        F32     0.0        
+
+    iq_m4           F32     0.0        
+    iq_m4_err       F32     0.0        
+    iq_m4_lq        F32     0.0        
+    iq_m4_uq        F32     0.0        
+
     dtime_script   F32      0.0
     hostname       STR      64
     n_stars        S32      0
+    n_psfstars     S32      0
+    n_iqstars      S32      0
     n_extended     S32      0
     n_cr           S32      0

trunk/dbconfig/changes.txt

@@ -537 +537 @@
 -- Reusing astrometry time field since ppImage doesn't do that any more
 ALTER TABLE chipProcessedImfile CHANGE COLUMN dtime_astrom dtime_total FLOAT;
+
 -- Deleting fields requiring astrometric matching from chipProcessedImfile
 ALTER TABLE chipProcessedImfile DROP COLUMN sigma_ra;
@@ -558 +559 @@
 
 * 1.1.40
+
+-- Add moments statistics (M2, M3, M4)
+
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2     FLOAT AFTER fwhm_minor;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2_err FLOAT AFTER iq_m2;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2_lq  FLOAT AFTER iq_m2_err;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2_uq  FLOAT AFTER iq_m2_lq;
+
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2c     FLOAT AFTER iq_m2_uq;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2c_err FLOAT AFTER iq_m2c;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2c_lq  FLOAT AFTER iq_m2c_err;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2c_uq  FLOAT AFTER iq_m2c_lq;
+
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2s     FLOAT AFTER iq_m2c_uq;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2s_err FLOAT AFTER iq_m2s;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2s_lq  FLOAT AFTER iq_m2s_err;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2s_uq  FLOAT AFTER iq_m2s_lq;
+
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m3     FLOAT AFTER iq_m2s_uq;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m3_err FLOAT AFTER iq_m3;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m3_lq  FLOAT AFTER iq_m3_err;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m3_uq  FLOAT AFTER iq_m3_lq;
+
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m4     FLOAT AFTER iq_m3_uq;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m4_err FLOAT AFTER iq_m4;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m4_lq  FLOAT AFTER iq_m4_err;
+ALTER TABLE chipProcessedImfile ADD COLUMN iq_m4_uq  FLOAT AFTER iq_m4_lq;
+
+ALTER TABLE chipProcessedImfile ADD COLUMN n_psfstars INT AFTER n_stars;
+ALTER TABLE chipProcessedImfile ADD COLUMN n_iqstars INT AFTER n_psfstars;
+
+
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2      FLOAT AFTER fwhm_minor;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2_err  FLOAT AFTER iq_m2;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2_lq   FLOAT AFTER iq_m2_err;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2_uq   FLOAT AFTER iq_m2_lq;
+
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2c     FLOAT AFTER iq_m2_uq;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2c_err FLOAT AFTER iq_m2c;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2c_lq  FLOAT AFTER iq_m2c_err;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2c_uq  FLOAT AFTER iq_m2c_lq;
+
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2s     FLOAT AFTER iq_m2c_uq;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2s_err FLOAT AFTER iq_m2s;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2s_lq  FLOAT AFTER iq_m2s_err;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m2s_uq  FLOAT AFTER iq_m2s_lq;
+
+ALTER TABLE camProcessedExp ADD COLUMN iq_m3      FLOAT AFTER iq_m2s_uq;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m3_err  FLOAT AFTER iq_m3;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m3_lq   FLOAT AFTER iq_m3_err;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m3_uq   FLOAT AFTER iq_m3_lq;
+
+ALTER TABLE camProcessedExp ADD COLUMN iq_m4      FLOAT AFTER iq_m3_uq;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m4_err  FLOAT AFTER iq_m4;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m4_lq   FLOAT AFTER iq_m4_err;
+ALTER TABLE camProcessedExp ADD COLUMN iq_m4_uq   FLOAT AFTER iq_m4_lq;
+
+ALTER TABLE camProcessedExp ADD COLUMN n_psfstars INT AFTER n_stars;
+ALTER TABLE camProcessedExp ADD COLUMN n_iqstars INT AFTER n_psfstars;
+
+* 1.1.41

trunk/dbconfig/chip.md

@@ -31 +31 @@
     fwhm_major      F32     0.0
     fwhm_minor      F32     0.0
+
+    iq_m2           F32     0.0        
+    iq_m2_err       F32     0.0        
+    iq_m2_lq        F32     0.0        
+    iq_m2_uq        F32     0.0        
+
+    iq_m2c          F32     0.0        
+    iq_m2c_err      F32     0.0        
+    iq_m2c_lq       F32     0.0        
+    iq_m2c_uq       F32     0.0        
+
+    iq_m2s          F32     0.0        
+    iq_m2s_err      F32     0.0        
+    iq_m2s_lq       F32     0.0        
+    iq_m2s_uq       F32     0.0        
+
+    iq_m3           F32     0.0        
+    iq_m3_err       F32     0.0        
+    iq_m3_lq        F32     0.0        
+    iq_m3_uq        F32     0.0        
+
+    iq_m4           F32     0.0        
+    iq_m4_err       F32     0.0        
+    iq_m4_lq        F32     0.0        
+    iq_m4_uq        F32     0.0        
+
     dtime_detrend   F32     0.0
     dtime_photom    F32     0.0
     dtime_total     F32     0.0
     dtime_script    F32     0.0
+
     hostname        STR     64
     n_stars         S32     0
+    n_psfstars      S32     0
+    n_iqstars       S32     0
     n_extended      S32     0
     n_cr            S32     0

trunk/dbconfig/config.md

@@ -2 +2 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.40
+    pkg_version     STR     1.1.41
 END