Tag Info

Hot answers tagged

2

This is a memory allocation problem. Your source and target nodes have high id's and PgRouting tries to allocate the memory based on the highest node id it can find, even if there is only a few edges and nodes in the graph. Dijkstra, drivingDistance and other functions have the same problem. IMHO this is a real problem since you can't select a subgraph ...


2

I think you don't need to set the BOX3D, instead use the following approach. But keep in mind that the 0.00012 is a bit crucial, you have to select it carefully. Don't insert 0 instead as I have noticed some abnormal behavior in the past. Plus, if your CRS is in ESPG:3857 then you have to defined this buffer value not in degrees but meters. with line as ...


2

The answer of @underdark was close, but does not work, because the destination ID's must be passed as an array. Here is the same example of the workshop using queries instead of passing the ID's directly. SELECT seq, id1 AS source, id2 AS target, cost FROM pgr_kdijkstraCost( 'SELECT id, source, target, cost FROM edge_table WHERE cost >= 0', ...


1

You're using an outdated tutorial with the new pgRouting 2.0 release, I guess. As the error states, it cannot find the function, because the function has been renamed. I recommend you to look at the pgRouting Workshop. The pgRouting documentation also gives brief examples for every function.


1

You could try something like this SELECT seq, id1 AS source, id2 AS target, cost FROM pgr_kdijkstraCost( 'SELECT id, source, target, cost FROM edge_table WHERE cost >= 0', (select nodeid FROM origins), (select nodeid FROM destinations), false, false) not tested, might be with or without brackets.


1

You need to give more details, how you're using WMS. If you are referring to the pgRouting workshop Geoserver chapter, then you could do the following modification to the SQL query to return also the length as attribute: SELECT ST_MakeLine(route.geom) AS geom, sum(route.l) AS length FROM ( SELECT geom, ST_Length(geom) AS l FROM pgr_fromAtoB('ways',%x1%, ...


1

There is a free REST API for this Simply POST GeoJson Data to an endpoint, and view the POI in Augmented Reality browsers(wikitude) , google earth, google maps or any GPX(track and route), KML, ARML supported app in real time. https://www.mashape.com/geokoala/geokoala/overview Just create an AppKey, and check out the code samples in ...



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