From 1f646399b643c8350535be9a4b0dea10032c3031 Mon Sep 17 00:00:00 2001
From: wuww <252740454@qq.com>
Date: 星期三, 16 四月 2025 10:31:35 +0800
Subject: [PATCH] 添加区域、模拟的控制器
---
data/init.sql | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/data/init.sql b/data/init.sql
index 59cebd4..be5e868 100644
--- a/data/init.sql
+++ b/data/init.sql
@@ -41,7 +41,9 @@
comment on column nsl.simu.bak is '澶囨敞';
comment on column nsl.simu.geom is '绌洪棿浣嶇疆';
-select * from nsl.simu;
+-- insert into nsl.simu (name, service_name, type, area_type, 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 *, st_astext(geom) geom from nsl.simu;
---------------------------------------------- 2.鎺ㄦ紨鍖哄煙
-- drop table if exists nsl.region;
create table nsl.region (
@@ -59,7 +61,9 @@
comment on column nsl.region.type is '绫诲埆锛�1-琛屾斂鍖哄垝锛�2-閲嶇偣鍖哄煙锛�3-閲嶇偣娌�';
comment on column nsl.region.geom is '绌洪棿浣嶇疆';
-select * from nsl.region;
+-- insert into nsl.region (name, type, geom) values ('澶у叴', 1, ST_GeomFromText('MULTIPOLYGON(((116.666748 39.639859,116.659403 39.626287,116.665956 39.654698,116.666748 39.639859)))'));
+
+select id, name, type, st_astext(geom) from nsl.region order by id;
---------------------------------------------- 3.闆ㄩ噺璁� *
-- drop table if exists nsl.udometer;
create table nsl.udometer (
--
Gitblit v1.9.3