SpatialSpark icon indicating copy to clipboard operation
SpatialSpark copied to clipboard

Spatial API wrappers as Spark SQL functions

Open Tagar opened this issue 7 years ago • 1 comments

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

Tagar avatar Mar 07 '17 21:03 Tagar

it is a nice feature, but it beyond the scope of this project. This project is mainly developed for a simple library to deal with spatial joins not a spatial database.

syoummer avatar Mar 08 '17 14:03 syoummer