Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| tutorials:adddata:welltab [2020/01/14 12:44] – [Step 1. Work flow In GeoScene3D] gs3d | tutorials:adddata:welltab [2020/03/25 11:09] (current) – removed gs3d | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Adding Wells From Files or Tabular Data ====== | ||
| - | |||
| - | This tutorial describes how to use import well data from various tabular (simple column) data sources like a comma separated file (CSV), tabular data, a view in a database (Access, Firebird, SQL Server, Oracle) etc. The tutorial starts with a small introduction of well data in the program, and then explains how to use the “Add Data Wizard” to import your well data. | ||
| - | |||
| - | ==== Requirements ==== | ||
| - | |||
| - | === Module === | ||
| - | |||
| - | === Data === | ||
| - | |||
| - | ==== Background: Well data in GeoScene3D ==== | ||
| - | |||
| - | **Layer Data**: Well Key, Layer Index, X, Y, Elevation, | ||
| - | **Water Levels**: Well Key, (Water Level Index), Water Level, (Time of Measurement), | ||
| - | **Filters**: | ||
| - | **Inclinations**: | ||
| - | |||
| - | {{: | ||
| - | **<font inherit/ | ||
| - | |||
| - | In GeoScene3D it is possible to link to data sources in many different formats which in combination constitute a dataset. Figure 1 shows the structure of a well dataset. It is comprised of 4 individual tabular data sources. All non-optional data links to the layer data – and position - by the well key. The optional position information in the optional data is used to filter on extent and is useful when handling very large data sets having a very large area, e.g. nation scale data sources. | ||
| - | |||
| - | **Layer Data**: The primary and mandatory data set. It holds definitions of the position of the well data and the individual layers and a key to be used in a legend symbol to color and identify the layer type.\\ | ||
| - | **Water Levels**: Optional data. Holds information on water level.\\ | ||
| - | **Filters**: | ||
| - | **Inclinations**: | ||
| - | |||
| - | {{: | ||
| - | **<font inherit/ | ||
| - | |||
| - | {{: | ||
| - | **<font inherit/ | ||
| - | |||
| - | Only “Layer Data” is mandatory, the other data sources are optional. The underlying data sources can be e.g. simple CSV files as shown in Figure 2. It can also be a set of tables, or even views, in a database, as shown in Figure 3. The sources can be combined as you please, importing e.g. Layer Data from a table in a database and inclinations from a CSV file. | ||
| - | |||
| - | |||
| - | ==== Step 2. Result ==== | ||
| - | |||
| - | 1. A new dataset has now been created in GeoScene3D, along with link to data sources and a new 3D object.\\ | ||
| - | 2. If data do not appear in the 3D window, right click on data, "Me New Wells" in the “Object manager’” and choose "Move camera to object position" | ||
| - | |||
| - | |||
| - | ==== Step 2. Result ==== | ||
| - | |||
| - | 1. A new dataset has now been created in GeoScene3D, along with link to data sources and a new 3D object.\\ | ||
| - | 2. If data do not appear in the 3D window, right click on data, "Me New Wells" in the “Object manager’” and choose "Move camera to object position" | ||
| - | |||