From 049e8125cd972b564c20dcdc153dfec55b6ae810 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 28 十二月 2022 15:54:57 +0800
Subject: [PATCH] 12.28

---
 data/ts.sql |   36 ++++++++++++++++++++++++++++++++++++
 1 files changed, 36 insertions(+), 0 deletions(-)

diff --git a/data/ts.sql b/data/ts.sql
index f06fef8..14f8583 100644
--- a/data/ts.sql
+++ b/data/ts.sql
@@ -97,6 +97,42 @@
 from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid inner join lf.sys_role c on b.roleid = c.id
 where c.id = 15
 
+select *, st_astext(geom) as wkt from bs.m_pipesegment;
+select * from bs.m_pipesegment;
+select gid, pipename, segname from bs.m_pipesegment order by pipename, segname;
+
+select * from bd.dlg_25w_hydl;
+select * from bd.dlg_25w_lrdl;
+select * from bd.dlg_25w_lrrl;
+select * from bd.dlg_25w_hyda;
+
+SELECT a.name as acrossName,
+	   b.segname as segName,
+	   b.remarks,
+	   b.pipename as pipeName,
+	   st_length( st_geographyfromtext( st_astext( st_intersection( ST_MakeValid(a.geom), ST_MakeValid(b.geom) ) ) ) ) AS acrossLength,
+	   st_astext(b.geom) as wkt
+FROM bd.dlg_25w_hyda AS a,
+	 (SELECT *
+	  FROM bs.m_pipesegment
+	  WHERE segname = 'DD' ) AS b
+WHERE ST_Intersects(a.geom, b.geom)
+
+select a.name as acrossName, b.segname as segName, b.remarks, b.pipename as pipeName,
+  cast( st_length( st_geographyfromtext( st_astext( st_intersection(ST_MakeValid(a.geom), ST_MakeValid(b.geom) ) ) ) ) as decimal(12, 3) ) AS acrossLength,
+  st_astext( st_intersection( ST_MakeValid(a.geom), ST_MakeValid(b.geom) ) ) as wkt
+from bd.dlg_25w_hyda as a, (select segname, remarks, pipename, geom from bs.m_pipesegment where gid = 24) as b
+where ST_Intersects(a.geom, b.geom)
+
+
+
+
+
+
+
+
+
+
 
 
 

--
Gitblit v1.9.3