PROSAGA码农传奇-数据融合-带有Fusion Table数据的Google Map不显示地图标记

<div class =“post-text”itemprop =“text”>
  <P>
    该错误（消息：“未配置访问”）是由于密钥没有正确的引用（至少当我添加了正确的密钥时，它适用于我）。
  </p>
  <P>
    真正的问题是你的纬度和经度是颠倒的，所以标记出现在南极洲。
  </p>
  <P>
    <a href="http://www.geocodezip.com/v3_SO_FusionTables_queryForMarkers.html" rel="nofollow">
      工作实例（用我的钥匙）
    </A>
  </p>
   <pre>
    <code>
      <!DOCTYPE html>
<html>
<head>
    <meta name="viewport" content="initial-scale=1.0, user-scalable=no">
    <meta charset="UTF-8">

<title>Fusion Table version of QB on draft info</title>
    <style>
    body {
        font-family: Arial, sans-serif;
        font-size: 12px;
    }

#map-canvas {
        height: 500px;
        width: 600px;
    }
    </style>

var map;
    var bounds = new google.maps.LatLngBounds();
    var infoWindow = new google.maps.InfoWindow();
    var DEFAULT_ICON_URL = 'http://clorentzen.com/queensbrewery/qb_maps.png';

// EDIT: change this key to your own from the Google APIs Console
    // https://code.google.com/apis/console/
    var apiKey = 'AIzaSyCxitB5jQcw7weQdg9MqBRfxr6mj81wT7I';

// EDIT: Specify the table with location data and icon URLs
    var tableID = '1coED7p2uvV31pMNMPhHsrPRxZCfZv4b9LvkvrCc';

// Create variables for the columns you need to retrieve from the table
    // EDIT this list as needed, then find and edit two places below.
    var latitudeColumn = 'LATITUDE';
    var longitudeColumn = 'LONGITUDE';
    var iconUrlColumn = 'ICON';
    var venueColumn = 'BAR';
    var addressColumn = 'ADDRESS';
    var neighborhoodColumn = 'NEIGHBORHOOD';
    var regionColumn = 'REGION';

function fetchData() {

// Construct a query to get data from the Fusion Table
        // EDIT this list to include the variables for columns named above
        var query = 'SELECT '
        + latitudeColumn + ','
        + longitudeColumn + ','
        + iconUrlColumn + ','
        + venueColumn + ','
        + addressColumn + ','
        + neighborhoodColumn + ','
        + regionColumn + ' FROM '
        + tableID;
        var encodedQuery = encodeURIComponent(query);

// Construct the URL
        var url = ['https://www.googleapis.com/fusiontables/v1/query'];
        url.push('?sql=' + encodedQuery);
        url.push('&key=' + apiKey);
        url.push('&callback=?');

// Send the JSONP request using jQuery
        $.ajax({
            url: url.join(''),
            dataType: 'jsonp',
            success: onDataFetched
        });
    }

function onDataFetched(data) {
        var rows = data['rows'];
        var iconUrl;
        var content;
        var coordinate;

// Copy each row of data from the response into variables.
        // Each column is present in the order listed in the query.
        // Starting from 0.
        // EDIT this if you've changed the columns, above.
        for (var i in rows) {
            coordinate = new google.maps.LatLng(rows[i][1],rows[i][0]);
            iconUrl = rows[i][2];
            content = "<strong>" + rows[i][3] + "</strong><br>" + rows[i][4] + "<br>" + rows[i][5] + ", " + rows[i][6] + "<br>";

if (iconUrl) {   // ensure not empty
                createMarker(coordinate, iconUrl, content);
            } else {
                createMarker(coordinate, DEFAULT_ICON_URL, content);
            }
        }
        map.fitBounds(bounds);
    }

function initialize() {

fetchData();  // begin retrieving data from table, and put it on the map

map = new google.maps.Map(document.getElementById('map-canvas'), {
            center: new google.maps.LatLng(40.7,-73.8),
            zoom: 13,
            mapTypeId: google.maps.MapTypeId.ROADMAP
        });
    }

google.maps.event.addDomListener(window, 'load', initialize);

</script>
</head>
<body>
    <div id="map-canvas"></div>
</body>
</html>

</code>
  </pre>
</DIV>