Thanks, Nicolas!
Från: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] För Nicolas
Ribot
Skickat: den 20 augusti 2019 09:21
Till: PostGIS Users Discussion
Ämne: Re: [postgis-users] splitting linestrings with a polygon
Hi,
Keep the geometry column as multilinestring, as resulting
Hi,
Keep the geometry column as multilinestring, as resulting splitting can
produce such objects, but add a st_multi after the intersection, on the
update clause:
... SET the_geom = st_multi(ST_Intersection(b.the_geom, p.the_geom))
It will force geometries to be multi, even if it only contains on
Hi, I have a problem with MultiLinestrings/Linestrings.
I have one layer with Linestrings which I would like to split in the
intersections of a polygon (MultiPolygon) in a polygon layer.
I tried this:
UPDATE public."linelayer" b
SET the_geom = ST_Intersection(b.the_geom, p.the_geom)
FROM
