Exporting single target TS frequency distribution analyses

The frequency distribution of the target strength of single targets within a selection or region on a single targets echogram can be exported to a .csv file.

Export and bin settings

TS range and number of bins

You set the range of TS values that will be included in the analysis and the number of bins into which this range is divided using the settings under Frequency Distribution on the Analysis page of the Variable Properties dialog box (for export).

Hint: You can graph the frequency distribution prior to exporting to visualize the binning and target information that will be exported. Configure the on-screen axes, bins and labels with Graph Properties.

Data exported for each bin

You can export either the number of targets in a bin and/or the TS mean of targets in a bin.

You select which values to export on the Export page of the EV File Properties dialog box.

To export...

In the Export these analysis variables box, select...

the number of targets in each bin

Bin_count

the mean TS value of targets in each bin

Bin_TS_mean

If you select one option, the exported file will contain a single line for each domain that is analyzed. If you select both options, the exported file will contain two rows (one after the other) for each domain that is analyzed.

Single target frequency distribution for a region or selection

To export single target frequency distribution for a region:

  1. Select the region.
  2. On the Shortcut menu (right-click), point to Export Region, and then click TS Frequency Distribution.
  3. Choose a folder and enter a file name.
  4. Click Save.

To export single target frequency distribution for a selection:

  1. Make a selection using any selection tool.
  2. On the Shortcut menu (right-click), point to Export Selection, and then click TS Frequency distribution.
  3. Choose a folder and enter a file name.
  4. Click Save.

To export single target frequency distribution for multiple analysis domains at the same time, see Exporting single target frequency distribution.

Single target frequency distribution by regions

The single target frequency distribution by regions export command is used to export a frequency distribution of single targets, by target strength, for analysis regions in an echogram. The data are exported to a single .csv file.

To export single target frequency distribution by regions:

  1. Bring the single target echogram into focus.
  2. On the menu, navigate to Echogram, Export, Analysis by Regions and click Frequency Distribution... to open the Export Frequency Distribution by Regions - Select Classes dialog box.
  3. Choose the region class(es) of interest, then click Export... to open the save file dialog box.
  4. Navigate to a destination folder and enter a File name for the file(s).
  5. Click Save.

Notes:

  • The column heading for each TS bin column represents the mid point of the targets strength values included in the bin, e.g. a bin that includes targets with target strength between -50 dB and -60 dB, would have -55 dB as the column heading.
  • The regions for which a frequency distribution will be exported is affected by exclusion lines selected on the Analysis page of the Variable Properties dialog box.
  • Regions that do not contain any targets will not be analyzed.
  • All settings in the Variable Properties dialog box except those on the Echogram Display page are applied to calculations.
  • This command will only be available if at least one analysis region has been defined on the selected echogram.
  • You can only export single target frequency distribution if you have purchased an Essentials module license.

Single target frequency distribution by cells

The single target frequency distribution by cells export command is used to export a frequency distribution of single targets, by target strength, for cells on an echogram.

You must select an export format on the Export page of the EV File Properties dialog box before using this command. You can select:

  • spreadsheet format: to export to a single .csv file for analysis using a spreadsheet application.
  • database format: to export data to multiple .csv files for analysis using a database application.

To export a single target frequency distribution by cells:

  1. Bring the single target echogram into focus.
  2. On the menu, navigate to Echogram, Export, Analysis by Cells and click Frequency Distribution... to open the save file dialog box.
  3. Navigate to a destination folder and enter a File name for the file(s).
  4. Click Save.

Notes:

  • The column heading for each bin represents the mid point of the TS values of the bin, e.g. a bin that includes targets with TS values between -50 dB and -60 dB, would have '-55' dB as the column heading.
  • The cells for which a frequency distribution will be exported is affected by the exclusion lines selected on the Analysis page of the Variable Properties dialog box.
  • The cells for which a frequency distribution will be exported is not affected by output empty cells option on the Export page of the EV File Properties dialog box, i.e. empty cells will not be analyzed or included in the export.
  • This command will only be available if you have defined a time/distance by depth grid on the Grid page of the Variable Properties dialog box.
  • All settings in the Variable Properties dialog box except those on the Echogram Display page are applied to calculations.
  • This command will not be available if a grid is not defined in your echogram.
  • You can only export single target frequency distribution if you have purchased an Essentials module license.

Single target frequency distribution by regions by cells

The single target frequency distribution by regions by cells export command is used to export a single target frequency distribution, by target strength, for region-cell intersections on an echogram.

You must select an export format on the Export page of the EV File Properties dialog box before using this command. You can select:

  • spreadsheet format: to export to a single .csv file for analysis using a spreadsheet application.
  • database format: to export data to multiple .csv files for analysis using a database application.

To export a single target frequency distribution by regions by cells:

  1. Bring the single target echogram into focus.
  2. On the menu, navigate to Echogram, Export, Analysis by Regions by Cells and click Frequency Distribution... to open the Export Frequency Distribution by Regions - Select Classes dialog box.
  3. Choose the region class(es) of interest, then click Export... to open the save file dialog box.
  4. Navigate to a destination folder and enter a File name for the file(s).
  5. Click Save.

Notes:

  • The column heading for each bin represents the mid point of the TS values of the bin, e.g. a bin that includes targets with TS values between -50 dB and -60 dB, would have '-55' dB as the column heading.
  • The region-cell intersections for which a frequency distribution will be exported is affected by the exclusion lines selected on the Analysis page of the Variable Properties dialog box.
  • The region-cell intersections for which a frequency distribution will be exported is not affected the output empty cells option on the Export page of the EV File Properties dialog box.
  • This command will only be available if you have defined a time/distance by depth grid on the Grid page of the Variable Properties dialog box.
  • All settings in the Variable Properties dialog box except those on the Echogram Display page are applied to calculations.
  • You can only export single target frequency distribution if you have purchased an Essentials module license.

TS frequency distribution file format (*.csv)

The first line of the .csv file lists the variables that are exported (these will be used as column headings if the file is loaded into a spreadsheet program). Each subsequent line contains the exported data.

The following data are exported.

Variable

Description

Region_ID

Unique Region ID assigned to the region.

Region_name

Name assigned to region. Empty if export of a selection.

Region_Class

Class of exported region. Empty if export of a selection.

Process_ID

Unique Process_ID value for the export.

Attribute

Attribute that follows for each bin, either Bin_Count and/or Bin_TS_mean selected under Frequency distribution on the Export page of the EV File Properties dialog box.

Targets_Binned

See About analysis variables for descriptions.

Notes:

  • Region_bottom_altitude_min, Region_bottom_altitude_max, Region_bottom_altitude_mean, Region_top_altitude_min, Region_top_altitude_max, Region_top_altitude_mean are automatically output under new EV files. See also Automatically exported variables.
  • Optional Frequency Distribution variables Bin_TS_count and Bin_TS_mean can be included with the export and may be specified on the Export page of the EV File Properties dialog box.
  • Analysis variations for By Regions, spreadsheet and database can include other analysis variables.

Targets_Failed_Thresholds

Targets_Failed_Filter

Targets_Excluded

Targets_Missed_Bins

Region_bottom_altitude_min

Region_bottom_altitude_max

Region_bottom_altitude_mean

Region_top_altitude_min

Region_top_altitude_max

Region_top_altitude_mean

Bin1 midpoint

BinN midpoint

The first line then has the median TS value for each bin from the first to last bin

Binning is determined by the Frequency distribution settings on the Analysis page of the Variable Properties dialog box

Example file

Widen the brower window to view unwrapped field rows and exported results.

Region_ID,Region_name,Region_class,Process_ID,Attribute,Targets_Binned,Targets_Failed_Thresholds,Targets_Failed_Filter,Targets_Excluded,Targets_Missed_Bins,Region_bottom_altitude_min,Region_bottom_altitude_max,Region_bottom_altitude_mean,Region_top_altitude_min,Region_top_altitude_max,Region_top_altitude_mean,-55,-45,-35,-25
57,"Region 57","Small region",4318,Bin_count,60,0,0,0,0,38.988512,39.312884,39.132643,70.753799,71.078171,70.89793,0,6,45,9
57,"Region 57","Small region",4318,Bin_TS_mean,60,0,0,0,0,38.988512,39.312884,39.132643,70.753799,71.078171,70.89793,-9.90E+37,-45.322011,-32.908052,-26.904587

Tip: It is possible to view a graph of the frequency distribution prior to exporting.

The export single target frequency distribution commands are used to export a frequency distribution of the single targets in selected analysis domains by their target strength.

See also

Exporting data
Special Export Values

Exporting single targets analyses