FishstatJ, FAO: Difference between revisions
Jump to navigation
Jump to search
Kexin.Shang (talk | contribs) m (→Introduction) |
Norah.Shamin (talk | contribs) |
||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
= | = Summary = | ||
FAO | 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 11: | Line 13: | ||
|AgFishAquaProdAqAnimalsFSJ | |AgFishAquaProdAqAnimalsFSJ | ||
|Total Aquatic Animals Aquaculture Production (tonnes) from FishstatJ | |Total Aquatic Animals Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 17: | Line 19: | ||
|AgFishAquaProdAqPlantsFSJ | |AgFishAquaProdAqPlantsFSJ | ||
|Total Aquatic Plants Aquaculture Production (tonnes) from FishstatJ | |Total Aquatic Plants Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 23: | Line 25: | ||
|AgFishAquaProdCephalopodsFSJ | |AgFishAquaProdCephalopodsFSJ | ||
|Total Cephalopods Aquaculture Production (tonnes) from FishstatJ | |Total Cephalopods Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 29: | Line 31: | ||
|AgFishAquaProdCrustaceansFSJ | |AgFishAquaProdCrustaceansFSJ | ||
|Total Crustaceans Aquaculture Production (tonnes) from FishstatJ | |Total Crustaceans Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 35: | Line 37: | ||
|AgFishAquaProdDemersalFSJ | |AgFishAquaProdDemersalFSJ | ||
|Total Demersal Aquaculture Production (tonnes) from FishstatJ | |Total Demersal Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 41: | Line 43: | ||
|AgFishAquaProdFreshwaterFSJ | |AgFishAquaProdFreshwaterFSJ | ||
|Total Freshwater Aquaculture Production (tonnes) from FishstatJ | |Total Freshwater Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 47: | Line 49: | ||
|AgFishAquaProdMarineFSJ | |AgFishAquaProdMarineFSJ | ||
|Total Marine Aquaculture Production (tonnes) from FishstatJ | |Total Marine Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 53: | Line 55: | ||
|AgFishAquaProdMolluscsFSJ | |AgFishAquaProdMolluscsFSJ | ||
|Total Molluscs Aquaculture Production (tonnes) from FishstatJ | |Total Molluscs Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 59: | Line 61: | ||
|AgFishAquaProdOthersFSJ | |AgFishAquaProdOthersFSJ | ||
|Total Others Aquaculture Production (tonnes) from FishstatJ | |Total Others Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 65: | Line 67: | ||
|AgFishAquaProdPelagicFSJ | |AgFishAquaProdPelagicFSJ | ||
|Total Pelagic Aquaculture Production (tonnes) from FishstatJ | |Total Pelagic Aquaculture Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 71: | Line 73: | ||
|AgFishCatchProdAqAnimalsFSJ | |AgFishCatchProdAqAnimalsFSJ | ||
|Total Aquatic Animals Catch Production (tonnes) from FishstatJ | |Total Aquatic Animals Catch Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 77: | Line 79: | ||
|AgFishCatchProdAqMammalsFSJ | |AgFishCatchProdAqMammalsFSJ | ||
|Total Aquatic Mammals Catch Production (tonnes) from FishstatJ | |Total Aquatic Mammals Catch Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 83: | Line 85: | ||
|AgFishCatchProdAqPlantsFSJ | |AgFishCatchProdAqPlantsFSJ | ||
|Total Aquatic Plants Catch Production (tonnes) from FishstatJ | |Total Aquatic Plants Catch Production (tonnes) from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 89: | Line 91: | ||
|AgFishCatchProdCephalopodsFSJ | |AgFishCatchProdCephalopodsFSJ | ||
|Total Cephalopods Capture Production from FishstatJ | |Total Cephalopods Capture Production from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 95: | Line 97: | ||
|AgFishCatchProdCrustaceansFSJ | |AgFishCatchProdCrustaceansFSJ | ||
|Total Crustaceans Capture Production from FishstatJ | |Total Crustaceans Capture Production from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 101: | Line 103: | ||
|AgFishCatchProdDemersalFSJ | |AgFishCatchProdDemersalFSJ | ||
|Total Demersal Capture Production from FishstatJ | |Total Demersal Capture Production from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 107: | Line 109: | ||
|AgFishCatchProdFreshwaterFSJ | |AgFishCatchProdFreshwaterFSJ | ||
|Total Freshwater Capture Production from FishstatJ | |Total Freshwater Capture Production from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 113: | Line 115: | ||
|AgFishCatchProdMarineFSJ | |AgFishCatchProdMarineFSJ | ||
|Total Marine Capture Production from FishstatJ | |Total Marine Capture Production from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 119: | Line 121: | ||
|AgFishCatchProdMolluscsFSJ | |AgFishCatchProdMolluscsFSJ | ||
|Total Molluscs Capture Production from FishstatJ | |Total Molluscs Capture Production from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 125: | Line 127: | ||
|AgFishCatchProdOthersFSJ | |AgFishCatchProdOthersFSJ | ||
|Total Others Capture Production from FishstatJ | |Total Others Capture Production from FishstatJ | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 131: | Line 133: | ||
|AgFishCatchProdPelagicFSJ | |AgFishCatchProdPelagicFSJ | ||
|Total Pelagic Capture Production (tonnes) from Fishstatj | |Total Pelagic Capture Production (tonnes) from Fishstatj | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 137: | Line 139: | ||
|AgFishExportVal | |AgFishExportVal | ||
|Global Commodities Production and Trade Value of Fish Exports (USD) | |Global Commodities Production and Trade Value of Fish Exports (USD) | ||
|Global Aquatic Trade | |Global Aquatic Trade Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 143: | Line 145: | ||
|AgFishImportVal | |AgFishImportVal | ||
|Global Commodities Production and Trade Value of Fish Imports (USD) | |Global Commodities Production and Trade Value of Fish Imports (USD) | ||
|Global Aquatic Trade | |Global Aquatic Trade Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 149: | Line 151: | ||
|AgFishProdAquaInland | |AgFishProdAquaInland | ||
|Fish,Production, Inland Aquaculture | |Fish,Production, Inland Aquaculture | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 155: | Line 157: | ||
|AgFishProdAquaMarine | |AgFishProdAquaMarine | ||
|Fish, production, Marine Aquaculture | |Fish, production, Marine Aquaculture | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 161: | Line 163: | ||
|AgFishProdCatchInland | |AgFishProdCatchInland | ||
|Fish, Production, Inland Catch | |Fish, Production, Inland Catch | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 167: | Line 169: | ||
|AgFishProdCatchMarine | |AgFishProdCatchMarine | ||
|Fish, Production, Marine Catch | |Fish, Production, Marine Catch | ||
|Global Production | |Global Fishery and Aquaculture Production Statistics | ||
|0 | |0 | ||
| | | | ||
| Line 173: | Line 175: | ||
|AgFishExportValue%GDPFAOTrade | |AgFishExportValue%GDPFAOTrade | ||
|Export value of fish ($1000 US) from FishstatJ software, as a percent of GDP at current $ from WDI, all species aggregated | |Export value of fish ($1000 US) from FishstatJ software, as a percent of GDP at current $ from WDI, all species aggregated | ||
|Global Aquatic Trade | |Global Aquatic Trade Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 179: | Line 181: | ||
|AgFishImportValue%GDPFAOTrade | |AgFishImportValue%GDPFAOTrade | ||
|Import value of fish ($1000 US) from FishstatJ software, as a percent of GDP at current $ from WDI, all species aggregated | |Import value of fish ($1000 US) from FishstatJ software, as a percent of GDP at current $ from WDI, all species aggregated | ||
|Global Aquatic Trade | |Global Aquatic Trade Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 185: | Line 187: | ||
|AgFishExportQuantityFAOTrade | |AgFishExportQuantityFAOTrade | ||
|Quantity of fish exported (Tonnes) from FishstatJ, | |Quantity of fish exported (Tonnes) from FishstatJ, | ||
|Global Aquatic Trade | |Global Aquatic Trade Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
| Line 191: | Line 193: | ||
|AgFishImportQuantityFAOTrade | |AgFishImportQuantityFAOTrade | ||
|Quantity of fish imported (Tonnes) from FishstatJ, | |Quantity of fish imported (Tonnes) from FishstatJ, | ||
|Global Aquatic Trade | |Global Aquatic Trade Statistics | ||
|1 | |1 | ||
|AGRI | |AGRI | ||
|} | |} | ||
= Data | = Data Pulling Instructions = | ||
After downloading Fishtatj and the Global Commodity and Global Production workspaces, open the program and load the Global Production dataset. Within this workspace, there are three tabs: Global Capture Production | 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). | ||
[[File:FAO Fishtatj Help Image.png]] | [[File:FAO Fishtatj Help Image.png]] | ||
== Global Capture Production (Quantity) | == Global Capture Production (Quantity) Tab of the Global Fishery and Aquaculture Production Statistics == | ||
AgFishCatchProdAqAnimalsFSJ through AgFishCatchProdPelagicFSJ | '''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: | ||
{| 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) | == Global Aquaculture Production (Quantity) of the Global Fishery and Aquaculture Production Statistics == | ||
AgFishAquaProdAqAnimalsFSJ through AgFishAquaProdPelagicFSJ | '''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 280: | 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. | ||
== Global Aquatic Trade Workspace == | == Global Aquatic Trade Statistics Workspace == | ||
Close the workspace. Then open the Global Aquatic Trade Workspace. | Close the workspace. Then open the Global Aquatic Trade Statistics Workspace. | ||
=== Global Aquatic Trade - All | === Global Aquatic Trade Statistics - All Partners Aggregated === | ||
==== Value | ==== 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 | ==== 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 = | |||
Latest revision as of 16:37, 15 August 2025
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 here.
Tables In IFs
| Variable | Definition | Workspace | UsedInPreprocessor | UsedInPreprocessorFileName |
| AgFishAquaProdAqAnimalsFSJ | Total Aquatic Animals Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishAquaProdAqPlantsFSJ | Total Aquatic Plants Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishAquaProdCephalopodsFSJ | Total Cephalopods Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishAquaProdCrustaceansFSJ | Total Crustaceans Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishAquaProdDemersalFSJ | Total Demersal Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishAquaProdFreshwaterFSJ | Total Freshwater Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishAquaProdMarineFSJ | Total Marine Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishAquaProdMolluscsFSJ | Total Molluscs Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishAquaProdOthersFSJ | Total Others Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 0 | |
| AgFishAquaProdPelagicFSJ | Total Pelagic Aquaculture Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdAqAnimalsFSJ | Total Aquatic Animals Catch Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdAqMammalsFSJ | Total Aquatic Mammals Catch Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 0 | |
| AgFishCatchProdAqPlantsFSJ | Total Aquatic Plants Catch Production (tonnes) from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdCephalopodsFSJ | Total Cephalopods Capture Production from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdCrustaceansFSJ | Total Crustaceans Capture Production from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdDemersalFSJ | Total Demersal Capture Production from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdFreshwaterFSJ | Total Freshwater Capture Production from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdMarineFSJ | Total Marine Capture Production from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdMolluscsFSJ | Total Molluscs Capture Production from FishstatJ | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishCatchProdOthersFSJ | Total Others Capture Production from FishstatJ | Global Fishery and Aquaculture Production Statistics | 0 | |
| AgFishCatchProdPelagicFSJ | Total Pelagic Capture Production (tonnes) from Fishstatj | Global Fishery and Aquaculture Production Statistics | 1 | AGRI |
| AgFishExportVal | Global Commodities Production and Trade Value of Fish Exports (USD) | Global Aquatic Trade Statistics | 0 | |
| AgFishImportVal | Global Commodities Production and Trade Value of Fish Imports (USD) | Global Aquatic Trade Statistics | 0 | |
| AgFishProdAquaInland | Fish,Production, Inland Aquaculture | Global Fishery and Aquaculture Production Statistics | 0 | |
| AgFishProdAquaMarine | Fish, production, Marine Aquaculture | Global Fishery and Aquaculture Production Statistics | 0 | |
| AgFishProdCatchInland | Fish, Production, Inland Catch | Global Fishery and Aquaculture Production Statistics | 0 | |
| AgFishProdCatchMarine | Fish, Production, Marine Catch | Global Fishery and Aquaculture Production Statistics | 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 Statistics | 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 Statistics | 1 | AGRI |
| AgFishExportQuantityFAOTrade | Quantity of fish exported (Tonnes) from FishstatJ, | Global Aquatic Trade Statistics | 1 | AGRI |
| AgFishImportQuantityFAOTrade | Quantity of fish imported (Tonnes) from FishstatJ, | Global Aquatic Trade Statistics | 1 | AGRI |
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).
Global Capture Production (Quantity) Tab of the Global Fishery and Aquaculture Production Statistics
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:
| Series | Name in Source |
|---|---|
| AgFishCatchProdAqAnimalsFSJ | Aquatic Animals NEI |
| AgFishCatchProdAqMammalsFSJ | Aquatic Mammals |
| AgFishCatchProdAqPlantsFSJ | Aquatic Plants |
| AgFishCatchProdCephalopodsFSJ | Cephalopods |
| AgFishCatchProdCrustaceansFSJ | Crustaceans |
| AgFishCatchProdDemersalFSJ | Demersal Marine Fish |
| AgFishCatchProdFreshwaterFSJ | Freshwater and Diadromous Fish |
| AgFishCatchProdMarineFSJ | Marine Fish NEI |
| AgFishCatchProdMolluscsFSJ | Molluscs excl. Cephalopods |
| AgFishCatchProdPelagicFSJ | Pelagic Marine Fish |
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.
Global Aquaculture Production (Quantity) of the Global Fishery and Aquaculture Production Statistics
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:
| AgFishAquaProdAqAnimalsFSJ | Aquatic Animals NEI |
| AgFishAquaProdAqPlantsFSJ | Aquatic Plants |
| AgFishAquaProdCephalopodsFSJ | Cephalopods |
| AgFishAquaProdCrustaceansFSJ | Crustaceans |
| AgFishAquaProdDemersalFSJ | Demersal Marine Fish |
| AgFishAquaProdFreshwaterFSJ | Freshwater and Diadromous Fish |
| AgFishAquaProdMarineFSJ | Marine Fish NEI |
| AgFishAquaProdMolluscsFSJ | Molluscs excl. Cephalopods |
| AgFishAquaProdPelagicFSJ | Pelagic Marine Fish |
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.
Global Aquatic Trade Statistics Workspace
Close the workspace. Then open the Global Aquatic Trade Statistics Workspace.
Global Aquatic Trade Statistics - All Partners Aggregated
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.
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.