Problem: Using parentheses in queries to ArcSDE for Coverages layers returns incorrect results


When the WHERE clause of a query to an ArcSDE for Coverages layer includes parentheses, all records are returned. An example is:

<SPATIALQUERY where="(STATE_NAME = 'California')" >


This is a known issue.

Solution or Workaround

Select an option below.

  • Add a space between the parentheses and the text inside:

    <SPATIALQUERY where="( STATE_NAME = 'California' )" >
  • Remove the parentheses.

    Shapefile and ArcSDE layers do not have this problem.