starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

地理位置函数增强

Open tpolong opened this issue 1 year ago • 5 comments

智慧城市行业,iot有关位置的场景中,需要更强更多的地理位置函数

Feature request

1.增加地理数据类型,支持点、线、面、多点、多线、多面 2.增加如下函数,如果都能完成,可以参考增加postgis一些功能如mvt之类的功能 https://github.com/Esri/spatial-framework-for-hadoop/wiki/UDF-Documentation 3.增加空间索引,空间索引是提升空间函数计算效率的关键

tpolong avatar Apr 24 '24 01:04 tpolong

You can specify functions you need and give more details about the scenario, input and output, is there any other functions in other db systems that sr can refer to.

wangsimo0 avatar Apr 24 '24 06:04 wangsimo0

可以参考duckdb的函数实现,不过还没有规划空间索引,https://github.com/duckdb/duckdb_spatial/blob/main/docs/functions.md

tpolong avatar Apr 24 '24 06:04 tpolong

image image image image

tpolong avatar Apr 24 '24 06:04 tpolong

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!

github-actions[bot] avatar Oct 21 '24 11:10 github-actions[bot]

这个issue有考虑做吗?

tpolong avatar Oct 22 '24 02:10 tpolong

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!

github-actions[bot] avatar Apr 28 '25 11:04 github-actions[bot]