Text‐to‐SpatialSQL: A LLM Based Method for Generating Spatial SQL Queries With Geo‐Knowledge Extracted From Software User Manual
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.
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}
}
EUVIMED