Changes between Version 18 and Version 19 of DVO_Conrad_Worksheet
- Timestamp:
- Jun 21, 2012, 4:13:52 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DVO_Conrad_Worksheet
v18 v19 98 98 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. 99 99 100 == Steps to trace inaccurate data from PSPS to IPP == 100 101 101 Step 0)Find the inaccurate data within PSPS.102 0. Find the inaccurate data within PSPS. 102 103 {{{ 103 104 SELECT objID, … … 115 116 }}} 116 117 117 Example result set: 118 '''Example result set:''' 118 119 119 120 ||'''objID''' ||'''stackDetectID''' ||'''ippObjID''' ||'''ippDetectID''' ||'''ra''' ||'''dec''' ||'''filterID''' ||'''instFlux''' ||'''calMag''' ||'''instFluxErr''' ||'''calMagErr'''|| … … 128 129 ||114493301431512878 ||1647540050000035033 ||18833000012411 ||3503 ||330.143162673458 ||5.41034250994028 ||3 ||0 ||22.3856067657471 ||0 ||0|| 129 130 ||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 {{{ 136 dvo: catdir /data/ipp005.0/gpc1/catdirs/sas/20120510 137 }}} 138
