planet_fixers [prototype]Issues page
planet_fixers [prototype]Here are the issues that are currently in the planet fixers knowledge base
Connected to MySQL....SELECT issues.issue, issues.description, resource.name, junc_issues_resources.percentage_effect from issues join junc_issues_resources on issues.id = junc_issues_resources.issue_id join resource on junc_issues_resources.resource_id = resource.id;
| Issue | Description | Connected resource | % of resource affected |
|---|---|---|---|
| ocean dead zones | Areas starved of oxygen in open ocean | Ocean | 0 |
| global warming | increasing average global temperatures | Atmosphere | 0 |
| plastic in food chain | Plastics and microplastics are now causing significant harm to living organisms and entering the food chain | Ocean | 0 |
| deforestation | forest is being cut down faster than it is being replanted | Atmosphere | 69 |
| plastic in food chain | Plastics and microplastics are now causing significant harm to living organisms and entering the food chain | Atmosphere | 69 |
| plastic in food chain | Plastics and microplastics are now causing significant harm to living organisms and entering the food chain | Rain (fresh water) | 69 |
| plastic in food chain | Plastics and microplastics are now causing significant harm to living organisms and entering the food chain | Land (habitable) | 69 |
| plastic in food chain | Plastics and microplastics are now causing significant harm to living organisms and entering the food chain | Atmosphere | 69 |
| mega-city pollution | air quality in mant mega-cities is poor | Ocean | 0 |
| Shreyas is too pog | Shreyas is far too pog for his own good. We must de-poggify him. | Rain (fresh water) | 0 |
| Hacked | This blog been hacked, is an issue | Atmosphere | 1 |
| Issue | Description | Connect resource |
|---|