laptop and a wrench

Bug

Incorrect results returned on spatial selections when the data sources extent is empty.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM035316
SubmittedMay 16, 2008
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.3
Version FixedN/A
StatusFixed

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

    Steps to Reproduce

    Bug ID: NIM035316

    Software:

    • No Product Found

    Get notified when the status of a bug changes

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options