I have a spreadsheet with about 200 data sets consisting of place (country, city), colours and numeric values that I want to use to create and place circles on a world map using a script that you would create.
Here a (zoomed in) sketch as an example:
[url removed, login to view] [Fig 1]
The world map only is visible there to show how the script has to place every single circle. The final thing should look something like this (only circles, no map or text):
[url removed, login to view]
The circle is created using 3 variables:
- Numeric Value: Defines the size of the circle
- Colour (given Hex Color Codes): Defines the filling colour
- Location (Country, City): Defines the place of the circle on the Map
Also: the circles need to have an opacity of 60% (best, If I could change that myself) so the circles can overlap if they are close to each other. See: Figure 1.
Outcome & Additional Info:
Alternatively (if it is not possible as script that creates a vector/works in illustrator) it can be pretty much done in any way, as long the result is a high quality image file. Format not as important.
I have no idea about the best way to calculate the correct position of the circles on the map from the given "Country, City" attributes, but I saw that, for example, Google Fusion Tables geocodes the information automatically and can place it on the map. Maybe that API can be used there, or is somehow useful. For example, here I placed all our points on a map: [url removed, login to view] . If not, of course it is your job to find a smart and easy solution.
Please reply for any further questions. Thanks.