Dale Kunce dalekunce

PostgreSQL & PostGIS Cheat sheet

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

Mac OS X GIS Setup

OS X Preferences

# Expand save panel by default
defaults write NSGlobalDomain NSNavPanelExpandedStateForSaveMode -bool true

I've been interested in computer vision for a long time, but I haven't had any free time to make any progress until this holiday season. Over Christmas and the New Years I experimented with various methodologies in OpenCV to detect road signs and other objects of interest to OpenStreetMap. After some failed experiments with thresholding and feature detection, the excellent /r/computervision suggested using the dlib C++ module because it has more consistently-good documentation and the pre-built tools are faster.

After a day or two figuring out how to compile the examples, I finally made some progress:

Compiling dlib C++ on a Mac with Homebrew

Clone dlib from Github to your local machine:

Creating custom OBF files for OsmAnd

Setup

Make sure the latest version of java is installed.
Download OsmAndMapCreator from here: http://download.osmand.net/latest-night-build/OsmAndMapCreator-main.zip
Download a PBF file for your area of interest from Geofabrik (http://download.geofabrik.de/) or other source (e.g. activation wiki)
Create an OBF folder on your desktop
Unzip your OsmAndMapCreator folder to whatever location you want.

	# Some good references are:
	# http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x
	# http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/
	# http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2630392

	#1. Install PostgreSQL postgis and postgres

	brew install postgis
	initdb /usr/local/var/postgres
	pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

	#!/bin/sh

	if [ -z "$1" -o -z "$2" -o -z "$3" ]; then
	echo "Usage: $0 [movie file] [fps] [delay]"
	exit 1
	fi

	DIR=/tmp/anigif-$( date +"%s" )

	mkdir $DIR

	#!/bin/sh

	# Alot of these configs have been taken from the various places
	# on the web, most from here
	# https://github.com/mathiasbynens/dotfiles/blob/master/.osx

	# Set the colours you can use
	black='\033[0;30m'
	white='\033[0;37m'
	red='\033[0;31m'

	# Beta-quality Landsat 8-oriented windowed pansharpener by Charlie Loyd

	# python3 panchunk.py $SCENE/*B{4,3,2,8}.TIF ${SCENE}-pansharp.tif

	# Then you may want something like this to brighten it up:
	# convert -channel B -gamma 0.96 -channel RGB -sigmoidal-contrast 40,14% ${SCENE}-pansharp.tif ${SCENE}-pretty.tif
	# But that will strip geo tags.

	import asyncio
	import rasterio as rio