{"id":"https://openalex.org/W7162014491","doi":"https://doi.org/10.1145/3786167.3788417","title":"An Agentic System for LLM-Driven Public Transportation Analytics: A Practical Application and Case Study in Salvador-Brazil","display_name":"An Agentic System for LLM-Driven Public Transportation Analytics: A Practical Application and Case Study in Salvador-Brazil","publication_year":2026,"publication_date":"2026-04-12","ids":{"openalex":"https://openalex.org/W7162014491","doi":"https://doi.org/10.1145/3786167.3788417"},"language":null,"primary_location":{"id":"doi:10.1145/3786167.3788417","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3786167.3788417","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2026 International Workshop on Agentic Engineering","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3786167.3788417","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5136682146","display_name":"Lucas T. Borges","orcid":"https://orcid.org/0009-0006-6178-3995"},"institutions":[{"id":"https://openalex.org/I126158947","display_name":"Universidade Federal da Bahia","ror":"https://ror.org/03k3p7647","country_code":"BR","type":"education","lineage":["https://openalex.org/I126158947"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Lucas T. Borges","raw_affiliation_strings":["Federal University of Bahia, Salvador, Brazil"],"raw_orcid":"https://orcid.org/0009-0006-6178-3995","affiliations":[{"raw_affiliation_string":"Federal University of Bahia, Salvador, Brazil","institution_ids":["https://openalex.org/I126158947"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136717631","display_name":"Fei T. Liu","orcid":"https://orcid.org/0000-0001-9028-2774"},"institutions":[{"id":"https://openalex.org/I4210164862","display_name":"Artificial Intelligence in Medicine (Canada)","ror":"https://ror.org/05p590m36","country_code":"CA","type":"company","lineage":["https://openalex.org/I4210164862"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Fei T. Liu","raw_affiliation_strings":["Artificial General Intelligence Pty Ltd., New South Wales, Australia"],"raw_orcid":"https://orcid.org/0000-0001-9028-2774","affiliations":[{"raw_affiliation_string":"Artificial General Intelligence Pty Ltd., New South Wales, Australia","institution_ids":["https://openalex.org/I4210164862"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078094395","display_name":"Tatiane Rios","orcid":null},"institutions":[{"id":"https://openalex.org/I126158947","display_name":"Universidade Federal da Bahia","ror":"https://ror.org/03k3p7647","country_code":"BR","type":"education","lineage":["https://openalex.org/I126158947"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Tatiane Rios","raw_affiliation_strings":["Federal University of Bahia, Salvador, Brazil"],"raw_orcid":"https://orcid.org/0000-0002-6992-977X","affiliations":[{"raw_affiliation_string":"Federal University of Bahia, Salvador, Brazil","institution_ids":["https://openalex.org/I126158947"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136677698","display_name":"Marcos V. Ferreira","orcid":"https://orcid.org/0000-0003-0574-8301"},"institutions":[{"id":"https://openalex.org/I126158947","display_name":"Universidade Federal da Bahia","ror":"https://ror.org/03k3p7647","country_code":"BR","type":"education","lineage":["https://openalex.org/I126158947"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Marcos V. Ferreira","raw_affiliation_strings":["Federal University of Bahia, Salvador, Brazil"],"raw_orcid":"https://orcid.org/0000-0003-0574-8301","affiliations":[{"raw_affiliation_string":"Federal University of Bahia, Salvador, Brazil","institution_ids":["https://openalex.org/I126158947"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090578258","display_name":"Clovis Carmo","orcid":null},"institutions":[{"id":"https://openalex.org/I126158947","display_name":"Universidade Federal da Bahia","ror":"https://ror.org/03k3p7647","country_code":"BR","type":"education","lineage":["https://openalex.org/I126158947"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Clovis Carmo","raw_affiliation_strings":["Federal University of Bahia, Salvador, Brazil"],"raw_orcid":"https://orcid.org/0009-0000-0274-0203","affiliations":[{"raw_affiliation_string":"Federal University of Bahia, Salvador, Brazil","institution_ids":["https://openalex.org/I126158947"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136687875","display_name":"Danilo B. Coimbra","orcid":"https://orcid.org/0000-0003-2218-1351"},"institutions":[{"id":"https://openalex.org/I126158947","display_name":"Universidade Federal da Bahia","ror":"https://ror.org/03k3p7647","country_code":"BR","type":"education","lineage":["https://openalex.org/I126158947"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Danilo B. Coimbra","raw_affiliation_strings":["Federal University of Bahia, Salvador, Brazil"],"raw_orcid":"https://orcid.org/0000-0003-2218-1351","affiliations":[{"raw_affiliation_string":"Federal University of Bahia, Salvador, Brazil","institution_ids":["https://openalex.org/I126158947"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5126114299","display_name":"Jorge Nery","orcid":null},"institutions":[{"id":"https://openalex.org/I126158947","display_name":"Universidade Federal da Bahia","ror":"https://ror.org/03k3p7647","country_code":"BR","type":"education","lineage":["https://openalex.org/I126158947"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Jorge Nery","raw_affiliation_strings":["Federal University of Bahia, Salvador, Brazil"],"raw_orcid":"https://orcid.org/0009-0003-8360-2612","affiliations":[{"raw_affiliation_string":"Federal University of Bahia, Salvador, Brazil","institution_ids":["https://openalex.org/I126158947"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008801364","display_name":"Matheus Souza","orcid":"https://orcid.org/0000-0002-1538-3361"},"institutions":[{"id":"https://openalex.org/I44314228","display_name":"Universidade Salvador","ror":"https://ror.org/01afz2176","country_code":"BR","type":"education","lineage":["https://openalex.org/I44314228"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Matheus Souza","raw_affiliation_strings":["Integra - Association of Transport Companies of Salvador, Salvador, Brazil"],"raw_orcid":"https://orcid.org/0009-0006-7496-5237","affiliations":[{"raw_affiliation_string":"Integra - Association of Transport Companies of Salvador, Salvador, Brazil","institution_ids":["https://openalex.org/I44314228"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136651128","display_name":"Noe O. Garcia","orcid":"https://orcid.org/0009-0009-1206-2560"},"institutions":[{"id":"https://openalex.org/I4210137495","display_name":"Arcadis (Netherlands)","ror":"https://ror.org/03hqjqp33","country_code":"NL","type":"company","lineage":["https://openalex.org/I4210137495"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Noe O. Garcia","raw_affiliation_strings":["Arcadis, Amsterdam, Netherlands"],"raw_orcid":"https://orcid.org/0009-0009-1206-2560","affiliations":[{"raw_affiliation_string":"Arcadis, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I4210137495"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136702966","display_name":"Albert Bifet","orcid":"https://orcid.org/0000-0002-8339-7773"},"institutions":[{"id":"https://openalex.org/I52179390","display_name":"University of Waikato","ror":"https://ror.org/013fsnh78","country_code":"NZ","type":"education","lineage":["https://openalex.org/I52179390"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Albert Bifet","raw_affiliation_strings":["University of Waikato, Hamilton, New Zealand"],"raw_orcid":"https://orcid.org/0000-0002-8339-7773","affiliations":[{"raw_affiliation_string":"University of Waikato, Hamilton, New Zealand","institution_ids":["https://openalex.org/I52179390"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067216942","display_name":"R Rios","orcid":null},"institutions":[{"id":"https://openalex.org/I126158947","display_name":"Universidade Federal da Bahia","ror":"https://ror.org/03k3p7647","country_code":"BR","type":"education","lineage":["https://openalex.org/I126158947"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Ricardo Rios","raw_affiliation_strings":["Federal University of Bahia, Salvador, Brazil"],"raw_orcid":"https://orcid.org/0000-0003-1449-4745","affiliations":[{"raw_affiliation_string":"Federal University of Bahia, Salvador, Brazil","institution_ids":["https://openalex.org/I126158947"]}]}],"institutions":[],"countries_distinct_count":4,"institutions_distinct_count":11,"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.77269322,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"18","last_page":"25"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11942","display_name":"Transportation and Mobility Innovations","score":0.21950000524520874,"subfield":{"id":"https://openalex.org/subfields/2203","display_name":"Automotive Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11942","display_name":"Transportation and Mobility Innovations","score":0.21950000524520874,"subfield":{"id":"https://openalex.org/subfields/2203","display_name":"Automotive Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11344","display_name":"Traffic Prediction and Management Techniques","score":0.06419999897480011,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10698","display_name":"Transportation Planning and Optimization","score":0.053300000727176666,"subfield":{"id":"https://openalex.org/subfields/3313","display_name":"Transportation"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/privilege","display_name":"Privilege (computing)","score":0.7031000256538391},{"id":"https://openalex.org/keywords/headway","display_name":"Headway","score":0.6855000257492065},{"id":"https://openalex.org/keywords/visual-analytics","display_name":"Visual analytics","score":0.5422000288963318},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.49070000648498535},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.47510001063346863},{"id":"https://openalex.org/keywords/public-transport","display_name":"Public transport","score":0.4401000142097473},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.429500013589859},{"id":"https://openalex.org/keywords/visual-language","display_name":"Visual language","score":0.32659998536109924}],"concepts":[{"id":"https://openalex.org/C2780138299","wikidata":"https://www.wikidata.org/wiki/Q3404265","display_name":"Privilege (computing)","level":2,"score":0.7031000256538391},{"id":"https://openalex.org/C2779240695","wikidata":"https://www.wikidata.org/wiki/Q4383682","display_name":"Headway","level":2,"score":0.6855000257492065},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6248999834060669},{"id":"https://openalex.org/C59732488","wikidata":"https://www.wikidata.org/wiki/Q2528440","display_name":"Visual analytics","level":3,"score":0.5422000288963318},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.49070000648498535},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.47510001063346863},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.44760000705718994},{"id":"https://openalex.org/C539828613","wikidata":"https://www.wikidata.org/wiki/Q178512","display_name":"Public transport","level":2,"score":0.4401000142097473},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.429500013589859},{"id":"https://openalex.org/C112930515","wikidata":"https://www.wikidata.org/wiki/Q4389547","display_name":"Risk analysis (engineering)","level":1,"score":0.3695000112056732},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.3546000123023987},{"id":"https://openalex.org/C2780878386","wikidata":"https://www.wikidata.org/wiki/Q1659648","display_name":"Visual language","level":2,"score":0.32659998536109924},{"id":"https://openalex.org/C2777055276","wikidata":"https://www.wikidata.org/wiki/Q7936580","display_name":"Visual approach","level":2,"score":0.31869998574256897},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.3111000061035156},{"id":"https://openalex.org/C2778137410","wikidata":"https://www.wikidata.org/wiki/Q2732820","display_name":"Government (linguistics)","level":2,"score":0.2903999984264374},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.28690001368522644},{"id":"https://openalex.org/C22212356","wikidata":"https://www.wikidata.org/wiki/Q775325","display_name":"Transport engineering","level":1,"score":0.2840999960899353},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.2786000072956085},{"id":"https://openalex.org/C42475967","wikidata":"https://www.wikidata.org/wiki/Q194292","display_name":"Operations research","level":1,"score":0.2773999869823456},{"id":"https://openalex.org/C47796450","wikidata":"https://www.wikidata.org/wiki/Q508378","display_name":"Intelligent transportation system","level":2,"score":0.2750999927520752},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.2705000042915344},{"id":"https://openalex.org/C133462117","wikidata":"https://www.wikidata.org/wiki/Q4929239","display_name":"Data collection","level":2,"score":0.26969999074935913},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.2687000036239624},{"id":"https://openalex.org/C2781283787","wikidata":"https://www.wikidata.org/wiki/Q2919821","display_name":"Right of way","level":2,"score":0.26660001277923584},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.25870001316070557},{"id":"https://openalex.org/C42629822","wikidata":"https://www.wikidata.org/wiki/Q1346408","display_name":"Geocoding","level":2,"score":0.25450000166893005},{"id":"https://openalex.org/C203481301","wikidata":"https://www.wikidata.org/wiki/Q76221","display_name":"Data system","level":2,"score":0.251800000667572},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.2506999969482422}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3786167.3788417","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3786167.3788417","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2026 International Workshop on Agentic Engineering","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3786167.3788417","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3786167.3788417","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2026 International Workshop on Agentic Engineering","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.7757221460342407,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W2095881341","https://openalex.org/W2185907055","https://openalex.org/W4391129224","https://openalex.org/W4404739549","https://openalex.org/W4406728221","https://openalex.org/W4406754736","https://openalex.org/W4410909684","https://openalex.org/W4411057454","https://openalex.org/W4412529260","https://openalex.org/W4412766661","https://openalex.org/W4413427262","https://openalex.org/W4413554837","https://openalex.org/W4414040315","https://openalex.org/W4414051470"],"related_works":[],"abstract_inverted_index":{"Public":[0],"transportation":[1],"agencies":[2],"gather":[3],"vast":[4],"and":[5,17,37,60,62,90,99,115],"heterogeneous":[6],"datasets,":[7],"yet":[8],"their":[9],"decisions":[10],"still":[11],"depend":[12],"largely":[13],"on":[14],"manual":[15],"queries":[16],"fragmented":[18],"analyses.":[19],"To":[20],"address":[21],"this":[22],"gap,":[23],"we":[24],"introduce":[25],"SUNTInsight,":[26],"an":[27,63],"agentic":[28],"system":[29],"that":[30],"combines":[31],"large":[32],"language":[33],"models,":[34],"machine":[35],"learning,":[36],"visual":[38,67],"analytics":[39],"to":[40,72,77],"strengthen":[41],"human":[42],"decision-making.":[43],"Through":[44],"a":[45,78],"seamless":[46],"workflow,":[47],"free-form":[48],"prompts":[49],"are":[50,58],"automatically":[51],"converted":[52],"into":[53],"SQL":[54],"queries,":[55],"relevant":[56],"data":[57],"retrieved":[59],"processed,":[61],"LLM,":[64],"supported":[65],"by":[66],"interfaces,":[68],"interprets":[69],"the":[70,110],"results":[71],"produce":[73],"actionable":[74],"findings.":[75],"Applied":[76],"case":[79],"study":[80],"in":[81,119,127],"Salvador-Brazil,":[82],"SUNTInsight":[83],"revealed":[84],"spatial":[85],"heterogeneity,":[86],"identified":[87],"high-demand":[88],"segments,":[89],"recommended":[91],"targeted":[92],"operational":[93],"strategies,":[94],"such":[95],"as":[96],"short":[97],"turns":[98],"headway":[100],"control,":[101],"instead":[102],"of":[103,112],"broad":[104],"fleet":[105],"expansions.":[106],"The":[107],"implementation":[108],"follows":[109],"principle":[111],"least":[113],"privilege":[114],"runs":[116],"generated":[117],"code":[118],"isolated":[120],"execution,":[121],"mitigating":[122],"risk":[123],"while":[124],"keeping":[125],"humans":[126],"control.":[128]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-05-22T00:00:00"}