jeudi 11 décembre 2014

How to split lines with PostGIS and view the result in QGIS?


I have two tables, one contains lines (test_line) and the other contains the points at the vertices of the lines (test_line_vertex). enter image description here


I want to split the line into individual segments based on the vertices. I tried the following query:



CREATE TABLE test_intersect AS
SELECT ST_Split(a.wkb_geometry,b.wkb_geometry)
FROM test_line as a,
test_line_vertex as b;


It returns successfully the rows with the line segments, but when I try to display it in QGIS it shows me that something is wrong. The spatial type is not defined and I can't view the lines in QGIS. So I assume something is wrong with my query. Any help is appreciated.


enter image description here





Aucun commentaire:

Enregistrer un commentaire