dkastl

#!/bin/bash

# Install dependencies Ubuntu 14.04
sudo apt-get install git cmake build-essential libcgal-dev libboost-graph-dev libboost-thread-dev python-sphinx texlive texlive-latex-extra postgresql-9.4-postgis-2.1 postgresql-server-dev-all checkinstall

# Clone the repository
git clone git@github.com:pgRouting/pgrouting.git && cd pgrouting && git checkout develop

# Compile
rm -Rf build 

dkastl

#!/bin/bash

# Upgrade linux headers
sudo apt-get install linux-headers-`uname -r`

# Reconfigure dkms and load module:
sudo dpkg-reconfigure virtualbox-dkms  
sudo modprobe vboxdrv

dkastl

#!/bin/bash

# Install Git Buildpackage
sudo apt-get install git-buildpackage cdbs debhelper

# Create tarball from tag
cd pgrouting
git archive v2.2.3 | gzip > ../tarballs/pgrouting-2.2.3-release-orig.tar.gz

# This is only for the first import and creation of a new build repository

dkastl

dkastl

#!/bin/bash
MYDATE=$(date +%d-%m-%Y)
for PORT in 5432 5433 5434
do
  echo "Backups on port $PORT"
  export PGPORT=$PORT
  LIST=$(psql -l | awk '{ print $1 }' | grep '^[a-z]' | grep -v template | grep -v postgres)
  for ITEM in $LIST
  do
    NAME=${ITEM}-${MYDATE}.dmp

dkastl

CREATE OR REPLACE FUNCTION write_file (param_bytes bytea, param_filepath text)
RETURNS text
AS $$
import os
f = open(param_filepath, 'wb+')
os.chmod(param_filepath, 0666)
f.write(param_bytes)
return param_filepath
$$ LANGUAGE plpythonu;

dkastl

"\e[A": history-search-backward
"\e[B": history-search-forward
"\e[C": forward-char
"\e[D": backward-char

dkastl

Opening up the network data of OpenStreetMap with pgRouting

Report from "Training School 'FOSS4VGI'"

pgRouting adds routing functionality to a PostgreSQL/PostGIS database. The introductory workshop of the training school showed the participants how. It gave a practical example of how to use pgRouting with OpenStreetMap road network data. It explained the steps to prepare the data, make routing queries, assign costs and write a custom ‘plpgsql’ function to display the route in a web-mapping application.

Navigation for road networks requires complex routing algorithms that support turn restrictions

dkastl

unzip -O shift-jis myarchive.zip

dkastl

-- Sample data
CREATE TABLE pipes (id serial, geom geometry(LineString));
INSERT INTO pipes(geom) VALUES (ST_MakeLine(ST_MakePoint(1,1), ST_MakePoint(4,1)));
INSERT INTO pipes(geom) VALUES (ST_MakeLine(ST_MakePoint(1,0), ST_MakePoint(3,0)));

CREATE TABLE connections (id serial, geom geometry(LineString));
INSERT INTO connections(geom) VALUES (ST_MakeLine(ST_MakePoint(0,0), ST_MakePoint(1,1)));
INSERT INTO connections(geom) VALUES (ST_MakeLine(ST_MakePoint(0,2), ST_MakePoint(1,1)));
INSERT INTO connections(geom) VALUES (ST_MakeLine(ST_MakePoint(2,2), ST_MakePoint(2,1)));
INSERT INTO connections(geom) VALUES (ST_MakeLine(ST_MakePoint(4,0), ST_MakePoint(4,1)));