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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Geospatial professional services http://even.rouault.free.fr/services.html _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
