[Cartoweb-users] LINESTRING

[Arnaud Lesauvage]

Eggenschwiler Raphael a écrit :
 > > I have datas in LINESTRING format. What is the best way to 
import these
 > > datas in postgis for using pgdijkstra.
 > >
 > > Is it possible to use assign_vertex_id() function on a 
LINESTRING object ?
 > >
 > > And then, can I use create_graph_tables on them ?

Hi Raphael !

There are special functions in pgdijkstra that will work on
MULTILINESTRINGS.
assign_vertex_id() will work on these data types.
There is also a special function update_cost_from_distance() that
will fill the costs for you, if you just need shortest paths based
on distance.

Regards
--
Arnaud