{"id":3793,"date":"2014-10-14T09:55:34","date_gmt":"2014-10-14T00:55:34","guid":{"rendered":"https:\/\/gunmagisgeek.com\/wordpress\/?p=3793"},"modified":"2018-12-13T10:48:42","modified_gmt":"2018-12-13T01:48:42","slug":"post-3793","status":"publish","type":"post","link":"https:\/\/gunmagisgeek.com\/blog\/google-map-api\/3793","title":{"rendered":"\u8907\u6570\u306eFusion Tables\u3092\u4e00\u3064\u306e\u5730\u56f3\u4e0a\u306b\u91cd\u306d\u3066\u8868\u793a\u3059\u308b\u3002"},"content":{"rendered":"<p>\u6b8b\u5ff5\u306a\u304c\u3089\u3001Fusion Tables\u306f\u5ec3\u6b62\u3055\u308c\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"https:\/\/support.google.com\/fusiontables\/answer\/9185417\">Notice: Google Fusion Tables Turndown &#8211; Fusion Tables Help<\/a><\/p>\n<hr>\n<p>\u4e0b\u8a18\u306f\u7fa4\u99ac\u770c\u306e\u30d0\u30b9\u30eb\u30fc\u30c8\u30c7\u30fc\u30bf\u3068\u30d0\u30b9\u505c\u7559\u6240\u30c7\u30fc\u30bf\u306eFusion Tables\u3092\u91cd\u306d\u3066\u8868\u793a\u3057\u305f\u4f8b\u3002<\/p>\n<p><a href=\"https:\/\/shimz.me\/datavis\/gunma\/bussmap\/\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/gunmagisgeek.com\/blog\/wp-content\/uploads\/2014\/10\/FusionTables141014.jpg\" alt=\"FusionTables\" width=\"590\" height=\"308\" class=\"aligncenter size-full wp-image-3794\" srcset=\"https:\/\/gunmagisgeek.com\/blog\/wp-content\/uploads\/2014\/10\/FusionTables141014.jpg 590w, https:\/\/gunmagisgeek.com\/blog\/wp-content\/uploads\/2014\/10\/FusionTables141014-287x150.jpg 287w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/shimz.me\/datavis\/gunma\/bussmap\/\">example<\/a><\/p>\n<p>\u4ee5\u524d\u3082\u7d39\u4ecb\u3057\u305f\u3053\u3068\u304c\u3042\u308b<a href=\"https:\/\/gunmagisgeek.com\/blog\/map\/2670\">Fusion Tables<\/a>\u3002\u624b\u8efd\u306b\u5730\u7406\u60c5\u5831\u306e\u8996\u899a\u5316\u304c\u884c\u3048\u3066\u975e\u5e38\u306b\u4fbf\u5229\u306a\u306e\u3067\u3059\u304c\u3001Google\u30c9\u30e9\u30a4\u30d6\u306e\u4e2d\u3067\u306f\u57fa\u672c\u4e00\u3064\u306e\u5730\u56f3\u306b\uff11\u7a2e\u985e\u306e\u30c7\u30fc\u30bf\u3057\u304b\u8868\u793a\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<p>Google Maps API\u30b3\u30fc\u30c9\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u6a5f\u80fd\u3092\u4f7f\u3046\u3068\u3001\u8907\u6570\u306eFusion Tables\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2>\u30b5\u30f3\u30d7\u30eb<\/h2>\n<h3>Google Maps API\u30b3\u30fc\u30c9\u51fa\u529b<\/h3>\n<p>\u300cTools\u300d\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300cPublish\u300d\u3092\u9078\u629e\u3057\u300cGet HTML and JavaScript\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068Google Maps API\u30b3\u30fc\u30c9\u304c\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/gunmagisgeek.com\/blog\/wp-content\/uploads\/2013\/03\/gmfusiontables000008.jpg\" alt=\"Fusion Tables\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\" width=\"473\" height=\"622\" class=\"alignnone size-full wp-image-2689 border\" srcset=\"https:\/\/gunmagisgeek.com\/blog\/wp-content\/uploads\/2013\/03\/gmfusiontables000008.jpg 473w, https:\/\/gunmagisgeek.com\/blog\/wp-content\/uploads\/2013\/03\/gmfusiontables000008-114x150.jpg 114w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><\/p>\n<p>\u51fa\u529b\u3055\u308c\u308b\u30b3\u30fc\u30c9\u306b\u306fGoogle Maps\u306e\u521d\u671f\u5316\u306a\u3069\u304c\u542b\u307e\u308c\u307e\u3059\u304c\u3001Fusion Tables\u3092\u8868\u793a\u3057\u3066\u3044\u308b\u306e\u306f\u4ee5\u4e0b\u306e\u90e8\u5206\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"lang:js decode:true \" >layer = new google.maps.FusionTablesLayer({\n  map: map,\n  heatmap: { enabled: false },\n  query: {\n    select: \"col6\",\n    from: \"1jKSH39amF5BDFE0YZBJn0KZZPeX8oOMKpuwu0X1F\",\n    where: \"\"\n  },\n  options: {\n    styleId: 2,\n    templateId: 2\n  }\n});\n<\/pre>\n<p>google.maps.FusionTablesLayer\u3067\u6307\u5b9a\u3057\u305fFusion Tables\u3092\u751f\u6210\u3057Google Maps\u4e0a\u306b\u8868\u793a\u3057\u3066\u3044\u308b\u308f\u3051\u3067\u3059\u304c\u3001\u3053\u306e\u90e8\u5206\u3092\u30b3\u30d4\u30da\u3057\u3066\u4e00\u3064\u306eGoogle Maps\u306b\u8ffd\u52a0\u3059\u308c\u3070\u8907\u6570\u306eFusion Tables\u3092\uff11\u3064\u306e\u5730\u56f3\u4e0a\u306b\u91cd\u306d\u3066\u8868\u793a\u3067\u304d\u307e\u3059\u3002<br \/>\n\uff08\u4e00\u90e8webix\u3092\u4f7f\u3063\u3066\u307e\u3059\u3002div\u30a8\u30ec\u30e1\u30f3\u30c8\u3092\u751f\u6210\u3057\u3066\u3044\u308b\u3060\u3051\u3067\u3059\u3002)<\/p>\n<pre class=\"lang:js mark:31-59 decode:true \" >webix.ui({\n    rows:[\n        {css: \"header\",template:\"\u7fa4\u99ac\u770c\u30d0\u30b9\u505c\u7559\u6240\", height:35 },\n        {css:\"map_view\", template:' &lt;div id=\"googft-mapCanvas\"&gt;&lt;\/div&gt;'},\n        {css:\"footer\", template:\"@_shimizu\", height:35 },\n    ]\n}).show();\n \n \n function initialize() {\n    google.maps.visualRefresh = true;\n    var isMobile = (navigator.userAgent.toLowerCase().indexOf('android') &gt; -1) ||\n      (navigator.userAgent.match(\/(iPod|iPhone|iPad|BlackBerry|Windows Phone|iemobile)\/));\n    if (isMobile) {\n      var viewport = document.querySelector(\"meta[name=viewport]\");\n      viewport.setAttribute('content', 'initial-scale=1.0, user-scalable=no');\n    }\n    var mapDiv = document.getElementById('googft-mapCanvas');\n    \n    var style_array_from_above_here =  [{\"featureType\":\"water\",\"elementType\":\"all\",\"stylers\":[{\"hue\":\"#e9ebed\"},{\"saturation\":-78},{\"lightness\":67},{\"visibility\":\"simplified\"}]},{\"featureType\":\"landscape\",\"elementType\":\"all\",\"stylers\":[{\"hue\":\"#ffffff\"},{\"saturation\":-100},{\"lightness\":100},{\"visibility\":\"simplified\"}]},{\"featureType\":\"road\",\"elementType\":\"geometry\",\"stylers\":[{\"hue\":\"#bbc0c4\"},{\"saturation\":-93},{\"lightness\":31},{\"visibility\":\"simplified\"}]},{\"featureType\":\"poi\",\"elementType\":\"all\",\"stylers\":[{\"hue\":\"#ffffff\"},{\"saturation\":-100},{\"lightness\":100},{\"visibility\":\"off\"}]},{\"featureType\":\"road.local\",\"elementType\":\"geometry\",\"stylers\":[{\"hue\":\"#e9ebed\"},{\"saturation\":-90},{\"lightness\":-8},{\"visibility\":\"simplified\"}]},{\"featureType\":\"transit\",\"elementType\":\"all\",\"stylers\":[{\"hue\":\"#e9ebed\"},{\"saturation\":10},{\"lightness\":69},{\"visibility\":\"on\"}]},{\"featureType\":\"administrative.locality\",\"elementType\":\"all\",\"stylers\":[{\"hue\":\"#2c2e33\"},{\"saturation\":7},{\"lightness\":19},{\"visibility\":\"on\"}]},{\"featureType\":\"road\",\"elementType\":\"labels\",\"stylers\":[{\"hue\":\"#bbc0c4\"},{\"saturation\":-93},{\"lightness\":31},{\"visibility\":\"on\"}]},{\"featureType\":\"road.arterial\",\"elementType\":\"labels\",\"stylers\":[{\"hue\":\"#bbc0c4\"},{\"saturation\":-93},{\"lightness\":-2},{\"visibility\":\"simplified\"}]}];\n    var map = new google.maps.Map(mapDiv, {\n        center: new google.maps.LatLng(36.322356, 139.013057),\n        zoom: 14,\n        mapTypeId: google.maps.MapTypeId.ROADMAP,\n        styles: style_array_from_above_here\n    });\n    map.controls[google.maps.ControlPosition.RIGHT_BOTTOM].push(document.getElementById('googft-legend-open'));\n    map.controls[google.maps.ControlPosition.RIGHT_BOTTOM].push(document.getElementById('googft-legend'));\n\n    \n    \/\/\u30d0\u30b9\u30eb\u30fc\u30c8\u30c7\u30fc\u30bf\u306eFusion Tables\u3092\u8868\u793a\n    var buss_route = new google.maps.FusionTablesLayer({\n        map: map,\n        heatmap: { enabled: false },\n        query: {\n            select: \"col8\",\n            from: \"1x3vlOo5wVXoMjsbS3sRT75LdSZ4KMeo5JGMNKGeQ\",\n            where: \"\"\n        },\n        options: {\n            styleId: 2,\n            templateId: 2\n        }\n    });\n    \n    \/\/\u30d0\u30b9\u505c\u7559\u6240\u30c7\u30fc\u30bf\u306eFusion Tables\u3092\u8868\u793a \n    var buss_stop = new google.maps.FusionTablesLayer({\n        map: map,\n        heatmap: { enabled: false },\n        query: {\n            select: \"col6\",\n            from: \"1jKSH39amF5BDFE0YZBJn0KZZPeX8oOMKpuwu0X1F\",\n            where: \"\"\n        },\n        options: {\n            styleId: 2,\n            templateId: 2\n        }\n    });\n\n    \n    if (isMobile) {\n        var legend = document.getElementById('googft-legend');\n        var legendOpenButton = document.getElementById('googft-legend-open');\n        var legendCloseButton = document.getElementById('googft-legend-close');\n        legend.style.display = 'none';\n        legendOpenButton.style.display = 'block';\n        legendCloseButton.style.display = 'block';\n        legendOpenButton.onclick = function() {\n            legend.style.display = 'block';\n            legendOpenButton.style.display = 'none';\n        }\n        legendCloseButton.onclick = function() {\n            legend.style.display = 'none';\n            legendOpenButton.style.display = 'block';\n        }\n    }\n  }\n\n  google.maps.event.addDomListener(window, 'load', initialize);<\/pre>\n<p>FusionTablesLayer\u306esetQuery\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066\u8868\u793a\u3059\u308b\u30c7\u30fc\u30bf\u306e\u7d5e\u308a\u8fbc\u307f\u306a\u3069\u3082\u884c\u3048\u308b\u306e\u3067\u3059\u304c\u3001\u305d\u308c\u306b\u3064\u3044\u3066\u306f\u307e\u305f\u5f8c\u65e5\u66f8\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6b8b\u5ff5\u306a\u304c\u3089\u3001Fusion Tables\u306f\u5ec3\u6b62\u3055\u308c\u308b&hellip;<\/p>\n","protected":false},"author":1,"featured_media":3794,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-3793","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-map-api","has-post-thumbnail-archive"],"_links":{"self":[{"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/posts\/3793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/comments?post=3793"}],"version-history":[{"count":0,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/posts\/3793\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/media\/3794"}],"wp:attachment":[{"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/media?parent=3793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/categories?post=3793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/tags?post=3793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}