====== ODV Dataset ======

An ODV Dataset represents a group of ODV (One Dimensional Vertical) geophysical resistivity layer models. The dataset is defined with a query that consists of a rectangular extent, settings for data type, and optional SQL. ODV Datasets are used in the [[:geoscene3d:project_content:objects:odv_models:odv_models_1d_geophysics_object|]].

==== Source Types ====

[[:geoscene3d:project_content:sources:access_database_source|]] in [[:geoscene3d:project_content:dataformats:gerda_database_format|]]\\
[[:geoscene3d:project_content:sources:firebird_database_source|]] in [[:geoscene3d:project_content:dataformats:gerda_database_format|]]\\
[[:geoscene3d:project_content:sources:csv_file_source|]] (generic CSV file format)

When using a generic CSV file source it must be formatted as show here. The column names are identical to field names in the [[:geoscene3d:project_content:dataformats:gerda_database_format|]]. All columns are required but may be in any order. Corresponding table and field names from GERDA is shown in parenthesis in the field description below the example.<code>

NAME;IDENT;DATATYPE;DATSUBTYPE;MODEL;POSITION;XUTM;YUTM;ELEVATION;LAYER;RHO;THICKNESS;DEPTOP;DEPBOTTOM
Sounding1;LongNameForSounding1;tem;tem40;5424;1;572132;6216112;64.24;1;38;11.8;0;11.8
Sounding1;LongNameForSounding1;tem;tem40;5424;1;572132;6216112;64.24;2;19.9;14;11.8;25.8
Sounding1;LongNameForSounding1;tem;tem40;5424;1;572132;6216112;64.24;3;146.7;32.5;25.8;58.3
Sounding1;LongNameForSounding1;tem;tem40;5424;1;572132;6216112;64.24;4;8.7;;58.3;
Sounding2;LongNameForSounding2;tem;tem40;5425;1;572669;6216031;69.74;1;34.3;11.7;;11.7
Sounding2;LongNameForSounding2;tem;tem40;5425;1;572669;6216031;69.74;2;18.6;46.1;11.7;57.8
Sounding2;LongNameForSounding2;tem;tem40;5425;1;572669;6216031;69.74;3;2.5;;57.8;
Sounding3;LongNameForSounding3;tem;tem40;5426;1;572769;6216243;79.68;1;21.2;18.4;0;18.4
Sounding3;LongNameForSounding3;tem;tem40;5426;1;572769;6216243;79.68;2;33.1;44;18.4;62.4
Sounding3;LongNameForSounding3;tem;tem40;5426;1;572769;6216243;79.68;3;3.4;36.1;62.4;98.5
Sounding3;LongNameForSounding3;tem;tem40;5426;1;572769;6216243;79.68;4;1;;98.5;
Sounding4;LongNameForSounding4;tem;tem40;5427;1;572519;6216406;78.79;1;78.5;1.9;0;1.9
Sounding4;LongNameForSounding4;tem;tem40;5427;1;572519;6216406;78.79;2;26.2;59.9;1.9;61.8
Sounding4;LongNameForSounding4;tem;tem40;5427;1;572519;6216406;78.79;3;6.8;;61.8;
.
.
.

</code>

NAME: Short name of model (MODEL.NAME)\\
IDENT: Long dame of model (MODEL.IDENT)\\
DATATYPE: Primary datatype (ODVMODSE.DATATYPE)\\
DATSUBTYPE: Secondary datatype (ODVMODSE.DATSUBTYPE)\\
MODEL: Primary Model ID (ODVPOS.MODEL)\\
POSITION: Secondary Model ID in case the same model consists of multiple sub models (ODVPOS.POSITION)\\
XUTM: Easting (ODVPOS.XUTM)\\
YUTM: Northing (ODVPOS.YUTM)\\
ELEVATION: Model elevation (ODVPOS.ELEVATION)\\
LAYER: Model layer ID (ODVLAYER.LAYER)\\
RHO: Layer resistivity (ODVLAYER.RHO)\\
THICKNESS: Layer thickness (ODVLAYER.THICKNESS)\\
DEPTOP: Layer top depth (ODVLAYER.DEPTOP)\\
DEPBOTTOM: Layer bottom depth (ODVLAYER.DEPBOTTOM)

==== Configuration ====

Regardless of source an ODV Dataset is defined in the same way

__Fixed Extent:__ By default the dataset extent is identical to the current scene extent. However, this option makes it is possible to fix the extent to any area.\\
__Extent:__ Defines a rectangular area where data are extracted from the source.

**Model Selection ** \\
__Type:__ Data type, e.g., "PACES" or "TEM". This setting corresponds to the field ODVMODSE.DATATYPE in the GERDA Database\\
__Sub Type:__ Data sub type e.g., "TEM40" or "SKYTEM1". Used for data type "TEM" only. This setting corresponds to the field ODVMODSE.DATSUBTYPE in the GERDA Database\\
__Edition:__ Selection of all model edition or a specific model edition. This setting corresponds to the field MODEL.EDITION in the GERDA Database.\\
Note: Use following SQL to select more than one model edtion in SKYTEM data (In this dataset, the model edtions are numbered 3269, 3370 and 3391)

{{:geoscene3d:project_content:datasets:dc825e2b04d6bbc1fc9064e6607ca834.png}}

**Model Layers ** \\
__More Than____:__ Include models with more than this number of layers\\
__Less Than____:__ Include models with less than this number of layers

__Additional "WHERE" conditions (optional):__ The dataset may be refined further using SQL. This is an advanced option that can be used for users that has an in depth knowledge of the [[:geoscene3d:project_content:dataformats:gerda_database_format|]]. May also be used with the generic CSV format but field names in the SQL is of course limited to the fields present in the CSV File\\
__Preview SQL…:__ Shows a preview of the resulting query. Advanced users can use this option to analyze the resulting query.\\
__Preview Data…:__ Shows a preview of the data resulting from the query using the [[:geoscene3d:application:data_management:dataset_viewer|]].