Well Log POV v0.2 Integration Plan

Source Inputs

• /Users/robertwilhelm/Downloads/TOQUIS DEV/Earthbond_POV_v0.2.docx
• /Users/robertwilhelm/Downloads/TOQUIS DEV/POV_Forgotten_Well_Log_Recovery_and_Bypassed_Pay_Triage_CLIENT.docx
• /Users/robertwilhelm/Downloads/TOQUIS DEV/Earthbond_Subsurface Pay Analog Finder_0.1.pdf
• /Users/robertwilhelm/Downloads/TOQUIS DEV/Earthbond_Edge_Wedge_01.pdf

What Changed In v0.2

• Expanded client-facing structure (numbered sections, glossary, worked example, confidence framing).
• Stronger depth-reference requirements:
• explicit KB/RT handling
• strict MD->TVDSS conversion requirement for deviated wells
• explicit minimum-curvature requirement
• Added explicit QC behavior:
• mandatory missing-curve checks
• caliper-based washout handling and fallback confidence downgrade when caliper is absent
• Added deterministic interpretation details:
• Vsh formula
• PHIE/RHOB/NPHI requirements
• Rt deep-resistivity handling
• optional Sw (Archie) with required parameter gates
• Added clearer bypassed-pay ranking logic and recommended next actions (including cased-hole pulsed-neutron evaluation).

Fit To Current POC

The current repo already has reusable building blocks:

• upload and metadata pipeline (ops.upload_sessions, ingest jobs)
• strict CRS and ECEF controls
• immutable audit and evidence model
• Web UI for file upload, metadata browsing, and visualization

Missing for this POV:

• LAS/DLIS well-log normalization pipeline
• petrophysical derivation pipeline (Vsh/PHIE/Rt/optional Sw)
• bypassed-pay event generation and ranking
• well-centric deliverable APIs (Well Status Pack + portfolio summary)

Integration Delta (Module By Module)

1) Database

Add forward-only migrations introducing well-log and interpretation entities under ops:

• ops.well_logs
• source file linkage, header metadata, KB/RT fields, CRS/depth reference status
• ops.well_log_curves
• curve mnemonic, unit, availability, alias mapping status
• ops.well_qc_cards
• missing percent, washout flags, confidence rating, data-gap reasons
• ops.well_interpretations
• run config/version, formula assumptions, cutoff set
• ops.well_pay_events
• top/base TVDSS, gross/net thickness, mean Vsh/PHIE/Rt, QC status
• ops.well_bypassed_candidates
• completion check result, confidence level, ranked actionability score, recommendation
• ops.well_data_gaps
• missing survey/tops/tests/completion details and priority

Recommended indexes:

• (project_id, well_id, created_at desc)
• (project_id, classification, score desc) on bypassed candidates
• GIN on interpretation/config JSON where needed

2) Contracts (OpenAPI + Events)

Extend contracts/openapi/data-plane.yaml with:

• POST /well-logs/jobs/normalize
• POST /well-logs/jobs/interpret
• POST /well-logs/jobs/bypassed-pay
• GET /projects/{project_id}/wells/{well_id}/qc-card
• GET /projects/{project_id}/wells/{well_id}/status-pack
• GET /projects/{project_id}/portfolio/bypassed-pay-summary

Add event schemas:

• contracts/events/well-log-normalized.schema.json
• contracts/events/well-log-interpreted.schema.json
• contracts/events/well-bypassed-pay-ranked.schema.json

3) Worker Pipeline

Add worker stages (can be added into worker-ingest first, then split later):

1. normalize_well_log

• parse LAS (first) and DLIS (optional connector)
• alias map -> canonical mnemonics (GR, RHOB, NPHI, Rt, CAL)
• depth standardization (MD/TVDSS state + uncertainty flag)

1. compute_petrophysics

• Vsh from GR
• PHIE from RHOB/NPHI
• Rt extraction
• optional Sw only when required parameters exist

1. detect_pay_events

• deterministic cutoffs from per-project config

1. rank_bypassed_pay

• perforation/test cross-check
• ranked output with recommendation

1. emit_well_status_pack

• JSON deliverable and summary payload persisted to object storage + DB links

4) API Layer

Data-plane should expose:

• job submit + status endpoints
• immutable result retrieval endpoints (QC card, pay events, bypass shortlist)
• deterministic replay mode using stored run configuration

Control-plane should expose:

• per-tenant/per-basin default cutoff profiles and formula policy
• approved alias maps and versioning

5) Admin / Client UI

Add in apps/client-web:

• Well log run wizard:
• select well files + completion history + optional tops/tests
• select/override cutoff profile
• Well Status Pack view:
• QC card
• pay table
• bypass shortlist with confidence and recommendation
• data-gap panel
• Portfolio board:
• top ranked bypassed-pay candidates across wells

Add in apps/admin-web:

• curve alias dictionary manager
• basin cutoff profile manager
• rule version history/audit view

Mapping to Existing Principles

• Metadata-first architecture remains unchanged.
• Raw files are still accessed only when needed by analysis stages.
• All transformations remain auditable and reproducible.
• CRS/ECEF controls remain mandatory for location-sensitive fields.

Implementation Order (Next Coding Phase)

1. Migration pack for well-log entities.
2. Contract additions and schema validation updates.
3. Worker normalization + deterministic interpretation stubs with tests.
4. Data-plane endpoints for status-pack retrieval.
5. Client UI status-pack and portfolio screens.

Test Gates For This Module

• LAS normalization unit tests (alias, units, depth range).
• MD/TVDSS conversion and uncertainty-flag tests.
• Deterministic cutoff reproducibility tests.
• Completion/perforation cross-check tests.
• End-to-end smoke test creating a status pack artifact per well.

Notes

• v0.2 is more explicit but directionally aligned with the prior client POV document.
• No contradictions found with current CRS/ECEF/audit architecture.
• This integration is additive and can be delivered without reworking current LiDAR flows.