# sanya-data-management-back 实景三维三亚后台管理系统 1 # 数据处理 ## 1.污水厂数据 1.污水处理厂的数据,需要提供空间字段,缓冲区字段 2.通过缓冲区字段生成缓冲区导入到数据库 3.4326数据导入库中,执行 ```angular2html 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.插入表格数据 ```sql 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 ('5e008c32506b47ffb1ea83009aba1ed2', '', 0, '', 2, '""', '防控因子', '1'); INSERT INTO "base"."t_fzss_fzxz_factor" ("id", "bsm", "level", "parent_id", "status", "condition_info", "name", "order_index") VALUES ('2e0e51252d7e46a697edf8b97dbd0bce', '', 0, '', 2, '""', '地形因子', '2');