abubelinha

## README.md

      
              2 files
            
          
              19 forks
            
          
              54 comments
            
          
              60 stars
            
          
                chrislkeller
                / README.md
            
            
              Last active
              December 18, 2020 08:12
            
              
                SpreadSheet To Fusion Tables
              
          
    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


## navicat_tunnel.php
<?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());

## grab-images-wikipedia.php
<?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

## Makefile
COMPOSE := docker-compose -p demouuid

start:
	$(COMPOSE) up -d
	sleep 3
	while $(COMPOSE) ps | grep -q database; do \
		$(COMPOSE) logs 2>/dev/null| grep -q 'MySQL init process done.' && break;\
		$(COMPOSE) logs 2>/dev/null| grep -i error && break;\
		$(COMPOSE) ps | grep -q Exit && break;\
	done

## grid.sql
INSERT INTO <my_table_name> (cartodb_id, the_geom, the_geom_webmercator)
WITH inputs AS (SELECT
  ST_Transform(ST_SetSRID(ST_MakeEnvelope(
    -126.21093749999999, 23.241346102386135,
    -63.28125, 50.064191736659104
  ), 4326), 5070) geom,
  500000 width,
  500000 height
), rast AS (SELECT
  (st_pixelaspolygons(

## Connect-to-Android-WebDAV-Server.md

      
              2 files
            
          
              1 fork
            
          
              0 comments
            
          
              10 stars
            
          
                akaleeroy
                / Connect-to-Android-WebDAV-Server.md
            
            
              Last active
              October 14, 2021 16:31
            
              
                Access phone storage over WiFi with WebDAV Server for Android
              
          
    Access phone storage over WiFi

Batch file to map your Android phone as network drive in Windows.

Requirements


An Android phone
WebDAV Server or WebDAV Server Ultimate
WiFi router (PC and phone on the same network)


## index.html
<!DOCTYPE html>
<html>
  <head>
    <title>Leaflet</title>
    <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.css" />
    <script src="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.js"></script>
    <script src="http://maps.google.com/maps/api/js?v=3.2&sensor=false"></script>
    <script src="http://matchingnotes.com/javascripts/leaflet-google.js"></script>
  </head>
  <body>

## gist:2296532
<?php
/**
* Spatialite to GeoJSON

It needs:

    *  apache2
    * php5-cli
    * php5-sqlite

## col_versions.R
library(tidyverse)

# 2017 monthly
x <- tempfile("col")
dir.create(x)
download.file("https://download.catalogueoflife.org/col/monthly/2017-02-27_dwca.zip", file.path(x, "dwca.zip"))
unzip(file.path(x, "dwca.zip"), exdir = x)
fs::dir_ls(x)
taxa <- readr::read_tsv(file.path(x, "taxa.txt"), guess_max=1e6, quote="", col_types = readr::cols(.default = "c"))
taxa %>% filter(specificEpithet == "sapiens", taxonomicStatus == "accepted name", genus=="Homo")

## dbcopier.py
#!/usr/bin/env python
import ConfigParser
import os
import time
import getpass


def combine_files(self,file1,file2):
    with open('file1', 'w') as outfile:
            with open(file2) as infile:
	<?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());
	<?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
	COMPOSE := docker-compose -p demouuid

	start:
	$(COMPOSE) up -d
	sleep 3
	while $(COMPOSE) ps \| grep -q database; do \
	$(COMPOSE) logs 2>/dev/null\| grep -q 'MySQL init process done.' && break;\
	$(COMPOSE) logs 2>/dev/null\| grep -i error && break;\
	$(COMPOSE) ps \| grep -q Exit && break;\
	done
	INSERT INTO <my_table_name> (cartodb_id, the_geom, the_geom_webmercator)
	WITH inputs AS (SELECT
	ST_Transform(ST_SetSRID(ST_MakeEnvelope(
	-126.21093749999999, 23.241346102386135,
	-63.28125, 50.064191736659104
	), 4326), 5070) geom,
	500000 width,
	500000 height
	), rast AS (SELECT
	(st_pixelaspolygons(
	<!DOCTYPE html>
	<html>
	<head>
	<title>Leaflet</title>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.css" />
	<script src="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.js"></script>
	<script src="http://maps.google.com/maps/api/js?v=3.2&sensor=false"></script>
	<script src="http://matchingnotes.com/javascripts/leaflet-google.js"></script>
	</head>
	<body>
	<?php
	/**
	* Spatialite to GeoJSON

	It needs:

	* apache2
	* php5-cli
	* php5-sqlite
	library(tidyverse)

	# 2017 monthly
	x <- tempfile("col")
	dir.create(x)
	download.file("https://download.catalogueoflife.org/col/monthly/2017-02-27_dwca.zip", file.path(x, "dwca.zip"))
	unzip(file.path(x, "dwca.zip"), exdir = x)
	fs::dir_ls(x)
	taxa <- readr::read_tsv(file.path(x, "taxa.txt"), guess_max=1e6, quote="", col_types = readr::cols(.default = "c"))
	taxa %>% filter(specificEpithet == "sapiens", taxonomicStatus == "accepted name", genus=="Homo")
	#!/usr/bin/env python
	import ConfigParser
	import os
	import time
	import getpass


	def combine_files(self,file1,file2):
	with open('file1', 'w') as outfile:
	with open(file2) as infile: