EUVIMEDEUVIMED entdecken
Crossref

Text‐to‐SpatialSQL: A LLM Based Method for Generating Spatial SQL Queries With Geo‐Knowledge Extracted From Software User Manual

Yicheng Ma, Yifan Zhang, Wenbo Zhang, Xinru Zhao, Wenhao Yu

Transactions in GIS · 2026-06 · 30 (4)

DOI: 10.1111/tgis.70312 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Transactions in GIS, online erschienen am 18.06.2026. Verfasst von Yicheng Ma und 4 weiteren Autor:innen. Die Arbeit wurde bisher 2-mal zitiert (Crossref) und nennt 56 Literaturangaben. Gefördert von: National Natural Science Foundation of China.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

SQL statement design is a fundamental task in spatial databases and GIS. However, the inherent complexity of spatial SQL queries presents a significant challenge for non‐expert users. Although large language models (LLMs) have been widely used for SQL generation in traditional databases, their effectiveness in handling spatial queries remains constrained due to the specialized nature of spatiotemporal data and operations. To address this limitation, we propose a novel framework that integrates Retrieval‐Augmented Generation (RAG) with LLMs. Our method automatically extracts domain‐specific knowledge from spatial database documentation, constructs an application‐oriented knowledge graph, and leverages prompt engineering to generate standardized spatial SQL queries. Experimental results on benchmark datasets demonstrate significant improvements in execution accuracy (EX) and component matching rate (CM) across queries of varying schema complexity, validating the framework's efficacy in automating spatial query generation.

Förderung

  • National Natural Science Foundation of China

Zitieren

APA

Ma, Y., Zhang, Y., Zhang, W., Zhao, X., & Yu, W. (2026). Text‐to‐SpatialSQL: A LLM Based Method for Generating Spatial SQL Queries With Geo‐Knowledge Extracted From Software User Manual. Transactions in GIS, 30(4). https://doi.org/10.1111/tgis.70312

Vancouver

Ma Y, Zhang Y, Zhang W, Zhao X, Yu W. Text‐to‐SpatialSQL: A LLM Based Method for Generating Spatial SQL Queries With Geo‐Knowledge Extracted From Software User Manual. Transactions in GIS. 2026;30(4). doi:10.1111/tgis.70312

BibTeX
@article{Ma2026,
  author = {Ma, Yicheng and Zhang, Yifan and Zhang, Wenbo and Zhao, Xinru and Yu, Wenhao},
  title = {Text‐to‐SpatialSQL: A LLM Based Method for Generating Spatial SQL Queries With Geo‐Knowledge Extracted From Software User Manual},
  journal = {Transactions in GIS},
  year = {2026},
  volume = {30},
  number = {4},
  doi = {10.1111/tgis.70312}
}
Kostenlos starten →