[postgis-users] help plz

[Pedro Doria Meunier]

Hi Lavanya,

 

You could consider using pgRouting (http://www.postlbs.org/) .

This extension to Postgres/PostGIS needs some topology and topology support
for PostGIS is still in its infancy and barely documented
 L

 

Now to implement ‘topology’ the *easy* way
 ;-)

Use OpenJump! (http://openjump.org)

There’s a tool there called ‘Planar Graph’


You can use it to get every line segment documented (start and end nodes for
each line).

Add a ‘length’ field to your dataset.

OpenJump also has a tool to calculate areas and lengths
 ;-)

 

Save your dataset from OpenJump into PostGIS.

The ‘length’ field acts as an initial cost for turning
.

 

Then use the shortest_path() function from pgRouting and you’re on your way!

 

Also heard from the developers of pgRouting that support for turn
restrictions is somewhere in the near future
 ;-)

 

(OJ Peopleà I’m posting this to the list as I think it’s useful ;-) )

 

HTH,

Pedro Doria Meunier

 

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Lavanya
A
Sent: segunda-feira, 19 de Fevereiro de 2007 13:42
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] help plz

 

Hi,

 

Jus need few help from u...im currently using postgres 8.2 and PostGIS
1.2.1..

 

I have few shapefile, especially roads..which im working on it..

 

I need to find the route between two points, namely a latitude and longitude
to a place of interest. I thought i should network analysis. But not sure of
what to use and how to achieve my goal.

 

Can u suggest me wat tool should i use and any special query will do using
postgres? Please i seek ur suggestion

 

Regards

Lavanya A

 

 

 

 

  

  _____  

Here’s a new way to find what you're looking for - Yahoo!
<http://us.rd.yahoo.com/mail/in/yanswers/*http:/in.answers.yahoo.com/>
Answers 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070219/441e1b85/attachment.html>