abubelinha

Script to sync a Google SpreadSheet to a Fusion Table

Save for a few legacy projects that still use Fusion Tables I don't actively use this script anymore. This update hopefully solves the OAuth issue that cropped up once Google depcricated the Client Login method used by the prior version.

As always, your mileage may vary, and I welcome someone -- Google or otherwise -- to offer a long-term maintained solution.

The following is largely cribbed from a Google example here. I try to explain some of the API settings that must be enabled in the Developer's Console and elsewhere

Create your spr

The difference between XYZ and TMS tiles and how to convert between them

Lots of tile-based maps use either the XYZ or TMS scheme. These are the maps that have tiles ending in /0/0/0.png or something. Sometimes if it's a script, it'll look like &z=0&y=0&x=0 instead. Anyway, these are usually maps in Spherical Mercator.

Good examples are OpenStreetMap, Google Maps, MapBox, MapQuest, etc. Lots of maps.

Most of those are in XYZ. The best documentation for that is slippy map tilenames on the OSM Wiki, and Klokan's Tiles a la Google.

	<?php
	/**
	* Spatialite to GeoJSON

	It needs:

	* apache2
	* php5-cli
	* php5-sqlite

	<?php
	class Weather {
	public $lat, $long, $weather, $location;
	private $weather_data, $location_data;

	public function __construct($lat=0.0, $long=0.0){
	$this->lat = (float) $lat;
	$this->long = (float) $long;
	}

	// Details: StackOverflow (http://stackoverflow.com/a/614397/18771)
	// License: cc-by-sa (http://creativecommons.org/licenses/by-sa/3.0/)
	// Extends: jQuery Tablesorter 2.0+ (http://tablesorter.com)
	// -------------------------------------------------------------------

	// file encoding must be UTF-8!
	function getTextExtractor()
	{
	return (function() {
	var patternLetters = /[öäüÖÄÜáàâéèêúùûóòôÁÀÂÉÈÊÚÙÛÓÒÔß]/g;

	<?php

	/**
	* Grab Images from Wikipedia via thier API
	*
	* @author http://techslides.com
	* @link http://techslides.com/grab-wikipedia-pictures-by-api-with-php
	*/

	//curl request returns json output via json_decode php function

	// TODO: options parser with overrides for projection, area etc.
	if (process.argv.length != 4) {
	console.error("usage: node convert.js <input.json> <output.json>");
	process.exit(1);
	}

	require('d3')
	require('./node_modules/d3-plugins/simplify/simplify.js')

	var fs = require('fs');

	#!/bin/sh

	# Use like this:
	#
	# minify-js.sh < app.js > app.min.js
	#

	curl -s \
	-d compilation_level=SIMPLE_OPTIMIZATIONS \
	-d output_format=text \

	function heidiDecode(hex) {
	var str = '';
	var shift = parseInt(hex.substr(-1));
	hex = hex.substr(0, hex.length - 1);
	for (var i = 0; i < hex.length; i += 2)
	str += String.fromCharCode(parseInt(hex.substr(i, 2), 16) - shift);
	return str;
	}
	document.write(heidiDecode('755A5A585C3D8141786B3C385E3A393'));

	<?php //version my104
	header("Content-Type: application/octet-stream");

	error_reporting(0);
	set_time_limit(0);
	set_magic_quotes_runtime(0);

	function phpversion_int()
	{
	list($maVer, $miVer, $edVer) = split("[/.-]", phpversion());