IGDS is a dataset from the Alberta Energy Regulator that provides reservoir attributes for over 368k wells in Alberta. As of the April 2017 release of Express Wells, we have loaded the IGDS data into the Zones and Interpretations subject area of the Express Wells PPDM model. This data set is available to all Express Wells subscribers at no additional cost.
Here are the tables that are used for this subject area.
|Tables Used for the IGDS data||Example Values|
|WELL_PAYZONE||Defines well, pay zone type and formation|
|WELL_POROUS_INTERVAL||Formation, Top and base depths for porous intervals|
|WELL_ZONE_INTERVAL||Top and base depths for each zone|
|WELL_ZONE_INTRVL_VALUE||List of 8.8 Million interval values for Alberta|
|ZONE||Zone names for 7073 defined IGDS zones for Alberta|
|R_CWD_WELL_ZONE_INT_VALUE||Reference table for types of values such as POROSITY_AVERAGE, POROSITY_CUTOFF|
|R_PAYZONE_TYPE||Reference table for pay zone types: OILSANDS or CONVENTIONAL|
There are quite a few useful attributes here, all of which have been picked by AER staff geologists, including the following:
- zone tops and bases for production or potentially productive zones
- porosity top and base of pay
- fluid interface depths if present
- net and gross pay thicknesses
- average porosity and water saturation values
- porosity and permeability cutoffs
- water resistivity where available
We can query for any specific formation and value type using a query like this:
su.LONG_NAME as FORMATION,
from well w,
and z.zone_id = wzi.ZONE_ID
and wzi.UWI = wziv.UWI
and wzi.INTERVAL_ID = wziv.INTERVAL_ID
and wzi.ZONE_ID = wziv.ZONE_ID
and wpz.UWI = wzi.UWI
and wpz.zone_id = wzi.ZONE_ID
and wpz.ZONE_ID = z.ZONE_ID
and wziv.CWD_VALUE_TYPE = ‘POROSITY_AVERAGE’
and wpz.BASE_STRAT_UNIT_ID = su.STRAT_UNIT_ID
and wpz.STRAT_NAME_SET_ID = su.STRAT_NAME_SET_ID
and su.LONG_NAME = ‘MONTNEY’
and wziv.PARAMETER = ‘GAS PAY’
order by uwi, interval_id
The key terms in this query are as follows:
The formation name which is specified by the su.long_name is set to MONTNEY in this example
The wziv.parameter which is set to GAS PAY
The wziv.CWD_VALUE_TYPE is set to POROSITY_AVERAGE.
This combination will return all of the average porosity values picked for Alberta Montney gas wells – about 2000 in total.
I’ve used the results of the above query with Surfer to map assigned pay and average porosity in the example images below.
Here is an example where the CWD_VALUE_TYPE = ‘TOTAL_ASSIGNED_PAY’
Here is another example where the CWD_VALUE_TYPE = ‘POROSITY_AVERAGE’
As always, feel free to copy and use queries from any of these posts but remember that WordPress has a tendency to change the single quotes on you when you copy it. A little editing of the quotes is all you should need to make these queries work for you.