Re: [gdal-dev] sqlite dialect and MySQL spatial input

2013-09-30 Thread Jukka Rahkonen
Even Rouault mines-paris.org> writes: > > I've just pushed in trunk a change to make SQLITE dialect available to all OGR > drivers that have a specialized ExecuteSQL() implementation. Hi, Is this a correct interpretation: - The default SQL dialect is "OGR SQL", except for databases when the

[gdal-dev] Buffering geometries

2013-09-30 Thread federico
Dear all, i'm trying buffer some geometries with GDAL. I have success with poligons and lines but i can't create the buffer when i try to do the same procedure with an OGRPoint. Here is a screenshot with the buffer http://i.imgur.com/rRQuooc.jpg I'm using the Buffer function from OGRGeometry Clas

Re: [gdal-dev] sqlite dialect and MySQL spatial input

2013-09-30 Thread Even Rouault
Le lundi 30 septembre 2013 19:22:21, aborruso a écrit : > Hi Jukka, > thank you. > > > Rahkonen Jukka wrote > > > I wonder where in the documentation would be the best place to mention > > this over-override trick. > > Probably in this moments it would be necessary to insert it in both pages >

Re: [gdal-dev] sqlite dialect and MySQL spatial input

2013-09-30 Thread aborruso
Hi Jukka, thank you. Rahkonen Jukka wrote > I wonder where in the documentation would be the best place to mention > this over-override trick. Probably in this moments it would be necessary to insert it in both pages you mentioned. Best regards, Andrea -- View this message in context: http

Re: [gdal-dev] sqlite dialect and MySQL spatial input

2013-09-30 Thread Jukka Rahkonen
aborruso gmail.com> writes: > > Only to add that if I try to read the same MySQL input using OGR Virtual > Format, the ST_Area function works properly. > > Thank you Hi, http://www.gdal.org/ogr/ogr_sql.html says: "All OGR drivers for database systems: MySQL, PostgreSQL and PostGIS (PG), Oracl

Re: [gdal-dev] Motion: Add Jukka Rahkonen to GDAL PSC

2013-09-30 Thread Daniel Morissette
+1 Welcome Jukka! Daniel On 13-09-28 4:42 AM, Even Rouault wrote: Hi, Jukka is one of our most active power users since many years. You've certainly noticed him many times answering to question from other users on the mailing list, testing bleeding edge trunk or doing precise bug reports. Juk

Re: [gdal-dev] sqlite dialect and MySQL spatial input

2013-09-30 Thread aborruso
Only to add that if I try to read the same MySQL input using OGR Virtual Format, the ST_Area function works properly. Thank you -- View this message in context: http://osgeo-org.1560.x6.nabble.com/sqlite-dialect-and-MySQL-spatial-input-tp5080909p5080911.html Sent from the GDAL - Dev mailing li

[gdal-dev] sqlite dialect and MySQL spatial input

2013-09-30 Thread aborruso
Hi all, I'm using sqlite dialect with shapefile input. An example is: ogrinfo poligoni_input.shp -dialect sqlite -sql "SELECT ST_Area(geometry) AS Area FROM poligoni_input" It works and it's a great feature. I have some problems with MySQL spatial input. I use this syntax: ogrinfo MYSQL:"mydb,us