Re: [postgis-users] postgis topology

2013-05-20 Thread Sandro Santilli
On Sun, May 19, 2013 at 10:03:05AM +0200, Eva Linhartová wrote: > Hi, > thx from your advice, I dropped topology DP_TOPO2 and create new one called > dp_topo. I didn't get the error, but the query still working (11 hours). I > expected long time for it because it's working with 7000 polygons, but I

Re: [postgis-users] toTopoGeom take long time

2013-05-20 Thread Sandro Santilli
On Sun, May 19, 2013 at 07:49:05PM +0200, Eva Linhartová wrote: > Hi, > I'm trying to insert geometry data to topology structure. I have 7000 > polygons and the procedure take very long time now it's about 22 hours. > > UPDATE plochy SET topo = topology.toTopoGeom(geom, 'dp_topo',3,0.005); > > I

[postgis-users] Shp2pgsql : Error in fread()

2013-05-20 Thread Hugues François
Hello, I have a big amount of data to import ins postgis from shapefile (18.000.000 of squares). As usual, I used shp2pgsql to do that with this command line : shp2pgsql -s 2154 -g geom -W LATIN1 -I /home/myhome/shpname myschema.shpname. But for each of my file (there are four of them) it throw

Re: [postgis-users] Shp2pgsql : Error in fread()

2013-05-20 Thread Mark Cave-Ayland
On 20/05/13 13:23, Hugues François wrote: Hello, I have a big amount of data to import ins postgis from shapefile (18.000.000 of squares). As usual, I used shp2pgsql to do that with this command line : shp2pgsql -s 2154 -g geom -W LATIN1 -I /home/myhome/shpname myschema.shpname. But for each