User contributions for Elie

18:1818:18, 29 August 2022 diff hist +163‎ N Talk:Land/built-up ‎ Created page with "==To do== Compare results to official estimates. Generate an image from the tester code. ~~~~"
18:1618:16, 29 August 2022 diff hist +2,456‎ N Land/built-up ‎ Created page with " ==Using 'population' data to estimate built-up land== Some inner cities can be quite dense, but even the less-dense suburbs are still fully ''built-up'', as none of the land is truly ''wilderness'' {{x|even the parks and nature trails are heavily touched by humans}}, and none of it is considered farm land {{x|maybe this could change with suburban farming, but even then, maybe double-counting the same land (as ''both'' cropland ''and'' built-up land) is ok}}. Let's est..."

01:5101:51, 27 August 2022 diff hist +217‎ File talk:energy-usage-by-source.png ‎No edit summary Tag: Reverted
01:4501:45, 27 August 2022 diff hist +193‎ N User:Elie ‎ Created page with "Hi I'm Elie, the creator of this wiki. Right now, everything you see on this wiki is made by me - but I hope to make the wiki open & collaborative soon, after I finish building its foundations." current
01:4201:42, 27 August 2022 diff hist +14‎ Wiki for a better world:About ‎ →‎Editing
01:4001:40, 27 August 2022 diff hist +102‎ Wiki for a better world:About ‎ →‎Domain name
00:4100:41, 27 August 2022 diff hist +113‎ File:food-funnel.png ‎ →‎Notes
00:3500:35, 27 August 2022 diff hist +4,235‎ N Code:make-flow-diagram1.html ‎ Created page with "This javascript/HTML canvas generates the "flow diagram" of File:food-funnel.png. If you want to generate a different flow diagram, you can save your own version of this and modify the draw() function to your liking. <syntaxhighlight lang="html"> <html><head> <script> // This draw() is the main function: Change it according to how you want your diagram: function draw() { primary = 5454; // crops harvested leftStart(); go(5000); branch(491..." current
00:2100:21, 27 August 2022 diff hist 0‎ File:global-hunger-index-2021.xlsx ‎ Elie uploaded File:global-hunger-index-2021.xlsx current
00:2000:20, 27 August 2022 diff hist +363‎ N File:global-hunger-index-2021.xlsx ‎ Created page with "==Summary== Data table on the ''global hunger index'' of countries. Downloaded from [http://globalhungerindex.org globalhungerindex.org] * page: https://www.globalhungerindex.org/download/all.html * file: https://www.globalhungerindex.org/xlsx/2021.xlsx The table generally doesn't include "developed countries" where hunger "isn't considered a major problem"."
00:1800:18, 27 August 2022 diff hist 0‎ File:global-hunger-index-2021.csv ‎ Elie uploaded File:global-hunger-index-2021.csv current
00:1700:17, 27 August 2022 diff hist +1,614‎ N File:global-hunger-index-2021.csv ‎ Created page with "==Summary== Data on the ''global hunger index'' of countries. Converted from File:global-hunger-index-2021.xlsx. This CSV file can be opened in SQLite, unlike the original XLSX file. Like the original, this table generally doesn't include "developed countries" where hunger "isn't considered a major problem". ===Conversion process used=== Step 1: Copy-pasted the relevent cells into a new spreadsheet. Saved it as a .csv Step 2: Edited any country names that did..."

23:5823:58, 26 August 2022 diff hist 0‎ File:API SP.POP.TOTL DS2 en csv v2 4150863.csv ‎ Elie uploaded File:API SP.POP.TOTL DS2 en csv v2 4150863.csv current
23:5723:57, 26 August 2022 diff hist +122‎ N File:API SP.POP.TOTL DS2 en csv v2 4150863.csv ‎ Created page with "==Summary== Data: population of countries. Downloaded from [https://data.worldbank.org/indicator/SP.POP.TOTL World Bank]"
23:5123:51, 26 August 2022 diff hist +729‎ N File:fao-livestock-primary.csv ‎ Data on the primary production of animal products such as meat, milk, and eggs. Data downloaded from [https://www.fao.org/faostat/en/#data/QCL FAOSTAT] * Domain: "Crops and livestock products" (QCL) * Areas: "All countries" + "World (Total)" ** Exception: "China, mainland" is omitted to avoid double counting. The crops are already counted in "China". Also because, most other datasets can be joined on the string "China" but not "China, mainland". ** Using ISO3 area codes ** "... current
23:3623:36, 26 August 2022 diff hist 0‎ File:fao-crops-primary.csv ‎ Elie uploaded File:fao-crops-primary.csv current
23:3423:34, 26 August 2022 diff hist +689‎ N File:fao-crops-primary.csv ‎ Created page with "==Summary== Data on the primary production of food crops. Data downloaded from [https://www.fao.org/faostat/en/#data/QCL FAOSTAT] * Domain: "Crops and livestock products" (QCL) * Areas: "All countries" + "World (Total)" ** Exception: "China, mainland" is omitted to avoid double counting. The crops are already counted in "China". Also because, most other datasets can be joined on the string "China" but not "China, mainland". ** Using ISO3 area codes ** "..."
23:3123:31, 26 August 2022 diff hist +7,374‎ N Code:sr28-collate.c ‎ Created page with "This program converts USDA nutrition data into an easier table to run SQL queries on. * Input: File:sr28asc.zip (must be unzipped in a subfolder <code>data/sr28asc/</code>) * Output: File:sr28-collated.csv <syntaxhighlight lang="c"> // sr28-collate.c // This program converts USDA nutrition data into an easier table to run SQL queries on. // Input: sr28asc.zip (USDA Standard Reference [SR Legacy] ascii version 28) // Output: sr28-collated.csv // Instructions:..." current
23:2423:24, 26 August 2022 diff hist +19‎ File:sr28-collated.csv ‎No edit summary current
23:2323:23, 26 August 2022 diff hist 0‎ File:sr28-collated.csv ‎ Elie uploaded File:sr28-collated.csv
23:2123:21, 26 August 2022 diff hist +194‎ N File:sr28-collated.csv ‎ Created page with "[fdc.nal.usda.gov USDA Nutrition Data] - Standard Reference, version 28 - Collated into a pivot-like data table Generated from data tables in File:sr28asc.zip using Code:sr28-collate.c"
23:1623:16, 26 August 2022 diff hist 0‎ Code:fao2usda.csv ‎No edit summary current
23:1523:15, 26 August 2022 diff hist +5‎ Code:fao2usda.csv ‎No edit summary
15:5015:50, 26 August 2022 diff hist 0‎ m File:PRIMARY-Blue Marble 2002.png ‎ Elie moved page File:pRIMARY-Blue Marble 2002.png to File:PRIMARY-Blue Marble 2002.png over a redirect without leaving a redirect current
15:0615:06, 26 August 2022 diff hist −16‎ File:food-crop-production1.png ‎ →‎Methodology
15:0415:04, 26 August 2022 diff hist +204‎ File:food-crop-production1.png ‎ →‎Methodology
15:0315:03, 26 August 2022 diff hist +204‎ File:food-crop-production1-if-crop-choices.png ‎ →‎Methodology
14:5314:53, 26 August 2022 diff hist +7‎ File:blue-marble-posterized.png ‎ →‎Summary
14:4614:46, 26 August 2022 diff hist 0‎ m File:country-and-continent-codes-list-csv csv.csv ‎ Elie moved page File:PRIMARY-Country-and-continent-codes-list-csv csv.csv to File:Country-and-continent-codes-list-csv csv.csv without leaving a redirect
14:4014:40, 26 August 2022 diff hist −6‎ Code:fao2usda.csv ‎No edit summary
14:3614:36, 26 August 2022 diff hist −32‎ Code:food2.sql ‎No edit summary
14:3514:35, 26 August 2022 diff hist +235‎ N Talk:Code:food1.sql ‎ Created page with "==Managing outputs== Maybe move the "URLs generated" (nutrition calculator) to a subpage? And also make subpages to showcase other results of various SQL queries? ~~~~" current
14:3314:33, 26 August 2022 diff hist −30‎ Code:food1.sql ‎No edit summary
14:3014:30, 26 August 2022 diff hist −418‎ Analysis ‎No edit summary current
14:2614:26, 26 August 2022 diff hist −31‎ Code:fao usda.csv ‎No edit summary current

10:4810:48, 25 August 2022 diff hist +4,269‎ N Code:fao2usda.csv ‎ Created page with "This is part 2 of the fao_usda.csv cross-reference table. This one deals with animal products instead of plant products. ==Code== <syntaxhighlight lang="csv"> "Item Code (FAO)","NDB_No","Multiplier" 1062,01123,1 1091,01138,1 1182,19296,1 1166,80200,1 1108,17152,1 1089,05144,1 947,17160,1 1127,17172,1 867,13047,1 1058,05001,1 1069,05139,1 1163,17330,1 1017,17168,1 1073,05146,1 1097,17170,1 1111,17144,1 1158,17158,1 1151,17..."
10:3610:36, 25 August 2022 diff hist +15,148‎ N Code:fao usda.csv ‎ Created page with "fao_usda.csv is a cross-reference table, to connect data from two sources: # FAO Primary Crop Production # USDA Nutrition Data, SR Legacy Purpose: to help analyze crop production in terms of calories, protein, etc. FAO data specifies crop production in tonnes, but for some crops, this includes some inedible parts. For example a ton of bananas includes the peels; a ton of apples includes the co..."
10:2910:29, 25 August 2022 diff hist +70,968‎ Code:food1.sql ‎No edit summary
09:5709:57, 25 August 2022 diff hist +847‎ N Analysis ‎ Created page with "Unlike Wikipedia, ''this'' wiki is full of ''original research''. We aim to make analysis as open, transparent, and repeatable as possible. You can help analyze data - here's our standard way to set up a folder on your computer: * Any files from the <code>Code:</code> namespace should be saved in the root of the folder. * Any files from the <code>File:</code> namespace should be saved in a subfolder called <code>data/</code>. ** Files that are Term:primary data from..."
09:5509:55, 25 August 2022 diff hist +115‎ Code:food2.sql ‎No edit summary
09:2509:25, 25 August 2022 diff hist +2,152‎ N Code:food2.sql ‎ Created page with "Like Code:food1.sql, this analyzes food production data from FAO, and nutrition data from USDA. But while ''food1'' is focused on plants (crops Term:primary), ''food2'' is focused on animal products (livestock primary). <syntaxhighlight lang="sql"> -- Analysis of the production of animal products -- Load data from various sources .mode csv -- cross-reference table 2: livestock products (FAO data) with foods (USDA nutrition data): .import fao2usda.csv..."
08:2308:23, 25 August 2022 diff hist +4,399‎ File:food-funnel.png ‎No edit summary

18:4218:42, 24 August 2022 diff hist +646‎ N Land ‎ Created page with "Land usage is a major environmental impact due to habitat loss. Agriculture uses vastly more land than all other human activity combined. Earth Surface * Oceans (% of Earth Surface) * Land (% of Earth Surface) ** Pasture: km^2 (% of Land) ** Cropland: km^2 (% of Land) ** Built-up land: km^2 (% of Land) *** "Built-up" includes all housing (cities, suburbs, towns, etc), buildings, roads, infrastructure and more. <tabs> <tab name="Pasture">File:land-pastu..."
18:1718:17, 24 August 2022 diff hist −447‎ Food ‎ →‎Q&A
18:1718:17, 24 August 2022 diff hist +210‎ N Rewilding ‎ Created page with "==Q&A== ===Unanswered=== How much carbon does every km^2 of newly-grown forest sequester per year? How much carbon does every km^2 of newly-grown grasslands sequester per year?" current
18:1718:17, 24 August 2022 diff hist +412‎ N Habitat loss ‎ Created page with "Habitat loss refers to the destruction of any natural wild ecosystems, such as forest. This causes extinctions and carbon emissions. Most habitat loss is caused by agriculture. {{qn}} This page is incomplete. ===Unanswered questions=== How much CO2 is released for every km^2 of deforestation? How much CO2 is released for every km^2 of destroyed grasslands?"
18:1018:10, 24 August 2022 diff hist +13‎ Food ‎ →‎Problems
18:0218:02, 24 August 2022 diff hist 0‎ File:food-funnel.png ‎ Elie uploaded a new version of File:Food-funnel.png
17:5617:56, 24 August 2022 diff hist 0‎ N File:food-funnel.png ‎No edit summary
17:5517:55, 24 August 2022 diff hist 0‎ m File:food-funnel-old.png ‎ Elie moved page File:Food-funnel.png to File:Food-funnel-old.png without leaving a redirect
17:4617:46, 24 August 2022 diff hist +214‎ Food ‎ →‎Solutions
17:2317:23, 24 August 2022 diff hist +216‎ Food ‎ →‎Problems
16:5416:54, 24 August 2022 diff hist +248‎ Food ‎ →‎Problems
15:3015:30, 24 August 2022 diff hist +267‎ Term:kalories ‎ →‎Why spell kalories with a k?
15:1415:14, 24 August 2022 diff hist −116‎ Term:kalories ‎ →‎Why spell kalories with a k?

22:4222:42, 15 August 2022 diff hist +483‎ Limits to sustainable animal consumption ‎No edit summary
21:4421:44, 15 August 2022 diff hist +971‎ N Limits to sustainable animal consumption ‎ Created page with "Vegans rightly point out that meat-containing diets require more land (and thus more deforestation) since feeding animals is a net loss of protein and calories. But... Pro-meat folks rightly point out that some land is only suited for grazing animals. This raises a more important question: :If farm animals only ever ate... :* grasses and other plants from pasture & range, and :* the parts of food crops that humans ''can't''..."

15:1515:15, 14 August 2022 diff hist +27‎ N Term:kalorie ‎ Redirected page to Term:kalories current Tag: New redirect
15:1415:14, 14 August 2022 diff hist +763‎ N Term:kalories ‎ Created page with "===Why spell kalories with a k?=== A kalorie is a food calorie. The 'k' is to prevent confusion with an older historical unit "calorie", which is 1000 times smaller. When someone says "An apple has 95 calories", technically the "proper" wording would be "An apple has 95 kilocalories". But that could easily confuse people more, as "95 kilocalories" sounds like enough food for a hundred meals! So a better solution is to say "An apple has 95 kalories" - the "kilo" is impli..."
15:1115:11, 14 August 2022 diff hist +929‎ N Term:primary ‎ Created page with "The word ''primary'' is used in very specific ways on this wiki. ===Food=== "Primary food production" is amount of food that is harvested from farms. Not all of this gets eaten. ===Energy=== "Primary energy production" - also known as "total energy supply" (TES) is the amount of energy produced ''before'' any transformations. This is in contrast with "total final consumption" (TFC) which is ''after'' transformations. For example, when natural..."
13:2213:22, 14 August 2022 diff hist +123‎ Crop choices ‎ →‎FAQ
13:0713:07, 14 August 2022 diff hist 0‎ File:food-crop-production1-if-crop-choices.png ‎ Elie uploaded a new version of File:Food-crop-production1-if-crop-choices.png
13:0613:06, 14 August 2022 diff hist 0‎ File:food-crop-production1.png ‎ Elie uploaded a new version of File:Food-crop-production1.png

21:1021:10, 13 August 2022 diff hist +982‎ Crop choices ‎ →‎FAQ
20:5720:57, 13 August 2022 diff hist +55‎ Crop choices ‎ →‎The scenario
19:5719:57, 13 August 2022 diff hist +233‎ Crop choices ‎No edit summary
19:5419:54, 13 August 2022 diff hist +422,232‎ N Crop choices/chart ‎ Created page with "===Average crop yields for each crop, by region=== The best-yielding crops are on the '''left''' (after ''status-quo'') and the worst are on the right. Ranking is based on calories & protein (see why). More specifically, 2000 Term:kalories is given the same ''value'' as 60 grams of protein. This table is generated by Code:food1.sql which uses data from [https://fao.org FAO] (on food crop production) and [https://usda.gov USDA] (..."
19:1219:12, 13 August 2022 diff hist −311,420‎ Crop choices ‎No edit summary
12:2812:28, 13 August 2022 diff hist +6,051‎ Code:food1.sql ‎No edit summary
12:2712:27, 13 August 2022 diff hist +2,241‎ File:food-crop-production1-if-crop-choices.png ‎ →‎Summary
12:2412:24, 13 August 2022 diff hist +178‎ N File:food-crop-production1-if-crop-choices.png ‎ Food crop production - what it would be if mainly high-yielding crops were chosen. (Isochromic world map) (Projection: equirectangular/geographic)
12:2012:20, 13 August 2022 diff hist +2,095‎ File:food-crop-production1.png ‎ →‎Summary
12:1812:18, 13 August 2022 diff hist +130‎ N File:food-crop-production1.png ‎ Production of food crops, superimposed on population. Isochromic world map (projection: equirectangular/geographic)

02:1802:18, 9 August 2022 diff hist −54‎ Responses ‎ →‎Energy-related current
02:0202:02, 9 August 2022 diff hist +160‎ Ammonia ‎No edit summary current
01:5101:51, 9 August 2022 diff hist +3,705‎ N Responses ‎ Created page with "==Energy-related== ===Response to=== Du, HL., Chatti, M., Hodgetts, R.Y. et al. Electroreduction of nitrogen at almost 100% current-to-ammonia efficiency. Nature (2022). https://doi.org/10.1038/s41586-022-05108-y https://www.nature.com/articles/s41586-022-05108-y This could be a breakthrough for fertilizer. Electricity could convert nitrogen gas (N2) to ammonia (NH3) at nearly 100% efficiency - unlike any previous attempts. Lithium is..."
01:0201:02, 9 August 2022 diff hist +762‎ N Ammonia ‎ Created page with "Ammonia (NH3) is a form of nitrogen. The vast majority of ammonia is used for fertilizer. Ammonia production requires energy. Currently this is mainly done with fossil fuels. But suppose we find another (greener) scaleable way to produce it... Then could it also be used as the "fuel of the future"? Because apparently it's easier to work with (storage, transport, etc) than hydrogen gas. Questions unanswered: What about the..."

14:1414:14, 7 August 2022 diff hist 0‎ File:blue-marble-posterized.png ‎ →‎Summary
14:1414:14, 7 August 2022 diff hist 0‎ File:blue-marble-posterized.png ‎ →‎Summary
14:1314:13, 7 August 2022 diff hist 0‎ m File:country-and-continent-codes-list-csv csv.csv ‎ Elie moved page File:Primary-Country-and-continent-codes-list-csv csv.csv to File:PRIMARY-Country-and-continent-codes-list-csv csv.csv without leaving a redirect
14:1214:12, 7 August 2022 diff hist 0‎ m File:PRIMARY-Blue Marble 2002.png ‎ Elie moved page File:Primary-Blue Marble 2002.png to File:PRIMARY-Blue Marble 2002.png without leaving a redirect
14:1014:10, 7 August 2022 diff hist +171‎ Code:borders-black-on-white.c ‎No edit summary current
14:0214:02, 7 August 2022 diff hist +181‎ N File:country-and-continent-codes-list-csv csv.csv ‎ Table of countries and their Country Codes (ISO3, M49, etc) and the continents they are on. Source: [https://datahub.io/JohnSnowLabs/country-and-continent-codes-list]
04:1104:11, 7 August 2022 diff hist +1,413‎ N Code:borders-black-on-white.c ‎ Created page with "<syntaxhighlight lang="c"> #define WIDTH 8640 #define HEIGHT 4320 #define IN_FILE "data/countries.data-int16-8640x4320" #define OUT_FILE "data/borders-black-on-white.png" #include <stdio.h> #define STB_IMAGE_WRITE_IMPLEMENTATION #include "stb_image_write.h" int main() { short *in = malloc(WIDTH*HEIGHT*sizeof(short)); unsigned char *out = malloc(WIDTH*HEIGHT*sizeof(unsigned char)); if (!in || !out) { printf("Not enough memory\n"); free(in); free(out);..."
04:0804:08, 7 August 2022 diff hist +56‎ File:borders-black-on-white.png ‎ →‎Summary
04:0604:06, 7 August 2022 diff hist +246‎ N File:borders-black-on-white.png ‎ World map: Outlines of countries, black on white Projection: equirectangular (geographic) This image was generated by Code:borders-black-on-white.c which uses File:countries.data-int16-8640x4320 (data from NASA) as input.
03:5903:59, 7 August 2022 diff hist +42‎ File:PRIMARY-Blue Marble 2002.png ‎ →‎Summary
03:5803:58, 7 August 2022 diff hist +46‎ File:blue-marble-posterized.png ‎ →‎Summary
03:5503:55, 7 August 2022 diff hist +877‎ File:population-earth1.png ‎ →‎Summary
03:5203:52, 7 August 2022 diff hist +409‎ N File:population-earth1.png ‎ An Term:isochromic map of the world population, superimposed on a pastel-color background that shows land, water, and borders. Everything in black is population. Note: Some border lines may be completely obscured by populations (especially India's borders with Bangladesh, Pakistan, and Bhutan). Still better than the opposite (letting the border lines obscure the populations).
03:4503:45, 7 August 2022 diff hist −8‎ File:solar-land-requirements.png ‎ →‎Would your city need solar farms?
03:4203:42, 7 August 2022 diff hist +1‎ File:blue-marble-posterized.png ‎ →‎Summary
03:3503:35, 7 August 2022 diff hist +149‎ N File:PRIMARY-Blue Marble 2002.png ‎ NASA's original Blue Marble Map of the Earth from satellite imagery Source: https://visibleearth.nasa.gov/collection/1484/blue-marble
03:3103:31, 7 August 2022 diff hist +77‎ File:blue-marble-posterized.png ‎ →‎Summary
03:2803:28, 7 August 2022 diff hist 0‎ File:blue-marble-posterized.png ‎ Elie uploaded File:Blue-marble-posterized.png
03:2603:26, 7 August 2022 diff hist +522‎ N File:blue-marble-posterized.png ‎ Created page with "== Summary == Simplified version of NASA's Blue Marble. Yellow areas are generally deserts or harsh mountainous regions. Suggested usage: for superimposing other data in black and/or white. How it was made * Opened the File:primary/Blue_Marble_2002.jpg in mtPaint (image editor) * Applied gamma=150% to blue and green channels (but not red channel) * Applied maximum color saturation, repeatedly * Posterized the image, on the most extreme setting * Replaced red spots..."
03:1903:19, 7 August 2022 diff hist −4‎ File:solar-land-requirements.png ‎ →‎Methodology
03:1803:18, 7 August 2022 diff hist 0‎ File:solar-land-requirements.png ‎No edit summary
03:1403:14, 7 August 2022 diff hist +102‎ File:solar-land-requirements.png ‎No edit summary
02:5902:59, 7 August 2022 diff hist +5,478‎ N File:solar-land-requirements.png ‎ World map: If all energy came from solar panels, how much land would we need? The land is shown in white. We would need approximately 0.8% of Earth's surface. Just for comparison, crop land is about 2.9% of Earth's surface, and pasture land is about 5.4% of Earth's surface. ==Methodology== Land required for solar panels, if * all energy came from solar photovoltaics, and * everyone on Earth lived a "first-world" lifestyle. Map projection: equirectangular Not counted in...

29 August 2022

27 August 2022

26 August 2022

25 August 2022

24 August 2022

15 August 2022

14 August 2022

13 August 2022

9 August 2022

7 August 2022