On Thu, Oct 04, 2012 at 08:36:36AM -0700, ps.tiara wrote:
> >Could you please send a self-contained script showing the problem ?
> >It should include the CreateTopology call and the literal value of
> >the geometry where id = 1.
>
> Sorry, do you mean the query file(.sql)?
> Here it is..
>
> 1_geometry.sql
> <http://postgis.17.n6.nabble.com/file/n5000224/1_geometry.sql>
> 2_create_topology.sql
> <http://postgis.17.n6.nabble.com/file/n5000224/2_create_topology.sql>
> 3_add_topogeom_column.sql
> <http://postgis.17.n6.nabble.com/file/n5000224/3_add_topogeom_column.sql>
> 4_totopogeom.sql
> <http://postgis.17.n6.nabble.com/file/n5000224/4_totopogeom.sql>
So basically it's this:
insert into phtomulti_srid values ('1', st_geomfromtext('MULTIPOLYGONZ (
((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)),
((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),
((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 0)),
((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 1)),
((1 0 0, 1 1 0, 1 1 1, 1 0 1, 1 0 0)),
((1 1 0, 0 1 0, 0 1 1, 1 1 1, 1 1 0)))',4326) );
select topology.createtopology('phtomulti_topo',4326,0,'TRUE') as topoid;
select
topology.addtopogeometrycolumn('phtomulti_topo','public','phtomulti_srid','topo','MULTIPOLYGON
Z');
update public.phtomulti_srid set topo =
topology.toTopoGeom(geom,'phtomulti_topo',1,0.0000001) where id='1';
Ok, I can reproduce. That geometry is surely very very bad (invalid)
but the topology code should't fail.
Simplified:
select droptopology('t');
select topology.createtopology('t',0,0,true) as topoid;
create table t.t (a int); -- just a place holder for the layer
select topology.addtopogeometrycolumn('t','t','t','g','MULTIPOLYGON Z');
select topology.toTopoGeom( 'MULTIPOLYGONZ (
((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)),
((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),
((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 0)),
((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 1)),
((1 0 0, 1 1 0, 1 1 1, 1 0 1, 1 0 0)),
((1 1 0, 0 1 0, 0 1 1, 1 1 1, 1 1 0)) )'
, 't',1);
Can you please file a ticket for this case ?
Thanks!
--strk;
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
