Search code examples
u-sql

Best way to combine spatial data

I have a question regarding spatial data and u-sql. I have a input with polygons and input with points and i want to combine these so that I know in what polygon the point belongs to.

In T sql I would do a left outer join with something like polygon.STintersect(point)= 1

But I suppose that won’t work in u sql. So how can I combine these two inputs?

Solution

  • To summarize the discussion on maya's answer: You currently need to do the join in a combiner or with a CROSS JOIN/WHERE.

    You may also want to file a feature request for native Spatial support at http://aka.ms/adlfeedback.