Hacker News new | ask | show | jobs
by NathanKP 5220 days ago
I wis this traced the IP to the city level. It would be interesting I think to see which cities have high amounts of malicious traffic.
2 comments

Anyone knows if there is a free geoip lookup database with city level detail? If not, if there was a way of crowdsourcing this somehow? If I'm not mistaken gps+phone probably wouldn't work since the IP addresses seem to be more or less random.

Google seems to know wifi routers locations, but afaik they use their streetcar fleet to create it. It was funny sometime ago that after moving cities but keeping the same wifi router, my detected location was still at the old place. Eventually it got corrected.

I’ve had good (but not great) results from https://github.com/fiorix/freegeoip . It has you download the database from http://mirrors.ipinfodb.com/ipinfodb/ip_database/current/ipi... , which doesn’t appear to be officially linked anymore (http://ipinfodb.com/ip_database.php).
This one is pretty good:

http://www.hostip.info/

thanks!
It would be possible with a different map and some changes to make this go to city level, I might do that some time in the future but I don't know how much extra work would be required and I assume it would require a whole lot more processing.