|
1.数据导入
导入处理完的excel。
1.1导入点数据
益阳给的数据的X、Y是反着的，地理坐标系为2000，中心轴为112.5011822162
资兴Y坐标 去掉38前缀
1.2导入线数据
线数据生成缺少字段，需要通过连接表添加字段属性
 
1.3数据导出
在确认数据没问题后，可以将数据导出成shape文件
导出到指定的文件夹并做好命名 
2.数据库添加数据
先在测试服查看，清空数据库点表和线表
2.1加载数据
按步骤操作，填充对应字段
在数据库里添加is_deleted、type、flow_type等字段
2.2图层排序查看
手动增加流向，拖动新增线图层，选择flow_type字段，新增类别
污水正向、反向、双向 1-3 蓝色
雨水正向、反向、双向 4-6 绿色
雨污同流正向、反向、双向 7-9
3.发布地图服务
3.1先将数据库注册到gis服务器上
 
3.2发布服务
去重sql
DELETE
FROM
sde.JH_POINT
WHERE
code IN ( SELECT code FROM [sde].[JH_POINT] GROUP BY code HAVING COUNT ( code ) > 1 )
AND OBJECTID NOT IN ( SELECT MIN ( OBJECTID ) FROM sde.JH_POINT GROUP BY code HAVING COUNT ( code ) > 1 )
管线sql
update [sde].[JH_LINE] set is_deleted = 0
update [sde].[JH_LINE] set type = '污水' where code LIKE 'WS%'
update [sde].[JH_LINE] set type = '雨水' where code LIKE 'YS%'
update [sde].[JH_LINE] set type = '雨污合流' where code LIKE 'HS%'
update [sde].[JH_LINE] set age = 1
update [sde].[JH_LINE] set is_open_alarm = 0
update [sde].[JH_LINE] set flow_type = 1 where type = '污水' and flow_directory = 0
update [sde].[JH_LINE] set flow_type =2 where type = '污水' and flow_directory =1
update [sde].[JH_LINE] set flow_type =4 where type = '雨水' and flow_directory =0
update [sde].[JH_LINE] set flow_type =5 where type = '雨水' and flow_directory =1
update [sde].[JH_LINE] set flow_type =7 where type = '雨污合流' and flow_directory =0
|