Skip to main content
6 events
when toggle format what by license comment
Sep 12, 2019 at 13:48 answer added robin loche timeline score: 1
Sep 12, 2019 at 9:36 comment added geozelot as an addition to the sinuosity; you should be able to use ST_SetEffectiveArea to derive statistics about a lines per-vertex curvature; it's a common simplification method, but it's values can be used to measure curvature properties.
Sep 12, 2019 at 8:19 comment added Babel And still another approach, depending on how detailed your data is: simply count the number of vertices (per distance): a straight-line section will contain much less vertices than a curved road. For other solutions, google for sinuosity and the tool you want to use (i.e. PostGIS/PostgreSQL)
Sep 12, 2019 at 8:12 comment added Babel I don't have a solution, but maybe an idea to build on if you would also be willing to work with QGIS: you could try to measure angles at each vertex with the expression-editor and the angle_at_vertex function. You could add all the values (be aware how to deal with positive and negative values) and relate the result to the total length. Like this you get a measure for the sinuosity of the road. Of course, you could simple calculate the proportion of total road-length to the length of a straight line from the beginning to the end (first to last vertex) of your line.
Sep 12, 2019 at 8:12 comment added Bera You could compare line length to euclidian distance from startpoint to endpoint. But that might be over simplifying it
Sep 12, 2019 at 7:40 history asked DavidP CC BY-SA 4.0