[I] Distance join between polygons [sedona]

[via GitHub]

remipham opened a new issue, #1789:
URL: https://github.com/apache/sedona/issues/1789

   Hi, 
   
   I'd like to do a distance join between a DataFrame A that has 30M polygons 
and a DataFrame B with 3M polygons. 
   I'd like to get, for each of the polygons of DataFrame A, the ones from 
DataFrame B within 100 meters.
   
   Here's my query:
   
   ```
   SELECT
       a.id,
       b.id,
       ST_Distance(a.polygon_geometry, b.polygon_geometry) as distance,
   FROM
       dataframea as a,
       dataframeb as b
   WHERE
       ST_Distance(a.polygon_geometry, b.polygon_geometry) <= 100;
   
   ```
   
   It seems as the KNNQuery doesn't use the polygons so I had to implement it 
manually. But it takes ages to run this query with not that many rows. Are 
there any ways to optimise it?
   
   Best regards,
   Remi


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@sedona.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org