Hi,

Sounds doable but a bit complicated. It woud be easier for me to use PostGIS 
and pgrouting, but I updated my database and there in not yet Windows extension 
for PostgreSQL 9.2 and PostGIS 2.1. It seems to be coming, though 
http://www.pledgebank.com/pgRoutingWindows

Routing with Spatialite is very fast and I have been able to visualize the 
route with OpenJUMP by copy-pasting the route from Spatialite-gui as WKT.  
Integration would be rather good if the OpenJUMP Spatialite Reader plugin would 
work. Unfortunately there is something broken nowadays.
http://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=OpenJUMP_with_SpatialLite#Using_SpatiaLite_with_Spatialite_Reader_Plugin

If the plugin worked we could send route requests directly with SQL
SELECT * from way_net where FromNode=x and ToNode=y
and see the result in OpenJUMP as a new layer.

-Jukka-



________________________________________
Michaël Michaud wrote:

> Interesting,

> Now I see the point :
> Planar graph and Noder are both missing something

> It would not be too hard to compute links between roads
> and the graph nodes by program but it is not so easy
> with OJ tools only.

> I think it is possible though :
> - Create road network with unique ids
> - Create unique nodes with planar graph
> - Create initial nodes with extract point and select sequence-id=0
> - Create final nodes the way but after a reverse lines operation
> - Do the joins between nodes and initial/final nodes to transfer node ids
> - Do the joins between initial/final nodes and roads to transfer node ids

> For each step, I think there are several ways to go except the last
> one where you may have to use matching plugin which can match
> features using only an attribute (road id, which must be a string
> to be a valid candidate for the matching tool)

> There maybe some pitfalls I did not see though,

> Michaël
>> Hi,
>>
>> I want todo this with OpenJUMP and Spatialite
>> http://www.gaia-gis.it/spatialite-2.4.0/Using-Routing.pdf
>> http://www.gaia-gis.it/spatialite-2.4.0-4/spatialite-cookbook/html/dijkstra.html
>>
>> Spatialite has a tool called spatialite_osm_net which makes a graph from 
>> OpenStreetMap data but I want to use a road data as input.  Therefore I am 
>> creating edges with OpenJUMP. However, for routing it would be nice to 
>> transfer road names from the shapefile roads to graph edges like 
>> spatialite_osm_net does.
>>
>> -Jukka-
>
>> Michaël Michaud wrote:
>>
>>> Hi
>>> Let me know what is the use case.
>>> Currently, attribute transfert to faces is a costly post-process
>>> (included in PlanarGraph plugin but not in Planar Graph calculation) and
>>> it works only if there is a 1 to 1 relation between polygons and faces.
>>> Is your use-case a network ? A map with surfaces + linestrings ?
>>> Other way to get a clean graph with attributes maybe
>>> - to use noder
>>> - to post-process planargraph  result with matching extension (just
>>> uploaded the last version)
>>> Michaël
>>> Hi,
>>
>>>> The planar graph does not create new layer for transferred attributes if 
>>>> the Create faces option is not set.
>>>> It might also be better to add the attributes into the Egde layer instead 
>>>> of creating a separate Transfer layer.
>>
>>>> -Jukka Rahkonen-

------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester  
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the  
endpoint security space. For insight on selecting the right partner to 
tackle endpoint security challenges, access the full report. 
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Reply via email to