Bug: Performing a selection in ArcGIS against a layer with an empty extent selects all features


If the layer's extent is empty, performing a spatial selection against an ArcSDE layer results in all features being selected.


When a layer's extent is empty, but features are present in the layer, ArcGIS removes the spatial constraint from the spatial query and simply selects all records from the layer.


To avoid the problem, update the layer's spatial extent by using the ArcSDE command sdelayer.

The following example demonstrates how to use the sdelayer command to automatically set the layer's feature extent.

D:\> sdelayer -o alter -l neighborhoods,shape -E calc -u tb -p tb -i 5151

ArcSDE 9.3 for Oracle10g Build 508 Thu Apr 17 12:23:18 2008
Layer Administration Utility
Successfully Modified the Layer