Migration 0065
4/4
synth-mviews LIVE
synth_lepingu_risk
1 133
cirsmas baseline
synth_sortiment_heatmap
38
join LIVE-tested
synth_nfa_overlap
148
TMA hull × cirsmas
BGE-M3 missing
93.24%
8884/9528 → P0!
forestsense_layer_registry
119+
data-products
📋 Kihid (registry)
Kiht 1 — Raw
lvm_cirsmas
1 133
kpdc_documents
159
tma_tracking
~50k
Kiht 2D — Synth (LIVE 2026-05-27)
synth_lepingu_risk
1 133
synth_sortiment_heatmap
38
synth_nfa_overlap
148
Kiht +A — Cross-cutting
synth_memory_coherence
1
Kiht 6 — Apps
timbertrace-ui
skill
kaardi_aju_router
edge-fn
RISK
jobcode 18
jobcode 18
OK
parcelcode 66640060200
parcelcode 66640060200
PARTIAL
NFA outside cirsmas
NFA outside cirsmas
📍 Click-i tulemus (synth_lepingu_risk)
fellarea: 3.73 ha · planned_m3_est: 933 m³ (250 m³/ha heuristic)
delivered: 0 m³ · pct_filled: 0.0%
status: NEW_OR_UNMAPPED (contractnumber-join pooleli)
delivered: 0 m³ · pct_filled: 0.0%
status: NEW_OR_UNMAPPED (contractnumber-join pooleli)
👤 Janis
Näita mulle raieid mis on rohkem kui 90 päeva üle tähtaja
🗺️ KaardiAju (jetson · qwen2.5:14b)
Layer matched: synth_lepingu_risk (layer=
EUR-mõju: €15k/a (Kiht #1 baseline kui mapping täiustub)
2D, 1133 rows, owner=kaardi-aju-skill.md v0.3)
SELECT cirsmas_id, jobcode, parcelcode,
fellarea, planned_m3_est, delivered_m3,
pct_filled, days_remaining, status
FROM synth_lepingu_risk
WHERE status IN ('RISK', 'WATCH')
ORDER BY last_delivery NULLS LAST
LIMIT 100;
0 rida hetkel — contractnumber-join cirsmas "14/18" vs kpdc "EGLIT015/LATFI050" pole veel mapitud. Mapping täiustub Sprint 2.
EUR-mõju: €15k/a (Kiht #1 baseline kui mapping täiustub)
👤 Janis
Mis on sortiment-jaotus Aizkraukle põhjas?
🗺️ KaardiAju
Layer matched: synth_sortiment_heatmap (layer=
Top-3 sortiment cirsmas-tes:
2D, 38 rows)
Top-3 sortiment cirsmas-tes:
- Egle III šķiras zāģbaļķis — kõige sagedasem (40+ m³ batch)
- Apse Malka — 50 m³ cirsmas 76660030129
- Skujkoki II šķiras zāģbaļķis — 40 m³ cirsmas 74520080074
Mode: jetson · qwen2.5:14b · ~25-40 tok/s · €0/päring · privacy=local
4-tab Tool-call API spec (Edge Function `kaardi_aju_router`)
| Tab | Tool-call | Sisend | Väljund | Latency Jetson |
|---|---|---|---|---|
| 🔍 Query | query_layer(NL: str) |
Natural-language päring (EE/LV/EN) | Top-3 layers + DRY-RUN SQL + sample geom | ~3-5s |
| 🧩 Compose | compose_layer(A, op, B, params) |
2 layer-nime + op (intersect/union/buffer/nearest/aggregate) | CREATE MATERIALIZED VIEW SQL (DRY-RUN) + estimated rows | ~8-12s |
| 🎨 Style | style_layer(layer, style_intent) |
Layer-nimi + värvi/ulatuse-intent | MapLibre paint JSON + deck.gl overlay | ~2-3s |
| 💬 Explain | explain_geom(WKT, context_layers) |
Click-itud polügoon + relevantsed kihid | ~150-sõna narratiiv + EUR-mõju hinnang | ~6-10s |
Brand-otsus + järgmised etapid
⚠️ Brand-paletti kasutus: see wireframe kasutab TerraNervus / KaardiAju työ-paletti
(
#1B4332 metsaroheline, #2D5F8A järvesinine, #D4A574 sügis-tamm, #F4F1EB linaluu).
Erki strateegiline brand-otsus (TerraNervus / KaardiAju / Forestsense AI alla) pooleli (P4.A AskUserQuestion popup tuleb).
Brand-otsuse järel uuendatakse: domeen WHOIS · GitHub repo · Edge Function namespace · UI logo · slogan.
Päev 2 progress
- ✅ P1.C Migration 0065 LIVE (4 synth-mview + 4 layer_registry kanded id=119-122)
- ✅ P2.B kaardi-aju-llm-prompt-v0.md — Qwen2.5 system prompt EE/LV/EN multilingual
- ✅ P3.A Janis Kaardi-paneel v0 wireframe (käesolev fail)
- 🟡 P3.B Edge Function
kaardi_aju_routerskeleton draft (deploy ootab brand-otsust) - 🔴 P2.A BLOCKED — Jetson SSH võtme upload (Erki manuaalne)
- ⏳ P4.A Brand-otsus AskUserQuestion popup
- ⏳ P4.C LTV/ROE €124k/a vs €60-140/kuu = 4-6× ROI arvutus
- ⏳ P4.D Sprint 1 retro + Sprint 2 prompt + finish(completed)
Kriitiline leid Päev 2 alguses
- 🔴 synth_memory_coherence: 8884 / 9528 (93.24%) pos_deep_memory ilma BGE-M3 embeddinguta. Last 7 päeva sissevool: 9155 uut kirjet. Tegevus: Jetson cron 03:00 BGE-M3 delta-reembed (vajab Erki SSH võtme upload-i — vt agent_messages id=4608).
- 🟢 TerraNervus Kiht #0 Evaluator 2026-05-22 hinnang (Memory Coherence = "ainus tehniline eelis Felt/Mapbox vastu") 100% kinnitatud andmetega.