Skip to content

Instantly share code, notes, and snippets.

View patchypt's full-sized avatar

Patchypt patchypt

0 followers · 2 following
View GitHub Profile
@patchypt
patchypt / testGmap.html
Created March 20, 2017 06:06
geochart query from google sheet with multiple columns
<script type='text/javascript' src='http://www.google.com/jsapi'></script>
<script type='text/javascript'>google.load('visualization', '1', {'packages': ['geochart']});
google.setOnLoadCallback(drawVisualization);
function drawVisualization()
{
var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1dTfxVvfDKn6iXn4W_m7HJ_86JOGNDsxYSSaXipEo0vM/edit#gid=0');
// query.setQuery('select A,B,C');
query.send(handleQueryResponseTR);
@patchypt
patchypt / gist:60cd3c0c723c2a3cf2921a276691bfd2
Created March 23, 2017 09:16
geochart query from googlesheet with clickable url on regions
<script type='text/javascript' src='http://www.google.com/jsapi'></script>
<script type='text/javascript'>google.load('visualization', '1', {'packages': ['geochart']});
google.setOnLoadCallback(drawVisualization);
function drawVisualization()
{
var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1dTfxVvfDKn6iXn4W_m7HJ_86JOGNDsxYSSaXipEo0vM/edit#gid=0');
// query.setQuery('select A,B,C');
query.send(handleQueryResponseTR);
}
@patchypt
patchypt / ColorGmap.html
Created March 27, 2017 16:01
Geochart : coloring each countries
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Map</title>
<style xmlns="http://www.w3.org/2000/svg">
/* #colormap path:hover { fill: #90db7c; } */
#colormap rect:hover {fill:transparent;}