About tables

Tables allow you to view and export the details of supported acoustic, position, attitude, distance, line, length, speed, bottom feature, bottom points, and time series variables—including time series collections.

The following tables are available:

Table Availability

Acoustic data

Available for a supported acoustic variable and includes:

  • No. (Ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.sss)
  • Data file (the name of the source raw data file)
  • Start range (m)
  • Stop range (m)
  • Data points (number of samples in the ping)

Notes:

  • An export via the Table menu is handled as for a data export. Exports to several file formats may be available.
  • For the Sector select operator, Sector type and Angle are specified by the operator.
Analysis time series data

Available for Interval analysis virtual variables, including Interval analysis - Bottom feature, Interval analysis - Single targets, and Interval analysis - Sv. Each line includes:

  • No. (Number of the interval)
  • Date/time (yyyy-MMM-dd HH:mm:ss.ssss)
  • Analysis feature
  • Status

Bottom classification data

Available for a bottom points variable. Each line will contain data for a bottom classification and can include:

  • No. (Index or ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.sss)
  • Latitude (°)
  • Longitude (°)
  • Altitude (m)
  • Depth (m)
  • Class+
  • Bottom_roughness_normalized
  • Bottom_hardness_normalized*
  • First_bottom_length_normalized
  • Second_bottom_length_normalized*
  • Bottom_rise_time_normalized
  • Bottom_line_depth_mean
  • Bottom_max_Sv
  • Bottom_kurtosis
  • Bottom_skewness

Notes:

  • The table displays extracted (user specified) bottom features.
  • *The Bottom_hardness_normalized and the Second_bottom_length_normalized are based on the existence and measurability of the second bottom echo.
  • +Modify a bottom point's Class by selecting a different class from the Class list. An exported bottom points file outputs a Class_name and Class_ID.

Line data

Available for line data depth and line data heave variables. Each line in the table may contain the following data for a single time/depth line coordinate:

  • No. (Index or ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.sss)
  • Data file (the name of the source raw data file)
  • Depth (m)
  • Status

Notes:

  • A raw line variable may have a related Position GPS fix variable.
  • Depth is referenced to the Z coordinate of the water level. Positive depths are reported for displacement below the water level.

Matrix data

Available for matrix variables. Each line in the table may contain the following:

  • No. (Ping index)
  • Date/time (yyyy-MMM-dd HH:mm:ss.sss)
  • Data file (the name of the source raw data file)
  • Start range (m)
  • Stop range (m)
  • Data points
  • Major beam count
  • Minor beam count
  • Total sample count
  • Major angle start (°)
  • Major angle stop (°)
  • Minor angle start (°)
  • Minor angle stop (°)

Notes:

Position GPS fixes

Available for a GPS fix variable. Each line in the table will contain the following data for a single position GPS fix:

  • No. (Index or ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.sss)
  • Data file (the name of the source raw data file)
  • Latitude (°)
  • Longitude (°)
  • Source (any NMEA GPS-fix letter groups identified by Echoview)
  • Status
  • Distance (nmi) (distance estimate between fixes is displayed and exported)

Notes:

Time series data

  • Heading data
  • Length data
  • Pitch data
  • Roll data
  • Speed data
  • Vessel logs
  • Virtual analysis data
  • Virtual calibration data
  • Virtual time series data

 

Available for a time series variable of supported data types. Each line in the table will contain the following data for a single determination of the data type:

  • No. (Index or ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.sss)
  • Data file (the name of the source raw data file)
  • Time series data name or time series as a Virtual time series, Virtual analysis data or virtual calibration data. Time series derived from data read from file may include:
    • Heading (°)
    • Length (m)
    • Pitch (°)
    • Roll (°)
    • Speed (m/s)
    • Distance (nmi) for vessel logs
    • Calibration
  • Status
Time series collection data

Available for a time series collection variable. The table shows one column per contained series, with a corresponding Status column for each series. Each row includes:

  • No. (Index or ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.ssss)
  • Data file (name of the source raw data file, if applicable)
  • Series value columns (one per contained series; header shows series name and unit when defined)
  • Status columns (one per series; refers to the series column immediately to its left)

Notes:

  • CSV-imported series with an undefined type show no units until extracted as a typed series via Time series select.
  • Standard no-data sentinels (e.g., -9.9e+37) display as no data.
  • If the collection has no measurements yet (e.g., source file not read), the table will be empty until data becomes available.
  • Data columns auto-size from their headers with a sensible minimum width.

This variable is used by the Time series select operator.

Time series scatter plot

Available for a time series scatter plot. The table shows one column per characteristic series with a corresponding Status column. Each row includes:

  • No. (Index or ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.ssss)
  • Data file (the name of the source raw data file, if applicable)
  • Time series first name column
  • Time series first name value column
  • First series Status column
  • Time series second name column
  • Time series second name value column
  • Second series Status column

Notes:

  • The table of a scatter plot shows the source time series collection for the scatter plot's time series.

Transect group

Double-click a transect group object to open the transect group table. Each row in the table defines a transect:

  • ID (An integer representing the index or transect number)
  • Name (A string—this is unique within the transect group)
  • Start time (yyyy-MM-dd HH:mm:ss.sss)
  • Stop time (yyyy-MM-dd HH:mm:ss.sss)
  • Notes (A string—your customized description)

Echoview includes the above fields in the *.transect.csv export.

Right-click to open the shortcut menu for options to:

Transmission time series data

Available for a virtual impedance statistic variable. Statistics are for a specified pair of impedance statistic and transducer component. Each line in the table will contain the following:

  • No. (Ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.sss)
  • Impedance statistic (Ohms)
  • Status

Transmission time series collection

Available for a transmission time series collection variable. The table shows one column per characteristic series with a corresponding Status column:

  • No. (Index or ping number)
  • Date/time (yyyy-MMM-dd HH:mm:ss.ssss)
  • Data file (name of the source raw data file, if applicable)
  • Time series value columns (one per contained series; header shows series name and unit (e.g., Ohms) when defined)
  • Status columns (one per series; refers to the series column immediately to its left)

Notes:

  • Undefined series display without units until extracted as a typed series.
  • Standard no-data values (e.g., -9.9e+37) display as no data.

This variable is used by the Transmission time series select operator.

Unspecified time series data

Unspecified time series variables are output by a Time series select operator that is configured to use an Unspecified data type. The data values are handled as unitless. Each line includes:

  • No. (Number of the interval)
  • Date/time (yyyy-MMM-dd HH:mm:ss.ssss)
  • Custom time series name
  • Status

Viewing a table

  1. Select the variable in the raw variables section of the Filesets window
  2. Click Table

- OR -

  1. On the View menu, point to Table
  2. Click the relevant variable

- OR -

  1. On the Dataflow window, click a variable and use Shortcut menu > Table

Notes:

  • When viewing large time series datasets, Echoview loads table rows asynchronously. This keeps the user interface responsive while data is processed and appended to the table.
  • For Time series collections, the Table view is the quickest way to validate all series at once (values, Status, and no-data handling) before extracting individual series for analysis.

Navigating to a table row

Click on a table to select it. Then press the Ctrl+G keyboard shortcut to open the Go To dialog box, and use it to specify a table row to navigate to.

Synchronizing a table with an echogram

Display a table next to the relevant cruisetrack or echogram. Double-click a table row to view the corresponding data point on the cruisetrack or echogram.

Exporting a table

On the Table menu, select an export item:

  • Export to CSV
  • Export to Matlab
  • Export to Echoview Data File Format
  • Export Complex to Matlab

See also

Exporting data