This page demonstrates a Nearest Neighbor Search. After the user clicked a position on the map and adjusted the filter settings, the application looks up nearest neighbors to the clicked position and shows them on the map as well as in the interactive report below the map.

This functionality is built on top of the SDO_NN Spatial SQL function, which walks through the spatial index and returns nearest neighbors based on the given position. Additional relational filters are respected, so that the returned neighbors are typically farther away as the filter selectivity increases.