Indicator - poverty rate

developmentseed / moz-datapipeline

Mozambique Road Planning data pipeline

MIT License

4 stars 1 forks source link

Indicator - poverty rate #6

Closed olafveerman closed 6 years ago

olafveerman commented 6 years ago

Measure the poverty rate of the area the road is serving.

olafveerman commented 6 years ago

The shapefile Poverty_Map_2007_based_on_Vasco_stata_data_using_national_poverty_line.shp contains an attribute Pov_HeadCn.

@XaviEspinet can you confirm that this is normalized on a 0-1 scale, with 0 being low poverty and 1 high poverty for that particular area? Since a road segment may span several areas, the final score for a road segment will be the average Pov_HeadCn weighted by % of road in an area.

XaviEspinet commented 6 years ago

Hi Olaf, I have added another shapefile MozamP2 - that includes POV_HCR that is poverty head count ratio, that is percentage of % of poor people. so yes, weighted average.

Then you need to add the xls p2Mozambique to this shapefile using code ZS_ID to merge both. On that xls you find ArtFiMean - that is a value for fishery potential - to use for fishery potential.

olafveerman commented 6 years ago

Thanks @XaviEspinet I don't think I see the MozamP2 shapefile, I do see the .csv and .xls

XaviEspinet commented 6 years ago

Take a look again and let me know.

olafveerman commented 6 years ago

Got it, thanks!

is the ZS_ID an official id system for the districts? If so, we will take that into account and make it easier to relate other information in the future.
there are some missing areas in the MozamP2 shapefile. See note below.
do you have any information about the source of the data that we can include in the documentation?

Missing areas in MozamP2

There are a couple of areas with 'holes' in them. Take for example Chimbonila district in Niassa province:

There are actual roads (red lines in the image) going through those areas. At this point we will just ignore these areas, which means that those road segments will get a 0 value.

olafveerman commented 6 years ago

cc @XaviEspinet on that last note

XaviEspinet commented 6 years ago

Sure.

olafveerman commented 6 years ago

This is now on the master branch. Sample of the results:

wayId,score
R1253-T9146,71.0552
R761-T9039,65.74464035637963
R768-T9137,66.52899670552264
R769-T9138,65.86658846714614