English

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

Description

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

Cause

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.

Workaround

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.

Code:
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