jiayuasu opened a new pull request, #845:
URL: https://github.com/apache/sedona/pull/845

   
   ## Did you read the Contributor Guide?
   
   - Yes, I have read [Contributor 
Rules](https://sedona.apache.org/latest-snapshot/community/rule/) and 
[Contributor Development 
Guide](https://sedona.apache.org/latest-snapshot/community/develop/)
   
   ## Is this PR related to a JIRA ticket?
   
   - Yes, the URL of the associated JIRA ticket is 
https://issues.apache.org/jira/browse/SEDONA-286. The PR name follows the 
format `[SEDONA-286] my subject`.
   
   ## What changes were proposed in this PR?
   
   1. Added patterns for ST_DistanceSpheroid based join
   2. Expand buffer area by dividing the degree-based distance by `111000` 
(meter). This is based on on the assumption that each latitude degree is 
approximately `111000` meters and each longitude degree ranges from 0 to 111000 
meters.
   
   Now the users can trigger our advanced spatial join algorithms by a 
ST_DistanceSpheroid predicate.
   
   ```
   SELECT *
   FROM df1, df2
   WHERE ST_DistanceSpheroid(df1.geom, df2.geom) < 100
   ``` 
   
   `100` indicates 100 meters.
   
   
   ## How was this patch tested?
   
   Passed new unit tests
   
   ## Did this PR include necessary documentation updates?
   
   - Yes, I have updated the documentation update.


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to