2,956
edits
Code:food2.sql: Difference between revisions
no edit summary
(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...") |
No edit summary |
||
| Line 1: | Line 1: | ||
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|primary]]), ''food2'' is focused on animal products (livestock primary). | 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|primary]]), ''food2'' is focused on animal products (livestock primary). | ||
Dependencies: | |||
* [[Code:fao2usda.csv]] | |||
* [[:File:sr28-collated.csv]] | |||
* [[:File:PRIMARY-fao-livestock-primary.csv]] | |||