2,507 reputation
614
bio website georepublic.info
location Osaka-shi, Japan
age
visits member for 4 years, 4 months
seen 14 hours ago

Working for Georepublic UG & Georepublic Japan


Jan
19
comment Find closest points in routing network for a set of points to pick shortest route
You want to do this with a single query? I think it's easier to write a custom function. You can find an example in the pgRouting workshop: workshop.pgrouting.org/chapters/…
Jan
9
comment How to find routes between for each entry in a list of point pairs?
Maybe better for understanding: the core functions only use the required attributes, because every network data table may have different attributes. And line geometry is actually not necessary for a Dijkstra shortest path.
Jan
9
comment How to find routes between for each entry in a list of point pairs?
Correct. The "core" functions only return the path result as a list of edges. But you can join your result with the original table. Then you have access to all the attributes again, also the line geometry: workshop.pgrouting.org/chapters/…
Jan
9
comment instal pgrouting on postgres 9.3 + postgis 2.1
I tried it and also got this error. But it's a problem with UbuntuGIS PPA, not the pgRouting PPA.
Jan
9
revised UbuntuGIS packages on ppa.launchpad
changed title and tags
Jan
9
comment UbuntuGIS packages on ppa.launchpad
This has nothing to do with the pgRouting PPA. As the error message says, the UbuntuGIS PPA can't be fetched.
Jan
9
revised UbuntuGIS packages on ppa.launchpad
formatting
Jan
8
answered How to find routes between for each entry in a list of point pairs?
Jan
8
comment instal pgrouting on postgres 9.3 + postgis 2.1
I can only speak for the Ubuntu PPA for pgRouting, because I maintain it, and there is no problem. Unfortunately I have no knowledge about the Debian package and who manages it.
Jan
7
revised instal pgrouting on postgres 9.3 + postgis 2.1
code syntax
Jan
7
comment instal pgrouting on postgres 9.3 + postgis 2.1
Where did you get the pgRouting Debian package from? Is it in the official Debian repository?
Dec
18
answered Learning pg_routing - shortest_path error
Dec
17
answered How to get the closest point from a table in PostGIS?
Dec
17
answered pgrouting - network distance many-to-one shortest paths
Dec
11
comment Error of doing pgr_analyzeGraph
Could you also post your query?
Dec
11
revised Error of doing pgr_analyzeGraph
remove unnecessary tags, make the code readable
Nov
23
answered pgrouting with wms
Nov
21
reviewed Approve How to narrow raster features to single cell width?
Nov
21
answered calculate route in road network
Nov
17
comment How to create a Network Topology in a shapefile that contains only nodes(geometry points)?
You need to know how points are connected to each other, how their relation is to each other. Otherwise routing will not work.