I'm looking to exclude any streams that have values of "NULL" or "NP" using an SQL query in ArcGIS 10.2.
I've tried expressions like:
WTR_NM NOT (NULL, NP)
WTR_MN is the Field Name and I'm trying to remove the unnamed streams.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
The SQL syntax for excluding nulls is slightly different from what is used to exclude normal values. The following should work to my knowledge:
WTR_NM IS NOT NULL AND WTR_NM <> 'NP'
This of course assumes that the NULL values are actually nulls, and not string values simply holding the word "NULL". It's counter-intuitive but the two types are different.