Skip to content

Spatial API wrappers as Spark SQL functions #19

@Tagar

Description

@Tagar

It would be awesome to add Spark SQL wrapper functions to Spatial Spark, so it would be possible to use someting like in Oracle Spatial:

https://docs.oracle.com/database/122/SPATL/complex-spatial-queries.htm#SPATL-GUID-C4BE15BF-04AC-41EC-BEE1-F6DDA2A29E79

SELECT c.city,
       sdo_nn_distance (1) distance_in_miles
FROM geod_interstates i, 
     geod_cities c 
WHERE i.highway = 'I170'
  AND sdo_nn(c.location, i.geom,
             'sdo_num_res=5 unit=mile', 1) = 'TRUE'
ORDER BY distance_in_miles

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions