FishStatJ Software for Fishery and Aquaculture Statistical Time Series

From Pardee Wiki
Revision as of 16:46, 10 March 2023 by Sami.McKinsey (talk | contribs)
Jump to navigation Jump to search

SUMMARY

FishStatJ is a Windows or Mac application software that gives access to datasets from Food and Agriculture Organization of the United Nations' (FAO) Fisheries and Aquaculture statistics. These datasets show FAO's data on production, trade, and consumption of fish trade and aquaculture from over 200 countries. Data in FishStatJ can be aggregated and disaggregated in a variety of ways. Generally, FAO collects data through questionarries sent to countries on a regular basis. Usually datasets are updated annually, with Global Capture and Aquaculture Production releasing in the second quarter. While new and updated datasets appear automatically in the <Manage workspaces> menu, the software also checks for updates each time it is launched and will inform you of new versions to download.

The data team uses datasets from FishStatJ is used primarily to update IFs data regarding fish imports and exports for each country as well as other aquaculture needs. Example series from FishStatJ include SeriesAgFishImportValueFAOTrade, SeriesAgFishImportQuantityFAOTrade, SeriesAgFishExportValueFAOTrade, and SeriesAgFishExportQuantityFAOTrade.

STEPS TO PULL DATA FROM FISHSTATJ

Step 1. To pull data from FAO's Fisheries and Aquaculture Statistical Time Series software, FishStatJ, navigate to https://www.fao.org/fishery/en/topic/166235

FAO FishStatJ Download Page

Step 2. Scroll down the page until you reach <Installing FishStatJ v.4.02.08 (November 2022)>. Under <Download FishStatJ>, click on the desired operating system to download the software. This example will use the Windows version.

NOTE: Make sure your Windows version is compatible with FishStatJ before downloading. FishStatJ is compatible with Windows 10; 64-bit version; it cannot work with Windows 32-bit.

FAO FishStatJ Download


Step 3. After installing, go to your downloads and right click on <FishStatJ_4.02.08_Installer> and click <Open>.

FishStatJ under Downloads

Step 4. The following permission window will pop up. Click <Yes> to finish installing and launch.

FishStatJ installation permission pop-up

Step 5. FishStatJ will immediately launch at this point. The <Workspaces Manager> page should also open automatically after launching.

FAO's FishStatJ mainpage

Step 6. Select the desired workspace, then click <Download> on the right side. This example will pull data from <FAO Global Fish Trade Statistics>.

FishStatJ Workspaces Manager pop-up

Step 7. The following page will populate. Click <Next> two times, then click <Finish>.

FishStatJ Workspace Download
FishStatJ Workspace Import
FishStatJ Workspace Import Finish

Step 8. The <Dataset Browser> page will then pop up. You can select to have the dataset by partner country or all partners aggregated. This example will select <All partners aggregated>. Click <OK> on bottom right of page to open up the dataset.

FishStatJ Dataset Options

Step 9. The following page will populate. There are a variety of functions in FishStatJ that can be used to organize data. Hovering over the various icons above the dataset will give options like <Each dimension can be detailed, group or aggregated>, <Change sort order>, etc. Data can also be organized by hovering over <Data> and then selecting from options like <Filter<, <Aggregate>, <Columns>, <Sort>, <Custom Groups>, etc.

FishStat Data Organization Options

Step 10. To change column dimensions, hover over <Data> then select <Columns>. Select the dimension desired (<Commodity> in this example) and then select the text under <Concept>. Click on <Edit>.

FishStat Column Dimension Options

Step 11. The following window will pop up after clicking <Edit>. To the right of <Concept>, select the desired group from the dropdown menu. This example uses <FAOSTAT group>. Then, click <OK>. Finally, click <Apply and Close>. The dimension in the data should change immediately.

A note on aggregation: Most fish data in IFs is disaggregated into different types of fish based on the FAOSTAT group. However, it is not necessary to use that aggregation group when it concerns fish trade data from FishStatJ.

FishStat Column Dimension Options

Step 12. To export the data, click on <File> in the top left corner, then select <Export Selection (CSV file)...> OR use command Ctrl + S. Name the CSV file then save it into an appropriate place.

NOTE: Null values in FishStatJ will download automatically as 0 in Excel. Make sure to take note of actual zeroes before downloading.

FishStatJ Final Dataset

Step 13. Opening up the CSV file in Excel will formulate the following page. Make sure to save the file as an *.xls or *.xlsx to prevent any possible data loss.

NOTE: For any extra software issues, FishStatJ also has an online manual

FishStatJ Excel File