Establishment And Application Of Special Oil Sands Spectrum Database

With the advent of the big data era,it is increasingly important to manage the data effectively and make full use of it.At present,there are many kinds of local and foreign land mass spectra database,there is still a research gap in the oil sands.It can not carry out effective management and analysis of oil sands and related information.In the process of resource exploration and exploitation,the accumulation and analysis of basic data and information is very important.The basic information of oil sands samples such as sample origin,latitude and longitude coordinates,rock description and weathering degree are included in field collection;back to the laboratory,the data obtained from the oil sands sample spectra includes the observation instrument,time,location and other spectral observation information;in the analysis of the identification of oil sand samples,the microstructure information of rock composition,microstructure and photomicrograph are also covered.How to generalize,filter,and conduct unified,standardized and effective management,the oil sands sample wave spectrum is analyzed at the same time,even the relevant data of oil sands can be established to explain the correlation between the physical and chemical components of the oil sands.They are the key and difficult point of this thesis.Based on the analysis of the existing thematic spectral database construction,by analyzing the relevant concepts and theories of oil sands,determine the functions that the database needs to implement,select C# language to combine SQL Server2008 database design and development of the oil sand spectrum project database,and the database is applied,the results of oil sands filling are ideal.Because of the complete information of the oil sands in the oil sands,the data analysis in this region and other regions is of certain significance.meanwhile,the distribution of oil sands resources can be determined by using the measured oil sand spectrum in the hyperspectral remote sensing image.the main research results are as follows:1.After detailed requirements analysis,the functions needed to be implemented by the database are clarified.Then based on the C# language,combined with Microsoft SQL Server 2008 database,we developed a special database of oil sand spectrum;to manage the all kinds of information,realize information increase,delete,query and update;at the same time,users can realize custom analysis on the characteristics of oil sand spectrum:(1)spectral absorption characteristic parameters: absorption band wavelength position(P),depth(H),width(W),slope(K),area(A)and symmetry(S);(2)the spectral characteristics are fitted to obtain the matching correlation coefficient;2.In the cold lake area of Qinghai province: there are 81 oil sands samples collected from No.4,No.5 oil field and No.7 construction,in addition,the sample coordinate position,related description information and sample photos are recorded in detail,Back to the laboratory,the oil sand samples were measured with standard spectral data,and 810 samples were obtained from the oil sand samples,the identification result of the rock flake was 81.obtain the primary data of the oil sand spectrum and the supporting information;3.Summarize Hyperion L1 R level data a rapid pretreatment process,because there are many problems with hyperspectral Hyperion L1 R data,it often requires a lot of tedious processing before practical application,which has always been a problem for researchers,this article has read a lot of relevant information,The quick pretreatment process and principle are described in detail;4.Based on the established special database of oil sand spectrum,Comprehensive utilization of high spectral remote sensing images and a small amount of oil sands samples collected in the field,after a series of processing to obtain its reflectivity data,the distribution of oil sands in the cold lake area of qinghai was completed by using the spectral angle mapping method,the extraction results are analyzed,this method is fast and relatively accurate compared with the traditional field geology survey.