Bug #950
Updated by Aaron Marcuse-Kubitza over 9 years ago
h3. test case eg. this happens for CVS rows: |datasource|country|state_province|county|latitude|longitude|is_geovalid| |CVS|United States|TENNESSEE|Sevier|35.654350967|-83.444906936|<NULL>| <pre><code class="SQL"> SET enable_seqscan = off; SET enable_mergejoin = off; SELECT * FROM view_full_occurrence_individual_view WHERE datasource = 'CVS' LIMIT 1; </code></pre> and FIA rows: |datasource|country|state_province|county|latitude|longitude|is_geovalid| |FIA|United States|Alabama|Covington|31.39|-86.36|<NULL>| |FIA|United States|Alabama|Escambia|31.17|-86.72|<NULL>| <pre><code class="SQL"> SET enable_seqscan = off; SET enable_mergejoin = off; SELECT DISTINCT ON (country, state_province, county) * FROM (SELECT * FROM view_full_occurrence_individual_view WHERE datasource = 'FIA' LIMIT 1000) s ; </code></pre> |CVS|United States|TENNESSEE|Sevier|35.654350967|-83.444906936|<NULL>| h3. info since is_geovalid is NULL, and state_province is falling back to the unscrubbed value, this indicates it is unable to find a @geoscrub.geoscrub_output@ row to join to