Create a google fusion table for highlighting a cities with different color in google maps

Question

I want to highlight a cities with different color in google maps. I found the solution with google fusion tables layer. But i have doubt in the creation of fusion table. i have planned to create a table with three fields 'zip code', 'city name' and 'geometry'. I have analysed about the geometry field value. it must be a KML format. But i don't know how to get the geometry value for each city(all the cities from european countries).

Kindly advice. Thanks in advance.

Answer 1

you need to build queries under FusionTablesLayer style options. Check the documentation: https://developers.google.com/fusiontables/docs/articles/fusiontables_styling#styling-via-the-google-maps-api

Answer 2

I know it's and old one but as I was wandering where to find a source of KMZ limits on Countries, Regions and Cities, I've read @geocodezip comment and find out gadm.org a good point to start getting that data. Once you download the maps you need, it's fair easy to use it on Fusion Tables or Google Maps Api.