@m-cameron opened this Issue on January 9th 2018

Maxmind has announced that they will remove coordinates from GeoLite2 in 2019.


How can Piwik works without the coordinates? Must we subscribe to the commercial GeoIP2? Can we use IP2Location LITE DB5?


@fdellwing commented on January 9th 2018 Contributor

Why you need coordinates? City should be precise enough for 99% of the users that don't use a commercial solution anyway.

@Findus23 commented on January 9th 2018 Member

I'm not sure if Piwik uses the coordinates to display the cities on the map.

@fdellwing commented on January 9th 2018 Contributor

Well, the map works if you use other methods of geolocation instead of GeoLite DB. So there should be no problem with that?

@m-cameron commented on January 9th 2018

Need to check the codes if latitude and longitude are being used. Any developers here?

@mattab commented on April 7th 2018 Member

As maxmind itself says "Latitude and Longitude are often near the center of population. These values are not precise and should not be used to identify a particular address or household."

from internal discussions: we do not really need lat/long values for each user but the lat/long are currently used for the following:

One solution would be to have, in Matomo, a static mapping of cities -> lat,long and use this instead, so we know for sure lat/long are not more precise than the closest city. Then we could use this static mapping to fill in the lat/long info for each visit (even in the DB raw data) and keep our APIs and Maps working as before.

Whether to keep or delete the fields lat/long in the DB, because the values can be set manually via the Tracking API, many people use and rely on this valuable info (and may have full consent to track locations), so we can keep the fields in the tables.

@oschwald commented on April 11th 2018

MaxMind is no longer discontinuing coordinates in GeoLite2:

After careful consideration, taking into account customer feedback, we have decided against removing latitude and longitude coordinates from the GeoLite2 databases. We are in the process of reviewing coordinates used in all of our GeoLite2 and GeoIP databases to ensure there is no risk of misuse.

@mattab commented on May 2nd 2018 Member

Thanks for letting us know @oschwald - closing this as won't fix then.

This Issue was closed on May 2nd 2018
Powered by GitHub Issue Mirror