mapgis钻孔柱状图自动成图方法

mapgis钻孔柱状图自动成图方法一、原理
Mapgis中的点、线可以通过明码转换的方式生成，明码文件中只要表明钻孔柱状图中需要的点和线在图中的位置和格式，就可以利用mapgis中文件转换功能转换成钻孔柱状图的点和线，从而达到自动生成钻孔柱状图的目的。

二、所使用的软件
excel，mapgis，vf6.0，6.prg和66.prg
三、使用说明
1、准备工作
成钻孔柱状图首先需要岩芯鉴定本和测井，在此定名两个文件分别命名为：岩性统计.xls和测井柱状.xls
（1）岩性柱状.xls文件格式，
注：A列代表层号；B列代表岩层名称；C列代表岩层底深；D 列代表岩层厚度；E列代表取芯长度；F列代表取芯率；G列代表岩层倾角；H列代表岩性描述。

注意在岩性描述里不能出现英文半角字符。

（2）测井柱状.xls文件格式
注：A列代表岩层名称；B列代表岩层底深；C列代表岩层厚度。

做好上面两个文件后保存在F:\vp柱状\文件夹里。

2、生成柱状图点和线文件的明码格式
在VF6.0中运行6.prg程序，从而产生点、线文件的明码格式文件。

运行中需要输入变比例深度，此深度最好填终孔深度。

运行结束后会依次显示两个文件，分别为注释.txt和柱状.txt。

（1）注释.txt文件
此文件为柱状图中点文件的明码文件，格式如下：
a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p
217.50,-55.60,1,0,"1",3,3.00,0,0,0,0,0,0,1,2,0
53.39,-54.30,2,0,"",4,3.50,0,0,0,0,0,0,1,2,0
130.24,-54.30,3,0,"砂质粘土",4,3.50,0,0,0,0,0,0,1,2,0
183.20,-54.30,4,0,"5.30",4,3.50,0,0,0,0,0,0,1,2,0
195.85,-54.30,5,0,"5.30",4,3.50,0,0,0,0,0,0,1,2,0
211.00,-54.30,6,0,"1",4,3.50,0,0,0,0,0,0,1,2,0
217.50,-58.90,7,0,"2",3,3.00,0,0,0,0,0,0,1,2,0
53.39,-63.60,8,0,"",4,3.50,0,0,0,0,0,0,1,2,0
130.24,-63.60,9,0,"粉砂",4,3.50,7,0,0,0,0,0,1,2,0
……………………
259.87,-1699.96,1768,0,"827.58",3,3.00,0,0,0,0,0,0,1,2,0
275.20,-1699.96,1769,0,"29.50",3,3.00,0,0,0,0,0,0,1,2,0
259.87,-1802.56,1770,0,"878.88",3,3.00,0,0,0,0,0,0,1,2,0
275.20,-1802.56,1771,0,"51.30",3,3.00,0,0,0,0,0,0,1,2,0
（2）柱状.txt文件
此文件为柱状图中线文件的明码文件，格式如下：
a,b,c,d,e,f,g,h,i
1.0000000000,0.0000000000,1,.20,10,10,0,11,0
2.0000000000,0.0000000000,0,.00,0.0,.00,0,0,0
51.0842080000,-57.3000000000,0,.00,0.0,.00,0,0,0
216.2868050000,-57.3000000000,0,.00,0.0,.00,0,0,0
1.0000000000,165.2025970000,0,.00,0.0,.00,0,0,0
1.0000000000,0.0000000000,1,.20,10,10,0,11,0
2.0000000000,0.0000000000,0,.00,0.0,.00,0,0,0
220.8998000000,-55.6000000000,0,.00,0.0,.00,0,0,0
234.6485000000,-55.6000000000,0,.00,0.0,.00,0,0,0
2.0000000000,1
3.7487000000,0,.00,0.0,.00,0,0,0
121.0000000000,0.0000000000,1,.10,20,15,0,0,0
2.0000000000,0.0000000000,0,.00,0.0,.00,0,0,0
220.9000000000,-46.7666666667,0,.00,0.0,.00,0,0,0
234.6500000000,-46.7666666667,0,.00,0.0,.00,0,0,0
3.0000000000,13.7500000000,0,.00,0.0,.00,0,0,0
……………………
1691.0000000000,13.7500000000,0,.00,0.0,.00,0,0,0
29.0000000000,2.0000000000,1,.20,2.0,2.0,0,11,0
2.0000000000,0.0000000000,0,.00,0.0,.00,0,0,0
236.4900000000,-1822.7600000000,0,.00,0.0,.00,0,0,0
284.8100000000,-1822.7600000000,0,.00,0.0,.00,0,0,0
1692.0000000000,48.3200000000,0,.00,0.0,.00,0,0,0
29.0000000000,2.0000000000,1,.20,2.0,2.0,0,11,0
2.0000000000,0.0000000000,0,.00,0.0,.00,0,0,0
236.4900000000,-1802.7600000000,0,.00,0.0,.00,0,0,0
284.8100000000,-1802.7600000000,0,.00,0.0,.00,0,0,0
1693.0000000000,48.3200000000,0,.00,0.0,.00,0,0,0
上面产生的两个文件需要处理下才能作为明码文件，处理方式和结果如下：
（1）注释.txt文件的处理
此文件处理方式为把第一行的“a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p”删掉，然后加上：
WMAP9022
1771
此处“WMAP9022”代表为点文件明码格式的开头，“1771”代表了点的数目，这个数字为文件最后一行，第3个数字。

处理结果如下：
WMAP9022
1771
217.50,-55.60,1,0,"1",3,3.00,0,0,0,0,0,0,1,2,0
53.39,-54.30,2,0,"",4,3.50,0,0,0,0,0,0,1,2,0
130.24,-54.30,3,0,"砂质粘土",4,3.50,0,0,0,0,0,0,1,2,0
183.20,-54.30,4,0,"5.30",4,3.50,0,0,0,0,0,0,1,2,0
195.85,-54.30,5,0,"5.30",4,3.50,0,0,0,0,0,0,1,2,0
211.00,-54.30,6,0,"1",4,3.50,0,0,0,0,0,0,1,2,0
217.50,-58.90,7,0,"2",3,3.00,0,0,0,0,0,0,1,2,0
53.39,-63.60,8,0,"",4,3.50,0,0,0,0,0,0,1,2,0
130.24,-63.60,9,0,"粉砂",4,3.50,7,0,0,0,0,0,1,2,0
……………………
259.87,-1699.96,1768,0,"827.58",3,3.00,0,0,0,0,0,0,1,2,0
275.20,-1699.96,1769,0,"29.50",3,3.00,0,0,0,0,0,0,1,2,0
259.87,-1802.56,1770,0,"878.88",3,3.00,0,0,0,0,0,0,1,2,0
275.20,-1802.56,1771,0,"51.30",3,3.00,0,0,0,0,0,0,1,2,0
（2）柱状.txt文件的处理
此文件的处理稍微复杂：首先把“,0.0000000000,0,.00,0.0,.00,0,0,0”全部替换为“”，即空，然后再把“,0,.00,0.0,.00,0,0,0”全部替换为“”，也是空，替换完之后，最后替换头，把头“a,b,c,d,e,f,g,h,i”替换为：WMAP9021
1693
这里“WMAP9021”开头代表线文件明码格式的开头，“1693”代表线数，在文件最后一行第一个数字。

改完之后可以很明显的看到线文件的格式，改后如下：
WMAP9021
1693
1.0000000000,0.0000000000,1,.20,10,10,0,11,0
2.0000000000
51.0842080000,-57.3000000000
216.2868050000,-57.3000000000
1.0000000000,165.2025970000
1.0000000000,0.0000000000,1,.20,10,10,0,11,0
2.0000000000
220.8998000000,-55.6000000000
234.6485000000,-55.6000000000
2.0000000000,1
3.7487000000
121.0000000000,0.0000000000,1,.10,20,15,0,0,0
2.0000000000
220.9000000000,-46.7666666667
234.6500000000,-46.7666666667
3.0000000000,13.7500000000
…………
1691.0000000000,13.7500000000
29.0000000000,2.0000000000,1,.20,2.0,2.0,0,11,0
2.0000000000
236.4900000000,-1822.7600000000
284.8100000000,-1822.7600000000
1692.0000000000,48.3200000000
29.0000000000,2.0000000000,1,.20,2.0,2.0,0,11,0
2.0000000000
236.4900000000,-1802.7600000000
284.8100000000,-1802.7600000000
1693.0000000000,48.3200000000
到此为止柱状图所需的点、线明码格式文件已经做好了。

3、生成点线文件、成图
打开mapgis的文件转换功能，依次点击输入---装入mapgis明码格式文件。

选择刚刚做好的两个文件，然后分别保存点、保存线，即可得到所需要的柱状图。

生成的柱状图部分如下：。