| | |
|---|
| | | |
|---|
| | | -- 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 *, st_astext(geom) geom from nsl.simu; |
|---|
| | | 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; |
|---|
| | | ---------------------------------------------- 2.推演区域 |
|---|
| | | -- drop table if exists nsl.region; |
|---|
| | | create table nsl.region ( |
|---|
