Skip to content

Instantly share code, notes, and snippets.

Drinking tea

Matt Walker walkermatt

Drinking tea
View GitHub Profile
AsgerPetersen / create_voronoi_function.sql
Last active Jan 18, 2021
Fast(er) voronoi polygons in PostGIS
View create_voronoi_function.sql
-- plpython needs to be enabled. Furthermore scipy needs to be installed in the python used.
-- CREATE LANGUAGE plpythonu;
CREATE OR REPLACE FUNCTION septima.voronoi(geom geometry, boundingpointdistance double precision)
RETURNS SETOF geometry_dump AS
from scipy.spatial import Voronoi
import numpy
class GeoVoronoi:
# Code borrowed from
# and upgraded for QGIS 3.0
import sys
from qgis.core import (QgsApplication, QgsFeature, QgsGeometry,
QgsProject, QgsVectorLayer)
from qgis.gui import QgsMapCanvas
from qgis.PyQt.QtCore import Qt
# Unused so commented
# from qgis.PyQt.QtGui import *
View gist:6c7b0afb180be4def6e705d701835f29
# got a huge ammount of help from
def sequence(i):
n = 2 * i - 1
return n * n
def layer(i):
return math.floor((math.sqrt(i) + 1) / 2)
def length(i):
csuzw / SpiralMemory.cs
Last active Dec 4, 2017
Advent of Code 2017 Day 3
View SpiralMemory.cs
int SpiralMemoryPartOne(int location)
if (location <= 1) return 0;
var ring = 1;
var max = 9;
while (max < location)
ring += 1;
max += (((ring + 1) * 2) - 2) * 4;
opera443399 /
Last active Dec 16, 2020
Print to the console in Python without UnicodeEncodeErrors 12 Jan 2014
I can't believe I just found out about this! If you use Python with unicode data, such as Django database records, you may have seen cases where you print a value to the console, and if you hit a record with an extended (non-ascii) character, your program crashes with the following:
Traceback (most recent call last):
File "", line 792, in <module>
print value
UnicodeEncodeError: 'ascii' codec can't encode character u'\xa0' in position 20: ordinal not in range(128)
iacovlev-pavel /
Last active Sep 30, 2020
Install GeoServer on Ubuntu 18.04
apt-get install openjdk-8-jre
# PostgreSQL and PostGIS
apt-get install postgresql postgresql-contrib postgis postgresql-10-postgis-2.4
# Create "geoserver" database
sudo -u postgres createuser -P geoserver
sudo -u postgres createdb -O geoserver geoserver
sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" geoserver
View runtimer.js
function* runTimer(getState) {
while(yield take('START')) {
while(true) {
const {stop, tick} = yield race({
stop : take('STOP'),
tick : call(wait, ONE_SECOND);
if ( !stop ) {
yield put(actions.tick());
t-mart / netrw quick
Last active Feb 24, 2021
A quick reference for Vim's built-in netrw file selector.
View netrw quick
Map Action
<F1> Causes Netrw to issue help
<cr> Netrw will enter the directory or read the file
<del> Netrw will attempt to remove the file/directory
- Makes Netrw go up one directory
a Toggles between normal display, hiding (suppress display of files matching g:netrw_list_hide) showing (display only files which match g:netrw_list_hide)
c Make browsing directory the current directory
C Setting the editing window
d Make a directory
javisantana / speed.sql
Created Aug 12, 2015
speed from a track table
View speed.sql
WITH deltas as (
st_distance(the_geom::geography, lag(the_geom::geography, 1) over(order by timestamp)) as ddist,
timestamp - lag(timestamp, 1) over(order by timestamp) as dt
from out_2 offset 1000
select avg(ddist/dt) as speed from deltas
AustinDizzy / pre-commit
Created Jul 12, 2015
A pre-commit git hook that prompts you to automatically `gofmt` Go files staged to commit.
View pre-commit
# Modified 2015, Austin Dizzy
# Copyright 2012 The Go Authors. All rights reserved.
# Use of this source code is governed by a BSD-style
# license that can be found in the LICENSE file.
# git gofmt pre-commit hook
# To use, store as .git/hooks/pre-commit inside your repository and make sure
# it has execute permissions.