sanya-data-management-back

sanya-data-management-back

实景三维三亚后台管理系统

数据处理

1.污水厂数据

1.污水处理厂的数据，需要提供空间字段，缓冲区字段 2.通过缓冲区字段生成缓冲区导入到数据库 3.4326数据导入库中，执行

CREATE TABLE "TB_WSC" AS SELECT ID
,
PUBLIC.ST_Buffer ( geom :: PUBLIC.geography, wsfhjl ) :: PUBLIC.geometry AS geom,
mc,
yjjsgm,
wsfhjl
FROM
"TB_WSC1"
WHERE
geom IS NOT NULL;

2.插入表格数据

INSERT INTO "base"."t_table" ( "id", "table_name", "table_describe", "table_type", "is_exist", "create_time", "delete_time", "create_user_id", "delete_user_id", "version" )
VALUES
( replace(uuid_generate_v4()::text, '-', ''), 'TB_WSC', '污水处理场', 0, 0, now(), NULL, '1', NULL, '20240716172001' );

INSERT INTO "base"."t_fzss_fzxz_factor" ("id", "bsm", "level", "parent_id", "status", "condition_info", "name", "order_index") VALUES ('5e008c3250', '', 0, '', 2, '""', '防控因子', '1'); INSERT INTO "base"."t_fzss_fzxz_factor" ("id", "bsm", "level", "parent_id", "status", "condition_info", "name", "order_index") VALUES ('2e0e51252d', '', 0, '', 2, '""', '地形因子', '2');