Skip to content

Document spatial Left Join #2560

@alexeyegorov

Description

@alexeyegorov

Based on this discussion about spatial joins, I have tried various options to perform a spatial left join.

Currently, we were using the S2 or H3 strategy as we need to perform LEFT JOINs in our setup (not inner joins). However, we figured out a combination of INNER JOIN and a FULL OUTER JOIN to produce a result of a LEFT JOIN by keeping high performance of Sedona spatial join.

A documentation will be updated in the PR.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions