Oracle spatial sdo_buffer function precision control SDO_GEOM.sdo_buffer function is used for buffer query. It has three parameters: www.2cto.com param1: the geometric element to be queried. Param2: the geometric elements used for filtering. Param3: used to control the buffer radius value, buffer arc tolerance, and unit. Now, I have a requirement to query the buffer zone of the first-line figure and draw the buffer zone on the map.
The following is my code: public String getBufferLine (String lineWKT, double distance) {String response = ""; // The smaller the tolerace value, the more accurate the image is. likehua 20121114 StringBuffer SQL = new StringBuffer ("select transform (SDO_GEOM.sdo_buffer (SDO_GEOMETRY ('" + lineWKT + "', 8307 ),"
+ Distance + ", 0.0002, 'arc _ tolerance = 0.02 unit = M') as wkt from dual"); List <Map> result = this. getListByArg (SQL. toString (), null); if (result! = Null & result. size ()> 0) {Map one = result. get (0); response = one. get ("WKT "). toString ();} return response;} the smaller the arc_tolerance, the more precise the buffer image, and the larger the sdo_geoemtry
The longer the response time for drawing the image.