JP7480030B2 - Prospecting information management device, method, and program - Google Patents

Description

The present invention relates to a prospecting information management device, a prospecting information management method, and a prospecting information management program.

In the past, test excavation of roads was conducted to identify buried objects during construction to remove utility poles and to update gas, water, electricity, and communications. One test excavation method proposed for identifying the location of buried cables is shown in Patent Document 1. In the technique described in Patent Document 1, while excavating the ground with an excavator, the magnetic flux density B is measured at two points, a first point above the buried cable and a second point a distance Δ away from the first point, and the ratio of the magnetic flux density B at the two measured points is calculated to calculate the rate of change W of the magnetic flux density B at the first point. The distance L from the first point to the buried cable is estimated based on the calculated rate of change W of the magnetic flux density B, and the excavation of the ground is switched from the excavator to hand digging when the distance L to the buried cable reaches the switching distance.

JP 2012-58190 A

At the trial excavation site, the installation status of the underground buried pipes is confirmed, photographs are taken, sketches are made of the installation status, various measurements are made, and then the area is immediately backfilled in order to lift traffic restrictions as soon as possible. For this reason, unless the road administrator or buried object manager is present at the site, the actual trial excavation status cannot be accurately confirmed. Also, in renewal work by occupying companies for gas, water, electricity, communications, etc., each company independently conducts trial excavation for each renewal work related to its own business, so there are cases where a different company will conduct trial excavation again in an area where one company conducted trial excavation and backfilled. This situation leads to problems such as high trial excavation costs, burdens on residents living along the road, and an increase in industrial waste generated during trial excavation work.

The present invention has been made in consideration of the above points, and aims to provide a prospecting information management device, method, and program that can reduce duplicate prospecting work.

In order to achieve the above object, the borehole information management device of the present invention includes an acquisition unit that acquires a plurality of images of an area including a borehole and position information of the borehole, a generation unit that generates three-dimensional data of the borehole from the plurality of images acquired by the acquisition unit, a storage control unit that associates the position information of the borehole acquired by the acquisition unit with the three-dimensional data generated by the generation unit and stores them in a storage unit, and a display control unit that, when position information is specified, reads out from the storage unit the three-dimensional data of the borehole that corresponds to the specified position information, and displays a three-dimensional image of the three-dimensional data on a display device.

According to the test drilling information management device of the present invention, the acquisition unit acquires multiple images of an area including a test drill hole and position information of the test drill hole, the generation unit generates three-dimensional data of the test drill hole from the multiple images acquired by the acquisition unit, the memory control unit associates the position information of the test drill hole acquired by the acquisition unit with the three-dimensional data generated by the generation unit and stores them in the memory unit, and when position information is specified, the display control unit reads out the three-dimensional data of the test drill hole corresponding to the specified position information from the memory unit and displays a three-dimensional image of the three-dimensional data visualized on the display device. This makes it possible to centrally manage underground buried object information and reduce duplicate test drilling work.

The acquisition unit can also acquire, as the multiple images, multiple still images of the borehole taken from multiple different angles. This makes it possible to acquire images for generating three-dimensional data with high accuracy.

The acquisition unit can also acquire a video of the borehole, and acquire, as the multiple images, multiple frame images of the borehole captured from multiple different angles from among multiple frame images constituting the video. This makes it possible to efficiently acquire images for generating three-dimensional data with high accuracy.

The acquisition unit can also transmit instructions to photograph the borehole from a number of different angles. This allows a user to take appropriate images even if they are not an expert in taking images to generate accurate three-dimensional data.

The acquisition unit further acquires information on the type of piping present in the borehole, and the display control unit can display the three-dimensional image with information that can identify the type of piping. This allows users other than those familiar with various types of piping to easily understand the type of piping that is buried when viewing the image.

The display control unit can also display the piping parts included in the three-dimensional image in different colors depending on the type of piping. This allows the user to intuitively identify the buried piping even when multiple types of piping are buried.

The acquisition unit also acquires the multiple images captured by an imaging device having a function for measuring the position of the device itself, and acquires the position information of the imaging device when the multiple images were captured by the imaging device, and the display control unit accepts the position of the display device, which has a function for measuring the position of the device itself, measured at the site after the test drilling is backfilled, as the designation of the position information. This makes it easy to acquire the position information to be stored in association with the three-dimensional data, and to designate the test drilling hole for which a three-dimensional image is to be displayed.

The generation unit also sets a reference point in the generated three-dimensional data, and when a marker is read by the display device having a marker reading function, the display control unit can display the three-dimensional image on the display device in a position and orientation that corresponds to the positional relationship between the display device and the marker, with the reference point being aligned with the position of the marker. This makes it possible to display a three-dimensional image in a state that makes it easy to intuitively grasp the excavation situation. In particular, when a marker placed at a site after the excavation has been backfilled is read, the three-dimensional image can be displayed in a state that makes it easy to grasp the situation at the site after the excavation has been backfilled.

The display control unit can also display on the display device an augmented reality image that combines an image captured by the display device having a shooting function with the three-dimensional image. This makes it possible to display a three-dimensional image with a sense of realism.

The display control unit can display a map on which symbols are arranged at positions corresponding to the position information stored in the storage unit, and when any symbol is selected from the map, can display on the display device a three-dimensional image that visualizes the three-dimensional data associated with the position information corresponding to the position of the selected symbol. This allows local government road managers, etc. to centrally manage the trial excavation status of roads under their management.

The acquisition unit can further acquire other information related to the test drilling, and the display control unit can display the other information related to the test drilling on the display device together with the three-dimensional image. This allows the user to grasp the details of the test drilling situation.

The drilling information management method according to the present invention is a method in which an acquisition unit acquires a plurality of images of an area including a drilling hole and position information of the drilling hole, a generation unit generates three-dimensional data of the drilling hole from the plurality of images acquired by the acquisition unit, a storage control unit associates the position information of the drilling hole acquired by the acquisition unit with the three-dimensional data generated by the generation unit and stores them in a storage unit, and a display control unit, when position information is specified, reads out from the storage unit the three-dimensional data of the drilling hole corresponding to the specified position information, and displays a three-dimensional image of the three-dimensional data on a display device.

The drilling information management program of the present invention is a program for causing a computer to function as an acquisition unit that acquires a plurality of images of an area including a drill hole and position information of the drill hole, a generation unit that generates three-dimensional data of the drill hole from the plurality of images acquired by the acquisition unit, a storage control unit that associates the position information of the drill hole acquired by the acquisition unit with the three-dimensional data generated by the generation unit and stores them in a storage unit, and a display control unit that, when position information is specified, reads out from the storage unit the three-dimensional data of the drill hole that corresponds to the specified position information and displays a three-dimensional image of the three-dimensional data on a display device.

The prospecting information management device, method, and program of the present invention can reduce duplicate prospecting work.

FIG. 2 is a block diagram showing the schematic configuration of a prospecting information management system. 2 is a block diagram showing the hardware configuration of the prospecting information management device. FIG. FIG. 13 is a diagram for explaining photographing a borehole. FIG. 13 is a diagram for explaining the generation of three-dimensional data of a borehole. FIG. 2 is a diagram showing an example of a prospecting information DB. FIG. 13 is a diagram showing an example of a position designation screen. FIG. 13 is a diagram illustrating an example of a viewing screen. FIG. 13 is a diagram showing an example of a marker. FIG. 13 is a diagram for explaining reading of a marker. FIG. 13 is a diagram for explaining an example of a display mode of a three-dimensional image of a borehole. FIG. 13 is a diagram for explaining another example of the display mode of a three-dimensional image of a borehole. FIG. 1 illustrates an example of a dashboard. 13 is a flowchart illustrating an example of a registration process. 10 is a flowchart illustrating an example of a first display process. 10 is a flowchart illustrating an example of a second display process.

An example of an embodiment of the present invention will be described below with reference to the drawings.

As shown in FIG. 1, the drilling information management system 100 according to this embodiment includes a drilling information management device 10 and user terminals 30A, 30B, and 30C. The drilling information management device 10 and each of the user terminals 30A, 30B, and 30C are connected via a network. Note that the number of user terminals 30A, 30B, and 30C is not limited to the example shown in FIG. 1.

User terminal 30A is an information processing terminal operated by a person in charge of the trial excavation work at the site of the trial excavation work. User terminal 30B is an information processing terminal operated by a person in charge of the business operator who is going to carry out the trial excavation work. User terminal 30C is an information processing terminal operated by, for example, a local government road administrator who manages roads including repairs. User terminals 30A, 30B, and 30C can all be realized by information processing terminals with similar functions, but in this embodiment, for convenience of explanation, different reference numerals are given to the terminals according to the differences in the users who operate them, as described above. Note that when explaining each of user terminals 30A, 30B, and 30C without distinction, they will simply be referred to as "user terminal 30".

In the user terminal 30, applications provided by the drilling information management system 100 are installed and run. Alternatively, the applications may be available via a web browser running on the user terminal 30. The user terminal 30 has a display function, an information input function, and a communication function.

In addition to the above functions, the user terminal 30A further has a photographing function for photographing the part including the borehole, and a positioning function for measuring the position of the terminal by, for example, GPS (Global Positioning System). For example, the user terminal 30A can be realized by a smartphone, a tablet terminal, etc. The image taken by the photographing function may be a video or a still image. Note that the user terminal 30A is not limited to having a photographing function, and the user terminal 30A may be configured to import images taken by a digital camera or the like. In addition, the position of the user terminal 30A when the image is taken by the photographing function is measured as the position information of the borehole by the positioning function. The position information is absolute coordinates represented by latitude and longitude. The measured position information may be manually corrected by the person operating the user terminal 30A. The user terminal 30A transmits the borehole information including the multiple images (multiple still images or videos) taken or imported, the measured position information of the borehole, and other information related to the borehole to the borehole information management device 10.

In addition to the above functions, the user terminal 30B may further have a reading function for reading markers (described in detail below) and a positioning function for measuring the position of the terminal, for example, by GPS or the like. For example, the user terminal 30B may be realized by a personal computer, a smartphone, a tablet terminal, a head mounted display (HMD, Head Mounted Display), etc. When an application is started and the user selects viewing of drilling information from a menu, the user terminal 30B accepts the designation of position information (described in detail below) and transmits the accepted position information to the drilling information management device 10. The user terminal 30B also receives screen data for displaying a three-dimensional image of the drilling hole (described in detail below) from the drilling information management device 10 and displays it on the display unit provided in the user terminal 30B. The user terminal 30B also accepts an operation on the displayed three-dimensional image, transmits the contents of the accepted operation to the drilling information management device 10, and receives screen data updated according to the contents of the operation.

The user terminal 30C can be realized, for example, by a personal computer, a smartphone, a tablet terminal, etc. When an application is started and the user selects display of a dashboard (described in detail later) from a menu, the user terminal 30C transmits a dashboard display request to the prospecting information management device 10. The user terminal 30C also receives dashboard screen data from the prospecting information management device 10 and displays it on a display unit provided in the user terminal 30C. The user terminal 30C also accepts operations on the dashboard, transmits the contents of the accepted operations to the prospecting information management device 10, and receives screen data updated according to the contents of the operations.

The drilling information management device 10 can be realized by an information processing device such as a server device located in a management center or cloud at a business providing services using the drilling information management system 100, or a personal computer.

Figure 2 is a block diagram showing the hardware configuration of the drilling information management device 10 according to this embodiment. As shown in Figure 2, the drilling information management device 10 has a CPU (Central Processing Unit) 42, a memory 44, a storage device 46, an input device 48, an output device 50, a storage medium reading device 52, and a communication I/F (Interface) 54. Each component is connected to each other so as to be able to communicate with each other via a bus 56.

The storage device 46 stores a prospecting information management program for executing the registration process and display process described below. The CPU 42 is a central processing unit, and executes various programs and controls each component. That is, the CPU 42 reads the program from the storage device 46 and executes the program using the memory 44 as a working area. The CPU 42 controls each of the components and performs various calculation processes according to the program stored in the storage device 46.

The memory 44 is made up of RAM (Random Access Memory) and serves as a working area to temporarily store programs and data. The storage device 46 is made up of ROM (Read Only Memory), HDD (Hard Disk Drive), SSD (Solid State Drive), etc., and stores various programs including the operating system and various data.

The input device 48 is a device for performing various inputs, such as a keyboard or a mouse. The output device 50 is a device for outputting various information, such as a display or a printer. A touch panel display may be used as the output device 50 to function as the input device 48. The storage medium reading device 52 reads data stored in various storage media, such as a CD (Compact Disc)-ROM, a DVD (Digital Versatile Disc)-ROM, a Blu-ray disc, and a USB (Universal Serial Bus) memory, and writes data to the storage media.

The communication I/F 54 is an interface for communicating with other devices, and uses standards such as Ethernet (registered trademark), FDDI, or Wi-Fi (registered trademark).

The drilling information management device 10 may be configured so that data and the like are distributed across multiple hardware devices on the cloud service side. In this case, multiple computers with the hardware configuration shown in FIG. 2 may be configured to operate in cooperation with each other via a communication I/F.

As shown in FIG. 1, the drilling information management device 10 functionally includes an acquisition unit 12, a generation unit 14, a storage control unit 16, and a display control unit 20. A drilling information database (DB) 18 is stored in a predetermined storage area of the drilling information management device 10. Each functional configuration is realized by the CPU 42 reading out the drilling information management program stored in the storage device 46, expanding it in the memory 44, and executing it.

The acquisition unit 12 acquires the drilling information transmitted from the user terminal 30A. As described above, the drilling information includes a plurality of images (a plurality of still images or video) of the area including the drilling hole, position information of the drilling hole, and other information related to the drilling. When acquiring a plurality of still images as the plurality of images, the acquisition unit 12 acquires a plurality of still images (e.g., 100 images) of the drilling hole taken from each of a plurality of different angles by the user terminal 30A, as shown in FIG. 3. The acquisition unit 12 may also acquire a video of the drilling hole taken by the user terminal 30A, and acquire a plurality of frame images (e.g., 100 images) of the drilling hole taken from each of a plurality of different angles from among the plurality of frame images constituting the video as the plurality of images.

In the above case, the acquisition unit 12 can transmit instructions to the user terminal 30A to photograph the borehole from each of a plurality of different angles. For example, the acquisition unit 12 can display on the user terminal 30A a lecture video, a message, or the like for photographing the borehole from each of a plurality of different angles. In addition, the acquisition unit 12 may display on the user terminal 30A a trajectory indicating the direction in which the imaging device (user terminal 30A) should be moved relative to the borehole when the video is being captured on the user terminal 30A, so that the position and attitude of the imaging device relative to the borehole are different at each time during the video capture. In addition, the acquisition unit 12 may instruct the user terminal 30A to have an overlapping portion with other still images when still images are captured.

As described above, the acquisition unit 12 acquires absolute coordinates expressed in latitude and longitude as the location information of the test hole. In addition to the location information expressed in absolute coordinates, the acquisition unit 12 may acquire information for identifying the location where the test hole was backfilled, such as a specific part of a building, a manhole cover number, a road boundary, and cutter marks made when the test hole was backfilled. Using this auxiliary information, the test hole backfilling location can be specifically identified at the site after the test hole has been backfilled.

The acquisition unit 12 can also acquire information on the type of piping present in the borehole as other information related to the borehole. For example, the user can specify the location of the piping in an image captured by the user terminal 30A and input the type of piping, thereby tagging the captured image with the type of piping. As a result, the acquisition unit 12 acquires images tagged with the type of piping from the user terminal 30A.

The acquisition unit 12 can also acquire other information related to the trial excavation, such as the trial excavation date, the business operator in charge, the construction contractor, the purpose of the trial excavation, and various measurement data input by the user via the user terminal 30A, as well as other information related to the trial excavation.

As shown in FIG. 4, the generating unit 14 generates three-dimensional data of the borehole from the multiple images acquired by the acquiring unit 12. Existing software can be used to generate this three-dimensional data, so a detailed description of the generation method will be omitted. The generating unit 14 also sets a reference point (for example, the position of the star in FIG. 4) in the generated three-dimensional data. The three-dimensional data reproduces the three-dimensional shape of the part that includes the actual borehole, and the position of each point of the three-dimensional shape is specified in the three-dimensional data as a relative coordinate from the reference point. Therefore, various data such as the distance from the ground surface to the buried pipe and the volume of the borehole can be measured based on the three-dimensional data.

The storage control unit 16 stores the position information of the borehole acquired by the acquisition unit 12 and the three-dimensional data generated by the generation unit 14 in association with each other in the borehole information DB 18. FIG. 5 shows an example of the borehole information DB 18. In the example of FIG. 5, the "position information" is latitude and longitude indicating the absolute coordinates of the position information of the borehole. In addition, in the example of FIG. 5, the borehole information DB 18 also stores other information related to boreholes other than the "position information" and "three-dimensional data" (in the example of FIG. 5, "pipe type" and "work date"), and each row (each record) of the borehole information DB 18 corresponds to one piece of borehole information. In addition, the borehole information DB 18 may also store multiple still images or videos that were the basis for generating the three-dimensional data.

When viewing of test drilling information is selected from the menu in the user terminal 30B, the display control unit 20 causes the display unit of the user terminal 30B to display, for example, a position specification screen 32 as shown in FIG. 6. A map of the range specified by the user is displayed on the position specification screen 32. The display control unit 20 acquires the latitude and longitude of the position selected by the user on the map as position information. Note that the specification of the position information in the user terminal 30B is not limited to the specification method using a map as shown in FIG. 6, and the latitude and longitude may be specified directly, or an address that can be converted into latitude and longitude information may be specified. In addition, the display control unit 20 may accept the position of the user terminal 30B measured at the site after test drilling backfilling by the positioning function of the user terminal 30B as the specified position information.

When the display control unit 20 acquires the location information specified by the user terminal 30B, it reads out from the drilling information DB 18 three-dimensional data of the drilling hole corresponding to the specified location information. Note that the specified location information does not need to match the location information stored in the drilling information DB 18 exactly. It is sufficient to read out three-dimensional data corresponding to the location information in the drilling information DB 18 whose difference from the specified location information is within a predetermined range.

The display control unit 20 then generates screen data for displaying a three-dimensional image obtained by visualizing the read three-dimensional data, and transmits the generated screen data to the user terminal 30B. As a result, a viewing screen 34, for example, as shown in FIG. 7 is displayed on the display unit of the user terminal 30B. If the image from which the three-dimensional data was generated is tagged with the type of piping, the display control unit 20 displays the piping parts included in the three-dimensional image with information that can identify the type of piping. For example, the display control unit 20 can display the piping parts in different colors depending on the type of piping, or display a label indicating the type of piping, as shown in the upper diagram of FIG. 7.

In addition, the display control unit 20 can rotate and display the three-dimensional image in any direction as shown in FIG. 7 in response to an operation instruction from a user operating the user terminal 30B. The display control unit 20 can also accept a specification of a slice position for the three-dimensional image and display a cross-sectional image of the specified slice position. As described above, since various data of the borehole can be measured based on the three-dimensional data, the display control unit 20 can display measurement data related to an item specified by the user (e.g., the distance from the ground surface to the buried pipe, the volume of the borehole, etc.) superimposed on the three-dimensional image.

The display control unit 20 may also display a three-dimensional image corresponding to the position and attitude of the user terminal 30B on the user terminal 30B, with the reference point set in the three-dimensional data being aligned with the position of the marker read by the reading function of the user terminal 30B. Specifically, the display control unit 20 first instructs the user terminal 30B to photograph the marker using a photographing device provided on the user terminal 30B in order to match the reference point with the position of the marker. In this case, the position of the marker may be the position indicated by the latitude and longitude, which are the position information of the test hole, or may be a position that serves as a marker for the location where the test hole has been backfilled, such as a cutter mark at the site after the test hole has been backfilled, or may be any position other than the test hole.

For example, as shown in FIG. 8, a marker 36 on which a two-dimensional code indicating the position information of a borehole specified by a user (a business operator performing borehole work) is drawn is delivered to the user in advance. Then, as shown in FIG. 9, when the two-dimensional code drawn on the printed marker 36 is read by the user terminal 30B, the display control unit 20 acquires a three-dimensional image generated from the three-dimensional data stored in association with the position information indicated by the two-dimensional code, and information on the position and attitude of the user terminal 30B. The position and attitude of the user terminal 30B at the time of reading the marker 36 are set as the initial position and attitude. The display control unit 20 matches the reference point set in the three-dimensional data that is the source of the acquired three-dimensional image with the position of the read marker 36, and displays the three-dimensional image so that the state in which the three-dimensional data is expanded in the direction according to the attitude of the acquired user terminal 30B is displayed on the display unit of the user terminal 30B. The display control unit 20 detects changes in the position and attitude of the user terminal 30B, and rotates and moves the three-dimensional image displayed on the user terminal 30B according to the amount of change from the initial position and attitude of the user terminal 30B. As a result, for example, as shown in FIG. 10, when the image capture device of the user terminal 30B is aimed at the ground, a three-dimensional image of the borehole is displayed on the display, allowing the user to intuitively grasp the underground conditions observed during past borehole work. In particular, when the marker 36 is placed at the position indicated by the borehole position information, the user can more intuitively grasp the borehole conditions at the site after the actual borehole has been backfilled.

The display control unit 20 may also display an augmented reality (AR) image, which is a combination of an image captured by the image capture device of the user terminal 30B and a three-dimensional image of the test hole, on the display unit of the user terminal 30B. By placing the above-mentioned marker 36 at the position indicated by the position information of the test hole, i.e., at the actual site after the test hole has been backfilled, capturing an image, and displaying the AR image, the test hole situation at the relevant location can be intuitively grasped while taking into account the surrounding conditions at the site after the test hole has been backfilled. Furthermore, as shown in FIG. 11, by using an HMD as the user terminal 30B and displaying an AR image based on the position indicated by the position information of the actual test hole, a more realistic three-dimensional image can be displayed at the site after the test hole has been backfilled.

When the display control unit 20 receives a dashboard display request from the user terminal 30C, it displays, for example, a dashboard 38 as shown in FIG. 12 on the display unit of the user terminal 30C. The display control unit 20 displays a map on the dashboard 38 in which symbols are arranged at positions corresponding to the position information stored in the drilling information DB 18. When any symbol is selected from the map, the display control unit 20 displays a three-dimensional image that visualizes the three-dimensional data associated with the position information corresponding to the position of the selected symbol. Furthermore, the display control unit 20 also displays other information related to drilling (such as work dates) associated with the position information corresponding to the position of the selected symbol. This allows the road manager to centrally manage the drilling status within the area he or she manages. Instead of or together with the map display, a list of drilling information within the area managed by the road manager may be displayed.

Next, the operation of the borehole information management system 100 according to this embodiment will be described. In the following, an example will be described in which a video is acquired as multiple images of an area including a borehole.

First, at the site of the drilling work, a user terminal 30A takes a video of the area including the drilling hole, and the user terminal 30A transmits the video and drilling information including the position information of the drilling hole to the drilling information management device 10. When the drilling information management device 10 receives the drilling information transmitted from the user terminal 30A, the drilling information management device 10 executes the registration process shown in FIG. 13. When the user terminal 30B selects viewing the drilling status from the menu, the user terminal 30B accepts the designation of the position information, transmits the designated position information, and the drilling information management device 10 receives this position information. Then, the drilling information management device 10 executes the first display process shown in FIG. 14. When the user terminal 30C selects displaying the dashboard from the menu, the user terminal 30C transmits a dashboard display request. When the drilling information management device 10 receives the dashboard display request transmitted from the user terminal 30C, the drilling information management device 10 executes the second display process shown in FIG. 15.

The CPU 42 reads the prospecting information management program from the storage device 46, expands it into the memory 44, and executes it, causing the CPU 42 to function as each functional component of the prospecting information management device 10, and executes the registration process, the first display process, and the second display process. Each of the registration process, the first display process, and the second display process will be described in detail below.

Figure 13 is an example of a flowchart showing the flow of the registration process executed by the CPU 42 of the drilling information management device 10.

First, in step S12, the acquisition unit 12 acquires drilling information including video, location information, and other information related to drilling received by the drilling information management device 10. Next, in step S14, the acquisition unit 12 acquires multiple frame images (e.g., 100 images) of the multiple frame images constituting the video, which are images of the drilling hole taken from multiple different angles. Note that if multiple still images are acquired as drilling information, the processing in this step may be omitted.

Next, in step S16, the generation unit 14 generates three-dimensional data of the borehole from the multiple frame images acquired by the acquisition unit 12 in step S14. Next, in step S18, the storage control unit 16 stores borehole information in the borehole information DB 18, which associates the borehole position information acquired in step S12 with the three-dimensional data generated in step S16 and other information related to the borehole acquired in step S12. Then, the registration process ends.

Figure 14 is an example of a flowchart showing the flow of the first display process executed by the CPU 42 of the drilling information management device 10.

In step S22, the display control unit 20 accepts the designation of location information from the user terminal 30B. Next, in step S24, the display control unit 20 reads out three-dimensional data corresponding to the accepted location information from the drilling information DB 18. Next, in step S26, the display control unit 20 generates screen data for displaying a three-dimensional image that visualizes the read out three-dimensional data. At this time, the three-dimensional image is a three-dimensional image of an initial position and orientation as seen from a predetermined viewpoint. The display control unit 20 transmits the generated screen data to the user terminal 30B.

Next, in step S28, the display control unit 20 determines whether an instruction to change the display of the three-dimensional image has been received by determining whether an operation from the user operating the user terminal 30B or a change in the position and attitude of the user terminal 30B has been detected. If an instruction to change the display has been received, the process proceeds to step S30; if not, the process proceeds to step S32.

In step S30, the display control unit 20 generates screen data by rotating and moving the three-dimensional image according to the amount of operation on the user terminal 30B or the amount of change in the position and attitude of the user terminal 30B, and transmits the screen data to the user terminal 30B.

Next, in step S32, the display control unit 20 determines whether or not to end the display of the three-dimensional image. In the user terminal 30B, it can be determined that the display of the three-dimensional image is to be ended when an application is ended or another menu is selected. If the display of the three-dimensional image is not to be ended, the process returns to step S28, and if the display of the three-dimensional image is to be ended, the first display process ends.

Figure 15 is an example of a flowchart showing the flow of the second display process executed by the CPU 42 of the drilling information management device 10.

In step S42, the display control unit 20 causes the user terminal 30C to display a dashboard 38 including a map of a pre-specified initial range, in association with the user (road manager) corresponding to the user terminal 30C that sent the dashboard display request. Next, in step S44, the display control unit 20 displays a symbol on the map displayed on the dashboard 38 at a position corresponding to the position information stored in the prospecting information DB 18.

Next, in step S46, the display control unit 20 determines whether or not any symbol has been selected from the map on the user terminal 30C. If any symbol has been selected, the process proceeds to step S48, and if no symbol has been selected, the process proceeds to step S50. In step S48, the display control unit 20 displays on the dashboard 38 a three-dimensional image that visualizes the three-dimensional data associated with the position information corresponding to the position of the selected symbol, as well as other information related to the exploratory drilling (such as work dates).

Next, in step S50, the display control unit 20 determines whether the range of the map to be displayed has been changed on the user terminal 30C. If the range has been changed, the process returns to step S42; if it has not been changed, the process proceeds to step S52. In step S52, the display control unit 20 determines whether to end the display of the three-dimensional image. If the display of the three-dimensional image is not to be ended, the process returns to step S46; if the display of the three-dimensional image is to be ended, the second display process ends.

As described above, according to the trial excavation information management system of this embodiment, three-dimensional data of the trial hole is generated from multiple images taken at the trial excavation site, and stored in the trial excavation information DB in association with the location information of the trial hole. Then, when location information is specified by the business operator performing the trial excavation work, a three-dimensional image of the trial hole indicated by the three-dimensional data corresponding to the specified location information is displayed. This allows the business operator to check the underground situation at the location where they are going to trial excavate based on the past trial excavation situation, eliminating the need to trial excavate the same location again. In other words, it is possible to reduce duplicate trial excavation work. In addition, it is possible to centrally manage the trial excavation situation within the area managed by the road administrator.

In the above embodiment, a system may be added that charges a fee when drilling information is provided to user terminal 30B or 30C. Also, a fee may be charged when drilling information is provided to user terminal 30B, and drilling information may be provided to user terminal 30C free of charge. As the billing method and the like can be a conventionally known method, a detailed explanation is omitted here.

In addition, in the above embodiment, a screen (Figure 12) similar to the dashboard 38 displayed on the user terminal 30C may be displayed on the user terminal 30B. In this case, when a fee is charged for the provision of drilling information as described above, only symbols corresponding to the drilling information for which a fee has been charged may be displayed on the map. Furthermore, of the symbols displayed on the map, only symbols corresponding to the drilling information for which a fee has been charged may be selectable.

In the above embodiment, the processing executed by the CPU after reading the software (program) may be executed by various processors other than the CPU. Examples of processors in this case include a PLD (Programmable Logic Device) such as an FPGA (Field-Programmable Gate Array) whose circuit configuration can be changed after manufacture, and an ASIC (Application Specific Integrated Circuit) which is a dedicated electric circuit that is a processor having a circuit configuration designed specifically to execute a specific process. The above process may be executed by one of these various processors, or may be executed by a combination of two or more processors of the same or different types (e.g., multiple FPGAs, a combination of a CPU and an FPGA, etc.). The hardware structure of these various processors is, more specifically, an electric circuit that combines circuit elements such as semiconductor elements.

In the above embodiment, the exploration information management program is described as being pre-stored (installed) in a storage device, but this is not limiting. The program may be provided in a form recorded on a recording medium such as a CD-ROM, DVD-ROM, or USB memory. The program may also be downloaded from an external device via a network.

10: Exploration information management device 12: Acquisition unit 14: Generation unit 16: Storage control unit 18: Exploration information DB
20 Display control unit 30A, 30B, 30C User terminal 32 Position designation screen 34 Viewing screen 36 Marker 38 Dashboard 42 CPU
44 Memory 46 Storage device 48 Input device 50 Output device 52 Storage medium reading device 54 Communication I/F
56 Bus 100 Exploration information management system

Claims (12)

an acquisition unit that acquires a plurality of images of an area including a borehole and position information of the borehole , and also acquires a position of a pipe in the borehole and a type of the pipe designated by a user for the images ;
a generation unit that generates three-dimensional data of the borehole from the plurality of images acquired by the acquisition unit;
a storage control unit that stores the borehole position information acquired by the acquisition unit and the three-dimensional data generated by the generation unit in a storage unit in association with each other;
a display control unit that, when position information is designated, reads out from the storage unit three-dimensional data of the borehole corresponding to the designated position information, and displays on a display device a three-dimensional image that visualizes the three-dimensional data and to which information capable of identifying the type of the pipe is added in association with the position of the designated pipe ;
A prospecting information management device including: The drilling information management device according to claim 1, wherein the acquisition unit acquires, as the plurality of images, a plurality of still images of the drilling hole taken from a plurality of different angles. The drilling information management device according to claim 1, wherein the acquisition unit acquires a video of the borehole, and acquires, as the plurality of images, a plurality of frame images of the borehole captured from a plurality of different angles among a plurality of frame images constituting the video. The drilling information management device according to claim 2 or 3, wherein the acquisition unit transmits instructions to photograph the drilling hole from each of a plurality of different angles. The prospecting information management device according to any one of claims 1 to 4 , wherein the display control unit displays the piping portions included in the three-dimensional image in different colors depending on the type of the piping. the acquisition unit acquires the plurality of images captured by an image capturing device having a function of measuring a position of the image capturing device itself, and acquires position information of the image capturing device when the plurality of images were captured by the image capturing device;
The display control unit of the prospecting information management device described in any one of claims 1 to 5 accepts the position of the display device, which has a function of measuring the position of the device itself, measured at the site after prospecting is backfilled as the specified position information. The generating unit sets a reference point in the generated three-dimensional data,
The prospecting information management device of claim 6, wherein when a marker is read by the display device having a marker reading function, the display control unit displays on the display device the three-dimensional image in a position and attitude corresponding to the positional relationship between the display device and the marker, with the reference point aligned with the position of the marker. The prospecting information management device according to claim 7 , wherein the display control unit displays on the display device an augmented reality image that combines an image captured by the display device having a photographing function with the three-dimensional image. The display control unit displays a map on which symbols are placed at positions corresponding to the position information stored in the memory unit, and when any symbol is selected from the map, displays on the display device a three-dimensional image that visualizes the three-dimensional data associated with the position information corresponding to the position of the selected symbol.A prospecting information management device as described in any one of claims 1 to 8 . The acquisition unit further acquires other information related to the prospecting,
The prospecting information management device according to any one of claims 1 to 9 , wherein the display control unit displays other information related to the prospecting on the display device together with the three-dimensional image. The acquisition unit acquires a plurality of images of a portion including a borehole and position information of the borehole, and acquires a position of a pipe in the borehole and a type of the pipe designated by a user for the images ;
A generation unit generates three-dimensional data of the borehole from the plurality of images acquired by the acquisition unit,
A memory control unit stores the borehole position information acquired by the acquisition unit and the three-dimensional data generated by the generation unit in association with each other in a memory unit;
A method for managing exploratory information, in which, when location information is specified, a display control unit reads out from the memory unit three-dimensional data of the exploratory hole corresponding to the specified location information, and displays on a display device a three-dimensional image that visualizes the three-dimensional data and has information added thereto that can identify the type of pipe, corresponding to the position of the specified pipe. Computer,
an acquisition unit that acquires a plurality of images of an area including a borehole and position information of the borehole , and acquires a position of a pipe in the borehole and a type of the pipe designated by a user for the images;
a generation unit that generates three-dimensional data of the borehole from the plurality of images acquired by the acquisition unit;
a storage control unit that stores the borehole position information acquired by the acquisition unit and the three-dimensional data generated by the generation unit in a storage unit in association with each other; and
A test drilling information management program that functions as a display control unit that, when location information is specified, reads out from the memory unit three-dimensional data of the test drilling hole corresponding to the specified location information, and displays on a display device a three-dimensional image that visualizes the three-dimensional data and has information added that can identify the type of the pipe, corresponding to the position of the specified pipe .