The Alberta Well Locator Program is a data visualisation tool that allows the user to interact with BitCan’s directory of well sites. Given any input Unique Well Identifier (UWI), the web app maps the point of interest, calculates the distance between the input UWI and all existing well sites, and displays rock lithology, in-situ, and mechanical properties associated with each well.
Tools Used: Flask, Folium, Python (Pandas, NumPy), SQLite
Using Pandas and NumPy, I plotted the Alberta Dominion Land Survey Grid as a planar projection and utilized the Alberta Township System (ATS) version 4.1 (NAD83) dataset to convert the entire set of Unique Well Identifier Numbers to geographical coordinates. This mapping tool then computes the distance between well locations by applying the Haversine Formula for great-circle distance.
The input UWI is displayed as a blue marker and a circle with a radius representing 50 km on the map. Each green marker represents a well location from the database, the name is displayed when the user hovers over it.
| Map Tiles | Scrollable Popup |
|---|---|
 |
 |
| Feature | Description |
|---|---|
| Distance | Distance between searched UWI and the well, measured in kilometers. |
| Depth | Data entries are sorted in ascending order based on depth. |
| Rock Lithology | Rock type, description, and additional notes |
| In-Situ | Stress (minimum and maximum horizontal stress, vertical stress), temperature, and pore pressure. |
| Mechanical Properties | Static (Young’s modulus, Bulk’s modulus, Shear modulus, Poisson’s ratio, cohesive strength, friction angle), and dynamic (P-wave, S-wave). |
The Alberta Well Locator Program uses a SQLite file database which is connected to the front-end of the web application. From the front end you can interact with the database in the following ways:
- View BitCan’s directory of well locations
- Add new well locations
- Add/Edit/Delete properties of each well location
Expanding the Well Locator to BitCan's well sites in an Indonesia-based project. Tasks
- Find comprehensive geographical coordinate dataset to create planar model of Indonesia
- Work with stakeholders to determine well properties of interest
- Develop tangential mapping tool