Jump to content

Does Spotfire support spatial queries and joins

Mark Herrmann

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...