PostgreSQL-Distance
create table pt_tmp(
id int,
pt geometry);insert into pt_tmp values
(1,'point(1 1)'),(2,'point(2 1)'),(3,'point(2 7)');计算欧式距离:select p1.id as id1,p2.id as id2,st_distance(p1.pt,p2.pt)
from pt_tmp p1,p...
原创
2018-04-23 10:15:58 ·
1099 阅读 ·
0 评论