India Tuberculosis Tracker

We extracted 2017 district-wise TB data sets from the 2018 annual TB report linked here:  https://www.tbcindia.gov.in/showfile.php?lid=331.

Using district-level information for vaccines, we generated a crosswalk between districts and parliamentary constituencies. We adopted a dasymetric mapping technique that allowed for weighting of the population in each PC assuming the indicators were distributed uniformly across the population in one district. See the workflow below for more details:

1. Calculate district area (dist_area): perform 'Calculate Geometry' function on the district shapefile, using the Kalianpur 1975/lndia Zone lla (EPSG: 24379) coordinate system
2. Calculate district population (dist_pop) in 2015: perform 'zonal statistics' command using district shapefile as the 'zone' and the WoldPop2015 as the data raster
3. Link each segment contained both district ID and PC ID of the overlapping over: perform 'intersect' command to district and PC shapefile, create a new shapefile called Dist_PC_intersect. In total, there are 3,828 segments
4. Calculate segment area (seg_area) and segment population in 2015 (seg_pop) following step 1 and 2
5. Calculate percentage of district population (Pct_pop) in each segment: divide segment population by district population in 2015, this is the estimate for percentage of population in 2017.
6. Calculate percentage of district area (Pct_ area) in each segment by segment area dividing district area. Remove segments that was less than a hundredth of a percent of the original district area. Those extremely small area are created possibly because the slightly boundary inaccuracies between district and PC shapefiles. A hundredth is chosen as a conservative threshold. There remains 3,377 in the intersected shapefile
7. Calculate number of total patients notified in each segment: multiply total patients notified in the district by percentage of district population (2015) in the given segment
8. Calculate segment population in 2017: multiply district population in 2017 (from TB report ) by percentage of population (Pct_pop, from WorldPop2015)
9. Calculate PC level estimates for total patients notified and population: aggregated segment level total patients notified , and population by PC ID
10. Calculate PC level total patients notified per 100,000 population