更新需求库数据
update npas.de_cover_point set coverage_range='楼层全覆盖' ,average_floor_num=30,demand_reason='投诉弱覆盖补点',demand_type_key='440000108015' where site_requirement_code='潮州_LTE_室分新建_20200813_94701'; update npas.de_cover_point set coverage_range='楼层全覆盖' ,average_floor_num=7,demand_reason='投诉弱覆盖补点',demand_type_key='440000108015' where site_requirement_code='潮州_LTE_室分新建_20200730_94116'; update npas.de_cover_point set coverage_range='楼层全覆盖' ,average_floor_num=32,demand_reason='投诉弱覆盖补点',demand_type_key='440000108015' where site_requirement_code='潮州_LTE_室分新建_20200922_95574'; update npas.de_cover_point set coverage_range='楼层全覆盖' ,average_floor_num=28,demand_reason='投诉弱覆盖补点',demand_type_key='440000108015' where site_requirement_code='潮州_LTE_室分新建_20200922_95573'; 更新建设批次失效 update npas.pl_cover_point set construction_batch_key=null where site_planning_id='PL_20201125_000141'; update npas.pl_cover_point set construction_batch_key=null where site_planning_id='PL_20201125_000144'; update npas.pl_cover_point set construction_batch_key=null where site_planning_id='PL_20201130_000329'; update npas.pl_cover_point set construction_batch_key=null where site_planning_id='PL_20200717_000346'; update npas.pl_cover_point set construction_batch_key=null where site_planning_id='PL_20200904_000717';
规划经纬度
update npas.pl_cover_point set planning_geopoint = ST_GeomFromText('POINT(110.939416 21.626311)', 4326) where site_planning_id = 'PL_20201123_000033';