ArcPro 3.0 Definition Query

Question

Is there a definition query bug in ArcPro 3.0? I'm filtering out certain parking lots by location type or by public access in the same query, but the OR condition isn't removing the correct features. So this query removes zero features: LOCDESC <> 'Street' OR Access <> 'Private' While this one removes the ones I want: LOCDESC <> 'Street' And Access <> 'Private'

BarryNorthey · Answer

In SQL And and Or are somewhat the reverse of how we use them in English. In English we might say that we want to display (Definition Query) or select (Select By Attributes) only the Pine (P) and Spruce (Sw) stands in this layer (field SP1). IN SQL we would write: SP1 = 'P' Or SP1 = 'Sw' wherein a selection is made when a condition on either side of the Or is met.

If we wrote SP1 = 'P' And SP1 = 'Sw' (as it sounds in English) no selections can be made because both conditions must be met to make a selection and in this example, a tree can't be both a spruce and a pine .

rzufelt · Answer

OR will draw all features that are not private, regardless of what the LOCDESC value is, as well as drawing all the features that are not street, regardless of what the Access value is.

R_

MichaelMcBain · Answer

Since I want parking areas that are not Street or areas that are not "Private" should it be an OR, not and?

I am using the one that gets the job done