How do I 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)
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
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
I beat my brains about this one. The field name is "ASSETID", it is either a value or NULL. But actually the field was a text field (KML). I tried..
"ASSETID" ISNULL, "ASSETID" IS NULL, ISNULL("ASSETID"), "ASSETID" = "" NOTHING WORKED!
"ASSETID" = '', "ASSETID" IN ('') did work also for search "ASSETID" in ('2251', '4321' etc)
Archaic but workable.
Pedonal = ''