Tag Info

Hot answers tagged


The "Topology" chapter of the workshop is there to explain the basics about the routing network. The first paragraph should actually explain that. If it's not so clear, then I will change this with the next version of the workshop. But if you import OSM data you just use an import tool named "osm2pgrouting", which is explained in detail a few chapters ...


In order to do this, your table must contain two coordinates, one for each end of the connection. If you have this, you can do a join on the coordinates to match up endpoints and assign them matching ids. For example, imagine you have a table with the following definition: create table foo (from_x float, from_y float, to_x float, to_y float); Then add ...


You have two issues mixed. First: pgRoute, uses precreated topology based on LineString geometry. Such geometry doesn't have direct links on osm Nodes. You could get geospatial points for built route, not osm Nodes. To get Nodes, you could build an index among osm Nodes geometries and perform distance lookup. In other words, select all nodes which are not ...


You need to use osm2psql for example, if you want to import data, that is not (road) network data. osm2pgrouting only handles linestring geometries and will not work with point data.


If you want to extract the few addr:* tags attached to streets, the current version might help. But you'll need Java to overwrite some standard behavior. Implement your own WayTagResolver or extend the Default one. There is a "meta"-attibute which can be populated withr custom data. Nevertheless, GeoCoding is one of the next steps I'm going to implement. One ...


The search term you need is "isochrone". A web search should reveal techniques for creating your 30-minute (or 60-minute, or whatever) boundary. With that, it's a simple intersection problem to find the contained points.


You get this error when there are no results, so the query returns 0 records, and row[0] does not exist. Using another postgres query method you can avoid this error: $result = pg_exec($dbconn, $query); $numrows = pg_numrows($result); // Loop through rows in the result set for($i = 0; $i < $numrows; $i++) { $row = pg_fetch_array($result, $i); ...

Only top voted, non community-wiki answers of a minimum length are eligible