1
vote
1answer
22 views

How to split/divide linestrings of larger lengths in postgis

I want to split/divide linestrings in my data. I have roads data and I want to have every road segment having length not more than 250 meter. Check the shape length of this particular line feature. ...
0
votes
1answer
26 views

Postgis add Geography to function()?

i was wondering im getting different results when using geography() on different positions within a query. So, whats the most accurate way of forcing geography() over a functions with geometry ...
3
votes
3answers
223 views

Why is sum of st_length() of segments 20% too big?

I'm running a query to return the total length of some bike paths, from OpenStreetMap. Compared to the known actual length of these paths, they're all a bit too big - something like 10-30%. I know it ...
0
votes
2answers
159 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
670 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
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 ...