Given that FIPS 10-4 was withdrawn from the standards track, how much overlap is there with ISO 3166-2?

Anthon, sounds good -

• The lookup table would just be a plain PHP array I assume?
• should this be part of Include GeoIP in core after improvements #1823 ?

Greg: do you have any additional equirements that I can accomodate here? (Relating to 1652).

this will be a mapping of fips10-4 to a subcountry (aka region) name

• do we need these names to be translateable?

In the future, there will be some methods (probably specific to a geolocation provider) for reverse lookup (ie store the more compact fips10-4 code).

• there's as yet, no iso 3166 standard for subcountries

Sorry, last bullet point is incorrect

• there isn't a one-to-one mapping between iso 3166-2 and fips10-4

(The iso 3166-2 standard isn't stable; it changes to reflect geopolitical changes.)

do we need these names to be translateable? 

No, only countries are translatable in Piwik (we should not have to add new translations for this feature)

Is there any issue that you can think of for this ticket, or all is clear?

Since we don't know what version of the GeoIP database a user may have installed, we have to include retired codes.

However, I noticed the following:

• a region may get a new code but keep the same name (e.g., JO 10 "Al Mafraq" becomes JO 15 "Al Mafraq")
• a region may get a new name but keep the same code (e.g., YE 06 "Al Ghaydah" becomes YE 06 "Lahij")

This will inevitably lead to questions (or bug reports) like "Al Mafraq appears twice in the table". So follow-up tasks to this one:

• add a FAQ entry
• monitor changes to MaxMind's fips_include list (e.g., a daily cron or Jenkins job) so we have timely updates

Maybe there won't be "double rows" since Piwik should, for a given month, deduplicate same labels ? It would only have the issue the day and month during the upgrade between old new format?

In any case a FAQ would be more than enough, probably it will not happen much.

Thanks for your status update, hopefully the data sets we are going to package to be used by 250,000 server is of good quality and fast to access? :)

Dealt with in: #1652

Milestone 1.8.x Piwik 1.8.x deleted

We need YOUR help! We are running a crowd funding campaign to raise funds to implement the detailed Visitors Maps of Countries, Regions and Cities (for all countries)!

These maps will be beautiful, usable, and built using open standards SVG+JS. They will show detailed visitor count, conversion rates, by Country but also (New!) by city and region.

Pledge now at: http://crowdfunding.piwik.org/analytics-maps-world-country-city-region/

Piwik needs you!