postgresql
温水煮蚂蚁
不进则退
展开
-
postgresql安装postgis扩展模块
为postgresql安装postgis扩展模块:1、安装postgis2、在指定数据库下执行下面语句CREATE EXTENSION postgis3、验证:执行下面语句不报错即可SELECT ST_SetSRID(ST_Point(-87.71,43.741),4326),ST_GeomFromText('POINT(-87.71 43.741)',4326)...原创 2018-05-31 11:45:54 · 19987 阅读 · 4 评论 -
postgresql计算两点距离
postgresql计算两点距离下面两种方法:select ST_Distance( ST_SetSRID(ST_MakePoint(115.97166453999147,28.716493914230423),4326)::geography, ST_SetSRID(ST_MakePoint(106.00231199774656,29.719258550486572),4326)::geo...原创 2018-05-31 13:58:21 · 8986 阅读 · 4 评论