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 odv_models_1d_geophysics_object.

Access Database Source in gerda_database_format
Firebird Database Source in gerda_database_format
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 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.

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;
.
.
.

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)

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)

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 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 Dataset Viewer.