I have two tables, one contains lines (test_line) and the other contains the points at the vertices of the lines (test_line_vertex).
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.
Aucun commentaire:
Enregistrer un commentaire