SpatialSpark
SpatialSpark copied to clipboard
Spatial API wrappers as Spark SQL functions
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
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.