Import CSV File To Grid

With this dialog multiple delimited text files (*.csv, *.txt) can be imported to 2D and 3D grid files compatible with GeoScene3D. 2D grids are imported to Surfer Binary format (*.grd), and 3D grids are imported to GeoScene3D grid format (*.grd3). 3D grids may be imported as both floating point and discrete grids for voxel modeling.

Important: X, Y, Z, and Value columns are selected from the first file in the list. When importing multiple files all files MUST contain these columns.

==== Import File Formats ====

All source text files must include a header line containing column names, and all files must contain columns for X, Y, and Z. 3D grid text files must also contain a Value column. Furthermore, the text files must contain a regular grid with constant grid node spacing.
Grid nodes containing blank or null values does not have to be present in the file. However, the exported grid extent is automatically estimated from min and max of the grid nodes present in the imput files.

Example 2D CSV File (Z = grid node elevation at position X, Y):

X;Y;Z
567000.0;6210000.0;1.75095
567050.0;6210000.0;5.44045
567100.0;6210000.0;16.77625
.
.
567000.0;6210000.0;5.75095
567000.0;6210050.0;15.44045
567000.0;6210100.0;25.77625
.
.

Example 3D CSV File (Value = node value at position X, Y, Z):

X;Y;Z;Value
567000.0;6210000.0;0.0;1.234
567050.0;6210000.0;0.0;3.134
567100.0;6210000.0;0.0;2.123
.
.
567000.0;6210000.0;0.0;5.435
567000.0;6210050.0;0.0;7.254
567000.0;6210100.0;0.0;1.253
.
.
567000.0;6210000.0;0.0;2.123
567050.0;6210000.0;5.0;5.321
567100.0;6210000.0;10.0;2.234
.
.

==== Input Text Files ====

Settings for the input text files. X, Y, Z, and Value columns are selected from the first file in the list.

X Field: Name of column containing X coordinate
Y Field: Name of column containing Y coordinate
Z Field: Name of column containing Z coordinate
Value Field (3D grids): Name of column containing value for coordinate. NOTE: when selecting a value field the output grid will be a 3D grid. Do not select a value field for 2D Grids.
Delimiter: Column delimiter character
Decimal Separator: Decimal character

==== Destination Grid Files ====

Output files are automatically named *.grd for 2D grids and *.grd3 for 3D grids.

Grid Geometry
Destination grid node spacing. X and Y spacing must be identical. In most cases the spacing should be set to the same as in the source CSV file. If set to a value different from the actual spacing in the CSV file a re sampling we be done during the import.
X Spacing: Horizontal destination grid X spacing.
Y Spacing: Horizontal destination grid Y spacing.
Z Spacing: Vertical destination grid Z spacing. 3D grids only.

3D Grid Format
Select output format for destination 3D grid. Use floating point types for grids representing a single value varying in 3D space. Use discrete value types for categorized values, e.g., lithology.

3D Grid Value Override
Override Value From File With This Value: If checked this value will be used instead of the value read from the value column in the CSV file.