Placing colored circles on Map [Script]


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:

Ideally the script would be for Adobe Illustrator or something else that creates exportable vector file. Illustrator supports Javascript, among others. More Info: [url removed, login to view]

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.

Kemahiran: Pengaturcaraan C, Pemprosesan Data, Javascript, PHP, Kejuruteraan Perisian

Lihat lagi: world programming, vector php, vector from jpg, variables in programming, value city, use script in google spreadsheet, spreadsheet script google, spreadsheet script, spreadsheet api javascript, smart circle, smart and final, sketch programming, size of vector, script google spreadsheet, programming vector, programming variables, need to find a illustrator, map .find, job programming find, job as an illustrator, javascript best codes, illustrator job us, if else c programming, https www programming, html spreadsheet example

Tentang Majikan:
( 0 ulasan ) Bla, United Kingdom

ID Projek: #1566315

5 pekerja bebas membida secara purata $215 untuk pekerjaan ini


We are a very experienced team who can tackle this task. Please check PMB for more details.

$300 USD dalam 7 hari
(23 Ulasan)

Hi, please check my PMB. Thanks.

$250 USD dalam 7 hari
(14 Ulasan)

Kindly see the personal message board

$175 USD dalam 15 hari
(0 Ulasan)

I can do this work

$100 USD dalam 7 hari
(0 Ulasan)

Pls check PMB.

$250 USD dalam sehari
(0 Ulasan)