search

AllanHao / blog-comments

博客评论
0 stars 0 forks source link

PostGIS 查找最近点 — Allan #3

Open AllanHao opened 6 years ago

AllanHao commented 6 years ago

https://allanhao.com/2018/04/20/PostGIS-%E6%9F%A5%E6%89%BE%E6%9C%80%E8%BF%91%E7%82%B9/

从PostGIS 2.0开始，geometry 类型的数据支持KNN算法。下面的例子示范查找最近点关于<->,详见PostgreSQL manual