<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); }});
