I figure you have spatially indexed the polygons already?
Any way of pre-categorising your polygons - binning them in some way that
allows a non spatial test in the where clause to replace the spatial test...
eg: a boolean attribute set to indicate if a feature has any part = a
particular x
Maybe you can try the stupidest way to go,
anyway you have to do a inner product because you have to consider each
pair of polygons.
CREATE TABLE result AS
SELECT DISTINCT ON (a.gid) a.*
FROM table AS a , table AS b
WHERE ST_Intersects(a.geom, b.geom) = TRUE
AND a.gid != b.gid
Now you can
Hye.
I have a question about the check constraints on the PostGIS columns type
Can you explain me why we got check constraints on old version (here 1.5.2) of
PostGIS and now we don't see such constraints with 2.0 when we ask a describe
of such relation.
I precise that the 2 objects have been
I would have gone with a license saying You can modify and redistribute as
long as the derived work is also under an open license, not necessarily GPL.
Does that make sense? Does that exist?
http://en.wikipedia.org/wiki/WTFPL
Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
Not really the same thing as I said... ;-)
I would prefer You just DO WHAT THE FUCK YOU WANT TO as long as it stay
open...
-Original Message-
From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-
boun...@lists.osgeo.org] On Behalf Of Mateusz Loskot
Sent: Wednesday,
On Wed, Nov 20, 2013 at 09:56:56AM -0500, Pierre Racine wrote:
Not really the same thing as I said... ;-)
I would prefer You just DO WHAT THE FUCK YOU WANT TO as long as it stay
open...
That's GPL, really. The only reason for people NOT to like it is
when they want to craft some piece of
There is a very big difference between :' i tweak one of your function, so
my tweak must be open source' and 'i use one of your function, so my code
must be open source'.
Unfortunately GPL imposes both.
Cheers,
Rémi-C
2013/11/20 Sandro Santilli s...@keybit.net
On Wed, Nov 20, 2013 at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Il 20/11/2013 16:32, Rémi Cura ha scritto:
There is a very big difference between :' i tweak one of your function, so my
tweak
must be open source' and 'i use one of your function, so my code must be open
source'.
Unfortunately GPL imposes
On Wed, Nov 20, 2013 at 04:32:12PM +0100, Rémi Cura wrote:
There is a very big difference between :' i tweak one of your function, so
my tweak must be open source' and 'i use one of your function, so my code
must be open source'.
Unfortunately GPL imposes both.
It's not unfortunate, it's
This is not as simple,
Many open source software are not GPL (starting from standard implementing
api ),
including postgres !
GPL is not always the answer, and here I don't think it is.
For me it should be a more open license, and the project should be hosted
on the postgis github.
Cheers,
Hi,
I would prefer You just DO WHAT THE FUCK YOU WANT TO as long as it stay
open...
That's GPL, really. The only reason for people NOT to like it is
when they want to craft some piece of closed source and still use
what you send out to the world as an open component.
Another reason is
Hi all,
I am drawing some multipolygons in QGIS and sometimes, I have parts of
them which are adjacent and I'd like to homogenize them to have less
parts and no adjacent parts.
I could do this with a quite complex method:
1. get the number of parts Z:
SELECT ST_NumGeometries(geometry)
From what I understand of your needs, Postigs topology was designed for
this.
Cheers,
Rémi-C
2013/11/20 Denis Rouzaud denis.rouz...@gmail.com
Hi all,
I am drawing some multipolygons in QGIS and sometimes, I have parts of
them which are adjacent and I'd like to homogenize them to have less
On Nov 20, 2013, at 3:48 PM, Pierre Racine wrote:
Salut Pierre,
Thanks Vincent for this input.
I'll go for GPL for now as it's that a nightmare to change afterward if,
really, someone complains.
I'm agree with Remi and Vincent points.
And i don't see there, any coming code valuable
Thank you for these suggestions. I haven't replied yet because I am testing
them, and the queries take an hour or more to run on the 2 million plus
table. I will report back with some results.
On Wed, Nov 20, 2013 at 4:46 AM, Rémi Cura remi.c...@gmail.com wrote:
Maybe you can try the
Hi All,
What's the best (normal) human readable reference for the PostGIS distance
operators-- but deep enough to talk about the use of index structure in the
use of the operators?
Thanks,
Best,
Steve
___
postgis-users mailing list
Hopefully I'm not too immodest in saying this
http://workshops.boundlessgeo.com/postgis-intro/knn.html
P
On Wed, Nov 20, 2013 at 10:49 AM, Stephen Mather
step...@smathermather.com wrote:
Hi All,
What's the best (normal) human readable reference for the PostGIS distance
operators-- but deep
Greg,
Did you run the nation script routine?
http://postgis.net/docs/manual-dev/Loader_Generate_Nation_Script.html
That's the first step needed. Should actually be done before you load the
other tables.
Hope that helps,
Regina
http://www.postgis.us
http://postgis.net
_
From:
No, that is in fact excellent (actually irritatingly good, I was just
finishing up a write up of my own...), but I should have been more
specific. I'm looking for a reference to point to for the why it works,
not the how, i.e. how does the structure of the R-Tree index lends itself
to creating a
Yes! Thanks Regina,
You know, I kept looking at that function and convinced myself that it was
for loading the entire country as opposed to individual states.
I'm getting Lat / Long now.
-- Greg
From: Paragon Corporation l...@pcorp.us
Reply-To: PostGIS Users Discussion
Hello Rémi,
I was hoping a simplest request without enabling topology but thanks anyway!
Cheers,
Denis
On 20. 11. 13 18:26, Rémi Cura wrote:
From what I understand of your needs, Postigs topology was designed
for this.
Cheers,
Rémi-C
2013/11/20 Denis Rouzaud denis.rouz...@gmail.com
21 matches
Mail list logo