From 2d5e75d867cf77c8004907ccbe606561df3549ff Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 13 三月 2023 11:11:41 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 7d522d6..eadbd06 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -18,9 +18,7 @@
-- delete from lf.sys_layer where id=427;
-- 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;
@@ -37,6 +35,10 @@
---------------------------------------------------------------------------------------------- 00.SQL鏌ヨ
+-- 缂撳啿鍖烘煡璇�
+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;
+
select id,cn_name,en_name,url,serve_type,data_type from lf.sys_layer where url is not null and
serve_type='WMS' and data_type in ('宸ョ▼椤圭洰','宸ョ▼椤圭洰-鍦扮伨绫�','宸ョ▼椤圭洰-娴嬮噺绫�','宸ョ▼椤圭洰-娲炲簱绫�','宸ョ▼椤圭洰-鍕樺療绫�') order by id;
--
Gitblit v1.9.3