Re: [gdal-dev] DBF indexing?

2012-04-25 Thread William Kyngesburye
Cool, I didn't think to look at the shapefile help for DBF info. Makes sense. I was able to index the DBF and the join processed in seconds, which was running for hours before without finishing. Sweet. On Apr 25, 2012, at 7:53 PM, Frank Warmerdam wrote: > William, > > Yes, but only in a very

Re: [gdal-dev] DBF indexing?

2012-04-25 Thread Frank Warmerdam
William, Yes, but only in a very restricted fashion. The shapefile driver docs says: """Currently the OGR Shapefile driver only supports attribute indexes for looking up specific values in a unique key column. To create an attribute index for a column issue an SQL command of the form "CREATE IND

Re: [gdal-dev] DBF indexing?

2012-04-25 Thread Smith, Michael ERDC-CRREL-NH
CREATE INDEX Some OGR SQL drivers support creating of attribute indexes. Currently this includes the Shapefile driver. An index accelerates very simple attribute queries of the form fieldname = value, which is what is used by the JOIN capability. To create an attribute index on the nation_id field

[gdal-dev] DBF indexing?

2012-04-25 Thread William Kyngesburye
Is it possible to index fields in a DBF, and does GDAL support that for a JOIN? - William Kyngesburye http://www.kyngchaos.com/ "Those people who most want to rule people are, ipso-facto, those least suited to do it." - A rule of the universe, from the HitchHiker's Guide to the Galaxy __

RE: [gdal-dev] Python 3 on Ubuntu 11.10

2012-04-25 Thread David Hodo
I had installed GDAL from a synaptic package, not source. I removed the synaptic version and installed 1.9 from source and everything works now. Thanks, David -Original Message- From: Even Rouault [mailto:even.roua...@mines-paris.org] Sent: Wednesday, April 25, 2012 1:39 PM To: gdal

Re: [gdal-dev] Python 3 on Ubuntu 11.10

2012-04-25 Thread Even Rouault
Le mercredi 25 avril 2012 20:32:28, David Hodo a écrit : > I'm trying to install GDAL for Python 3 on Ubuntu 11.10 and having some > problems. I installed GDAL 1.7.0 and the header files from with Synaptic. > I initially tried installing the Python bindings with 'sudo easy_install > GDAL'. This

[gdal-dev] Python 3 on Ubuntu 11.10

2012-04-25 Thread David Hodo
I'm trying to install GDAL for Python 3 on Ubuntu 11.10 and having some problems. I installed GDAL 1.7.0 and the header files from with Synaptic. I initially tried installing the Python bindings with 'sudo easy_install GDAL'. This worked for me, but the installed version does not work with Pytho

Re: [gdal-dev] RFC 39

2012-04-25 Thread Ari Jolma
On 04/25/2012 04:31 PM, Even Rouault wrote: Hi Ari, Hum, I'm surprised that it has survived your testing ;-) : GetSpatialFilter() might return NULL (in fact, in the general case, it will), so GetSpatialFilter()->clone() should segfault. I've not yet tested this one at all :) -- I only made sur

Re: [gdal-dev] RFC 39

2012-04-25 Thread Even Rouault
Hi Ari, > I've uploaded a new patch, which hopefully corrects the issues Even > brought up. Below are comments. I've reviewed quickly and the new version seems to address my comments well. > > I've not added the Append or Buffer methods, which basically work on > just one layer. I believe such f

Re: [gdal-dev] OGR and Postgis : use simpler request to determine the spatial projection

2012-04-25 Thread Even Rouault
Selon Alexandre Gacon : > Hi, > > We use currently GDAL/OGR C++ API to execute complicated requests on a > postgis database. Apparently, GDAL executes the request also to find the > spatial reference of the result. Is it possible to bypass this behavior and > thus to avoid the execution of our req

[gdal-dev] OGR and Postgis : use simpler request to determine the spatial projection

2012-04-25 Thread Alexandre Gacon
Hi, We use currently GDAL/OGR C++ API to execute complicated requests on a postgis database. Apparently, GDAL executes the request also to find the spatial reference of the result. Is it possible to bypass this behavior and thus to avoid the execution of our request ? -- Alexandre Gacon

[gdal-dev] RFC 39

2012-04-25 Thread Ari Jolma
Folks, I'll start a new thread for this RFC. I've uploaded a new patch, which hopefully corrects the issues Even brought up. Below are comments. I've not added the Append or Buffer methods, which basically work on just one layer. I believe such functionality is simple enough to create using