A Python script was used to run an SQL query on the AER corporate data holdings and perform basic data formatting and filtering. The conditions and filters used were as follows:
- Gas tests from wells containing the words 'MONTNEY', 'DOIG', 'BELLOY', or 'TRIASSIC' in their Well Licence Purpose field.
- Any tests from wells with confidential status were removed.
- Any tests with null values in the Reported H2S field were removed.
- Wells that are injection or observation wells based on the Well Licence Purpose or Type fields were removed.
- Samples based on recombination of fluids were removed.
- Any tests with quality flagged as Poor were removed.
- Samples from wells south of 52.5 degrees N latitude were removed.
- Samples from east of 115.2 degrees W longitude were removed.
- Samples with a base depth of less than 1000 m were removed.
- Samples from east of 115.2 degrees W longitude were removed.
- Samples with a tested interval base depth of less than 1000 m were removed.
These operations produced a total of 17 434 gas analysis tests associated with 5100 unique well identifiers (UWIs).