Valuation Data Gaps & Portfolio Coverage Telemetry

Updated: September 28, 2026
Total Valuations: 13,475 historical appraisals
Database: Hosted Supabase project jrsgosnnyjonxaesqtln (public.valuations_base)
Audit Ledger: internal.valuation_deterministic_recovery_ledger & internal.valuation_same_parcel_crossfill_ledger

---

Live Portfolio Field Coverage Summary

Field	Populated Records	Completeness	Unpopulated Gaps	Status & Recovery Method
Property Type	13,151	97.6%	324	78 cross-filled via unanimous same-parcel consensus
Area (Al-Mintaqa)	12,636 ➔ 13,428	93.8% ➔ 99.65%	839 ➔ 47	792 recovered from drive register notes (REG-YYYY-<area>)
Size (sqm)	7,527 ➔ 11,709	55.8% ➔ 86.9%	5,948 ➔ 1,766	Enriched via master Excel + 5,124 property workbooks
Applicant	11,853	88.0%	1,622	Historical client files; 715 recoverable from same-parcel siblings
Price / sqm	6,629 ➔ 10,739	49.2% ➔ 79.7%	6,846 ➔ 2,736	Restored from certified valuation workbooks & master register
Cost Value (Appraised)	6,691 ➔ 10,055	49.7% ➔ 74.6%	6,784 ➔ 3,420	Restored from certified valuation workbooks & master register
Land Value	5,941 ➔ 9,981	44.1% ➔ 74.1%	7,534 ➔ 3,494	Restored from cost-approach breakdown sheets
Directed To (Bank)	8,214 ➔ 10,148	61.0% ➔ 75.3%	5,261 ➔ 3,327	1,934 recovered via applicant institutional bank name alignment
Governorate	7,707 ➔ 13,428	57.2% ➔ 99.65%	5,768 ➔ 47	4,929 recovered via paci_areas.area_key + 792 from notes
PACI GIS Parcel Link	8,186	60.7%	5,289	Cadastral polygon boundary links (parcel_identity_id)
Delivered Certified Appraisals	6,737 ➔ 10,460	50.0% ➔ 77.6%	6,738 ➔ 3,015	Active valuation deliveries; unvalued intake backlog reduced to 3,011
Linked Valuation Documents	21,631 ➔ 24,387	—	—	+2,756 uploaded deeds, reports, and licenses linked to records
Annual Revenue	2,367 ➔ 3,104	23.0%	—	Investment/commercial income-generating assets
FAR Ratio (building_ratio)	6,550 ➔ 8,998	66.8%	4,477	Permitted building ratio from appraisal certificates

---

Recovery Methodology & Production Migrations

1. Deterministic Mathematical Closures (20260927020000)

• Status: 100% Complete. 0 solvable mathematical gaps remaining.
• Closed all computable equations:
  • land_value = price_per_sqm * size_sqm
  • size_sqm = land_value / price_per_sqm
  • cost_value = land_value + building_value
  • price_per_sqm = land_value / size_sqm

2. Unanimous Same-Parcel Cadastral Cross-Fill (20260927120000)

• Status: Merged & Applied.
• Strictly requires 100% unanimous consensus across all sibling valuation records on the identical cadastral parcel (LOWER(TRIM(area)), TRIM(block), TRIM(plot)):
  • Recovered missing size_sqm where every other valuation on that exact plot reported identical parcel area.
  • Recovered missing property_type where zoning classification is identical across all historical valuations on that plot.
  • Provenance tracked in internal.valuation_same_parcel_crossfill_ledger.

3. Governorate & Area Deterministic Backfill (20260928133000)

• Pass 1 (Existing area_key values):
  • 4,929 records had populated snake_case area_key values (salmiya, mahboula, hawalli, qibla, zahra, etc.) with governorate IS NULL.
  • Exactly mapped against public.paci_areas.area_key to assign governorate_short (kw_governorate enum).
  • Breakdown of recovered governorates:
    • Hawalli: 1,865 records
    • Capital: 897 records
    • Ahmadi: 856 records
    • Farwaniya: 528 records
    • Jahra: 404 records
    • Mubarak Al-Kabeer: 379 records
• Pass 2 (Drive Register Notes Area Extraction):
  • 792 records with area IS NULL contained structured drive register notes: REG-YYYY-<area>-<block>-<plot>.
  • Extracted Arabic area names and mapped through canonical paci_areas / area_name_aliases to populate both area and governorate.
  • Leaves only 47 records in the entire 13,475 valuation database without a governorate (99.65% completeness).
• Pass 3 (Institutional Applicant Bank Alignment):
  • 1,934 records with missing directed_to had clear institutional bank names in applicant (KFH, KIB, ABK, Boubyan, Warba, NBK).
  • Aligned to standard canonical bank designations (بيت التمويل الكويتي (KFH), بنك الكويت الدولي (KIB), البنك الأهلي الكويتي (ABK)).

---

Audit Ledger & Provenance Schema

All automated and deterministic recoveries write immutable audit records to internal.valuation_deterministic_recovery_ledger:

• valuation_id: UUID reference to public.valuations_base(id)
• field_name: Field recovered (governorate, area, directed_to, size_sqm, land_value, cost_value)
• old_value: Original pre-recovery value (or NULL)
• new_value: Deterministically assigned value
• recovery_method: Enumerated method (paci_area_mapping, drive_register_notes_extraction, applicant_bank_alignment, mathematical_calc, notes_regex)
• applied_at: Timestamp of operation