Mark Herrmann Posted April 15, 2020 Share Posted April 15, 2020 Hi there, the 20-Apr-2020 Dr. Spotfire "episode" on "Spatial Joins and Geoanalytics Tips" showed a method how to do spatial joins between hospitals and cities in order to assign a hospital to one or more cities based on its distance to that city. If I got this correctly this was done by computing the distance from every single hospital to every single city and then narrowing the huge list down to distances below a certain threshhold. This seems to be an "expensive" method given that you discard most of the results and in our scenario (which is not geographical but simply thousands of microscopic defects on millions of transistor structures) probably not a promising approach. Instead I was wondering if Spotfire supports spatial queries and joins in Oracle as outlined here Especially a query technique where you could only retrieve the shapes / spatial objects from an Oracle database which are within a given distance from a few thousand defect locations would come in very handy. If anyone's got experience with that or if a follow up in Dr. Spotfire would be possible, that'd be great. Thanks, Mark Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted April 21, 2020 Share Posted April 21, 2020 You can try creating queries using data connectors if you are using Spotfire version above 7.14 https://support.tibco.com/s/article/Custom-queries-with-spatial-data Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now