From d8a1ab25881275da008b2801119f36b51554f427 Mon Sep 17 00:00:00 2001
From: wuww <252740454@qq.com>
Date: 星期日, 04 五月 2025 11:11:30 +0800
Subject: [PATCH] 修改初始化方案参数
---
data/init.sql | 21 ++++++++++++++++++---
1 files changed, 18 insertions(+), 3 deletions(-)
diff --git a/data/init.sql b/data/init.sql
index a7dbb76..56fe366 100644
--- a/data/init.sql
+++ b/data/init.sql
@@ -45,8 +45,8 @@
-- insert into nsl.simu (name, service_name, type, area_type, area_name, status, geom) values ('棰勬祴妯℃嫙-0416', '20250416100000', 1, 1, '澶у叴鍖�', 0, ST_GeomFromText('MULTIPOLYGON(((116.666748 39.639859,116.659403 39.626287,116.665956 39.654698,116.666748 39.639859)))'));
-select id, name, service_name, type, area_type, area_name, status, result, create_time, create_user, update_time, update_user, bak, data, st_astext(geom) geom from nsl.simu order by id desc;
--- update nsl.simu set status = 0, area_name = '鎴垮北鍖�' where id = 24;
+select id,name,service_name,type,area_type,area_name,status,result,create_time,update_time,bak,data,st_astext(geom) from nsl.simu where id > 0 order by id desc;
+-- update nsl.simu set status = 0, area_name = '鎴垮北鍖�', data = '{"startTime":"2025-05-01 11:10:54","type":3,"total":50,"duration":6,"intensity":70,"history":"XX骞�50mm闄嶉洦"}' where id = 24;
---------------------------------------------- 2.鎺ㄦ紨鍖哄煙
-- drop table if exists nsl.region;
create table nsl.region (
@@ -85,6 +85,21 @@
comment on column nsl.udometer.geom is '绌洪棿浣嶇疆';
select * from nsl.udometer;
-----------------------------------------------
+---------------------------------------------- 灏� MULTIPOLYGON 杞崲涓� POLYGON
+select st_astext(ST_GeometryN(geom, generate_series(1, ST_NumGeometries(geom)))) as geom from nsl.region limit 1;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
--
Gitblit v1.9.3