New answers tagged linestring
I've written a function for PostGIS which uses linear referencing functions to redistribute vertices for [Multi]LineString and [Multi]Polygon geometries. For PostGIS 2.0 and earlier, ST_LineInterpolatePoint needs to be renamed to ST_Line_Interpolate_Point. CREATE OR REPLACE FUNCTION ST_RedistributeVertices(geom geometry, distance double precision) RETURNS ...
I am not very exerienced, but I would try function geometry ST_MakePolygon(geometry outerlinestring, geometry interiorlinestrings);
The z-value is not supported in QGIS. Removing the z-value and changing WKT to LINESTRING makes the SQL load in QGIS. select geomFromText('LINESTRING(13.091464 47.061328, 13.092059 47.061287)') as geometry Why do you want the two z-values 2597 and 2580 into QGIS?
I had the same problem, and this is my solution. When you create the topology for pgRouting, you establish a tolerance for connect the lines, which it means that all the lines not necessarily touch each other. Having this in mind you can use a simply ST_LineMerge command if you use ST_SnapToGrid to the tolerance that you established earlier in the topology ...
Top 50 recent answers are included