From d29863abcfc8166d3b0e2f82a6a6eea9e41b9fcc Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 30 十二月 2022 09:55:10 +0800
Subject: [PATCH] 12.30.1

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

diff --git a/data/ts.sql b/data/ts.sql
index b67e578..2b2b4f1 100644
--- a/data/ts.sql
+++ b/data/ts.sql
@@ -125,13 +125,13 @@
 	  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,
+select row_number() over() as gid, 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)
 
-select * from lf.sys_download where type=4;
+select * from lf.sys_download where type = 5;
 select * from bs.m_pipesegment;
 
 

--
Gitblit v1.9.3