Task #816

Updated by Aaron Marcuse-Kubitza over 10 years ago

* this will fix the 300,000 no-opinion names[1] 1.3 million[1] names scrubbed during the 6 days that TNRS was broken[2], when it wasn't populating the critical field @Name_matched_accepted_family@ 

 fn1(((. +293816+ +1337539+ 
 <pre><code class="SQL"> 
 SELECT COUNT(*) FROM "TNRS".tnrs 
 WHERE 
     "Name_matched_accepted_family" IS NULL 
 AND "Family_matched" IS NOT NULL 
 AND "Accepted_name_family" IS NULL -- where we are using the matched name instead of the accepted name 
 AND "Name_matched_rank" != 'family' -- this is also the case for family-only matches 
 Total query runtime: 5718 5090 ms. 
 </code></pre> 

 fn2(((. 2013-5-23..28 
 <pre><code class="SQL"> 
 SELECT min(batch), max(batch) FROM "TNRS".tnrs 
 WHERE 
     "Name_matched_accepted_family" IS NULL 
 AND "Family_matched" IS NOT NULL 
 AND "Accepted_name_family" IS NULL -- where we are using the matched name instead of the accepted name 
 AND "Name_matched_rank" != 'family' -- this /*this is also the case for family-only matches matches*/ 
 Total query runtime: 3928 18606 ms. 
 "2013-05-23 15:48:28.970796-07","2013-05-28 08:36:52.569103-07" 
 </code></pre>

Back