I would like the ability to be able to spatially relate tables within Spotfire. Currently, in order to achieve this functionality I either have to leverage spatial SQL on the backend or assign a geospatial key to my two different tables which allows for me to pass the marking from the feature layer to a data table and thus create a detailed visualization based on the making of the map with the data in the data table.
As a simple example, I'd like to be able to select a polygon feature (e.g. a section in a land grid) and be able to geospatially link that to a point feature (e.g. well surface locations) to generate a details visualization of the wells table where all those well heads fall within the selected polygon.
As a further template of what could be useful would be to provide functionality similar to the spatialSQL commands such as .STIntersects(), STArea(), etc.
This is achievable today using a points in polygon data function.
Using this function, each point in a table of locations defined by Latitude and Longitude coordinates, identify its corresponding enclosing polygon contained in a separate table. A new column is then returned that contains the enclosing polygon identifier to append to the point location table.
Many of our energy customers are requesting this feature.
Please add!