wanna help me test something? - GoFuckYourself.com

heywood · 08-30-2006, 12:12 AM

So I downloaded the freeware GeoIP database in csv format and put together a little app:

http://sandbox.jeremymorgan.com/geo/location.php

Type in your actual city, and we'll see how accurate it is. I'm testing the accuracy of this database, and see if it's usable.

In exchange, I'll share my findings/code to GFY members, in case you want to implement this on your site.

You can view the results here:

http://sandbox.jeremymorgan.com/geo/location.php?mode=show

Bro Media - BANNED FOR LIFE · 08-30-2006, 12:12 AM

nice Jeremy, i'll be interested in this down the road

JD · 08-30-2006, 12:15 AM

Hello user from , WA

Your IP is 71.231.250.135

What is this?

This is just a silly program to try and guess what city you are coming from based on your IP address. This is based on an open source database called geoIP, you can download a binary, or a csv file like I did, and drop it into a database.

User says:

GEOIP says:
university place

, WA
Guttenberg, IA

Dubuque, IA
orlando

Orlando, FL
kerman,ca

Stockton, CA
Wilsonville, OR

Beaverton, OR

heywood · 08-30-2006, 12:21 AM

Cool, I downloaded the csv, and dumped it into a mysql database, there is a shitload of records. Even on my local webserver (no load whatsoever) queries take around 5 seconds, so I'm guessing using their binary version is faster. I tried indexing the tables and optimizing things, but it hasn't done much.

I plan on optimizing it, and maybe coming up with a US-only database to hit. I'll share my code in this thread, with a small class to extract data, it's pretty simple.

I know it won't be totally accurate, they disclose that on their site, the free version is much less accurate than paid, but if it's in the close vicinity, I don't see why we couldn't use it, if anything just to attact the user's attention, or maybe even to do some demographic study for your paysite members. I'll keep everyone posted in this thread with whatever I come up with.

Fizzgig · 08-30-2006, 12:29 AM

I didn't get it.

2HousePlague · 08-30-2006, 12:37 AM

Fuzzy.

2hp

the alchemist · 08-30-2006, 12:42 AM

User says: Montreal, QC, Canada

GEOIP says:

Whitby, ON
Ontario

Salt Lake City, UT
san francisco

Greenville, SC
bhubaneswar

New Delhi, 07
oak forest

Hinsdale, IL
Lumby, Canada

,
Buenos Aires, Argentina

,
Fucknugget, Kentucky

Stockton, CA
Montreal, Canada

Montréal, QC
Austria

,
university place

, WA
Guttenberg, IA

Dubuque, IA
orlando

Orlando, FL
kerman,ca

Stockton, CA
Wilsonville, OR

Beaverton, OR

heywood · 08-30-2006, 02:19 AM

Quote:

Originally Posted by 2HousePlague

Fuzzy.

2hp

Ok, I definitely don't get this one.

Antonio · 08-30-2006, 02:44 AM

I live in South Africa, your script didn't say shit ;)

so much about free geoip database, saw another one - Czech Republic - the same story, is it only for the US?

heywood · 08-30-2006, 05:38 PM

Quote:

Originally Posted by Antonio

I live in South Africa, your script didn't say shit ;)

so much about free geoip database, saw another one - Czech Republic - the same story, is it only for the US?

No, it's supposedly worldwide. I did see a few non-us entries in there so far. As far as SA goes, not sure which cities/provinces/countries it includes, but I'll do a query on it later and find out.

heywood · 09-11-2006, 06:16 AM

As it turns out, the accuracy of this is not great.

However, I dont know if the extra accuracy is even worth it anyway. Some people have ISP routers that are 20-30 miles away anyway, so the extra accuracy may not be worth it.

I ended up downloading the binary version and working against it, it is substantially faster. Using their API, I was able to get results 1/10th of the time the database version is.

So I would highly reccomend just using that version instead, and forget the DB version. At least in my case, it was very very slow on a production machine.

08-30-2006, 12:12 AM	#1
heywood So Fucking Banned Join Date: Jun 2003 Location: Wilsonville, Oregon Posts: 468	wanna help me test something? So I downloaded the freeware GeoIP database in csv format and put together a little app: http://sandbox.jeremymorgan.com/geo/location.php Type in your actual city, and we'll see how accurate it is. I'm testing the accuracy of this database, and see if it's usable. In exchange, I'll share my findings/code to GFY members, in case you want to implement this on your site. You can view the results here: http://sandbox.jeremymorgan.com/geo/location.php?mode=show

08-30-2006, 12:29 AM	#5
Fizzgig Registered User Join Date: Feb 2004 Location: In Your Dreams Posts: 9,649	I didn't get it. __________________ ---'-,-{@ Sassy Grrrl @}-'-,---

08-30-2006, 12:37 AM	#6
2HousePlague CURATOR Join Date: Jul 2004 Location: the attic Posts: 14,572	Fuzzy. 2hp __________________ tada!

08-30-2006, 12:42 AM	#7
the alchemist Confirmed User Industry Role: Join Date: Dec 2004 Location: Montreal, Canada Posts: 3,271	User says: Montreal, QC, Canada GEOIP says: Whitby, ON Ontario Salt Lake City, UT san francisco Greenville, SC bhubaneswar New Delhi, 07 oak forest Hinsdale, IL Lumby, Canada , Buenos Aires, Argentina , Fucknugget, Kentucky Stockton, CA Montreal, Canada Montréal, QC Austria , university place , WA Guttenberg, IA Dubuque, IA orlando Orlando, FL kerman,ca Stockton, CA Wilsonville, OR Beaverton, OR __________________ 264 349 400

08-30-2006, 12:12 AM	#2
Bro Media - BANNED FOR LIFE MOBILE PORN: IMOBILEPORN Join Date: Jan 2004 Location: Tinseltown NL Posts: 16,502	nice Jeremy, i'll be interested in this down the road

08-30-2006, 12:15 AM	#3
JD Too lazy to set a custom title Industry Role: Join Date: Sep 2003 Posts: 22,651	Hello user from , WA Your IP is 71.231.250.135 What is this? This is just a silly program to try and guess what city you are coming from based on your IP address. This is based on an open source database called geoIP, you can download a binary, or a csv file like I did, and drop it into a database. User says: GEOIP says: university place , WA Guttenberg, IA Dubuque, IA orlando Orlando, FL kerman,ca Stockton, CA Wilsonville, OR Beaverton, OR

08-30-2006, 12:21 AM	#4
heywood So Fucking Banned Join Date: Jun 2003 Location: Wilsonville, Oregon Posts: 468	Cool, I downloaded the csv, and dumped it into a mysql database, there is a shitload of records. Even on my local webserver (no load whatsoever) queries take around 5 seconds, so I'm guessing using their binary version is faster. I tried indexing the tables and optimizing things, but it hasn't done much. I plan on optimizing it, and maybe coming up with a US-only database to hit. I'll share my code in this thread, with a small class to extract data, it's pretty simple. I know it won't be totally accurate, they disclose that on their site, the free version is much less accurate than paid, but if it's in the close vicinity, I don't see why we couldn't use it, if anything just to attact the user's attention, or maybe even to do some demographic study for your paysite members. I'll keep everyone posted in this thread with whatever I come up with.

08-30-2006, 02:44 AM	#9
Antonio Too lazy to set a custom title Join Date: Oct 2001 Location: Spartaaaaaaaaa Posts: 14,136	I live in South Africa, your script didn't say shit ;) so much about free geoip database, saw another one - Czech Republic - the same story, is it only for the US?

09-11-2006, 06:16 AM	#11
heywood So Fucking Banned Join Date: Jun 2003 Location: Wilsonville, Oregon Posts: 468	As it turns out, the accuracy of this is not great. However, I dont know if the extra accuracy is even worth it anyway. Some people have ISP routers that are 20-30 miles away anyway, so the extra accuracy may not be worth it. I ended up downloading the binary version and working against it, it is substantially faster. Using their API, I was able to get results 1/10th of the time the database version is. So I would highly reccomend just using that version instead, and forget the DB version. At least in my case, it was very very slow on a production machine.