The project I'm working on is multi-lingual, there is a large member sign-up campaign planned and it is necessary to show statistics, and ideally also a map with marker clusters, to display where the members are coming from. I've tackled the map part without a problem using Google Maps by Objective HTML but I'm running into problems trying to figure out:
1- how to have the locations translated so that, for example, in english you read New York, USA but in portuguese you get Nova Iorque, EUA.
2- what method to use so that I can display a list of all the countries which have members on the site and the number of members per country.
3- it's important to be able to search the members by region/country but I can't get the search form to work properly, do I need dedicated lat/long fields?
I suspect this all comes down to how I setup the Google Maps field type, if I have dedicated fields for lat/long and the formatted address or not. I'll be using Publisher for the translations but I'm still not sure what's the best field setup.
Also, let's say there are hundreds of markers to display on the map, the clusters take care of that visually, but how do you cope with the memory usage?
I will be using EE 2.9, Zoo Visitor for the registrations, Publisher, Low Search and Google Maps amongst others.
Thank you for your help any input is welcome!