HOME| DEEPENING


1. General Principle

Litterati's goal is to empower people to collect Litter Data & to empower people with access to that data so that anyone can help to create a litter-free world. Download custom data subsets from our Global Litter Database. The below tool can help you generate data reports of up to 50,000 pieces of litter.

2. Technical overview - Database version

Database Structure:

Waste database:
- Object ID (stored once)
- Material ID (stored once)
- BRAND ID (stored once)
- WASTE Photo (stored once)
- Observations of waste(updated regularly)
- Geographical Existence on the Map (updated in real-time)
- Taxonomy (stored once)
- Status (updated regularly)
Users database:
- Name (stored once)
- Email(stored once)
- City (stored once)
- Observation Date and Time (stored once)
- Place (stored once)
- Observation Added Date and Time (stored once)

Identifiers database:
- User ID (stored once)
- Rank (updated in real-time)

Action Types:

- a data is created: a user registers a waste on the platform (name of the waste brand and material, photo, location).
- a data is read : another user reads the data. For example, he consults the material sheet of the waste
- a data is updated: a user adds a new observation of a previously recorded waste. New data is created
- a data is deleted: An expert reject a false observation (for example : if the brand is not correct)

Query Types:

- Search: a user searches for a piece of waste in order to list it and then pick it up.

- Filter: there is no filter, all waste is good to take

-sort per :
*place
*the result-set in ascending or descending order.