[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

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

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.

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

2013-09-30 Thread Jukka Rahkonen
aborruso aborruso at 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),

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:

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 you

[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