You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hivemall.apache.org by "Makoto Yui (JIRA)" <ji...@apache.org> on 2017/06/23 10:25:00 UTC
[jira] [Commented] (HIVEMALL-96) Support GeoSpatial (lat/long ops)
functions
[ 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)