{"id":"https://openalex.org/W4402351867","doi":"https://doi.org/10.1109/ijcnn60899.2024.10651125","title":"GS-SQL: Modeling Spatial Semantics in Spatial Text-to-SQL","display_name":"GS-SQL: Modeling Spatial Semantics in Spatial Text-to-SQL","publication_year":2024,"publication_date":"2024-06-30","ids":{"openalex":"https://openalex.org/W4402351867","doi":"https://doi.org/10.1109/ijcnn60899.2024.10651125"},"language":"en","primary_location":{"id":"doi:10.1109/ijcnn60899.2024.10651125","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ijcnn60899.2024.10651125","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 International Joint Conference on Neural Networks (IJCNN)","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/A5100437205","display_name":"Xu Zhang","orcid":"https://orcid.org/0000-0002-1533-4340"},"institutions":[{"id":"https://openalex.org/I10535382","display_name":"Chongqing University of Posts and Telecommunications","ror":"https://ror.org/03dgaqz26","country_code":"CN","type":"education","lineage":["https://openalex.org/I10535382"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xu Zhang","raw_affiliation_strings":["Chongqing University of Posts and Telecommunications,Department of Computer Science and Technology,Chongqing,China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Chongqing University of Posts and Telecommunications,Department of Computer Science and Technology,Chongqing,China","institution_ids":["https://openalex.org/I10535382"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101384223","display_name":"Feiyang Xiao","orcid":null},"institutions":[{"id":"https://openalex.org/I10535382","display_name":"Chongqing University of Posts and Telecommunications","ror":"https://ror.org/03dgaqz26","country_code":"CN","type":"education","lineage":["https://openalex.org/I10535382"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Feiyang Xiao","raw_affiliation_strings":["Chongqing University of Posts and Telecommunications,Department of Computer Science and Technology,Chongqing,China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Chongqing University of Posts and Telecommunications,Department of Computer Science and Technology,Chongqing,China","institution_ids":["https://openalex.org/I10535382"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055814112","display_name":"Liang Yan","orcid":"https://orcid.org/0000-0001-7315-5415"},"institutions":[{"id":"https://openalex.org/I10535382","display_name":"Chongqing University of Posts and Telecommunications","ror":"https://ror.org/03dgaqz26","country_code":"CN","type":"education","lineage":["https://openalex.org/I10535382"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Liang Yan","raw_affiliation_strings":["Chongqing University of Posts and Telecommunications,Department of Computer Science and Technology,Chongqing,China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Chongqing University of Posts and Telecommunications,Department of Computer Science and Technology,Chongqing,China","institution_ids":["https://openalex.org/I10535382"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048571434","display_name":"Zhiqing Zhang","orcid":"https://orcid.org/0000-0002-9306-3267"},"institutions":[{"id":"https://openalex.org/I211433327","display_name":"Ministry of Natural Resources","ror":"https://ror.org/02kxqx159","country_code":"CN","type":"government","lineage":["https://openalex.org/I211433327","https://openalex.org/I4210127390"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhiqing Zhang","raw_affiliation_strings":["Ministry of Natural Resources,Key Laboratory of Monitoring, Evaluation and Early Warning of Territorial Spatial Planning Implementation,China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ministry of Natural Resources,Key Laboratory of Monitoring, Evaluation and Early Warning of Territorial Spatial Planning Implementation,China","institution_ids":["https://openalex.org/I211433327"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9951000213623047,"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"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9937000274658203,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8215344548225403},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7287663817405701},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.7118545770645142},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6088793277740479},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5277379751205444},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5062826871871948},{"id":"https://openalex.org/keywords/pl/sql","display_name":"PL/SQL","score":0.4278659224510193},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4260498881340027},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.36187177896499634},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2513730227947235}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8215344548225403},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7287663817405701},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.7118545770645142},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6088793277740479},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5277379751205444},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5062826871871948},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.4278659224510193},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4260498881340027},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.36187177896499634},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2513730227947235},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ijcnn60899.2024.10651125","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ijcnn60899.2024.10651125","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 International Joint Conference on Neural Networks (IJCNN)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320310282","display_name":"Ministry of Natural Resources","ror":"https://ror.org/02ntv3742"},{"id":"https://openalex.org/F4320324805","display_name":"Chongqing Municipal Education Commission","ror":"https://ror.org/031nm5713"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W2123442489","https://openalex.org/W2747329762","https://openalex.org/W2751448157","https://openalex.org/W2768409085","https://openalex.org/W2890431379","https://openalex.org/W2963617989","https://openalex.org/W2984452801","https://openalex.org/W3034835156","https://openalex.org/W3035529900","https://openalex.org/W3103291908","https://openalex.org/W3103801878","https://openalex.org/W3150263485","https://openalex.org/W3175488485","https://openalex.org/W3208581766","https://openalex.org/W3214600982","https://openalex.org/W4283733706","https://openalex.org/W4290927888","https://openalex.org/W4297733535","https://openalex.org/W4383199468","https://openalex.org/W6739901393","https://openalex.org/W6743367031","https://openalex.org/W6745537798","https://openalex.org/W6745921949","https://openalex.org/W6757817989","https://openalex.org/W6766978945","https://openalex.org/W6803081274"],"related_works":["https://openalex.org/W4386768611","https://openalex.org/W637318291","https://openalex.org/W1980548249","https://openalex.org/W650213220","https://openalex.org/W2340883001","https://openalex.org/W2348171219","https://openalex.org/W2614112517","https://openalex.org/W2184401408","https://openalex.org/W4318225407","https://openalex.org/W4366683866"],"abstract_inverted_index":{"Conventional":[0],"Text-to-SQL":[1,155],"research":[2],"tackles":[3],"the":[4,15,21,56,64,90,100,104,130,139],"problem":[5],"of":[6,20,70,141],"solving":[7,39],"user":[8],"questions":[9,41],"in":[10,32,38,63,89,148],"natural":[11],"language":[12],"by":[13],"generating":[14],"corresponding":[16],"SQL":[17,124],"queries.":[18],"Most":[19],"recent":[22],"works":[23],"are":[24],"dedicated":[25],"to":[26,118],"improving":[27],"model\u2019s":[28,36],"robustness":[29],"and":[30,60,92,122,146],"generalizability":[31],"cross-domain":[33],"settings.":[34],"However,":[35],"capability":[37],"geography-related":[40],"remains":[42],"unexploited.":[43],"In":[44],"this":[45],"paper":[46],"we":[47,107,128],"propose":[48,108],"GS-SQL,":[49],"a":[50,80,93,110],"new":[51],"framework":[52,68],"that":[53,112],"jointly":[54],"model":[55,117],"schema":[57],"item":[58],"alignment":[59],"geospatial":[61,114,150],"semantics":[62,95,151],"question.":[65],"The":[66],"proposed":[67,131],"consists":[69],"an":[71],"improved":[72],"abstract":[73,143],"syntax":[74,144],"tree":[75,145],"for":[76,86,98],"representing":[77],"spatial":[78,82,94,101,120],"queries,":[79,115],"novel":[81],"entity":[83],"tagging":[84],"module":[85,97],"locating":[87],"entities":[88],"question,":[91],"extraction":[96],"determining":[99],"relationship":[102],"between":[103],"entities.":[105],"Then":[106],"GeoSpatialSpider,":[109],"dataset":[111,135],"introduces":[113],"requiring":[116],"yield":[119],"functions":[121],"nested":[123],"inside":[125],"functions.":[126],"Finally":[127],"evaluate":[129],"method":[132],"on":[133],"our":[134,142],"Experimental":[136],"results":[137],"show":[138],"effectiveness":[140],"GS-SQL":[147],"parsing":[149],"while":[152],"preserving":[153],"traditional":[154],"capabilities.":[156]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}