Method for quickly converting coordinate formats of mineral resource reserve database in batches and related equipment

Abstract

The invention provides a method for quickly converting coordinate formats of mineral resource reserve databases in batches and related equipment. The method comprises the following steps: firstly, reading a mining area number and a registration classification number in a row coordinate record, and a character string in a mining area or mine range coordinate field and a character string in a calculation coordinate field from a coordinate management table; secondly, independently storing block coordinates in the two character strings by utilizing two one-dimensional arrays, and independently storing initial positions and inflection points of the block coordinates by utilizing two two-dimensional arrays; and finally, according to the information in the four arrays, in combination with an encoding rule of the character string, reading block coordinates from the corresponding arrays in sequence, forming a coordinate pair format, and writing the coordinate pair format into a corresponding text file, so that forward conversion from the coordinate string to the coordinate pair is realized. In addition, reverse conversion of coordinate pairs to coordinate strings is also provided. According to the invention, the coordinate pair data meeting the coordinate system transformation format requirement can be quickly realized and provided.

Description

Technical Field

[0001] The present invention relates to the technical field of mineral resource reserve databases and geospatial coordinate data processing, and particularly relates to a method and related equipment for batch and rapid conversion of the coordinate format of a mineral resource reserve database. Background Art

[0002] Mineral resources are the cornerstone of national economic development. The reserve database is used to store and manage mineral resource reserve data, and is the foundation and important starting point for mineral resource management. Due to historical reasons, there is a mixed use of coordinate systems for the coordinate values in the reserve database, resulting in problems such as graphic offset, non-fitting of graphics, graphic overlap, incorrect coordinate values, and missing coordinate values in the mining area (mountain). To better manage the reserves, the mineral resource reserve management department needs to transform all the coordinate systems in the reserve database into the 2000 National Geodetic Coordinate System. To transform the coordinate system, it is necessary to first batch extract the coordinate values in the database and convert them into a text file in the coordinate pair format required by the surveying and mapping department's coordinate conversion before the next batch coordinate transformation can be carried out. After the coordinate transformation is completed, it is necessary to reverse-transform the coordinate pairs in the text file into the format of a coordinate string, and then import it back into the reserve database to update and replace the transformed coordinate values.

[0003] There are thousands of coordinate values in the reserve database every year, and some mining areas (mountains) have up to hundreds of coordinate inflection points. If the coordinate strings are to be sorted into a text file in the coordinate pair format, handed over to the surveying and mapping department for coordinate system transformation of the coordinate values, and then the coordinate pairs are converted into a coordinate string in the string format and imported back into the reserve database, the manual sorting workload is extremely large and extremely error-prone. Summary of the Invention

[0004] In order to solve the problems of huge workload and extremely error-prone in the manual conversion between coordinate strings and coordinate pairs, based on the need for coordinate system transformation of the coordinates of the mining area (mountain) in the reserve database, the present invention provides a method and related equipment for batch and rapid conversion of the coordinate format of a mineral resource reserve database, which can realize the forward conversion of the coordinate string of the coordinate value in the reserve database to the coordinate pair format, and the reverse conversion of the coordinate pair to the reserve database coordinate string format, achieving the purpose of quickly, efficiently, and accurately converting the coordinate format, and providing strong support for the management of the mineral resource reserve database.

[0005] In a first aspect, a method for batch and rapid conversion of the coordinate format of a mineral resource reserve database according to the present invention, which converts a coordinate in the string format into the coordinate pair format, includes:

[0006] Step 1: Obtain the coordinate management table of the target mining area or mine from the mineral resource reserve database;

[0007] Step 2: Read a row of coordinate records from the coordinate management table and extract the mining area number and registration classification number included in the row record;

[0008] Step 3: Read the first string in the mining area or mine range coordinate field and the second string in the calculation coordinate field from the coordinate record;

[0009] Step 4: According to the delimiter in the first string, store all the characters between adjacent delimiters into a first one-dimensional array in sequence, and extract the starting position of the range coordinates and the number of inflection points of each block from the first one-dimensional array and store them in a first two-dimensional array; according to the delimiter of the second string, store all the characters between adjacent delimiters into a second one-dimensional array in sequence, and extract the starting position of the calculation coordinates and the number of inflection points of each block from the second one-dimensional array and store them in a second two-dimensional array;

[0010] Step 5: Write the mining area number, registration classification number, and range coordinate field identifier into a preset text file and use it as the starting line of the range coordinate field; according to the starting position of the range coordinates and the number of inflection points of each block stored in the first two-dimensional array, combined with the encoding rules of the string, sequentially read the inflection point serial number, the X coordinate and Y coordinate of the inflection point from the first one-dimensional array, and form a coordinate pair format to write after the starting line of the range coordinate field in the preset text file until all blocks are processed;

[0011] Step 6: Write the mining area number, registration classification number, and calculation coordinate field identifier into a preset text file and use it as the starting line of the calculation coordinate field; according to the starting position of the calculation coordinates and the number of inflection points of each block stored in the second two-dimensional array, combined with the encoding rules of the second string, sequentially read the inflection point serial number, the X coordinate and Y coordinate of the inflection point from the second one-dimensional array, and form a coordinate pair format to write after the starting line of the calculation coordinate field in the preset text file until all blocks are processed;

[0012] Step 7: Return to Step 2 until all row coordinate records in the coordinate management table are processed.

[0013] Further, during the process of writing the information of the block into the preset file, an interval symbol is set between the information of two adjacent mining area (mine) coordinate blocks, and a first end symbol is set after the information of the last block; for the information of each mining area (mine) coordinate block, one inflection point corresponds to one line, and a second end symbol is set after the last inflection point of a block. After the second end symbol, the starting and ending elevation, block identifier, and block property are written.

[0014] Further, in Step 4, if the starting position of the range coordinates or the starting position of the calculation coordinates of Block 1 is 1 and the number of inflection points is G1, then calculate the starting position of the range coordinates or the starting position of the calculation coordinates P of the nth block according to the following formula n ;

[0015] P n = 1 + P n-1 +(G n-1 + 1)*3 + 1

[0016] where G n-1 represents the number of inflection points of the (n - 1)-th block, and n is an integer greater than 1;

[0017] Correspondingly, the element value with the subscript P n in the first or second one-dimensional array is used as the number of inflection points of the n-th block.

[0018] Further, step 5 specifically includes: writing the mine area number, registration classification number, and range coordinate field identifier into a preset text file and using it as the starting line of the range coordinate field; assigning the starting position of the range coordinate to point1 as the pointer of the first one-dimensional array, sequentially reading the element value with the subscript (point1 + 1) in the first one-dimensional array as the serial number of the current inflection point, the element value with the subscript (point1 + 2) as the X coordinate of the current inflection point, and the element value with the subscript (point1 + 3) as the Y coordinate of the current inflection point; moving the point1 pointer backward and continuing to read the information of the next inflection point until all blocks are read;

[0019] Further, step 6 specifically includes: writing the mine area number, registration classification number, and calculation coordinate field identifier into a preset text file and using it as the starting line of the calculation coordinate field; assigning the starting position of the calculation coordinate to point2 as the pointer of the second one-dimensional array, sequentially reading the element value with the subscript (point2 + 1) in the second one-dimensional array as the serial number of the current inflection point, the element value with the subscript (point2 + 2) as the X coordinate of the current inflection point, and the element value with the subscript (point2 + 3) as the Y coordinate of the current inflection point; moving the point2 pointer backward and continuing to read the information of the next inflection point until all blocks are read.

[0020] Further, after the second end symbol, write the starting and ending elevations, block identifier, and block property, specifically including:

[0021] Assign the position of the second end symbol in the first one-dimensional array to point3 as the pointer of the first one-dimensional array, read the element value with the subscript (point3 + 1) in the first one-dimensional array as the starting elevation of the current block, the element value with the subscript (point3 + 2) as the ending elevation of the current block, the element value with the subscript (point3 + 3) as the block identifier of the current block, and the element value with the subscript (point3 + 4) as the block property of the current block.

[0022] In a second aspect, the present invention provides a method for batch and rapid conversion of the coordinate format of a mineral resource reserve database, which converts the coordinate pair format into a string format coordinate, including:

[0023] Step 1: Obtain a preset text file storing coordinate pairs of a target mining area or mine;

[0024] Step 2: Locate the row where the mining area number is located in the preset text file, denoted as the starting row; and read the mining area number, registration classification number, and coordinate field identifier in the starting row and write them into the first three columns of the same row of a third two-dimensional array;

[0025] Step 3: Read the subsequent rows after the starting row, convert the coordinate pairs in the subsequent rows into strings and concatenate them until a preset end symbol is read, and write the string at this time into the fourth column of the row where the currently located mining area number is in the third two-dimensional array; the preset end symbol is used to indicate that all block information included in the currently located mining area number ends here;

[0026] Step 4: Return to Step 2 until the preset text file is processed;

[0027] Step 5: Obtain the coordinate management table of the target mining area or mine from the mineral resource reserve database;

[0028] Step 6: Traverse all row coordinate records in the coordinate management table, use the mining area number and registration classification number in a single row coordinate record as keywords to search in the third two-dimensional array. If a matching result exists, replace the range coordinate string and calculation coordinate string in the coordinate management table with the string in the fourth column of the matching row to update the coordinate management table.

[0029] In a third aspect, the present invention provides a device for batch and rapid conversion of the coordinate format of a mineral resource reserve database, which is used to convert the string format coordinate into a coordinate pair format, including:

[0030] An acquisition module, configured to obtain the coordinate management table of the target mining area or mine from the mineral resource reserve database;

[0031] A mining area information extraction module, configured to read a row of coordinate records from the coordinate management table and extract the corresponding mining area number and registration classification number of the row record;

[0032] A string reading module, configured to read a first string in the mining area or mine range coordinate field and a second string in the calculation coordinate field from the coordinate record;

[0033] An array writing module, configured to store all characters between adjacent delimiters in the first string into a first one-dimensional array in sequence, and extract the starting position of the range coordinates and the number of inflection points of each block from the first one-dimensional array and store them in a first two-dimensional array; store all characters between adjacent delimiters in the second string into a second one-dimensional array in sequence according to the delimiter of the second string, and extract the starting position of the calculation coordinates and the number of inflection points of each block from the second one-dimensional array and store them in a second two-dimensional array;

[0034] A text writing module, configured to write the mining area number, registration classification number, and range coordinate field identifier into a preset text file and use it as the starting line of the range coordinate field; according to the starting position of the range coordinates and the number of inflection points of each block stored in the first two-dimensional array, and in combination with the encoding rule of the first string, sequentially read the inflection point serial number, the X coordinate and the Y coordinate of the inflection point from the first one-dimensional array, and form a coordinate pair format to write it into the preset text file after the starting line of the range coordinate field until all blocks are processed; and configured to write the mining area number, registration classification number, and calculation coordinate field identifier into a preset text file and use it as the starting line of the calculation coordinate field; according to the starting position of the calculation coordinates and the number of inflection points of each block stored in the second two-dimensional array, and in combination with the encoding rule of the second string, sequentially read the inflection point serial number, the X coordinate and the Y coordinate of the inflection point from the second one-dimensional array, and form a coordinate pair format to write it into the preset text file after the starting line of the calculation coordinate field until all blocks are processed.

[0035] In a fourth aspect, the present invention provides a device for batch and quickly converting the coordinate format of a mineral resource reserve database, configured to convert the coordinate pair format into a string format coordinate, including:

[0036] A text acquisition module, configured to acquire a preset text file storing coordinate pairs of a target mining area or mine;

[0037] A mining area information positioning module, configured to locate the row where the mining area number is located in the preset text file, denoted as the starting line; and read the mining area number, registration classification number, and coordinate field identifier in the starting line and write them into the first three columns of the same row of a third two-dimensional array

[0038] A string writing module, configured to read the subsequent rows after the starting line, convert the coordinate pairs in the subsequent rows into strings and concatenate them until a preset end symbol is read, and write the string at this time into the fourth column of the row where the currently located mining area number is in the third two-dimensional array; the preset end symbol is used to indicate that all block information included in the currently located mining area number ends here;

[0039] A table acquisition module, configured to acquire a coordinate management table of a target mining area or mine from a mineral resource reserve database;

[0040] A table update module is used to traverse all row coordinate records in the coordinate management table, search in the third two-dimensional array with the mine area number and registration classification number in a single row coordinate record as keywords. If a matching result exists, the string in the fourth column of the matching row is used to replace the range coordinate string and calculation coordinate string in the coordinate management table to update the coordinate management table.

[0041] In a fifth aspect, the present invention provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, the method described in the first and / or second aspect is implemented.

[0042] In a sixth aspect, the present invention provides a non-transitory computer-readable storage medium, on which a computer program is stored. The computer program is characterized in that when executed by a processor, the method described in the first and / or second aspect is implemented.

[0043] The beneficial effects of the present invention are as follows:

[0044] 1. For the situation where a large number of coordinate transformations from the 1954 Beijing Coordinate System or the 1980 Xi'an Coordinate System to the 2000 National Geodetic Coordinate System are required, the method of the present invention can be quickly implemented and provide coordinate pair data that meets the requirements of the coordinate transformation format.

[0045] 2. The present invention can achieve a large number of fast forward conversions from reserve database coordinate strings to coordinate pairs, reverse conversions, exports, and imports from coordinate pairs to reserve database coordinate strings, greatly reducing the workload of manually sorting coordinate strings and coordinate pairs.

[0046] 3. Through the forward conversion, the coordinate strings in the reserve database are converted into coordinate pair data, which can quickly visually determine whether the number of digits of the coordinate values X and Y is correct, solve the problem that coordinate strings are not intuitive and it is impossible to directly judge input errors of coordinate values in the string, and can quickly check for errors in coordinate value data.

[0047] 4. According to the converted coordinate pair file, it is possible to quickly determine how many closed blocks there are in the coordinates of a mining area (mountain), which helps to troubleshoot coordinate problems in the mining area (mountain).

[0048] 5. For the coordinate values in the coordinate pair format after coordinate transformation, it is possible to convert them back to the string format and write them back into the reserve database, which can quickly update the coordinate values in the reserve database. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] Figure 1 It is a schematic flowchart of a method for batch and fast conversion of the coordinate format of a mineral resource reserve database (forward conversion) provided by an embodiment of the present invention.

[0050] Figure 2 It is a relationship diagram of the mining area (mountain) range and blocks;

[0051] Figure 3 It is a schematic flowchart of a method (reverse conversion) for batch and rapid conversion of the coordinate format of a mineral resource reserve database provided by an embodiment of the present invention;

[0052] Figure 4 It is a data structure diagram of the conversion correspondence between coordinate strings and coordinate pairs provided by an embodiment of the present invention;

[0053] Figure 5 It is a schematic structural diagram of a device (forward conversion) for batch and rapid conversion of the coordinate format of a mineral resource reserve database provided by an embodiment of the present invention;

[0054] Figure 6 It is a schematic structural diagram of a device (reverse conversion) for batch and rapid conversion of the coordinate format of a mineral resource reserve database provided by an embodiment of the present invention;

[0055] Figure 7 It is a schematic structural diagram of an electronic device provided by an embodiment of the present invention. Specific embodiments

[0056] To make the objectives, technical solutions, and advantages of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some, but not all, of the embodiments of the present invention. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0057] The present invention provides a method for batch and rapid conversion of the coordinate format of mining areas (mountains) in a mineral resource reserve database (hereinafter referred to as the reserve database), mainly achieving the following functions: forward conversion of the coordinates of mining areas (mountains) in the reserve database from coordinate strings to coordinate pair text files; reverse conversion from coordinate pair files back to the coordinate strings of mining areas (mountains) in the reserve database; providing data that meets the format requirements for coordinate system transformation of mining areas (mountains) in the reserve database; and quickly updating the transformed coordinate values back to the reserve database to achieve the update after coordinate data transformation in the reserve database.

[0058] As Figure 1 shown, an embodiment of the present invention provides a method for batch and rapid conversion of the coordinate format of a mineral resource reserve database, which converts the coordinates in string format into coordinate pair format (forward conversion), including the following steps:

[0059] S101: Obtain the coordinate management table of the target mining area or mine from the mineral resource reserve database, that is, the KCL_ZB table;

[0060] Specifically, the coordinates of the mining area (mountain) in the storage reservoir are stored in the KCL_ZB table. The main fields of the table are shown in Table 1, mainly including kqbh (mining area number), djflbh (registration classification number), kqzb (coordinates of the mining area (mountain) range), and jszb (calculation coordinates), as shown in Table 1. The keywords are kqbh and djflbh.

[0061] Table 1 Main fields of the KCL_ZB table

[0062]

[0063] S102: Read a row of coordinate records from the KCL_ZB table and extract the corresponding mining area number and registration classification number of this row of records, that is, the values of the kqbh and djflbh fields in the KCL_ZB table; among them, kqbh corresponds to the mining area number, and djflbh corresponds to the registration classification number.

[0064] In this embodiment, the SELECT statement of SQL language is used to read kqbh, djflbh, kqzb, and jszb from the KCL_ZB table. The program statement is: sql = "SELECT kqbh,djflbh,kqzb,jszb FROM KCL_ZB". The db.OpenRecordset method is used to open the database, execute the SQL statement, and assign it to the rs record set.

[0065] S103: Read the first string in the mining area or mine range coordinate field and the second string in the calculation coordinate field from the coordinate record;

[0066] Specifically, in the KCL_ZB table, the storage data type of the coordinate value is long text. The range coordinates of the mining area (mountain) (as Figure 2 shown) and the calculation coordinates are both composed of more than 1 block. A block is a closed area formed by inflection point coordinates.

[0067] S104: According to the delimiter in the first string (usually a comma as the delimiter), store all the characters between adjacent delimiters into the first one-dimensional array (denoted as array brr1) in sequence, and extract the starting position of the range coordinates and the number of inflection points of each block from array brr1 and store them in the first two-dimensional array (denoted as array arr1); according to the delimiter of the second string, store all the characters between adjacent delimiters into the second one-dimensional array (denoted as array brr2) in sequence, and extract the starting position of the calculation coordinates and the number of inflection points of each block from array brr2 and store them in the second two-dimensional array (denoted as array arr2);

[0068] Specifically, the array brr1 is used to store the range coordinate strings of all blocks in a mining area (mountain), and the array arr1 is used to store the starting positions and the number of inflection points of the range coordinates of all blocks in this mining area (mountain). Correspondingly, the array brr2 is used to store the calculated coordinate strings of all blocks in a mining area (mountain), and the array arr2 is used to store the starting positions and the number of inflection points of the calculated coordinates of all blocks in this mining area (mountain). Taking the range coordinates as an example, the data structures of the arrays arr and brr are shown in Figure 4 as shown.

[0069] It should be noted that when extracting the starting position and the number of inflection points of the coordinates, it is necessary to know the encoding rules of the coordinate value strings. In this embodiment, the encoding rules of the first string and the second string are the same. Generally speaking, the encoding rules of the strings in the KCL_ZB table are as follows: the number of blocks, the number of inflection points of block 1, 1, the X coordinate of inflection point 1, the Y coordinate of inflection point 1, 2, the X coordinate of inflection point 2, the Y coordinate of inflection point 2,..., n, the X coordinate of inflection point n, the Y coordinate of inflection point n, the upper elevation of the mining depth of block 1, the lower elevation of the mining depth of block 1, the block number (can be blank), the block property (1 is a normal closed area, -1 is a deducted empty sub-area in the circular area), the number of inflection points of block 2, 1, the X coordinate of inflection point 1, the Y coordinate of inflection point 1, 2, the X coordinate of inflection point 2, the Y coordinate of inflection point 2,...; as Figure 4 shown in the KCL_ZB table.

[0070] Based on the above encoding rules, it can be known that the value of brr(0) is the number of blocks. Using this value as the count, starting from the element of the array brr(0), read the values of the elements in the brr array backward, and calculate and find the starting positions and the number of inflection points of the coordinates of each block from the brr array, and then they can be stored in the first column and the second column of the two-dimensional array block arr respectively.

[0071] Taking the range coordinate string as an example, it is assumed that the range coordinate string uses a comma as the separator. In this embodiment, the function Split(rs!kqzb, ",") is called to split and store the coordinate string value of the kqzb field into the brr array, where rs!kqzb is the range coordinate string value of a row record read from the table.

[0072] S105: Write the mining area number, registration classification number, and range coordinate field identifier into a preset text file and use it as the starting line of the range coordinate field, such as "412822602,2004,KQZB", where "412822602" represents the mining area number, "2004" represents the registration classification number, and "KQZB" represents the range coordinate field identifier of the mining area or mine;

[0073] Write the mine area number, registration classification number, and calculation coordinate field identifier into a preset text file and use it as the starting line of the calculation coordinate field, such as "412822602,2004,JSZB", where "JSZB" represents the calculation coordinate field identifier.

[0074] S106: According to the starting positions of the range coordinates and the number of inflection points of each block stored in the array arr1, combined with the encoding rules of the string, sequentially read the inflection point numbers, the X coordinates and Y coordinates of the inflection points from the array brr1, and write them in the form of coordinate pairs after the starting line of the range coordinate field in the preset text file until all blocks are processed;

[0075] According to the starting positions of the calculation coordinates and the number of inflection points of each block stored in the array arr2, combined with the encoding rules of the string, sequentially read the inflection point numbers, the X coordinates and Y coordinates of the inflection points from the array brr2, and write them in the form of coordinate pairs after the starting line of the calculation coordinate field in the preset text file until all blocks are processed;

[0076] It should be noted that the text file storing the range coordinate pairs and the text file storing the calculation coordinate pairs can be the same, or each can correspond to a text file. In addition, for the same line of coordinate records, the writing processes of the range coordinate pairs and the calculation coordinate pairs are independent of each other, and the two can be completed in parallel.

[0077] S107: Return to step S102 until all line coordinate records in the coordinate management table are processed.

[0078] The embodiments of the present invention can realize the forward conversion, export, and import of a large number of and fast reserve database coordinate strings → coordinate pairs, greatly reducing the workload of manually sorting out coordinate strings and coordinate pairs. And according to the converted coordinate pair file, it can quickly judge how many closed blocks there are in the mine area (mountain) coordinates, which helps to check the coordinate problems of the mine area (mountain).

[0079] In one embodiment, during the process of writing the information of the block into the preset file, an interval symbol (such as a line break symbol) is set between the information of two adjacent blocks, and a first end symbol (such as ",,,,") is set after the information of the last block in a mine area (mountain); for the information of each block, one inflection point corresponds to one line, and a second end symbol (such as "*") is set after the last inflection point of a block. After the second end symbol, the starting and ending elevations, block identifier, and block property are written. As Figure 4 Shown in the "converted coordinate pairs" as follows.

[0080] In the embodiment of the present invention, through forward conversion, a large number of coordinate strings in the storage are quickly converted into coordinate pair data, and the coordinate pairs of each inflection point correspond to one line. In this way, it is possible to quickly visually judge whether the number of digits of the coordinate values X and Y is correct, solving the problem that the coordinate string is not intuitive and it is impossible to directly judge input errors of coordinate values in the string, and enabling quick verification of coordinate value data errors. Moreover, according to the converted coordinate pair file, it is possible to quickly judge how many closed blocks there are in the coordinates of the mining area (mountain), which helps to investigate coordinate problems in the mining area (mountain), and greatly reduces the workload of manually sorting out coordinate strings and coordinate pairs.

[0081] In one embodiment, if the starting position of the range coordinates or the starting position of the calculated coordinates of block 1 is 1 and the number of inflection points is G1, then the starting position of the range coordinates or the starting position of the calculated coordinates P of the nth block is calculated according to the following formula n ;

[0082] P n = 1 + P n-1 +(G n-1 + 1)*3 + 1

[0083] where G n-1 represents the number of inflection points of the (n - 1)th block, and n is an integer greater than 1;

[0084] Correspondingly, the element value with the subscript P n in the first or second one-dimensional array is used as the number of inflection points of the nth block.

[0085] Specifically, since the array brr is used to store the coordinate strings of all blocks containing a mining area (mountain), and the array arr is used to store the starting positions and the number of inflection points of the coordinates of all blocks in the mining area (mountain), assuming that the starting position of block 1 is 1 and the number of inflection points is brr(1), then the above formula can also be expressed as:

[0086] Block arr(n, 1)= 1 + block arr(n - 1, 1)+(block arr(n - 1, 2)+ 1)*3 + 1;

[0087] The calculation formula for the number of inflection points of the nth block is:

[0088] Block arr(n, 2)= brr(block arr(n, 1);

[0089] In one embodiment, in the above S106 step, a pointer is used to sequentially read the serial number and coordinate pair of each inflection point. Specifically as follows:

[0090] Extract the starting position and the number of inflection points of the nth block according to the first column and the second column of the array arr1 respectively; assign the starting position of the range coordinates to point1 as the pointer of the array brr1, and sequentially read the element value with the subscript (point1 + 1) in the array brr1 as the serial number of the current inflection point, the element value with the subscript (point1 + 2) as the X coordinate of the current inflection point, and the element value with the subscript (point1 + 3) as the Y coordinate of the current inflection point; move the point1 pointer backward and continue to read the information of the next inflection point until all blocks are read;

[0091] Similarly, extract the starting position and the number of inflection points of the nth block according to the first column and the second column of the array arr2 respectively, assign the starting position of the calculated coordinates to point2 as the pointer of the array brr2, and sequentially read the element value with the subscript (point2 + 1) in the array brr2 as the serial number of the current inflection point, the element value with the subscript (point2 + 2) as the X coordinate of the current inflection point, and the element value with the subscript (point2 + 3) as the Y coordinate of the current inflection point; move the point2 pointer backward and continue to read the information of the next inflection point until all blocks are read.

[0092] Furthermore, after the second end symbol, write the starting and ending elevations, block identifier, and block property, specifically including: assign the position of the second end symbol in the array brr1 to point3 as the pointer of the array brr1, read the element value with the subscript (point3 + 1) in the array brr1 as the starting elevation of the current block, the element value with the subscript (point3 + 2) as the ending elevation of the current block, the element value with the subscript (point3 + 3) as the block identifier of the current block, and the element value with the subscript (point3 + 4) as the block property of the current block; connect the second end symbol, starting elevation, ending elevation, block name, and block property into a string, separated by commas in the middle, and write it into a line in the text file.

[0093] As Figure 3 shown, the embodiment of the present invention also provides a method for batch and rapid conversion of the coordinate format of the mineral resource reserve database, converting the coordinate pair format into a string format coordinate (reverse conversion), including the following steps:

[0094] S201: Obtain a preset text file storing the coordinate pairs of the target mining area or mine;

[0095] S202: Locate the row where the mining area number is located in the preset text file, denoted as the starting row; and read the mining area number, registration classification number, and coordinate field identifier in the starting row and write them into the first three columns of the same row of the third two-dimensional array (denoted as the array crr);

[0096] For example, the mine area number is generally composed of 9 Arabic numerals, and each Arabic numeral represents a different coding meaning. Therefore, the coding meaning of the mine area number can be used to locate the line where the mine area number is located. For example, if the line starts with "41", it indicates that this line is the start of the coordinates of the mine area (mountain). Based on the writing rules of the text file, the function Mid(Line, 1, 9) can be used to obtain the mine area number, Mid(Line, 11, 4) to obtain the registration classification number, and Mid(Line, 16, 4) to obtain the coordinate type, and write them into crr(i, 1), crr(i, 2), and crr(i, 3) respectively. In the formula, Line is the current line data read, and i is the line number of a certain block currently.

[0097] In this embodiment, the main fields included in the array crr are shown in Table 2.

[0098] Table 2 Structure Table of Array crr

[0099]

[0100] S203: Read the subsequent lines after the starting line, convert the coordinate pairs in the subsequent lines into strings and concatenate them until the preset end symbol is read, and write the string at this time into the fourth column of the line where the currently located mine area number in the array crr; the preset end symbol is used to indicate that all the block information included in the currently located mine area number ends here;

[0101] For example, when encountering the block coordinate end symbol "*", continue to convert the coordinate pairs of the next line into strings and concatenate them, and at the same time, the number of blocks +1; when encountering the mine area (mountain) coordinate end symbol ",,,,", it means that the coordinate pairs of all blocks of a certain mine area have been converted into strings, and the number of blocks and the regional coordinate string can be concatenated into a string and written into crr(i, 4). Among them, the number of blocks is the total count of all blocks included in the range coordinates or calculated coordinates of a certain mine area (mountain), and the regional coordinate string is the string containing the coordinates of all blocks of a certain mine area (mountain).

[0102] S204: Return to step S202 until the preset text file is processed.

[0103] S205: Obtain the coordinate management table of the target mine area or mine from the mineral resource reserve database, that is, the KCL_ZB table;

[0104] S206: Traverse all the line coordinate records in the KCL_ZB table, use the mine area number and registration classification number in a single line coordinate record as keywords, and search for the first column and the second column in the array crr. If there is a matching result, replace the range coordinate string and the calculated coordinate string in the coordinate management table with the string in the fourth column of the matching row to update the coordinate management table.

[0105] The embodiments of the present invention can achieve a large - scale and rapid reverse conversion, export, and import of coordinate pairs to reservoir coordinate strings, greatly reducing the workload of manually sorting out coordinate strings and coordinate pairs. For the coordinate values after coordinate system transformation, they can be converted back to the string format and written back into the reservoir, enabling rapid updating of the coordinate values in the reservoir.

[0106] It should be noted that the process of converting the coordinate pair format to the coordinate in string format provided by the embodiments of the present invention is the reverse process of the process of converting the coordinate in string format to the coordinate pair format described above, and the specific details are not elaborated here.

[0107] The forward conversion and reverse conversion processes between the coordinate string and the coordinate pair provided by the present invention are as Figure 4 shown. Figure 4 As shown in the KCL_ZB table, the "mine (mountain) coordinates" field is the coordinate string, and the "converted coordinate pair" shown is the corresponding coordinate pair.

[0108] As Figure 5 shown, the embodiments of the present invention also provide a device for batch - quickly converting the coordinate format of a mineral resource reserve database, which is used to convert the coordinate in string format to the coordinate pair format, and includes an acquisition module, a mining area information extraction module, a string reading module, an array writing module, and a text writing module.

[0109] The acquisition module is used to acquire the coordinate management table of the target mining area or mine from the mineral resource reserve database. The mining area information extraction module is used to read a row of coordinate records from the coordinate management table and extract the corresponding mining area number and registration classification number of the row record. The string reading module is used to read the first string in the mining area or mine range coordinate field and the second string in the calculation coordinate field from the coordinate record. The array writing module is used to store all the characters between adjacent delimiters in the first one-dimensional array in sequence according to the delimiter in the first string, and extract the starting position of the range coordinates and the number of inflection points of each block from the first one-dimensional array and store them in the first two-dimensional array; according to the delimiter of the second string, store all the characters between adjacent delimiters in the second one-dimensional array in sequence, and extract the starting position of the calculation coordinates and the number of inflection points of each block from the second one-dimensional array and store them in the second two-dimensional array. The text writing module is used to write the mining area number, registration classification number, and range coordinate field identifier into a preset text file and use it as the starting line of the range coordinate field; according to the starting position of the range coordinates and the number of inflection points of each block stored in the first two-dimensional array, combined with the encoding rule of the first string, sequentially read the inflection point serial number, the X coordinate and Y coordinate of the inflection point from the first one-dimensional array, and form a coordinate pair format to write it after the starting line of the range coordinate field in the preset text file until all blocks are processed; and is used to write the mining area number, registration classification number, and calculation coordinate field identifier into a preset text file and use it as the starting line of the calculation coordinate field; according to the starting position of the calculation coordinates and the number of inflection points of each block stored in the second two-dimensional array, combined with the encoding rule of the second string, sequentially read the inflection point serial number, the X coordinate and Y coordinate of the inflection point from the second one-dimensional array, and form a coordinate pair format to write it after the starting line of the calculation coordinate field in the preset text file until all blocks are processed.

[0110] It should be noted that the above device provided by the embodiment of the present invention is to implement the above coordinate conversion method of converting the coordinate in string format into the coordinate in coordinate pair format. Its functions can be specifically referred to the above method embodiments and will not be elaborated here.

[0111] As Figure 6 shown, the embodiment of the present invention also provides a device for batch and rapid conversion of the coordinate format of the mineral resource reserve database, which is used to convert the coordinate in coordinate pair format into the coordinate in string format, including a text acquisition module, a mining area information positioning module, a string writing module, a table acquisition module, and a table update module.

[0112] The text acquisition module is used to acquire a preset text file storing coordinate pairs of a target mining area or mine. The mining area information positioning module is used to locate the row where the mining area number is located in the preset text file, denoted as the starting row; and read the mining area number, registration classification number, and coordinate field identifier in the starting row and write them into the first three columns of the same row of a third two-dimensional array. The string writing module is used to read the subsequent rows after the starting row, convert the coordinate pairs in the subsequent rows into strings and concatenate them until a preset end symbol is read, and write the string at this time into the fourth column of the row where the currently located mining area number is in the third two-dimensional array; the preset end symbol is used to indicate that all block information included in the currently located mining area number ends here. The table acquisition module is used to acquire a coordinate management table of a target mining area or mine from a mineral resource reserve database. The table update module is used to traverse all row coordinate records in the coordinate management table, use the mining area number and registration classification number in a single row coordinate record as keywords to search in the third two-dimensional array. If a matching result exists, replace the range coordinate string and calculation coordinate string in the coordinate management table with the string in the fourth column of the matching row to update the coordinate management table.

[0113] It should be noted that the above device provided in the embodiment of the present invention is for implementing the above coordinate conversion method for converting the coordinate pair format into the string format, and its functions can be specifically referred to the above method embodiments, which will not be elaborated here.

[0114] Figure 7 Schematic diagram of the physical structure of an electronic device is exemplified, such as Figure 7As shown in the figure, the electronic device may include: a processor 701, a communications interface 702, a memory 703, and a communication bus 704. Among them, the processor 701, the communications interface 702, and the memory 703 complete communication with each other through the communication bus 704. The processor 701 may call the logical instructions in the memory 703 to execute a method for batch rapid conversion of the coordinate format of a mineral resource reserve database. For example, it includes: Step 1: Obtain the coordinate management table of the target mining area or mine from the mineral resource reserve database; Step 2: Read a row of coordinate records from the coordinate management table and extract the mining area number and registration classification number corresponding to the row record; Step 3: Read the first string in the mining area or mine range coordinate field and the second string in the calculated coordinate field from the coordinate record; Step 4: According to the delimiter in the first string, store all the characters between adjacent delimiters into a first one-dimensional array in sequence, and extract the starting position of the range coordinates and the number of inflection points of each block from the first one-dimensional array and store them in a first two-dimensional array; According to the delimiter of the second string, store all the characters between adjacent delimiters into a second one-dimensional array in sequence, and extract the starting position of the calculated coordinates and the number of inflection points of each block from the second one-dimensional array and store them in a second two-dimensional array; Step 5: Write the mining area number, registration classification number, and range coordinate field identifier into a preset text file and use it as the starting line of the range coordinate field; According to the starting position of the range coordinates and the number of inflection points of each block stored in the first two-dimensional array, combined with the encoding rule of the string, sequentially read the inflection point serial number, the X coordinate, and the Y coordinate of the inflection point from the first one-dimensional array, and form a coordinate pair format and write it after the starting line of the range coordinate field in the preset text file until all blocks are processed; Step 6: Write the mining area number, registration classification number, and calculated coordinate field identifier into a preset text file and use it as the starting line of the calculated coordinate field; According to the starting position of the calculated coordinates and the number of inflection points of each block stored in the second two-dimensional array, combined with the encoding rule of the second string, sequentially read the inflection point serial number, the X coordinate, and the Y coordinate of the inflection point from the second one-dimensional array, and form a coordinate pair format and write it after the starting line of the calculated coordinate field in the preset text file until all blocks are processed; Step 7: Return to Step 2 until all row coordinate records in the coordinate management table are processed.

[0115] For example, it further includes: Step 1: Obtain a preset text file storing coordinate pairs of a target mining area or mine; Step 2: Locate the row where the mining area number is located in the preset text file, denoted as the starting row; and read the mining area number, registration classification number, and coordinate field identifier in the starting row and write them into the first three columns of the same row of a third two-dimensional array; Step 3: Read the subsequent rows after the starting row, convert the coordinate pairs in the subsequent rows into strings and concatenate them until a preset end symbol is read, and write the string at this time into the fourth column of the row where the currently located mining area number is in the third two-dimensional array; the preset end symbol is used to indicate that all block information included in the currently located mining area number ends here; Step 4: Return to Step 2 until the preset text file is processed; Step 5: Obtain the coordinate management table of the target mining area or mine from the mineral resource reserve database; Step 6: Traverse all row coordinate records in the coordinate management table, use the mining area number and registration classification number in a single row coordinate record as keywords to search in the third two-dimensional array. If a matching result exists, replace the range coordinate string and calculation coordinate string in the coordinate management table with the string in the fourth column of the matching row to update the coordinate management table.

[0116] In addition, when the logical instructions in the above-mentioned memory 703 are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or a part of this technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: various media such as USB flash drives, mobile hard disks, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), magnetic disks, or optical discs that can store program codes.

[0117] The embodiments of the present invention further provide a computer program product. The computer program product includes a computer program stored on a non-transitory computer-readable storage medium. The computer program includes program instructions. When the program instructions are executed by a computer, the computer can execute the method for batch and rapid conversion of the coordinate format of the mineral resource reserve database provided by the above-mentioned method embodiments.

[0118] The embodiments of the present invention further provide a non-transitory computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, it implements the method for batch and rapid conversion of the coordinate format of the mineral resource reserve database provided by the above-mentioned method embodiments.

[0119] Through the description of the above embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus a necessary general hardware platform, and of course, it can also be implemented by hardware. Based on such an understanding, the essence of the above technical solution, or the part that contributes to the prior art, can be embodied in the form of a software product. The computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0120] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions recorded in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of each embodiment of the present invention.

Claims

1. A method for batch rapid conversion of mineral resource reserve database coordinate format, characterized in that: Converts coordinates in string format to coordinate pair format, including: Step 1: Obtain the coordinate management table of the target mining area or mine from the mineral resource reserve database; Step 2: Read a row of coordinate records from the coordinate management table and extract the mining area number and registration classification number contained in the row of records; Step 3: Read the first character string in the mine area or mine range coordinate field and calculate the second character string in the coordinate field from the coordinate record; Step 4: According to the delimiter in the first character string, all characters between adjacent delimiters are stored in a first one-dimensional array in order, and the starting position of the range coordinates and the number of inflection points of each block are extracted from the first one-dimensional array and stored in a first two-dimensional array; according to the delimiter in the second character string, all characters between adjacent delimiters are stored in a second one-dimensional array in order, and the starting position of the calculated coordinates and the number of inflection points of each block are extracted from the second one-dimensional array and stored in a second two-dimensional array; Step 5: Write the mining area number, registration classification number and range coordinate field identifier into a preset text file and use them as the starting line of the range coordinate field; according to the starting position of the range coordinates and the number of inflection points of each block stored in the first two-dimensional array, in combination with the encoding rules of the character string, read the inflection point sequence number, the X coordinate and the Y coordinate of the inflection point from the first one-dimensional array in sequence, form a coordinate pair format and write it into the starting line of the range coordinate field in the preset text file until all blocks are processed; Step 6: Write the mining area number, registration classification number and calculated coordinate field identifier into a preset text file and use them as the starting line of the calculated coordinate field; according to the calculated coordinate starting position and the number of inflection points of each block stored in the second two-dimensional array, in combination with the encoding rule of the second character string, read the inflection point sequence number, the X coordinate and the Y coordinate of the inflection point from the second one-dimensional array in sequence, form a coordinate pair format and write it into the starting line of the calculated coordinate field in the preset text file until all blocks are processed; Step 7: Return to step 2 until all row coordinate records in the coordinate management table are processed.

2. The method for batch rapid conversion of mineral resource reserve database coordinate format according to claim 1, characterized in that: In the process of writing the block information into the preset file, a separator is set between the information of two adjacent blocks, and a first terminator is set after the information of the last block; for the information of each block, one inflection point corresponds to one line, and a second terminator is set after the last inflection point of a block, and after the second terminator, the start and end elevations, block identifier and block properties are written.

3. The method for batch rapid conversion of mineral resource reserve database coordinate format according to claim 1 is characterized in that: In step 4, if the starting position of the range coordinates of block 1 or the calculated starting position of the coordinates is 1 and the number of inflection points is G1, the starting position of the range coordinates of the nth block or the calculated starting position of the coordinates P is calculated according to the following formula: n ; P n =1+P n-1 +(G n-1 +1)*3+1 Among them, G n-1 Indicates the number of inflection points of the n-1th block, where n is an integer greater than 1; Correspondingly, the subscript in the first or second one-dimensional array is P n The element value of is used as the inflection point number of the nth block.

4. The method for batch rapid conversion of mineral resource reserve database coordinate format according to claim 1, characterized in that: Step 5 specifically includes: writing the mining area number, registration classification number and range coordinate field identifier into a preset text file as the starting line of the range coordinate field; assigning the starting position of the range coordinate to point1 as a pointer to the first one-dimensional array, sequentially reading the element value with the subscript (point1+1) in the first one-dimensional array as the sequence number of the current inflection point, the element value with the subscript (point1+2) as the X coordinate of the current inflection point, and the element value with the subscript (point1+3) as the Y coordinate of the current inflection point; moving the point1 pointer backwards, and continuing to read the information of the next inflection point until all blocks are read; Step 6 specifically includes: writing the mining area number, registration classification number and calculated coordinate field identifier into a preset text file as the starting line of the calculated coordinate field; assigning the calculated coordinate starting position to point2 as a pointer to the second one-dimensional array, sequentially reading the element value with the subscript (point2+1) in the second one-dimensional array as the serial number of the current inflection point, the element value with the subscript (point2+2) as the X coordinate of the current inflection point, and the element value with the subscript (point2+3) as the Y coordinate of the current inflection point; moving the point2 pointer backward and continuing to read the information of the next inflection point until all blocks are read.

5. The method for batch rapid conversion of mineral resource reserve database coordinate formats according to claim 2, characterized in that: After the second terminator, the start and end elevations, block identifiers and block properties are written, including: Assign the position of the second terminator in the first one-dimensional array to point3 as a pointer to the first one-dimensional array, read the element value with subscript (point3+1) in the first one-dimensional array as the starting elevation of the current block, read the element value with subscript (point3+2) as the ending elevation of the current block, read the element value with subscript (point3+3) as the block identifier of the current block, and read the element value with subscript (point3+4) as the block property of the current block.

6. A method for batch rapid conversion of mineral resource reserve database coordinate format, characterized in that: Convert coordinate pairs to string coordinates, including: Step 1: Obtain a preset text file storing the target mining area or mine coordinate pair; Step 2: Locate the row where the mining area number is located in the preset text file and record it as the starting row; and read the mining area number, registration classification number and coordinate field identifier in the starting row and write them into the first three columns of the same row of the third two-dimensional array; Step 3: Read the subsequent rows after the starting row, convert the coordinate pairs in the subsequent rows into strings and connect them until a preset end character is read, and write the string at this time into the fourth column of the row where the mining area number currently located in the third two-dimensional array is located; the preset end character is used to indicate that all block information contained in the mining area number currently located ends here; Step 4: Return to step 2 until the preset text file is processed; Step 5: Obtain the coordinate management table of the target mining area or mine from the mineral resource reserve database; Step 6: Traverse all row coordinate records in the coordinate management table, use the mining area number and registration classification number in a single row coordinate record as keywords, search in the third two-dimensional array, and if there is a match, replace the range coordinate string and calculated coordinate string in the coordinate management table with the string in the fourth column of the matching row to update the coordinate management table.

7. A device for batch rapid conversion of mineral resource reserve database coordinate formats, characterized in that: Used to convert coordinates in string format to coordinate pair format, including: An acquisition module is used to obtain a coordinate management table of a target mining area or mine from a mineral resource reserve database; A mining area information extraction module, used to read a row of coordinate records from the coordinate management table and extract the mining area number and registration classification number contained in the row of records; A character string reading module, used for reading a first character string in a mine area or mine range coordinate field and a second character string in a calculated coordinate field from the coordinate record; An array writing module is used to store all characters between adjacent delimiters in a first one-dimensional array in sequence according to the delimiters in the first character string, and extract the range coordinate starting position and the number of inflection points of each block from the first one-dimensional array and store them in a first two-dimensional array; according to the delimiters in the second character string, store all characters between adjacent delimiters in sequence according to the delimiters in the second one-dimensional array, and extract the calculated coordinate starting position and the number of inflection points of each block from the second one-dimensional array and store them in a second two-dimensional array; A text writing module is used to write the mining area number, registration classification number and range coordinate field identifier into a preset text file as the starting line of the range coordinate field; according to the starting position of the range coordinates of each block stored in the first two-dimensional array and the number of inflection points, in combination with the encoding rule of the first character string, the inflection point sequence number, the X coordinate and the Y coordinate of the inflection point are read from the first one-dimensional array in sequence to form a coordinate pair format, which is written into the starting line of the range coordinate field in the preset text file until all blocks are processed; and to write the mining area number, registration classification number and calculated coordinate field identifier into a preset text file as the starting line of the calculated coordinate field; according to the starting position of the calculated coordinates of each block stored in the second two-dimensional array and the number of inflection points, in combination with the encoding rule of the second character string, the inflection point sequence number, the X coordinate and the Y coordinate of the inflection point are read from the second one-dimensional array in sequence to form a coordinate pair format, which is written into the starting line of the calculated coordinate field in the preset text file until all blocks are processed.

8. A device for batch rapid conversion of mineral resource reserve database coordinate formats, characterized in that: Used to convert coordinate pairs to string format, including: A text acquisition module, used to acquire a preset text file storing a target mining area or mine coordinate pair; The mining area information positioning module is used to locate the row where the mining area number is located in the preset text file, record it as the starting row; and read the mining area number, registration classification number and coordinate field identifier in the starting row and write them into the first three columns of the same row of the third two-dimensional array A string writing module is used to read subsequent rows after the starting row, convert the coordinate pairs in the subsequent rows into strings and connect them until a preset end character is read, and write the string at this time into the fourth column of the row where the mining area number currently located in the third two-dimensional array is located; the preset end character is used to indicate that all block information contained in the mining area number currently located ends here; A table acquisition module is used to obtain a coordinate management table of a target mining area or mine from a mineral resource reserve database; The table update module is used to traverse all row coordinate records in the coordinate management table, use the mining area number and registration classification number in a single row coordinate record as keywords, search in the third two-dimensional array, and if there is a matching result, replace the range coordinate string and calculated coordinate string in the coordinate management table with the string in the fourth column of the matching row to update the coordinate management table.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, the method according to any one of claims 1 to 6 is implemented.

10. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.

Images