{"id":"https://openalex.org/W7155537927","doi":"https://doi.org/10.1109/icsc67292.2026.00075","title":"LLM-based Text-to-SQL: A Case Study of Geospatial Information Retrieval","display_name":"LLM-based Text-to-SQL: A Case Study of Geospatial Information Retrieval","publication_year":2026,"publication_date":"2026-02-02","ids":{"openalex":"https://openalex.org/W7155537927","doi":"https://doi.org/10.1109/icsc67292.2026.00075"},"language":null,"primary_location":{"id":"doi:10.1109/icsc67292.2026.00075","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icsc67292.2026.00075","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2026 International Conference on Semantic Computing (ICSC)","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5134535192","display_name":"Temitayo Olamilekan Ogunsusi","orcid":null},"institutions":[{"id":"https://openalex.org/I250520410","display_name":"Prairie View A&M University","ror":"https://ror.org/0449kf092","country_code":"US","type":"education","lineage":["https://openalex.org/I250520410"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Temitayo Olamilekan Ogunsusi","raw_affiliation_strings":["Prairie View A&M University,Department of Electrical and Computer Engineering,Prairie View,TX,USA,77446"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Prairie View A&M University,Department of Electrical and Computer Engineering,Prairie View,TX,USA,77446","institution_ids":["https://openalex.org/I250520410"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134477443","display_name":"Jose Angel Nguema Azeme Mangue","orcid":null},"institutions":[{"id":"https://openalex.org/I250520410","display_name":"Prairie View A&M University","ror":"https://ror.org/0449kf092","country_code":"US","type":"education","lineage":["https://openalex.org/I250520410"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jose Angel Nguema Azeme Mangue","raw_affiliation_strings":["Prairie View A&M University,Department of Electrical and Computer Engineering,Prairie View,TX,USA,77446"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Prairie View A&M University,Department of Electrical and Computer Engineering,Prairie View,TX,USA,77446","institution_ids":["https://openalex.org/I250520410"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134531895","display_name":"Weishan Bai","orcid":null},"institutions":[{"id":"https://openalex.org/I91045830","display_name":"Texas A&M University","ror":"https://ror.org/01f5ytq51","country_code":"US","type":"education","lineage":["https://openalex.org/I91045830"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Weishan Bai","raw_affiliation_strings":["Texas A&M University,Department of Landscape Architecture & Urban Planning,College Station,TX,USA,77843"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Texas A&M University,Department of Landscape Architecture & Urban Planning,College Station,TX,USA,77843","institution_ids":["https://openalex.org/I91045830"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134504529","display_name":"Xinyue Ye","orcid":null},"institutions":[{"id":"https://openalex.org/I91045830","display_name":"Texas A&M University","ror":"https://ror.org/01f5ytq51","country_code":"US","type":"education","lineage":["https://openalex.org/I91045830"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xinyue Ye","raw_affiliation_strings":["Texas A&M University,Department of Landscape Architecture & Urban Planning,College Station,TX,USA,77843"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Texas A&M University,Department of Landscape Architecture & Urban Planning,College Station,TX,USA,77843","institution_ids":["https://openalex.org/I91045830"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134510713","display_name":"Lijun Qian","orcid":null},"institutions":[{"id":"https://openalex.org/I250520410","display_name":"Prairie View A&M University","ror":"https://ror.org/0449kf092","country_code":"US","type":"education","lineage":["https://openalex.org/I250520410"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lijun Qian","raw_affiliation_strings":["Prairie View A&M University,Department of Electrical and Computer Engineering,Prairie View,TX,USA,77446"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Prairie View A&M University,Department of Electrical and Computer Engineering,Prairie View,TX,USA,77446","institution_ids":["https://openalex.org/I250520410"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5006284276","display_name":"Xishuang Dong","orcid":"https://orcid.org/0000-0002-3742-0071"},"institutions":[{"id":"https://openalex.org/I250520410","display_name":"Prairie View A&M University","ror":"https://ror.org/0449kf092","country_code":"US","type":"education","lineage":["https://openalex.org/I250520410"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xishuang Dong","raw_affiliation_strings":["Prairie View A&M University,Department of Electrical and Computer Engineering,Prairie View,TX,USA,77446"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Prairie View A&M University,Department of Electrical and Computer Engineering,Prairie View,TX,USA,77446","institution_ids":["https://openalex.org/I250520410"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.43592002,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"200","last_page":"204"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.12700000405311584,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.12700000405311584,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10757","display_name":"Geographic Information Systems Studies","score":0.125900000333786,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.06840000301599503,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/geospatial-analysis","display_name":"Geospatial analysis","score":0.5672000050544739},{"id":"https://openalex.org/keywords/document-retrieval","display_name":"Document retrieval","score":0.35019999742507935},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.3215000033378601},{"id":"https://openalex.org/keywords/information-system","display_name":"Information system","score":0.3172999918460846},{"id":"https://openalex.org/keywords/relevance","display_name":"Relevance (law)","score":0.31189998984336853}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.641700029373169},{"id":"https://openalex.org/C9770341","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Geospatial analysis","level":2,"score":0.5672000050544739},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5245000123977661},{"id":"https://openalex.org/C161156560","wikidata":"https://www.wikidata.org/wiki/Q1638872","display_name":"Document retrieval","level":2,"score":0.35019999742507935},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.3215000033378601},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.3172999918460846},{"id":"https://openalex.org/C158154518","wikidata":"https://www.wikidata.org/wiki/Q7310970","display_name":"Relevance (law)","level":2,"score":0.31189998984336853},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3068999946117401},{"id":"https://openalex.org/C551230270","wikidata":"https://www.wikidata.org/wiki/Q4368942","display_name":"Data retrieval","level":2,"score":0.3052999973297119},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.275299996137619},{"id":"https://openalex.org/C116834253","wikidata":"https://www.wikidata.org/wiki/Q2039217","display_name":"Identification (biology)","level":2,"score":0.2662000060081482},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.2500999867916107},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2500999867916107}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icsc67292.2026.00075","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icsc67292.2026.00075","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2026 International Conference on Semantic Computing (ICSC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Climate action","id":"https://metadata.un.org/sdg/13","score":0.4269338548183441}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W2890431379","https://openalex.org/W4390705060","https://openalex.org/W4396571402","https://openalex.org/W4406028351","https://openalex.org/W4406072772","https://openalex.org/W4416036717"],"related_works":[],"abstract_inverted_index":{"Text-to-SQL":[0,41,60,103],"aims":[1],"to":[2,70],"convert":[3],"natural":[4,134],"language":[5,109,135],"questions":[6],"into":[7],"executable":[8],"SQL":[9,94],"queries":[10],"for":[11,42,59],"retrieving":[12],"information":[13,44,127],"from":[14,128],"databases.":[15,32],"Despite":[16],"significant":[17],"advancements,":[18],"a":[19,49,53,85,102],"key":[20],"limitation":[21],"in":[22,62],"current":[23],"research":[24],"is":[25],"the":[26,63,77,121,129],"lack":[27],"of":[28,88],"focus":[29],"on":[30,133],"geospatial":[31,43,64,126],"This":[33],"paper":[34],"addresses":[35],"that":[36,120],"gap":[37],"by":[38],"exploring":[39],"LLM-based":[40],"retrieval.":[45],"We":[46,82],"first":[47],"construct":[48],"new":[50],"benchmark":[51],"using":[52,139],"PostGIS":[54],"spatial":[55,130],"database,":[56],"specifically":[57],"designed":[58],"tasks":[61],"domain.":[65],"Specifically,":[66],"we":[67,100],"use":[68],"LLMs":[69],"generate":[71],"additional":[72],"user-SQL":[73],"query":[74,92],"pairs,":[75],"enhancing":[76],"benchmark\u2019s":[78],"size":[79],"and":[80,96,114,143],"diversity.":[81],"also":[83],"provide":[84],"statistical":[86],"analysis":[87],"its":[89],"characteristics,":[90],"including":[91,111],"length,":[93],"complexity,":[95],"difficulty":[97],"levels.":[98],"Afterwards,":[99],"implement":[101],"pipeline":[104,123],"leveraging":[105],"state-of-theart":[106],"(SOTA)":[107],"large":[108],"models,":[110],"GPT-4,":[112],"Llama,":[113],"Google\u2019s":[115],"Gemma.":[116],"Experimental":[117],"results":[118],"demonstrate":[119],"proposed":[122],"effectively":[124],"retrieves":[125],"database":[131],"based":[132],"queries,":[136],"as":[137],"evaluated":[138],"Execution":[140],"Accuracy":[141],"(EX)":[142],"Valid":[144],"Efficiency":[145],"Score":[146],"(VES).":[147]},"counts_by_year":[],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2026-04-25T00:00:00"}