Amidst all the excitement of I/O followed by the July 4th holiday in the U.S., many developers missed the announcement of the new Fusion Tables API. The new API includes all of the functionality of the existing SQL API, plus the ability to read and modify table and column metadata as well as the definitions of styles and templates for data visualization. This API is also integrated with the Google APIs console which lets developers manage all their Google APIs in one place and take advantage of built-in reporting and authentication features.
With this launch, we are also announcing a six month deprecation period for the existing SQL API. Since the new API includes all of the functionality of the existing SQL API, developers can easily migrate their applications using our migration guide.
For a detailed description of the features in the new API, please refer to the API documentation.
<html style='height: 100%'> <head> <script type='text/javascript' src='http://maps.google.com/maps/api/js?sensor=false'></script> <script type='text/javascript'> function initialize() { var bc_office = new google.maps.LatLng(37.788901, -122.403806); var map = new google.maps.Map(document.getElementById('accident-map'), { center: bc_office, zoom: 13, mapTypeId: google.maps.MapTypeId.ROADMAP }); var accidents_layer = new google.maps.FusionTablesLayer(433634); accidents_layer.setMap(map); } </script> </head> <body onload='initialize()' style='height: 100%; margin: 0px; padding: 0px'> <div id="accident-map" style='height: 100%'></div> </body></html>
var accidents_layer = new google.maps.FusionTablesLayer(433634);
var accidents_layer = new google.maps.FusionTablesLayer(433634, { query: 'SELECT FullAddress FROM 433634 WHERE Year=2009 AND Month=5'});
SELECT
COUNT
'SELECT COUNT() FROM 433634 WHERE Year=2009 AND Month=5'
https://www.google.com/fusiontables/api/query?sql=SELECT COUNT() FROM 433634 WHERE Year=2009 AND Month=5
$('#filter-form').ajaxForm({ success: function(responseText, statusText) { var data = $.parseJSON(responseText); accidents_layer.setMap(null); accidents_layer = new google.maps.FusionTablesLayer(433634, { query: data.map_query}); accidents_layer.setMap(map); $('#filter-results').html(data.results); }});
