Re: [postgis-users] Raster "zonal histogram"

2014-04-15 Thread guido lemoine
The order of union and clip seems illogical. First union, then clip (once). This may not be a big difference for a small parcel (2048 seems to be smaller than a 100 x 100 tile), but should be for others (multi-tile parcel coverages). On 04/15/14, Adrien ANDRÉ wrote: > > Hi list, > > i h

[postgis-users] Raster "zonal histogram"

2014-04-15 Thread Adrien ANDRÉ
Hi list, i have a polygon table named "common.parcel" (3432 records). and a 11038x13438 pixels raster table "resource.zones" (100x100 tiled) with the following values: 0: wetland; 1: strong slope; 2: workable surface. As a "zonal histogram", i'd like to get this kind of result: parcel_gid | 0

Re: [postgis-users] curves geometries and topology

2014-04-15 Thread Rémi Cura
2014-04-15 16:58 GMT+02:00 Sandro Santilli : > On Tue, Apr 15, 2014 at 04:40:34PM +0200, Reijer Copier wrote: > > Thanks! > > > > We are currently considering using PostGIS Topology only to maintain > > a topology aware copy of the data (to be used for analyses where > > topology matters) and use

Re: [postgis-users] curves geometries and topology

2014-04-15 Thread Sandro Santilli
On Tue, Apr 15, 2014 at 04:40:34PM +0200, Reijer Copier wrote: > Thanks! > > We are currently considering using PostGIS Topology only to maintain > a topology aware copy of the data (to be used for analyses where > topology matters) and use the original geometry (containing circular > strings) whe

Re: [postgis-users] curves geometries and topology

2014-04-15 Thread Reijer Copier
Thanks! We are currently considering using PostGIS Topology only to maintain a topology aware copy of the data (to be used for analyses where topology matters) and use the original geometry (containing circular strings) when we have to (re)generate output geometry. BTW: Is cgal/sfcgal going

[postgis-users] Error in displaying PostGIS raster layers on Mac

2014-04-15 Thread Marcello Benigno
Hi all, I have on my mac (Mavericks OS) Mapserver 6.2.1 and PostGIS 2.1.2 installed via homebrew and my version of GDAL is 1.10.1_1. Apparently everything works fine ... When I try to display a raster layer from PostGIS, got the following message : msDrawMap(): Image handling error. Failed to dr

[postgis-users] (no subject)

2014-04-15 Thread Marcello Benigno
Hi all, I have on my mac (Mavericks OS) Mapserver 6.2.1 and PostGIS 2.1.2 installed via homebrew and my version of GDAL is 1.10.1_1. Apparently everything works fine ... When I try to display a raster layer from PostGIS, got the following message : msDrawMap(): Image handling error. Failed to dr