OpenLitterMap / OpenLitterMap/openlittermap-web
Errors in the downloaded file, number in 'total_litter' wrong in two different ways
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 134
- Forks
- 42
- PR merge metrics
- No merged PRs in 30d
Description
Download all the data of the Netherlands (can be found somewhere in the top-5 in the worldcup).
Open the excel and apply 'text to columns'.
The next issues are visible:
-
Number in 'total_litter' > real number of items in the different colums:
Go to item 109266. The column 'total_litter' says 2, but there in only a 1 in the column 'plasticFoodPackaging'. Where/What is the other item? -
Number in 'total_litter' < real number of items in the different colums:
Go to item 109304. The column 'total_litter' says 1, however, there is a 1 in the column of 'beer can' and there is a 1 in the column of 'Heineken'. So why is 'total_litter' not 2?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the Netherlands download, open the Excel file, and apply “text to columns” as described. Inspect items 109266 and 109304 and compare total_litter with their item columns; done means the exported total matches the reported item values in both cases.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- backend, data
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100