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
- Single target frequency distribution for a region or selection
- Single target frequency distribution by regions
- Single target frequency distribution by cells
- Single target frequency distribution by regions by cells
- File format
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:
- Select the region.
- On the Shortcut menu (right-click), point to Export Region, and then click TS Frequency Distribution.
- Choose a folder and enter a file name.
- Click Save.
To export single target frequency distribution for a selection:
- Make a selection using any selection tool.
- On the Shortcut menu (right-click), point to Export Selection, and then click TS Frequency distribution.
- Choose a folder and enter a file name.
- 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:
- Bring the single target echogram into focus.
- 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.
- Choose the region class(es) of interest, then click Export... to open the save file dialog box.
- Navigate to a destination folder and enter a File name for the file(s).
- 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:
- Bring the single target echogram into focus.
- On the menu, navigate to Echogram, Export, Analysis by Cells and click Frequency Distribution... to open the save file dialog box.
- Navigate to a destination folder and enter a File name for the file(s).
- 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:
- Bring the single target echogram into focus.
- 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.
- Choose the region class(es) of interest, then click Export... to open the save file dialog box.
- Navigate to a destination folder and enter a File name for the file(s).
- 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:
|
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