On 18 Nov 2009, at 15:38, Tim Morley wrote: > Slightly OT as far as mySoc is concerned, so apologies for that, but > nonetheless related to the kind of discussion that often happens here: > > Is there an easy way to convert a spreadsheet column full of IP addresses to > a pretty set of pins stuck in a map, to show the (approximate) location of > the people who've signed up to my web service?
The locations are very approximate. Usually, you'll get the right country. Sometimes, you'll get the right county. I'm in Lewes, East Sussex, 60 miles south of London. But my IP address is apparently located in Rickmansworth, Herts. That's three counties away, on the other side of London 80 miles away. My guess is that any plusnet subscriber would be located in Rickmansworth. > Google Maps would be fine on this particular occasion, but bonus points for > using OpenStreetMap or similar if possible. > > Thanks in advance for your help. > > > Tim > > > > _______________________________________________ > Mailing list [email protected] > Archive, settings, or unsubscribe: > https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public -- Ian Eiloart _______________________________________________ Mailing list [email protected] Archive, settings, or unsubscribe: https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public
