A version of my (ordinate) Round function for SQL Server Spatial and Oracle Spatial is available for MySQL. Function Declaration Function Testing If you think this is of use to you, make a donation and I will release the code to you along with any other MySQL functions I have created.
Someone contacted me about having to change all the tolerances in their user_sdo_geom_metadata due to a need to change each sdo_tolerance value from 0.005 (1cm) to 0.0005 (1mm) meters. I hope this helps someone out there…
In a previous article I showed how too many digits of precision for the ordinates of an sdo_geometry object – stored in its sdo_ordinate_array – has an effect on storage volume. In this article I will revisit the question of storage size while examining the effect that storage size has on performance (search and retrieval).Read More
In this article I am going look at the effect ordinate precision has on the storage space occupied by tables containing sdo_geometry data. In a related article I will also look at the effect storage precision may have on performance (ie searching and returning data in SQL). Sdo_Geometry Coordinate Precision There is a little knownRead More