Using the data from www.maxmind.com/app/fips10_4, build a lookup table, i.e., from subcountry/region name to FIPS 10-4 code (and possibly the converse, see #1652).
This will used by #1823 to convert region names (as supplied by geolocation providers) to the more compact FIPS 10-4 code (when storing in the log_visit table).
Given that FIPS 10-4 was withdrawn from the standards track, how much overlap is there with ISO 3166-2?
Anthon, sounds good -
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
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).
Sorry, last bullet point is incorrect
(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:
This will inevitably lead to questions (or bug reports) like "Al Mafraq appears twice in the table". So follow-up tasks to this one:
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? :)
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.
Piwik needs you!