Re: [postgis-users] Query choces on searching too small area

2016-12-19 Thread Rémi Cura
@Paul, that's what I thought, but it seems querry can't be un-rolled like this, because one row will have only one key. (no one row will match all the conditions, you have to get several rows and perform intersection of results). I fully agree this is totally bad for postgres, I would guess Arjen

Re: [postgis-users] Query choces on searching too small area

2016-12-19 Thread Arjen Haayman
Yes, this works nicely. Thanks! Didn’t know about the ‘WITH’ statement From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Rémi Cura Sent: vrijdag 16 december 2016 18:33 To: PostGIS Users Discussion Subject: Re: [postgis-users] Query

Re: [postgis-users] Postgress.app + pointcloud

2016-12-19 Thread P Kishor
> On Dec 19, 2016, at 10:20 AM, Giuseppe Broccolo > wrote: > > Hi, > > 2016-12-18 21:40 GMT+01:00 Puneet Kishor : >> As advised, I downloaded and installed Postgress.app (Mac OS X Sierra with >> Xcode 8.1). All works well. >> >>

Re: [postgis-users] Postgress.app + pointcloud

2016-12-19 Thread Giuseppe Broccolo
Hi, 2016-12-18 21:40 GMT+01:00 Puneet Kishor : > As advised, I downloaded and installed Postgress.app (Mac OS X Sierra with > Xcode 8.1). All works well. > > However, I'd like to install and experiment with the pointcloud extension > as I have a bunch of data from a 3D scan.