Model Builder、SQL在林业数据质检和统计汇总中的应用
|
摘要
Model Builder为ArcGIS模型构建器,能够建立非常复杂的模型,利用Model Builder按流程处理多个地理操作步骤,可实现林业空间数据质检的共享。文中以图形检查模型和属性检查模型来介绍Model Builder在林业数据质检中的应用实例,实现了空间数据质检验收从数据导入到结果输出的数据自动处理流程。数据质检合格后,基于SQL语句进行海量数据的统计汇总。文中主要引用了SELECT语句和LEFT JOIN语句,以某县林地"一张图"数据为例,给出了基于SQL统计的应用实例。
As the ArcGIS Model Builder, Model Builder which can build very complex models was used to process multiple geographic operation steps to achieve the sharing of forest spatial data quality inspection.This paper introduced the application of Model Builder in forest data quality inspection by means of graphic inspection model and attribute inspection model, which realized the automatic processing flow of spatial data quality inspection acceptance from data import to result output. After the data quality inspection was passed, the statistical summary of massive data was carried out on SQL. This paper mainly cited the SELECT sentence and the LEFT JOIN sentence, and gave an application example based on SQL statistics with the "one graph" data of a county forest.
As the ArcGIS Model Builder, Model Builder which can build very complex models was used to process multiple geographic operation steps to achieve the sharing of forest spatial data quality inspection.This paper introduced the application of Model Builder in forest data quality inspection by means of graphic inspection model and attribute inspection model, which realized the automatic processing flow of spatial data quality inspection acceptance from data import to result output. After the data quality inspection was passed, the statistical summary of massive data was carried out on SQL. This paper mainly cited the SELECT sentence and the LEFT JOIN sentence, and gave an application example based on SQL statistics with the "one graph" data of a county forest.
引文
[1] 陈伟,周亮,邢庆振.ArcGIS模型构造器在林业矢量化数据中的应用—以新疆兵团第四师六十一团为例[J].现代园代,1997(6):166-167.
[2] 邱中军,段建刚.基于ArcGIS工具箱构建点云数据批处理模型[J].吉林水利,2012(8):7-9.
[3] 刘江涛,吴发富,王建雄,等.基于ArcGIS建模器的数据处理模型在摩洛哥地球化学填图中的应用[J].地质科技情报,2017,36(5):1-6.
[4] 于中伟,邵楠,杨简.基于ArcGIS数据处理的应用研究[J].测绘与空间地理信息,2012(9):87-88.
[5] 张魁,史秋晶.基于模型构建器的矢量数据批量裁剪处理方法研究[J].江苏科技信息,2015(14):51-52.
[6] 邱世平,刘建敏,苏全.一种基于Python与ARCGIS模型构造器的小班四至坐标提取及编号方法[J].林业科技通讯,2016(12):58-60.
[7] 汤国安,杨昕.ArcGIS地理信息系统空间分析实验教程[M].北京:科学出版社,2008.
[8] 倪锡春,范园园,陈永良.基于Model Bulider的城市部件数据库[J].城市勘测,2013(8):45-48.
[9] 陈国栋.Excel SQL语句在企业会计科目汇总中的应用[J].财会月刊,2014(5):81.
[10] 王新平.Excel SQL在工资数据统计和汇总中的应用[J].财会月刊,2015(1):121.
[11] 陈斌.Microsoft Access交叉表的应用研究[J].聊宁师专学报,2006(3):37-40.
[12] 李方元.SQL查询技术在报表统计中的应用[J].电脑开发与应用,2006(9):15.
[13] 萨师煊,王珊.数据库系统概论[M].北京:高等教育出版社,1991.
[14] 李劲,谢兆阳.SQL Sever 2000数据库设计与系统管理[M].北京:清华大学出版社,2001.
[15] 张海健.SQL Sever 2000的管理与应用[M].北京:中国电力出版社,2001.
[16] 李海燕.SQL查询语句使用技巧[J].电脑开发与应用,2002,16(2):39-40.
[2] 邱中军,段建刚.基于ArcGIS工具箱构建点云数据批处理模型[J].吉林水利,2012(8):7-9.
[3] 刘江涛,吴发富,王建雄,等.基于ArcGIS建模器的数据处理模型在摩洛哥地球化学填图中的应用[J].地质科技情报,2017,36(5):1-6.
[4] 于中伟,邵楠,杨简.基于ArcGIS数据处理的应用研究[J].测绘与空间地理信息,2012(9):87-88.
[5] 张魁,史秋晶.基于模型构建器的矢量数据批量裁剪处理方法研究[J].江苏科技信息,2015(14):51-52.
[6] 邱世平,刘建敏,苏全.一种基于Python与ARCGIS模型构造器的小班四至坐标提取及编号方法[J].林业科技通讯,2016(12):58-60.
[7] 汤国安,杨昕.ArcGIS地理信息系统空间分析实验教程[M].北京:科学出版社,2008.
[8] 倪锡春,范园园,陈永良.基于Model Bulider的城市部件数据库[J].城市勘测,2013(8):45-48.
[9] 陈国栋.Excel SQL语句在企业会计科目汇总中的应用[J].财会月刊,2014(5):81.
[10] 王新平.Excel SQL在工资数据统计和汇总中的应用[J].财会月刊,2015(1):121.
[11] 陈斌.Microsoft Access交叉表的应用研究[J].聊宁师专学报,2006(3):37-40.
[12] 李方元.SQL查询技术在报表统计中的应用[J].电脑开发与应用,2006(9):15.
[13] 萨师煊,王珊.数据库系统概论[M].北京:高等教育出版社,1991.
[14] 李劲,谢兆阳.SQL Sever 2000数据库设计与系统管理[M].北京:清华大学出版社,2001.
[15] 张海健.SQL Sever 2000的管理与应用[M].北京:中国电力出版社,2001.
[16] 李海燕.SQL查询语句使用技巧[J].电脑开发与应用,2002,16(2):39-40.