pgrouting Batch driving distance - a pgRouting function A function to batch process driving distance results for a set of input points, in this case, schools. The function creates a table to hold the results (dropping it if it exists) and then selects each school from the your_schools table and calculates the driving distance numbers. For each
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_
ordnance survey pgRouting and OS Open Roads Get the data you need from OS: http://www.ordnancesurvey.co.uk/business-and-government/products/os-open-roads.html Load the data into PostGIS using QGIS or pgAdmin or ogr2ogr - your choice. This takes some time to process as there are a large number links making up the network: 3.6 million
pgrouting pgRouting TRSP in OpenLayers3 I've managed, after some hacking, to write a wrapper to the pgr_trsp function in pgRouting that allows me to use the Turn Restricted Shortest Path to route between two points on the map. It is in the same structure as the Dijkstra Shortest Path wrapper with just a few
pgrouting pgRouting in OpenLayers3 with reverse costs The previous post looked at implementing the basic pgRouting workshop OpenLayers3 examples in EPSG:27700. This post adds reverse costs to the mix to take advantage of the road routing information (RRI) supplied with Ordnance Survey's ITN dataset. The changes to the two functions I created are minor - I
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.
