Re: [postgis-users] Topology Postgis 2.0

2012-10-05 Thread 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) geometr

Re: [postgis-users] Topology Postgis 2.0

2012-10-05 Thread Sandro Santilli
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_ge

Re: [postgis-users] Topology Postgis 2.0

2012-10-04 Thread ps.tiara
>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

Re: [postgis-users] Topology Postgis 2.0

2012-10-04 Thread Sandro Santilli
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 w

Re: [postgis-users] Topology Postgis 2.0

2012-10-04 Thread ps.tiara
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.p

Re: [postgis-users] Topology Postgis 2.0

2012-09-28 Thread Wim Nederend
On 09/27/2012 02:50 PM, Sandro Santilli wrote: On Thu, Sep 27, 2012 at 02:44:12PM +0200, Sandro Santilli wrote: On Thu, Sep 27, 2012 at 04:58:24AM -0700, ps.tiara wrote: but when i visualized the result of topology in x3d, it was mess..maybe i made a mistake by wrong query?? How did you vis

Re: [postgis-users] Topology Postgis 2.0

2012-09-27 Thread ps.tiara
> When asked for a version please report the output of: > SELECT postgis_full_version(); > That way we have full information. There is 2.0.0 and 2.0.1 of PostGIS. This is the report "POSTGIS="2.0.0 r9605" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.0, released 2011/12

Re: [postgis-users] Topology Postgis 2.0

2012-09-27 Thread Sandro Santilli
On Thu, Sep 27, 2012 at 02:44:12PM +0200, Sandro Santilli wrote: > On Thu, Sep 27, 2012 at 04:58:24AM -0700, ps.tiara wrote: > > but when i visualized the result of topology in x3d, it was mess..maybe i > > made a mistake by wrong query?? > > How did you visualize ? What do you mean by "messy" ?

Re: [postgis-users] Topology Postgis 2.0

2012-09-27 Thread Sandro Santilli
On Thu, Sep 27, 2012 at 04:58:24AM -0700, ps.tiara wrote: > I used PostgreSQL 9.1 and PostGIS 2.0 for PostgreSQL 9.1 When asked for a version please report the output of: SELECT postgis_full_version(); That way we have full information. There is 2.0.0 and 2.0.1 of PostGIS. > I tried in two way

Re: [postgis-users] Topology Postgis 2.0

2012-09-27 Thread ps.tiara
I used PostgreSQL 9.1 and PostGIS 2.0 for PostgreSQL 9.1 I tried in two ways.. FIRST, I populated geometry to the schema using CreateTopoGeo, and then updated the topology column using CreateTopoGeom... (the query and data attached) but when i visualized the result of topology in x3d, it was mess

Re: [postgis-users] Topology Postgis 2.0

2012-09-27 Thread Sandro Santilli
On Thu, Sep 27, 2012 at 02:08:00AM -0700, ps.tiara wrote: > oh thanks .. > > I almost gave up with my research .. > I used geometry that are two adjacent objects imported from KML, and I have > not managed to make the topology, do you think it is possible to do a > topology? Sure, it should. How

Re: [postgis-users] Topology Postgis 2.0

2012-09-27 Thread ps.tiara
oh thanks .. I almost gave up with my research .. I used geometry that are two adjacent objects imported from KML, and I have not managed to make the topology, do you think it is possible to do a topology? Thanks.. -- View this message in context: http://postgis.17.n6.nabble.com/Topology-Postg

Re: [postgis-users] Topology Postgis 2.0

2012-09-24 Thread Sandro Santilli
On Mon, Sep 24, 2012 at 08:34:46PM -0700, ps.tiara wrote: > I have checked with > select * from topology.topology where name = > > > but I mean the value of Z didn't appear in the Face table is when > SELECT ST_AsEWKT (mbr) > FROM . Face > > "SRID = 32749; POLYGON ((436431.259423056 9227300.430

Re: [postgis-users] Topology Postgis 2.0

2012-09-24 Thread ps.tiara
I have checked with select * from topology.topology where name = but I mean the value of Z didn't appear in the Face table is when SELECT ST_AsEWKT (mbr) FROM . Face "SRID = 32749; POLYGON ((436431.259423056 9227300.43051331,436431.259423056 9227300.43051344,436431.259423165 9227300.43051344,43

Re: [postgis-users] Topology Postgis 2.0

2012-09-24 Thread Sandro Santilli
On Mon, Sep 24, 2012 at 05:29:18AM -0700, ps.tiara wrote: > hi, > thank you for your answer.. > > i have tried to build topology, and specified Z at CreateTopology.. > but when i populated geometry to the schema, the Z value did'nt appear in > the Face table.. \d .face select * from topology.topo

Re: [postgis-users] Topology Postgis 2.0

2012-09-24 Thread ps.tiara
hi, thank you for your answer.. i have tried to build topology, and specified Z at CreateTopology.. but when i populated geometry to the schema, the Z value did'nt appear in the Face table.. for information, i used geometry data from KML file that stores the polygon in a triangles, does this make

Re: [postgis-users] Topology Postgis 2.0

2012-09-24 Thread Sandro Santilli
On Mon, Sep 24, 2012 at 01:40:05AM -0700, ps.tiara wrote: > i have questions, whether PostGIS 2.0 supports topology in 3 D? > could you explain the detail steps to populate the geometry to the topology > schema please? It supports 2.5D topology (a Z value for each vertex, but no volumes). You need

[postgis-users] Topology Postgis 2.0

2012-09-24 Thread ps.tiara
hi all, i have questions, whether PostGIS 2.0 supports topology in 3 D? could you explain the detail steps to populate the geometry to the topology schema please? thank you... -- View this message in context: http://postgis.17.n6.nabble.com/Topology-Postgis-2-0-tp506.html Sent from the Po