汪永华,蔚远江,张倩,等. 基于Python的油气行业ArcGIS数据库空值运算方法及应用[J]. 中国矿业,2023,32(7):87-94. DOI: 10.12075/j.issn.1004-4051.20230007
    引用本文: 汪永华,蔚远江,张倩,等. 基于Python的油气行业ArcGIS数据库空值运算方法及应用[J]. 中国矿业,2023,32(7):87-94. DOI: 10.12075/j.issn.1004-4051.20230007
    WANG Yonghua,YU Yuanjiang,ZHANG Qian,et al. Method and application of null value calculation in ArcGIS database of oil and gas industry based on Python[J]. China Mining Magazine,2023,32(7):87-94. DOI: 10.12075/j.issn.1004-4051.20230007
    Citation: WANG Yonghua,YU Yuanjiang,ZHANG Qian,et al. Method and application of null value calculation in ArcGIS database of oil and gas industry based on Python[J]. China Mining Magazine,2023,32(7):87-94. DOI: 10.12075/j.issn.1004-4051.20230007

    基于Python的油气行业ArcGIS数据库空值运算方法及应用

    Method and application of null value calculation in ArcGIS database of oil and gas industry based on Python

    • 摘要: ArcGIS软件Geodatabase数据库已成为世界知名石油公司必用分析工具和制图平台,但其中大量存在着一些不完全信息数据(或缺失数据),并以空值形式存在,解决其导致的数据处理中“空值数据运算出错”问题,对各类油气储量统计分析与编图等科研和生产意义重大。在调研分析和对比常见的五种空值处理方法基础上,结合GDB关系数据库中属性所代表的实际意义和空值转换思想,提出了油气领域GDB数据库空值运算的四步流程和一种新的面向ArcGIS10.0以上的Python编程脚本。基于ArcGIS软件二次开发语言,开展了VB语句、Shapefile格式VB语句、Python语句三种方法的部分数据空值运算实验,结果展示了Python脚本的可行性,进而评价选定了较为适用的Python语句空值运算方法。将其应用于全球32 799个油气田数据的运算结果表明,Python语句空值运算方法可行,运算结果正确,并可应用至其他类型、领域和行业有空值的数据运算之中,提高了工作效率,保证了分析数据的正确与完整。

       

      Abstract: ArcGIS software Geodatabase database has become a necessary analysis tool and mapping platform for world famous oil companies, but there are a lot of incomplete information data (or missing data) and exist in the form of null value, which is of great significance to scientific research and production such as statistical analysis and mapping of various oil and gas reserves and to solve the problem of “null value data operation error” in data processing caused by it. On the basis of investigation, analysis and comparison of five common null value processing methods, combined with the practical significance of attributes in GDB relational database and the idea of null value conversion, a four-step process of null value calculation in GDB database in oil and gas field and a new Python programming script oriented to ArcGIS10.0 and above are proposed. Based on the secondary development language of ArcGIS software, experiments on partial data null value operation using VB statements, Shapefile format VB statements, and Python statements are carried out. The experimental results prove the feasibility of Python scripts, and then evaluated and selected a more applicable Python statement null value operation method. Its application to 32 799 oil and gas fields around the world shows that the Python statement null value operation method is feasible, the operation result is correct, and can be applied to data operations with null values in other types, fields and industries, which improves the work efficiency and ensures the correctness and integrity of the analysis data.

       

    /

    返回文章
    返回