IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 19639


Ignore:
Timestamp:
Sep 22, 2008, 11:07:11 AM (18 years ago)
Author:
Paul Price
Message:

Adding additional statistics for diff.

Location:
trunk
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • trunk/dbconfig/changes.txt

    r19622 r19639  
    486486
    487487
     488
     489--- Additions for stack/diff QA by PAP.
     490ALTER TABLE diffSkyfile ADD COLUMN stamps_mean FLOAT AFTER stamps_num;
     491ALTER TABLE diffSkyfile ADD COLUMN dtime_match FLOAT AFTER dtime_diff;
     492ALTER TABLE diffSkyfile ADD COLUMN dtime_phot FLOAT AFTER dtime_match;

  • trunk/dbconfig/diff.md

    r19361 r19639  
    1 # $Id: diff.md,v 1.10 2008-09-05 00:18:26 eugene Exp $
     1# $Id: diff.md,v 1.11 2008-09-22 21:06:49 price Exp $
    22
    33diffRun METADATA
    … …  
    3737    bg_stdev    F64         0.0
    3838    stamps_num  S32         0
     39    stamps_mean F32         0.0
    3940    stamps_rms  F32         0.0
    4041    sources     S32         0
    4142    dtime_diff  F32         0.0
     43    dtime_match F32         0.0
     44    dtime_phot  F32         0.0
    4245    hostname    STR         64
    4346    good_frac   F32         0.0     # Key

  • trunk/ippTools/share/pxadmin_create_tables.sql

    r19621 r19639  
    656656
    657657CREATE TABLE detResidExp (
    658        det_id BIGINT,
    659        iteration INT,
    660        exp_id BIGINT,
    661        recipe VARCHAR(64),
    662        bg DOUBLE,
    663        bg_stdev DOUBLE,
    664        bg_mean_stdev DOUBLE,
    665        bg_skewness DOUBLE,
    666        bg_kurtosis DOUBLE,
    667        bin_stdev DOUBLE,
    668        fringe_0 DOUBLE,
    669        fringe_1 DOUBLE,
    670        fringe_2 DOUBLE,
    671        fringe_resid_0 DOUBLE,
    672        fringe_resid_1 DOUBLE,
    673        fringe_resid_2 DOUBLE,
    674        user_1 DOUBLE,
    675        user_2 DOUBLE,
    676        user_3 DOUBLE,
    677        user_4 DOUBLE,
    678        user_5 DOUBLE,
    679        path_base VARCHAR(255),
    680        data_state VARCHAR(64),
    681        accept TINYINT,
    682        fault SMALLINT NOT NULL,
    683        PRIMARY KEY(det_id, iteration, exp_id),
    684        KEY(fault),
    685        INDEX(det_id, iteration),
    686        FOREIGN KEY (det_id, iteration, exp_id) 
    687        REFERENCES  detInputExp(det_id, iteration, exp_id),
    688        FOREIGN KEY (det_id, iteration, exp_id) 
    689        REFERENCES  detResidImfile(det_id, iteration, exp_id)
    690 ) ENGINE=innodb DEFAULT CHARSET=latin1;
    691 
    692 CREATE TABLE detRunSummary (
    693        det_id BIGINT,
    694        iteration INT,
    695        data_state VARCHAR(64),
    696        bg DOUBLE,
    697        bg_stdev DOUBLE,
    698        bg_mean_stdev DOUBLE,
    699        accept TINYINT,
    700        fault SMALLINT NOT NULL,
    701        PRIMARY KEY(det_id, iteration),
    702        KEY(fault),
    703        FOREIGN KEY (det_id, iteration) 
    704          REFERENCES  detInputExp(det_id, iteration),
    705        FOREIGN KEY (det_id, iteration) 
    706          REFERENCES  detResidExp(det_id, iteration)
    707 ) ENGINE=innodb DEFAULT CHARSET=latin1;
    708 
    709 CREATE TABLE detRegisteredImfile (
    710        det_id BIGINT,
    711        iteration INT,
    712        class_id VARCHAR(64),
    713        uri VARCHAR(255),
    714        bg DOUBLE,
    715        bg_stdev DOUBLE,
    716        bg_mean_stdev DOUBLE,
    717        user_1 DOUBLE,
    718        user_2 DOUBLE,
    719        user_3 DOUBLE,
    720        user_4 DOUBLE,
    721        user_5 DOUBLE,
     658       det_id BIGINT,
     659       iteration INT,
     660       exp_id BIGINT,
     661       recipe VARCHAR(64),
     662       bg DOUBLE,
     663       bg_stdev DOUBLE,
     664       bg_mean_stdev DOUBLE,
     665       bg_skewness DOUBLE,
     666       bg_kurtosis DOUBLE,
     667       bin_stdev DOUBLE,
     668       fringe_0 DOUBLE,
     669       fringe_1 DOUBLE,
     670       fringe_2 DOUBLE,
     671       fringe_resid_0 DOUBLE,
     672       fringe_resid_1 DOUBLE,
     673       fringe_resid_2 DOUBLE,
     674       user_1 DOUBLE,
     675       user_2 DOUBLE,
     676       user_3 DOUBLE,
     677       user_4 DOUBLE,
     678       user_5 DOUBLE,
    722679       path_base VARCHAR(255),
    723680       data_state VARCHAR(64),
    724        fault SMALLINT NOT NULL,
    725        PRIMARY KEY(det_id, iteration, class_id),
    726        KEY(fault),
    727        FOREIGN KEY (det_id, iteration) 
     681       accept TINYINT,
     682       fault SMALLINT NOT NULL,
     683       PRIMARY KEY(det_id, iteration, exp_id),
     684       KEY(fault),
     685       INDEX(det_id, iteration),
     686       FOREIGN KEY (det_id, iteration, exp_id)
     687       REFERENCES  detInputExp(det_id, iteration, exp_id),
     688       FOREIGN KEY (det_id, iteration, exp_id)
     689       REFERENCES  detResidImfile(det_id, iteration, exp_id)
     690) ENGINE=innodb DEFAULT CHARSET=latin1;
     691
     692CREATE TABLE detRunSummary (
     693       det_id BIGINT,
     694       iteration INT,
     695       data_state VARCHAR(64),
     696       bg DOUBLE,
     697       bg_stdev DOUBLE,
     698       bg_mean_stdev DOUBLE,
     699       accept TINYINT,
     700       fault SMALLINT NOT NULL,
     701       PRIMARY KEY(det_id, iteration),
     702       KEY(fault),
     703       FOREIGN KEY (det_id, iteration)
     704         REFERENCES  detInputExp(det_id, iteration),
     705       FOREIGN KEY (det_id, iteration)
     706         REFERENCES  detResidExp(det_id, iteration)
     707) ENGINE=innodb DEFAULT CHARSET=latin1;
     708
     709CREATE TABLE detRegisteredImfile (
     710       det_id BIGINT,
     711       iteration INT,
     712       class_id VARCHAR(64),
     713       uri VARCHAR(255),
     714       bg DOUBLE,
     715       bg_stdev DOUBLE,
     716       bg_mean_stdev DOUBLE,
     717       user_1 DOUBLE,
     718       user_2 DOUBLE,
     719       user_3 DOUBLE,
     720       user_4 DOUBLE,
     721       user_5 DOUBLE,
     722       path_base VARCHAR(255),
     723       data_state VARCHAR(64),
     724       fault SMALLINT NOT NULL,
     725       PRIMARY KEY(det_id, iteration, class_id),
     726       KEY(fault),
     727       FOREIGN KEY (det_id, iteration)
    728728         REFERENCES  detRun(det_id, iteration)
    729729) ENGINE=innodb DEFAULT CHARSET=latin1;
    … …  
    828828        uri VARCHAR(255),
    829829        path_base VARCHAR(255),
    830         data_state VARCHAR(64),
     830        data_state VARCHAR(64),
    831831        bg DOUBLE,
    832832        bg_stdev DOUBLE,
    … …  
    882882        uri VARCHAR(255),
    883883        path_base VARCHAR(255),
    884         data_state VARCHAR(64),
     884        data_state VARCHAR(64),
    885885        bg DOUBLE,
    886886        bg_stdev DOUBLE,
    887887        stamps_num INT,
     888        stamps_mean FLOAT,
    888889        stamps_rms FLOAT,
    889890        sources INT,
    890891        dtime_diff FLOAT,
     892        dtime_match FLOAT,
     893        dtime_phot FLOAT,
    891894        hostname VARCHAR(64),
    892895        good_frac FLOAT,

  • trunk/ippTools/src/difftool.c

    r19582 r19639  
    477477    PXOPT_LOOKUP_F64(bg_stdev, config->args, "-bg_stdev", false, false);
    478478    PXOPT_LOOKUP_F32(dtime_diff, config->args, "-dtime_diff", false, false);
     479    PXOPT_LOOKUP_F32(dtime_match, config->args, "-dtime_match", false, false);
     480    PXOPT_LOOKUP_F32(dtime_phot, config->args, "-dtime_phot", false, false);
    479481    PXOPT_LOOKUP_S32(stamps_num, config->args, "-stamps_num", false, false);
     482    PXOPT_LOOKUP_S32(stamps_mean, config->args, "-stamps_mean", false, false);
    480483    PXOPT_LOOKUP_F32(stamps_rms, config->args, "-stamps_rms", false, false);
    481484    PXOPT_LOOKUP_S32(sources, config->args, "-sources", false, false);
    … …  
    496499                           bg_stdev,
    497500                           stamps_num,
     501                           stamps_mean,
    498502                           stamps_rms,
    499503                           sources,
    500504                           dtime_diff,
     505                           dtime_match,
     506                           dtime_phot,
    501507                           hostname,
    502508                           good_frac,

  • trunk/ippTools/src/difftoolConfig.c

    r19525 r19639  
    9696    psMetadataAddF64(adddiffskyfileArgs, PS_LIST_TAIL, "-bg_stdev",  0,            "define exposure background mean stdev", NAN);
    9797    psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-dtime_diff",  0,            "define elapsed processing time", NAN);
     98    psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-dtime_match", 0, "define match processing time", NAN);
     99    psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-dtime_phot", 0, "define photometry processing time", NAN);
    98100    psMetadataAddS32(adddiffskyfileArgs, PS_LIST_TAIL, "-stamps_num",  0,            "define subtraction stamp number", 0);
     101    psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-stamps_mean", 0, "define subtraction stamp mean", NAN);
    99102    psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-stamps_rms",  0,            "define subtraction stamp rms", NAN);
    100103    psMetadataAddS32(adddiffskyfileArgs, PS_LIST_TAIL, "-sources",  0,            "define number of sources", 0);
Note: See TracChangeset for help on using the changeset viewer.