The increasing demand for efficient geographic data querying has underscored the need to improve both the speed and accuracy of such operations.This study presents a novel approach that com-bines Retrieval-Augmented G...The increasing demand for efficient geographic data querying has underscored the need to improve both the speed and accuracy of such operations.This study presents a novel approach that com-bines Retrieval-Augmented Generation(RAG)with a Large Language Model(LLM)-based Multi-Agent System(MAS)to address this challenge.By leveraging Geographic Information System(GIS)metadata,the method transforms natural language queries into precise SQL queries,enhancing the functionality of LLMs in geos-patial database management.RAG enriches the model's responses with relevant external knowledge,while the MAS framework decomposes complex queries into manageable subtasks,each handled by a dedicated agent.This ensures the generation of syntactically accurate and contextually relevant SQL queries,improving query precision.Rigorous experimentation shows that the approach achieves over 80%SQL generation accuracy,surpass-ing traditional LLM-based techniques,even with large-scale geos-patial datasets and complex queries.Additionally,the average query execution time is only 11.74 seconds,demonstrating the method's efficiency.The practical applicability of our method has been validated through its implementation and user testing in an urban planning platform.This has made geospatial database access more accessible and user-friendly,regardless of the user's expertise in database management or SQL,thus facilitating more efficient geospatial data interaction.展开更多
基金supported by the National Natural Science Foundation of China(41901325).
文摘The increasing demand for efficient geographic data querying has underscored the need to improve both the speed and accuracy of such operations.This study presents a novel approach that com-bines Retrieval-Augmented Generation(RAG)with a Large Language Model(LLM)-based Multi-Agent System(MAS)to address this challenge.By leveraging Geographic Information System(GIS)metadata,the method transforms natural language queries into precise SQL queries,enhancing the functionality of LLMs in geos-patial database management.RAG enriches the model's responses with relevant external knowledge,while the MAS framework decomposes complex queries into manageable subtasks,each handled by a dedicated agent.This ensures the generation of syntactically accurate and contextually relevant SQL queries,improving query precision.Rigorous experimentation shows that the approach achieves over 80%SQL generation accuracy,surpass-ing traditional LLM-based techniques,even with large-scale geos-patial datasets and complex queries.Additionally,the average query execution time is only 11.74 seconds,demonstrating the method's efficiency.The practical applicability of our method has been validated through its implementation and user testing in an urban planning platform.This has made geospatial database access more accessible and user-friendly,regardless of the user's expertise in database management or SQL,thus facilitating more efficient geospatial data interaction.
