I have a large data set with point data and there are a few points that have null values on certain days (the sites didn't record data for that particular day). I wanted to produce a map using IDW (Geostatistical Analyst tool) for these points on different days but I did not want to the IDW interpolation to include the null values.
How do I ensure this doesn't happen?
Any help would be much appreciated!
Solved! Go to Solution.
You could create a definition query in the point layer (Layer Properties > Definition Query). You could use the Query Builder to write the query.
<FieldName> IS NOT NULL
Then you could run the IDW or other interpolation techniques on the same layer.
You could create a definition query in the point layer (Layer Properties > Definition Query). You could use the Query Builder to write the query.
<FieldName> IS NOT NULL
Then you could run the IDW or other interpolation techniques on the same layer.
Just wanted to say thank you for your help. Much appreciated.
I am glad I could help. You could mark my comment as "Correct Answer", if it resolved the issue. It will help others looking to resolve a similar problem.
Mark a reply as the Correct Answer
You don't have to do anything.
The interpolation tools in Spatial Analyst and Geostatistical Analyst automatically ignore Null values 🙂
-Steve