kmuthusi/cdc-kenya-footprint

# CDC Kenya Footprint Dashboard Interactive Streamlit MVP for exploring CDC activities in Kenya by national, county, sub-county, and facility/site footprint. ## Run ```powershell python -m streamlit run app.py --server.port 8501 ``` Then open: ```text localhost ``` ## Local Secrets The dashboard does not require runtime secrets to open locally. Deployment to Posit Connect can use a local `.env` file for your personal Connect credentials. Create `.env` from `.env.example` and fill in your values: ```env CONNECT_API_KEY=your-posit-connect-api-key CONNECT_SERVER=rconnect.edav.cdc.gov CONNECT_NICKNAME=cdc-kenya-footprint CONNECT_APP_ID= CDC_RELEASE_DATE= ``` `.env` is ignored by Git and should not be committed. ## Included MVP Features - National/county choropleth map using the supplied `ken_admbnda_adm1_counties` shapefile; the normalized local copy is `data/kenya_counties.geojson`. - Facility/site point map from workbook coordinates. - DGHT `TX_CURR` layer merged from `FY26Q2 TX_CURR_Site listing_13.07.xlsx` to `MFLCODE_FacilityExportMaterialList_26022026_Recent.xlsx`; the DGHT indicator values are as of **31 March 2026**, with automatic latitude/longitude correction and canonical geography overwrite from the MFL reference. - Curated POE point lookup for the Border Health sheet. - Sidebar filters for CDC Program, Project, Activity, county, sub-county, implementer, and map metric. - DGHT HIV Incidence project with county-level incidence results and mapped contributing pre-ART VL sites. - DGHT HIV Estimates project with county-level PLHIV, new infections, ART, PMTCT, MTCT, viral suppression, and AIDS death indicators from the June 2026 estimates workbook. These records support county shading and briefing metrics but do not create facility map points. - County or national factsheet export as print-ready HTML. - Internal Data quality panel with source counts, coordinate coverage, TX_CURR records needing review, POE geocode coverage, and cou …