0

Recently I have stumbled upon a problem - MaxMind's GeoIPCity file is way too big for our needs and contains A LOT of data we don't need and won't need.

The question is: is there a way to limit the City database to a single country? let's say, Canadian cities only?

Rossitten
  • 1,140
  • 1
  • 16
  • 34

1 Answers1

2

You cannot just conveniently download the database for Canadian cities only, but you can certainly prune the database once you have downloaded and loaded it. This is true whether you use the MaxMind DB or download the CSV format, just trim out the lines that do not represent Canada's country code or geoname_id (depending on v1 or v2 of the dataset).

If you identify your specific coding environment and language, I'm certain someone can help you write a few lines of code that chops out all the fat.

raccoon
  • 519
  • 4
  • 5
  • Thanks for your comment! I see. So the only way to get that is to edit the file. Language - PHP. Own CMS... but I guess I'll figure out how to do that (though, other, probably, won't - so all suggestions would be highly appreciated here) – Rossitten Oct 21 '17 at 04:44