Tranch 3: Analytics & Domain Model Fixes #67
Merged
wasabi opened 3 days ago

Fixes stale schema columns, expands forecast resolvers, adds period filtering to ecology reports, adds signal dedup/auto-classification, and enforces technology roadmap status transitions.

Commits were merged into target branch
  • fix(crisp): replace stale columns with correct schema fields
    - climate_risk: temperature_celsius->temperature_c, wind_speed_kph->wind_speed_kmh, incident_date->detection_date
    - carbon_yield: estimated_yield_kg->quantity with unit conversion, add species param
    - implementation_risk: farm_onboarding_profile->farm/derived queries, training_event->training_session, decision_method->governance_body, satisfaction_score->sentiment
    - policy_risk: decision_method->governance_body, satisfaction_score->sentiment
    - financial_risk: noi_projection_y1/y2/y3->projected_annual_noi_usd
    - scoring_engine: break_even_month->break_even_year with year conversion
    3 days ago
    fix(delphi): persist stopping eval, add reject method, add panel calibration
    - check_stopping: persist round_summary + consensus_reached to study metadata
    - add reject_recommendation: human rejection with reason logged to study metadata
    - add calibrate_panel: expert weight updates based on historical prediction accuracy
    - CLI: add reject-recommendation and calibrate-panel commands
    3 days ago
    fix(predictions): expand forecast outcome resolvers
    - Fix revenue_event column name: amount_usd -> amount
    - Add projected_cash_flow_usd resolver (revenue - expenses)
    - Add carbon_sequestration_tonnes resolver (carbon_credit.current_sequestration_tonnes)
    - Add carbon_credit_value_usd resolver (available_tonnes * pricing_usd_per_tonne)
    3 days ago
    fix(reports): add period filtering to ecological and resource reports
    - ecological_modeling: filter model_runs, populations, energy_flows, soil_inputs by period
    - trophic_pyramid: filter species_by_trophic by period
    - pest_management: filter pest_trends and biocontrol by period
    - resource_efficiency: filter resources and harvest by period
    3 days ago
    fix(threatcasting): add signal dedup and auto-classification
    - ingest_signal: content_hash dedup within configurable time window
    - ingest_signal: auto-classify by keyword overlap against threat names
    - CLI: use SignalIngestor class instead of raw SQL, add --location-id
    - Migration 345: add content_hash column + index to threat_signal
    3 days ago
    fix(roadmap): enforce status transitions and reviewer auth
    - update_roadmap: validate status transitions against allowed graph
    - review_roadmap: require reviewed_by, enforce submitted-only review
    - Define valid transitions: draft→submitted, submitted→approved/rejected, approved→superseded, rejected→draft
    3 days ago
  • wasabi merged 3 days ago
1/1
Submitter wasabi
Target main
Source feat/tranch3-analytics-fixes
Jobs
Merge Strategy
Create Merge Commit
Watchers (1)
Reference
pull request KI-67
Please wait...
Connection lost or session expired, reload to recover
Page is in error, reload to recover