[Updated to show all users until 15 March 2014]
I just created a map of all the recent activity in OppiaMobile Android app based on the IP addresses our users are visiting from:
The map is just a point-in-time visualization of all our current users and since it’s based on IP addresses the locations aren’t exact (for example all users in Ethiopia are shown as being in Addis), but it’s sufficient to get a good impression on a country/regional level. The size of each ‘blob’ represents how many hits we’ve had from that location.
For info, here’s the process I went through to generate the map:
- Exact all the distinct IP address from our server logs
- Look up the IP address to get the city/region and country from the IPAddressLabs web service. I only signed up for their basic trial version – which doesn’t give the lat/lng – hence the requirement for the next step
- Look up the city and country using the GeoNames web service to get the lat/lng to then match up the IP address.
- Export the data and upload into CartoDB to create the visualization
Hopefully soon I’ll figure out how to make this a live map so it’s dynamically updated.