Most people who have made maps with well data understand that there are at least 2 different versions of the latitude and longitude well coordinates available – one for the NAD83 datum and one for the NAD27 datum. What’s not always obvious is that in Western Canada, we also have different versions of the township grids as well and this can lead to many more different versions of the well coordinates. For example, we publish 4 different versions for Alberta in the CWD Express PPDM-371 well database. The reason for the different versions is so you can ensure that when well locations are drawn on a map, they can be matched up precisely with the survey grid version used on the map and know that they are in the right place. There can be significant differences between different grid versions and different datum’s and this can lead to incorrectly spotted wells if there is a mismatch between the well spots and the grid.

In Express, we use these tables to store the coordinates:

TABLE NAME |

WELL |

WELL_NODE |

WELL_NODE_VERSION |

WELL_NODE_M_B |

The WELL table has both bottom and surface coordinates for every well but there is no indication of the grid version or datum.

The WELL_NODE table contains the same set of coordinates that have been “promoted” to the well table along with complete details on the grid version and datum.

The WELL_NODE_VERSION table contains all of the available coordinate versions for every well, including calculated and government supplied coordinates.

To calculate the well coordinates, we use the surveyed township grids and the surveyed well metes and bounds measurements found in the WELL_NODE_M_B table, to precisely spot the surface and bottom well locations. When you combine these with the different geodetic datum’s and include the original coordinates supplied by the government, you can end up with a large number of versions.

To keep track of it all, we use a column named, “ACQUISITION_ID” to identify the source of the coordinates for every row in the WELL_NODE_VERSION table. Here’s a list of the ACQUISITION_ID’s used in the WELL_NODE_VERSION table for the western provinces.

ACQUISITION_ID |
COUNT(ACQUISITION_ID) |
PROVINCE |
DESCRIPTION |

GOVT_ATS41_NAD83 | 1175916 | AB | Govt supplied |

CALC_ATS41_NAD27 | 1176784 | AB | Calculated |

CALC_ATS41_NAD83 | 1176784 | AB | Calculated |

CALC_ATS26_NAD27 | 1176784 | AB | Calculated |

GOVT_PRB20_NAD83 | 21556 | BC | Govt supplied |

CALC_BCPNG_NAD27 | 62400 | BC | Calculated |

CALC_BCPNG_NAD83 | 62400 | BC | Calculated |

CALC_PRB20_NAD27 | 21564 | BC | Calculated |

CALC_PRB20_NAD83 | 21564 | BC | Calculated |

GOVT_PNG_NAD83 | 59814 | BC | Govt supplied |

CALC_MTS10_NAD83 | 22918 | MB | Calculated |

CALC_MTS10_NAD27 | 22918 | MB | Calculated |

CALC_STS25_NAD83 | 307004 | SK | Calculated |

GOVT_STS25_NAD83 | 307002 | SK | Govt supplied |

CALC_STS25_NAD27 | 307004 | SK | Calculated |

CALC_STS10_NAD27 | 307004 | SK | Calculated |

Here is an example query that will return all of the available locations for a specific well in Alberta.

SELECT

W.UWI,

WNV.NODE_OBS_NO,

WNV.NODE_POSITION,

WNV.ACQUISITION_ID,

WNV.LATITUDE,

WNV.LONGITUDE,

WNV.PREFERRED_IND

FROM

WELL W,

WELL_NODE_VERSION WNV

WHERE

W.UWI = ‘100092908909W500’

AND (W.BASE_NODE_ID = WNV.NODE_ID OR W.SURFACE_NODE_ID = WNV.NODE_ID)

The results are below. The preferred indicator, tells us which row has been promoted to both the WELL_NODE table and the WELL table.

UWI |
NODE OBS NO |
NODE POSITION |
ACQUISITION_ID |
LATITUDE |
LONGITUDE |
PREFERRED IND |

100092908909W500 | 1 | SURFACE | CALC_ATS26_NAD27 | 56.7503453 | -115.3889691 | |

100092908909W500 | 2 | SURFACE | CALC_ATS41_NAD27 | 56.7503453 | -115.388969 | |

100092908909W500 | 3 | SURFACE | CALC_ATS41_NAD83 | 56.7504514 | -115.3901795 | Y |

100092908909W500 | 4 | SURFACE | GOVT_ATS41_NAD83 | 56.750447 | -115.390184 | |

100092908909W500 | 1 | BOTTOM | CALC_ATS26_NAD27 | 56.7503453 | -115.3889691 | |

100092908909W500 | 2 | BOTTOM | CALC_ATS41_NAD27 | 56.7503453 | -115.388969 | |

100092908909W500 | 3 | BOTTOM | GOVT_ATS41_NAD83 | 56.750447 | -115.390184 | |

100092908909W500 | 4 | BOTTOM | CALC_ATS41_NAD83 | 56.7504514 | -115.3901795 | Y |

Here is the complete list of the CWD preferred Acquisition ID’s that are used in the WELL table for each province:

ACQUISITION_ID |
PROVINCE |

CALC_ATS41_NAD83 | AB |

CALC_BCPNG_NAD83 | BC |

CALC_PRB20_NAD83 | BC |

CALC_MTS10_NAD83 | MB |

CALC_STS25_NAD83 | SK |

There are cases where we will use the Government supplied versions of the well coordinates for the preferred well node instead of the calculated nodes. The CWD well spot calculator will compare the results of each calculation to check if the LSD and section number resulting from the calculation put the well in the same LSD and section number that are indicated by the well UWI. If they don’t match, then the Government supplied version of the coordinates are marked as the preferred nodes and are promoted to the WELL_NODE table and the WELL table.

Follow us on LinkedIn