From 8aa79d9913374a471c80f5855a773850b87f601c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 04 十一月 2022 10:41:31 +0800
Subject: [PATCH] 1
---
data/db_fn.sql | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index 39d027a..a55f8ca 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -276,6 +276,20 @@
select * from lf.sys_domain where dom_name='dlg25gbcode';
select * from bd.dlg_25w_aanp limit 10;
+select * from bd.dlg_25w_agnp
+where ST_Intersects(geom,
+ST_PolygonFromText('POLYGON ((115.94927385452 32.3754479115071 0,121.989371092554 32.2766788010181 0,121.850621222894 29.6874200067864 0,115.9727267226 29.7835368627922 0,115.94927385452 32.3754479115071 0))', 0))
+limit 10;
+select st_srid(geom) from bd.dlg_25w_agnp limit 1;
+select * from bd.dlg_25w_agnp where class != 'BB' limit 1;
+
+
+
+
+
+
+
+
--
Gitblit v1.9.3