Exporting data or underlying data

The data values exported will depend on the type of variable from which you are generating the export, e.g. Sv values will be exported from an Sv variable, TS values from a TS variable. Underlying data values exported will depend upon the file format and what is stored in the data file.

All values are exported with one ping per line in a file of comma separated values file (*.csv)

Notes:

To export data values for a Dataflow object

  1. On the Dataflow window, click an object, on the right-click menu click Export, Data Values...
  2. Specify a ping range to export, click Export.
  3. Choose a folder and enter a file name.
  4. Click Save.

To export data and underlying data from single beam, split beam or dual beam variables

To export data values or underlying data for an entire echogram:

  1. On the Echogram menu, point to Export, and then click Value... or Underlying data...

  2. Choose a folder and enter a file name.

  3. Click Save.

To export data values or underlying data from a selection:

  1. Make a selection using the Vertical band tool vertical selection tool.

  2. On the Shortcut menu (right-click), point to Export Selection, and then click Value... or Underlying data...

  3. Choose a folder and enter a file name.

  4. Click Save.

To export data values from a region:

  1. Select the region.

  2. On the Shortcut menu (right-click), point to Export Region, and then click Value...

  3. Choose a folder and enter a file name.

  4. Click Save.

Note: The longitude and latitude values that are exported are the longitude and latitude of the GPS antenna at the time the ping was transmitted, see What is affected by transducer geometry for more information.

To export data and underlying data from multibeam variables

You can export the following values for all pings or a selection of pings:

Note: Underlying values cannot be exported from variables that were beamformed in Echoview.

To export data values from a multibeam echogram:

  1. On the Echogram menu, point to Export, and then click Underlying data..., Value... or Bottom detections...

  2. On the Export Underlying Data dialog box, Export Variable Data dialog box or Export Multibeam Bottom Detections dialog box, select All, or Ping range to enter the pings for which you want to export values.

  3. If you selected Ping range, enter the first and last ping for the range over which you want to export values.

  4. Click Export.

  5. Choose a folder and enter a file name for the export file.

  6. Click Save.

Notes:

Echogram data export file formats (*.csv)

Data values (Sv values, TS values, dB values, linear values, Boolean values, angular positions, color values, Power values) can be exported from echograms to .csv files.

The first line of the .csv file lists the names of the variables that are exported (these will be used as column headings if the file is loaded into a spreadsheet program). No column heading is provided for the list of data values. Each subsequent line contains the value for each variable for a single ping and the data value for each sample in the ping.

Single beam, split beam and dual beam data value exports

Data can be exported for an entire echogram, a region, or a selection made using the vertical band tool vertical selection tool. The following data are exported.

Variable

Description

Ping_index

Sequential ping number

Note: Echoview numbers pings sequentially beginning with 0 for the first ping in an echogram.

Distance_GPS

nmi

Distance_vl

nmi

Ping_date

yyyy-mm-dd

Ping_time

hh:mm:ss

Ping_milliseconds

ms

Latitude

degrees

Longitude

degrees

Depth_start

m

Depth_stop

m

Range_start

m

Range_stop

m

Sample_count

Number of samples to follow

List of data values

Data value for each sample (separated by commas)

 

Note: For "color" variables, the red, green and blue color intensities of each data point are exported as a single number. The exported number is a decimal representation of a six digit hexadecimal number 'bbggrr'; where 'bb' represents the intensity (0-255) of blue, 'gg' represents the intensity of green and 'rr' represents the intensity of red.

Notes:

Multibeam data value exports

Data values from all types of multibeam variable can be exported to .csv files. The export can be for an entire echogram or for a range of pings selected from the Export Data - Select Range of Pings for Export dialog box.

The first line of the file is a header row that contains the names of the variables that are exported (see below). The remaining lines contain the corresponding variables for a single ping.

Variable

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

The date (yyyy-mm-dd) on which the ping was transmitted

Ping_time

The time (hh:mm:ss) at which the ping was transmitted

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)

Sector_angle

Angle (degrees) scribed between the outer edges of the two outer beams.

Number_of_beams

Number of beams in this ping

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.

Full_sector_angle

The description of a beam subset.

Full_sector_beam_count

First_beam_number

Tilt_angle

The tilt angle of the beam.

Bearing_angle

The bearing angle of the beam.

Datafile_ping_number

The number, if any, assigned to the ping in the original data file from which Echoview read the data.

List of datafile values

If and only if data is being exported from a raw variable of ping mode 3, 4 or 5 (H-, V-, S-mode) in Furuno .fsv files then certain values read from the data file will be exported here in a series of columns headed "datafile_X" where X is the name of the variable in the data file.

Note: The Furuno FSV 30 (Research version) data format is not supported in Echoview 5.0.

Target_lock_beam

The number of the beam in the beam in the target-locked variable if any.

Note: This is only exported from variables with ping mode 3 or 4 (H- or V- mode).

Ping_group

A number identifying the ping group .

Note: This is only exported from variables with ping mode 3 or 4 or 5 (H- or V- or S- mode).

List of data values

Note: No title in the header row of the file

On the remainder of this line, the data value for each sample arranged as follows (for x+1 samples and y+1 beams):

<beam0 sample0>, <beam1 sample0> ... <beamy sample0>,

<beam0 sample1>, <beam1 sample1> ... <beamy sample1>,

...

<beam0 samplex>, <beam1 samplex> ... <beamy samplex>

Notes:

  • For "multibeam color" variables, the red, green and blue color intensities of each data point are exported as a single number. The exported number is a decimal representation of a six digit hexadecimal number 'bbggrr'; where 'bb' represents the intensity (0-255) of blue, 'gg' represents the intensity of green and 'rr' represents the intensity of red.

  • For "multibeam boolean" variables, each data point is represented by 0 or 1 (for false and true respectively)

Notes:

Data type

File extension

magnitude (raw - not beamformed)

.csv+

phase (raw - not beamformed)

.csv

magnitude (beamformed)

.mag.mb.csv+

phase (beamformed)

.phase.mb.csv

angular position pings (formed beams)

.angle.mb.csv

Sv

.sv.mb.csv+

unspecified dB

.db.mb.csv

TS

.ts.mb.csv

Boolean

.boolean.mb.csv

color

.color.mb.csv

+Sv and magnitude variables may also be exported in MATLAB format (*.mat) .

See also

Exporting data values
Text data files

Underlying data export file formats (*.csv)

Underlying data can be exported to .csv files from most Echograms (a notable exception is variables produced by Echoview's beamformer).

Single beam, split beam and dual beam underlying data exports

Underlying data values from Sv, TS, angular position variables can be exported to .csv files. The export can be for an entire echogram or a selection made using the vertical band tool vertical selection tool.

The first line of the .csv file lists the names of the six data properties that are exported (these will be used as column headings if the file is loaded into a spreadsheet program). No column heading is provided for the list of data values. Each subsequent line contains the value for each variable for a single ping and the underlying data value for each sample in the ping.

The following data are exported.

Data property

Description

Ping_index

Sequential ping number

Note: Echoview numbers pings sequentially beginning with 0 for the first ping in an echogram.

Depth _start

m

Depth _stop

m

Range_start

m

Range_stop

m

Sample_count

Number of samples to follow

List of data values

Sample values (separated by commas)

Notes:

Multibeam underlying data exports

Underlying data values from all multibeam variables not formed by Echoview's beamformer can be exported to .csv files. The export can be for an entire echogram or for a range of pings selected from the Export Underlying Data - Select Range of Pings for Export dialog box.

The first line of the .csv file lists the names of the six data properties that are exported (these will be used as column headings if the file is loaded into a spreadsheet program). No column heading is provided for the list of data values. Each subsequent line contains the value for each variable for a single ping and data values for each sample in the ping.

Data property

Description

Ping_index

Sequential ping number

Note: Echoview numbers pings sequentially beginning with 0 for the first ping in an echogram.

Range_start

m

Range_stop

m

Sector_angle

The angle of the sample from the transducer axis

Number_of_beams

The number of beams in the multibeam echogram.

Samples_per_beam

Number of samples per beam in the echogram.

List of data values

Note: No title in the header row of the file

Depending on the variable and echosounder from which the data was collected, data may consist of:

  • magnitude data: signal strength of each sample.

  • amplitude and phase data: alternating magnitude and phase information for each sample.

  • in-phase and quadrature data: alternating in-phase and quadrature components of the complex voltage signal for each sample. The signal magnitude is the square root of the sum of the component squares and the phase is the trigonometric tangent of the quadrature to in-phase component ratios.

To determine which format your echosounder stores, see Echosounder data files

The data values are ordered as follows:

each line contains the sample values for a whole ping. If the ping data is seen as a matrix with one column per beam and one row per distinct sample range, then the data are written one row at a time to the data file (on the one line). If the data are complex then the values are further, written as pairs (in-phase and quadrature values or magnitude and phase values respectively).

Thus, samples are ordered from lowest range across each beam, i.e. they are reported in the following order:

range0-beam0, range0-beam1, ... range0-beamN,
range1-beam0, range1-beam1, ... range1-beamN,
range2-beam0, range2-beam1, ... range2-beamN,
rangeM-beam0, rangeM-beam1... rangeM-beamN for N-1 beams and M-1 ranges.  

Notes:

See also

About exporting data