Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| geoscene3d:toolbox:toolbox_imports:import_csv_file_to_grid [2020/02/17 16:58] – created rebecca130301_gmail.com | geoscene3d:toolbox:toolbox_imports:import_csv_file_to_grid [2023/03/22 17:29] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| 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. | 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. |
| - | Important: __ | + | ==== Import File Formats ==== |
| - | 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, | 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, | ||
| Line 51: | Line 47: | ||
| </ | </ | ||
| - | ==== | ||
| - | Input Text Files ==== | ||
| - | Settings for the input text files. X, Y, Z, and Value columns are selected from the first file in the list. | + | ==== Irregular geometry of import file ==== |
| + | If the text file have an irregular geometry (e.g. increasing with a factor for each step in depth), then the value of the 3d grid is determined | ||
| + | Whenever a point in the textfile is present within the volume of a single cell, the value will override the previous value. The 3D grid will therefore show the value of the last point present within the 3D space of that cell during the iteration. | ||
| - | __ | ||
| - | 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 | ||
| - | ==== | + | ==== Input Text Files ==== |
| - | Destination Grid 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: | ||
| + | __Decimal Separator: | ||
| + | ==== Destination Grid Files ==== | ||
| Output files are automatically named *.grd for 2D grids and *.grd3 for 3D grids. | Output files are automatically named *.grd for 2D grids and *.grd3 for 3D grids. | ||
| - | ** | + | **Grid Geometry ** \\ |
| - | 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.\\ |
| - | 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.\\ |
| - | __X Spacing:__ | + | __Y Spacing:__ Horizontal destination grid Y spacing.\\ |
| - | Horizontal destination grid X spacing. \\ | + | __Z Spacing:__ Vertical destination grid Z spacing. 3D grids only. |
| - | __Y Spacing:__ | + | |
| - | Horizontal destination grid Y spacing. \\ | + | |
| - | __Z Spacing:__ | + | |
| - | Vertical destination grid Z spacing. 3D grids only. | + | |
| - | ** | + | **3D Grid Format ** \\ |
| - | 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. | 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 ** \\ |
| - | 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. |
| - | __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. | + | |