[gdal-dev] sqlite dialect and MySQL spatial input

[Even Rouault]

Le mercredi 02 octobre 2013 10:13:23, aborruso a écrit :
> Hi,
> firts of all thank you for your work. It is always very nice to see how a
> great open source community works.
> 
> 
> Even Rouault wrote
> 
> > Using SQLITE dialect with a RDBMS driver is kind of unusual use case
> > (which was the thing that was finxed with r26506).
> 
> I want to add a detail, but I do not know whether it is useful. I have
> discovered this over-override
> trick, because I needed to use real spatial SQL functions, not the limited
> MBR functions of MySQL spatial.

Wouldn't Area() as described in 
http://dev.mysql.com/doc/refman/5.0/en/geometry-property-
functions.html#function_area do the job ?

$ ogrinfo mysql:autotest -sql "SELECT Area(GeomFromText('Polygon((0 0,0 3,3 
0,0 0),(1 1,1 2,2 1,1 1))'))"
INFO: Open of `mysql:autotest'
      using driver `MySQL' successful.

Layer name: sql_statement
Geometry: None
Feature Count: 1
Layer SRS WKT:
(unknown)
Area(GeomFromText('Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))')): Real 
(23.0)
OGRFeature(sql_statement):0
  Area(GeomFromText('Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))')) (Real) = 
4


> With this trick I have solved.
> 
> Best regards,
> 
> Andrea
> 
> 
> 
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/sqlite-dialect-and-MySQL-spatial-input
> -tp5080909p5081365.html Sent from the GDAL - Dev mailing list archive at
> Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
Geospatial professional services
http://even.rouault.free.fr/services.html