[postgis-users] Finding Islands

2013-11-19 Thread Lee Hachadoorian
I am trying to find "islands", polygons in a (multi)polygon layer which are not connected to any other polygons in the same layer. What I came up with runs in a couple of seconds on a layer with ~1000 geometries, and a couple of minutes on a layer with ~23,000 geometries, but I want to run it o

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Vincent Picavet
Hi, Sorry for complicating things. Le mardi 19 novembre 2013 21:48:11, Pierre Racine a écrit : > > 1. If it is GPL and I add it to my code them my code has to be licensed > > undr GPL. This is problematic for most business. If I have a proprietary > > product that I'm spent 100's of thousands of h

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Mathieu Basille
Sorry to be a little bit late in the discussion, but in my opinion, there are really two sensible solutions: 1) Use the most simple and liberal (permissive) license. No license is not an option, since it means copyright by default, and public domain is not a good option due to specific issues

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Bborie Park
> Its your code, pick the one you want. > > +1. If there was one true answer to the licensing question, this would be it. -bborie ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Pierre Racine
> 1. If it is GPL and I add it to my code them my code has to be licensed > undr GPL. This is problematic for most business. If I have a proprietary > product that I'm spent 100's of thousands of hours to develop and > believe that it is critical to my success, there is no way that I can > afford t

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Stephen Woodbridge
On 11/19/2013 2:42 PM, Pierre Racine wrote: IMHO, It's fine (actually wonderful) that postgis is in the GPL, it protects the project and does not really limit its use in any substantive way. It's big enough to stand on its own. But re: #2 GPL would limit the wide use of these scripts. How wou

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Stephen Mather
Oh, I prefer GPL, and in this case, since it's uncompiled code it probably doesn't matter. I just know lots of people belly ache about the GPL, so I'm trying to insert that perspective... . :) On Tue, Nov 19, 2013 at 2:42 PM, Pierre Racine wrote: > > IMHO, It's fine (actually wonderful) that p

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Sandro Santilli
On Tue, Nov 19, 2013 at 02:13:04PM -0500, Pierre Racine wrote: > I bend toward GPL in any case... +1 for GPL "version 2 or later" Same license that applies to PostGIS. --strk; ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.os

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Pierre Racine
> IMHO, It's fine (actually wonderful) that postgis is in the GPL, it protects > the > project and does not really limit its use in any substantive way. It's big > enough to stand on its own. But re: #2 GPL would limit the wide use of > these scripts. How would GPL limit the wide use of these s

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Stephen Mather
How could we avoid a license discussion... :) . I think there are two relevant points from the discussion: 1) It should be licensed such that it can go into core if such an option for some or all functions reveals itself in the future 2) It should be flexible enough for wide reuse. #1 precludes

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Pierre Racine
I guess the fact that PL/pgSQL is not compiled and hence is open "by nature" should have an incidence on the choice of the license. No? I bend toward GPL in any case... > -Original Message- > From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users- > boun...@lists.osgeo.org] On

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-19 Thread Pierre Racine
I knew we would fall into a license nightmare... So far we've got suggestions for "No rights reserved", BSD, Creative Common Zero, GPL, LGPL, MIT... Any of these license would make it hard to move a function from the Add-ons to PostGIS core? That would be a good candidate for elimination. Why p

Re: [postgis-users] ST_SetValue problem

2013-11-19 Thread Pierre Racine
> The result is that I change raster values in only 1 of the 81 polygon cells > that I have in > schema.data_vector. What am I missing here? Thanks for your help! Keep > up the great work! UPDATE schema.data_raster SET rast = ST_SetValue(rast,1, geom, 100) FROM schema.data_vector I don't fully u

Re: [postgis-users] ST_SetValue problem

2013-11-19 Thread Hugues François
Hello, Did you try with a new raster CREATE TABLE schema.data_raster_newval AS SELECT rid, ST_SetValue(rast,1, geom, 100) AS RAST FROM schema.data_raster, schema.data_vector What is the result ? Since you have only one tile, I don't think the intersect statement will really improve performan

[postgis-users] ST_SetValue problem

2013-11-19 Thread Sebastian Schutte
Dear Postgis list, I have been struggling for a while with a seemingly simple raster operation in postgis. I have a small number of quadratic polygons arranged like a chessboard. The cells of this chessboard contain values like elevation that I would like to write into a much larger raster layer w

Re: [postgis-users] missing libxml2.la file when compiling PostGIS 2.1.1 from Source on Ubuntu 12.04

2013-11-19 Thread Sandro Santilli
On Tue, Nov 19, 2013 at 10:22:34AM +0100, Sandro Santilli wrote: > There seem to be a reference to libxml2.la into one of the .la > files involved in the libtool call line. Start form liblwgeom.la, > it's a shell script setting some variables. Mine was created > by libtool (GNU libtool) 2.4.2 Deb

Re: [postgis-users] missing libxml2.la file when compiling PostGIS 2.1.1 from Source on Ubuntu 12.04

2013-11-19 Thread Sandro Santilli
On Mon, Nov 18, 2013 at 08:22:07PM +0100, Paolo Corti wrote: > Hi list > > When compiling PostGIS 2.1.1 I am getting the following error on my > Ubuntu 12.04 box (when making): > > ... > make[2]: Entering directory `/opt/gis/postgis/postgis-2.1.1/raster/loader' > gcc -g -O2 -fPIC -DPIC -Wall -W

Re: [postgis-users] missing libxml2.la file when compiling PostGIS 2.1.1 from Source on Ubuntu 12.04

2013-11-19 Thread Stefano Iacovella
2013/11/19 Paolo Corti > My best guess is that you are using the 2.7.8.dfsg-5.1ubuntu4.6 > version (the one for which you provided the url), and on my system for > some reasons I have a newer version. > Did you install updates? Could you provide me your sources.list? > Sorry Paolo as I don't rem

Re: [postgis-users] missing libxml2.la file when compiling PostGIS 2.1.1 from Source on Ubuntu 12.04

2013-11-19 Thread Paolo Corti
Hello Mike > > You should have e.g. /usr/lib/i386-linux-gnu/libxml2.la from libxml2-dev as > shown here > http://packages.ubuntu.com/precise/i386/libxml2-dev/filelist > so maybe try: > sudo apt-get install --reinstall libxml2-dev > No way, the libxml2-dev version in my system does not have that f