One of CWD’s optional datasets is the Directional Survey data that is available with Express Wells. If you subscribe to the ‘Enhanced’ version, the two directional survey tables will be populated with over 90,000 surveys. The tables I’m talking about are part of the PPDM 371 model – WELL_DIR_SRVY and WELL_DIR_SRVY_STATION.
Another component of the Express Wells Enhanced database is the spatial data which is separate from the relational component. The Enhanced version includes a layer called ‘can_well_dir_srvy’. This is used to show the true borehole deviation paths on a map in a GIS system by projecting each X,Y survey point onto the surface. What is not obvious however, is that this layer also contains the TVD elevations for each survey point stored as Z values.
We use QGIS internally to view and check our spatial layers but QGIS doesn’t include a tool like ArcScene that can be used to render 3d objects. For those that aren’t familiar with QGIS, it’s a very powerful open source GIS system that’s freely available for download. You can get a copy of it here:
One of the great things about QGIS is that because it’s open, it can be extended with plugins. It turns out that there is a 3D rendering plugin available called QGIS2threejs. After installing this plugin I was able to render the directional boreholes in 3d with fairly impressive results.
Here is a fairly standard map view of an area in NW Alberta with horizontal wells drilled into the Montney Fm.
Fig 1. Standard Map View
The Qgis2threejs plugin will allow you to render and export terrain and vector data to a standard web browser so long as it supports WebGL The scene in the browser is fully interactive, allowing you to pan, zoom, rotate and even select objects to view their attributes.
The image below shows the scene rotated down toward the front and shows the extents of the boreholes below the surface which has also been rendered.
Fig 2. 3D Boreholes with Surface
For the third image, I generated a surface grid in Surfer using Montney formation picks and converted it to a DEM file that could be viewed and rendered in QGIS. This image shows the geometry of the horizontal boreholes as they penetrate the Montney Fm.
Fig 3. 3D Boreholes with Montney
Qgis2threejs is maintained by Minoru Akagi. It is very well documented and appears to be updated on a regular basis. You can install it in QGIS using the built in Plugins menu and user help can be found here:
For more information on the Express Wells Enhanced database, contact CWD at 403-457-4315