wrong total number of records published by country

15533
Reporter: feedback bot
Assignee: omeyn
Type: Bug
Summary: wrong total number of records published by country
Priority: Blocker
Resolution: Fixed
Status: Resolved
Created: 2014-04-15 15:53:34.754
Updated: 2014-06-11 14:20:52.183
Resolved: 2014-06-11 14:20:52.132
        
        
Description: On Country page, Data from Belgium shows: 63 occurrence datasets with 9 278 712 records.

But a search with publishing country= Belgium gives 6 110 634 results.
http://www.gbif.org/occurrence/search?PUBLISHING_COUNTRY=BE

Why is that different?
I trust the second number, please correct the first one.

]]>
    

Author: kbraak@gbif.org
Created: 2014-04-29 14:02:30.658
Updated: 2014-04-29 14:02:30.658
        
There is an inconsistency between the record numbers shown on the country pages, and the number retrieved via the occurrence search.

"Data from country" number should be equal to number retrieved via search on publishing country:

http://www.gbif.org/occurrence/search?PUBLISHING_COUNTRY=BE
6,189,396 results

However, "data from country" number is 16,974,438 on country page:
http://www.gbif.org/country/BE/publishing

Data about country number should be equal to number retrieved via search on country:

http://www.gbif.org/occurrence/search?COUNTRY=BE
5,631,232 results

In this case, the country page shows the exact same number:
http://www.gbif.org/country/BE/about
    

Author: mdoering@gbif.org
Created: 2014-04-29 14:19:57.457
Updated: 2014-04-29 14:19:57.457
        
The about mismatch is between the cube which gives 16.974.438 vs solr which yields 6,189,396
http://api.gbif.org/v0.9/occurrence/count?publishingCountry=BELGIUM
    

Author: mdoering@gbif.org
Created: 2014-04-29 14:23:55.231
Updated: 2014-04-29 14:23:55.231
        
For denmark it is also very different, but for Germany it is close (13.218.226 vs 13.139.479)
Live indexing failure? On uat it is also not corretc, though very close again:
http://api.gbif-uat.org/v0.9/occurrence/search?limit=1&publishingCountry=BE
http://api.gbif-uat.org/v0.9/occurrence/count?publishingCountry=BELGIUM