JP6399586B2 - Inspection data management device and inspection data management method - Google Patents

Description

  The present invention relates to an inspection data management device and an inspection data management method.

Conventionally, the state of equipment installed outdoors and indoors (state of deterioration, failure, damage, etc.) is inspected, and the inspection data that is inspected is linked to the equipment identification information that identifies the equipment and the date and time when the equipment is measured. The state of the equipment is managed by a database.
The state of each facility is monitored based on the inspection data of each facility stored in this database. Depending on the state of the equipment in the inspection data, management work for the equipment such as repair, repair or replacement of each equipment is performed.

Japanese Patent Laid-Open No. 10-229577

  However, when an imaging device or recording device that is not connected to an information communication network such as the Internet is used, or when each of the imaging device and the recording device is not connected and is independent, The voice data recording the voice explaining the state is not directly related as the check data for the equipment that has been checked. That is, when inspecting equipment, if the inspection device connected to the information communication network or the inspection device is an integrated device such as a smartphone, check the equipment identification information of the equipment and the date and time of inspection. The information is added to the data and transmitted to the management server, and the management information indicating which equipment was inspected when is accurately recorded in the management server.

On the other hand, there are few imaging devices and recording devices each having a function of adding equipment identification numbers of facilities inspected in the imaging device and recording device to image data and sound data, which are inspection data. In addition, there are many cases where each of the imaging device and the recording device cannot be connected to the information communication network for each of the image data and the sound data.
For this reason, after returning to the management center where the management server is installed, the image data and audio data that are inspection data are associated with each of the inspection target equipment by recording and storing the workers who inspected the equipment. The work is done.

  This linking process is time consuming for the linking process performed by a human being, and the work efficiency is very poor. In addition, when there is an error in the storage or recording of the worker, incorrect inspection data is associated with the equipment. As a result, the image data and the sound data at the time of inspection are not correctly associated with the facility, and an erroneous determination of the state of the facility is performed by incorrect inspection data. As a result, it is necessary to reinspect the erroneously determined equipment, and the work efficiency of the inspector is greatly reduced.

  The present invention has been made in view of such circumstances, and when an inspection device such as an imaging device and an audio device that are not connected to an information communication network that transmits and receives data is used, or each of the imaging device and the recording device An object of the present invention is to provide an inspection data management device and an inspection data management method capable of easily and accurately associating equipment with inspection data such as image data and audio data even when they are disconnected and independent. .

  The present invention has been made in order to solve the above-described problems, and the inspection data management apparatus of the present invention provides equipment identification information for identifying equipment to be inspected and equipment time stamp indicating the time at which the equipment inspection is started. An inspection data input unit for inputting the inspection data to which the inspection time stamp indicating the time when the inspection of the equipment is performed is input from the inspection device that has inspected the equipment, and the equipment A time stamp confirmation unit that groups the inspection time stamps corresponding to the inspection data for each facility according to the time sequence of each time stamp and each of the inspection time stamps, and the inspection data included in the group A data management unit that associates each facility with the facility identification information corresponding to the facility time stamp. And wherein the door.

  In the inspection data management apparatus of the present invention, the time stamp confirmation unit sequentially extracts and extracts the inspection time stamp included in the equipment time stamp from the target equipment time stamp to immediately before the next equipment time stamp. Further, the inspection data of the inspection time stamp is set as the group of the target time stamps.

  In the inspection data management device according to the present invention, the inspection data is any one or a combination of image data captured by an imaging device, audio data recorded by a recording device, and measurement data measured by a measurement device.

  The inspection data management method of the present invention includes an equipment data input process in which an equipment data input unit inputs equipment identification information for identifying equipment to be inspected and equipment time stamp indicating a time at which the equipment inspection is started, and inspection. An inspection data input process in which the data input unit inputs inspection data to which an inspection time stamp indicating the time at which the equipment is inspected is added from an inspection device that has inspected the equipment, and a time stamp confirmation unit, A time stamp confirmation process in which the inspection time stamps corresponding to the inspection data for each facility are grouped according to a time relationship between each of the equipment time stamps and each of the inspection time stamps, and a data management unit, The inspection data included in a group is added to the equipment identification information corresponding to the equipment time stamp for each group. Characterized in that it comprises a data management process to attach response.

  According to the present invention, it is easy to associate equipment with inspection data such as image data and audio data even when using inspection equipment such as an imaging device and an audio device that are not connected to an information communication network that transmits and receives data. It is possible to provide an inspection data management device and an inspection data management method that can be performed.

It is a schematic block diagram which shows the structural example of the inspection data management apparatus by the 1st Embodiment of this invention. It is a figure which shows the structural example of the equipment time table memorize | stored in the temporary data storage part 15 in this embodiment. It is a figure which shows the structural example of the inspection time table memorize | stored in the temporary data storage part 15 in this embodiment. It is a figure which shows the structural example of the grouping table memorize | stored in the temporary data storage part 15 in this embodiment. It is a figure which shows the structural example of the equipment inspection table memorize | stored in the equipment database 16 in this embodiment. It is a flowchart which shows the operation example of the measurement of the inspection data of the inspection data management apparatus 1 and the inspection apparatus group 3 by embodiment of this invention. It is a flowchart which shows the operation example of the production | generation of the equipment inspection table in the equipment database 16 in the inspection data management apparatus 1 by embodiment of this invention.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a schematic block diagram showing a configuration example of an inspection data management apparatus according to the first embodiment of the present invention. The inspection data management device 1 according to the embodiment of the present invention in FIG. 1 includes an equipment data input device 11, an inspection data input device 12, a time stamp confirmation unit 13, a data management unit 14, a temporary data storage unit 15, and an equipment database 16. It has.

The equipment data input unit 11 sends the equipment identification information for identifying the equipment to be inspected and the equipment time stamp indicating the date and time when the equipment inspection is started via the information communication network 100 including the Internet etc. to the portable terminal 2. Enter from. Here, the date and time when the inspection of the equipment is started is the time when the equipment to be inspected is selected on the mobile terminal in order to confirm the equipment information of this equipment before the inspection starts, and the inspection person arrives at the equipment to be inspected. Indicates the date and time.
Further, the facility data input unit 11 associates the facility identification information input from the portable terminal 2 with the facility time stamp, and writes and stores them in the facility time table of the temporary data storage unit 15 described later.

  The inspection data input unit 12 is data obtained by inspecting equipment from each device of the inspection device group 3, and reads inspection data to which an inspection time stamp indicating the time when the equipment is inspected is added. The facility data input unit 11 writes inspection data to a temporary data storage unit 15 described later. At this time, the equipment data input unit 11 has each of the inspection time stamp, the data type indicating the type of the inspection data, and the start address of the storage area in which the inspection data is written, with respect to the inspection time table of the temporary data storage unit 15. Is written and stored. Here, the facilities include utility poles, pipelines, cables, manholes, communication equipment, power supply facilities, and the like.

  The time stamp confirmation unit 13 groups the inspection data of the inspection device group 3 to be described later based on the date and time when the equipment is inspected (date and time when the inspection data is acquired) added to the inspection data. Here, the time stamp confirmation unit 13 determines the inspection time stamp of the time in the range between the equipment time stamps according to the time relationship between each of the equipment time stamps and each of the inspection time stamps. A group is formed as an inspection time stamp of the time when the equipment corresponding to each time stamp is inspected. That is, the time stamp confirmation unit 13 sequentially extracts the inspection time stamps included in the equipment time stamp from the target equipment time stamp to immediately before the next equipment time stamp, and obtains the inspection data of the extracted inspection time stamp. , Group as a target time stamp group.

  The data management unit 14 associates each piece of inspection data included in the group grouped by the time stamp confirmation unit 13 with the facility identification information corresponding to the target facility time stamp. That is, the data management unit 14 associates the inspection data group with the equipment identification number of the equipment that is the inspection target of the inspection data.

  The temporary data storage unit 15 includes an equipment time table indicating correspondence between equipment identification information of the inspected equipment supplied from the mobile terminal 2 and equipment time stamps indicating the date and time when the equipment inspection indicated by the equipment identification information is started. Written and stored. Further, the temporary data storage unit 15 is input from each device of the inspection device group 3, an inspection time stamp indicating the date and time when each inspection data is acquired, a data type indicating the data type of the inspection data, An inspection time table showing the correspondence with the address where inspection data is stored in the data storage unit 15 is written and stored.

  FIG. 2 is a diagram illustrating a configuration example of an equipment time table stored in the temporary data storage unit 15 in the present embodiment. In the equipment time table of FIG. 2, the correspondence between equipment identification information for identifying equipment and the equipment time stamp of the equipment indicated by the equipment identification information is shown. The date and time when the inspection is started indicates the date and time when the equipment to be inspected is selected on the mobile terminal in order to confirm the equipment information of this equipment before the inspection arrives at the equipment to be inspected by the inspector. Yes. The portable terminal 2 transmits the selected equipment and the date and time at the time of selection to the inspection data management apparatus 1 when the equipment to be inspected is selected.

  FIG. 3 is a diagram illustrating a configuration example of an inspection time table stored in the temporary data storage unit 15 in the present embodiment. In the inspection time table of FIG. 3, the inspection time stamp indicating the date and time when the inspection of the equipment is started, the data type indicating the type of inspection data, and the address where the inspection data is written in the temporary data storage unit 15 Correspondence is shown. The data type indicates whether the inspection data is still image data, moving image data, audio data, or measurement data. When the inspection data is read, the inspection data input unit 12 determines the data type based on the extension of each file of the inspection data, and extracts the date data included in each inspection data as the date and time.

  FIG. 4 is a diagram illustrating a configuration example of the grouping table stored in the temporary data storage unit 15 in the present embodiment. In the grouping table of FIG. 4, the correspondence between the equipment time stamp, the inspection time stamp, the data type, and the start address (the address in FIG. 4) of the area in which the inspection data is written is shown. The time stamp confirmation unit 13 has an inspection time stamp having a date and time included between the equipment time stamp of the target for inspection data grouping and the equipment time stamp immediately after the date and time indicated by the target time stamp. Data is extracted from the inspection table. Then, the time stamp confirmation unit 13 groups the target equipment time stamp and the inspection time stamp of the extracted inspection data as a group of the target equipment time stamp, and the target equipment time stamp and the extracted inspection data Correlate (link) the inspection time stamp.

  FIG. 5 is a diagram showing a configuration example of the equipment inspection table stored in the equipment database 16 in the present embodiment. In the equipment inspection table of FIG. 5, equipment identification information, equipment time stamp, first image data address, second image data address, audio data address, and measurement data address are associated with each other. The equipment time stamp is shown as a representative date and time for each inspection time stamp group in the inspection data of the group corresponding to itself. The first image data address indicates the head address of the area of the facility database 16 in which still image data of the first imaging device 31 is stored. The second image data address indicates the head address of the area of the facility database 16 in which the moving image data of the second imaging device 32 is stored. The voice data address indicates the head address of the area of the facility database 16 where the voice data of the recording device 33 is stored. The measurement data address indicates the head address of the area of the equipment database 16 in which the measurement data of the measuring device 34 is stored.

  The facility database 16 stores map data to be displayed as a map on the display screen of the portable terminal 2 in the inspection range of the inspector and an equipment table (not shown). In the equipment table, the equipment name corresponding to the equipment identification information, the equipment name, the construction year indicating the year of construction, the type of equipment, the coordinate position on the map data, the history of failure, replacement, etc. Etc. are shown.

  The portable terminal 2 reads map data from the equipment database 16 on the display screen, and displays a map image. The inspector goes to the facility to be inspected while confirming the route to the facility to be inspected on the map of the display screen of the portable terminal 2. The inspector, when attached to the facility to be inspected, clicks and selects the facility to be inspected on the map of the display screen of the portable terminal 2 as a trigger for starting the inspection. The portable terminal 2 transmits the equipment identification number of the selected equipment and the clicked date and time to the inspection data management apparatus 1 at the selected timing.

  Returning to FIG. 1, the portable terminal 2 is a terminal capable of transmitting and receiving data to and from the inspection data management apparatus 1 via an information communication network 100 including the Internet, such as a notebook personal computer, a tablet terminal, and a smartphone.

  The inspection device group 3 is a set of devices having an independent function for inspecting equipment, and includes a first imaging device 31, a second imaging device 32, a recording device 33, a measuring device 34, and the like. Each of the first imaging device 31, the second imaging device 32, the recording device 33, the measuring device 34, and the like is an independent device that is not connected to the information communication network.

The first image pickup device 31 is, for example, a digital camera, and picks up still image data of a facility inspection location. Moreover, the 1st imaging device 31 assign | provides the inspection time stamp which shows the date and time imaged with respect to this still image data, whenever it captures still image data.
The second image pickup device 32 is, for example, a video camera, and picks up moving image data of a facility inspection location. In addition, every time the moving image data is captured, the second imaging device 32 gives an inspection time stamp indicating the date and time when the moving image data is captured.

The recording device 33 is, for example, an IC (integrated circuit) recorder (digital voice recorder), and records the voice of the inspector explaining the state of the equipment as voice data. In addition, each time the sound recording device 33 records sound as sound data, the sound recording data 33 gives an inspection time stamp indicating the recording date and time to the sound data.
The measuring device 34 is, for example, a laser displacement meter, and records numerical values such as lengths and depths of equipment scratches or cracks as measurement data. Further, every time the measurement device 34 measures the measurement data, the measurement device 34 gives an inspection time stamp indicating the measurement date and time to the measurement data.

FIG. 6 is a flowchart showing an operation example of inspection data measurement of the inspection data management device 1 and the inspection device group 3 according to the embodiment of the present invention.
Step S1:
When the inspector moves to the equipment to be inspected, the equipment to be inspected is clicked and selected on the map of the display screen of the mobile terminal 2 as a trigger for starting the equipment inspection.
Thereby, the portable terminal 2 transmits the equipment identification number of the selected equipment and the equipment time stamp indicating the clicked date and time to the inspection data management apparatus 1 at the selected timing.
At this time, the facility data input unit 11 associates each of the facility identification information and the facility time stamp supplied from the portable terminal 2 and writes and stores them in the facility time table shown in FIG. 2 in the temporary data storage unit 15.

Step S2:
Next, the inspector selects the facility on the map, and then performs data measurement as a process for inspecting the target facility by each device of the inspection device group 3. For example, the inspector performs data measurement for imaging the appearance of the facility as still image data by the first imaging device 31. The inspector performs data measurement by actually operating the operation state of the facility using the second imaging device 32 and recording it as moving image data. When the inspector checks the equipment with the recording device 33, the inspector explains the result of observing the state of the equipment, and performs data measurement to record the voice of the explanation as voice data. The inspector uses the recording device 33 to record the operation sound when the facility is operated as voice data. The inspector uses the measuring device 34 to measure the length and depth of scratches or cracks in the equipment and perform data measurement to record as measurement data.

Step S3:
For example, if the inspection process of the facility on that day is completed, the inspector returns to the management center where the inspection data management device 1 is located, and if the inspection process of the facility is continued, the process proceeds to step S4.

Step S4:
The inspector refers to the map displayed on the display screen of the portable terminal 2 and moves to the facility to be inspected next. Thereafter, the process returns to step S1.

FIG. 7 is a flowchart showing an operation example of generating an equipment inspection table in the equipment database 16 in the inspection data management apparatus 1 according to the embodiment of the present invention.
Step S11:
When the inspector returns to the management center, the inspection data of the first imaging device 31, the second imaging device 32, the recording device 33, and the measuring device 34 in the inspection device group 3 are input to the inspection data management device 1. To do. That is, the inspector performs an inspection data reading process from each device of the inspection device group 3 in the inspection data input unit 12.

At this time, the inspection data input unit 12 determines the inspection data input from each device of the inspection device group 3 based on the extension of the data type of each inspection data. Further, the inspection data input unit 12 extracts the date and time information included in the inspection data as an inspection time stamp, and writes and stores the inspection data in an area having an arbitrary address in the temporary data storage unit 15 as a start address.
Then, the inspection data input unit 12 writes and stores the inspection time stamp, the data type, and the address in association with each other in the inspection time table of the temporary data storage unit 15.

Step S12:
The time stamp confirmation unit 13 includes a facility time stamp corresponding to a target facility for grouping inspection data from the facility time table (hereinafter referred to as a target facility time stamp) and a facility time immediately after the target facility time stamp in terms of time. A stamp (hereinafter, equipment time stamp) is read out.
When the processing loop is repeated, the time stamp confirmation unit 13 newly sets the immediately-facing equipment time stamp as the target time stamp, and sets the equipment time stamp immediately after the immediately following equipment time stamp as the new immediately-facing equipment time stamp.

Step S13:
Then, the time stamp confirmation unit 13 extracts the inspection time stamp included between the target equipment time stamp and the immediately subsequent equipment time stamp from the inspection time table of the temporary data storage unit 15.
The time stamp confirmation unit 13 configures a group by associating the extracted inspection time stamp with the target facility time stamp, and writes and stores the group in the grouping table of the temporary data storage unit 15.

Step S14:
The time stamp confirmation unit 13 determines whether or not all the equipment time stamps in the equipment time table of the temporary data storage unit 15 are sequentially set as the target equipment time stamps. That is, the time stamp confirmation unit 13 detects whether or not the inspection time stamp grouping corresponding to each of the facilities has been completed.

At this time, when the processing for all equipment time stamps in the equipment time table of the temporary data storage unit 15 is completed, the time stamp confirmation unit 13 advances the processing to step S15.
On the other hand, if the processing for all the equipment time stamps in the equipment time table of the temporary data storage unit 15 has not been completed, the time stamp confirmation unit 13 advances the processing to step S12.

Step S15:
The data management unit 14 searches and extracts inspection data having the same equipment time stamp in the grouping table of the temporary data storage unit 15.
Then, the data management unit 14 reads out the equipment identification number corresponding to the equipment time stamp from the equipment time table in the temporary data storage unit 15.

The data management unit 14 associates the equipment identification number having the same equipment time stamp and the inspection data between the equipment time table and the grouping table, and writes and stores them in the equipment inspection table in the equipment database 16. At this time, the data management unit 14 reads each inspection data stored in the temporary data storage unit 15 and newly writes it in the facility database 16.
For this reason, the data management unit 14 newly writes each inspection data in the address of each data type, that is, the first image data address, second image data address, audio data address, and measurement data address column. The head address of the area of the equipment database 16 is written into the equipment inspection table.

As described above, according to the present embodiment, the inspection data of each inspection device of the inspection device group 3 not directly associated with the facility identification number of the facility is the facility time stamp indicating the date and time when the inspection of the facility is started. The inspection data for each facility can be easily grouped according to the date and time relationship with the inspection time stamp indicating the date and time when each inspection device in the inspection device group 3 performs the inspection.
Therefore, according to the present embodiment, even when using inspection equipment such as an imaging device and a sound device that are not connected to the Internet, or when the imaging device and the recording device are each not connected and independent, Compared to the conventional method of associating equipment that relies on the user's memory and records with the inspection data of the equipment, it is possible to prevent errors in the correspondence between the equipment (equipment identification number) and inspection data. The inspection data can be accurately associated with.

  Further, the program for realizing the function of the inspection data management apparatus shown in FIG. 1 is recorded on a computer-readable recording medium, and the program recorded on the recording medium is read into the computer system and executed for inspection. Data management processing may be performed. Here, the “computer system” includes an OS and hardware such as peripheral devices.

Further, the “computer system” includes a homepage providing environment (or display environment) if a WWW system is used.
The “computer-readable recording medium” refers to a storage device such as a flexible medium, a magneto-optical disk, a portable medium such as a ROM and a CD-ROM, and a hard disk incorporated in a computer system.

  Furthermore, the “computer-readable recording medium” dynamically holds a program for a short time like a communication line when transmitting a program via a network such as the Internet or a communication line such as a telephone line. In this case, a volatile memory in a computer system serving as a server or a client in that case, and a program that holds a program for a certain period of time are also included. Further, the program may be a program for realizing a part of the functions described above, and is a so-called differential file that can realize the functions described above in combination with a program already recorded in the computer system. May be.

  The embodiment of the present invention has been described in detail with reference to the drawings. However, the specific configuration is not limited to this embodiment, and includes design and the like within a scope not departing from the gist of the present invention.

DESCRIPTION OF SYMBOLS 1 ... Inspection data management apparatus 2 ... Portable terminal 3 ... Inspection apparatus group 11 ... Equipment data input part 12 ... Inspection data input part 13 ... Time stamp confirmation part 14 ... Data management part 31 ... 1st imaging device 32 ... 2nd imaging device 33 ... Recording device 34 ... Measuring device 100 ... Information communication network

Claims (4)

Equipment identification information for identifying equipment to be inspected, and equipment data input unit for inputting equipment time stamp indicating the time when inspection of the equipment is started, from a terminal;
An inspection data input unit for inputting inspection data with an inspection time stamp indicating the time when the equipment was inspected, from the inspection device that inspected the equipment, and
A time stamp confirmation unit that groups the inspection time stamps corresponding to the inspection data for each facility according to the time relationship between each of the equipment time stamps and each of the inspection time stamps,
An inspection data management device comprising: a data management unit that associates the inspection data included in the group with the facility identification information corresponding to the facility time stamp for each group. The time stamp confirmation unit
In the equipment time stamp, the inspection time stamps included immediately before the next equipment time stamp from the target equipment time stamp are sequentially extracted, and the inspection data of the extracted inspection time stamp is the target time stamp. The inspection data management device according to claim 1, wherein the inspection data management device is the group.   The inspection according to claim 1 or 2, wherein the inspection data is any one or a combination of image data captured by an imaging device, voice data recorded by a recording device, and measurement data measured by a measuring device. Data management device. A facility data input process in which a facility data input unit inputs facility identification information for identifying a facility to be inspected and a facility time stamp indicating a time at which the inspection of the facility is started;
An inspection data input process in which the inspection data input unit inputs inspection data to which an inspection time stamp indicating the time at which the inspection of the equipment has been performed is input from the inspection device that has inspected the equipment;
A time stamp confirming unit, a time stamp confirming process in which the inspection time stamps corresponding to the inspection data for each facility are grouped according to the time relationship between each of the facility time stamps and each of the inspection time stamps;
A data management unit comprising: a data management process for associating the inspection data included in the group with the facility identification information corresponding to the facility time stamp for each group.

Images