DisasterLex: An Expert Concept-to-Schema Knowledge Graph for Geospatial Reasoning in Disaster Analytics
Yiming Xiao, Ankit Basu, Kai Yin, Christian Swords, Ali Mostafavi · 2026
Read DisasterLex: An Expert Concept-to-Schema Knowledge Graph for Geospatial Reasoning in Disaster Analytics by Yiming Xiao, Ankit Basu, Kai Yin, Christian Swords, Ali Mostafavi (2026) in the Tower of Babel, a free online library of public-domain works preserved in clean, searchable text. No sign-up. The full text is served as a plain-text file at a predictable URL, where text is present: https://antarctic-labs.com/tower-of-babel/arxiv-2605-30538.txt.
Introduction
Xiao and colleagues build DisasterLex, a system that helps analysts query disaster databases in plain language. Ordinary text-to-SQL tools stumble on disaster data because queries span many geospatial tables and demand reasoning about causes. DisasterLex inserts an expert knowledge graph of concepts and causal links between the question and the database, routing each query through entity spotting, domain routing, causal planning, and SQL grounding. Across seven base models it beat four leading baselines by wide margins on a seventy-five-query test set.
Catalog record
| CREATOR | Yiming Xiao, Ankit Basu, Kai Yin, Christian Swords, Ali Mostafavi |
|---|---|
| YEAR | 2026 |
| COLLECTION | PAPERS |
| FORMAT | TXT |
| FILE SIZE | 65304 |
| LICENSE | http://creativecommons.org/licenses/by/4.0/ |
| RIGHTS | CC BY |
| SOURCE | arXiv |
Source: https://arxiv.org/abs/2605.30538
Browse the full library · About the Tower of Babel
Full text
The opening of the work, from the library's hosted text:
DisasterLex: An Expert Concept-to-Schema Knowledge Graph for Geospatial Reasoning in Disaster Analytics Yiming Xiao, Ankit Basu, Kai Yin, Christian Swords, Ali Mostafavi Abstract Disasters are inevitable and increasingly costly, and effective response depends on querying structured tabular data: precise, information-dense records of hazard, exposure, vulnerability, and lifeline infrastructure that underpin disaster management. Current text-to-SQL methods enable natural-language access to such tables but transfer poorly to the disaster domain, where queries span heterogeneous geospatial schemas and require reasoning over causal relations. We introduce DisasterLex , a knowledge-graph-mediated framework that inserts an Expert Knowledge Graph (EKG) of curated concepts and typed causal edges between the user query and the database, bridged to schema by concept-to-table links. The orchestration runs four stages (identifying query entities, routing to the operational domain, planning over causal edges, and grounding the SQL), restricting the schema passed to the model at each step. We instantiate it on a disaster-analytics database (36 geospatial tables, 150 columns) with an EKG of 107 concepts, 117 causal edges, and 52 concept-to-schema links, evaluated on a 75-query test set. On all seven base models spanning proprietary and open-weight families, DisasterLex beats four state-of-the-art baselines (LightRAG, HippoRAG 2, ReFoRCE, CHESS) by 1.4 × \times to 2.75 × \times , with absolute scores of 1.65 to 3.56 (of 5.0). Error analysis shows baseline failures cluster in routing and multi-table SQL composition, the operations our orchestration explicitly addresses. Code, data, and the EKG artifact are available at this repository and on Zenodo at 10.5281/zenodo.20388029 . 1 Introduction Disasters, both natural and technological, inevitably trigger severe societal, economic, and humanitarian consequences ( 10 ; 23 ) . During such events, emergency analysts, incident commanders, and affected populations rely on rapid, accurate access to structured geospatial data (hazard exposure, population vulnerability, lifeline-infrastructure readiness) to coordinate response under time-critical decision constraints ( 11 ; 6 ; 2 ) . Reliable natural-language access to this data could dramatically lower the barrier between an analyst’s question and the underlying tables, but the data itself resists general-purpose language tools: it spans dozens of heterogeneous tables with specialised semantics, where sentinel values mark missingness, scores invert between datasets so that higher means more resilient on one index but more vulnerable on another, and the causal relations a domain expert reasons over (e.g., low community resilience reduces emergency-response capacity, flood depth increases structural damage, power outages cascade to hospital operations) must be encoded externally for the LLM to use. Current natural-language data access approaches fail in this setting for distinct reasons. Text-to-SQL systems ( 47 ; 27 ; 32 ) assume a small or pre-selected schema; at our scale, injecting the full 150-column schema into every Text-to-SQL prompt is technically feasible at modern context lengths but dilutes attention across semantically unrelated tables, producing hallucinated joins between, e.g., flood-risk tables and unrelated demographic tables that share only an hex_id key. Standard retrieval-augmented generation (RAG) ( 24 ; 15 ) retrieves passages when what is needed is executable SQL over structured tables. Graph-augmented RAG ( 9 ; 31 ) builds knowledge graphs from document corpora to improve passage retrieval, but does not address the schema selection problem that gates structured query answering. Multi-agent text-to-SQL pipelines such as CHESS ( 37 ) , designed for clean BIRD-style benchmarks, similarly rely on column-name heuristics for schema linking and do not encode domain causal structure. To bridge this gap, we introduce DisasterLex , a knowledge-graph-mediated agentic framework for structured question answering in disaster analytics. At its core is a concept-level schema-linking layer: an expert-curated graph of domain concepts and typed causal edges mapped to executable database schemas. The graph mediates between user vocabulary and column names at the table-selection step, leaving SQL generation to the LLM. A four-stage orchestration pipeline (criticality extraction, operationally-motivated routing, causal-informed planning, grounded execution) enforces the operational structure that domain experts already follow. Unlike prior graph-augmented retrieval, schema-linking, and text-to-SQL systems, DisasterLex uses an expert-curated causal concept graph as a domain-specific schema selection layer over structured tables, motivated by the functional structure of the target domain rather than the general-purpose retrieval setting these systems were designed for. Contributions. (1) Concept-level schema linking via an expert-curated typed causal graph. We address the schema-selection failure mode of prior text-to-SQL and RAG approaches by interposing an Expert Knowledge Graph (EKG) of 107 domain concepts and 117 typed causal edges between natural-language queries and a 36-table relational schema, connected by 52 explicit concept-to-schema edges. Synonym-based concept matching plus 1-hop graph traversal reduces the prompt schema context from 150 columns to typically 10–20 per query. (2) An ICS-motivated four-stage orchestration pipeline whose components are individually load-bearing. We decompose disaster-analytics queries into criticality extraction, three-cluster routing, causal-informed planning, and tool-augmented execution rather than relying on a single ReAct loop ( 44 ; 11 ; 3 ) . Ablating routing drops Tier M (multi-table composition) by - 1.50 on Gemini; ablating planning drops Tier K by - 0.29 to - 3.19 across models, demonstrating that orchestration choices interact non-trivially with base-model capability. (3) A four-tier diagnostic benchmark. A 75-case test split decoupled from development tuning, organized into four tiers that isolate distinct failure modes of natural-language interfaces to geospatial databases (routing, EKG grounding, multi-table composition, data-availability disclosure). Per-tier scoring localizes where SOTA external systems collapse, with the largest gaps concentrated on routing and multi-table composition (Table 2 ). (4) Cross-model evidence with quantified seed variance. A five-condition ablation (full pipeline plus four internal-component ablations) replayed across seven architecturally diverse base models spanning closed-source and open-source families (Gemini 3.1 Flash-Lite Preview, DeepSeek V3.2, Qwen 3.6 Flash, Llama 3.1 8B, Qwen3 8B, Qwen3 32B, Llama 3.3 70B) with three random seeds per cell, alongside four state-of-the-art external comparators: two graph-RAG retrievers (LightRAG ( 17 ) , HippoRAG 2 ( 18 ) ) and two multi-agent text-to-SQL pipelines (CHESS ( 37 ) , ReFoRCE ( 7 ) ). The full pipeline beats every general-purpose retrieval substitute and text-to-SQL competitor on every base model, but cross-model ablation deltas reveal substantial heterogeneity (e.g., DeepSeek is the most tolerant of orchestration removal, Qwen 3.6 the least), qualifying any claim that “pipeline structure matters” by which base model is in scope. 2 System Architecture Figure 1: DisasterLex architecture. A natural-language query flows through four stages: (1) context & criticality extraction, (2) operational-domain classification into a domain-specific cluster, (3) a ReAct planner that scouts the EKG and the web, and (4) a ReAct executor that runs concept-aware SQL on DuckDB and traverses EKG causal rules to synthesise an incident report. The expert-curated Causal Knowledge Graph is bridged to the Relational Database by Maps_To edges. DisasterLex consists of three integrated components, summarized in Figure 1 : a unified knowledge graph (§ 2.1 ), a concept-aware schema retrieval mechanism (§ 2.2 ), and a four-stage orchestration pipeline (§ 2.3 ). 2.1 Unified Knowledge Graph The unified graph is hosted in Neo4j ( 40 ) and combines a faithful representation of the relational schema with curated domain causal knowledge. Disaster Data Catalog Graph (DDCG). Auto-introspected from a relational database: each table is a DataTable node with child DataColumn nodes, and JoinRule nodes encode valid join patterns over the primary-key column(s) of each table. In our case study (§ 3 ), the DDCG is