<!--Load the AJAX API-->
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript" src="https://geoxml3.googlecode.com/svn/branches/polys/geoxml3.js"></script>
<!-- Initialize -->
<script type="text/javascript">
// globals
var map = null;
var infoWindow = null;
var geoXml = null;
var geoXmlDoc = null;
var myLatLng = null;
var myOptions = null;
var mapCenter = null;
var geocodeTheCountry = true;
var gpolygons = [];
var geocoder = null;
// Fusion Table data ID
var FT_TableID = '1LkZUDcoWDwGcL06wPbkk3SPW1vI0bLtO63JmuTS0'; // numeric ID 420419;
var CountryNombre = "Cali - Valle del Cauca, Colombia"; // "United States of America";
google.load('visualization', '1', {
'packages': ['corechart', 'table', 'geomap']
});
function createSidebar() {
document.getElementById('sidebar').innerHTML = "querying for data";
var FT_Query2 = "SELECT 'zona', 'nombre', 'cordenadas' FROM " + FT_TableID + " WHERE 'zona' = '" + CountryNombre + "' ORDER by 'nombre'";
document.getElementById("FTquery2").innerHTML = FT_Query2;
var queryText = encodeURIComponent(FT_Query2);
var query = new google.visualization.Query('http://www.google.com/fusiontables/gvizdata?tq=' + queryText);
//set the callback function
query.send(getData);
}
// Set a callback to run when the Google Visualization API is loaded.
google.setOnLoadCallback(createSidebar);
function getCountryNombres() {
// set the query using the parameters
var FT_Query_CountryNombre = "SELECT 'zona', count() FROM " + FT_TableID + " GROUP by 'zona' ORDER by 'zona'";
document.getElementById("FTquery4").innerHTML = FT_Query_CountryNombre;
var queryText = encodeURIComponent(FT_Query_CountryNombre);
var query = new google.visualization.Query(
'http://www.google.com/fusiontables/gvizdata?tq=' +...