Re: [postgis-users] totopogeom resulting in SQL/MM Spatial exception

Hi,   It's better for you to use topogeo_addlinestring() function, it will split existing edges or faces.   Totopogeom() don't split. It casts a geometry type in a topogeometry.   Bonne soirée.         > Message du 15/01/19 17:4 > De : "Bo Guo" > A : postgis-users@lists.osgeo.org >

Re: [postgis-users] PostGIS case usages

Hi,   A "french use of Postgis" (sorry for my poor english, it's easyer to read than to write ) :   We are working in Land Analysis and Urban Planning. Our Information System is based on Postgresql/postgis database engine. Topology is particulary usefull for us, but a little bit tricky. Our

Re: [postgis-users] TOPOLOGY St_remedgenewface strange behavior

Thanks a lot   > Every update to the table leaves an orphaned record that's removed > on vacuum. The topology functions make lots of updates, so you'd > better enable autovacuum and/or automatically vacuum every N edge > deletion. Ok ! My work's DB contains one million of face so I'm working now

[postgis-users] TOPOLOGY St_remedgenewface strange behavior

HI,   I try to remove edges wich have left_face = 0 or right_face=0 and area of the other face is less than one m².   My request store this edges in a table : topo.tempface0   And after deleting edges: with p as (select edge_id FROM topo.tempface0) SELECT st_remedgenewface('topo',edge_id

[postgis-users] Secret Code

Hello, When I write : CREATE TABLE cadastre.p__edigeo_2012_2b_thread1_com_148_EAD0A01 (idobj serial,ptrobj integer, refedigeo varchar(255)) it works with an implicit conversion from EAD0A01 to lower case. When I write CREATE TABLE cadastre.p__edigeo_2012_2b_thread1_com_149_EAD0A01 (idobj

Re: [postgis-users] Secret Code

Thanks, I solve it with a temp table the p__edigeo_... was here to make the unicity of the table for different threads. Christophe Rémi Cura a écrit : Both work fine here (9.3). Cheers, Rémi-C ___ postgis-users mailing list

Re: [postgis-users] spatial index for topology?

OK. So for now, working with a large topology data set is not practical. Some processing should not be a problem, if it operates on the primitives, which are indexed. - I'm not sure to understand all of the problem, the way I use to link Buissnes Object (here tronfluv ) and Primitives

Re: [postgis-users] Subdividing a polygon (rectangle) into equal segments (smaller rectangles)

Hi,   If you'd choosed to subdivise in equal parts you might have 3 lines and 4 columns (or 4 l * 3 c). So when a point A (ax,ay) is in a primary boxe, the related position in sub-boxes is: i E {0,3) \ pcxi= Message du 15/08/13 00:17 De : René Fournier A : postgis-users@lists.osgeo.org

[postgis-users] PG_Dump PG_Restore and Topology

Hi, After a Dump of a postgis 2.0's database, we try to restore it with this : http://svn.osgeo.org/postgis/tags/2.0.2/utils/postgis_restore.pl.in It works but the topology.topology table is restored only with one row (my_topo, the default row) all rows wich were created by ourself with

[postgis-users] PostGIS 2.0 Topology

Hi, Not a question but a tip. How to draw faster faces in a box:. The first methode (very slow): SELECT st_AsBinary(st_GetFaceGeometry('topocommune',element_id)) AS poly, topogeo_id FROM topocommune.relation WHERE ((layer_id=:lid) AND (st_GetFaceGeometry('topocommune',element_id)

[postgis-users] POSTGIS 2.0 Test if a Geometry Exists

Hi, I want to test if a Geometry is already exists in a table, what is the faster Solution ? I think to use this : SELECT the_geom FROM schemaname.mytable WHERE ST_Equals(the_geom, geomtoadd); When it returns 0 rows the geometry does not exist, but with a big table it will be slow ? Is

Re: [postgis-users] Connecting AutoCAD to PostGIS / setting up a read only user

Hi, Autocad belongs to the windows world, so I think it's a windows account problem. And with Seven OS it's a little bit tricky. Mark Volz a écrit : Hello, Does anyone know if CAD can use a read only account to connect to PostGIS, or do I need an account that had read and write