IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 18 and Version 19 of DVO_Conrad_Worksheet


Ignore:
Timestamp:
Jun 21, 2012, 4:13:52 PM (14 years ago)
Author:
conradh
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DVO_Conrad_Worksheet

    v18 v19  
    9898   After doing some queries into PSPS, one particular query for data quality is to find instrumental flux values that are equal to zero.  This should not be possible but some small amount of entries were found.
    9999
     100== Steps to trace inaccurate data from PSPS to IPP ==
    100101
    101 Step 0) Find the inaccurate data within PSPS.
     102 0. Find the inaccurate data within PSPS.
    102103{{{
    103104SELECT objID,
     
    115116}}}
    116117
    117 Example result set:
     118'''Example result set:'''
    118119
    119120||'''objID''' ||'''stackDetectID''' ||'''ippObjID''' ||'''ippDetectID''' ||'''ra''' ||'''dec''' ||'''filterID''' ||'''instFlux''' ||'''calMag''' ||'''instFluxErr''' ||'''calMagErr'''||
     
    128129||114493301431512878 ||1647540050000035033 ||18833000012411 ||3503 ||330.143162673458 ||5.41034250994028 ||3 ||0 ||22.3856067657471 ||0 ||0||
    129130||114503301103546828 ||1647540050000038543 ||18833000017783 ||3854 ||330.110331520645 ||5.42194339501451 ||3 ||0 ||22.3856067657471 ||-999 ||0||
     131
     132 1. Find out the dvo path that the IPPTOPSPS is getting its data from. See [wiki:ippToPsps_Database#Theconfigtable IPPTOPSPS Config table].
     133
     134 2. Run dvo and set the catdir from the dvo prompt.
     135{{{
     136dvo: catdir /data/ipp005.0/gpc1/catdirs/sas/20120510
     137}}}
     138