4 ms·
Folks... he gives us the database for FREE! We can use it or leave it. I would hope that someone downloads the damn thing, compares it against his GeoIP and tel
by binarray2000 18y ago
Folks... he gives us the database for FREE! We can use it or leave it. I would hope that someone downloads the damn thing, compares it against his GeoIP and tells us his findings. Otherwise, the discussion about accuracy is silly.
- tc 18y agoI was trying to find a free SQL database of IP geolocation with country, city, region, latitude and longitude for a project but none was accurate and up to date so I decided to create my own and now I offer it for free. He makes it sound as though this isn't particularly difficult or expensive. Does anyone want to speculate on the method he is using to compile this data? For his zipcode database he seems to be running mass queries on the Google Maps API. Simply doing mass WHOIS queries to the regional registrars only gets you data about the corporate headquarters of the ISPs, which I suppose could be enough depending on the level of granularity that is acceptable to you. (presently a similar question on his forum, posted by someone else, is unanswered: http://blogama.org/node/105 http://blogama.org/node/105)
- Locke 18y agoSomeone on reddit claims it's an exact copy of this: http://www.maxmind.com/app/geolitecity http://www.maxmind.com/app/geolitecity I haven't verified that claim.
- rmaccloy 18y agoFrom page (quoted in some other comment below): "Very accurate. The database is updated during the first week of each month." This is also the frequency at which Maxmind releases updates. So...
- mpk 18y ago.. so perhaps he's pulling the data from some of the same sources as Maxmind does and hence is on a similar update schedule, is what you're implying, right? Anyway, I'd still like to know what those sources are.
- gjm11 18y agoOr perhaps the implication is that he's pulling some of his data from the Maxmind database. (Which would be illegal, unless I'm misremembering Maxmind's licensing terms.) I'm guessing that you're merely pretending not to understand what's being implied, but I don't understand why...
- babo 18y agoThis DB has close to six times as much location as GeoLite: wc -l ip_group_city.csv 1195012 ip_group_city.csv wc -l GeoLiteCity-Location.csv 238957 GeoLiteCity-Location.csv
- tc 18y agoI checked his ip->city database against a dozen class C's with which I am intimately familiar, and in every case they were either correct or as correct as possible (i.e. someone in that /24 is located in city X, even if most people in the block are located 25-100 miles away). I specifically looked at cases where the ARIN information would lead one astray, so it appears that is not the primary source of location data.
- davidbnewquist 18y agoThe method: dynamic programming algorithm, triangulation and tracert.
- rmaccloy 18y agoI don't believe this is what Maxmind does; I have no direct knowledge but I believe their data is based on IP registry data (location of the registering org) along with inference from per-user registration data (surveys, social networks, panels, etc.) Akamai has a (much more expensive) geolocation product that's based on doing triangulation, since they have a lot more information on routing (all those edge servers) but I'm not sure it's appreciably more accurate.
- davidbnewquist 18y agoSorry: I was actually joking. I should have capped with an emoticon. But it's cool to know Akamai actually has a triangulation DB: I didn't know it was feasible. So I gave you a karma point:)
- enf 18y agoIf you want locations of zip codes or US cities, you can easily get that from the US Census's TIGER data.
- deleted 18y ago[deleted]
- adnam 18y agoGood plan. I'll start by making a GUI in Visual Basic...(SCNR)