Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ST_INTRSECTION(ST_COLLECTIONEXTRACT(A.GEOM1,2)::geometry(MULTILINESTRING, 4326),B.GEOM) FROM (select GEOM1 FROM public.boundary) AS A, (select GEOM FROM catatlog.multilinestring) AS B WHERE ST_INTERSECT(B.GEOM, A.GEOM1)
Add Comment
Please, Sign In to add comment