[postgis-users] Preparing for Topology - St_CreateTopoGeo

[Chris English]

Hi,
I'm trying to run some county parcels into topology.  Prepared by running the following:
-- Executing query:Select gid,St_isValidReason(geom)from unioncountyparcelswhere not St_isValid(geom);Total query runtime: 20890 ms.0 rows retrieved. --> nothing comes up amiss
-- Executing query:Select St_MakeValid(geom)from unioncountyparcelswhere  St_isValid(geom)= false;Total query runtime: 20141 ms.0 rows retrieved. --> same as above, generally
-- Executing query:Select St_MakeValid(geom)from unioncountyparcels;Total query runtime: 52718 ms.147295 rows retrieved. --> and for good measure
Select topology.ST_createtopogeo('union_cty_topo',St_collect(geom)) from unioncountyparcels;

ERROR: Edge 20949 has face 0 registered on the side of this face, while edge 20948 has face 7446 on the same sideSQL state: P0001Context: SQL statement "SELECT topology.AddFace('union_cty_topo', '01030000200B7D00000100000005000000C05BF04EE05F1F410065B68BD8AC24418417744EE05F1F416FD8ED8BD8AC244180CEEC4FE05F1F41C0518C8BD8AC24411E636950E05F1F4175BA548BD8AC2441C05BF04EE05F1F410065B68BD8AC2441', true)"PL/pgSQL function "st_addedgemodface" line 607 at EXECUTE statementSQL statement "SELECT topology.ST_AddEdgeModFace(atopology, snode_id, enode_id, rec.geom)"PL/pgSQL function "st_createtopogeo" line 152 at PERFORM

The currently offending geoms:
20948 --> "01060000200B7D0000010000000103000000010000000500000080CD197443872141804C827B8B72244160C59F12AC872141007C974465722441200CCDF85687214100F7FE58B6712441006624DF018721410032D76ED571244180CD197443872141804C827B8B722441"20940 --"01060000200B7D00000100000001030000000100000007000000204F2F7CE23C214140AA79907071244180EF6AE12B3D2141C0EF55BC50712441E0ACD564CC3C21414008958C7470244140F668FF823C2141C0C2B86094702441E0C3B6D3A23C21414066FBC5DD702441607EDAA7C23C2141C006372B27712441204F2F7CE23C214140AA799070712441"

The run to this point took 12 hours and is 1/7th of the rows.
Any thoughts on further, better preparing my parcels prior to processing with St_CreateTopoGeo would be greatly appreciated.
Thanks,
Chris