Group items tagged

Daniel Lathrop Wanted to share with all of you my latest installment in my ongoing love affair with Google Fusion Tables, the Dallas publicly-traded companies list. http://newsapps.dallasnews.com/media/dfw-public-companies.html I got the data from the biz desk on Thursday and wrote this little thing using JQuery, JQueryUI and FusionTables pretty quickly. And before everyone gets all "but you could have used [Caspio, TableSetter, Rails, PHP, Ilene, etc.]" on me, I know I could have. But doing this with Fusion Tables let me do all my work on the client side and let me create the user-experience I wanted. Plus, I now have a starting place to do this for any similar Fusion Tables project. For the curious, the Javascript can be found here: http://newsapps.dallasnews.com/media/fusiondmn.pubcompanies.js It's fewer than 150 lines, and more than a quarter of that is my Javascript for for rendering integer/floating point #s in newsroom style (e.g. $4.2 billion). I'm hoping to turn it into a robust tool for deploying searchable data with Fusion Tables and am going to ask my corporate overlords to let me open source it once I've done some refactoring to make it generally applicable. Critiques welcome. -Daniel --------------------------- Daniel Lathrop 206.718.0349 (cell)

FusionTablesLayer Builder This wizard helps you create the HTML for a map with a FusionTablesLayer and search element (either text-based search or select menu). After creating your map, you can copy and paste the HTML code in the textarea below to display the map on your own website! Please submit bug reports here: Issue Tracker

Click on the "Add another feature" drop-down to add additional layer or search box

Shape to Fusion Hi. This website lets you import a shapefile to Google Fusion Tables. This blog post has some details on how it was built. (http://porcupinealley.com/2010/dec/20/shape-escape/) To continue, you will need to authorize this site to access your Fusion Tables data on your behalf. Site by Josh Livni. Source code available at http://code.google.com/p/shpescape/

Ties in with Google Fusion.

A handy cut-and-paste HTML script that is easily customized