AER Wells Data Layer

Status: Shipped Issue: #114Data source: Alberta Energy Regulator (AER) ST37 dataset

Overview

The AER Wells layer renders Alberta-licensed wells on the DLS grid as a circle layer with status-based colouring. Backed by the aer_wells.pmtiles archive served from maps.townshipcanada.com, with row-level lookups available through three REST endpoints.

Components

Component	Purpose
`app/config/mapLayers/dataCatalog/aerWells.js`	Circle layer config (zoom-scaled radius, status colouring)
`app/config/mapLayers/dataCatalog/aerWellsLabel.js`	Labels for individual wells
`app/config/mapLayers/index.js` (data catalog)	Catalog entry with legend (Active, Suspended, Abandoned, Reclaimed)
`server/api/wells/search.get.js`	Text search by UWI prefix, well name, or licence number
`server/api/wells/lookup.get.js`	Spatial lookup by lat/lng within 500m
`server/api/wells/[uwi].get.js`	Single-well record by UWI
`app/pages/well-closure.vue`	Marketing landing page surfacing the wells layer

Database

Table: app.aer_wells
Geometry: centroid (geography) + geom for boundary where applicable
Columns include UWI, well name, licence number, licence status, fluid, mode, type, full DLS components (township, meridian, range, section, LSD), total depth, KB elevation
Spatial index on centroid for ST_DWithin lookups

Map presentation

The legend in app/config/mapLayers/index.js groups well status values into four customer-facing categories using filterValues:

Legend label	AER `licence_status` values	Colour
Active	`issued`, `amended`, `re-entered`	`#1b9e77`
Suspended	`suspension`	`#d95f02`
Abandoned	`abandoned`	`#7570b3`
Reclaimed	`reccertified`, `recexempt`	`#e7298a`

Zoom-scaled circle radius is configured to keep province-wide views readable while making individual wells clickable past z14. Stroke and fill opacity also step with zoom so that dense well pads stay legible.

API

All three endpoints require an authenticated user. Tier gating for paid API access is enforced at the API key layer (see api-module.md).

Search

GET /api/wells/search?q=<term>&limit=<n>

Accepts UWI prefixes, well names, or licence numbers. Uses pg_trgm similarity scoring for fuzzy text matches. Returns the top results ordered by similarity.

Lookup by coordinates

GET /api/wells/lookup?lat=<lat>&lng=<lng>

Returns wells within 500 metres of the supplied point, ordered by distance.

Single well by UWI

GET /api/wells/[uwi]

Returns a single well record by Unique Well Identifier.

Refresh pipeline

ST37 dataset refresh is run on a periodic schedule (see operations runbook). New AER status values are mapped into the legend filterValues arrays as they appear in the data.

Alberta CCS / Pore Space Tenure
Geothermal Tenure (bundled with the CCS layer set)
Oil & Gas Fields (oilGasFields)

Marketing

Use case: content/use-cases/energy.md
Industry landing: content/learn/industries/oil-and-gas.md
How-to: content/learn/how-to/well-site-gps-coordinates-alberta.md
Blog: content/blog/alberta-well-licence-legal-land-description.md