Dmytro dklimok
WouterNieuwerth
/ GoogleSheetToBigQuery.js
Created
November 9, 2018 19:51
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Loads the content of a Google Drive Spreadsheet into BigQuery | |
| * Based on: | |
| * - https://www.lunametrics.com/blog/2017/07/26/connect-google-analytics-data-tools-via-bigquery/ | |
| * - https://developers.google.com/apps-script/advanced/bigquery | |
| * Edit by Wouter Nieuwerth, w.nieuwerth@adwise.nl | |
| * https://www.adwise.nl | |
| */ | |
| function loadSpreadsheet() { |
phirework
/ map.html
Created
February 12, 2013 18:16
Create a Google map using JSON data with check-box filtering for categories. Map data set-up: name, url, place (address), ltt (latitude), lgt (longitude), cat (category). Set up custom icons that correspond to the name of each category in PNG format. Sample: http://dev.phirephoenix.com/map/maps.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <div id="map" style="width: 550px; height: 450px"></div> | |
| <form action="#"> | |
| Eat: <input type="checkbox" id="eatbox" onclick="boxclick(this,'eat')" /> | |
| Stay: <input type="checkbox" id="staybox" onclick="boxclick(this,'stay')" /> | |
| Shop: <input type="checkbox" id="shopbox" onclick="boxclick(this,'shop')" /> | |
| Play: <input type="checkbox" id="playbox" onclick="boxclick(this,'play')" /> | |
| Community: <input type="checkbox" id="communitybox" onclick="boxclick(this,'community')" /><br /> | |
| </form> |