Microfinance in India: Getting a sense of the geographic distribution

I am working on a review paper on microfinance in India and use data from the MIX market. Today, I was amazed by how quick I conjured a map of India with the headquarters of the microfinance institutions that report data to the MIX market depicted on that map. Ideally, I would have more geolocation data – but this is hard to come by. But what we can clearly see is the clustering of institutions in big cities and in the south, which was hit hardest by the recent crisis.

Microfinance Institutions across India

 

I dont think anybody has produced such a map before. In fact, I can do this for all institutions reporting data around the world, which may be interesting to see. Also, I already tried to make the size of the dot proportional to e.g. measures of real yield or color-coding the nearest neighborhood (say the neigbhouring districts) by the average loan sizes reported. Lots of things to do. Maybe thats something for the guys at MIX Market or for David Roodman who, I think has finished his open book.

The key difficulty was actually not in plotting the map (though it took some time), but in obtaining geo-data on where the headquarters of the microfinance institutions are located. I managed to obtain this data – though its not perfect – by making calls to the Google MAP API via a PHP script., basically using the following two functions:

Selec All Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
function ResponseToArray($response) {
 
	return json_decode($response,true);
}
 
function findLocation($string) {
 
	$url = "http://maps.google.com/maps/geo?q=".$string."&output=json&sensor=true_or_false&key=your_api_key";
 
	$raw = file_get_contents($url);
 
	$geodata = ResponseToArray($raw);
 
	$point = $geodata["Placemark"][0]["Point"]["coordinates"];
 
return $point;
 
}

The first one transforms the JSON return into an array and the latter, actually does the call. The variable $string should contain the actual paramters, such as the city and the zip code of where the institution is located.

 

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • MisterWong
  • Y!GG
  • Webnews
  • Digg
  • del.icio.us
  • StumbleUpon
  • Reddit

2 thoughts on “Microfinance in India: Getting a sense of the geographic distribution”

  1. This is great! Branch-level data would be better, but this is at least a start. CMF and MFIN also have maps on their sites, which could yield more useful information. We also did something similar for Nigeria recently, maybe you will find that useful: http://www.themix.org/publications/mix-microfinance-world/2011/08/mapping-nigerian-microfinance-banks

    For what it’s worth, this was a helpful tutorial on getting address info from APIs that we’ve used: http://support.mapbox.com/kb/tilemill/converting-addresses-in-spreadsheets-to-custom-maps-in-tilemill

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">

Login with Facebook: