Vincent Sarago vincentsarago

Locate the section for your github remote in the .git/config file. It looks like this:

[remote "origin"]
	fetch = +refs/heads/*:refs/remotes/origin/*
	url = [email protected]:joyent/node.git

Now add the line fetch = +refs/pull/*/head:refs/remotes/origin/pr/* to this section. Obviously, change the github url to match your project's URL. It ends up looking like this:

303 See Other

Location: https://github.com/wsargent/docker-cheat-sheet

Hi there!

The docker cheat sheet has moved to a Github project under https://github.com/wsargent/docker-cheat-sheet.

Please click on the link above to go to the cheat sheet.

PostgreSQL & PostGIS Cheatsheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.

Installing Nominatim on Amazon Linux / EC2

Introduction

The official instructions for installing Nominatim are complete, but brief in places, and several steps must be changed in the Amazon Linux environment (which is roughly CentOS / Redhat). The steps below are rough record of what I did to get it working, but I didn't keep perfect track so you shouldn't rely on them as a shell script. Just follow each step, make sure it worked, and hopefully you'll need to adapt very little (version numbers, for one thing). (I also skip in and out of root, but you can be more careful if you like.)

Setting up the EC2 instance

Fix Qt for Homebrew QGIS install

Go to terminal and roll back the Qt installation through GitHub

$ brew uninstall qt

$ brew install https://raw.githubusercontent.com/Homebrew/homebrew/8dd3478131b232553f4c0cab197f8443a0a559a6/Library/Formula/qt.rb

This gist contains lists of modules available in

Python 3.10
Python 3.9
Python 3.8
Python 3.7
Python 3.6
Python 2.7

in AWS Lambda.

Falsehoods programmers believe about addresses

This is an anchor-linked version of the excellent, amazing original opus magnum by Michael Tandy.

An address will start with, or at least include, a building number.

Counterexample: Royal Opera House, Covent Garden, London, WC2E 9DD, United Kingdom.

When there is a building number, it will be all-numeric.

Counterexample: 1A Egmont Road, Middlesbrough, TS4 2HT

	server {

	listen 80;
	# default catch-all domain
	server_name _ ;

	error_page 503 @503 ;
	#return 503 ;

	root /var/www/htdocs/ ;

	create or replace function pointToTileFraction(float, float, integer) returns int[3] as $$

	declare
	lon ALIAS FOR $1;
	lat ALIAS FOR $2;
	z ALIAS FOR $3;
	result int[];
	BEGIN
	result := array_append(result, floor(pow(2,z) * (lon / 360 + 0.5))::int);
	result := array_append(result, floor(pow(2,z) * (0.5-0.25 (log((1 + sin(latpi()/180))/(1 - sin(lat*pi()/180)))/pi())))::int);

	#!/usr/bin/env zsh

	# ./day.sh month_number morning_day evening_day zoom_level

	# Strictly alpha: for example, does not know how to handle
	# month edges or unscheduled missing images.

	set -eu

	year=$1