<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
<font class="Apple-style-span" style="text-indent: 0px; color: rgb(0, 0, 0); font-size: 10pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" face="Tahoma" size="2">strk,<br><br>I think that's the next, next step, first I have to figure out the final update</font><div style="text-indent: 0px; color: rgb(0, 0, 0); font-size: 10pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-family: Tahoma; ">of my topo tables and the topology documentation has left me head scratching, i.e. the topology.CreateTopoGeom stage:</div><div style="text-indent: 0px; color: rgb(0, 0, 0); font-size: 10pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-family: Tahoma; "><br style="text-indent: 0px !important; "></div><div style="text-indent: 0px; color: rgb(0, 0, 0); font-size: 10pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-family: Tahoma; "><div style="text-indent: 0px !important; ">select edge_id, start_node, end_node, next_left_edge, abs_next_left_edge, next_right_edge, <br>abs_next_right_edge, left_face, geom from union_cty_topo.edge_data limit 1;</div></div><div style="text-indent: 0px; color: rgb(0, 0, 0); font-size: 10pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-family: Tahoma; "><br style="text-indent: 0px !important; "></div><div style="text-indent: 0px; color: rgb(0, 0, 0); font-family: 'Lucida Console'; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">20952;271096;271075;20954;20954;-20953;20953;0;"01020000200B7D00000200000060C7D31DEF042041807D82545CA72441C087CB2AB504204140C7FC7E07AA2441"</div><div style="text-indent: 0px; color: rgb(0, 0, 0); font-family: 'Lucida Console'; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><br style="text-indent: 0px !important; "><font class="Apple-style-span" style="text-indent: 0px !important; " face="Tahoma">select face_id, mbr from union_cty_topo.face limit 2;</font></div><div style="text-indent: 0px; color: rgb(0, 0, 0); font-family: 'Lucida Console'; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font class="Apple-style-span" style="text-indent: 0px !important; " face="Tahoma"><div style="text-indent: 0px !important; ">0;""</div><div style="text-indent: 0px !important; ">7447;"01030000200B7D00000100000005000000C087CB2AB5042041807D82545CA72441C087CB2AB5042041C0E1276882AC2441E06B43906F082041C0E1276882AC2441E06B43906F082041807D82545CA72441C087CB2AB5042041807D82545CA72441"</div><div style="text-indent: 0px !important; "><br style="text-indent: 0px !important; "></div><div style="text-indent: 0px !important; "><div style="text-indent: 0px !important; ">select node_id, containing_face, geom from union_cty_topo.node limit 1;</div></div><div style="text-indent: 0px !important; ">271075;;"01010000200B7D0000C087CB2AB504204140C7FC7E07AA2441"</div><div style="text-indent: 0px !important; "><br style="text-indent: 0px !important; "></div><div style="text-indent: 0px !important; "><div style="text-indent: 0px !important; ">select topogeo_id, layer_id, element_id,element_type from union_cty_topo.relation limit 1;</div></div><div style="text-indent: 0px !important; "><no data></div><div style="text-indent: 0px !important; "><br style="text-indent: 0px !important; "></div><div style="text-indent: 0px !important; ">select gid, pams_pin, cost, topo from union_cty_topo.summit_parcels limit 1;</div><div style="text-indent: 0px !important; "><no data></div><div style="text-indent: 0px !important; "><br style="text-indent: 0px !important; "></div><div style="text-indent: 0px !important; ">So I take the fact that I don't have node_id.containing_face, and no data in either</div><div style="text-indent: 0px !important; ">relation or summit_parcels as my failure to understand this final step of CreateTopoGeom<br><br>update union_cty_topo.summit_parcels as sp -- sp is summit_parcels<br> set topo = topology.createtopoGeom('union_cty_topo',<br> 3,1<br> , foo.sfaces)<br>from (Select s.gid, topology.TopoElementaryArray_Agg(Array[f.face.id,3]) as sfaces<br> From union_cty_topo.summit_parcels as s<br> Inner Join union_cty_topo.face as f on s.topo && f.mbr -- a little confusion here <br> where ST_Covers (s.geom, topology.ST_GetFaceGeometry('union_cty_topo', f.face_id))<br> Group by s.gid) as foo<br>Where foo.gid =sp.gid;<br><br>ERROR: schema "f" does not exist<br><br></div><div style="text-indent: 0px !important; "><br style="text-indent: 0px !important; "></div><div style="text-indent: 0px !important; ">Chris<br><br></div></font></div>--switched to firefox from chrome in hopes of better plain text client<br><div><br>> Date: Sat, 3 Dec 2011 09:44:37 +0100<br>> From: strk@keybit.net<br>> To: postgis-users@postgis.refractions.net<br>> Subject: Re: [postgis-users] Preparing for Topology - St_CreateTopoGeo<br>> <br>> On Fri, Dec 02, 2011 at 10:53:16PM -0500, Chris English wrote:<br>> <br>> > SELECT topology.st_createtopogeo('union_cty_topo',ST_Collect(geom))<br>> > FROM summit_parcels;<br>> > "Topology union_cty_topo populated"<br>> <br>> Great ! Congratulations !<br>> Now maybe you would want to try with another subset of the data<br>> as I think you were trying to isolate a portion of it that triggers<br>> a bug in ST_CreateTopoGeo, right ?<br>> <br>> --strk; <br>> <br>> ,------o-. <br>> | __/ | Thank you for PostGIS-2.0 Topology !<br>> | / 2.0 | http://www.pledgebank.com/postgistopology<br>> `-o------'<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div> </div></body>
</html>