[postgis-users] Topology: How to create topogeometry from existing faces?

Jan Michálek godzilalalala at gmail.com
Mon Apr 17 04:37:44 PDT 2017


I have some edges and centroids with some atributes.
I imported edges to topo using TopoGeo_AddLineString.
And I polygonized toposchema.

I want to create relation with polygons with centroid attribute table.

I can do something like

SELECT centro.*

,
topology.ST_GetFaceGeometry(

   'topo', topology.GetFaceByPoint('topo', geom,
0)
) geom FROM centro;

For obtain face geometry.

But if I want have topogeometry, I need to create normal geometry and
create topogeometry from this.

Is there another way, how to create topogeometry from face id?

I can insert face id into topo.relation and create topogeometry from this
by query, but is it a right way? Can I used some functionality in topology
for doing this.

Thanks Je;

-- 
Jelen
Starší čeledín datovýho chlíva
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170417/d7f1c736/attachment.html>


More information about the postgis-users mailing list