[postgis-users] Shp2pgsql-gui, Save to schema other than public?

I just got PostGIS 2.0 installed and was using the Shp2pgsql-gui to load some shapefiles into the database. I have created a 'data' schema where I was planning to store all of my imported data, but when I use the shapefile import GUI, it does not appear as though there is an option to specify whic

Re: [postgis-users] ST_MakeValid

Stephen, Do you have a final timing from your ST_MakeValid test?  The numbers you show indicate about a 2.5:1 decrease in performance.  This could easily be explained by an extra overlay or validity test or two.  This isn't to say that there wouldn't be a poss

Re: [postgis-users] ST_MakeValid

> IIRC there's a difference with a multipolygon composed by two > overlapping rectangles. Rereading, does ST_MakeValid also test for overlapping polygons? This would explain the performance difference, as these polygons are pretty complicated, and checking for overlap would not be well served by

Re: [postgis-users] ST_MakeValid

Forgot to reply all... > The ST_MakeValid tries its best to retain all input vertices. AFAIK, Horst's function does as well. > Also, ST_MakeValid internally checks for input validity and avoids > running anything if the input is valid. Such check has a cost too. Horst's function naturally lev

Re: [postgis-users] ST_MakeValid

On Mon, Apr 16, 2012 at 12:33:15PM -0400, Stephen V. Mather wrote: > Then a quick run through cleanGeometry: ... > Query returned successfully: 1004952 rows affected, 955444 ms execution time. > > If I run as ST_MakeValid, ... > At 230 milliseconds, it is still running. . The ST_MakeValid tr

Re: [postgis-users] ST_MakeValid

Credit where credit is due-the cleanGeometry function listed below is written by Horst Duester. Best, Steve http://www.clemetparks.com/images/esig/cmp-ms-90x122.pngStephen Mather Geographic Information Systems (GIS) Manager (216) 635-3243 s...@clevelandmetroparks.com

[postgis-users] ST_MakeValid

Hi All, Has anyone done any performance tests on ST_MakeValid? I had been using Tim Sutton's cleanGeometry function from circa 2010 (http://linfiniti.com/2010/07/cleaning-geometries-inside-postgis/) to clean up geometries. Works most of the time-every now and then I throw it some

Re: [postgis-users] function comments

On Mon, Apr 16, 2012 at 02:03:22PM +0200, Jose Carlos Martinez Llario wrote: > I meant "make install" is not copying the comments to the target > directory. I can copy them by myself but it makes me suspect why the > rpm (in opensuse georepository) does not include the comments. Indeed if "make" b

Re: [postgis-users] function comments

Thanks a lot Nicolas, make docs-install is working. Maybe the people in charge of georepository in opensuse made the same mistake thats why these files are missing too. Regards, On 16/04/2012 14:05, Nicolas Ribot wrote: Hi list, After building from src or installing postgis 2 from repository

Re: [postgis-users] function comments

>>> >>> Hi list, >>> After building from src or installing postgis 2 from repository >>> (opensuse) I >>> cant find the sql comments files: postgis_comments.sql, etc. >>> The create extension system include the comments though. >>> >>> According to the manual the comments files should be there for

Re: [postgis-users] function comments

I meant "make install" is not copying the comments to the target directory. I can copy them by myself but it makes me suspect why the rpm (in opensuse georepository) does not include the comments. On 16/04/2012 13:57, Jose Carlos Martinez Llario wrote: On 16/04/2012 13:52, Nicolas Ribot wrote

Re: [postgis-users] function comments

On 16/04/2012 13:52, Nicolas Ribot wrote: Hi list, After building from src or installing postgis 2 from repository (opensuse) I cant find the sql comments files: postgis_comments.sql, etc. The create extension system include the comments though. According to the manual the comments files should

Re: [postgis-users] function comments

> Hi list, > After building from src or installing postgis 2 from repository (opensuse) I > cant find the sql comments files: postgis_comments.sql, etc. > The create extension system include the comments though. > > According to the manual the comments files should be there for postgres <= > 9.0 >

[postgis-users] function comments

Hi list, After building from src or installing postgis 2 from repository (opensuse) I cant find the sql comments files: postgis_comments.sql, etc. The create extension system include the comments though. According to the manual the comments files should be there for postgres <= 9.0 Someone kn