There is a section called Examples of Spatial SQL in
http://trac.osgeo.org/postgis/wiki/UsersWikiMain
I think this is the best place.
Otherwise if you can come up with a robust, generic ST_RemoveSpeckle(rast, more
parameter) plpgsql function I can add it to the trunk in the script/plpgsql
folder. Those are plpgsql prototypes to be implemented in C if we find time of
fund.
Pierre
-Original Message-
From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-
boun...@postgis.refractions.net] On Behalf Of Nicolas Ribot
Sent: Thursday, July 19, 2012 11:21 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] where to publish my scripts?
Hi Tom,
I personally publish these kind of scripts to the PostGIS wiki.
Nicolas
On 19 July 2012 17:18, Tom van Tilburg tom.van.tilb...@gmail.com wrote:
ok. I will try a bit of plpgsql'ing.
That reminds me to another question:
is there any place that people can drop their own scripts for a wider
audience?
I know there is some postgis wiki but it doesn't seem very active or
structured.
I would love to share my scripts and see some scripts from others.
chrs,
Tom
On 19-7-2012 15:57, Pierre Racine wrote:
In my idea staying with the algebra functions should be doable, even
with complex speckles.
As long as the mask is big enough (finding speckles of max N pixels
takes a 2N x 2N matrix) one should be able to run a neighbourhood scan
outwards from the centre pixel. With some smart iterations that might
work, I just need to start learning plpsql or something...
Would you agree that that kind of method would be faster than
vectorizing?
I can't answer this as I haven't played much with ST_MapAlgebraFctNgb.. It
all depends on the size of the window.
Give it a try! plpgsql is very easy and you can start from the example in
the doc.
Pierre
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users