Loading

Rounding Coordinates or Ordinates in SDO_GEOMETRY

31 Jul 2020 By Simon Greener

Often Oracle Locator/Spatial users want to know how to round the individual ordinates of the coordinates of an sdo_geometry. This article shows how this can be done. Background Oracle imposes no precision limit on the NUMBER that records an ordinate of a coordinate except that imposed by the NUMBER datatype itself. Also, while one associatesRead More

The Power of Constraints and Indexes for Spatial Constraints: stopping duplicate points

24 Jul 2020 By Simon Greener

Over on Technet , the following question was asked: My question is, can you think of a way to recognize situations like this and merge and store them in a table before, we attempt mapping and spatial queries are performed? The following database level approach is one approach for ensuring any loader doesn’t load duplicateRead More