{"id":970,"date":"2014-03-12T21:25:52","date_gmt":"2014-03-13T01:25:52","guid":{"rendered":"http:\/\/commons.trincoll.edu\/dataviz\/?p=970"},"modified":"2014-03-12T21:28:18","modified_gmt":"2014-03-13T01:28:18","slug":"google-fusion-table-number-of-coal-plants-in-each-state-searchable-by-state","status":"publish","type":"post","link":"http:\/\/commons.trincoll.edu\/dataviz\/2014\/03\/12\/google-fusion-table-number-of-coal-plants-in-each-state-searchable-by-state\/","title":{"rendered":"Google Fusion Table- Number of Coal Plants in Each State (Searchable by State)"},"content":{"rendered":"<p>I was able to use the layer wizard to allow users to look at specific states using a search bar. This will be helpful if the user wishes to look at a smaller scale of map by state, instead of the entire country comparatively. This can also be done if you were to use a disease outbreak map, similar to the one I mentioned in the last post. With an outbreak map, the layer wizard could be used to create a search bar that would allow the user to search for specific outbreaks on a map&#8230;so the creator could have multiple disease outbreaks on one map.<\/p>\n<p>&nbsp;<\/p>\n<p><!--\n    #map-canvas { width:500px; height:400px; }\n.layer-wizard-search-label { font-family: sans-serif };\n-->\/\/<br \/>\n\/\/ &gt;0&#8243;,<br \/>\n          from: &#8220;1EcVjHVW1MhqOS_OgeVbldAzZxbKOt_3weRLIMcog&#8221;<br \/>\n        },<br \/>\n        map: map,<br \/>\n        styleId: 2,<br \/>\n        templateId: 2<br \/>\n      });<br \/>\n    }<br \/>\n    function changeMap_0() {<br \/>\n      var whereClause;<br \/>\n      var searchString = document.getElementById(&#8216;search-string_0&#8217;).value.replace(\/&#8217;\/g, &#8220;\\\\'&#8221;);<br \/>\n      if (searchString != &#8216;&#8211;Select&#8211;&#8216;) {<br \/>\n        whereClause = &#8220;&#8216;name&#8217; = &#8216;&#8221; + searchString + &#8220;&#8216;&#8221;;<br \/>\n      }<br \/>\n      layer_0.setOptions({<br \/>\n        query: {<br \/>\n          select: &#8220;col2&gt;&gt;0&#8221;,<br \/>\n          from: &#8220;1EcVjHVW1MhqOS_OgeVbldAzZxbKOt_3weRLIMcog&#8221;,<br \/>\n          where: whereClause<br \/>\n        }<br \/>\n      });<br \/>\n    }<br \/>\n    google.maps.event.addDomListener(window, &#8216;load&#8217;, initialize);<\/p>\n<p>\/\/ ]]&gt;<\/p>\n<div id=\"map-canvas\"><\/div>\n<div style=\"margin-top: 10px\"><label class=\"layer-wizard-search-label\"><label class=\"layer-wizard-search-label\"><br \/>\nState&#8211;Select&#8211;AlabamaAlaskaAmerican SamoaArizonaArkansasCaliforniaColoradoCommonwealth of the Northern Mariana IslandsConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaGuamHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaPuerto RicoRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirgin Islands of the United StatesVirginiaWashingtonWest VirginiaWisconsinWyoming<\/label><\/label>&nbsp;<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was able to use the layer wizard to allow users to look at specific states using a search bar. This will be helpful if the user wishes to look at a smaller scale of map by state, instead of the entire country comparatively. This can also be done if you were to use a &hellip; <a href=\"http:\/\/commons.trincoll.edu\/dataviz\/2014\/03\/12\/google-fusion-table-number-of-coal-plants-in-each-state-searchable-by-state\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Google Fusion Table- Number of Coal Plants in Each State (Searchable by State)<\/span><\/a><\/p>\n","protected":false},"author":723,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[20,21,4],"tags":[],"_links":{"self":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/970"}],"collection":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/users\/723"}],"replies":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/comments?post=970"}],"version-history":[{"count":6,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/970\/revisions"}],"predecessor-version":[{"id":974,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/970\/revisions\/974"}],"wp:attachment":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/media?parent=970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/categories?post=970"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/tags?post=970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}