{"id":7881,"date":"2019-01-23T01:18:49","date_gmt":"2019-01-23T00:18:49","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?p=7881"},"modified":"2025-08-25T09:20:46","modified_gmt":"2025-08-25T07:20:46","slug":"how-to-develop-an-application-with-pgrouting-in-windows-1","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/how-to-develop-an-application-with-pgrouting-in-windows-1\/","title":{"rendered":"How to develop an application with pgrouting in Windows (1)"},"content":{"rendered":"\n

Here starts a series of articles to set up a routing web application (route\ncalculation) completely autonomous, ie using no web service or API for\ncalculating the route.
\nWe will set up the database including the route network (or fluvial, etc.) with\nPostgresql, then we will set up a wms flow with Geoserver, and finally we will\ndevelop a calculation page with OpenLayers 3. All using Windows . <\/p>\n\n\n\n\n\n\n\n

In this first article we will discuss the setting up of the network\ndatabase.
\nYou will need to have an operational installation of PostreSQL \/ Postgis<\/a>. If\nthis is not the case, refer to the article Starting with PostgreSQL \/ Postgis.<\/a> <\/p>\n\n\n\n

Pgrouting installation<\/strong> <\/p>\n\n\n\n

For routing calculations, we will use the Postgis pgrouting extension. It\nis installed, in theory, with the new Postgis versions. To be on the safe side,\nopen pgAdmin III and run the following SQL query: <\/p>\n\n\n\n

SELECT pgr_version (); \n\nYou must have a result like this:   \n\n\n\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If pgrouting is not installed: <\/p>\n\n\n\n

    \n
  1. Download the zipped pgRouting file zip file for your system (32 or 64
    bit) from Winnie . <\/li>\n\n\n\n
  2. Unzip the
    file. You will find three directories: bin, lib and share folders and two text
    files. <\/li>\n\n\n\n
  3. Copy
    these files and directories into the directory of your Postgres installation
    (in my case C: \\
    Programs \\ PostgreSQL \\ 9.5 ) <\/li>\n\n\n\n
  4. In
    pgAdmin III select your Postgis database and run the following SQL query: <\/li>\n<\/ol>\n\n\n\n

    CREATE EXTENSION pgrouting; <\/p>\n\n\n\n

    Check with the following query that the installation has been completed\nsuccessfully <\/p>\n\n\n\n

    SELECT pgr_version (); \n\nIf the version you have is\nnot the last (2.2.3), download and update your version. The whole series of\nthese articles is achieved with this version and be aware that the syntax of\nmany pgrouting commands has been modified. If\nyou try to run the queries shown here with older versions you risk error\nmessages like this:  \n\n\n\n<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Setting up the data<\/strong> <\/p>\n\n\n\n

    We will take the simplest case, but if you already have a network\ndatabase, you will need to take inspiration from this example to do the necessary\n adaptation for its use with pgrouting. <\/p>\n\n\n\n

    In our case, we will download openStreetMap data from Brittany. <\/p>\n\n\n\n

    We download them from Geofabrik (http:\/\/download.geofabrik.de\/europe\/france\/bretagne.html<\/a>\n). <\/p>\n\n\n\n

    You have several available formats (osm, shp, pbf). Whichever your\nchoice, there will be work to be done to make the data usable once loaded into\nyour Postgis database. The format that gives the least work and the best final\nresults is the osm .In addition, there is a tool (osm2pgrouting) that allows\nthe loading and creation of the topology in, just, one path. <\/p>\n\n\n