{"data":[{"id":"ath-aurora","name":"Aurora North","formation":"McMurray","region":"Athabasca","status":"Producing","operator":"Northern Horizon","licenseHolder":"Northern Horizon Resources Ltd.","areaKm2":184,"depthM":320,"thicknessM":38,"porosity":0.32,"permeabilityMd":4200,"oilInPlaceMMbbl":1685,"reservesMMbbl":910,"recoveryFactor":0.54,"productionBpd":145000,"historicalPeakBpd":152000,"remainingLifeYears":28,"capexMM":8400,"opexPerBbl":25,"transportPerBbl":6.5,"processingPerBbl":4.2,"carbonKgPerBbl":74,"royaltyRate":0.09,"latitude":57.25,"longitude":-111.25,"pipelineKm":42,"powerMwAvailable":520,"powerMwRequired":410,"roadAccess":"Highway","nearestPipeline":"Athabasca Trunk","exportRoute":"Edmonton hub → export terminals","storageMbbl":2.4,"risk":{"commodity":28,"construction":18,"political":22,"regulatory":24,"market":30,"carbon":42,"infrastructure":20},"employment":4200,"capitalBreakdown":{"drilling":0.18,"facilities":0.34,"upgrading":0.22,"roads":0.06,"camps":0.05,"pipelines":0.15},"opexBreakdown":{"steam":0.28,"electricity":0.12,"naturalGas":0.18,"labour":0.16,"maintenance":0.12,"chemicals":0.08,"water":0.06}},{"id":"cl-ember","name":"Ember Lake","formation":"Clearwater","region":"Cold Lake","status":"Approved","operator":"Prairie Basin","licenseHolder":"Prairie Basin Energy Inc.","areaKm2":96,"depthM":450,"thicknessM":22,"porosity":0.28,"permeabilityMd":1800,"oilInPlaceMMbbl":900,"reservesMMbbl":280,"recoveryFactor":0.31,"productionBpd":42000,"historicalPeakBpd":0,"remainingLifeYears":22,"capexMM":1870,"opexPerBbl":19,"transportPerBbl":8.2,"processingPerBbl":3.1,"carbonKgPerBbl":39,"royaltyRate":0.075,"latitude":54.65,"longitude":-110.1,"pipelineKm":18,"powerMwAvailable":180,"powerMwRequired":95,"roadAccess":"All-season","nearestPipeline":"Cold Lake Lateral","exportRoute":"Hardisty hub","storageMbbl":0.6,"risk":{"commodity":32,"construction":35,"political":18,"regulatory":28,"market":34,"carbon":26,"infrastructure":22},"employment":980,"capitalBreakdown":{"drilling":0.32,"facilities":0.28,"upgrading":0.05,"roads":0.08,"camps":0.07,"pipelines":0.2},"opexBreakdown":{"steam":0.22,"electricity":0.1,"naturalGas":0.14,"labour":0.2,"maintenance":0.14,"chemicals":0.12,"water":0.08}},{"id":"pr-cascade","name":"Cascade Creek","formation":"Peace River Oil Sands","region":"Peace River","status":"Planned","operator":"West Frontier","licenseHolder":"West Frontier Developments LP","areaKm2":142,"depthM":580,"thicknessM":26,"porosity":0.26,"permeabilityMd":950,"oilInPlaceMMbbl":1090,"reservesMMbbl":470,"recoveryFactor":0.43,"productionBpd":68000,"historicalPeakBpd":0,"remainingLifeYears":26,"capexMM":4240,"opexPerBbl":28,"transportPerBbl":11.8,"processingPerBbl":5.4,"carbonKgPerBbl":67,"royaltyRate":0.09,"latitude":56.55,"longitude":-117.1,"pipelineKm":126,"powerMwAvailable":90,"powerMwRequired":210,"roadAccess":"Seasonal","nearestPipeline":"Peace Connector (proposed)","exportRoute":"Northwest pipeline / rail hybrid","storageMbbl":0.35,"risk":{"commodity":40,"construction":55,"political":30,"regulatory":38,"market":44,"carbon":48,"infrastructure":62},"employment":1650,"capitalBreakdown":{"drilling":0.24,"facilities":0.3,"upgrading":0.1,"roads":0.12,"camps":0.09,"pipelines":0.15},"opexBreakdown":{"steam":0.3,"electricity":0.14,"naturalGas":0.16,"labour":0.15,"maintenance":0.11,"chemicals":0.08,"water":0.06}},{"id":"ca-sunrise","name":"Sunrise Cardium","formation":"Cardium","region":"Central Alberta","status":"Undeveloped","operator":"Foothills Energy","licenseHolder":"Foothills Energy Corp.","areaKm2":48,"depthM":2100,"thicknessM":12,"porosity":0.12,"permeabilityMd":8,"oilInPlaceMMbbl":600,"reservesMMbbl":108,"recoveryFactor":0.18,"productionBpd":18000,"historicalPeakBpd":0,"remainingLifeYears":16,"capexMM":760,"opexPerBbl":16,"transportPerBbl":5.5,"processingPerBbl":2.2,"carbonKgPerBbl":23,"royaltyRate":0.06,"latitude":52.25,"longitude":-114.2,"pipelineKm":14,"powerMwAvailable":60,"powerMwRequired":28,"roadAccess":"Highway","nearestPipeline":"Central Alberta Mainline","exportRoute":"Edmonton refining / export","storageMbbl":0.2,"risk":{"commodity":36,"construction":28,"political":16,"regulatory":22,"market":38,"carbon":14,"infrastructure":18},"employment":420,"capitalBreakdown":{"drilling":0.48,"facilities":0.2,"upgrading":0,"roads":0.08,"camps":0.06,"pipelines":0.18},"opexBreakdown":{"steam":0,"electricity":0.18,"naturalGas":0.08,"labour":0.28,"maintenance":0.22,"chemicals":0.16,"water":0.08}},{"id":"nw-montney","name":"Montney Ridge","formation":"Montney (Alberta)","region":"Northwest Alberta","status":"Planned","operator":"Boreal Stream","licenseHolder":"Boreal Stream Resources","areaKm2":72,"depthM":2800,"thicknessM":45,"porosity":0.08,"permeabilityMd":0.4,"oilInPlaceMMbbl":420,"reservesMMbbl":95,"recoveryFactor":0.22,"productionBpd":24000,"historicalPeakBpd":0,"remainingLifeYears":18,"capexMM":1120,"opexPerBbl":14,"transportPerBbl":7.8,"processingPerBbl":3.6,"carbonKgPerBbl":28,"royaltyRate":0.07,"latitude":55.9,"longitude":-119.4,"pipelineKm":68,"powerMwAvailable":40,"powerMwRequired":55,"roadAccess":"Limited","nearestPipeline":"Northwest liquids line","exportRoute":"BC corridor / Alberta hub","storageMbbl":0.15,"risk":{"commodity":34,"construction":42,"political":20,"regulatory":30,"market":36,"carbon":20,"infrastructure":48},"employment":560,"capitalBreakdown":{"drilling":0.52,"facilities":0.18,"upgrading":0,"roads":0.1,"camps":0.08,"pipelines":0.12},"opexBreakdown":{"steam":0,"electricity":0.22,"naturalGas":0.12,"labour":0.24,"maintenance":0.2,"chemicals":0.14,"water":0.08}},{"id":"dv-swan","name":"Swan Hills West","formation":"Swan Hills","region":"Central Alberta","status":"Producing","operator":"Legacy Basin","licenseHolder":"Legacy Basin Operating Co.","areaKm2":65,"depthM":2500,"thicknessM":30,"porosity":0.11,"permeabilityMd":45,"oilInPlaceMMbbl":780,"reservesMMbbl":156,"recoveryFactor":0.2,"productionBpd":22000,"historicalPeakBpd":48000,"remainingLifeYears":14,"capexMM":540,"opexPerBbl":18,"transportPerBbl":4.8,"processingPerBbl":2.8,"carbonKgPerBbl":31,"royaltyRate":0.08,"latitude":54.75,"longitude":-115.4,"pipelineKm":22,"powerMwAvailable":75,"powerMwRequired":40,"roadAccess":"All-season","nearestPipeline":"Swan Hills Feeder","exportRoute":"Edmonton hub","storageMbbl":0.4,"risk":{"commodity":30,"construction":20,"political":15,"regulatory":20,"market":28,"carbon":22,"infrastructure":16},"employment":610,"capitalBreakdown":{"drilling":0.4,"facilities":0.25,"upgrading":0,"roads":0.08,"camps":0.05,"pipelines":0.22},"opexBreakdown":{"steam":0.05,"electricity":0.16,"naturalGas":0.12,"labour":0.24,"maintenance":0.22,"chemicals":0.14,"water":0.07}}],"metadata":{"source":"demo seed dataset","updatedAt":"2026-10-07T19:39:57.033Z","count":6,"nextStep":"Connect a versioned AER/AGS ETL dataset and PostGIS feature store."}}