Re: [gdal-dev] Differences in behavior between pgsql query and use of GDAL API

2011-06-13 Thread Alexandre Gacon
Hi Luca, I follow your advice and now I have all my features. I had to do some union/collect to have the awaited result. It's just sad that I can't take more advantage of GDAL to do this : do we know why my first method can't work ? Because of a limitation in ST_GeomFromText ? Because of a limita

Re: [gdal-dev] Differences in behavior between pgsql query and use of GDAL API

2011-06-13 Thread Luca Sigfrido Percich
Hi Alexandre, if I well understood your problem, you're already doing half of the job (the queries)in PostGIS, so why not doing everything using PostGIS queries? Moreover, I think you don't need union. Assuming towns is a polygon layer, try: select distinct t.* from towns as t, (select dist

[gdal-dev] Differences in behavior between pgsql query and use of GDAL API

2011-06-13 Thread Alexandre Gacon
Hi, I need to do the following request to find some data: - I have a bunch of towns (let's call them group A) - I retrieve the towns touching the group A (let's call them group B) - I make the union of group A and group B - I ask the towns covered by the resulting union For the moment, I use GDA