FishstatJ, FAO - Revision history

Norah.Shamin: /* Global Aquatic Trade Statistics Workspace */

2025-08-15T16:37:18Z

Global Aquatic Trade Statistics Workspace

← Older revision		Revision as of 16:37, 15 August 2025
Line 303:		Line 303:
	==== Quantity ====		==== Quantity ====
	The two series found in this workspace are AgFishExportQuantityFAOTrade and AgFishImportQuantityFAOTrade. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to detailed. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened.		The two series found in this workspace are AgFishExportQuantityFAOTrade and AgFishImportQuantityFAOTrade. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to detailed. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened.

			= Data Notes =

Norah.Shamin at 16:08, 3 July 2025

2025-07-03T16:08:36Z

← Older revision		Revision as of 16:08, 3 July 2025
Line 206:		Line 206:
	== Global Capture Production (Quantity) Tab of the Global Fishery and Aquaculture Production Statistics ==		== Global Capture Production (Quantity) Tab of the Global Fishery and Aquaculture Production Statistics ==

	AgFishCatchProdAqAnimalsFSJ through AgFishCatchProdPelagicFSJ ~~(see list in Introduction)~~:		'''AgFishCatchProdAqAnimalsFSJ through AgFishCatchProdPelagicFSJ:'''

	Using the aggregation tool, set the country dimension to detailed, the species to grouped, and the fishing area to aggregated. For the species division, choose "FAOSTAT group of commodities." Using the filter tool under the data tab, make sure that ALL species, countries and fishing areas have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The species correspond to the different data series as follows:		Using the aggregation tool, set the country dimension to detailed, the species to grouped, and the fishing area to aggregated. For the species division, choose "FAOSTAT group of commodities." Using the filter tool under the data tab, make sure that ALL species, countries and fishing areas have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The species correspond to the different data series as follows:
Line 246:		Line 246:


	For AgFishProdCatchInland and AgFishProdCatchMarine:
			'''For AgFishProdCatchInland and AgFishProdCatchMarine:'''

	Using the aggregation tool, set the country dimension to detailed, the species to aggregated, and the fishing area to grouped. For the fishing area division, choose "Inland/Marine areas". Using the filter tool under the data tab, make sure that ALL species, countries and fishing areas have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The marine areas data correspond to AgFishProdCatchMarine and the inland waters data correspond to AgFishProdCatchInland.		Using the aggregation tool, set the country dimension to detailed, the species to aggregated, and the fishing area to grouped. For the fishing area division, choose "Inland/Marine areas". Using the filter tool under the data tab, make sure that ALL species, countries and fishing areas have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The marine areas data correspond to AgFishProdCatchMarine and the inland waters data correspond to AgFishProdCatchInland.
Line 252:		Line 253:
	== Global Aquaculture Production (Quantity) of the Global Fishery and Aquaculture Production Statistics ==		== Global Aquaculture Production (Quantity) of the Global Fishery and Aquaculture Production Statistics ==

	AgFishAquaProdAqAnimalsFSJ through AgFishAquaProdPelagicFSJ ~~(see list in Introduction)~~:		'''AgFishAquaProdAqAnimalsFSJ through AgFishAquaProdPelagicFSJ:'''

	Using the aggregation tool, set the country dimension to detailed, the species to grouped, and the aquaculture area and environment both to aggregated. For the species division, choose "FAOSTAT group of commodities". Using the filter tool under the data tab, make sure that ALL species, countries, aquaculture areas, and environments have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The species correspond to the different data series as follows:		Using the aggregation tool, set the country dimension to detailed, the species to grouped, and the aquaculture area and environment both to aggregated. For the species division, choose "FAOSTAT group of commodities". Using the filter tool under the data tab, make sure that ALL species, countries, aquaculture areas, and environments have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The species correspond to the different data series as follows:
Line 285:		Line 286:
	\| Pelagic Marine Fish		\| Pelagic Marine Fish
	\|}		\|}
			AgFishProdAquaInland and AgFishProdAquaMarine:

	AgFishProdAquaInland and AgFishProdAquaMarine:		'''AgFishProdAquaInland and AgFishProdAquaMarine:'''

	Under the aggregation tool, set the country dimension to detailed, the species and enviroment both to aggregated, and the aquaculture area to grouped. For the aquaculture division, choose "Inland/Marine areas". Using the filter tool under the data tab, make sure that ALL species, countries, aquaculture areas, and evironments have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The marine areas data correspond to AgFishProdAquaMarine and the inland waters data correspond to AgFishProdAquaInland.		Under the aggregation tool, set the country dimension to detailed, the species and enviroment both to aggregated, and the aquaculture area to grouped. For the aquaculture division, choose "Inland/Marine areas". Using the filter tool under the data tab, make sure that ALL species, countries, aquaculture areas, and evironments have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The marine areas data correspond to AgFishProdAquaMarine and the inland waters data correspond to AgFishProdAquaInland.

Norah.Shamin at 14:57, 3 July 2025

2025-07-03T14:57:53Z

← Older revision		Revision as of 14:57, 3 July 2025
Line 1:		Line 1:
	= ~~Introduction~~ =		= Summary =

	FAO ~~Fishtatj~~ is software used by the Food and Agriculture Organization to handle their fisheries and aquaculture data. Data from Fishtatj is separated into four different workspaces, which must each be downloaded separately: Global Fishery and Aquaculture Production Statistics and Global Aquatic Trade Statistics. Once downloaded, the data in each of these workspaces may be manipulated and converted to an excel file using the Fishtatj software. FAO Fishtatj and workspaces can be downloaded [https://www.fao.org/fishery/en/statistics/software/fishstatj here]. ~~The following series are~~ IFs ~~data collected using Fishstatj:~~		FAO FishtatJ is software used by the Food and Agriculture Organization to handle their fisheries and aquaculture data. Data from Fishtatj is separated into four different workspaces, which must each be downloaded separately: Global Fishery and Aquaculture Production Statistics and Global Aquatic Trade Statistics. Once downloaded, the data in each of these workspaces may be manipulated and converted to an excel file using the Fishtatj software. FAO Fishtatj and workspaces can be downloaded [https://www.fao.org/fishery/en/statistics/software/fishstatj here].

			= Tables In IFs =
	{\| class="wikitable"		{\| class="wikitable"
	\|Variable		\|Variable
Line 196:		Line 198:
	\|}		\|}

	= Data ~~Collection~~ =		= Data Pulling Instructions =

	After downloading Fishtatj and the Global Commodity and Global Fishery and Aquaculture Production Statistics workspaces, open the program and load the Global Fishery and Aquaculture Production Statistics dataset. Within this workspace, there are three tabs: Global Capture Production, Global Aquaculture Production, and Global Production by Production Source. Data can be further manipulated using the level of aggregation tool (blue arrow) and the filter tool - the first option under the data tab (green arrow).		After downloading Fishtatj and the Global Commodity and Global Fishery and Aquaculture Production Statistics workspaces, open the program and load the Global Fishery and Aquaculture Production Statistics dataset. Within this workspace, there are three tabs: Global Capture Production, Global Aquaculture Production, and Global Production by Production Source. Data can be further manipulated using the level of aggregation tool (blue arrow) and the filter tool - the first option under the data tab (green arrow).
Line 202:		Line 204:
	[[File:FAO Fishtatj Help Image.png]]		[[File:FAO Fishtatj Help Image.png]]

	== Global Capture Production (Quantity) ~~tab~~ of the Global Fishery and Aquaculture Production Statistics ~~dataset~~ ==		== Global Capture Production (Quantity) Tab of the Global Fishery and Aquaculture Production Statistics ==

	AgFishCatchProdAqAnimalsFSJ through AgFishCatchProdPelagicFSJ (see list in Introduction):		AgFishCatchProdAqAnimalsFSJ through AgFishCatchProdPelagicFSJ (see list in Introduction):
Line 209:		Line 211:

	{\| border="1" cellpadding="0" cellspacing="0" width="448"		{\| border="1" cellpadding="0" cellspacing="0" width="448"
			!Series
			!Name in Source
	\|- height="20"		\|- height="20"
	\| height="20" width="232" \| AgFishCatchProdAqAnimalsFSJ		\| height="20" width="232" \| AgFishCatchProdAqAnimalsFSJ
Line 241:		Line 245:
	\|}		\|}

	AgFishProdCatchInland and AgFishProdCatchMarine:
			For AgFishProdCatchInland and AgFishProdCatchMarine:

	Using the aggregation tool, set the country dimension to detailed, the species to aggregated, and the fishing area to grouped. For the fishing area division, choose "Inland/Marine areas". Using the filter tool under the data tab, make sure that ALL species, countries and fishing areas have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The marine areas data correspond to AgFishProdCatchMarine and the inland waters data correspond to AgFishProdCatchInland.		Using the aggregation tool, set the country dimension to detailed, the species to aggregated, and the fishing area to grouped. For the fishing area division, choose "Inland/Marine areas". Using the filter tool under the data tab, make sure that ALL species, countries and fishing areas have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The marine areas data correspond to AgFishProdCatchMarine and the inland waters data correspond to AgFishProdCatchInland.

	== Global Aquaculture Production (Quantity) ~~tab~~ of the Global Fishery and Aquaculture Production Statistics ~~dataset~~ ==		== Global Aquaculture Production (Quantity) of the Global Fishery and Aquaculture Production Statistics ==

	AgFishAquaProdAqAnimalsFSJ through AgFishAquaProdPelagicFSJ (see list in Introduction):		AgFishAquaProdAqAnimalsFSJ through AgFishAquaProdPelagicFSJ (see list in Introduction):
Line 289:		Line 294:
	Close the workspace. Then open the Global Aquatic Trade Statistics Workspace.		Close the workspace. Then open the Global Aquatic Trade Statistics Workspace.

	=== Global Aquatic Trade Statistics - All ~~partners aggregated~~ ===		=== Global Aquatic Trade Statistics - All Partners Aggregated ===

	==== Value ====		==== Value ====

Yutang.Xiong: Yutang.Xiong moved page FAO FishstatJ to FishstatJ, FAO without leaving a redirect: new name

2025-02-12T20:55:29Z

Yutang.Xiong moved page FAO FishstatJ to FishstatJ, FAO without leaving a redirect: new name

← Older revision	Revision as of 20:55, 12 February 2025
(No difference)

Yutang.Xiong: Yutang.Xiong moved page FAO FishstatJ Data to FAO FishstatJ without leaving a redirect: renaming

2025-02-12T19:56:08Z

Yutang.Xiong moved page FAO FishstatJ Data to FAO FishstatJ without leaving a redirect: renaming

← Older revision	Revision as of 19:56, 12 February 2025
(No difference)

Kexin.Shang: /* Value (1976 - 2021) */

2024-04-08T17:25:46Z

Value (1976 - 2021)

← Older revision		Revision as of 17:25, 8 April 2024
Line 291:		Line 291:
	=== Global Aquatic Trade Statistics - All partners aggregated ===		=== Global Aquatic Trade Statistics - All partners aggregated ===

	==== Value ~~(1976 - 2021)~~ ====		==== Value ====
	The four series found in this workspace are AgFishExportVal, AgFishImportVal, AgFishExportValue%GDPFAOTrade and AgFishImportValue%GDPFAOTrade. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to detailed. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. For AgFishExportValue%GDPFAOTrade and AgFishImportValue%GDPFAOTrade, downloaded value divided by GDP at current $ from WDI.		The four series found in this workspace are AgFishExportVal, AgFishImportVal, AgFishExportValue%GDPFAOTrade and AgFishImportValue%GDPFAOTrade. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to detailed. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. For AgFishExportValue%GDPFAOTrade and AgFishImportValue%GDPFAOTrade, downloaded value divided by GDP at current $ from WDI.

	==== Quantity ~~(1976- 2021)~~ ====		==== Quantity ====
	The two series found in this workspace are AgFishExportQuantityFAOTrade and AgFishImportQuantityFAOTrade. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to detailed. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened.		The two series found in this workspace are AgFishExportQuantityFAOTrade and AgFishImportQuantityFAOTrade. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to detailed. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened.

Kexin.Shang: /* Introduction */

2024-04-08T17:25:17Z

Introduction

Show changes

Kexin.Shang: /* Introduction */

2024-04-08T17:12:40Z

Introduction

← Older revision		Revision as of 17:12, 8 April 2024
Line 100:		Line 100:
	\|-		\|-
	\|AgFishCatchProdDemersalFSJ		\|AgFishCatchProdDemersalFSJ
	\|Total Demersal ~~Capture~~ Production from FishstatJ		\|Total Demersal Capture Production from FishstatJ
	\|Global Production		\|Global Production
	\|1		\|1
Line 118:		Line 118:
	\|-		\|-
	\|AgFishCatchProdMolluscsFSJ		\|AgFishCatchProdMolluscsFSJ
	\|Total Molluscs ~~Capture~~ Production from FishstatJ		\|Total Molluscs Capture Production from FishstatJ
	\|Global Production		\|Global Production
	\|1		\|1
Line 137:		Line 137:
	\|AgFishExportVal		\|AgFishExportVal
	\|Global Commodities Production and Trade Value of Fish Exports (USD)		\|Global Commodities Production and Trade Value of Fish Exports (USD)
	\|Global ~~Commodities~~		\|Global Aquatic Trade
	\|0		\|0
	\|		\|
Line 143:		Line 143:
	\|AgFishImportVal		\|AgFishImportVal
	\|Global Commodities Production and Trade Value of Fish Imports (USD)		\|Global Commodities Production and Trade Value of Fish Imports (USD)
	\|Global ~~Commodities~~		\|Global Aquatic Trade
	\|0		\|0
	\|		\|
	\|-		\|-
	\|AgFishProdAquaInland		\|AgFishProdAquaInland
	\|Fish,Production, ~~Inland~~ Aquaculture		\|Fish,Production, Inland Aquaculture
	\|Global Production		\|Global Production
	\|0		\|0
Line 170:		Line 170:
	\|0		\|0
	\|		\|
			\|-
			\|AgFishExportValue%GDPFAOTrade
			\|Export value of fish ($1000 US) from FishstatJ software, as a percent of GDP at current $ from WDI, all species aggregated
			\|Global Aquatic Trade
			\|1
			\|AGRI
			\|-
			\|AgFishImportValue%GDPFAOTrade
			\|Import value of fish ($1000 US) from FishstatJ software, as a percent of GDP at current $ from WDI, all species aggregated
			\|Global Aquatic Trade
			\|1
			\|AGRI
			\|-
			\|AgFishExportQuantityFAOTrade
			\|Quantity of fish exported (Tonnes) from FishstatJ,
			\|Global Aquatic Trade
			\|1
			\|AGRI
			\|-
			\|AgFishImportQuantityFAOTrade
			\|Quantity of fish imported (Tonnes) from FishstatJ,
			\|Global Aquatic Trade
			\|1
			\|AGRI
	\|}		\|}

Line 263:		Line 287:
	== Global Aquatic Trade Workspace ==		== Global Aquatic Trade Workspace ==

	Close the workspace. Then open the Global Aquatic Trade Workspace. The two series found in this workspace are ~~AgFishExportVal~~ and ~~AgFishImportVal~~. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to ~~Detailed~~. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened.		Close the workspace. Then open the Global Aquatic Trade Workspace.

			=== Global Aquatic Trade - All partners aggregated ===

			==== Value (1976 - 2021) ====
			The four series found in this workspace are AgFishExportVal, AgFishImportVal, AgFishExportValue%GDPFAOTrade and AgFishImportValue%GDPFAOTrade. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to detailed. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. For AgFishExportValue%GDPFAOTrade and AgFishImportValue%GDPFAOTrade, downloaded value divided by GDP at current $ from WDI.

			==== Quantity (1976- 2021) ====
			The two series found in this workspace are AgFishExportQuantityFAOTrade and AgFishImportQuantityFAOTrade. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the trade flow to detailed. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened.

Kexin.Shang: /* Global Commodities Workspace */

2024-04-08T16:59:19Z

Global Commodities Workspace

Show changes

AlisaNelson at 23:06, 16 July 2017

2017-07-16T23:06:02Z

Show changes