User contributions for Elie
29 August 2022
- 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..."
27 August 2022
- 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..."
26 August 2022
- 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
25 August 2022
- 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
24 August 2022
- 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?<br /> 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?<br /> 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