Λεπτομέρειες βιβλιογραφικής εγγραφής
| Τίτλος: |
基于 EXCEL VBA 的坐标转换软件开发. (Chinese) |
| Alternate Title: |
Coordinate transformation software development based on EXCEL VBA. (English) |
| Συγγραφείς: |
李振修, 陈洁 |
| Πηγή: |
Oil Geophysical Prospecting / Shiyou Dili Wuli Kantan; 2025 Special Issue, Vol. 60 Issue S1, p121-125, 5p |
| Θεματικοί όροι: |
Coordinate transformations, Computer software development, Petroleum prospecting, Cartesian coordinates, Geographical positions, Microsoft Visual Basic (Computer program language) |
| Γεωγραφικοί όροι: |
Beijing (China) |
| Reviews & Products: |
Microsoft Excel (Computer software) |
| Abstract (English): |
Due to historical reasons, a large number of oil and gas well coordinates, massive seismic data acquisition coordinates, and oil and gas pipeline coordinates in the domestic blocks of mining right are generated and preserved in the format of the Beijing 1954 coordinate system during the process of exploration and development. With the full adoption of the China Geodetic Coordinate System 2000 (CGCS 2000)by the Ministry of Land and Resources (now restructured as the Ministry of Natural Resources), coordinate results of the Beijing 1954 coordinate system are no longer provided. It is objectively necessary to quickly transform coordinate results of the Beijing 1954 coordinate system into those of CGCS 2000 through precise transformation software. To complete the transformation at a low cost, this paper introduces a set of self-developed coordinate transformation software. The commonly used ellip-soids, coordinate systems, and projection parameters are pre-built, and the format conversion, zone changing, and coordinate transformation functions are designed for the coordinate systems. The operator only needs to input the seven transformation parameters between the two coordinate systems, then give the central meridian value of the current zone, select the target coordinate system, and click the transformation button to complete the coordinate transformation in batch. For the 8 groups of representative transformation types supported by the software, the SSoffice software, which is well known in the industry and has a wide range of applications, is selected for one-to-one transformation and comparison. The mutual differences of the north coordinates, east coordinates, and elevations of various types are counted. This software is proved to have high precision and good quality and also provides the function of generating KML files with coordinates of different coordinate systems. [ABSTRACT FROM AUTHOR] |
| Abstract (Chinese): |
由于历史原因, 国内油气田在勘探、开发过程中, 矿权区块中大量油气井坐标、海量地震采集坐标数据、油 气管线坐标成果以北京54坐标系格式产生和保存。随着国土资源部全面使用2000国家大地坐标系(China Geodetic Coordinate System 2000, CGCS 2000), 不再提供北京54坐标系坐标成果, 客观上需要尽快把北京54坐标 系坐标成果通过精密转换软件转换成 CGCS 2000坐标成果。为了低成本完成转换工作, 介绍一款自行开发的 具有针对性的坐标系转换软件。事先内置了常用椭球、坐标系、投影参数, 设计了坐标系内部不同格式之间的转 换、换带、坐标转换等处理功能。操作者仅需通过输入两套坐标系之间的转换7参数, 然后给定所在分带中央经 线值, 选择需转换的目标坐标系, 点击转换按钮即可批量完成坐标转换。 针对本软件转换中具有代表性的8组 类型, 选择业内较熟知、并有较大应用范围的SSo伍ce软件进行一一对应的转换、对比, 统计了各类型的北坐标、 东坐标、高程的互差, 证明本软件精度高、质量好, 同时提供不同坐标系坐标生成KML文件功能. [ABSTRACT FROM AUTHOR] |
|
Copyright of Oil Geophysical Prospecting / Shiyou Dili Wuli Kantan is the property of Editorial Department of Oil Geophysical Prospecting and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) |
| Βάση Δεδομένων: |
Complementary Index |