Google Fusion Tables for Current Affairs

[Update: I noted on many of my Google Fusion Table posts that, while the data are still on Google Drive for you to view, GFT no longer offers a polygon or heatmap option, only geocoding by country centroid in its new version. Not sure why, but on this, this, this, and another  example posted as Iframes not Scripts preserved the old GFT maps.]

Wolfram Alpha is a search tool that does statistical as well as word searches. This is powerful indeed as it allows to query across diciplines, subjects and techniques. I live in Kuwait now, and the current events made me curious about the distribution of Christianity, Islam and Judaism. Having already used Google Docs and Fusion Tables here and here, I performed the following:

Google Fusion Tables for new Google Maps?

[Update: I noted on many of my Google Fusion Table posts that, while the data are still on Google Drive for you to view, GFT no longer offers a polygon or heatmap option, only geocoding by country centroid as evidenced below. Not sure why, but on this, this, this and another example posted as Iframes not Scripts preserved the old GFT maps.]

I posted on my old website a number of Google Maps in v.2 API that I have not converted to v.3. I also used Google Fusion Tables a number of times under the 'old look' - the 'new look' doesn't afford Heat Maps and polygon rendering as yet out-of-the-box - along comes a Google Fusion Tool that helps both on v.3 API and the new régime with very simple Google Fusion Table templates and new  rendering.

More simple maps in current affairs

[Update: I noted on many of my Google Fusion Table posts that, while the data are still on Google Drive for you to view, GFT no longer offers a polygon or heatmap option, only geocoding by country centroid in its new version. Not sure why, but on this, this, this and another example posted as Iframes not Scripts preserved the old GFT maps.]

Geocurrents.info posted an interesting item on UNESCO World Heritage Sites list. I suggested that their otherwise lovely static maps could be augmented via dynamic ones. They're not computer mappers, so I pointed them to Google Fusion Tables as the simplest way to post simple aggregate maps by country. Here is what their maps on World Heritage Site count looks like (note this is still 'beta', as for example Côte d'Ivoire and DR Congo do have sites, and I had to match country names to Google):

Mapping languages on the internet

[Update: I noted on many of my Google Fusion Table posts that, while the data are still on Google Drive for you to view, GFT no longer offers a polygon or heatmap option, only geocoding by country centroid in its new version. Not sure why, but on this, this, this and another example posted as Iframes not Scripts preserved the old GFT maps.]

Let's explore global language distribution from World Mapper, then language usage on the internet as seen from Wikipedia. This was inspired by an article in The Economist as well as data I previously collected an posted on Google Drive to explore various topics on Google Fusion Tables.

Google Fusion Coffee Table

[Update: I noted on many of my Google Fusion Table posts that, while the data are still on Google Drive for you to view, GFT no longer offers a polygon or heatmap option, only geocoding by country centroid in its new version. Not sure why, but on this, this, this and another example posted as Iframes not Scripts preserved the old GFT maps.]

Geocurrents posted this interesting dataset from Worldbank's Ease of Doing Business website. James Fee waxed rhapsodic over Google Fusion Tables after WhereCamp5280. So I decided to see how easy it really was to map their Ease of doing Business Rank.

The politics of London2012 Olympic medal counts

[Update: I noted on many of my Google Fusion Table posts that, while the data are still on Google Drive for you to view, GFT no longer offers a polygon or heatmap option, only geocoding by country centroid in its new version. Not sure why, but on this, this, this and another example posted as Iframes not Scripts preserved the old GFT maps.]

I was curious about the London2012 Olympic medal count - why rank them by gold medals as BBC did, rather than by total medals as perhaps statistically more significant? It kept TeamGB in #3,  ahead of the 2008 Beijing Olympic gold medal rank of 4 (rather than ahead of the Russians I'm told). In any case the top two - US and China - stood unchallenged, and every country performed well in what some called the best games ever... even if I hear that at every four years!

The power of context, Part III

[Update: I noted on many of my Google Fusion Table posts that, while the data are still on Google Drive for you to view, GFT no longer offers a polygon or heatmap option, only geocoding by country centroid in its new version. Not sure why, but on this, this, this and another example posted as Iframes not Scripts preserved the old GFT maps.]

Ruth Lang created this excellent mashup for the 2010 FIFA World Cup - which coloured all the countries at the beginning and gradually greys them out as they are eliminated - only Spain and the Netherlands are left as at today. This was a labour of love, needing for example some tweeking to work in the Firefox browser, and a testament to SVG.

Illustrative maps in current affairs

[Update: I noted on many of my Google Fusion Table posts that, while the data are still on Google Drive for you to view, GFT no longer offers a polygon or heatmap option, only geocoding by country centroid in its new version. Not sure why, but on this, this, this and another example posted as Iframes not Scripts preserved the old GFT maps.]

The Data section of British paper The Guardian is a great example of illustrating reams of data and helping readers make sense of it - such maps are only illustrations, not exacting science as in my previous post - readers wish to grasp trends for tabular data by country, rather than examine their exact geographies.

Roundup of web projects

Is it spring in the air or LinkedIn's new (to me) facility to post projects? Here is a round-up of various projects in the past five years as recently posted on my LinkedIn page:

... now HOW open is open?

[Update: Part II is on my Medium professional channel 2½ year later: Almost open data]

A lot of (virtual) ink has flowed around opening up data, as in this blog, GISuser crowdsourcing open data (below left) etc. etc. And everyone is getting into the act, from White House (below center) and Whitehall (UK Cabinet Office) to the number of open data hits (below right).

"The shots heard around the world"

Recent mass shootings in the US and elsewhere affect me in a particular way: My parents grew up in Nazi then Soviet occupied Pest, on the east shore of the Danube overlooked by the Buda Castle (dark green below), from which guns fired down streets perpendicular to the river (grey at right below), so residents literally ran the gauntlet across those streets, and friends of my parents lost a babe in arms from a stray bullet; my parents thus emigrated just before my birth to give me a better life, but that included six months in Algiers during a revolution where I too witnessed two fatalities early 1961.

A tale of two cities: web maps new and old

Last I posted on vector online GIS, and that appears to be gaining traction. Mapbox offers through TileMill and OpenStreetMaps editing. These are new an emerging technologies that are exciting, and it contrasts with Esri who offers a slew of tools on the desktop and in arcgis.com. WMS is for example still immature on giscloud.com (though it is OGC compliant now), as are the symbology and labels. They do not offer model builder like Esri or Qgis (thru Sextante). But they do offer a service to process GIS functions online and allow to load data direct from web source, avoiding costly down- & up-loads. Here I compare how I used a 180K vector dataset from NOAA NGDC described previously.

Releasing data really works, Part III

More and more free data are available that are quality-controlled and verifiable. Guardian Data Blog's @smfrogers (now at Twitter) was quite sanguine about this:

Comment is free, but facts are sacred