Tagged Questions
0
votes
2answers
58 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 ...
3
votes
3answers
332 views
How to Calculate length of polyline geometry for several tables in PostGIS?
PostGIS database contains several geometry (polyline) tables (with names "D1_r", "D2_r", "D3_r"). I calculate length for one "postgis layer" use request:
SELECT
...
6
votes
1answer
1k 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 ...
