search

USAID-OHA-SI / TeamTracking

Project Management Tracker for the SI Team
0 stars 0 forks source link

Create maps of where CBWs are in relation to facilities in 4 districts in SA #57

Closed gsarfaty closed 5 years ago

gsarfaty commented 5 years ago

Create maps using HRH2030 CBW assessment data to show where community based workers are that could be leveraged to improve TX outcomes.

Request from HW Branch to supplement a large analysis HRH2030 is already doing with the assessment data. In follow up to earlier DG conversations, we agreed it would be easier for us to do this small mapping portion in house than to go through dg processes that would be required for HRH2030 to receive any PEPFAR-collected data. Doing it this way, they received no data from us. Instead they sent us the assessment data they collected.

eThekini & Johannesburg drafts done. Ehlanzeni & Ekhurhuleni to come.

FYI - @jrose202. Diana is expecting the full HRH analysis to come in tonight from the project side, which if suitable, I'm sure she'll use on TDY this week.

gsarfaty commented 5 years ago

Remaining two districts drafted. Need to check on merging raw tables w/condensed shp to show difference in the cadres of CBWs if possible. Also indicate # of CBWs in an area - can be hard to see when not zoomed into neighborhood level.

gsarfaty commented 5 years ago

Merged raw tables to condensed shp from the project to show organization affiliated with each CBW, and iterated on a few versions of the outputs w/Diana throughout the week.

Just received targeted list of sites from DF to update the outputs with that are in line w/current country strategy.

gsarfaty commented 5 years ago

Had several exchanges w/DF last week re: re-running to align CBWs to A) testing & linkage tasks, and then separately for B) retention-related tasks.

Was set to do that when partner who did the assessment was asked to add variable to the dataset regarding who funded the CBWs. Partner added that to an Excel table COB 2/7. On 2/8, I manipulated the data so that the funding variable could be added to the existing shapefiles we were working with.

Also chatted w/DF further on 2/7 re: changing the medium for the outputs to allow for interactivity. Formatted the data for Tableau 2/8 and developed working draft 2/11.

gsarfaty commented 5 years ago

Finalized output in tableau and shared w/the team + @jrose202.