Integrating artificial and collective intelligence in hydro-economic modeling for sustainable irrigation and drought adaptation in Colombia

[EN] Water-scarce smallholder regions require irrigation strategies that are both biophysically credible and socially legitimate. We propose an integrated hydro-economic decision-support framework for the Cesar Department (Colombia) that couples (i) AI emulation of FAO AquaCrop crop¿water responses, (ii) Bayesian aggregation of collective intelligence elicited under Shared Socioeconomic Pathways (SSP) using an AHP-anchored, two-round Delphi protocol, and (iii) a household linear program enforcing diversification and a Top-M social-alignment rule with penalized slack. XGBoost surrogates generate household-specific yield and net irrigation requirement coefficients for four crops under a dry-year baseline (test R2: 0.89¿0.93 for yield; 0.87¿0.91 for NIR). Expert-derived SSP-specific crop priority vectors are modeled on the simplex and combined via a Dirichlet posterior to produce crop-preference weights with 95% credible intervals, operationalized as social-weight layers (Base/Low/High/Uniform/Favored). The model solves 2520 household¿scenario combinations (168 households × 3 SSPs × 5 layers) with full feasibility and zero slack use. Increasing normative leverage through the minimum-alignment quota (¿) and social-reward scaling (¿) raises the social welfare component with limited income disruption in SSP1 and SSP4: in SSP4, the mean objective increases from USD 8334 (Base) to USD 11,427 (Favored), driven by the social term (USD 3283 ¿ 6382) while net income remains stable (~USD 5045¿5052). SSP3 provides a stress test, revealing tighter feasibility (alignment 0.582 and net income USD 3661 under Low; binding rate 22%). Across Socioeconomic Vulnerability Index (SEVI) terciles, mean income declines by ~42% while alignment remains high, motivating complementary investments that relax constraints for high-vulnerability households. Overall, embedding uncertainty-aware social priorities into hydro-economic optimization enables policy-relevant, scenario-conditional irrigation guidance while transparently revealing when preference-consistent targeting is compatible with feasibility and when it requires enabling investments.