Exporting matrix variable data
Matrix data may be exported to a CSV file. The file can't be added to a fileset or imported by Echoview. Note, the output file may exceed the data limits of third party viewing applications. Excel has a larger grid limit for its .xlsx file format and the internet documents workarounds for handling very larger CSV files.
Dataflow window
Select the matrix variable, right-click and on the Shortcut menu, select Export, Data Values...
Table window
Select the matrix variable table, on the Table menu, select Export to CSV...
Notes:
- Raw matrix variables can only be displayed as a general summary table. Column headings will thus be different from those displayed from exporting matrix variable data from the Dataflow and Table windows.
- Export to CSV... is subject to the same exclusions and thresholding as single beam and multibeam CSV exports.
CSV file format
Each row of data represents sample information for the selected matrix pings.
Data type |
File extension |
Sv pings matrix formed beams |
*.sv.mmb.csv |
TS pings matrix formed beams |
*.ts.mmb.csv |
angular position pings matrix formed beams |
*.angle.mmb.csv |
unspecified dB pings matrix formed beams |
*.db.mmb.csv |
The header row includes headers for:
Header |
Description |
Ping_index |
Sequential ping number Note: Echoview numbers pings sequentially beginning with 0 for the first ping in an echogram. |
Distance_gps |
Distance (nmi) from the first GPS fix in the data file. |
Distance_vl |
Distance (nmi) traveled according to the vessel log at the time the ping was transmitted. |
Ping_date |
dd/mm/yyyy for the segment. |
Ping_time |
HH:mm:ss for the segment. |
Ping_milliseconds |
The millisecond (0.999) at which the ping was transmitted. |
Latitude |
The latitude (degrees) of the GPS antenna at the time the ping was transmitted. |
Longitude |
The longitude (degrees) of the GPS antenna at the time the ping was transmitted. |
Heading |
The heading of the platform at the time the ping was transmitted Note: Heading values are taken from the heading variable selected on the Attitude page of the Platform Properties dialog box. |
Range_start |
Range (m) of the nearest sample in the ping (measured along the beam-axis). |
Range_stop |
Range (m) of the farthest sample in the ping (measured along the beam-axis). |
Number_of_beams |
Number of beams in this ping. |
Number_of_beams_minor |
Number of beams along the minor sector. |
Samples_per_beam |
Number of samples in each beam of this ping. |
Ping_mode |
A number identifying the ping mode. |
Variable_name |
The name of the variable which was exported. |
Angular_width_major |
The angular distance (°) between the clockwise edge of the first beam and the counterclockwise edge of the last beam in the major sector at a minor angle of zero. |
Angular_width_minor |
The angular distance (°) between the clockwise edge of the first beam and the counterclockwise edge of the last beam in the minor sector at a major angle of zero. |
| Datafile_ping_number | The number, if any, assigned to the ping in the original data file from which Echoview read the data. |
List of data values Note: No title in the header row of the file
|
On the remainder of this line, the data values for each sample are structured sequentially per sample, per minor beam index, per major beam index. Example: Consider a ping with 4 samples, 3 minor beams and 2 major beams, indexed as {sample_index, minor_index, major_index}. The resulting output order is as follows: {0,0,0} {0,0,1} {0,1,0} {0,1,1} {0,2,0} {0,2,1} {1,0,0} ... {3,0,0} {3,0,1} {3,1,0} {3,1,1} {3,2,0} {3,2,1}
|