{"id":1761,"date":"2026-03-24T08:15:00","date_gmt":"2026-03-24T08:15:00","guid":{"rendered":"https:\/\/cloudlab.urv.cat\/catedracloud\/?p=1761"},"modified":"2026-03-24T11:24:05","modified_gmt":"2026-03-24T11:24:05","slug":"hackato-ia-urv-tsystems-2026-iberia","status":"publish","type":"post","link":"https:\/\/cloudlab.urv.cat\/catedracloud\/2026\/03\/24\/hackato-ia-urv-tsystems-2026-iberia\/","title":{"rendered":"Hackat\u00f3 IA URV-TSystems 2026: IberIA"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-fd5ae7f9 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" srcset=\"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/D81_3490-1024x684.jpg ,https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/D81_3490.jpg 780w, https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/D81_3490.jpg 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/D81_3490-1024x684.jpg\" alt=\"\" class=\"uag-image-1764\" width=\"2048\" height=\"1367\" title=\"D81_3490\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center\"><strong>2n Premi<\/strong><\/h4>\n\n\n\n<p><strong>IberIA<\/strong>&nbsp;\u00e9s un agent analista d&#8217;intel\u00b7lig\u00e8ncia artificial d&#8217;\u00faltima generaci\u00f3, especialitzat en el mercat de l&#8217;habitatge d&#8217;Espanya i Catalunya. El projecte fusiona dades massives de preus, contractes de lloguer i habitatge protegit amb capacitats de&nbsp;<strong>RAG (Retrieval-Augmented Generation)<\/strong>&nbsp;per oferir respostes precises, comparatives visuals i interpretaci\u00f3 legal en temps real.<\/p>\n\n\n\n<p><strong>Nom Grup:<\/strong> Coffee Coders<\/p>\n\n\n\n<p><strong>Entitat del repte:<\/strong> C\u00e0tedra UNESCO d&#8217;Habitatge de la URV<\/p>\n\n\n\n<p><strong>Integrants: <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ivan Arenal Fern\u00e1ndez (<a>ivan.arenal@estudiants.urv.cat<\/a>)<\/li>\n\n\n\n<li>Enric Esteve Pons (<a>enric.esteve@estudiants.urv.cat<\/a>)<\/li>\n\n\n\n<li>Josep Llu\u00eds Mar\u00edn Trabal\u00f3n (<a>joseplluis.marin@estudiants.urv.cat<\/a>)<\/li>\n\n\n\n<li>Angelina Ruiz Jim\u00e9nez (<a>angelina.ruiz@estudiants.urv.cat<\/a>)<\/li>\n<\/ul>\n\n\n\n<p><strong>Nom Projecte:<\/strong> IberIA (Motor d&#8217;Intel\u00b7lig\u00e8ncia d&#8217;Habitatge)<\/p>\n\n\n\n<p><strong>Descripci\u00f3:<\/strong> IberIA neix de la necessitat de transformar dades est\u00e0tiques en coneixement accionable. Mitjan\u00e7ant una arquitectura h\u00edbrida de&nbsp;<strong>Next.js 16<\/strong>&nbsp;(Frontend) i&nbsp;<strong>FastAPI<\/strong>&nbsp;(Backend), el sistema processa milers de registres de fonts oficials. L&#8217;agent utilitza el model&nbsp;<strong>Google Gemini 2.5 Flash<\/strong>&nbsp;equipat amb eines determin\u00edstiques: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SQL Din\u00e0mic amb Feedback Loop<\/strong>: L&#8217;IA tradueix preguntes naturals en consultes SQL sobre&nbsp;<strong>Supabase<\/strong>. Hem implementat un sistema d&#8217;auto-correcci\u00f3 on l&#8217;agent, davant d&#8217;un error de sintaxi, analitza el missatge de la base de dades i corregeix la seva pr\u00f2pia consulta en temps real. <\/li>\n\n\n\n<li><strong>Cerca Sem\u00e0ntica Avan\u00e7ada (RAG)<\/strong>: Indexaci\u00f3 de normativa legal i dades d&#8217;Excel vectoritzades amb&nbsp;<code>pgvector<\/code>. L&#8217;IA no nom\u00e9s respon, sin\u00f3 que referencia la font i l&#8217;article exacte. <\/li>\n\n\n\n<li><strong>Visualitzaci\u00f3 Contextual<\/strong>: L&#8217;IA controla el frontend enviant instruccions per renderitzar gr\u00e0fics de&nbsp;<strong>Recharts<\/strong>&nbsp;i actualitzar un mapa interactiu de&nbsp;<strong>Mapbox<\/strong>&nbsp;amb coropletes i marcadors segons el municipi mencionat.<\/li>\n<\/ul>\n\n\n\n<p>El projecte ha estat refactoritzat per garantir la&nbsp;<strong>reproducibilitat<\/strong>, eliminant rutes hardcoded i utilitzant un sistema de c\u00e0rrega de dades portable basat en variables d&#8217;entorn i paths relatius.<\/p>\n\n\n\n<p><strong>Tecnologies utilitzades:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>IA\/LLM<\/strong>: Google Gemini 2.5 Flash, LangChain, Sentence-Transformers.<\/li>\n\n\n\n<li><strong>Backend<\/strong>: Python 3.10+, FastAPI, Supabase (PostgreSQL + pgvector).<\/li>\n\n\n\n<li><strong>Frontend<\/strong>: Next.js 16, React 19, TypeScript, Tailwind CSS.<\/li>\n\n\n\n<li><strong>Visualitzaci\u00f3<\/strong>: Mapbox GL JS, Recharts, Framer Motion.<\/li>\n\n\n\n<li><strong>Dades<\/strong>: pandas, PyMuPDF, openpyxl.<\/li>\n<\/ul>\n\n\n\n<p><strong>Recursos del Projecte:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Github: <\/strong><a href=\"https:\/\/github.com\/angeruiizz\/agente_vivien\">https:\/\/github.com\/angeruiizz\/agente_vivien<\/a><\/li>\n\n\n\n<li><strong>Presentaci\u00f3: <\/strong><a href=\"https:\/\/rovira-my.sharepoint.com\/:b:\/g\/personal\/52460503-x_epp_urv_cat\/IQCO8B07c2AsRqN_o4RF6YboAYk-oVOg9lN2PNF0lWjE8pU?e=uHmkaW\">https:\/\/rovira-my.sharepoint.com\/:b:\/g\/personal\/52460503-x_epp_urv_cat\/IQCO8B07c2AsRqN_o4RF6YboAYk-oVOg9lN2PNF0lWjE8pU?e=uHmkaW<\/a><\/li>\n<\/ul>\n\n\n\n<p><strong>Acc\u00e9s a la resta de projectes de la Hackat\u00f3 d&#8217;IA 2026:<\/strong> <a href=\"https:\/\/cloudlab.urv.cat\/catedracloud\/hackato2026\/\">https:\/\/cloudlab.urv.cat\/catedracloud\/hackato2026\/<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>2n Premi IberIA&nbsp;\u00e9s un agent analista d&#8217;intel\u00b7lig\u00e8ncia artificial d&#8217;\u00faltima generaci\u00f3, especialitzat en el mercat de l&#8217;habitatge d&#8217;Espanya i Catalunya. El projecte fusiona dades massives de preus, contractes de lloguer i habitatge protegit amb capacitats de&nbsp;RAG (Retrieval-Augmented Generation)&nbsp;per oferir respostes precises, comparatives visuals i interpretaci\u00f3 legal en temps real. Nom Grup: Coffee Coders Entitat del repte: [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1763,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_swt_meta_header_display":false,"_swt_meta_footer_display":false,"_swt_meta_site_title_display":false,"_swt_meta_sticky_header":false,"_swt_meta_transparent_header":false,"footnotes":""},"categories":[113,94,39],"tags":[],"class_list":["post-1761","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-computing","category-hackathon","category-ia"],"jetpack_featured_media_url":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/Captura-de-pantalla-2026-03-23-a-las-16.54.43.png","uagb_featured_image_src":{"full":["https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/Captura-de-pantalla-2026-03-23-a-las-16.54.43.png",1834,864,false],"thumbnail":["https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/Captura-de-pantalla-2026-03-23-a-las-16.54.43-150x150.png",150,150,true],"medium":["https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/Captura-de-pantalla-2026-03-23-a-las-16.54.43-300x141.png",300,141,true],"medium_large":["https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/Captura-de-pantalla-2026-03-23-a-las-16.54.43-768x362.png",768,362,true],"large":["https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/Captura-de-pantalla-2026-03-23-a-las-16.54.43-1024x482.png",1024,482,true],"1536x1536":["https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/Captura-de-pantalla-2026-03-23-a-las-16.54.43-1536x724.png",1536,724,true],"2048x2048":["https:\/\/cloudlab.urv.cat\/catedracloud\/wp-content\/uploads\/2026\/03\/Captura-de-pantalla-2026-03-23-a-las-16.54.43.png",1834,864,false]},"uagb_author_info":{"display_name":"Carlos Molina","author_link":"https:\/\/cloudlab.urv.cat\/catedracloud\/author\/carlos-molina\/"},"uagb_comment_info":0,"uagb_excerpt":"2n Premi IberIA&nbsp;\u00e9s un agent analista d&#8217;intel\u00b7lig\u00e8ncia artificial d&#8217;\u00faltima generaci\u00f3, especialitzat en el mercat de l&#8217;habitatge d&#8217;Espanya i Catalunya. El projecte fusiona dades massives de preus, contractes de lloguer i habitatge protegit amb capacitats de&nbsp;RAG (Retrieval-Augmented Generation)&nbsp;per oferir respostes precises, comparatives visuals i interpretaci\u00f3 legal en temps real. Nom Grup: Coffee Coders Entitat del repte:&hellip;","_links":{"self":[{"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/posts\/1761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/comments?post=1761"}],"version-history":[{"count":6,"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/posts\/1761\/revisions"}],"predecessor-version":[{"id":1900,"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/posts\/1761\/revisions\/1900"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/media\/1763"}],"wp:attachment":[{"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/media?parent=1761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/categories?post=1761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudlab.urv.cat\/catedracloud\/wp-json\/wp\/v2\/tags?post=1761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}