Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 5 down vote favorite
1

I need to identify which features have null attributes in the attribute table of a shapefile. When i try [field]= 'NULL' it selects the features with value=0 (see picture)enter image description here

Suggestions?

share|improve this question
It may be a bug. I'll check and let you know, eventually I will link you the ticket URL. Stay tuned. – Giovanni Manghi Oct 24 '11 at 15:26

2 Answers

up vote 8 down vote accepted

Have you tried replacing the "=" with "is"? I don't have QGIS in front of me, but that is pretty common database select syntax for working with NULL values.

pedonal is NULL
share|improve this answer
up vote -2 down vote

Try:

Pedonal = ''

  • that should work!
share|improve this answer
that works for text fields...i'm using numerical fields, and that selects values = to 0 – vascobnunes Oct 24 '11 at 15:48
1  
@Darren Cope, NULL is different than "" – artwork21 Oct 25 '11 at 14:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.