jcbowyer's picture
Deploy: Consolidated gold tables, fixed nginx docs routing
3d16fe6 verified
<!doctype html><html lang=en dir=ltr class="docs-wrapper plugin-docs plugin-id-default docs-version-current docs-doc-page docs-doc-id-development/react-refactoring" data-has-hydrated=false><head><meta charset=UTF-8><meta name=generator content="Docusaurus v3.10.0"><title data-rh=true>React + FastAPI Databricks App Refactoring | Open Navigator</title><meta data-rh=true name=viewport content="width=device-width, initial-scale=1.0"/><meta data-rh=true property=og:image content=https://www.communityone.com/img/docusaurus-social-card.jpg /><meta data-rh=true name=twitter:image content=https://www.communityone.com/img/docusaurus-social-card.jpg /><meta data-rh=true property=og:url content=https://www.communityone.com/docs/development/react-refactoring /><meta data-rh=true property=og:locale content=en /><meta data-rh=true name=docusaurus_locale content=en /><meta data-rh=true name=docsearch:language content=en /><meta data-rh=true name=keywords content="civic engagement, policy tracking, meeting minutes, nonprofit tracking, municipal government, advocacy, open data, local government"/><meta data-rh=true property=og:type content=website /><meta data-rh=true property=og:site_name content="Open Navigator"/><meta data-rh=true name=twitter:card content=summary_large_image /><meta data-rh=true name=docusaurus_version content=current /><meta data-rh=true name=docusaurus_tag content=docs-default-current /><meta data-rh=true name=docsearch:version content=current /><meta data-rh=true name=docsearch:docusaurus_tag content=docs-default-current /><meta data-rh=true property=og:title content="React + FastAPI Databricks App Refactoring | Open Navigator"/><meta data-rh=true name=description content="Executive Summary"/><meta data-rh=true property=og:description content="Executive Summary"/><link data-rh=true rel=icon href=/img/favicon.ico /><link data-rh=true rel=canonical href=https://www.communityone.com/docs/development/react-refactoring /><link data-rh=true rel=alternate href=https://www.communityone.com/docs/development/react-refactoring hreflang=en /><link data-rh=true rel=alternate href=https://www.communityone.com/docs/development/react-refactoring hreflang=x-default /><script data-rh=true type=application/ld+json>{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","item":"https://www.communityone.com/docs/for-developers","name":"Developers & Technical Users","position":1},{"@type":"ListItem","item":"https://www.communityone.com/docs/development/react-refactoring","name":"React + FastAPI Databricks App Refactoring","position":2}]}</script><link rel=alternate type=application/rss+xml href=/blog/rss.xml title="Open Navigator RSS Feed"><link rel=alternate type=application/atom+xml href=/blog/atom.xml title="Open Navigator Atom Feed"><link rel=preconnect href=https://www.google-analytics.com><link rel=preconnect href=https://www.googletagmanager.com><script async src="https://www.googletagmanager.com/gtag/js?id=G-5EQV815915"></script><script>function gtag(){dataLayer.push(arguments)}window.dataLayer=window.dataLayer||[],gtag("js",new Date),gtag("config","G-5EQV815915",{anonymize_ip:!0})</script><link rel=stylesheet href=/assets/css/styles.c89d6b2d.css /><script src=/assets/js/runtime~main.c8fa085e.js defer></script><script src=/assets/js/main.6e24e536.js defer></script></head><body><svg style="display: none;"><defs>
<symbol id=theme-svg-external-link viewBox="0 0 24 24"><path fill=currentColor d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"/></symbol>
</defs></svg>
<script>!function(){var t=function(){try{return new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}}()||function(){try{return window.localStorage.getItem("theme-7e9")}catch(t){}}();document.documentElement.setAttribute("data-theme",t||(window.matchMedia("(prefers-color-scheme: dark)").matches?"dark":"light")),document.documentElement.setAttribute("data-theme-choice",t||"system")}(),function(){try{for(var[t,e]of new URLSearchParams(window.location.search).entries())if(t.startsWith("docusaurus-data-")){var a=t.replace("docusaurus-data-","data-");document.documentElement.setAttribute(a,e)}}catch(t){}}()</script><div id=__docusaurus><link rel=preload as=image href=/img/communityone_logo.svg /><script type=application/ld+json>{"@context":"https://schema.org","@type":"Organization","address":{"@type":"PostalAddress","addressCountry":"US","addressLocality":"Tuscaloosa","addressRegion":"AL","postalCode":"35406","streetAddress":"5617 Lakeridge Court"},"contactPoint":{"@type":"ContactPoint","availableLanguage":["English"],"contactType":"Customer Service","email":"johnbowyer@communityone.com"},"description":"Track 90,000+ jurisdictions, 1.8M nonprofits, and analyze meeting minutes with AI. The open path to everything local.","email":"johnbowyer@communityone.com","legalName":"CommunityOne","logo":"https://www.communityone.com/img/communityone_logo.svg","name":"CommunityOne","sameAs":["https://www.facebook.com/communityone","https://www.instagram.com/communityone","https://twitter.com/communityone","https://www.linkedin.com/company/communityone","https://www.youtube.com/@communityone","https://discord.gg/communityone","https://github.com/getcommunityone/open-navigator"],"url":"https://www.communityone.com"}</script><script type=application/ld+json>{"@context":"https://schema.org","@type":"WebSite","alternateName":"CommunityOne Open Navigator","description":"AI-powered civic engagement platform tracking jurisdictions, nonprofits, and government meetings","name":"Open Navigator","potentialAction":{"@type":"SearchAction","query-input":"required name=search_term_string","target":{"@type":"EntryPoint","urlTemplate":"https://www.communityone.com/search?q={search_term_string}"}},"url":"https://www.communityone.com"}</script><script type=application/ld+json>{"@context":"https://schema.org","@type":"SoftwareApplication","aggregateRating":{"@type":"AggregateRating","ratingCount":"1","ratingValue":"5"},"applicationCategory":"BusinessApplication","description":"Track 90,000+ jurisdictions, 1.8M nonprofits, and analyze meeting minutes with AI","featureList":["Track 90,000+ jurisdictions","Monitor 1.8M nonprofits","Analyze meeting minutes","Legislative bill tracking","Campaign finance data"],"name":"Open Navigator","offers":{"@type":"Offer","price":"0","priceCurrency":"USD"},"operatingSystem":"Web","screenshot":"https://www.communityone.com/img/docusaurus-social-card.jpg","softwareVersion":"1.0.0"}</script><div role=region aria-label="Skip to main content"><a class=skipToContent_fXgn href=#__docusaurus_skipToContent_fallback>Skip to main content</a></div><nav aria-label=Main class="theme-layout-navbar navbar navbar--fixed-top"><div class=navbar__inner><div class="theme-layout-navbar-left navbar__items"><button aria-label="Toggle navigation bar" aria-expanded=false class="navbar__toggle clean-btn" type=button><svg width=30 height=30 viewBox="0 0 30 30" aria-hidden=true><path stroke=currentColor stroke-linecap=round stroke-miterlimit=10 stroke-width=2 d="M4 7h22M4 15h22M4 23h22"/></svg></button><a href=https://www.communityone.com target=_self rel="noopener noreferrer" class=navbar__brand><div class=navbar__logo><img src=/img/communityone_logo.svg alt="CommunityOne Logo" class="themedComponent_mlkZ themedComponent--light_NVdE"/><img src=/img/communityone_logo.svg alt="CommunityOne Logo" class="themedComponent_mlkZ themedComponent--dark_xIcU"/></div><b class="navbar__title text--truncate">Open Navigator Home</b></a><a class="navbar__item navbar__link" href=/docs/intro>Getting Started</a><a class="navbar__item navbar__link" href=/docs/for-families>Families & Individuals</a><a class="navbar__item navbar__link" href=/docs/for-advocates>Policy Makers</a><a class="navbar__item navbar__link" href=/docs/for-developers>Developers</a><a class="navbar__item navbar__link" href=/docs/data-sources/citations>Data and Terms</a><a class="navbar__item navbar__link" href=/blog>Blog</a></div><div class="theme-layout-navbar-right navbar__items navbar__items--right"><a href=https://github.com/getcommunityone/open-navigator-for-engagement target=_blank rel="noopener noreferrer" class="navbar__item navbar__link">GitHub<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><div class="toggle_vylO colorModeToggle_DEke"><button class="clean-btn toggleButton_gllP toggleButtonDisabled_aARS" type=button disabled title="system mode" aria-label="Switch between dark and light mode (currently system mode)"><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP lightToggleIcon_pyhR"><path fill=currentColor d="M12,9c1.65,0,3,1.35,3,3s-1.35,3-3,3s-3-1.35-3-3S10.35,9,12,9 M12,7c-2.76,0-5,2.24-5,5s2.24,5,5,5s5-2.24,5-5 S14.76,7,12,7L12,7z M2,13l2,0c0.55,0,1-0.45,1-1s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S1.45,13,2,13z M20,13l2,0c0.55,0,1-0.45,1-1 s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S19.45,13,20,13z M11,2v2c0,0.55,0.45,1,1,1s1-0.45,1-1V2c0-0.55-0.45-1-1-1S11,1.45,11,2z M11,20v2c0,0.55,0.45,1,1,1s1-0.45,1-1v-2c0-0.55-0.45-1-1-1C11.45,19,11,19.45,11,20z M5.99,4.58c-0.39-0.39-1.03-0.39-1.41,0 c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0s0.39-1.03,0-1.41L5.99,4.58z M18.36,16.95 c-0.39-0.39-1.03-0.39-1.41,0c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0c0.39-0.39,0.39-1.03,0-1.41 L18.36,16.95z M19.42,5.99c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06c-0.39,0.39-0.39,1.03,0,1.41 s1.03,0.39,1.41,0L19.42,5.99z M7.05,18.36c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06 c-0.39,0.39-0.39,1.03,0,1.41s1.03,0.39,1.41,0L7.05,18.36z"/></svg><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP darkToggleIcon_wfgR"><path fill=currentColor d="M9.37,5.51C9.19,6.15,9.1,6.82,9.1,7.5c0,4.08,3.32,7.4,7.4,7.4c0.68,0,1.35-0.09,1.99-0.27C17.45,17.19,14.93,19,12,19 c-3.86,0-7-3.14-7-7C5,9.07,6.81,6.55,9.37,5.51z M12,3c-4.97,0-9,4.03-9,9s4.03,9,9,9s9-4.03,9-9c0-0.46-0.04-0.92-0.1-1.36 c-0.98,1.37-2.58,2.26-4.4,2.26c-2.98,0-5.4-2.42-5.4-5.4c0-1.81,0.89-3.42,2.26-4.4C12.92,3.04,12.46,3,12,3L12,3z"/></svg><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP systemToggleIcon_QzmC"><path fill=currentColor d="m12 21c4.971 0 9-4.029 9-9s-4.029-9-9-9-9 4.029-9 9 4.029 9 9 9zm4.95-13.95c1.313 1.313 2.05 3.093 2.05 4.95s-0.738 3.637-2.05 4.95c-1.313 1.313-3.093 2.05-4.95 2.05v-14c1.857 0 3.637 0.737 4.95 2.05z"/></svg></button></div><div class=navbarSearchContainer_Bca1></div></div></div><div role=presentation class=navbar-sidebar__backdrop></div></nav><div id=__docusaurus_skipToContent_fallback class="theme-layout-main main-wrapper mainWrapper_z2l0"><div class=docsWrapper_hBAB><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type=button></button><div class=docRoot_UBD9><aside class="theme-doc-sidebar-container docSidebarContainer_YfHR"><div class=sidebarViewport_aRkj><div class=sidebar_njMd><nav aria-label="Docs sidebar" class="menu thin-scrollbar menu_SIkG"><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=true href=/docs/intro><span title="Getting Started" class=categoryLinkLabel_W154>Getting Started</span></a></div><ul class=menu__list><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/docs/intro><span title=Introduction class=linkLabel_WmDU>Introduction</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/docs/open-navigator><span title="Open Navigator" class=linkLabel_WmDU>Open Navigator</span></a></ul><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist" href=/docs/for-families><span title="Families & Individuals" class=categoryLinkLabel_W154>Families & Individuals</span></a><button aria-label="Collapse sidebar category 'Families & Individuals'" aria-expanded=true type=button class="clean-btn menu__caret"></button></div><ul class=menu__list><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/families/community-events><span title="Resources for Families" class=categoryLinkLabel_W154>Resources for Families</span></a></div><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/docs/open-navigator><span title="Getting Started with Open Navigator" class=linkLabel_WmDU>Getting Started with Open Navigator</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/docs/data-sources/citations><span title="Data and Citations" class=linkLabel_WmDU>Data and Citations</span></a></ul><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist" href=/docs/for-advocates><span title="Policy Makers & Advocates" class=categoryLinkLabel_W154>Policy Makers & Advocates</span></a><button aria-label="Collapse sidebar category 'Policy Makers & Advocates'" aria-expanded=true type=button class="clean-btn menu__caret"></button></div><ul class=menu__list><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/data-sources/overview><span title="Understanding the Data" class=categoryLinkLabel_W154>Understanding the Data</span></a></div><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/guides/political-economy><span title="Analysis & Strategy" class=categoryLinkLabel_W154>Analysis & Strategy</span></a></div><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/case-studies/tuscaloosa-complete><span title="Real-World Examples" class=categoryLinkLabel_W154>Real-World Examples</span></a></div></ul><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--active" href=/docs/for-developers><span title="Developers & Technical Users" class=categoryLinkLabel_W154>Developers & Technical Users</span></a><button aria-label="Collapse sidebar category 'Developers & Technical Users'" aria-expanded=true type=button class="clean-btn menu__caret"></button></div><ul class=menu__list><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/quickstart><span title="Setup & Installation" class=categoryLinkLabel_W154>Setup & Installation</span></a></div><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/data-sources/citations><span title="Data Sources (Technical)" class=categoryLinkLabel_W154>Data Sources (Technical)</span></a></div><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/guides/jurisdiction-setup><span title="How-To Guides" class=categoryLinkLabel_W154>How-To Guides</span></a></div><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/integrations/mcp-server><span title=Integrations class=categoryLinkLabel_W154>Integrations</span></a></div><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=false tabindex=0 href=/docs/deployment/databricks-apps><span title=Deployment class=categoryLinkLabel_W154>Deployment</span></a></div><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" role=button aria-expanded=true tabindex=0 href=/docs/development/database-setup><span title=Development class=categoryLinkLabel_W154>Development</span></a></div><ul class=menu__list><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/database-setup><span title="Database Setup & Stats Verification" class=linkLabel_WmDU>Database Setup & Stats Verification</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/events-naming-migration><span title="File Migration to Events Naming Convention" class=linkLabel_WmDU>File Migration to Events Naming Convention</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/adding-data-sources><span title="Adding New Data Sources" class=linkLabel_WmDU>Adding New Data Sources</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/api-logging-errors><span title="API Logging & Error Handling Implementation" class=linkLabel_WmDU>API Logging & Error Handling Implementation</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/openstates-integration><span title="OpenStates Integration & Contribution Opportunities" class=linkLabel_WmDU>OpenStates Integration & Contribution Opportunities</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/real-time-statistics><span title="Real-Time Statistics with Geographic Filtering" class=linkLabel_WmDU>Real-Time Statistics with Geographic Filtering</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/schema-migration-summary><span title="Schema Migration Summary" class=linkLabel_WmDU>Schema Migration Summary</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/terminal-corruption-prevention><span title="Terminal Corruption Prevention" class=linkLabel_WmDU>Terminal Corruption Prevention</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/county-data-status><span title="County Search and Aggregation - Status Summary" class=linkLabel_WmDU>County Search and Aggregation - Status Summary</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/intel-optimization><span title="DuckDB + Intel Arc Optimization" class=linkLabel_WmDU>DuckDB + Intel Arc Optimization</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/dashboard-redesign><span title="React Dashboard Redesign Summary" class=linkLabel_WmDU>React Dashboard Redesign Summary</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/docs-migration><span title="Documentation Migration Summary" class=linkLabel_WmDU>Documentation Migration Summary</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/port-guide><span title="🚨 CRITICAL: Which Port to Use?" class=linkLabel_WmDU>🚨 CRITICAL: Which Port to Use?</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link menu__link--active" aria-current=page tabindex=0 href=/docs/development/react-refactoring><span title="React + FastAPI Databricks App Refactoring" class=linkLabel_WmDU>React + FastAPI Databricks App Refactoring</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/readme-migration><span title="README Migration Summary" class=linkLabel_WmDU>README Migration Summary</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/refactoring-summary><span title="✨ React + FastAPI Databricks App - Complete Refactoring Summary" class=linkLabel_WmDU>✨ React + FastAPI Databricks App - Complete Refactoring Summary</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/changelog><span title="Changelog - Jurisdiction Discovery System" class=linkLabel_WmDU>Changelog - Jurisdiction Discovery System</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/enhancements><span title="βœ… Enhancement Complete: Official Data Sources Integration" class=linkLabel_WmDU>βœ… Enhancement Complete: Official Data Sources Integration</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/integration-status><span title="βœ… Integration Status Summary" class=linkLabel_WmDU>βœ… Integration Status Summary</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/migration-v2><span title="βœ… Migration Complete: Pattern-Based Discovery v2.0" class=linkLabel_WmDU>βœ… Migration Complete: Pattern-Based Discovery v2.0</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/docs/development/new-capabilities><span title="πŸŽ‰ NEW CAPABILITIES SUMMARY" class=linkLabel_WmDU>πŸŽ‰ NEW CAPABILITIES SUMMARY</span></a></ul></ul></ul></nav></div></div></aside><main class=docMainContainer_TBSr><div class="container padding-top--md padding-bottom--lg"><div class=row><div class="col docItemCol_VOVn"><div class=docItemContainer_Djhp><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Z_bl" aria-label=Breadcrumbs><ul class=breadcrumbs><li class=breadcrumbs__item><a aria-label="Home page" class=breadcrumbs__link href=/><svg viewBox="0 0 24 24" class=breadcrumbHomeIcon_YNFT><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill=currentColor /></svg></a><li class=breadcrumbs__item><a class=breadcrumbs__link href=/docs/for-developers><span>Developers & Technical Users</span></a><li class=breadcrumbs__item><span class=breadcrumbs__link>Development</span><li class="breadcrumbs__item breadcrumbs__item--active"><span class=breadcrumbs__link>React + FastAPI Databricks App Refactoring</span></ul></nav><div class="tocCollapsible_ETCw theme-doc-toc-mobile tocMobile_ITEo"><button type=button class="clean-btn tocCollapsibleButton_TO0P">On this page</button></div><div class="theme-doc-markdown markdown"><header><h1>React + FastAPI Databricks App Refactoring</h1></header>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=executive-summary>Executive Summary<a href=#executive-summary class=hash-link aria-label="Direct link to Executive Summary" title="Direct link to Executive Summary" translate=no>​</a></h2>
<p>The Oral Health Policy Pulse has been <strong>completely refactored</strong> from a CLI-based multi-agent system into a <strong>modern full-stack web application</strong> that deploys as a <strong>Databricks App</strong>.</p>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=what-changed>What Changed<a href=#what-changed class=hash-link aria-label="Direct link to What Changed" title="Direct link to What Changed" translate=no>​</a></h3>
<table><thead><tr><th>Before (v1.0)<th>After (v2.0)<tbody><tr><td>❌ CLI-only interface<td>βœ… Modern React web UI<tr><td>❌ Manual command execution<td>βœ… Interactive dashboard<tr><td>❌ Text-based outputs<td>βœ… Visual charts & maps<tr><td>❌ Local deployment only<td>βœ… Cloud-native Databricks Apps<tr><td>❌ Static HTML heatmap<td>βœ… Interactive Leaflet map<tr><td>❌ No user settings<td>βœ… Configurable UI settings</table>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=new-architecture>New Architecture<a href=#new-architecture class=hash-link aria-label="Direct link to New Architecture" title="Direct link to New Architecture" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=frontend-react--typescript>Frontend (React + TypeScript)<a href=#frontend-react--typescript class=hash-link aria-label="Direct link to Frontend (React + TypeScript)" title="Direct link to Frontend (React + TypeScript)" translate=no>​</a></h3>
<p><strong>Technology Stack:</strong></p>
<ul>
<li class="">React 18.2 with TypeScript</li>
<li class="">Vite for build tooling</li>
<li class="">Tailwind CSS for styling</li>
<li class="">React Router for navigation</li>
<li class="">TanStack Query for data fetching</li>
<li class="">Recharts for data visualization</li>
<li class="">Leaflet for interactive maps</li>
</ul>
<p><strong>Pages Created:</strong></p>
<ol>
<li class="">
<p><strong>Dashboard</strong> (<code>frontend/src/pages/Dashboard.tsx</code>)</p>
<ul>
<li class="">Real-time statistics cards</li>
<li class="">Topic distribution bar/pie charts</li>
<li class="">Recent opportunities table</li>
</ul>
</li>
<li class="">
<p><strong>Interactive Heatmap</strong> (<code>frontend/src/pages/Heatmap.tsx</code>)</p>
<ul>
<li class="">Geographic visualization using Leaflet</li>
<li class="">State and topic filters</li>
<li class="">Color-coded urgency markers</li>
<li class="">Popup details for each opportunity</li>
</ul>
</li>
<li class="">
<p><strong>Documents Browser</strong> (<code>frontend/src/pages/Documents.tsx</code>)</p>
<ul>
<li class="">Full-text search</li>
<li class="">Pagination</li>
<li class="">Topic tags</li>
<li class="">Direct links to source documents</li>
</ul>
</li>
<li class="">
<p><strong>Opportunities Manager</strong> (<code>frontend/src/pages/Opportunities.tsx</code>)</p>
<ul>
<li class="">Filterable list view</li>
<li class="">Urgency-based sorting</li>
<li class="">One-click email generation</li>
<li class="">Talking points display</li>
<li class="">Confidence score visualization</li>
</ul>
</li>
<li class="">
<p><strong>Settings Panel</strong> (<code>frontend/src/pages/Settings.tsx</code>)</p>
<ul>
<li class="">Target state configuration</li>
<li class="">Policy topic selection</li>
<li class="">Confidence threshold slider</li>
<li class="">Email notification preferences</li>
<li class="">Agent status monitoring</li>
</ul>
</li>
</ol>
<p><strong>Components:</strong></p>
<ul>
<li class=""><strong>Layout</strong> (<code>frontend/src/components/Layout.tsx</code>)<!-- -->
<ul>
<li class="">Sidebar navigation</li>
<li class="">Header with breadcrumbs</li>
<li class="">Responsive design</li>
</ul>
</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=backend-fastapi-refactored>Backend (FastAPI Refactored)<a href=#backend-fastapi-refactored class=hash-link aria-label="Direct link to Backend (FastAPI Refactored)" title="Direct link to Backend (FastAPI Refactored)" translate=no>​</a></h3>
<p><strong>New File: <code>api/app.py</code></strong></p>
<p>Completely rewritten FastAPI application optimized for:</p>
<ul>
<li class="">βœ… Serving React static files (SPA routing)</li>
<li class="">βœ… REST API endpoints for all frontend interactions</li>
<li class="">βœ… Databricks Apps compatibility</li>
<li class="">βœ… Delta Lake integration</li>
<li class="">βœ… Background task processing</li>
<li class="">βœ… CORS support for local development</li>
</ul>
<p><strong>Key Endpoints:</strong></p>
<div class="language-text codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-text codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">GET /api/health # Health check</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">GET /api/dashboard # Dashboard stats</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">GET /api/opportunities # List opportunities</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">GET /api/documents # Browse documents</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">POST /api/workflow/start # Start analysis</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">POST /api/advocacy/email/{id} # Generate email</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">GET /api/settings # Get settings</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">PUT /api/settings # Update settings</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">GET /api/agents/status # Agent status</span><br/></div></code></pre></div></div>
<p><strong>Static File Serving:</strong></p>
<ul>
<li class="">React build output served from <code>api/static/</code></li>
<li class="">SPA routing with catchall route</li>
<li class="">Automatic index.html fallback</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=database-layer>Database Layer<a href=#database-layer class=hash-link aria-label="Direct link to Database Layer" title="Direct link to Database Layer" translate=no>​</a></h3>
<p><strong>New File: <code>pipeline/delta_lake_queries.py</code></strong></p>
<p>Added async query methods to support web app:</p>
<div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>get_dashboard_stats</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Dashboard statistics</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>query_opportunities</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Filtered opportunity queries</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>query_documents</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Document search/pagination</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>count_documents</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Total count for pagination</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token keyword" style=color:#00009f>async</span><span class="token plain"> </span><span class="token keyword" style=color:#00009f>def</span><span class="token plain"> </span><span class="token function" style=color:#d73a49>get_opportunity</span><span class="token punctuation" style=color:#393A34>(</span><span class="token punctuation" style=color:#393A34>)</span><span class="token plain"> </span><span class="token comment" style=color:#999988;font-style:italic># Single opportunity details</span><br/></div></code></pre></div></div>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=databricks-apps-integration>Databricks Apps Integration<a href=#databricks-apps-integration class=hash-link aria-label="Direct link to Databricks Apps Integration" title="Direct link to Databricks Apps Integration" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=configuration-files>Configuration Files<a href=#configuration-files class=hash-link aria-label="Direct link to Configuration Files" title="Direct link to Configuration Files" translate=no>​</a></h3>
<p><strong>1. app.yaml</strong> (Databricks Apps manifest)</p>
<div class="language-yaml codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-yaml codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token key atrule" style=color:#00a4db>command</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"uvicorn"</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"api.app:app"</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"--host"</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"0.0.0.0"</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"--port"</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token string" style=color:#e3116c>"8000"</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token key atrule" style=color:#00a4db>env</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>name</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> DATABRICKS_HOST</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>valueFrom</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>databricksSecret</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>key</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> host</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>scope</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> oral</span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain">health</span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain">app</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>name</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> OPENAI_API_KEY</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>valueFrom</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>databricksSecret</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>key</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> openai_key</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>scope</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> oral</span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain">health</span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain">app</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token key atrule" style=color:#00a4db>resources</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>name</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> policy</span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain">classifier</span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain">endpoint</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>modelServing</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> </span><span class="token key atrule" style=color:#00a4db>endpoint</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> policy</span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain">classifier</span><span class="token punctuation" style=color:#393A34>-</span><span class="token plain">prod</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token key atrule" style=color:#00a4db>port</span><span class="token punctuation" style=color:#393A34>:</span><span class="token plain"> </span><span class="token number" style=color:#36acaa>8000</span><br/></div></code></pre></div></div>
<p><strong>2. Dockerfile.app</strong> (Container image for Databricks Apps)</p>
<ul>
<li class="">Multi-stage build</li>
<li class="">Node.js for frontend build</li>
<li class="">Python 3.11 for backend</li>
<li class="">Optimized for CPU-only deployment</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=deployment-scripts>Deployment Scripts<a href=#deployment-scripts class=hash-link aria-label="Direct link to Deployment Scripts" title="Direct link to Deployment Scripts" translate=no>​</a></h3>
<p><strong>1. scripts/deploy-databricks-app.sh</strong></p>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain"># Automated deployment script:</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># 1. Build React frontend</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># 2. Create Databricks secrets</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># 3. Deploy to Databricks Apps</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># 4. Provide access URL</span><br/></div></code></pre></div></div>
<p><strong>2. scripts/setup-local.sh</strong></p>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain"># Local development setup:</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># - Install Python deps</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># - Install npm packages</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># - Create .env file</span><br/></div></code></pre></div></div>
<p><strong>3. scripts/test-app.py</strong></p>
<div class="language-python codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-python codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token comment" style=color:#999988;font-style:italic># Test production build locally</span><span class="token plain"></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"></span><span class="token comment" style=color:#999988;font-style:italic># Simulates Databricks Apps environment</span><br/></div></code></pre></div></div>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=project-structure>Project Structure<a href=#project-structure class=hash-link aria-label="Direct link to Project Structure" title="Direct link to Project Structure" translate=no>​</a></h2>
<div class="language-text codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-text codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">oral-health-policy-pulse/</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”œβ”€β”€ frontend/ # NEW: React application</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ src/</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”œβ”€β”€ components/</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”‚ └── Layout.tsx # Main layout component</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”œβ”€β”€ pages/</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”‚ β”œβ”€β”€ Dashboard.tsx # Dashboard page</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”‚ β”œβ”€β”€ Heatmap.tsx # Interactive map</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”‚ β”œβ”€β”€ Documents.tsx # Document browser</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”‚ β”œβ”€β”€ Opportunities.tsx # Opportunity manager</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”‚ └── Settings.tsx # Settings panel</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”œβ”€β”€ App.tsx # Root component</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ β”œβ”€β”€ main.tsx # Entry point</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”‚ └── index.css # Tailwind styles</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ package.json # npm dependencies</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ vite.config.ts # Vite configuration</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ tsconfig.json # TypeScript config</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ tailwind.config.js # Tailwind config</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ └── index.html # HTML template</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”œβ”€β”€ api/</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ app.py # NEW: Refactored FastAPI app</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ main.py # LEGACY: Original API</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ └── static/ # Built React files (generated)</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”œβ”€β”€ pipeline/</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ delta_lake.py # Original Delta Lake pipeline</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ └── delta_lake_queries.py # NEW: Query methods for web app</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”œβ”€β”€ scripts/ # NEW: Deployment scripts</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ deploy-databricks-app.sh # Deploy to Databricks</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ β”œβ”€β”€ setup-local.sh # Local development setup</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚ └── test-app.py # Test production build</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”‚</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”œβ”€β”€ app.yaml # NEW: Databricks Apps config</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”œβ”€β”€ Dockerfile.app # NEW: Production Docker image</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">β”œβ”€β”€ DATABRICKS_APP_GUIDE.md # NEW: Deployment documentation</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">└── README.md # UPDATED: Added React info</span><br/></div></code></pre></div></div>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=features-by-page>Features by Page<a href=#features-by-page class=hash-link aria-label="Direct link to Features by Page" title="Direct link to Features by Page" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=1-dashboard>1. Dashboard<a href=#1-dashboard class=hash-link aria-label="Direct link to 1. Dashboard" title="Direct link to 1. Dashboard" translate=no>​</a></h3>
<p><strong>Statistics Cards:</strong></p>
<ul>
<li class="">Total documents analyzed</li>
<li class="">Advocacy opportunities found</li>
<li class="">States monitored</li>
</ul>
<p><strong>Charts:</strong></p>
<ul>
<li class="">Topic distribution (bar chart)</li>
<li class="">Topic distribution (pie chart)</li>
</ul>
<p><strong>Recent Activity:</strong></p>
<ul>
<li class="">Latest opportunities table</li>
<li class="">Sortable and filterable</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=2-interactive-heatmap>2. Interactive Heatmap<a href=#2-interactive-heatmap class=hash-link aria-label="Direct link to 2. Interactive Heatmap" title="Direct link to 2. Interactive Heatmap" translate=no>​</a></h3>
<p><strong>Map Features:</strong></p>
<ul>
<li class="">OpenStreetMap tiles</li>
<li class="">Circle markers for opportunities</li>
<li class="">Color-coded by urgency:<!-- -->
<ul>
<li class="">πŸ”΄ Critical</li>
<li class="">🟠 High</li>
<li class="">🟑 Medium</li>
<li class="">🟒 Low</li>
</ul>
</li>
</ul>
<p><strong>Interactivity:</strong></p>
<ul>
<li class="">Click markers for details</li>
<li class="">Filter by state dropdown</li>
<li class="">Filter by topic dropdown</li>
<li class="">Real-time updates</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=3-document-browser>3. Document Browser<a href=#3-document-browser class=hash-link aria-label="Direct link to 3. Document Browser" title="Direct link to 3. Document Browser" translate=no>​</a></h3>
<p><strong>Features:</strong></p>
<ul>
<li class="">Full-text search across all documents</li>
<li class="">Pagination (20 per page)</li>
<li class="">Topic tags for each document</li>
<li class="">Direct links to source</li>
<li class="">Meeting date display</li>
<li class="">State/municipality info</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=4-opportunities-manager>4. Opportunities Manager<a href=#4-opportunities-manager class=hash-link aria-label="Direct link to 4. Opportunities Manager" title="Direct link to 4. Opportunities Manager" translate=no>​</a></h3>
<p><strong>Display:</strong></p>
<ul>
<li class="">Card-based layout</li>
<li class="">Urgency badge</li>
<li class="">Key talking points</li>
<li class="">Confidence score bar</li>
</ul>
<p><strong>Actions:</strong></p>
<ul>
<li class="">Generate advocacy email</li>
<li class="">Contact via email</li>
<li class="">Add to calendar</li>
<li class="">Copy talking points</li>
</ul>
<p><strong>Filters:</strong></p>
<ul>
<li class="">Critical only</li>
<li class="">High priority</li>
<li class="">Medium priority</li>
<li class="">Low priority</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=5-settings-panel>5. Settings Panel<a href=#5-settings-panel class=hash-link aria-label="Direct link to 5. Settings Panel" title="Direct link to 5. Settings Panel" translate=no>​</a></h3>
<p><strong>Configuration Options:</strong></p>
<ul>
<li class="">Target states (multi-select)</li>
<li class="">Policy topics (checkboxes)</li>
<li class="">Confidence threshold (slider)</li>
<li class="">Email notifications (toggle)</li>
</ul>
<p><strong>System Status:</strong></p>
<ul>
<li class="">Agent health indicators</li>
<li class="">Uptime display</li>
<li class="">Real-time status</li>
</ul>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=development-workflow>Development Workflow<a href=#development-workflow class=hash-link aria-label="Direct link to Development Workflow" title="Direct link to Development Workflow" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=local-development>Local Development<a href=#local-development class=hash-link aria-label="Direct link to Local Development" title="Direct link to Local Development" translate=no>​</a></h3>
<p><strong>1. Backend (Hot Reload)</strong></p>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">source venv/bin/activate</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">uvicorn api.app:app --reload</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Runs on http://localhost:8000</span><br/></div></code></pre></div></div>
<p><strong>2. Frontend (Hot Reload)</strong></p>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">cd frontend</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">npm run dev</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Runs on http://localhost:3000</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Proxies API calls to :8000</span><br/></div></code></pre></div></div>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=production-build>Production Build<a href=#production-build class=hash-link aria-label="Direct link to Production Build" title="Direct link to Production Build" translate=no>​</a></h3>
<p><strong>1. Build Frontend</strong></p>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">cd frontend</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">npm run build</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Outputs to api/static/</span><br/></div></code></pre></div></div>
<p><strong>2. Test Locally</strong></p>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">python scripts/test-app.py</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Serves at http://localhost:8000</span><br/></div></code></pre></div></div>
<p><strong>3. Deploy to Databricks</strong></p>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain">./scripts/deploy-databricks-app.sh</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># One-command deployment</span><br/></div></code></pre></div></div>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=benefits-of-refactoring>Benefits of Refactoring<a href=#benefits-of-refactoring class=hash-link aria-label="Direct link to Benefits of Refactoring" title="Direct link to Benefits of Refactoring" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=user-experience>User Experience<a href=#user-experience class=hash-link aria-label="Direct link to User Experience" title="Direct link to User Experience" translate=no>​</a></h3>
<table><thead><tr><th>Before<th>After<tbody><tr><td>Command-line only<td>Beautiful web interface<tr><td>Manual file management<td>Automatic workflows<tr><td>Static visualizations<td>Interactive maps & charts<tr><td>No configuration UI<td>Full settings panel<tr><td>Email via CLI<td>One-click generation</table>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=developer-experience>Developer Experience<a href=#developer-experience class=hash-link aria-label="Direct link to Developer Experience" title="Direct link to Developer Experience" translate=no>​</a></h3>
<table><thead><tr><th>Before<th>After<tbody><tr><td>Python-only<td>Full-stack (Python + TypeScript)<tr><td>Local deployment<td>Cloud-native (Databricks Apps)<tr><td>Manual setup<td>One-command deployment<tr><td>Limited monitoring<td>Built-in observability<tr><td>No UI testing<td>Component testing with Vitest</table>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=operations>Operations<a href=#operations class=hash-link aria-label="Direct link to Operations" title="Direct link to Operations" translate=no>​</a></h3>
<table><thead><tr><th>Before<th>After<tbody><tr><td>Single-user CLI<td>Multi-user web app<tr><td>Local storage<td>Cloud Delta Lake<tr><td>Manual scaling<td>Auto-scaling<tr><td>No authentication<td>Databricks SSO<tr><td>Basic logging<td>Enterprise monitoring</table>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=technology-choices>Technology Choices<a href=#technology-choices class=hash-link aria-label="Direct link to Technology Choices" title="Direct link to Technology Choices" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=why-react>Why React?<a href=#why-react class=hash-link aria-label="Direct link to Why React?" title="Direct link to Why React?" translate=no>​</a></h3>
<ul>
<li class="">βœ… Industry-standard UI framework</li>
<li class="">βœ… Rich ecosystem of libraries</li>
<li class="">βœ… TypeScript support for type safety</li>
<li class="">βœ… Excellent developer experience</li>
<li class="">βœ… Easy to maintain and extend</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=why-vite>Why Vite?<a href=#why-vite class=hash-link aria-label="Direct link to Why Vite?" title="Direct link to Why Vite?" translate=no>​</a></h3>
<ul>
<li class="">βœ… Lightning-fast dev server</li>
<li class="">βœ… Instant hot module replacement</li>
<li class="">βœ… Optimized production builds</li>
<li class="">βœ… Native ES modules support</li>
<li class="">βœ… Built-in TypeScript support</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=why-tailwind-css>Why Tailwind CSS?<a href=#why-tailwind-css class=hash-link aria-label="Direct link to Why Tailwind CSS?" title="Direct link to Why Tailwind CSS?" translate=no>​</a></h3>
<ul>
<li class="">βœ… Utility-first approach</li>
<li class="">βœ… Rapid prototyping</li>
<li class="">βœ… Consistent design system</li>
<li class="">βœ… Small production bundle</li>
<li class="">βœ… Highly customizable</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=why-databricks-apps>Why Databricks Apps?<a href=#why-databricks-apps class=hash-link aria-label="Direct link to Why Databricks Apps?" title="Direct link to Why Databricks Apps?" translate=no>​</a></h3>
<ul>
<li class="">βœ… Integrated with workspace</li>
<li class="">βœ… Automatic authentication</li>
<li class="">βœ… Unity Catalog integration</li>
<li class="">βœ… Seamless data access</li>
<li class="">βœ… Enterprise-ready</li>
</ul>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=migration-path>Migration Path<a href=#migration-path class=hash-link aria-label="Direct link to Migration Path" title="Direct link to Migration Path" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=for-existing-users>For Existing Users<a href=#for-existing-users class=hash-link aria-label="Direct link to For Existing Users" title="Direct link to For Existing Users" translate=no>​</a></h3>
<p><strong>v1.0 (CLI) β†’ v2.0 (Web App)</strong></p>
<ol>
<li class=""><strong>Keep using CLI</strong> - Original functionality preserved in <code>api/main.py</code></li>
<li class=""><strong>Gradually adopt web UI</strong> - Run both simultaneously</li>
<li class=""><strong>Full migration</strong> - Switch to web-only when ready</li>
</ol>
<p><strong>Backward Compatibility:</strong></p>
<ul>
<li class="">All CLI commands still work</li>
<li class="">Original API endpoints unchanged</li>
<li class="">Can run standalone or web mode</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=for-new-users>For New Users<a href=#for-new-users class=hash-link aria-label="Direct link to For New Users" title="Direct link to For New Users" translate=no>​</a></h3>
<p><strong>Start with Web UI:</strong></p>
<ol>
<li class="">Deploy to Databricks Apps</li>
<li class="">Access via browser</li>
<li class="">No CLI needed!</li>
</ol>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=performance-optimizations>Performance Optimizations<a href=#performance-optimizations class=hash-link aria-label="Direct link to Performance Optimizations" title="Direct link to Performance Optimizations" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=frontend>Frontend<a href=#frontend class=hash-link aria-label="Direct link to Frontend" title="Direct link to Frontend" translate=no>​</a></h3>
<ul>
<li class="">βœ… Code splitting with React lazy loading</li>
<li class="">βœ… Query caching with TanStack Query</li>
<li class="">βœ… Optimized bundle size (~300KB gzipped)</li>
<li class="">βœ… Lazy-loaded charts and maps</li>
<li class="">βœ… Debounced search inputs</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=backend>Backend<a href=#backend class=hash-link aria-label="Direct link to Backend" title="Direct link to Backend" translate=no>​</a></h3>
<ul>
<li class="">βœ… Async endpoints with FastAPI</li>
<li class="">βœ… Background task processing</li>
<li class="">βœ… Delta Lake query optimization</li>
<li class="">βœ… Static file caching</li>
<li class="">βœ… CORS preflight caching</li>
</ul>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=deployment>Deployment<a href=#deployment class=hash-link aria-label="Direct link to Deployment" title="Direct link to Deployment" translate=no>​</a></h3>
<ul>
<li class="">βœ… Scale-to-zero when idle</li>
<li class="">βœ… Auto-scaling under load</li>
<li class="">βœ… CDN for static assets</li>
<li class="">βœ… Connection pooling</li>
<li class="">βœ… Gzip compression</li>
</ul>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=next-steps>Next Steps<a href=#next-steps class=hash-link aria-label="Direct link to Next Steps" title="Direct link to Next Steps" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=planned-features>Planned Features<a href=#planned-features class=hash-link aria-label="Direct link to Planned Features" title="Direct link to Planned Features" translate=no>​</a></h3>
<p><strong>Phase 1: Enhanced Analytics</strong></p>
<ul class="contains-task-list containsTaskList_mC6p">
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Historical trend charts</li>
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Predictive analytics</li>
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Custom report builder</li>
</ul>
<p><strong>Phase 2: Collaboration</strong></p>
<ul class="contains-task-list containsTaskList_mC6p">
<li class=task-list-item><input type=checkbox disabled/> <!-- -->User comments/notes</li>
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Shared dashboards</li>
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Team workspaces</li>
</ul>
<p><strong>Phase 3: Automation</strong></p>
<ul class="contains-task-list containsTaskList_mC6p">
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Scheduled reports</li>
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Email alerts</li>
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Slack integration</li>
</ul>
<p><strong>Phase 4: Advanced AI</strong></p>
<ul class="contains-task-list containsTaskList_mC6p">
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Document Q&A chatbot</li>
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Meeting video analysis</li>
<li class=task-list-item><input type=checkbox disabled/> <!-- -->Speech-to-text integration</li>
</ul>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=deployment-examples>Deployment Examples<a href=#deployment-examples class=hash-link aria-label="Direct link to Deployment Examples" title="Direct link to Deployment Examples" translate=no>​</a></h2>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=example-1-local-testing>Example 1: Local Testing<a href=#example-1-local-testing class=hash-link aria-label="Direct link to Example 1: Local Testing" title="Direct link to Example 1: Local Testing" translate=no>​</a></h3>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain"># Setup</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">./scripts/setup-local.sh</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">source venv/bin/activate</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Run backend</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">uvicorn api.app:app --reload &</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Run frontend</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">cd frontend && npm run dev</span><br/></div></code></pre></div></div>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=example-2-production-deployment>Example 2: Production Deployment<a href=#example-2-production-deployment class=hash-link aria-label="Direct link to Example 2: Production Deployment" title="Direct link to Example 2: Production Deployment" translate=no>​</a></h3>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain"># Configure</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">export DATABRICKS_HOST=https://your-workspace.cloud.databricks.com</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">export DATABRICKS_TOKEN=dapi...</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">export OPENAI_API_KEY=sk-...</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Deploy</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">./scripts/deploy-databricks-app.sh</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Monitor</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">databricks apps logs oral-health-policy-pulse --follow</span><br/></div></code></pre></div></div>
<h3 class="anchor anchorTargetStickyNavbar_Vzrq" id=example-3-docker-deployment>Example 3: Docker Deployment<a href=#example-3-docker-deployment class=hash-link aria-label="Direct link to Example 3: Docker Deployment" title="Direct link to Example 3: Docker Deployment" translate=no>​</a></h3>
<div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style=--prism-color:#393A34;--prism-background-color:#f6f8fa><div class=codeBlockContent_QJqH><pre tabindex=0 class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style=color:#393A34;background-color:#f6f8fa><code class=codeBlockLines_e6Vv><div class=token-line style=color:#393A34><span class="token plain"># Build</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">docker build -f Dockerfile.app -t oral-health-app .</span><br/></div><div class=token-line style=color:#393A34><span class="token plain" style=display:inline-block></span><br/></div><div class=token-line style=color:#393A34><span class="token plain"># Run</span><br/></div><div class=token-line style=color:#393A34><span class="token plain">docker run -p 8000:8000 \</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> -e DATABRICKS_HOST=$DATABRICKS_HOST \</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> -e OPENAI_API_KEY=$OPENAI_API_KEY \</span><br/></div><div class=token-line style=color:#393A34><span class="token plain"> oral-health-app</span><br/></div></code></pre></div></div>
<hr/>
<h2 class="anchor anchorTargetStickyNavbar_Vzrq" id=conclusion>Conclusion<a href=#conclusion class=hash-link aria-label="Direct link to Conclusion" title="Direct link to Conclusion" translate=no>​</a></h2>
<p>The <strong>React + FastAPI refactoring</strong> transforms Oral Health Policy Pulse from a developer-focused CLI tool into an <strong>enterprise-ready web application</strong> that can be:</p>
<p>βœ… <strong>Deployed instantly</strong> to Databricks Apps<br/>
<!-- -->βœ… <strong>Used by non-technical users</strong> via web browser<br/>
<!-- -->βœ… <strong>Scaled automatically</strong> for any load<br/>
<!-- -->βœ… <strong>Monitored comprehensively</strong> with built-in observability<br/>
<!-- -->βœ… <strong>Secured enterprise-grade</strong> with Databricks SSO</p>
<p><strong>The future of oral health advocacy is here! 🦷✨</strong></div><footer class="theme-doc-footer docusaurus-mt-lg"><div class="row margin-top--sm theme-doc-footer-edit-meta-row"><div class="col noPrint_WFHX"><a href=https://github.com/getcommunityone/open-navigator-for-engagement/tree/main/website/docs/development/react-refactoring.md target=_blank rel="noopener noreferrer" class=theme-edit-this-page><svg fill=currentColor height=20 width=20 viewBox="0 0 40 40" class=iconEdit_Z9Sw aria-hidden=true><g><path d="m34.5 11.7l-3 3.1-6.3-6.3 3.1-3q0.5-0.5 1.2-0.5t1.1 0.5l3.9 3.9q0.5 0.4 0.5 1.1t-0.5 1.2z m-29.5 17.1l18.4-18.5 6.3 6.3-18.4 18.4h-6.3v-6.2z"/></g></svg>Edit this page</a></div><div class="col lastUpdated_JAkA"></div></div></footer></article><nav class="docusaurus-mt-lg pagination-nav" aria-label="Docs pages"><a class="pagination-nav__link pagination-nav__link--prev" href=/docs/development/port-guide><div class=pagination-nav__sublabel>Previous</div><div class=pagination-nav__label>🚨 CRITICAL: Which Port to Use?</div></a><a class="pagination-nav__link pagination-nav__link--next" href=/docs/development/readme-migration><div class=pagination-nav__sublabel>Next</div><div class=pagination-nav__label>README Migration Summary</div></a></nav></div></div><div class="col col--3"><div class="tableOfContents_bqdL thin-scrollbar theme-doc-toc-desktop"><ul class="table-of-contents table-of-contents__left-border"><li><a href=#executive-summary class="table-of-contents__link toc-highlight">Executive Summary</a><ul><li><a href=#what-changed class="table-of-contents__link toc-highlight">What Changed</a></ul><li><a href=#new-architecture class="table-of-contents__link toc-highlight">New Architecture</a><ul><li><a href=#frontend-react--typescript class="table-of-contents__link toc-highlight">Frontend (React + TypeScript)</a><li><a href=#backend-fastapi-refactored class="table-of-contents__link toc-highlight">Backend (FastAPI Refactored)</a><li><a href=#database-layer class="table-of-contents__link toc-highlight">Database Layer</a></ul><li><a href=#databricks-apps-integration class="table-of-contents__link toc-highlight">Databricks Apps Integration</a><ul><li><a href=#configuration-files class="table-of-contents__link toc-highlight">Configuration Files</a><li><a href=#deployment-scripts class="table-of-contents__link toc-highlight">Deployment Scripts</a></ul><li><a href=#project-structure class="table-of-contents__link toc-highlight">Project Structure</a><li><a href=#features-by-page class="table-of-contents__link toc-highlight">Features by Page</a><ul><li><a href=#1-dashboard class="table-of-contents__link toc-highlight">1. Dashboard</a><li><a href=#2-interactive-heatmap class="table-of-contents__link toc-highlight">2. Interactive Heatmap</a><li><a href=#3-document-browser class="table-of-contents__link toc-highlight">3. Document Browser</a><li><a href=#4-opportunities-manager class="table-of-contents__link toc-highlight">4. Opportunities Manager</a><li><a href=#5-settings-panel class="table-of-contents__link toc-highlight">5. Settings Panel</a></ul><li><a href=#development-workflow class="table-of-contents__link toc-highlight">Development Workflow</a><ul><li><a href=#local-development class="table-of-contents__link toc-highlight">Local Development</a><li><a href=#production-build class="table-of-contents__link toc-highlight">Production Build</a></ul><li><a href=#benefits-of-refactoring class="table-of-contents__link toc-highlight">Benefits of Refactoring</a><ul><li><a href=#user-experience class="table-of-contents__link toc-highlight">User Experience</a><li><a href=#developer-experience class="table-of-contents__link toc-highlight">Developer Experience</a><li><a href=#operations class="table-of-contents__link toc-highlight">Operations</a></ul><li><a href=#technology-choices class="table-of-contents__link toc-highlight">Technology Choices</a><ul><li><a href=#why-react class="table-of-contents__link toc-highlight">Why React?</a><li><a href=#why-vite class="table-of-contents__link toc-highlight">Why Vite?</a><li><a href=#why-tailwind-css class="table-of-contents__link toc-highlight">Why Tailwind CSS?</a><li><a href=#why-databricks-apps class="table-of-contents__link toc-highlight">Why Databricks Apps?</a></ul><li><a href=#migration-path class="table-of-contents__link toc-highlight">Migration Path</a><ul><li><a href=#for-existing-users class="table-of-contents__link toc-highlight">For Existing Users</a><li><a href=#for-new-users class="table-of-contents__link toc-highlight">For New Users</a></ul><li><a href=#performance-optimizations class="table-of-contents__link toc-highlight">Performance Optimizations</a><ul><li><a href=#frontend class="table-of-contents__link toc-highlight">Frontend</a><li><a href=#backend class="table-of-contents__link toc-highlight">Backend</a><li><a href=#deployment class="table-of-contents__link toc-highlight">Deployment</a></ul><li><a href=#next-steps class="table-of-contents__link toc-highlight">Next Steps</a><ul><li><a href=#planned-features class="table-of-contents__link toc-highlight">Planned Features</a></ul><li><a href=#deployment-examples class="table-of-contents__link toc-highlight">Deployment Examples</a><ul><li><a href=#example-1-local-testing class="table-of-contents__link toc-highlight">Example 1: Local Testing</a><li><a href=#example-2-production-deployment class="table-of-contents__link toc-highlight">Example 2: Production Deployment</a><li><a href=#example-3-docker-deployment class="table-of-contents__link toc-highlight">Example 3: Docker Deployment</a></ul><li><a href=#conclusion class="table-of-contents__link toc-highlight">Conclusion</a></ul></div></div></div></div></main></div></div></div><footer class="theme-layout-footer footer footer--dark"><div class="container container-fluid"><div class="row footer__links"><div class="theme-layout-footer-column col footer__col"><div class=footer__title>Documentation</div><ul class="footer__items clean-list"><li class=footer__item><a class=footer__link-item href=/docs/intro>Getting Started</a><li class=footer__item><a class=footer__link-item href=/docs/data-sources/citations>Citations & Data Sources</a><li class=footer__item><a class=footer__link-item href=/docs/data-sources/overview>Data Sources</a><li class=footer__item><a class=footer__link-item href=/docs/for-developers>For Developers</a></ul></div><div class="theme-layout-footer-column col footer__col"><div class=footer__title>Resources</div><ul class="footer__items clean-list"><li class=footer__item><a href=https://www.communityone.com target=_blank rel="noopener noreferrer" class=footer__link-item>Launch Open Navigator<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://github.com/getcommunityone/open-navigator-for-engagement target=_blank rel="noopener noreferrer" class=footer__link-item>GitHub<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://www.groundvue.org/ target=_blank rel="noopener noreferrer" class=footer__link-item>GroundVue (Partner)<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a></ul></div><div class="theme-layout-footer-column col footer__col"><div class=footer__title>Community</div><ul class="footer__items clean-list"><li class=footer__item><a href=https://www.instagram.com/getcommunityone/ target=_blank rel="noopener noreferrer" class=footer__link-item>Instagram<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://www.facebook.com/getcommunityone target=_blank rel="noopener noreferrer" class=footer__link-item>Facebook<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://x.com/getcommunityone/ target=_blank rel="noopener noreferrer" class=footer__link-item>X (Twitter)<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://www.linkedin.com/company/getcommunityone target=_blank rel="noopener noreferrer" class=footer__link-item>LinkedIn<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://www.youtube.com/@getcommunityone target=_blank rel="noopener noreferrer" class=footer__link-item>YouTube<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li class=footer__item><a href=https://discord.gg/uH6Dytek target=_blank rel="noopener noreferrer" class=footer__link-item>Discord<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a></ul></div><div class="theme-layout-footer-column col footer__col"><div class=footer__title>Legal</div><ul class="footer__items clean-list"><li class=footer__item><a class=footer__link-item href=/docs/legal/privacy-policy>Privacy Policy</a><li class=footer__item><a class=footer__link-item href=/docs/legal/terms-of-service>Terms of Service</a><li class=footer__item><a class=footer__link-item href=/docs/legal/data-provider-terms>Data Provider Terms</a></ul></div><div class="theme-layout-footer-column col footer__col"><div class=footer__title>More</div><ul class="footer__items clean-list"><li class=footer__item><a class=footer__link-item href=/blog>Blog</a><li class=footer__item><a href=https://github.com/getcommunityone/open-navigator-for-engagement/blob/main/LICENSE target=_blank rel="noopener noreferrer" class=footer__link-item>License (MIT)<svg width=13.5 height=13.5 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a></ul></div></div><div class="footer__bottom text--center"><div class=footer__copyright>Copyright © 2026 Community One. Built with Docusaurus.</div></div></div></footer></div></body>