<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'>
in any case, to your point of trying to isolate a portion that triggers a bug in <br>St_CreateTopoGeo, some candidates are suggested by taking the geoms reported as Error initially:<br><br>select gid, mun from unioncountyparcels where geom && ST_AsEWKT('01060000200B7D00000100000001030000000100000007000000204F2F7CE23C214140AA79907071244180EF6AE12B3D2141C0EF55BC50712441E0ACD564CC3C21414008958C7470244140F668FF823C2141C0C2B86094702441E0C3B6D3A23C21414066FBC5DD702441607EDAA7C23C2141C006372B27712441204F2F7CE23C214140AA799070712441')<br> ;<br>(later-> possible_triggers_2)<br>gid____mun<br>37854;"2004"<br>27568;"2004"<br>31314;"2004"<br>32373;"2004"<br>34949;"2004"<br>36301;"2004"<br>36303;"2004"<br>37096;"2004"<br>133778;"2019"<br>133779;"2019"<br><br>or<br><br>select gid, mun from unioncountyparcels where geom && ST_AsEWKT('01060000200B7D0000010000000103000000010000000500000080CD197443872141804C827B8B72244160C59F12AC872141007C974465722441200CCDF85687214100F7FE58B6712441006624DF018721410032D76ED571244180CD197443872141804C827B8B722441');<br><br>(later -> possible_triggers)<br>gid_____mun<br>25221;"2004"<br>32369;"2004"<br>34946;"2004"<br>34947;"2004"<br>34948;"2004"<br><br>select topology.createtopology('possible_triggers', 32011);<br><br>Select topology.ST_createtopogeo('possible_triggers',St_collect(geom)) from possible_triggers;<br><this populated for the second group><br>"Topology possible_triggers (3), SRID 32011, precision 0<br>8 nodes, 12 edges, 5 faces, 0 topogeoms in 0 layers"<br><br>Select topology.ST_createtopogeo('possible_triggers_2',St_collect(geom)) from possible_triggers_2;<br>"Topology possible_triggers_2 populated"<br><br>Well, that approach didn't isolate. Better thoughts on isolating?<br>Chris<br><div><hr id="stopSpelling">From: sglish@hotmail.com<br>To: postgis-users@postgis.refractions.net<br>Date: Sat, 3 Dec 2011 09:22:29 -0500<br>Subject: Re: [postgis-users] Preparing for Topology - St_CreateTopoGeo<br><br>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<style>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
</style>
<div dir="ltr">
<font class="ecxApple-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;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;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;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;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">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"><br style="text-indent:0px !important"><font class="ecxApple-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"><font class="ecxApple-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>
<br>_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users</div> </div></body>
</html>