A Jupiter Wells Dataset represents a group of wells. The dataset is defined with a query that consists of a rectangular extent and optional SQL. Wells Datasets are used in the Wells Object.
Access Database Source in Jupiter Database Format.
Access Database Source in Jupiter Generic Database Format (generic well database format).
CSV File Source (generic CSV file format, layers only).
When using a generic CSV file source it must be formatted as show below. The column names are identical to field names in the Jupiter Database format. All columns are required but may be in any order. Corresponding table and field names from Jupiter is shown in parenthesis in the field description below the example. NOTE: Only layers are supported with the CSV format
BOREHOLENO;ELEVATION;XUTM;YUTM;SAMPLENO;TOP;BOTTOM;ROCKSYMBOL 89.63;70.5;570729;6217334;1;0;33.9;b 89.63;70.5;570729;6217334;2;33.9;36.4;s 89.63;70.5;570729;6217334;3;36.4;41;l 89.63;70.5;570729;6217334;4;41;45;s 89.63;70.5;570729;6217334;5;45;50;g 89.63;70.5;570729;6217334;6;50;51;l 89.65;77.5;567911;6218234;1;0;25;l 89.65;77.5;567911;6218234;2;25;26.5;g 89.65;77.5;567911;6218234;3;26.5;29;s 89.65;77.5;567911;6218234;4;29;35;l 89.65;77.5;567911;6218234;5;35;43;g 89.65;77.5;567911;6218234;6;43;43.5;l 89.65;77.5;567911;6218234;7;43.5;50;s 89.83B;47.5;573321;6215967;1;0;3;g 89.83B;47.5;573321;6215967;2;3;3.5;l 89.83B;47.5;573321;6215967;3;3.5;14.5;s 89.83B;47.5;573321;6215967;4;14.5;17;l 89.84B;64;570678;6217457;1;0;4;l 89.84B;64;570678;6217457;2;4;7.5;l 89.84B;64;570678;6217457;3;7.5;14;g 89.84B;64;570678;6217457;4;14;24;l 89.84B;64;570678;6217457;5;24;42;gl 89.84B;64;570678;6217457;6;42;63;gs 89.84B;64;570678;6217457;7;63;64;gl . . .
BOREHOLENO: Primary unique well ID [String] (BOREHOLE.BOREHOLENO)
ELEVATION: Well elevation [Float] (BOREHOLE.ELEVATION)
XUTM: Well easting [Float] (BOREHOLE.XUTM)
YUTM: Well northing [Float] (BOREHOLE.YUTM)
SAMPLENO: Layer ID [Integer] (LITHSAMP.SAMPLENO)
TOP: Layer top depth [Float] (LITHSAMP.TOP)
BOTTOM: Layer bottom depth [Float] (LITHSAMP.BOTTOM)
ROCKSYMBOL: Layer lithology. This string must correspond to the CODE field when loading color symbols using the Lithology Editor [String] (LITHSAMP.ROCKSYMBOL)
Regardless of source type the following configuration is required. The Wells Dataset dialog sets up a query that is used to extract wells from the source.
Extent
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.
Additional “WHERE” conditions (optional)
The wells dataset may be refined further using SQL. This makes it possible to use regular SQL to query the source within the extent. This is an advanced option that can be used for users that has an in depth knowledge of the source format.
Example 1: Include only wells deeper than 50 meters.
BOREHOLE.DRILLDEPTH > 50
Example 2: Include only wells deeper than 50 meters and at a location with an elevation of more than 70 meters.
BOREHOLE.DRILLDEPTH > 50 AND BOREHOLE.ELEVATION > 70
Preview Buttons
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.