Bruce Ralston of the University of Tennessee has previously released several US Census TIGER data tools that I’ve posted about in the past. TGR2SHP converts TIGER files into shapefile format, while TGR2KML converts TIGER polygon files (like legislative districts and county subdivisions) into basic KML files for viewing in Google Earth. Both of these tools only work with the older pre-2007 TIGER format, which is no longer in use; the Census Bureau now issues all this TIGER data in standard shapefile format. But Bruce Ralston has just released a new tool called AFF Mapper that goes a step beyond his previous ones: it can convert TIGER shapefile data into KML format, link it to tabular American Fact Finder data (AFF) from the US Census, and plot this census data thematically. But unlike the previous TIGER tools, this one is a general-purpose one; it can convert any shapefile – point, line or polygon – into a thematic or unique value KML file, with the option of using thematic data from a linked external table. The only limitation is that the shapefile must be in geographic coordinates (lat/long), WGS84 datum, Google Earth’s native coordinate system.
I won’t go through the process with Census data; there’s an excellent PDF manual that describes the process of creating maps like this one (from the manual):










