OpenXmlDeveloper Countries

Published 11 January 07 11:30 AM

If anybody knows a good automated way to convert IP addresses to locations, let me know. I've looked around but haven't found one that's both free and programmatically accessible. I suppose I could actually pay for a service, but I'm trying to find the cheap option first.

The reason I'm looking is that I'd like to see where our members on OpenXmlDeveloper.org are located, so that I can share this information periodically on the site. It would also be interesting to see which types of articles draw viewers from which regions. But the usage reports on the site are all raw data that just lists the IP addresses, so I need to convert those to locations. I'm thinking there's probably an option out there that I'm not aware of, since this must be a common need.

FYI, I manually spot-checked some random visitors from 2006 (by pasting the IP address into lookup options on various sites), and here are the countries represented in my random sample:

Argentina
Australia
Brazil
Canada
China
Denmark
Ecuador
France
Germany
Hong Kong
India
Japan
Korea
Mexico
Netherlands
New Zealand
Nicaragua
Norway
Poland
Russia
South Africa
Spain
Sweden
Taiwan
Turkey
Uganda
United Kingdom
United States
by dmahugh
Filed under:

Comments

# Dennis E. Hamilton said on January 11, 2007 7:33 PM:

This is rather neat, but I don't know if you want to rely on an externally-hosted web site to do it for you:

http://clustrmaps.com/index.htm

This might not be the only one.  Weren't you looking at Google Analytics?

# dmahugh said on January 11, 2007 7:41 PM:

Yeah, I was hoping to find a way to convert any arbitrary list of IP addresses, so that I could look at historical activity too (which I only have available as IP addresses).  But going forward, one of these approaches might work well.

I have Google Analytics on my personal blog and generally like it, but I've not looked at alternatives.  You use clustrmaps, right?  Anything in particular you do/don't like about it?  The maps are a nice visual presentation of the data.

# Sander said on January 12, 2007 3:04 AM:

This may do the trick:

http://api.hostip.info/?ip=<ipaddress>

# Annette said on January 15, 2007 8:56 AM:

Hello,

:) So many countrys are represented here :)

How about creating a field in the userprofile so everybody can type in his/her country, to let the others know.

By the way. I'm from germany.

Regards,

Annette

New Comments to this post are disabled

This Blog

Syndication

Page view tracker