Mercurial > gemma

comparison schema/isrs_functions.sql @ 2486:bca9a7a89f28 octree-diff

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into octree-diff branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 01 Mar 2019 18:28:50 +0100
parents 7677a2850a2d
children 54c9fe587fe6
comparison
equal deleted inserted replaced
2485:86173ac7f222 2486:bca9a7a89f28
64 ST_LineMerge(ST_Collect(ARRAY( 64 ST_LineMerge(ST_Collect(ARRAY(
65 -- Linestring build up so far 65 -- Linestring build up so far
66 SELECT refgeom 66 SELECT refgeom
67 UNION 67 UNION
68 -- Fill eventual gap 68 -- Fill eventual gap
69 SELECT ST_MakeLine( 69 SELECT ST_ShortestLine(
70 ST_ClosestPoint( 70 ST_Boundary(refgeom), ST_Boundary(geom))
71 ST_Boundary(refgeom), ST_Boundary(geom)),
72 ST_ClosestPoint(
73 ST_Boundary(geom), ST_Boundary(refgeom)))
74 UNION 71 UNION
75 -- Linestring to be added 72 -- Linestring to be added
76 SELECT geom))) 73 SELECT geom)))
77 FROM axis_snapped AS axis_snapped (refids, refgeom), 74 FROM axis_snapped AS axis_snapped (refids, refgeom),
78 axis AS axis (id, geom), 75 axis AS axis (id, geom),