topic Simple Definition Query in ArcGIS Pro Questions

Simple Definition Query

ChrisMacNeillNCFPD — Tue, 28 Feb 2023 23:26:42 GMT

Hey all,

I'm trying to create a definition query for a points layer where I only was to display the points in the TYPE field of 1 and 2 and then leave type 3 hidden. Anyone know how to do this?

Re: Simple Definition Query

DavidPike — Tue, 28 Feb 2023 23:46:07 GMT

The Syntax does depend on the input data type. Assuming it's a feature class, use https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/write-a-query-in-the-query-builder.htm as an example.

For the interactive selection:

Type is equal to 1

Type is equal to 2

for SQL syntax:

TYPE = 1 Or TYPE = 2

NB if the numbers are actually strings(text) then enclose '1' and '2' in quotes.

Re: Simple Definition Query

ChrisMacNeillNCFPD — Tue, 28 Feb 2023 23:59:55 GMT

Got it! Thanks!

Re: Simple Definition Query

RhettZufelt — Wed, 01 Mar 2023 00:05:25 GMT

TYPE IN (1, 2)