routing - Mixedbredie's Ghosts

Building Highways for pgRouting

A copy-and-paste post to help you build the new OS Highways for pgRouting. It is still a work in progress so things may change and break. Requires PostgreSQL with PostGIS and pgRouting and a licensed copy of Safe Software's FME Desktop. 1. Load the data If you have Safe Software’

pgrouting

All-in-one function to create isochrones

Well, almost all-in-one. The function currently requires some prep work on the input points before being able to generate the isochrones (alphashapes). The function takes as its arguments the point input table you want the isochrones for and the time in seconds. CREATE OR REPLACE FUNCTION public.make_isochronesX(v_

pgrouting

pgRouting alphashapes - batched

A while back I looked at generating alphashapes using pgRouting and displaying in QGIS. It was a pretty convoluted hack though and my SQL skills need some honing. After seeing a post by smathermather that generated isochrones using PostgreSQL functions and the pgRouting algorithms I thought there must be a

pgrouting

The QGIS Road Graph plugin

QGIS offers a plugin that will solve a shortest path problem across any vector polyline layer in any format - the Road Graph plugin. The advantage of using this plugin over pgRouting is that you don't need to do anything special to your polyline layer to route across it. As

pgrouting

Improving pgRouting Performance

The Network I've loaded up the new Open Roads network dataset from Ordnance Survey into PostGIS and got it working with pgRouting. I can route successfully from A to B across the network. The problem is that it is so slow. There are 3.18 million road links and 2.

pgrouting

Using pgRouting with OS Meridian2

A quick guide to building a pgRouting network from Ordnance Survey's Meridian2 dataset. It assumes you have a working PostgreSQL/PostGIS database. The most current information will be on Github: https://github.com/mixedbredie/meridian2-for-pgrouting Get the data Download the Meridian2 shapefiles for the UK from https://www.ordnancesurvey.co.

pgrouting

Using pgRouting with OS Strategi

A quick guide to building a pgRouting network with Ordnance Survey's Strategi dataset. It assumes you have a working PostgreSQL/PostGIS database. The latest information will be on Github: https://github.com/mixedbredie/strategi-for-pgrouting Get the data I downloaded the shapefiles for UK coverage from the Ordnance Survey: https://www.

pgrouting

Building ITN for pgRouting

This document and repository explains how to load Ordnance Survey ITN GML into a PostGIS database with Loader and then build a network suitable for use with pgRouting. The network will have one way streets, no entry and no turn restrictions, mandatory turns and grade separations for over- and underpasses.