Jay Goldberg JayGoldberg

## url-param-stripper.html
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>URL Parameter Stripper</title>
</head>
<body>
	<h1>URL Parameter Stripper</h1>

## etl_geojson.py
#!/usr/bin/env python3
# See: https://medium.com/@lakshmanok/how-to-load-geojson-files-into-bigquery-gis-9dc009802fb4

import json
import sys

def convert_geojson(input_file_path):
    with open(input_file_path, 'r') as ifp:
        with open('to_load.json', 'w') as ofp:
            features = json.load(ifp)['features']

## convertGeoJsonToBq.js
// https://medium.com/google-cloud/how-to-load-geojson-files-into-bigquery-gis-9dc009802fb4
// Javascript (NodeJS) vs Python
function convertGeoJsonBq() {
  const fs = require('fs');

  fs.readFile(process.argv[1], 'utf8', (err, data) => {
    if (err) throw err;

    const geojson = JSON.parse(data);
    const features = geojson.features;

## resolveRedirect.gs
const options = {
  'muteHttpExceptions': true,
  'followRedirects': false
};

function getStatusCode(url) {
  const url_trimmed = url.trim();

  let cache = CacheService.getScriptCache();
  let result = cache.get(url_trimmed);

## bqCreateExternalTableFromDrive.gs
// create external table from CSV or Google Sheet, autodetect schema
function bqCreateCsvTable(csvDriveFileId) {
  const CONFIG = setConfig();

  let csvFile = DriveApp.getFileById(csvDriveFileId);
  let tableId = csvFile.getName();

  let bqConfig = {
    "tableReference": {
        "projectId": CONFIG.projectId,

## restWebService.gs
function doGet(e) {
  // Look up the function for the specified endpoint
  var handler = getEndpointHandlers[e.parameter.action];
  if (handler) {
    // Call the appropriate function for the endpoint
    return handler(e);
  } else {
    // Return an error if the endpoint is not recognized
    return ContentService.createTextOutput("Error: Invalid GET endpoint.").setMimeType(ContentService.MimeType.TEXT);
  }

## driveFolderTagging.gs
// https://www.labnol.org/code/19721-add-tags-google-drive-files
/*
 setDescriptionToFolderNames
 Workaround to fake Tags in Google Drive.
 Writes all the folder names of a file into the file description, so that the file can be found by searching the folder names.
*/

function setDescriptionToFolderNames() {
  var file;
  var filename;

## mouseDraw.js
// Get the canvas and its context
var canvas = document.querySelector('#paint');
var ctx = canvas.getContext('2d');

// Get the parent element of the canvas and its computed style
var sketch = document.querySelector('.sketch');
var sketch_style = getComputedStyle(sketch);

// Set the canvas dimensions to match the parent element
canvas.width = parseInt(sketch_style.getPropertyValue('width'));

## drawing.js
(function(window){
  // Define the Pen object, which handles drawing on the canvas
  var Pen = function(context){
    // Whether the user is currently drawing
    var drawing;

    // Reset the pen's drawing style
    this.reset = function(){
      context.beginPath();
      context.lineCap = 'round';

## spreadsheetIndexfromColumn.js
// given a column 'A'...'AB' etc, return a numeric index
function columnToIndex(column) {
  // Initialize the index to 0
  var index = 0;

  // Iterate through the characters in the column string
  for (var i = 0; i < column.length; i++) {
    // Get the character at the current index
    var char = column.charAt(i);
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>URL Parameter Stripper</title>
	</head>
	<body>
	<h1>URL Parameter Stripper</h1>
	#!/usr/bin/env python3
	# See: https://medium.com/@lakshmanok/how-to-load-geojson-files-into-bigquery-gis-9dc009802fb4

	import json
	import sys

	def convert_geojson(input_file_path):
	with open(input_file_path, 'r') as ifp:
	with open('to_load.json', 'w') as ofp:
	features = json.load(ifp)['features']
	// https://medium.com/google-cloud/how-to-load-geojson-files-into-bigquery-gis-9dc009802fb4
	// Javascript (NodeJS) vs Python
	function convertGeoJsonBq() {
	const fs = require('fs');

	fs.readFile(process.argv[1], 'utf8', (err, data) => {
	if (err) throw err;

	const geojson = JSON.parse(data);
	const features = geojson.features;
	const options = {
	'muteHttpExceptions': true,
	'followRedirects': false
	};

	function getStatusCode(url) {
	const url_trimmed = url.trim();

	let cache = CacheService.getScriptCache();
	let result = cache.get(url_trimmed);
	// create external table from CSV or Google Sheet, autodetect schema
	function bqCreateCsvTable(csvDriveFileId) {
	const CONFIG = setConfig();

	let csvFile = DriveApp.getFileById(csvDriveFileId);
	let tableId = csvFile.getName();

	let bqConfig = {
	"tableReference": {
	"projectId": CONFIG.projectId,
	function doGet(e) {
	// Look up the function for the specified endpoint
	var handler = getEndpointHandlers[e.parameter.action];
	if (handler) {
	// Call the appropriate function for the endpoint
	return handler(e);
	} else {
	// Return an error if the endpoint is not recognized
	return ContentService.createTextOutput("Error: Invalid GET endpoint.").setMimeType(ContentService.MimeType.TEXT);
	}
	// https://www.labnol.org/code/19721-add-tags-google-drive-files
	/*
	setDescriptionToFolderNames
	Workaround to fake Tags in Google Drive.
	Writes all the folder names of a file into the file description, so that the file can be found by searching the folder names.
	*/

	function setDescriptionToFolderNames() {
	var file;
	var filename;
	// Get the canvas and its context
	var canvas = document.querySelector('#paint');
	var ctx = canvas.getContext('2d');

	// Get the parent element of the canvas and its computed style
	var sketch = document.querySelector('.sketch');
	var sketch_style = getComputedStyle(sketch);

	// Set the canvas dimensions to match the parent element
	canvas.width = parseInt(sketch_style.getPropertyValue('width'));
	(function(window){
	// Define the Pen object, which handles drawing on the canvas
	var Pen = function(context){
	// Whether the user is currently drawing
	var drawing;

	// Reset the pen's drawing style
	this.reset = function(){
	context.beginPath();
	context.lineCap = 'round';
	// given a column 'A'...'AB' etc, return a numeric index
	function columnToIndex(column) {
	// Initialize the index to 0
	var index = 0;

	// Iterate through the characters in the column string
	for (var i = 0; i < column.length; i++) {
	// Get the character at the current index
	var char = column.charAt(i);