All Questions
Tagged with openstreetmap pgrouting
106 questions
1
vote
0
answers
25
views
Does osm2po take into consideration one-ways, bridges, tunnels, underpasses and overpasses? [closed]
I've started with osm and pgrouting recently, and found osm2po to be a great tool, however I can't find any information about how it processes osm data. I use pgr_dijkstra to create a route and use ...
1
vote
0
answers
82
views
pgr_nodeNetwork doesnt put nodes on every intersection
I used the osmnx python package to get OSM roads network.
I intended to use pgr_createTopology to have a correct network in order to use other pgrounting functions.
However my data from osm is not ...
- 136
1
vote
1
answer
364
views
After pgr_createTopology, how should I use pgr_dijkstra?
Using the OpenStreetMap data and osm2pgsql, I created a topology by using the pgr_createTopology() function. These tables are what I have:
List of relations
Schema | ...
- 121
2
votes
1
answer
282
views
pgRouting ways table attributes description
I've imported an extract of OSM data for my region of interest to Postgresql using osm2pgrouting 2.3.6 in Linux, using mapconfig_for_cars.xml configuration file, and I've found that it created tables ...
- 306
1
vote
0
answers
220
views
Finding nearest POIs by travel time(not distance) given current location and travel method
A user can choose between walking, bicycling, public transit, or driving for X minutes. Their current location is a latitude and longitude pair given by the HTML5 Geolocation API(wgs84). The (roughly ...
- 111
2
votes
1
answer
708
views
Walking distance with pgrouting for several locations
I'm intending to calculate the walking distance (not the linear distance, but the "real travelled distance") to several locations (e.g. social infrastructure). Thus I will have to create a routable ...
- 23
1
vote
2
answers
174
views
Ring geometries in pgRouting OSM DUMP
After performing pgRouting's "pgr_analyzeGraph" algorithm, over an Open Street Map dump uploaded to my PostGIS DB, I get this output, by I can't figure out what "ring geometries" are. Does somebod ...
2
votes
1
answer
208
views
finding isolated rings in postgis
I want to find the isolated rings in an OSM dump loaded into PostGIS, using pgRouting. I need to do this in order to delete the isolated rings of the network. Does anyone know how to do it?
0
votes
1
answer
70
views
Ambiguous values on OSM to calculate optimal path: Which value should I use?
I'm using San Francisco OSM dataset, I want to calculate the optimal path using pgrouting(pgr_astar)
The problem that I don't know which column should I use?
For example:
I want to calculate the ...
- 59
0
votes
1
answer
144
views
OSM database and congested roads
I'm using San Francisco OSM database, which contains the name of each edge, the id source and id target of each vertex.
I need to use the information of the most congested routes in San Francisco, but ...
- 59
1
vote
1
answer
230
views
pgrouting OSM data with tolls
Is there any way to import the OSM data into pgRouting with the toll data?
I already have a database with OSM data with topology, and working with pgRouting, but I need to add some nodes to it.
I ...
- 1,073
0
votes
2
answers
247
views
Routable streets database
I'm trying to find the most "affordable" way to have a routable database, and I'm having some questions that maybe some of you can clarify.
My aim is to store all data in our server (not external ...
- 1,073
2
votes
2
answers
235
views
Dead-ends are connected by osm2pgrouting
I've downloaded an extent of OSM data with QGIS's OpenStreetMap downloader, and want to use this data for with pgRouting. I can load it without problems as:
osm2pgrouting --f data.osm --conf ...
- 51
1
vote
1
answer
1k
views
pgrouting with oneway
I have a road network data where roads(edges) are specified with 3 values to identify the category of road(one way).
Road with value 0 can be routed in both direction.
Road with value 1 can be ...
- 247
1
vote
0
answers
44
views
Getting base GIS files for use with pgRouting library
I'm just starting to read the tutorial for pgRouting and the first issue that troubles me is the origin of the "base map" to feed pgRouting with. I'm aware that there's available a tool called ...
- 157
0
votes
0
answers
95
views
Forcing driving direction using edited OSM shapefile and pgRouting
I need to edit a shapefile from OSM in QGIS. I want to use pgRouting to find a route, where it uses a forced driving direction. The algorithm may use the same edge however to calculate the route ...
- 317
3
votes
0
answers
300
views
Weird (longer) route from using cost_s as cost in pgRouting?
I am currently developing application that want to use the fastest time to arrive as parameter for the routing. And i know that pgRouting has 'cost_s' column which calculated from length_m and ...
2
votes
0
answers
455
views
Importing OSM data to pgRouting enabled database including turn restrictions
I recently used the tool pypgroutingloader to import OSM data into a pgRouting database. For a small amount of data, this tool works perfectly. Most routing restrictions are present and it modifies ...
2
votes
0
answers
88
views
Routing for specific subjects (cars, pedestrians, ..) dynamically
I need create app which will be provide routing for specific category. For example only for cars, only for bikes or only for pedestrians. For importing OSM data I'll used default mapconfig for all way ...
- 699
2
votes
0
answers
40
views
Osm2pgrouting - edit final route
I've imported my data to database by osm2pgrouting. This tool created network topology which contains vertices and edges between them. Problem is when I need get route to specific point which is not ...
- 699
3
votes
2
answers
917
views
Correct routing on osm2po table
What is the best way to use routing table generated by osm2po? When I apply osm2po on my *.osm.pbf file, the generated table looks like this:
Here is my routing script:
SELECT d.seq, d.path_seq, d....
- 699
5
votes
0
answers
172
views
pgr_drivingdistance seems to be excluding nodes that should fall within the cost parameters set
I am getting a result that I don't understand and I am not sure if its my lack of understanding of OSM.
I am using the pgrouting functions pgr_drivingdistance to get the list nodes reachable within ...
- 161
2
votes
1
answer
701
views
How to display proper route for OSM data using pgRouting
I am facing a problem while displaying routes using OSM data and pgRouting. I have followed the following procedure:
downloaded OSM data
made it routable using osm2pgrouting
taking point coordinates ...
- 121
2
votes
1
answer
371
views
How can I get the length of segments from the output of pgr_dijkstra?
I created a topology from OSM data with osm2pgrouting.
I use a very simple Query
SELECT * FROM pgr_dijkstra('
SELECT gid AS id,
source,
target,
cost_s AS cost,
...
- 3,440
2
votes
0
answers
94
views
Some PostGIS functions explanations [closed]
I'm trying to optimize a route SQL function and playing with some ST_* functions I found around.
But even found a good one, I don't want to simply copy/paste what someone wrote. I want to understand ...
- 2,190
1
vote
1
answer
2k
views
Shortest path postgis query with in a bounding box
I have been following this article to find shortest path in vector data. I can already find shortest path between 2 OSM nodes using Dijkstra algorithm in pgrouting. My working query is as below:
...
- 113
1
vote
3
answers
749
views
Routing network from database created by osm2pgsql
I created my PostGIS database by osm2pgsql tool and now I want create network suitable for routing. (I could not use directly osm2pgrouting because I need street names e.g. and so on).
For this ...
- 133
2
votes
1
answer
349
views
pgRouting from geocoded user input
have created database by tool osm2pgrouting. On my website can user enter start and end point.
How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables ...
- 133
2
votes
0
answers
169
views
Exported OSM database do not contains node names
I've used osm2pgrouting tool to export data from osm file to my postgresql database. Now I have database with this schema:
osm_node:
-node_id
-osm_id
-lon
-lat
-numofuse
-the_geom
...
- 49
2
votes
2
answers
1k
views
Using OpenStreetMap for routing in GeoServer?
I am new in OSM but now I need create application which will use GIS (Geoserver) and will be provide service to get road from point A to point B.
I found some informations about this but I still have ...
- 21
0
votes
1
answer
274
views
How to quick-fix drive time in residential area with Osm2PgRouting?
I'm currently testing pgRouting using OpenStreempMap XML dataset loaded via Osm2PgRouting. My goal is to solve shortest path problems using time driven costs instead of path length.
I noticed that ...
- 1,250
2
votes
0
answers
66
views
Inaccurate Result from using QGIS contour function on pgr_driving distance
I was wondering whether anybody else has experienced a similar problem when using the contour function in QGIS.
I've run PGRouting's pgr_drivingdistance function on some osm data, and applied the ...
- 41
1
vote
0
answers
138
views
London highways missing in OSM Data
I'm working with London OSM data (roads) with PostGIS and pgRouting.
After download the pbf file from Geofabrik and create the topology with osm2po, I've realized that some highways in London are ...
- 1,073
1
vote
0
answers
182
views
Output shortest route shapefile using pgRouting and JSON data
I'm interested in finding the shortest route between two sets of bike share stations (22/21 stations each) in the city of Glasgow. Note, I need to overlay the final shapefile onto an OSM basemap in ...
- 307
1
vote
2
answers
354
views
May I use OSM in pgRouting to determine TSP solution?
I have a TSP problem that I'd to determine if my solution path is correct. As stated, a classic TSP, I have a number of locations (bikeshare stations) within a city centre (Glasgow, Scotland) that I'd ...
- 307
0
votes
2
answers
102
views
Creating Drive Time Polygons Across State Boundaries Using OSM?
I am using pgRouting on OpenStreetMaps to create drive time polygons. The challenge is that at state boundaries, these polygons effectively stop, since the roads in OSM are segmented at the state ...
- 61
0
votes
1
answer
216
views
Will a basic pgRouting/OSM data setup allow me to calculate travel-times?
I have a PostGIS database and I need to figure out a quick (in terms of setup) way of calculating the travel-time between points corresponding to geocoded addresses taking into account the route and ...
1
vote
1
answer
643
views
Referencing variables inside ST_Distance_Sphere function
I trying to create an UPDATE function that will ultimately return straight-line distance to the nearest node on an OSM network (which will be later added to pgrouting distances I have already ...
- 11
1
vote
2
answers
861
views
pgrouting tsp (travelling salesman problem) performance
I currently use a web API to solve TSP tasks. However my provider limits the query to a maximum of 150 stops. I therefore consider to host my own routing service based on OSM data and pgrouting. My ...
- 291
2
votes
0
answers
194
views
How to quickly get coverage of multiple services at once using pgrouting driving distance
I'm trying to get some useful information out of openstreetmap data to choose where to rent an apartment in my city.
I used osm2pgrouting and osm2pgsql to get OSM data into my postgis database.
So far ...
- 447
1
vote
1
answer
164
views
Retrieving the data from PgRouting
Currently i have created the layer in Geoserver by configuring a native SQL statement, there i am getting the route geometry details from DB by following query
SELECT ST_MakeLine(route.geom) FROM (...
- 133
4
votes
0
answers
116
views
QGIS Contours plugin [closed]
I managed to load osm-data with osm2po, pgrouting, postgis and postgresql into qgis.
Then I did a drivingdistance analysis based on cost to finally get the qgis contours plugin up and running.
But ...
- 51
0
votes
1
answer
835
views
Pedestrian routing using pgRouting
I'm new to pgRouting and I want to implement a pedestrian routing system. I've already implemented a routing system using pgRouting, PostGIS, GeoServer, OSM data and OpenLayers 3 and it uses Dijkstra ...
0
votes
2
answers
603
views
Incomplete data - lines missing from osm2pgrouting
I am importing OSM data into PostGIS using osm2pgrouting but some data is missing/did not import. I am using the default mapconfig.xml and this appears to work for most roads.
For example in below ...
- 1
1
vote
1
answer
246
views
A few PgRouting database design questions
Does someone know how the cost field in PgRouting is calculated?
What are 'source' and 'target' good for? 'osm_source_id' and 'osm_target_id' contain the same information using different numbers.
Is ...
user54586
1
vote
1
answer
457
views
How to check if a node is in route computed with pgRouting?
I'm new to the GIS system and I'm following the pgRouting workshop.
I've imported the locations of nodes (points, highway=street_lamp) using osm2pgsql.
now I'm calculating a few paths between two ...
- 175
0
votes
1
answer
175
views
Add columns with information OSM by osm2po?
I imported the europa.osm network within my spatial database using the osm2po tool. I use this with pgrouting.
How can I know the information provided by the tag address (city, country, etc) and not ...
- 111
1
vote
1
answer
90
views
PgRouting Obtain RoadNetwork data from osm file
I am trying to obtain road-network data from OSM file using pgrouting and for this I am following this tutorial:
http://workshop.pgrouting.org/
The format I am looking for is following(bidirectional)...
- 307
0
votes
0
answers
104
views
Densifying OpenStreetMap (OSM) network nodes?
I am working with osmconverter to convert osm files(*.osm) to *.pbf, then i use osm2po to get sql file that run into PostGis to get a network table.
The last step is to run a createTopology ...
- 197
1
vote
3
answers
2k
views
Getting route segments from OSM data and assigning ETA for them
I have a problem of assigning possible ETA for a route.
So far, I have the following:
OSM data for a city.
I have open source data of taxi trails for the same city.
Now, I am planning to divide the ...
- 187