RE: [postgis-users] correcting polygons

2007-06-01 Thread Malm Paul
Thanks, Paul! I'm not to good in SQL and have looked at old userGroup qestions and found this (Regina Obe): (converting multi polygons to polygons by creating a new tabel) / String table = depare_area; String qq; myStat = con.createStatement(); qq= SELECT

Re: [postgis-users] Problem with slow GeomUnion (geom, geom)

2007-06-01 Thread Mark Cave-Ayland
On Fri, 2007-06-01 at 10:06 +0200, Matt Doughty wrote: Hi, I’m having some problems with the GeomUnion (geometry, geometry) function- basically that it takes forever and eventually crashes out for lack of memory. I’m trying to perform a union on two polygon tables (of 9,000 and

[postgis-users] ArcCatalog

2007-06-01 Thread Malm Paul
Hi, I wounder if someone knows of an application like ArcCatologe for Postgis (import/export/adding/correcting/joining etc)? Kind regards, Paul ___ postgis-users mailing list postgis-users@postgis.refractions.net

RE: [postgis-users] ArcCatalog

2007-06-01 Thread Matt Doughty
Hi, I'm not familiar with Qgis, but I found that Kosmo (from saig.es) is much more stable than gvSIG and Jump (on which it is based). It supports My SQL and Oracle as well as PostGIS and the spatial analyses are quite good. Matt Matt Doughty GEOGRAMA S.L. Tel.: +34 945 13 13 72652 77

RE: [postgis-users] correcting polygons

2007-06-01 Thread Obe, Regina
Forgot to mention before updating the field, its probably best to only if you really need to and if updating will help so something like UPDATE sometable SET the_geom = multi(buffer(the_geom, 0.0)) WHERE isvalid(the_geom) = false and isvalid(buffer(the_geom,0.0)) = true -Original