hivemall-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Makoto Yui (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVEMALL-96) Support GeoSpatial (lat/long ops) functions
Date Fri, 23 Jun 2017 10:25:00 GMT

    [ 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)

Mime
View raw message