ArcGIS for Excel - Use Spatial Filter, it will be easy they say...
Use Spatial Filter, it will be easy they say...
In the latest version of ArcGIS for Excel, we introduced a shiny new analysis tool, Spatial filtering. This tool has great capabilities, and this blog will show how to use this new feature.
(You may find this tool under Analysis > Create Spatial Filter, if the option is grayed out, please check your permissions or license level.)
Spatial Filter can create a data layer result containing a copy of the features on a map with criteria based on a spatial query. Spatial filtering can be used with points, lines, or polygons and to successfully run this tool, you will need to select 2 layers to filter and select your filter type.
Step 1 – Choose the layer to filter
Step 2 – Choose the layer to filter by
Step 3 – Choose type of filter: Intersects, does not Intersect, Within Distance, not within Distance or Nearest.
See Usage notes for more
For example, I have added 2 layers. The layer to filter is US Zip codes. The layerto filter by is Public Libraries. I want to find all the public libraries within a specified distance of a US Zip code.
The goal is to determine how many public libraries are available within a 2-mile distance of a zip code.
Result -
Result -
If your Spatial Filtering failed, here are few troubleshooting options to try:
- Ensure coordinate system are the same for both layers
- Spatial filter failed error (generic)
- Currently, some large data may not work
- If it is a server error, the error is shown as-is, troubleshooting can be done from the ArcGIS Online or ArcGIS Enterprise side.
In conclusion, I hope this resource was helpful and at the very least encouraging you to continue to master the latest analysis tool, Spatial Filtering.
We hope you enjoy the latest update and find it useful for your work. If you have any feedback, questions, or issues, please feel free to comment on this blog post.
Thank you for using ArcGIS for Excel. Until next time.
