0
votes
2answers
208 views

How to create a new column to store the length of a linestring in postgis?

I am working with pgRouting, following this nice guide:A Beginner’s Guide to pgRouting I am now in this step:Calculating shortest routes, with these codes below SELECT * FROM shortest_path(' SELECT ...
6
votes
1answer
2k views

How to measure length of line accurately?

In postgis 1.5 for the below given query the answer is 1540651.62674101 meters , SELECT ST_Length(ST_GeomFromText('LINESTRING(77.83042478941326 9.98463896136159,78.03469506809812 23.90398909552571 ...