I feel this blog will be more a test of my knowledge of Alteryx than anything else. The challenge is to name the tools in Alteryx that are capable of spatial analysis that are not part of the default category of spatial tools. The added caveat is I won’t be naming any tools that you need to purchase an additionally package, such as the Address Tools or Demographic Analysis tools.
The first tool is the Map Input tool from the In/Out category which allows the user to digitise on a map creating points, lines or polygons from a reference map.
The formula tool contains over 30 different functions just for spatial analysis and can essentially replace many of the default spatial tools. The formula tool in most cases is the Swiss army knife of any Alteryx workflow. The link provided gives more detail in regards to the functions in the formula tool link.
As the formula tools has spatial functionality the other variants of the formula tools, Multi-Field Formula and Multi-Row Formula also share some of those functions. The Multi-Row formula is quite a powerful tool for spatial analysis when you are calculating distance between points. The Alteryx weekly challenge #26 could be solved with two tools if you utilised the Multi-Row formula.
The Summarize tool is capable of a number of spatial processes such as Combine, Create Intersection, Create Bounding Rectangle, Create Convex Hull and Create centroid. The following link provides more detail in regards to those functions link.
A number of the Reporting tools give the user the ability to create a static map such as the Report Map, Map Legend Builder and Map Legend Splitter. The Report Map tool is intended to be used with other spatial inputs from an Alteryx workflow hence why it’s able to accept multiple spatial inputs, allowing for these inputs to be layered in a thematic map.
This tool display an interactive map for the user to draw or select map objects in an app or macro. I’ve previously used this tool in an app where the user could input a point which was used downstream in the app, to do catchment analysis based on drivetime or straight-line distances.
The dynamic Input tool has a really great feature which is Spatial Filter which uses a polygon object in the incoming data, to determine if latitude and longitude are in the database contained within the object’s bounding rectangle. In my previous role we used this features in a catchment profiler application where the end user would select a point, then I would use this point to create a tradetime area to query against our demographic data to only bring the data to sufficiently do the analysis rather than attempting to bring in demographic data for the whole country which increased the run time of the application.
R Tool and Python Tool
The last tools in this list is the R Tool and Python Tool which both have libraries of tools to work with Spatial Data. There are entire books dedicated to spatial analysis in these code languages showcasing what the capabilities are. As both these tools enable a user to write code scripts you have nearly endless possibilities in term on analysis.