Spatial Match if | spatial match with a join

Question

Hi Gurus,

I want to do a spatial match, but selectively on geofences that match criteria of a transaction.

I have stream of data with points.

I have a set shapes and I want to find what points occur in what shapes.

Easy enough, using a spatial match using target within universe.

Now I want to compare the stream of data with points, but only against criteria the it shares with the geofence.

I have a stream of sales data with a salesperson has an identifier.

I have a set of geofences which don't overlap among 1 salesperson, but may overlap among all salespeople.

I want to compare the location of the salesperson against only their set of geofences.

If then the location isn't within the universe of their own geofences, I then want to do a find nearest, but again only against their own geofences and not everyones.

The best thing I can think of is a batch macro, but just can't seem to figure out if this makes sense to do when processing 20m records. Will each record going through the batch macro then create a new request to fetch the geofence set of each salespersons geofences?

It's such a simple thing to do in my head, just can't figure out the order of the toolset for this.

thanks in advance,

FkeetGuy · Answer

Thanks for your response

If I have an 18m row data set, and a salesperson has 170 geofences, and 2000 rows of data, it'll baloon quickly and I won't have the resources to process the data.

FkeetGuy · Answer

Thanks for your reply, what you've suggested is actually what I'm doing. but I could have a salesman with 10,000 records and 187 geofences to check, and the next salesmen in the data set might have 300 points and 5 geofences.  plus the added bonus of finding the nearest geofence but only of that salespersons geofences is the next problem to solve.

herry067broof · Answer

Hello, The overhead will kill your performance. Instead, use a Join tool to link your points to your geofences by Salesperson_ID first, then stream that joined data into a Spatial Match tool. Crucially, in the Spatial Match configuration, select the "Group By" option for Salesperson_ID so the engine only compares points against that specific person’s shapes. For anything that doesn't fall inside a fence, take the "Unmatched" output and run it through a Find Nearest tool, again using that "Group By" setting on the ID to keep the search restricted to their CareCredit com own territory. This keeps everything in a single, high-speed stream and avoids the "engine restart" lag of a macro.