Jump to content

 
Photo

Selecting Null values in ArcMap

- - - - -

  • Please log in to reply
4 replies to this topic

#1
tellett

tellett

    Contributor

  • Validated Member
  • PipPip
  • 11 posts
  • Gender:Male
  • Location:Milton Keynes
  • Interests:Mapping (obviously!!)<br />Photography<br />Music<br />Travelling<br />Sport
  • United Kingdom

Hello all, I have a problem selecting null values in ArcMap.

Essentially, what I am trying to do is compare an updated dataset with the original.
The way I am doing this is too join the two tables and then simply select the rows
where there are null values (which is what arc puts in fields when rows cannot be
matched). The value in the fields is actually <NULL>, but I assume thats the same
as null. So my query is:

SELECT * from Table where Field IS NULL

But its not selecting the row. I am most confused and frustrated!!

Thanks in advance for the answer!!!!

#2
Matthew Hampton

Matthew Hampton

    Hall of Fame

  • Moderator
  • PipPipPipPipPipPipPip
  • 1,303 posts
  • Gender:Male
  • Location:Portland, Oregon
  • Interests:Playing in the mountains and rivers.
  • United States

I copied this from 9.2-Help.


"The NULL keyword
You can use the NULL keyword to select features and records that have null values for the specified field. The NULL keyword is always preceded by IS or IS NOT.

For example, to find cities whose 1996 population has not been entered, you can use

"POPULATION96" IS NULL"

co-cartographic creator of boringmaps.com


#3
ELeFevre

ELeFevre

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 1,049 posts
  • Gender:Male
  • Location:Louisville, Colorado USA
  • Interests:Cartography, musical instruments, reading, hiking, craft beer
  • United States

This might provide a little insight into your problem. "How can I select only the null values on a joined table?"



#4
tellett

tellett

    Contributor

  • Validated Member
  • PipPip
  • 11 posts
  • Gender:Male
  • Location:Milton Keynes
  • Interests:Mapping (obviously!!)<br />Photography<br />Music<br />Travelling<br />Sport
  • United Kingdom

Thanks for your help everybody, but none of it seems to work unfortunately.
What I've done is do 'is not null', which selects all the records I don't want,
and then simply invert the selection. A quick run around in the face of
overwhelming illogic!!!

#5
David T

David T

    GIS Manager, USMC, MCIWEST-MCB Camp Pendleton

  • Validated Member
  • PipPipPipPip
  • 192 posts
  • Gender:Male
  • Location:San Diego, California
  • United States

Well, <Null>, if that's what is actually in the field (as opposed to no information in the field), is a text string. So you would need to select for '<Null>'.
David Toney, GISP
GIS Manager
United States Marine Corps
West Coast Installations




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->