Download "user manual"

Routing [plugin]
functions in your database by typing:
$ psql -d demo_plugins -f routing_core.sql
These file are in the pgRouting installation package in folder /core/sql/
• Import Europe road geodata in PostGIS, create its graph structure and
configure plugin routing database. To do so, simply execute the
demo_routing.sql file, located in the <CARTOWEB_HOME>/projects/demoPlugins/
server_conf/sql directory. You may need to uncompress the file with gunzip
before usage.
Note
These steps are detailed in the next section.
• Edit the cartoweb3/projects/demoPlugins/demo.properties file. and
uncomment the line beginning with ;ROUTING_PLUGINS
• Execute cw3setup.php. file, with the --config-from-file option as described in the
previous chapter.
27.2.2. Detailled installation steps
The routing module is a set of functions that compute a shortest path from a set of
edges and vertices. Some functions are provided for importing data from geometric
tables, and for generating results as geometries.
Note
For more information on these functions, you can have a look at the pgRouting
documentation: http://pgrouting.postlbs.org/wiki/pgRoutingDocs.
This section explains the main steps to integrate the routing fonctionnalities in a
custom application. We describe the steps followed to install the routing demo. To
make short, we used an Europe roads shapefile, imported it in PostGIS, generated the
graph tables and configured files to suggest a search of the shortest path between two
European towns.
Note
The following chapters describe steps necessary to build a graph structure from
shapefiles. It is not necessary to execute these commands if the demo_routing.sql file
(<CARTOWEB_HOME>/projects/demoPlugins/server_conf/sql) was loaded into
the demo_plugins database. This file already installs all the routing structure.
167