/* for each geometry in the dh_lue table insert its shapepoints into dh_lup table! */withrecursivepoints_per_element(id,numpoints,points)as(selectid,numgeometries(dissolvepoints(GeomWGS84)),dissolvepoints(GeomWGS84)fromclip.dh_lue),rows_dh_lup(n,element,x,y)as(select1,id,x(geometryn(points,1)),y(geometryn(points,1))frompoints_per_elementunionallselectr.n+1,p.id,x(geometryn(p.points,r.n+1)),y(geometryn(p.points,r.n+1))fromrows_dh_lupr,points_per_elementpwherer.element=p.idandr.n<p.numpoints)insertintoclip.dh_lup(element,x,y,heightlevel)selectelement,cast(xasinteger),cast(yasinteger),0fromrows_dh_lup;
Comments (0)
HTTPSSSH
You can clone a snippet to your computer for local editing.
Learn more.