Skip to main content

Using Google Charts with KML

In my last post, I showed how KML icon images could be utilised for proportional symbol mapping. Instead of loading a custom image, images can be requested from the URL based Google Chart API as shown below (download KMZ).

These pie charts are generated on-the-fly. The dataset is the same I used for my OpenLayers and Google Chart mashup. The charts are scaled according to total population and the pie shows the age distribution for each country. If you click on a chart, you'll see a larger version in the balloon:

Since the pie charts are loaded from an external service, the KMZ file is only 10 kB. There are some performance issues since around 200 pie charts are requested from the Google Chart API. I hope to see chart functionality as an integral part of KML and various geobrowsers in the future.

The map is also viewable in Google Maps and Microsoft Live Maps (Virtual Earth). The KML IconScale element is not supported by these geobrowsers, so all pie charts have the same size.

You'll obtain more control of the styling by using GeoJSON and OpenLayers.
Labels:

Comments

test said…
Great job and great blog !
30 April 2008 at 19:01
Anonymous said…
Is there any chance of seeing the code behind this? The KMZ file doesn't seem to show anything nice in my texteditor, I'm presuming a KML file would provide human-readable output...

M
21 October 2008 at 14:03
veerugadde said…
Hello

I was trying to use google charts api with Gearth but when its not showing any charts.I included the chart url in description tag and cannot see any output.Is there any specific way i need to follow while writing kml or creating charts.Could you also please suggest me how to make charts on the fly(i.e server side)

Thank you,
12 December 2008 at 17:30
Bjørn Sandvik said…
Hi veerugadde,

If you download the KMZ file in this blog post, you can right-click on an element in the places panel in Google Earth, select 'copy' and paste the code into a text editor. You'll then see how the chart images are referenced in KML.

To generate charts on the server you could use a graphics library like gd (complicated), or generate URLs for the Google Chart API (not so complicated). Details are explained in the Thematic Mapping Engine documentation (click on Downloads above).
13 December 2008 at 06:12
Anonymous said…
Hi
The problem is with labels in google chart URLs, for some reason the vertical bar separator makes the URL unusable. I've just tried your KMZ file with GE 4.3.7284.3916 - I have proper images for placemarks, but in the description only gray rectangles remain. If I remove labeling (legeng) from URL to google charts the image appears. Any ideas how to solve it?
28 December 2008 at 18:14
d said…
Okay, this is pretty amazing; I've got to admit. But, how can we do this but get the stuff to load automatically... I would like to see this created, but the KML file come from autoprocessing the components of an SQL database. HAve you ever seen something like that?
21 February 2009 at 00:45
Jeff Vyduna said…
Hi! Great example. Just wanted to comment that some data visualization snobs would point out the similarity between this and the pies-on-map graphic that VDQI. More info: http://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=00018S

But I really respect what you were able to achieve with respect to the API.
5 June 2009 at 19:49
Tolga Can said…
I am totaly new on how to create kmz file as shown .

I just have , say excel file with latitude , longitude and the data to be indicated on pie chart.
what kind of software can I use to gwenerate kmz / kml ?
9 April 2011 at 13:08
Ravi Kumar said…
Hi,

nice article. I have found another sample code about How to create Chart on Google Maps - Google Visualization. Please visit http://www.etechpulse.com/2013/07/how-to-create-chart-on-google-maps.html

I hope this will be helpful.
22 July 2013 at 11:21
Post a Comment

Popular posts from this blog

Creating a WebGL Earth with three.js

This blog post will show you how to create a WebGL Earth with three.js , a great JavaScript library which helps you to go 3D in the browser. I was surprised how easy it seemed when reading a blog post  by Jerome Etienne . So I decided to give it a try using earth textures  from one of my favourite cartographers, Tom Patterson . WebGL is a JavaScript API for rendering interactive 3D graphics in modern web browsers without the use of plug-ins. Three.js is built on top of WebGL, and allows you to create complex 3D scenes with a few lines of JavaScript. If your browser supports WebGL you should see a rotating Earth below: [ Fullscreen ] To be able to display something with three.js, you need three things: a scene, a camera and a renderer. var width  = window.innerWidth,     height = window.innerHeight; var scene = new THREE.Scene(); var camera = new THREE.PerspectiveCamera(45, width / height, 0.01, 1000); camera.position.z = 1.5; var rende...
11 comments
Read more

Thematic Mapping Engine

It's time to introduce the Thematic Mapping Engine (TME). In my previous blog posts, I've shown various techniques of how geobrowsers can be used for thematic mapping. The goal has been to explore the possibilites and to make these techniques available to a wider audience. The Tematic Mapping Engine provides an easy-to-use web interface where you can create visually appealing maps on-the-fly. So far only prism maps are supported, but other thematic mapping techniques will be added in the upcoming weeks. The engine returns a KMZ file that you can open in Google Earth or download to your computer. My primary data source is UNdata . The above visualisation is generated by TME ( download KMZ ) and shows child mortaility in the world ( UNdata ). The Thematic Mapping Engine is also an example of what you can achieve with open source tools and datasets in the public domain: A world border dataset is loaded into a MySQL database . The same database contains tables with statistics ...
45 comments
Read more

Creating 3D terrains with Cesium

Previously, I’ve used three.js to create 3D terrain maps in the browser ( 1 , 2 , 3 , 4 , 5 , 6 ). It worked great for smaller areas, but three.js doesn’t have built-in support for tiling and advanced LOD algorithms needed to render large terrains. So I decided to take Cesium for a spin. Cesium is a JavaScript library for creating 3D globes and 2D maps in the browser without a plugin. Like three.js, it uses WebGL for hardware-accelerated graphics. Cesium allows you to add your own terrain data, and this blog post will show you how. Impressed by the terrain rendering in @CesiumJS - with a 10m elevation model for Norway! Farewell Google Earth. pic.twitter.com/RQKvfu2hBb — Bjørn Sandvik (@thematicmapping) October 4, 2014 Compared to  the dying Google Earth plugin , it's quite complicated to get started with Cesium. The source code is well documented and the live coding Sandcastle is great, but there is a lack of tutorials  and my development slows down when ...
12 comments
Read more