Re: [postgis-users] OpenBSd installation problem

2013-07-02 Thread Greg Troxel
This smells like issues with not having RPATH set in various libraries. I have been building on NetBSD and not seeing this, but I think I have LDFLAGS set to -L and -R both for /usr/pkg/lib and such. (Sorry, the details are paged out of my brain because Copious Spare Time for postgis has been

Re: [postgis-users] Tricks to find polygon/line intersection faster

2013-07-02 Thread Lelo - Luiz Rogério De Pieri
Hi Evan, What about instead of verify the intersection with Simplified polygon, verify the intersection with the BBox ? *ST_Envelope * http://postgis.refractions.net/documentation/manual-1.4/ST_Envelope.html I've been using this strategy on my system but using geotools and gives me nice results.

Re: [postgis-users] Pixels' neighbors

2013-07-02 Thread dustymugs
Hugues, You should be able to use ST_MapAlgebraNgb if you have PostGIS 2.0. But there may be challenges working with neighboring tiles. PostGIS 2.1 has more robust handling with ST_MapAlgebra. http://www.postgis.net/docs/manual-2.1/RT_ST_MapAlgebra.html See the example with the description

Re: [postgis-users] Pixels' neighbors

2013-07-02 Thread dustymugs
Hugues, Another possibility if you have PostGIS 2.1 is ST_Neighborhood(). http://www.postgis.net/docs/manual-dev/RT_ST_Neighborhood.html -bborie On 07/02/2013 09:47 AM, Hugues François wrote: Hello, Given a one band raster made of numerous tiles and a point geometry from which I select

Re: [postgis-users] Pixels' neighbors

2013-07-02 Thread Hugues François
Hello Bborie, Thanks for your answers. I have requested our team to migrate to postgis2.1 since beta version been released but unsuccessfully. I hope things will move with the official release. I fall in love with these new sexy features and others. Awaiting for this moment, I will look