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] [Comment Edited] (HIVEMALL-96) Support GeoSpatial (lat/long ops) functions
Date Thu, 27 Apr 2017 09:13:04 GMT

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

Makoto Yui edited comment on HIVEMALL-96 at 4/27/17 9:12 AM:
-------------------------------------------------------------

Add x_tile and y_tile as well for custom formatting.

{code}
WITH data (
  select 'http://cyberjapandata.gsi.go.jp/xyz/std/%d/%d/%d.png' fmt, 35.4439029 lat, 139.1416358
lon, 15 as zoom
)
select
  printf(fmt, x_tile(lat, zoom), y_tile(lon, zoom), zoom);
{code}

http://cyberjapandata.gsi.go.jp/xyz/std/16/58097/25859.png


was (Author: myui):
Add x_tile and y_tile as well for custom formatting.

{code}
WITH data (
  select 'http://cyberjapandata.gsi.go.jp/xyz/std/%d/%d/%d.png' fmt, 35.4439029 lat, 139.1416358
lon, 15 as zoom
)
select
  printf(fmt, x_tile(lat, zoom), y_tile(lon, zoom), zoom);
{code}

> 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.3.15#6346)

Mime
View raw message