[postgis-users] Preparing for Topology - St_CreateTopoGeo

[Chris English]

strk,

I think that's the next, next step, first I have to figure out the final updateof my topo tables and the topology documentation has left me head scratching, i.e. the topology.CreateTopoGeom stage:select edge_id, start_node, end_node, next_left_edge, abs_next_left_edge, next_right_edge, 
abs_next_right_edge, left_face, geom from union_cty_topo.edge_data limit 1;20952;271096;271075;20954;20954;-20953;20953;0;"01020000200B7D00000200000060C7D31DEF042041807D82545CA72441C087CB2AB504204140C7FC7E07AA2441"select face_id, mbr from union_cty_topo.face limit 2;0;""7447;"01030000200B7D00000100000005000000C087CB2AB5042041807D82545CA72441C087CB2AB5042041C0E1276882AC2441E06B43906F082041C0E1276882AC2441E06B43906F082041807D82545CA72441C087CB2AB5042041807D82545CA72441"select node_id, containing_face, geom from union_cty_topo.node limit 1;271075;;"01010000200B7D0000C087CB2AB504204140C7FC7E07AA2441"select topogeo_id, layer_id, element_id,element_type from union_cty_topo.relation limit 1;<no data>select gid, pams_pin, cost, topo  from union_cty_topo.summit_parcels limit 1;<no data>So I take the fact that I don't have node_id.containing_face, and no data in eitherrelation or summit_parcels as my failure to understand this final step of CreateTopoGeom

update union_cty_topo.summit_parcels as sp   -- sp is  summit_parcels
    set topo = topology.createtopoGeom('union_cty_topo',
            3,1
            , foo.sfaces)
from (Select s.gid, topology.TopoElementaryArray_Agg(Array[f.face.id,3]) as sfaces
        From union_cty_topo.summit_parcels as s
            Inner Join union_cty_topo.face as f on s.topo && f.mbr -- a little confusion here 
        where ST_Covers (s.geom, topology.ST_GetFaceGeometry('union_cty_topo', f.face_id))
            Group by s.gid) as foo
Where foo.gid =sp.gid;

ERROR:  schema "f" does not exist

Chris

--switched to firefox from chrome in hopes of better plain text client

> Date: Sat, 3 Dec 2011 09:44:37 +0100
> From: strk at keybit.net
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Preparing for Topology - St_CreateTopoGeo
> 
> On Fri, Dec 02, 2011 at 10:53:16PM -0500, Chris English wrote:
> 
> > SELECT topology.st_createtopogeo('union_cty_topo',ST_Collect(geom))
> > FROM summit_parcels;
> > "Topology union_cty_topo populated"
> 
> Great ! Congratulations !
> Now maybe you would want to try with another subset of the data
> as I think you were trying to isolate a portion of it that triggers
> a bug in ST_CreateTopoGeo, right ?
> 
> --strk; 
> 
>   ,------o-. 
>   |   __/  |    Thank you for PostGIS-2.0 Topology !
>   |  / 2.0 |    http://www.pledgebank.com/postgistopology
>   `-o------'
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111203/537373ed/attachment.html>