三调数据库标注插件v1.3

2022-08-20 11:49:08

三调数据库标注插件

插件介绍：

本插件基于VS2010+ARCGIS Addin 开发，高效率处理三调数据，可以标注相关属性、检查尖角、检查节点平均密度、检查地类图斑属性一致性，方便数据导入建库软件之前，保证属性的正确性（好处：属性检查完成修改完成，导入建库系统，建库系统导出VCT,利用国家质检软件检查VCT,可以保证地类图斑属性正确性，减少反复导入导出繁琐过程）

v1.3更新说明

将ArcGIS一键计算模型通过代码移植到本插件，只需一键就可以计算地类图斑所有属性值。特点：本功能通过代码连接GDB数据库，通过写SQL语言执行的形式去更新数据库（省去了繁琐的属性计算步骤，且不会计算遗漏），执行速度杠杠的！

操作步骤：

1、点击一键计算所有属性，弹出计算对话框

2、点击打开GDB按钮，选择GDB数据库

3、选择地类图斑

4、执行“一键计算”

计算完成：

软件内部执行的SQL语句代码如下：

update DLTB set TBMJ=0;
update DLTB set KCDLBM='';
update DLTB set KCXS=0.0;
update DLTB set KCMJ=0.0;
update DLTB set TBDLMJ=0.0;
update DLTB set GDLX='';
update DLTB set TBXHMC='';
update DLTB set ZZSXMC='';
update DLTB set FRDBS='0';
update DLTB set SJNF=2019;
update DLTB set MSSM='00';
update DLTB set BZ='';
update DLTB set GDPDJB='' where DLBM not like '01%';
update DLTB set KCDLBM='1203' where DLBM like '01%' and GDPDJB in ('2','3','4','5');
update DLTB set GDLX='PD' where DLBM in ('0102','0103') and GDPDJB in ('2','3','4','5');
update DLTB set GDLX='TT' where DLBM ='0101' and GDPDJB in ('2','3','4','5');
update DLTB set XZDWKD=0.0 where DLBM not in ( '1001','1002','1003','1004','1006','1009','1107','1107A','1107a','1101');
update DLTB set GDDB=1 where DLBM like '01%';
update DLTB set GDDB=0 where DLBM not like '01%';
update DLTB set DLMC='物流仓储用地' where DLBM='0508';
update DLTB set DLMC='商业服务业设施用地' where DLBM='05H1';
update DLTB set DLMC='工业用地' where DLBM='0601';
update DLTB set DLMC='采矿用地' where DLBM='0602';
update DLTB set DLMC='盐田' where DLBM='0603';
update DLTB set DLMC='城镇住宅用地' where DLBM='0701';
update DLTB set DLMC='农村宅基地' where DLBM='0702';
update DLTB set DLMC='公用设施用地' where DLBM='0809';
update DLTB set DLMC='公园与绿地' where DLBM='0810';
update DLTB set DLMC='广场用地' where DLBM='0810A';
update DLTB set DLMC='机关团体新闻出版用地' where DLBM='08H1';
update DLTB set DLMC='科教文卫用地' where DLBM='08H2';
update DLTB set DLMC='高教用地' where DLBM='08H2A';
update DLTB set DLMC='特殊用地' where DLBM='09';
update DLTB set DLMC='铁路用地' where DLBM='1001';
update DLTB set DLMC='轨道交通用地' where DLBM='1002';
update DLTB set DLMC='公路用地' where DLBM='1003';
update DLTB set DLMC='城镇村道路用地' where DLBM='1004';
update DLTB set DLMC='交通服务场站用地' where DLBM='1005';
update DLTB set DLMC='机场用地' where DLBM='1007';
update DLTB set DLMC='港口码头用地' where DLBM='1008';
update DLTB set DLMC='管道运输用地' where DLBM='1009';
update DLTB set DLMC='水工建筑用地' where DLBM='1109';
update DLTB set DLMC='空闲地' where DLBM='1201';
update DLTB set DLMC='水田' where DLBM='0101';
update DLTB set DLMC='水浇地' where DLBM='0102';
update DLTB set DLMC='旱地' where DLBM='0103';
update DLTB set DLMC='果园' where DLBM='0201';
update DLTB set DLMC='茶园' where DLBM='0202';
update DLTB set DLMC='橡胶园' where DLBM='0203';
update DLTB set DLMC='其他园地' where DLBM='0204';
update DLTB set DLMC='乔木林地' where DLBM='0301';
update DLTB set DLMC='竹林地' where DLBM='0302';
update DLTB set DLMC='红树林地' where DLBM='0303';
update DLTB set DLMC='森林沼泽' where DLBM='0304';
update DLTB set DLMC='灌木林地' where DLBM='0305';
update DLTB set DLMC='灌丛沼泽' where DLBM='0306';
update DLTB set DLMC='其他林地' where DLBM='0307';
update DLTB set DLMC='天然牧草地' where DLBM='0401';
update DLTB set DLMC='沼泽草地' where DLBM='0402';
update DLTB set DLMC='人工牧草地' where DLBM='0403';
update DLTB set DLMC='农村道路' where DLBM='1006';
update DLTB set DLMC='水库水面' where DLBM='1103';
update DLTB set DLMC='坑塘水面' where DLBM='1104';
update DLTB set DLMC='养殖坑塘' where DLBM='1104A';
update DLTB set DLMC='沟渠' where DLBM='1107';
update DLTB set DLMC='干渠' where DLBM='1107A';
update DLTB set DLMC='设施农用地' where DLBM='1202';
update DLTB set DLMC='田坎' where DLBM='1203';
update DLTB set DLMC='其他草地' where DLBM='0404';
update DLTB set DLMC='河流水面' where DLBM='1101';
update DLTB set DLMC='湖泊水面' where DLBM='1102';
update DLTB set DLMC='沿海滩涂' where DLBM='1105';
update DLTB set DLMC='内陆滩涂' where DLBM='1106';
update DLTB set DLMC='沼泽地' where DLBM='1108';
update DLTB set DLMC='冰川及永久积雪' where DLBM='1110';
update DLTB set DLMC='盐碱地' where DLBM='1204';
update DLTB set DLMC='沙地' where DLBM='1205';
update DLTB set DLMC='裸土地' where DLBM='1206';
update DLTB set DLMC='裸岩石砾地' where DLBM='1207';
update DLTB set ZZSXMC='种植粮食作物' where ZZSXDM='LS';
update DLTB set ZZSXMC='种植非粮食作物' where ZZSXDM='FLS';
update DLTB set ZZSXMC='粮与非粮轮作' where ZZSXDM='LYFL';
update DLTB set ZZSXMC='未耕种' where ZZSXDM='WG';
update DLTB set ZZSXMC='休耕' where ZZSXDM='XG';
update DLTB set ZZSXMC='林粮间作' where ZZSXDM='LLJZ';
update DLTB set ZZSXMC='即可恢复' where ZZSXDM='JKHF';
update DLTB set ZZSXMC='工程恢复' where ZZSXDM='GCHF';
update DLTB set TBXHMC='河道耕地' where TBXHDM='HDGD';
update DLTB set TBXHMC='湖区耕地' where TBXHDM='HQGD';
update DLTB set TBXHMC='林区耕地' where TBXHDM='LQGD';
update DLTB set TBXHMC='牧区耕地' where TBXHDM='MQGD';
update DLTB set TBXHMC='沙荒耕地' where TBXHDM='SHGD';
update DLTB set TBXHMC='石漠化耕地' where TBXHDM='SMGD';
update DLTB set TBXHMC='林区种植园用地' where TBXHDM='LQYD';
update DLTB set TBXHMC='灌丛草地' where TBXHDM='GCCD';
update DLTB set TBXHMC='火电工业用地' where TBXHDM='HDGY';
update DLTB set TBXHMC='钢铁工业用地' where TBXHDM='GTGY';
update DLTB set TBXHMC='煤炭工业用地' where TBXHDM='MTGY';
update DLTB set TBXHMC='水泥工业用地' where TBXHDM='SNGY';
update DLTB set TBXHMC='玻璃工业用地' where TBXHDM='BLGY';
update DLTB set TBXHMC='电解铝工业用地' where TBXHDM='DLGY';
update DLTB set TBXHMC='废弃' where TBXHDM='FQ';