Google Fusion Tables

Recent posts

California Redistricting with Google Fusion Tables

This redistricting map app is among the best Google Fusion Tables examples I’ve seen in media. It draws proposed legislative boundaries but also has a nifty search function. Here’s the before/after view of congressional districts statewide:

Before/after Compton:

Before/after San Diego:

Before/after Los Angeles:

Nice work, LA Times.

In the Suburbs, I…

… should be buying gas, according to this map of D.C.-area gas prices. The lowest, in Maryland, are about $3.70 per gallon of regular gas. (The D.C. average is more than $4, but some stations are at or above $5).Larger symbols on this map, made with ArcGIS, represent higher prices: 

Here’s an interactive version: 

Source: washingtondcgasprices.com | Map shapefiles | Data

Top-Tier Soccer League Attendance by Country

Germans like their fussball, apparently. The country has the highest average attendance to association football matches in the world — better even than England, where the rules for what we call soccer were codified 150 years ago. 

More than 41,000 people on average attend matches in the Bundesliga, followed by the Premier League (England), La Liga (Spain) and Primera División (México). The U.S. ranks 11th, just behind soccer-crazy Brazil. 

Here’s a map, with darker shades representing higher attendance: 

Data | Larger Map | Source: Wikipedia

Mapping Starbucks Locations

I stumbled upon this interactive, which visualizes the locations of more than 18,000 international Starbucks locations using Google Fusion Tables and custom JavaScript. Here’s the USA view: 

Europe and Asia:

And Washington, DC. Notice the lack of locations in my ‘hood, Brookland, which is represented in the red circle. Bummer. Fortunately, there’s a nice coffee shop nearby called Cafe Sureia

Download the data.

U.S. Naturalizations by Country

The Department of Homeland Security now posts records detailing how many people become U.S. citizens each year, and from which countries. Visualizing this data on a world map is easy, thanks to Google Fusion Tables.

This map shades countries in darker greens based on the number of people who became citizens (excluding Mexico, which accounted for about one in five naturalizations in 2008, the most-recent data available): 

Here’s the view with Mexico:

Data: All Countries | Source: Office of Immigration Statistics

NOTE: These maps normally would be interactive, allowing viewers to mouse over countries and view totals. But that feature is broken.