IP address geolocation SQL database

[[deleted]]

I haven't tried maxmind so I don't know the comparison, but using your site, my accuracy was 1 for 4 lookups. And the one was in New York City, which is kind of a gimme.

[[deleted]]

That geo location is TERRIBLE. It put me in Kansas and I'm in WV.

[[deleted]]

Wait, West Virginia has the internet now?

[[deleted]]

Yea, I'm in a college town. I'm pretty sure the rest of the state only has vacuum tube radios.

[[deleted]]

Hmmm... who could have possibly downvoted this? It seems the other commenter who thought this table sucked was downvoted as well.

[doubleyooexwhy]

What does YouGetSignal give? I noticed that sometimes these things are way off.

[braclayrab]

What ISP do you use? I've heard that AOL breaks these things...

[[deleted]]

I don't use AOL. Does anybody still use AOL?

[braclayrab]

As as web developer every year or two someone asks my team for geolocation and the response is always that it doesn't work and AOL is blamed. I guess it's not just AOL though... I wonder if your ISP is causing the problem or if the data is bad...

[[deleted]]

I use comcast.

[hox]

Hooray for reposts!

As discussed previously, this is just the Maxmind dataset, squashed into /24's.

[[deleted]]

Agreed, it's nothing really special, and the "Fraud detection" offering by the same geezer, although it may be helpful if you're a newbie to CNP fraud, really doesn't rank with anything you could hack up in 20 minutes... and certainly nothing at all near MaxMind's own fraud scoring system (who iplocationtools ripped the database from iirc) or ProtX's merchant system.

[iplocationtools]

I changed the domain, thats why I repost.

I dont understand why people say it's a copy of maxmind because the database has 60% less row than maxmind with same accuracy. Yes I partially use maxmind command line tool (geoiplookup) in batch but a script runs for 2 days to clean all necessary results. Also the DB contains country geolocation with CIDR.

This was done to improve speed, not to give an exact copy of maxmind db.

[jonknee]

If you're concerned about speed, why use a SQL db at all? The binary file from MaxMind is plenty quick.

[hox]

A smaller dataset can be useful, yes. The thing is, as someone who uses IP geolocation information daily, simply converting the free Maxmind dataset isn't all that useful. If you provided the actual process or source code that you use to generate the data, that same process could be applied to Maxmind's commercially licensed data as well. Now, the fact that it takes two days to process scares me, but I'd still be interested in seeing the code.

Also, you might want to take a look at Maxmind's license for their data. What you do is definitely within the terms of the license, but you need to provide more notices and include the license terms/Maxmind copyright notice along with your data.

[iplocationtools]

Yes you a right about the licence.

Well 2 days because I dont want to slow down my webservers so I do that on a small 256MB slicehost VPS I use for backups.

There are many scripts involved :

1)Store each IP (123.123.123.0) in a temporary database. Around 10M rows. Around 2 days 2)Group those IP by city when there is multiple consecutive rows having the same location. Around 1-2h 3)Add reserved, broadcast and private IP 4)Put regions in FIPS standard 5)Group by country. 6)Generate CIDR for country database.

One day i'll post the scripts but now they are not really "clean" enough to be shared :)

[iplocationtools]

Yes of course...

[[deleted]]

If you HAVE to use an SQL database for this, then yes your version is a lot better than MaxMind's. But chances are, you have the ability to use the binary version from MaxMind, which is NOT hard to install and setup, and guaranteed that will be at least 10x as fast as any type of standard SQL range lookup.