From b2e4845b84b23aa3f9cc01141c74a8a27c56c17a Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 13 三月 2023 10:52:39 +0800 Subject: [PATCH] 1 --- data/db_cx.sql | 5 ++++- 1 files changed, 4 insertions(+), 1 deletions(-) diff --git a/data/db_cx.sql b/data/db_cx.sql index 0743d7c..7d522d6 100644 --- a/data/db_cx.sql +++ b/data/db_cx.sql @@ -17,7 +17,10 @@ update lf.sys_layer set elev=118,cn_name='鍦伴潰灞�' where id=427; -- delete from lf.sys_layer where id=427; -select * from lf.sys_model -- delete from lf.sys_model +-- 28.178 +select * from bd.dlg_25w_boul where ST_Intersects(geom, ST_Buffer(ST_GeomFromText('POINT (101.9281 36.58675)', 4490), 10, 'endcap=round join=round')) limit 20; + +select * from bd.dlg_25w_boul where ST_DWithin(geom, ST_GeomFromText('POINT (101.9281 36.58675)', 4490), 10) = true limit 20; -- Gitblit v1.9.3