FAOSTAT Land Use - Revision history

Norah.Shamin: /* Series pulled from the FAOSTAT, Land Use */

2025-08-15T16:39:38Z

Series pulled from the FAOSTAT, Land Use

← Older revision		Revision as of 16:39, 15 August 2025
Line 4:		Line 4:
	The most recent update was in August. 2025. IFs have 10 series in total.		The most recent update was in August. 2025. IFs have 10 series in total.

	= ~~Series pulled from the FAOSTAT, Land Use~~ =		= Tables In IFs =
	{\| class="wikitable"		{\| class="wikitable"
	\|Variable		\|Variable
Line 96:		Line 96:
	5110 is the element code and the number after it is the item code. Remember to filter both.		5110 is the element code and the number after it is the item code. Remember to filter both.

	= Instructions ~~for pulling FAOSTAT, Land Use series~~ =		= Data Pulling Instructions =
	# The data can be accessed on the [https://www.fao.org/faostat/en/#data/RL FAOSTAT, Land Use] website.		# The data can be accessed on the [https://www.fao.org/faostat/en/#data/RL FAOSTAT, Land Use] website.
	# The importing python scripts can be accessed [https://github.com/shangkexin/FAO_Land here].		# The importing python scripts can be accessed [https://github.com/shangkexin/FAO_Land here].

Norah.Shamin: /* Notes for Kosovo and Serbia: */

2025-08-14T20:16:22Z

Notes for Kosovo and Serbia:

← Older revision		Revision as of 20:16, 14 August 2025
Line 131:		Line 131:
	Use Ethiopia PDR and Ethiopia for Ethiopia's data. The two entities have roughly the same geographical coverage.		Use Ethiopia PDR and Ethiopia for Ethiopia's data. The two entities have roughly the same geographical coverage.

	====== Notes for Kosovo and Serbia: ======		====== Notes for Kosovo and Serbia ======
	#There is no value for Kosovo from FAOSTAT, Land Use. Thus, we use the resource from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook].		#There is no value for Kosovo from FAOSTAT, Land Use. Thus, we use the resource from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook].
	#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.		#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.

Norah.Shamin at 20:16, 14 August 2025

2025-08-14T20:16:07Z

← Older revision		Revision as of 20:16, 14 August 2025
Line 2:		Line 2:
	The [https://www.fao.org/faostat/en/#data/RL FAOSTAT Land Use domain] contains data on forty-four categories of land use, irrigation and agricultural practices and five indicators relevant to monitor agriculture, forestry and fisheries activities at national, regional and global level. Data are available by country and year, with global coverage and annual updates.		The [https://www.fao.org/faostat/en/#data/RL FAOSTAT Land Use domain] contains data on forty-four categories of land use, irrigation and agricultural practices and five indicators relevant to monitor agriculture, forestry and fisheries activities at national, regional and global level. Data are available by country and year, with global coverage and annual updates.

	The most recent update was in ~~June~~. 2025. IFs have 10 series in total.		The most recent update was in August. 2025. IFs have 10 series in total.

	= Series pulled from the FAOSTAT, Land Use =		= Series pulled from the FAOSTAT, Land Use =
Line 105:		Line 105:

	= Notes =		= Notes =
	~~'''''Notes for LandTotal and LandArea:'''''~~

			====== Disaggregation ======
			We need to disaggregate the following for previous years data

			# Czechoslovakia = Slovakia and Czech Republic
			# Yugoslav SFR = Slovenia, Croatia, Bosnia and Herzegovina, North Macedonia, Serbia, and Montenegro
			# Serbia and Montenegro = Serbia and Montenegro
			# Sudan (former) = Sudan and South Sudan
			# USSR = Armenia, Azerbaijan, Belarus, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Russia, Tajikistan, Turkmenistan, Ukraine, and Uzbekistan

			For disaggregation you are adding up the values for the year after the state disbanded, using the data when the state existed, have the values for the new states after the entity disbanded, and then extrapolate (find the percentage of each state in the data from the OG state and then multiply it to get the right amount) data for the new states in the previous years.

			# USSR add up the values for 1992; have totals for 1961-1991; have the values for 15 states for 1992; extrapolate data for 15 states 1961-1991
			# Czechoslovakia add up the values for for 1993; have totals for 1961-1992; have the values for 2 states for 1993; extrapolate data for 2 states 1961-1992
			# Sudan (former) add up the values for 2012; have totals for 1961-2011; have the values for 2 states for 2012; extrapolate data for 2 states 1961-2011
			# Yugoslav SFR add up the values for 1992; have totals for 1961-1991; have the values for 6 states for 1992; extrapolate for 6 states 1961-1991
			# Serbia and Montenegro add up the values for 2006; have totals for 1992-2005; have the values for 2 states for 2006; extrapolate data for 2 states 1992-2005

			A script to do this disaggregation (as well as pulling and cleaning the data for importing) can be found [https://github.com/n1shamin/FAO-Land-Use here].

			====== Notes for LandTotal and LandArea: ======
	There is no null values in IFsHistSeries. Thus, the null values from original data need to be back filled by the earliest year's value.		There is no null values in IFsHistSeries. Thus, the null values from original data need to be back filled by the earliest year's value.

	'~~''''Special notes~~ for Kosovo and Serbia:~~'''''~~		====== Notes for Ethiopia ======
	#There is no value for Kosovo from FAOSTAT, Land Use. Thus, we use the resource from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook].		Use Ethiopia PDR and Ethiopia for Ethiopia's data. The two entities have roughly the same geographical coverage.

			====== Notes for Kosovo and Serbia: ======
			#There is no value for Kosovo from FAOSTAT, Land Use. Thus, we use the resource from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook].
	#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.		#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.
	#The value for Kosovo in series LandAgri, LandGrazing, LandOther, LandCrop, and LandForest. We will use the information from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook] to calculate.[[File:Screenshot 2024-08-20 113943.png\|none\|thumb]]		#The value for Kosovo in series LandAgri, LandGrazing, LandOther, LandCrop, and LandForest. We will use the information from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook] to calculate.[[File:Screenshot 2024-08-20 113943.png\|none\|thumb]]
	##To calculate take the 1.0087, multiply it by the variable (i.e. agricultural land). But for LandAgri multiply that value by 1000		##To calculate take the 1.0087, multiply it by the variable (i.e. agricultural land). But for LandAgri multiply that value by 1000.
	###Agricultural Land: LandAgri		###Agricultural Land: LandAgri
	###Permanent Crops and Arable Land: LandCrop		###Permanent Crops and Arable Land: LandCrop

Norah.Shamin: /* Notes */

2025-08-14T18:25:22Z

Notes

← Older revision		Revision as of 18:25, 14 August 2025
Line 113:		Line 113:
	#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.		#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.
	#The value for Kosovo in series LandAgri, LandGrazing, LandOther, LandCrop, and LandForest. We will use the information from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook] to calculate.[[File:Screenshot 2024-08-20 113943.png\|none\|thumb]]		#The value for Kosovo in series LandAgri, LandGrazing, LandOther, LandCrop, and LandForest. We will use the information from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook] to calculate.[[File:Screenshot 2024-08-20 113943.png\|none\|thumb]]
	##To calculate take the 1.0087, multiply it by the variable (i.e. agricultural land)~~, and~~ multiply that value by 1000.		##To calculate take the 1.0087, multiply it by the variable (i.e. agricultural land). But for LandAgri multiply that value by 1000
	###Agricultural Land: LandAgri		###Agricultural Land: LandAgri
	###Permanent Crops: LandCrop		###Permanent Crops and Arable Land: LandCrop
	###Permanent Pasture: LandGrazing		###Permanent Pasture: LandGrazing
	###Forest: LandForest		###Forest: LandForest
	###Other: LandOther		###Other: LandOther
	#Kosovo became independent from Serbia in 2008. Thus, the values for Serbia need to be deducted from the value for Kosovo since 2008 for each series.		#Kosovo became independent from Serbia in 2008. Thus, the values for Serbia need to be deducted from the value for Kosovo since 2008 for each series.

Norah.Shamin at 17:18, 1 July 2025

2025-07-01T17:18:51Z

← Older revision		Revision as of 17:18, 1 July 2025
Line 4:		Line 4:
	The most recent update was in June. 2025. IFs have 10 series in total.		The most recent update was in June. 2025. IFs have 10 series in total.

	== Series pulled from the FAOSTAT, Land Use ==		= Series pulled from the FAOSTAT, Land Use =
	{\| class="wikitable"		{\| class="wikitable"
	\|Variable		\|Variable
Line 96:		Line 96:
	5110 is the element code and the number after it is the item code. Remember to filter both.		5110 is the element code and the number after it is the item code. Remember to filter both.

	== Instructions for pulling FAOSTAT, Land Use series ==		= Instructions for pulling FAOSTAT, Land Use series =
			# The data can be accessed on the [https://www.fao.org/faostat/en/#data/RL FAOSTAT, Land Use] website.
	# The data can be accessed on the [https://www.fao.org/faostat/en/#data/RL FAOSTAT, Land Use] website.
	# The importing python scripts can be accessed [https://github.com/shangkexin/FAO_Land here].		# The importing python scripts can be accessed [https://github.com/shangkexin/FAO_Land here].
	# To download the all the data at once, you may click the "All Data Normalized" under "Bulk Downloads" on the FAOSTAT, Land Use website.		# To download the all the data at once, you may click the "All Data Normalized" under "Bulk Downloads" on the FAOSTAT, Land Use website.
			# Filter using the element and item code.

	[[File:Screenshot 2024-08-20 112504.png\|none\|thumb\|458x458px]]		[[File:Screenshot 2024-08-20 112504.png\|none\|thumb\|458x458px]]

Norah.Shamin at 19:38, 16 June 2025

2025-06-16T19:38:50Z

← Older revision		Revision as of 19:38, 16 June 2025
Line 1:		Line 1:
			= Summary =
	The [https://www.fao.org/faostat/en/#data/RL FAOSTAT Land Use domain] contains data on forty-four categories of land use, irrigation and agricultural practices and five indicators relevant to monitor agriculture, forestry and fisheries activities at national, regional and global level. Data are available by country and year, with global coverage and annual updates.		The [https://www.fao.org/faostat/en/#data/RL FAOSTAT Land Use domain] contains data on forty-four categories of land use, irrigation and agricultural practices and five indicators relevant to monitor agriculture, forestry and fisheries activities at national, regional and global level. Data are available by country and year, with global coverage and annual updates.

	The most recent update was in ~~Aug~~. ~~2024~~. IFs have 10 series in total.		The most recent update was in June. 2025. IFs have 10 series in total.

	== Series pulled from the FAOSTAT, Land Use ==		== Series pulled from the FAOSTAT, Land Use ==
Line 93:		Line 94:
	\|		\|
	\|}		\|}
			5110 is the element code and the number after it is the item code. Remember to filter both.

	== Instructions for pulling FAOSTAT, Land Use series ==		== Instructions for pulling FAOSTAT, Land Use series ==
Line 100:		Line 102:
	# To download the all the data at once, you may click the "All Data Normalized" under "Bulk Downloads" on the FAOSTAT, Land Use website.		# To download the all the data at once, you may click the "All Data Normalized" under "Bulk Downloads" on the FAOSTAT, Land Use website.

	[[File:Screenshot 2024-08-20 112504.png\|none\|thumb\|458x458px]]'''''Notes for LandTotal and LandArea:'''''		[[File:Screenshot 2024-08-20 112504.png\|none\|thumb\|458x458px]]

			= Notes =
			'''''Notes for LandTotal and LandArea:'''''

	There is no null values in IFsHistSeries. Thus, the null values from original data need to be back filled by the earliest year's value.		There is no null values in IFsHistSeries. Thus, the null values from original data need to be back filled by the earliest year's value.
Line 108:		Line 113:
	#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.		#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.
	#The value for Kosovo in series LandAgri, LandGrazing, LandOther, LandCrop, and LandForest. We will use the information from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook] to calculate.[[File:Screenshot 2024-08-20 113943.png\|none\|thumb]]		#The value for Kosovo in series LandAgri, LandGrazing, LandOther, LandCrop, and LandForest. We will use the information from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook] to calculate.[[File:Screenshot 2024-08-20 113943.png\|none\|thumb]]
			##To calculate take the 1.0087, multiply it by the variable (i.e. agricultural land), and multiply that value by 1000.
			###Agricultural Land: LandAgri
			###Permanent Crops: LandCrop
			###Permanent Pasture: LandGrazing
			###Forest: LandForest
			###Other: LandOther
	#Kosovo became independent from Serbia in 2008. Thus, the values for Serbia need to be deducted from the value for Kosovo since 2008 for each series.		#Kosovo became independent from Serbia in 2008. Thus, the values for Serbia need to be deducted from the value for Kosovo since 2008 for each series.

Yutang.Xiong: Yutang.Xiong moved page FAOSTAT Land, Inputs and Sustainability to FAOSTAT Land Use without leaving a redirect: new name

2025-02-12T21:37:40Z

Yutang.Xiong moved page FAOSTAT Land, Inputs and Sustainability to FAOSTAT Land Use without leaving a redirect: new name

← Older revision	Revision as of 21:37, 12 February 2025
(No difference)

Yutang.Xiong: Yutang.Xiong moved page FAO Land to FAOSTAT Land, Inputs and Sustainability without leaving a redirect: new name

2025-02-12T21:35:28Z

Yutang.Xiong moved page FAO Land to FAOSTAT Land, Inputs and Sustainability without leaving a redirect: new name

← Older revision	Revision as of 21:35, 12 February 2025
(No difference)

Kexin.Shang: /* Series pulled from the FAOSTAT, Land Use */

2024-09-05T20:09:23Z

Series pulled from the FAOSTAT, Land Use

← Older revision		Revision as of 20:09, 5 September 2024
Line 80:		Line 80:
	\|Land use, other land (% of total area)		\|Land use, other land (% of total area)
	\|Percent		\|Percent
	\|		\|''LandOther/LandTotal''
	\|0		\|0
	\|		\|
Line 88:		Line 88:
	\|Land use, permanent pasture (% of total area)		\|Land use, permanent pasture (% of total area)
	\|Percent		\|Percent
	\|		\|''LandGrazing/LandTotal''
	\|0		\|0
	\|		\|

Kexin.Shang: /* Instructions for pulling FAOSTAT, Land Use series */

2024-09-05T20:07:55Z

Instructions for pulling FAOSTAT, Land Use series

← Older revision		Revision as of 20:07, 5 September 2024
Line 100:		Line 100:
	# To download the all the data at once, you may click the "All Data Normalized" under "Bulk Downloads" on the FAOSTAT, Land Use website.		# To download the all the data at once, you may click the "All Data Normalized" under "Bulk Downloads" on the FAOSTAT, Land Use website.

	[[File:Screenshot 2024-08-20 112504.png\|none\|thumb\|458x458px]]'''''Special notes for Kosovo and Serbia:'''''		[[File:Screenshot 2024-08-20 112504.png\|none\|thumb\|458x458px]]'''''Notes for LandTotal and LandArea:'''''

			There is no null values in IFsHistSeries. Thus, the null values from original data need to be back filled by the earliest year's value.

			'''''Special notes for Kosovo and Serbia:'''''
	#There is no value for Kosovo from FAOSTAT, Land Use. Thus, we use the resource from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook].		#There is no value for Kosovo from FAOSTAT, Land Use. Thus, we use the resource from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook].
	#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.		#Kosovo is a landlocked country. So, we fill the 1.0887 Million Ha for Kosovo from 2008 to 2022 for both LandTotal and LandArea series.
	#The value for Kosovo in series LandAgri, LandGrazing, LandOther, LandCrop, and LandForest. We will use the information from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook] to calculate.[[File:Screenshot 2024-08-20 113943.png\|none\|thumb]]		#The value for Kosovo in series LandAgri, LandGrazing, LandOther, LandCrop, and LandForest. We will use the information from [https://www.cia.gov/the-world-factbook/countries/kosovo/#geography. CIA, The World Factbook] to calculate.[[File:Screenshot 2024-08-20 113943.png\|none\|thumb]]
	#Kosovo became independent from Serbia in 2008. Thus, the values for Serbia need to be deducted from the value for Kosovo since 2008 for each series.		#Kosovo became independent from Serbia in 2008. Thus, the values for Serbia need to be deducted from the value for Kosovo since 2008 for each series.