Tagged Questions
0
votes
1answer
26 views
missing tables vertices_tmp and vertices_tmp_id_seq pgrouting workshop
I'm using OSgeo 6.5 dvd and studing pgrouting workshop for get shortest path.
I created database call "routing" and used "template_routing" for create tables but only 3 tables created. So then I ...
1
vote
1answer
187 views
Unreachable vertex
I'm developing an application for academic purposes that mainly gives to the user a recommended itinerary for a previously introduced preferences (Gastronomy, Leisure,etc.).
For this purpose, I use ...
1
vote
2answers
71 views
osm2pgrouting hangs on “classes table created”
I'm trying to run osm2pgrouting and on Ubuntu 12.04...everything looks like it's working until it gets to "classes table created" when it just stops. I'm watching the process with the system monitor ...
0
votes
1answer
28 views
pgRouting one way segment direction
How can one acquire information about direction of a one way road from OpenStreetMap data converted to a postresql database with osm2pgrouting?
1
vote
2answers
188 views
Turn-by-turn direction using PgRouting
How can I generate turn-by-turn directions using PgRouting?
At the moment, I have a web-page where a user can enter and start/end location and a route is generated on a map (using PgRouting and ...
1
vote
1answer
95 views
Do vertex IDs stay the same every time I run osm2po?
Does anybody knows if vertex (source, target columns) in osm2po tables are always the same?
I have my dr_2po_4pgr table with routing data and dr_matrix with routes already made. In this table I have ...
2
votes
0answers
112 views
From pgRouting shortest_path back to osm node id
I'm successfully performing path finding queries like shortest_path on data imported with osm2pgrouting.
The tables I have inside my pgrouting DB are the following:
List of relations
...
3
votes
2answers
126 views
Multiple queries in a row
I have osm data imported into PostgreSQL with osm2po tool (wich makes the data routable). Also I have imported data relationed with nodes and node_tags with osmosis tool.
I need to obtain a set of ...
1
vote
1answer
146 views
How to control what kind of tags / flags are imported with osm2po?
With the help of osm2po, I have successfully inserted the contents of the italian files (italy.osm.pbf) in a pgrouting-enabled database (postgresql 8.4)
It displays fine in Qgis, using rule based ...
9
votes
3answers
354 views
How to add offsets to the route?
Edited:
I want to ilustrate my question. Suppose that you're in "Point A" and want to go to "Point B". This points wouldn't be in "at_2po_4pgr" table cause aren't source/targets nodes.
Then, I ...
2
votes
0answers
92 views
Create a consistent topology using pgrouting
I'm developing an application that needs routing information for certain cities. First, I downloaded a openstreetmap datafile (*.osm) and then I imported it into a postgreSQL database using ...
1
vote
1answer
243 views
PgRouting: Driving_distance() or shootingstar_sp()?
I use OSM data imported into PgRouting database.
I developped a web application with a map to use OSM data.
I trace routes using shooting_star_sp() function.
For example, to have time cost between ...
0
votes
0answers
24 views
why there are links in streets table on navteq with zero value in the FEAT_ID field?
I have too many links with FEAT_ID = 0. Those links are transitable ways, but in the navteqs tables the associate FEAT_ID value is 0. Also, the street name and other fields are in 0.
What does this ...
2
votes
1answer
90 views
Is there a way to show the direction of a route?
I use pgrouting and openstreetmaps .I would like to know if there is a way to show the direction of the route on the map (eg something like this ---->---- or any other way,idea)
Thanks in advance.
2
votes
1answer
73 views
Relevant data for cost attribute to calculate route time
I have imported OSM data into PgRouting database.
I would like to use driving_distance() function to calculate route time.
How to add relevant time cost into database ?
Thanks
2
votes
2answers
112 views
What is geom_way column in osm2po generated data?
Could anybody tell me the meaning of geom_way column generated by osm2po?
3
votes
1answer
486 views
How to get started with pgRouting and OSM?
I have followed these instructions to install postgresql and pgrouting on our ubuntu server:
...
4
votes
1answer
187 views
estimate travelling time for the route using pgRouting and OSM data
Could someone share with me some ideas or your experience how to estimate travelling time based on the provided route within pgRouting? The problem is that roads inside and outside cities have the ...
1
vote
1answer
157 views
Returning gps points in the form of gpx files in pgrouting
I am trying to create a service that returns the shortest path for a given start and end destination. What I did was used shortest path query provided by pgrouting to calculate the vertex and edges ...
1
vote
1answer
102 views
Generate source_id and target_ id for every segment in a multilinestring geometry (PostGIS|PgRouting)
I am working on a project that requires finding the shortest path and to achieve this, I've used the PgRouting dijkstra function and it's all worked out perfectly.
Initially, the road network was ...
1
vote
1answer
249 views
How to get travel time and link used from osm2po http service
I used osm2po to get shortest paths but I would like to get travel time and osm links ids used in the path. Is it possible?
Here is the osm2po service url format I use (this is an example):
...
1
vote
2answers
311 views
How to restart an osm2po service from a previous run?
I have followed underdark's clear and concise "how to" to get osm2po running. The web service is a great little tool for inspecting the data. Is there a way to restart the service using an existing ...
4
votes
3answers
1k views
How to make routable OSM map
I have some routable data for testing my pgRouting functions, and everything is fine. Now I have to download some more countries from OSM. I downloaded Germany shape files, but OSM maps are not ...
3
votes
2answers
447 views
How to route between lat/lon pairs in pgRouting?
I have set up Postgresql, PostGIS and pgrouting on Ubuntu.
I have imported an osm for wales using the following command:
./osm2pgrouting -file wales.osm \
-conf ...
3
votes
1answer
303 views
Using OSM data, pgRouting, and dummy data to develop an origin/destination travel matrix
Further to my previous question I was wondering if it is possible to add dummy node data without to do routing analysis.
ISSUE
I have a polygon layer that represents zonal attributes
I created a ...
5
votes
2answers
417 views
How to fix pgRouting error “starting vertex not found”?
I've posted on here before about my battles with drivetime polygons and got some sensible suggestions back, so having Googled myself stupid over this I'm turning to you once again in the hope of a ...
4
votes
2answers
275 views
Why is osm2pgrouting not importing?
I installed pgrouting successfully and did a little import with a 20Mb file. Works good!
Now I'm trying to import a file with the size of a country and it doesn't even start to import. The last 2 ...
5
votes
1answer
518 views
Split edges at intersections in PostGIS
I'm attempting to do a walking distance analysis using OpenStreetMap data (osm2pgrouting) and PostGIS and following underdark's blog posts, however I need to exclude residential and service roads that ...
2
votes
1answer
581 views
troubles with osm2pgrouting
I'm trying desperately to write my first query in pgRouting using maps in osm format (as shown in http://www.carsonfarmer.com/?p=799).
Im using Ubuntu 10.10 with Postgresql 8.4 ang postgis 1.5.
After ...
6
votes
1answer
415 views
demo maps for training pgRouting
I'm very new to postgis and pgRouting but I'm using it for my thesys.
I need any map to train my self with routing and TSP problems in pgRouting, but on the Internet I found unworking links only!
Can ...
0
votes
2answers
231 views
Installing TSP functionality on win7
I'm very new to pgRouting!
I installed PostgreSQL 8.4, and pgrouting 1.03 on win7.
I need to solve a TSP problem so I was trying to install the TSL functionality as showen at:
...
7
votes
1answer
947 views
What are the advantages of pgSQL+PostGIS+pgRouting over a simple MySQL+handwritten routing algorithms?
Goal:
To have a routable set of roads in a database and to have a software that can calculate the shortest path (e.g. simple Dijkstra) through this set in a reasonable amount of time (up to 2 ...
1
vote
2answers
310 views
How can I calculate the amount of memory required to run osm2pgrouting?
I have read that osm2pgrouting loads all the data into memory, which makes it faster.
On the other side the size of the .osm file which it can parse is limited.
How can I exactly know how much ...
30
votes
7answers
5k views
Creating drive time polygons using open source tools
Is anyone using open source tools and/or data to generate drive time polygons that radiate out from a given location? For example, I have used ESRI products like Network Analyst and Business Analyst ...
