SDO_SAM.SIMPLIFY

Format

SDO_SAM.SIMPLIFY_LAYER(
     theme_tablename       IN VARCHAR2, 
     theme_colname         IN VARCHAR2, 
     smpl_geom_colname     IN VARCHAR2, 
     commit_interval       IN NUMBER DEFAULT 10, 
     pct_area_change_limit IN NUMBER DEFAULT 2);

Description

Simplifies a geometry layer.

Parameters

theme_tablename: Name of the table containing the geometry layer to be simplified.
theme_colname: Column in theme_tablename of type SDO_GEOMETRY containing the geometries to be simplified.
smpl_geom_colname: Column in theme_tablename of type SDO_GEOMETRY into which the simplified geometries are to be placed by this procedure.
commit_interval: Number of geometries to simplify before Spatial performs an internal commit operation. If commit_interval is not specified, a commit is performed after every 10 simplification operations.
pct_area_change_limit: The percentage of area changed to be used for each simplification iteration, as explained in the Usage Notes for the SDO_SAM.SIMPLIFY_GEOMETRY function.

Usage Notes

This procedure simplifies all geometries in a layer. It is equivalent to calling the SDO_SAM.SIMPLIFY_GEOMETRY function for each geometry in the layer, except that each simplified geometry is put in a separate column in the table instead of being returned to the caller. See also the Usage Notes for the SDO_SAM.SIMPLIFY_GEOMETRY function.

Examples

The following example adds a column named SMPL_GEOM to the POLY_4PT_TEMP table, then simplifies all geometries in the GEOMETRY column of the POLY_4PT_TEMP table, placing each simplified geometry in the SMPL_GEOM column in the same row with its associated original geometry.

ALTER TABLE poly_4pt_temp ADD (smpl_geom mdsys.sdo_geometry);
 
Table altered.
 
EXECUTE sdo_sam.simplify_layer('POLY_4PT_TEMP', 'GEOMETRY', 'SMPL_GEOM');
 
PL/SQL procedure successfully completed.