How can we visualise our driving distance dataset another way? Can we create something like this which is using Voronoi polygons: Palvealueanalyysi avoimella lähdekoodia #Hämeenlinna #PostGIS #pgRouting #sote #OSGeofi pic.twitter.com/ssyCD0vOxN — Pekka Sarkola (@posiki) May 23, 2017 Well, yes we can. And PostGIS gives us the tools
Checklist QGIS with the Time Manager plugin installed. a PostgreSQL database with PostGIS and pgRouting extensions installed. access to said database through psql or pgAdmin3/4 A quick and dirty workflow to create some animations using a road network and some driving distance calculations. I won't go through the process
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_
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
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
This collection of notes covers my foray into using pgRouting in OpenLayers3 in EPSG:27700, or British National Grid, rather than the usual Google or Spherical Web Mercator projections. This part looks at simply tweaking the tutorial to work in EPSG:27700. The pgRouting workshop (http://workshop.pgrouting.org/) includes
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.
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.
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.