View source for FishStatJ Software for Fishery and Aquaculture Statistical Time Series

__FORCETOC__
=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 from 1976 to present day. Data in FishStatJ can be aggregated and disaggregated in a variety of ways. Generally, FAO collects data through questionnaries 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 primarily to update IFs data regarding fish imports and exports for each country as well as other aquaculture series. 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 <nowiki>https://www.fao.org/fishery/en/topic/166235</nowiki>
[[File:FISHSTATJ IMG STEP 01.jpg|center|thumb|575x575px|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.
[[File:FISHSTATJ IMG STEP 02.jpg|center|thumb|568x568px|FAO FishStatJ Download]]


Step 3. After installing, go to your downloads and right click on <FishStatJ_4.02.08_Installer> and click <Open>.
[[File:FISHSTATJ IMG STEP 03.jpg|center|thumb|573x573px|FishStatJ under Downloads]]
Step 4. The following permission window will pop up. Click <Yes> to finish installing and launch.
[[File:FISHSTATJ IMG STEP 04.jpg|center|thumb|587x587px|FishStatJ installation permission pop-up]]
Step 5. FishStatJ will immediately launch at this point. The <Workspaces Manager> page should also open automatically after launching.
[[File:FISHSTATJ IMG STEP 05.jpg|center|thumb|597x597px|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>.
[[File:FISHSTATJ IMG STEP 06.jpg|center|thumb|619x619px|FishStatJ Workspaces Manager pop-up]]
Step 7. The following page will populate. Click <Next> two times, then click <Finish>.
[[File:FISHSTATJ IMG STEP 07.jpg|center|thumb|624x624px|FishStatJ Workspace Download]]
[[File:FISHSTATJ IMG STEP 07(2).jpg|center|thumb|625x625px|FishStatJ Workspace Import]]
[[File:FISHSTATJ IMG STEP 07(3).jpg|center|thumb|631x631px|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.
[[File:FISHSTATJ IMG STEP 08.jpg|center|thumb|627x627px|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 <nowiki><Data> and then selecting from options like <Filter<, <Aggregate>, <Columns>, <Sort>, <Custom Groups>, etc.</nowiki>
[[File:FISHSTATJ IMG STEP 09(2).jpg|center|thumb|630x630px|FishStat Data Organization Options]]
Step 10. To change column dimensions, hover over <nowiki><Data> then select <Columns>. Select the dimension desired (<Commodity> in this example) and then select the text under <Concept>. Click on <Edit>.</nowiki>
[[File:FISHSTATJ IMG STEP 10(2).jpg|center|thumb|631x631px|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.
[[File:FISHSTATJ IMG STEP 11.jpg|center|thumb|647x647px|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.
[[File:FISHSTATJ IMG STEP 09.jpg|center|thumb|653x653px|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 [https://www.fao.org/fishery/static/FishStatJ/FishStatJ_4.02.7-Manual.pdf manual]
[[File:FISHSTATJ IMG STEP 10.jpg|center|thumb|660x660px|FishStatJ Excel File]]