2,956
edits
Code:food1.sql: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==Overview== | ==Overview== | ||
This is ''sqlite code'' to analyze the production of [[food]] crops and nutrition. Data is mostly from [https://fao.org FAO] and [https://usda.gov USDA]. | This is ''sqlite code'' to analyze the production of [[food]] crops and nutrition. | ||
Some key questions it can help to answer: | |||
* How much food could there be (globally per capita) if nothing was wasted and everything was plant-based? | |||
* Which countries produce a surplus? | |||
* Which crops get the best yields? | |||
* Which plant-based diets are the most optimal for feeding the world and preventing deforestation? | |||
Data is mostly from [https://fao.org FAO] and [https://usda.gov USDA]. | |||
Dependencies (data files as input) | Dependencies (data files as input) | ||
| Line 612: | Line 620: | ||
|} | |} | ||
==Why is ranking only based on protein and calories?== | ====Take some of these results with a grain of salt==== | ||
=====Monoculture vs polyculture===== | |||
Be careful not to interperet these results as "This one crop is the best, let's just grow that and nothing else!" It could be that some crops [[companion planting|depend on each other]] for their high yields. I recommend growing ''a mix of'' top crops, and especially include [[legumes]] for [[nitrogen fixing]]. | |||
=====Local variation===== | |||
It's possible that a country's top-yielding crops wouldn't be top-yielding in other parts of that country, if the soil or climate is different. | |||
=====Social, economic, and technological factors===== | |||
Maybe the top-yielding crop just has more resources invested into it - or the people who grow it are richer for historical reasons. In which case, maybe some currently-less-productive crops could be just as good if given a chance. | |||
===Why is ranking only based on protein and calories?=== | |||
It's true that humans need a lot more than just protein and calories. We also need vitamins, minerals, fiber, and omegas (3 and 6). But in a world where farm land is scarce {{x|which ''is'' today's world, in the sense that both hunger and deforestation are happening}} - protein and calories are of greatest concern. | It's true that humans need a lot more than just protein and calories. We also need vitamins, minerals, fiber, and omegas (3 and 6). But in a world where farm land is scarce {{x|which ''is'' today's world, in the sense that both hunger and deforestation are happening}} - protein and calories are of greatest concern. | ||
* Nearly every crop in its natural form contains ''some'' vitamins and minerals. | * Nearly every crop in its natural form contains ''some'' vitamins and minerals. | ||
| Line 619: | Line 635: | ||
* There is almost always an overabundance of fibre in crops. There are parts of plants we don't eat ''because'' they are so fiberous. | * There is almost always an overabundance of fibre in crops. There are parts of plants we don't eat ''because'' they are so fiberous. | ||
* Omegas 3 & 6 might be a genuine concern, and we should analyze this too. The next version of the [[nutrition calculator]] will track these. | * Omegas 3 & 6 might be a genuine concern, and we should analyze this too. The next version of the [[nutrition calculator]] will track these. | ||