Hello,
I am relatively new to GIS an have been working on hot spot mapping recently with some success. However, I have recently been having problems with null data fields created during a spatial join.
First, I'll briefly explain my process. First a create a fishnet grid, then I join my point data to the grid based on spatial location. This groups close data points together on the grid and gives areas of the grid where there is no point data a "count" of zero. After that I run the hot spot analysis and then use the IDW tool to create a hot spot raster. This process worked well for me and resulted in some nice maps.
Recently, whenever I have tried to spatially join the point data to the grid, any part of the grid where there is no point data to be joined gets a "count" of null, which leads to a hot spot map that is a lot more confusing and questionable. I will attach examples of these differences.
What I am wanting to do is have all the empty cells in the attribute table to have zeros instead of nulls. Like I said, I am pretty new to GIS mapping so this could likely be something simple I have overlooked or a setting I accidentally changed. Any help would be appreciated!
Thanks
