Skip to content

Instantly share code, notes, and snippets.

View barryrowlingson's full-sized avatar

Barry Rowlingson barryrowlingson

View GitHub Profile
@barryrowlingson
barryrowlingson / load_xyz_sources.py
Created February 27, 2018 16:00 — forked from ThomasG77/load_xyz_sources.py
PyQGIS script to save/load/wipe XYZ sources in Browser Panel in QGIS3
# -*- coding: utf-8 -*-
"""
/***************************************************************************
Name : XYZ manager
Description : Script to save/load/wipe WYZ sources in QGIS 3.0
Date : February 27, 2017
copyright : (C) 2017 by Thomas Gratier
email : thomas.gratier@webgeodatavore.com
@barryrowlingson
barryrowlingson / ggfail.R
Last active January 29, 2018 15:50 — forked from anonymous/ggfail.R
polygon clipping in ggplot
library(sp)
library(rgdal)
library(ggplot2)
library(spdep)
library(ggpolypath)
usq = data.frame(x=c(0,1,1,0),y=c(0,0,1,1))
pts1 =
structure(list(x = c(-0.380226816911908, -0.368506824640174,
# Author: Joona Lehtomäki <joona.lehtomaki@gmail.com>
# Updated: 13.11.2011
# Version: 0.0.1
if (!require("rgdal")) {
install.packages("rgdal")
}
if (!require("raster")) {
install.packages("raster")
@barryrowlingson
barryrowlingson / response times by language.sql
Created October 31, 2012 14:11 — forked from guilespi/response times by language.sql
StackOverflow response times by stats packages (and java)
select TagName,
avg(cast(ResponseTime as bigint)) as Average,
stdev(cast(ResponseTime as bigint)) as StandardDev
from
(SELECT
Questions.CreationDate,
Questions.Title,
Tags.TagName,
Answers.CreationDate as ResponseDate,
datediff(minute, Questions.CreationDate,