[postgis-devel] Topology Postgis 2.0

Sandro Santilli strk at keybit.net
Mon Oct 8 23:31:55 PDT 2012


NOTE: postgis-devel back in recipient list, these kind of questions are
      best asked to the public, for better help

On Mon, Oct 08, 2012 at 09:01:47PM -0700, ps.tiara at yahoo.com wrote:
> Hi,
> 
> I have read ticket #2033, thank you for your quick response Mr. Sandro..
> I am sorry it's take long time to replay your last post...
> I want to use the fixed ticket #2033 but I have some difficulties to use that..
> 
> Could you please explain the steps?
> 
> I have downloaded the postgis-2.0.2SVN.tar.gz and installed SVN client (SlikSVN)..but I don't know how to execute..

See the "PostGIS Upgrade" section in the online manual.
It could be as easy as loading postgis_topology_upgrade_20.sql

--strk;

> 
> regards,
> tiara
> 
> <quote author='Sandro Santilli'>
> On Thu, Oct 04, 2012 at 04:39:49PM +0200, Sandro Santilli wrote:
> > On Thu, Oct 04, 2012 at 07:11:47AM -0700, ps.tiara wrote:
> > > Hi, it's me again..
> > > 
> > > I have installed Postgis 2.0.1 and the function of toTopoGeom has
> > worked...
> > > 
> > > I used toTopogeom for multilinestring (2d & 3d)  geometry and it
> > worked..
> > > It also worked for  polygon 3d geometry...but it didn't work for
> > > multipolygon 3d..
> > > Here is the message error :
> > > 
> > > update public.phtomulti_srid
> > > set topo = topology.toTopoGeom(geom,'phtomulti_topo',1,0.0000001)
> > > where id='1';
> > > 
> > > ERROR:  Column has Z dimension but geometry does not
> > > CONTEXT:  SQL statement "INSERT INTO phtomulti_topo.node(node_id, geom) 
> > >     VALUES(26,'0101000020E61000000000000000000000000000000000F03F')"
> > 
> > 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.
> 
> I did it: http://trac.osgeo.org/postgis/ticket/2033
> 
> --strk;
> 
>  http://www.cartodb.com - Map, analyze and build applications with your data
> 
>                                        ~~ http://strk.keybit.net 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> </quote>
> Quoted from: 
> http://postgis.17.n6.nabble.com/Topology-Postgis-2-0-tp5000006p5000249.html

-- 

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net 




More information about the postgis-devel mailing list