28 SDO_SAM Package (Spatial Analysis and Mining)

The MDSYS.SDO_SAM package contains subprograms for spatial analysis and data mining.

To use the subprograms in this chapter, you must understand the conceptual information about spatial analysis and data mining in Spatial Analysis and Mining.

Note:

SDO_SAM subprograms are supported for two-dimensional geometries only. They are not supported for three-dimensional geometries.

Table 28-1 lists the spatial analysis and mining subprograms.

Table 28-1 Subprograms for Spatial Analysis and Mining

Function	Description
SDO_SAM.AGGREGATES_FOR_GEOMETRY	Computes the thematic aggregate for a geometry.
SDO_SAM.AGGREGATES_FOR_LAYER	Computes thematic aggregates for a layer of geometries.
SDO_SAM.BIN_GEOMETRY	Computes the most-intersecting tile for a geometry.
SDO_SAM.BIN_LAYER	Assigns each ___location (and the corresponding row) in a data mining table to a spatial bin.
SDO_SAM.COLOCATED_REFERENCE_FEATURES	Performs a partial predicate-based join of tables, and materializes the join results into a table.
SDO_SAM.SIMPLIFY_GEOMETRY	Simplifies a geometry.
SDO_SAM.SIMPLIFY_LAYER	Simplifies a geometry layer.
SDO_SAM.SPATIAL_CLUSTERS	Computes clusters using the existing R-tree index, and returns a set of SDO_REGION objects where the geometry column specifies the boundary of each cluster and the `geometry_key` value is set to null.
SDO_SAM.TILED_AGGREGATES	Tiles aggregates for a ___domain. For each tile, computes the intersecting geometries from the theme table; the values in the `aggr_col_string` column are weighted proportionally to the area of the intersection, and aggregated according to `aggr_col_string`.
SDO_SAM.TILED_BINS	Tiles a two-dimensional space and returns geometries corresponding to those tiles.

The rest of this chapter provides reference information on the spatial analysis and mining subprograms, listed in alphabetical order.