[ 
https://issues.apache.org/jira/browse/HIVEMALL-96?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16060698#comment-16060698
 ] 

Makoto Yui commented on HIVEMALL-96:
------------------------------------

Create the following UDFs.
 
{code}
lat2tile(lat), lon2tile(lon), tile2lat(xtile), tile2lon(ytile), 
latlon_distance(lat1, lon1, lat2, lon2)
{code}

https://stackoverflow.com/questions/27928/calculate-distance-between-two-latitude-longitude-points-haversine-formula

> Support GeoSpatial (lat/long ops) functions
> -------------------------------------------
>
>                 Key: HIVEMALL-96
>                 URL: https://issues.apache.org/jira/browse/HIVEMALL-96
>             Project: Hivemall
>          Issue Type: New Feature
>            Reporter: Makoto Yui
>            Assignee: Makoto Yui
>            Priority: Minor
>
> Tile by lat/long
> http://wiki.openstreetmap.org/wiki/Slippy_map_tilenames#Java
> ESRI geometry api for Java
> https://github.com/Esri/geometry-api-java
> ESRI Spatial functions for Hive
> https://github.com/Esri/spatial-framework-for-hadoop



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to