Control method and equipment of electric geological terrain sand table and storage medium

Abstract

The invention discloses a control method and device of an electric geological terrain sand table and a storage medium, and relates to the technical field of methods. The sand table comprises the following steps: acquiring DEM data and corresponding color information of a target area, and constructing an electric geological terrain sand table; based on the DEM data, aggregating corresponding area data by adopting a mean value integral method to obtain elevation data with the same size as a lifting column in the sand table body; the size comprises a data volume and the number of rows and columns; and calculating the cylinder pop-up time of the lifting column based on the elevation data, controlling the height of the lifting column according to the cylinder pop-up time to obtain the sand table shape of the target area, and finally projecting the color information to the surface of the sand table by using the projector. According to the invention, the shape and color of the geological terrain sand table can be controlled through DEM data, and help is provided for geological work.

Description

Technical Field

[0001] The present invention relates to the technical field of sand tables, and in particular to a control method, device and storage medium for an electric geological terrain sand table. Background Art

[0002] At present, geological mapping work mainly uses standard map sheets with a scale of 1:50,000. The area of each map sheet is approximately 300 km 2 , and the working area is relatively large. Geological staff conduct geological mapping through on-site surveys, which brings inconvenience to the scientific layout of routes and the study of geological origins. Therefore, current traditional sand tables need to be customized by merchants and are in a fixed form. They cannot be reused, and some contour data is confidential. Summary of the Invention

[0003] The purpose of the present invention is to provide a control method, device and storage medium for an electric geological terrain sand table, which can control the shape and color of the geological terrain sand table through DEM data to assist in carrying out geological work.

[0004] To achieve the above object, the present invention provides the following solutions:

[0005] A control method for an electric geological terrain sand table includes:

[0006] Obtain DEM data of a target area and corresponding color information, and construct an electric geological terrain sand table; the electric geological terrain sand table includes a sand table body, a support arm and a projector; the bottom end of the support arm is fixed on the sand table body, and the top end is fixedly connected to the projector;

[0007] Based on the DEM data, use the mean integral method to aggregate data of corresponding areas to obtain elevation data with the same size as the lifting columns in the sand table body; the size includes data volume and number of rows and columns;

[0008] Calculate the cylinder ejection time of the lifting column based on the elevation data, control the height of the lifting column according to the cylinder ejection time to obtain the shape of the sand table in the target area, and finally project the color information onto the surface of the sand table by using the projector.

[0009] Optionally, the shape of the lifting column is pointed at the top and thick at the bottom, and the circumference is threaded.

[0010] Optionally, the step of, based on the DEM data, using the mean integral method to aggregate data of corresponding areas to obtain elevation data with the same size as the lifting columns in the sand table body specifically includes:

[0011] Determine target grids according to the layout of the lifting columns in the sand table body;

[0012] Perform rasterization processing on the DEM data to obtain a DEM raster and corresponding data;

[0013] Adopt the mean integration method to aggregate the DEM raster and corresponding data into the target raster to obtain elevation data with the same size as the lifting columns in the sand table body.

[0014] Optionally, the process of adopting the mean integration method to aggregate the DEM raster and corresponding data into the target raster to obtain elevation data with the same size as the lifting columns in the sand table body specifically includes:

[0015] Set the data in the DEM raster as r(x, y), and the data in the target raster as h(i, j);

[0016] Since the data in each target raster is the integration result of a D1×D2 area in the DEM raster, the mean integration method is adopted to aggregate the corresponding area data, converting the large-scale data into small-scale data to obtain elevation data with the same size as the lifting columns in the sand table body;

[0017] Among them, D1×D2 = (x max / i max )×(y max / j max ), x max represents the maximum number of rows of the DEM raster data, i max represents the maximum number of rows of the target raster, y max represents the maximum number of columns of the DEM raster data, j max represents the maximum number of columns of the target raster.

[0018] Optionally, the elevation data is specifically expressed as:

[0019]

[0020] Among them, i, j≥1; x, y≥0; the row range of the DEM data raster corresponding to the i-th target raster cell is [D1(i - 1), D1i - 1], D1(i - 1) is the minimum row value, and D1i - 1 is the maximum row value; the column range corresponding to the j-th target raster cell is [D2(j - 1), D2j - 1], D2(j - 1) is the minimum column value, and D2j - 1 is the maximum column value.

[0021] Optionally, the cylinder ejection time is specifically expressed as:

[0022]

[0023] Among them, T max represents the time required for the lifting column to lift to the maximum height, h max represents the maximum elevation data.

[0024] The present invention also provides an electronic device, including a memory and a processor. The memory is used for storing a computer program, and the processor runs the computer program to enable the electronic device to execute the control method of the electric geological terrain sand table according to the above.

[0025] The present invention also provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the control method of the electric geological terrain sand table as described above is implemented.

[0026] According to the specific embodiments provided by the present invention, the following technical effects are disclosed by the present invention:

[0027] The present invention discloses a control method, device and storage medium of an electric geological terrain sand table. The method includes obtaining DEM data of a target area and corresponding color information, and constructing an electric geological terrain sand table; based on the DEM data, aggregating the data of the corresponding area by using the mean integral method to obtain elevation data with the same size as the lifting columns in the sand table body; the size includes the data volume and the number of rows and columns; calculating the cylinder ejection time of the lifting columns based on the elevation data, and controlling the height of the lifting columns according to the cylinder ejection time to obtain the sand table shape of the target area, and finally projecting the color information onto the sand table surface by using the projector. The present invention can control the shape and color of the geological terrain sand table through DEM data, and provide help for carrying out geological work. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required to be used in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0029] Figure 1 It is a schematic flow chart of the control method of the electric geological terrain sand table of the present invention;

[0030] Figure 2 It is a schematic structural diagram of the sand table in this embodiment; wherein, Figure 2 (a) is a schematic external view of the overall sand table; Figure 2 (b) is a front view of the lifting structure; Figure 2 (c) is a top view of the lifting structure; Figure 2 (d) is a connection diagram between bevel gears.

[0032] Reference numerals: 1, sensor; 2, USB interface; 3, motor; 4, lifting column; 5, rotating rod a; 6, rotating rod b; 7, bevel gear; 8, cylinder. Detailed implementation manners

[0033] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. 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.

[0034] The purpose of the present invention is to provide a control method, device and storage medium for an electric geological terrain sand table, which can control the shape and color of the geological terrain sand table through DEM data to help carry out geological work.

[0035] To make the above objects, features and advantages of the present invention more obvious and understandable, the present invention will be further described in detail below with reference to the accompanying drawings and specific implementation manners.

[0036] As Figure 1 shown, the present invention provides a control method for an electric geological terrain sand table. Geological workers can generate a geological terrain sand table through DEM data and modify the sand table through different DEM data, eliminating the above inconveniences and providing help for the development of geological work. The specific control steps include:

[0037] Step 100: Obtain the DEM data of the target area and the corresponding color information, and construct an electric geological terrain sand table; the electric geological terrain sand table includes a sand table body, a support arm and a projector; the bottom end of the support arm is fixed on the sand table body, and the top end is fixedly connected to the projector.

[0038] Step 200: Based on the DEM data, aggregate the data of the corresponding area by the mean integral method to obtain elevation data with the same size as the lifting column 4 in the sand table body; the size includes the data volume and the number of rows and columns.

[0039] Step 300: Calculate the pop-up time of the cylinder 8 of the lifting column 4 based on the elevation data, control the height of the lifting column 4 according to the pop-up time of the cylinder 8 to obtain the sand table shape of the target area, and finally project the color information onto the sand table surface by using the projector.

[0040] As a specific implementation, the present invention is based on DEM data to produce a geological terrain sand table, making geological work more scientific and convenient. Based on the DEM data, using the resampling function of arcgis software, the DEM data is resampled to obtain new elevation values with the same number of grids as the matrix of the lifting column 4. Using the raster to point function, the new elevation values are assigned to points, and then the new elevation values are exported. The pop-up time of the cylinder 8 is calculated through a formula, and the matrix of the lifting column 4 constitutes the sand table of the DEM area. Above the lifting column 4 is a rubber material surface with elasticity to achieve a smooth and fluent sand table surface. The image is projected onto the rubber surface through a projector to achieve the purpose of more intuitively studying the geographical environment of the working area.

[0041] Based on the above technical solutions, the following embodiments are provided.

[0042] In this embodiment, first, the structure of the electric geological terrain sand table is described. The sand table is composed of a USB port, a sensor 1, a motor 3, a rotating rod a 5, a rotating rod b 6, a cylinder 8, a lifting column 4, a rubber surface, and a projector. The sensor 1 is connected to the cylinder 8, the motor 3, and the USB port, and controls the cylinder 8 and the motor 3 through the data transmitted through the USB. The USB port receives the pop-up time data of the cylinder 8, resamples the DEM data using arcgis software, converts the raster to points, assigns the elevation values to the points, exports the point attributes to excel, and calculates the pop-up time of the cylinder 8 through a formula. The motor 3 is connected to the rotating rod a 5. The rotating rod a 5 is connected to the rotating rod b 6 to provide power for the lifting column 4. There is one rotating rod b 6 perpendicular to the rotating rod a 5 and connected to each row of the lifting column 4. The top of the cylinder 8 is connected to a bevel gear 7. After the cylinder 8 pops up, it is connected to the rotating rod b 6, and when the cylinder 8 does not pop up, it is not connected to the rotating rod b 6. The lifting column 4 is thick at the bottom and sharp at the top, with threads around its circumference, and the upper end is connected to the rubber surface to reduce the contact area. The rubber surface is made of a highly elastic material. The projector is located at the top of the sand table and projects the image onto the sand table to achieve the purpose of coloring the sand table.

[0043] In addition, it further includes a base, and a plurality of vertically arranged threaded through holes are arrayed on the base, and a plurality of lifting rods are respectively threadedly connected in the threaded through holes.

[0044] Then, based on the above-constructed sand table composition, the following algorithm scheme is used for control.

[0045] Data processing of the present invention: Make the number of elevation data the same as the number of the lifting column 4 and the number of rows and columns the same (for example: the number of rows and columns of the lifting column 4 is 100×100, the raster data is 20m, and the number of rows and columns is 500×500, then resample to 100m×100m). Convert the raster to points, assign the elevation values to the points, export the point attributes to excel, and calculate the pop-up time of the cylinder 8 through a formula. The specific process is as follows:

[0046] The DEM raster data is r(x, y), and the data of the target raster is h(i, j). The target raster has the same number of rows and columns and the same data volume as the lifting column 4.

[0047] The number of rows and columns of the target raster corresponding to the original raster area is:

[0048] (x max / i max ) × (y max / j max ) = D1 × D2

[0049] Each target raster value is the integration result of a D1×D2 area in the original raster. Therefore, the mean integration method is used to aggregate the data in the corresponding area and convert the large-scale data into small-scale data, that is:

[0050]

[0051] where i, j ≥ 1; x, y ≥ 0; the row range of the i-th target raster cell corresponding to the DEM data raster is [D1(i - 1), D1i - 1], D1(i - 1) is the minimum row value, and D1i - 1 is the maximum row value; the column range corresponding to the j-th target raster cell is [D2(j - 1), D2j - 1], D2(j - 1) is the minimum column value, and D2j - 1 is the maximum column value.

[0052] The maximum elevation value of the obtained h(i, j) is h max , and the known time required for the lifting column 4 to lift the maximum height is T max , then calculate the ejection time of the cylinder 8:

[0053]

[0054] where T max represents the time required for the lifting column 4 to lift the maximum height, and h max represents the maximum elevation data.

[0055] As Figure 2 shown, the data links each cylinder 8 through the sensor 1 and controls the ejection time of the cylinder 8; the motor 3 is connected to a rotating rod a 5. Since there is one motor 3 in the present invention, the rotating rod a 5 can only provide rotational force for one row. If the lifting column 4 is a 100×100 matrix, then 100 rotating rods b 6 are required to be vertically connected to the rotating rod a 5 to provide rotational force for 100 columns of the lifting column 4. Each lifting column 4 has a thread, and the connection method is as Figure 2 shown in (c); the front end of each cylinder 8 is a bevel gear 7 that can be connected to the rotating rod b 6, and a threaded connecting rod is provided behind the bevel gear 7 to connect to the lifting column 4, as Figure 2As shown in Figure (d), when the cylinder 8 pops out, the bevel gear 7 connects the rotary rod b 6 and the lifting column 4, providing lifting power for the lifting column 4; conversely, if the cylinder 8 does not pop out, the rotary rod a 5 and the rotary rod b 6 are not connected, and the lifting column 4 remains stationary. The working time of the motor 3 is Tmax. Before the motor 3 starts working, the cylinder 8 corresponding to the lifting column 4 with a lifting time T = 0 pops out first to lift the lifting column 4 corresponding to the maximum elevation value of the map to the corresponding height position. Then, according to the terrain height gradient distribution, the lifting columns at the corresponding positions of the remaining parts are lifted in sequence; there is an elastic rubber sheet at the top of the sand table, and the rubber sheet is adhered to each lifting column 4 below. After the sand table is made, its surface is smooth; the projector is connected to the sand table through a support arm, and the color map is vertically projected onto the surface of the sand table to achieve the purpose of coloring the sand table.

[0056] In this specification, each embodiment is described in a progressive manner. The key point of each embodiment is to illustrate the differences from other embodiments. For the same or similar parts among the embodiments, reference can be made to each other.

[0057] In this article, specific examples are used to elaborate on the principle and implementation manner of the present invention. The description of the above embodiments is only used to help understand the core idea of the present invention; at the same time, for those of ordinary skill in the art, according to the idea of the present invention, there will be changes in the specific implementation manner and application scope. In summary, the content of this specification should not be construed as a limitation to the present invention.

Claims

1. A control method for an electric geological terrain sand table, characterized in that: include: Obtain DEM data and corresponding color information of the target area, and construct an electric geological topography sand table; the electric geological topography sand table includes a sand table body, a support arm and a projector; the bottom end of the support arm is fixed on the sand table body, and the top end is fixedly connected to the projector; Based on the DEM data, the corresponding regional data is aggregated by using the mean integral method to obtain elevation data with the same size as the lifting column in the sand table body; the size includes the data volume and the number of rows and columns; The cylinder ejection time of the lifting column is calculated based on the elevation data, and the height of the lifting column is controlled according to the cylinder ejection time to obtain the sand table shape of the target area, and finally the color information is projected onto the sand table surface using the projector.

2. The control method of the electric geological terrain sand table according to claim 1 is characterized in that: The lifting column is in the shape of being pointed at the top and thick at the bottom, and having a spiral shape all around.

3. The control method of the electric geological terrain sand table according to claim 1 is characterized in that: Based on the DEM data, the corresponding regional data is aggregated by the mean integral method to obtain elevation data with the same size as the lifting column in the sand table body, specifically including: Determine the target grid according to the layout of the lifting columns in the sand table body; Performing rasterization processing on the DEM data to obtain a DEM raster and corresponding data; The mean integral method is used to aggregate the DEM grid and the corresponding data into the target grid to obtain elevation data with the same size as the lifting column in the sand table body.

4. The control method of the electric geological terrain sand table according to claim 3 is characterized in that: The mean integral method is used to aggregate the DEM grid and the corresponding data into the target grid to obtain elevation data with the same size as the lifting column in the sand table body. The specific process includes: Set the data in the DEM grid to r(x, y) and the data in the target grid to h(i, j); Since the data in each target grid is the integral result of a D1×D2 area in the DEM grid, the mean integral method is used to aggregate the corresponding regional data, convert the large-scale data into small-scale data, and obtain the elevation data with the same size as the lifting column in the sand table body; Where D1×D2=(x max / i max )×(y max / j max ), x max Indicates the maximum number of rows of DEM raster data, i max Indicates the maximum number of rows in the target grid, y max Indicates the maximum number of columns of DEM raster data, j max Indicates the maximum number of columns in the target grid.

5. The control method of the electric geological terrain sand table according to claim 4 is characterized in that: The elevation data is specifically expressed as: Among them, i, j ≥ 1; x, y ≥ 0; the row range of the DEM data grid corresponding to the i-th target grid cell is [D1(i-1), D1i-1], D1(i-1) is the minimum value of the row, and D1i-1 is the maximum value of the row; the column range corresponding to the j-th target grid cell is [D2(j-1), D2j-1], D2(j-1) is the minimum value of the column, and D2j-1 is the maximum value of the column.

6. The control method of the electric geological terrain sand table according to claim 5 is characterized in that: The cylinder ejection time is specifically expressed as: Among them, T max Indicates the time required for the lifting column to reach the maximum height, h max Indicates the maximum elevation data.

7. An electronic device, characterized in that: It comprises a memory and a processor, the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to execute the control method of the electric geological terrain sandbox according to any one of claims 1-6.

8. A computer-readable storage medium, characterized in that: It stores a computer program, which, when executed by a processor, implements the control method of the electric geological terrain sandbox as described in any one of claims 1-6.

Images