JP7014946B2 - Data generation program, data generation method, and data generation device - Google Patents

Description

The present invention relates to a data generation program, a data generation method, and a data generation device.

The timing of road repair work is determined based on the results of measuring road conditions such as cracks in the road as an index indicating the road condition. Measuring road conditions for all roads requires enormous time, effort and cost, which can be difficult to deal with in some areas.

Therefore, simply measure the vertical acceleration of the traveling vehicle with an acceleration sensor to determine the flatness of the road, select the part where the result is bad, and measure the road condition that requires a huge amount of time and cost. A method for measuring a reduced road condition has been proposed (see, for example, Patent Document 1).

Japanese Unexamined Patent Publication No. 2015-176540

However, in order to judge the road condition more accurately, not only the flatness of the road, but also the cavity under the road surface, the accessories installed on the road such as manholes, the operation information of the vehicle such as the traffic volume, and the road. It is necessary to acquire and consider road condition information such as repair history or information under the road surface.
In addition, the time, region, method, and place where the acquired information is stored differ depending on the organization such as the national government, local governments, and companies, and the management unit, which is the unit for managing the road condition, is also available. different. For this reason, for the purpose of determining the timing of road repair work, it is not possible to obtain and compare documents that contain information on road conditions or information under the road surface, as well as electronic data. There is a problem that it takes a lot of time and effort, it is difficult to check each information in chronological order, and the accuracy of judgment is low. In addition, there is a problem that only a person who has specialized knowledge about road repair work cannot easily determine when to carry out road repair work.
Further, in the method of Patent Document 1, the vertical acceleration of a traveling vehicle is measured by an acceleration sensor to simply obtain the flatness of the road, but in the acceleration sensor, the acceleration is measured depending on the position where the acceleration sensor is installed in the vehicle. There is a problem that the value is liable to fluctuate.

In one aspect, it is an object of the present invention to provide a data generation program, a data generation method, and a data generation device that can be handled in a unified manner even if the management systems of measurement items of roads including at least angular velocities are different.

In one embodiment, the data generation program generates first data in which the position of the road, the first range relative to the position, and the value of the measurement result of the angular velocity for the first range are associated with each other. Receiving, dividing and / or combining the first range so as to match the position of the road and the second range relative to the position, and each of the first ranges to be divided and / or combined. The road measurement result values associated with each of the first ranges are divided and / or combined according to the ratio, and the road measurement result values are divided and / or combined into each of the second ranges. The computer is made to execute the process of associating the combined results and storing the associated results in the storage unit.

In one aspect, even if the management system of the measurement items of the road including at least the angular velocity is different, it can be handled in a unified manner.

FIG. 1 is a diagram illustrating an overall configuration example of the system according to the first embodiment. FIG. 2 is a functional block diagram showing a functional configuration of the road management server according to the first embodiment. FIG. 3 is a diagram showing an example of information stored in the definition information DB. FIG. 4 is a diagram showing an example of information stored in the measurement result DB. FIG. 5 is a diagram showing an example of information stored in the conversion result DB. FIG. 6 is a diagram showing an example of information stored in the section aggregation result DB. FIG. 7 is a diagram showing an example of information stored in the period aggregation result DB. FIG. 8 is a diagram showing an example of information stored in the time-dependent change DB. FIG. 9 is a diagram showing an example of information stored in the time-dependent change DB. FIG. 10 is a diagram illustrating division by latitude and longitude. FIG. 11 is a diagram illustrating an example of extracting a change over time at a specific position. FIG. 12 is a diagram illustrating an example of extracting changes over time from section aggregation. FIG. 13 is a diagram illustrating an example of result display. FIG. 14 is a flowchart illustrating the flow of the aggregation process. FIG. 15 is a flowchart showing the flow of the display process. FIG. 16 is a diagram illustrating an example of associating a link with an interval. FIG. 17 is a diagram illustrating an example of associating the data before conversion with an interval. FIG. 18 is a diagram illustrating a hardware configuration example.

Hereinafter, examples of the data generation program, the data generation method, and the data generation apparatus according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment. In addition, each embodiment can be appropriately combined within a consistent range.

[overall structure]
FIG. 1 is a diagram illustrating an overall configuration example of the system according to the first embodiment. The system shown in FIG. 1 is a system that realizes a road management platform in which a road management server 10 manages a plurality of databases managed in different formats in an integrated manner.

The road management server 10 is a server device that receives data type A managed in the first format and data type B managed in a second format different from the first format, and generates statistical data. This is just one example.

The data type A is the measurement result of the angular velocity for each road, and is managed by, for example, "position information (latitude / longitude), measurement result of the angular velocity", and the data type B is the "position information (link)" for each road. Information), measurement results ”. That is, in the data type A and the data type B, the measurement results for the same road are managed by different position information. The measurement result of the angular velocity of the data type A may be measured by, for example, an angular velocity sensor, and the measurement result of the data type B may be acquired by, for example, the vehicle speed, another measuring method or a measuring device. It is angular speed, acceleration, number of sudden braking, traffic volume, pavement condition, road image, etc., and may be information obtained from probe data transmitted from each vehicle having a vehicle device equipped with a digital tachograph, a so-called digital tachograph. Further, the link information is information indicating a range from the intersection to the intersection, and may be described as a link ID.

As described above, in the road management server 10, the position of the road and the first range (for example, latitude / longitude or link ID) based on the position correspond to the value of the measurement result of the angular velocity for the first range. Accepts the attached data type A (measurement result of angular velocity) or data type B. Then, the road management server 10 executes a process of dividing and / or combining the first range so as to match the position of the road and a predetermined second range (for example, section ID) based on the position. .. Further, the road management server 10 divides and / or combines the measurement result values of the roads associated with each of the first ranges according to the respective ratios of the first ranges to be divided and / or combined. After that, the road management server 10 executes a process of dividing and / or combining the values of the road measurement results into each of the second ranges, and stores the executed results in the storage unit.

For example, the road management server 10 divides or combines the measurement results of the latitude / longitude and the angular velocity of the data type A so that the data type A managed by the latitude / longitude can be associated with the section ID that specifies the section of the road. Then, it is converted into the data type A managed by the section ID. Similarly, the road management server 10 divides or combines the link information and the measurement result of the data type B so that the data type B managed by the link information can be associated with the section ID, and the section ID. Convert to the data type B managed by.

In this way, the road management server 10 generates data type A and data type B managed by the same section ID, and from these data types, each measurement result corresponding to the section ID of the road to be managed is obtained. Extract. As a result, the road management server 10 can collate a plurality of measurement results managed by different management systems and manage the measurement results in time series or the like. Therefore, the road management server 10 can handle measurement items of roads having different management systems in a unified manner.

[Functional configuration]
FIG. 2 is a functional block diagram showing a functional configuration of the road management server 10 according to the first embodiment. As shown in FIG. 2, the road management server 10 has a communication unit 11, a storage unit 12, and a control unit 20. The storage unit 12 is, for example, a storage device such as a hard disk or a memory, and the control unit 20 is a processor such as a CPU (Central Processing Unit).

The communication unit 11 is a processing unit that controls communication of other devices, and is, for example, a communication interface or the like. For example, the communication unit 11 receives probe data and various data from a vehicle, a management server, or the like. In addition, various wireless and various wired can be adopted for the communication unit 11.

The storage unit 12 stores programs, data, and the like executed by the control unit 20. Further, the storage unit 12 has a definition information DB 13, a measurement result DB 14, a conversion result DB 15, an interval aggregation result DB 16, a period aggregation result DB 17, and a time-dependent change DB 18.

The definition information DB 13 is a database that stores the definition of the section on the route in advance. FIG. 3 is a diagram showing an example of information stored in the definition information DB 13. As shown in FIG. 3, the definition information DB 13 stores "route ID, section ID, start point position, end point position" in association with each other.

The "route ID" stored here is an identifier that uniquely identifies the road. The "section ID" is an identifier that uniquely identifies a section arbitrarily divided on the road. The "start point position" is position information indicating the start position of the section, and is, for example, latitude and longitude. The "end point position" is position information indicating the end position of the section, and is, for example, latitude and longitude. In the case of FIG. 3, it is shown that the section of "section ID = 1" on the road identified by "route ID = 1" is from (latitude A, longitude A) to (latitude B, longitude B). The definition information DB 13 can further store information in which the link and the latitude / longitude from the start to the end of the link are associated with each other.

The measurement result DB 14 is a database that stores the measurement results of the road managed by another management server or the like. The information stored here may be received from an external management server at any time, and may be manually registered by an administrator or the like.

FIG. 4 is a diagram showing an example of information stored in the measurement result DB 14. As shown in FIG. 4, the measurement result DB 14 stores a database of data type A (measurement result of angular velocity) and a database of data type B. The data type A stores "No, time, position information, measurement result of angular velocity" in association with each other. The “No” stored here is an identifier that identifies a record in the DB. "Time" indicates the time and date and time at the time of measurement. "Position information" is latitude and longitude indicating the measurement position of the angular velocity. The "measurement result of the angular velocity" is the measurement result of the angular velocity at the position on the road specified by the position information.

The data type B stores "No, time, link information, measurement result" in association with each other. The “No” stored here is an identifier that identifies a record in the DB. "Time" indicates the time and date and time at the time of measurement. "Link information" is link information indicating a measurement position. The "measurement result" is a measurement result at a position on the road specified by the position information, and in this embodiment, the number of sudden braking is taken as an example.

In the example of FIG. 4, the record "No = 1" of the data type A indicates that the angular velocity value specified at "time t1" at the position of the position information (latitude G, longitude G) is "angular velocity X". .. Similarly, the record "No = 1" of the data type B indicates that the angular velocity value specified at "time t1" at the position of the position information (link information = 1) is "the number of sudden braking times Y".

In this way, the measurement result DB 14 contains data type A that manages the measurement result (angular velocity) of a certain road by latitude and longitude, and data type B that manages the measurement result (number of sudden brakings) of a certain road by link information. It will be remembered. That is, the measurement result DB 14 stores a plurality of data types (databases) having different management systems. In this embodiment, an example in which two data types are stored will be described, but the present invention is not limited to this, and may be three or more.

The conversion result DB 15 is a database that stores the data types after converting each data type stored in the measurement result DB 14 into predetermined conditions. FIG. 5 is a diagram showing an example of information stored in the conversion result DB 15. As shown in FIG. 5, the conversion result DB 15 stores the data type A and the data type B as in the measurement result DB 14. The difference from FIG. 4 is that the position information of the data type B is converted from the link information to the position information of latitude and longitude.

The section aggregation result DB 16 is a database that stores evaluation results for each section for each data type. FIG. 6 is a diagram showing an example of information stored in the section aggregation result DB 16. As shown in FIG. 6, the section aggregation result DB 16 stores the aggregation result of the data type A and the aggregation result of the data type B stored in the conversion result DB 15.

Each of the data type A and the data type B stores "time, route ID, section ID, evaluation" in association with each other. The "time" stored here indicates the total date and time or the measurement date and time. The "route ID" is an identifier that uniquely identifies a road. The "section ID" is an identifier that uniquely identifies a section arbitrarily divided on the road. The "evaluation" is an evaluation value calculated using the measurement result, and for example, the setting can be arbitrarily changed such as an average value, a dispersion value, a maximum value, and a minimum value. In this embodiment, the average value will be described as an example.

In the example of FIG. 6, for the data type A, the average value of the angular velocities measured in the section of the road "section ID = 1" of the road "route ID = 1" at "time t1" is "evaluation 1". Is shown. Further, for the data type B, the average value of the number of sudden brakes measured in the section of the road "section ID = 1" of the road "route ID = 1" at "time t1" is "evaluation 3". show.

The period aggregation result DB 17 is a database that stores the evaluation results for a certain period for each data type. FIG. 7 is a diagram showing an example of information stored in the period aggregation result DB 17. As shown in FIG. 7, the period aggregation result DB 17 stores the aggregation result of the data type A and the aggregation result of the data type B stored in the conversion result DB 15.

Each of the data type A and the data type B stores "period, position information, evaluation" in association with each other. The "period" stored here indicates a period to be aggregated, and the setting can be arbitrarily changed, for example, a day, a date and time, a predetermined date to a predetermined date, and the like. "Position information" indicates the latitude and longitude of the measurement position. The "evaluation" is an evaluation value calculated using the measurement result, and for example, the setting can be arbitrarily changed such as an average value, a dispersion value, a maximum value, and a minimum value. In this embodiment, the average value will be described as an example.

In the example of FIG. 7, for the data type A, it is shown that the average value of the angular velocities measured at the “position α” of “2016/1/1” is “evaluation G”. Further, for the data type B, it is shown that the average value of the number of sudden brakings measured at the “position α” of “2016/1/1” is “evaluation I”.

The time-dependent change DB 18 is a database that stores the time-dependent change of evaluation and measurement results in a certain section of a certain road. The information stored here is generated using the interval aggregation result and the period aggregation result. Specifically, the time-dependent change DB 18 is a comparison result of a specific date and time of a plurality of data types, a time-dependent change of a specific position of a plurality of data types, a time-dependent change of a plurality of data types for each period, and a time-dependent change of each evaluation result of a plurality of data types. And so on.

8 and 9 are diagrams showing examples of information stored in the time-dependent change DB 18. FIG. 8A shows changes over time in association with “period, route ID, section ID, data type A evaluation value, data type B evaluation value”, and the evaluation value and data of data type A for different section IDs. The result of comparison with the evaluation value of species B at a specific date and time is shown. In the example of (a) of FIG. 8, the measurement result of "2016/1/1" is shown, and the evaluation value of the data type A in the section of "section ID = 1" of the road of "route ID = 1" is In "evaluation 1", the evaluation value of data type B is "evaluation 2", and the evaluation value of data type A in the section of "section ID = 2" of the road of "route ID = 1" is "evaluation 4". It is shown that the evaluation value of the species B is "evaluation 5". In other words, the measurement results of each data type in the "route, section" are aggregated for each "period".

FIG. 8B shows changes over time in association with "period, route ID, section ID, data type A evaluation value, data type B evaluation value", and the evaluation value and data of data type A for the same section ID. The result of comparison with the evaluation value of Species B is shown. In the example of (b) of FIG. 8, the evaluation value of the data type A of "2016/1/1" is "evaluation 1" for the section of "section ID = 1" of the road of "route ID = 1". It is shown that the evaluation value of the species B is "evaluation 3", the evaluation value of the data type A of "2016/2/1" is "evaluation 1", and the evaluation value of the data type B is "evaluation 7". In other words, the measurement results of each data type in the "period" are aggregated for each "route, section".

FIG. 9A shows changes over time in which "route ID, section ID, data type A evaluation value, data type B evaluation value" are associated with each "period", and data for each period for different section IDs. The result of comparing the evaluation value of the species A and the evaluation value of the data type B is shown. In FIG. 9A, “2016 /” for each of “route ID = 1, section ID = 1”, “route ID = 1, section ID = 2”, and “route ID = 1, section ID = 3”. The evaluation value of the data type A and the evaluation value of the data type B of "1/1" and the evaluation value of the data type A and the evaluation value of the data type B of "2016/2/1" are shown.

FIG. 9B shows the change over time in which "route ID, section ID, data type A evaluation value, data type B evaluation value" are associated with each "period", and different section IDs are shown for each data type. It shows the change of the evaluation value in a certain period. In (b) of FIG. 9, data type A is obtained for each of "route ID = 1, section ID = 1", "route ID = 1, section ID = 2", and "route ID = 1, section ID = 3". "2016/1/1" evaluation value and "2016/2/1" evaluation value, and data type B "2016/1/1" evaluation value and "2016/2/1" evaluation value Is shown.

The control unit 20 is a processing unit that controls the processing of the entire road management server 10, and includes a conversion storage unit 21, an extraction unit 22, and a display control unit 26. The conversion storage unit 21, the extraction unit 22, and the display control unit 26 are examples of electronic circuits included in the processor and examples of processes executed by the processor. The conversion storage unit 21 is an example of a reception unit, and the extraction unit 22 is an example of a data processing unit, an association unit, and a storage unit.

The conversion storage unit 21 is a processing unit that receives data types having different management systems, stores them in the measurement result DB 14, and converts each data type into predetermined position information. Specifically, the conversion storage unit 21 converts the data type managed by the position information other than latitude and longitude into latitude and longitude for each data type stored in the measurement result DB 14, and stores it in the conversion result DB 15. For example, since the position information of the data type A shown in FIG. 4 is latitude / longitude, the conversion storage unit 21 stores the data type A as it is in the conversion result DB 15 without performing the conversion process. On the other hand, since the position information of the data type B shown in FIG. 4 is the link information, the conversion storage unit 21 converts the link information into latitude and longitude and then stores the data type B in the conversion result DB 15.

More specifically, the conversion storage unit 21 converts the position information of the original data type into latitude and longitude, divides or combines the measurement results associated with the position information, and converts it into the data type of latitude and longitude. For example, the conversion storage unit 21 specifies the latitude / longitude of the center between the intersections specified by the link information and the intersections, and converts the specified latitude / longitude into position information.

Further, when the conversion storage unit 21 has data only in a certain long distance unit such as a route instead of link information, it divides the data into arbitrary lengths based on the latitude and longitude of the start point and the end point, and the latitude and longitude thereof. Store in. FIG. 10 is a diagram illustrating division by latitude and longitude. As shown in FIG. 10, it is assumed that the position information of a certain data type is managed by the coordinates from the start point (x1, y1) to the end point (x2, y2). That is, it is assumed that the data type B in FIG. 4 is managed by "position coordinates =" start point (x1, y1) -end point (x2, y2) "instead of the link information.

In this case, the conversion storage unit 21 divides the distance between the start point and the end point for each latitude xd, and also divides the measurement result from the start point to the end point by the number of divisions according to the latitude. For example, FIG. 10 shows an example in which the distance is divided into 11 pieces. For example, the position information (x, y) in FIG. 10A is (x1 + xd × 3, y1 + (y2-y1) / 10 × 3). ). Further, when the conversion storage unit 21 divides the distance into 11 pieces at latitude xd, the measurement result is also divided into 11 pieces, and the data type in which each latitude / longitude obtained by the division is associated with the divided measurement result. Convert to.

Here, if the measurement result is a cumulative number such as the number of sudden brakings, it can be simply divided, but if it is an image or the like, it cannot be divided. In that case, the image captured at the position coordinates is associated with each divided position information (latitude / longitude). In the example of FIG. 10, images captured from the start point to the end point are associated with each of the 11 divided position information (latitude and longitude).

The conversion storage unit 21 can dynamically determine whether or not such division is possible by using the data type of the measurement result. For example, the conversion storage unit 21 can store the data type and the division method of the data type in association with each other, divide the data, use the same data, or use the average value of the data.

Further, when the conversion storage unit 21 has data only in an extremely short distance unit such as a route, instead of link information, the distances are combined based on the latitude and longitude of the start point and the end point to obtain one latitude and longitude. Data conversion can also be performed by associating with.

For example, the conversion storage unit 21 is a DB in which the data type B manages the data type B by the position coordinates instead of the link information, and the No. The position coordinates of the record 1 and No. It is assumed that the difference (distance) from the position coordinates of the two records is less than the threshold value. In this case, the conversion storage unit 21 is No. The position coordinates of the record 1 and No. The intermediate point of the position coordinates of the two records is specified as new position information (position coordinates). Then, the conversion storage unit 21 has the specified position information (position coordinates) and the No. Measurement result of 1 record and No. It is converted into new data associated with the value obtained by adding the measurement result of 2 records.

Here, as in the case of division, if the measurement result is a cumulative number such as the number of sudden brakings, it can be simply added, but in the case of an image or the like, it cannot be added. In that case, associating is performed by an arbitrary method such as selecting one of the images captured at the position coordinates. As the method of associating, the same method as the method exemplified at the time of division can be adopted.

Returning to FIG. 2, the extraction unit 22 is a processing unit that extracts the corresponding data from each DB stored in the conversion result DB 15 according to the conditions specified by the user or the like. The extraction unit 22 has a section evaluation unit 23, a period aggregation unit 24, and a generation unit 25, and extracts the corresponding data by these units.

The section evaluation unit 23 is a processing unit that aggregates data in defined section units. Specifically, the section evaluation unit 23 aggregates the measurement results for each section stored in the definition information DB 13 for each data type stored in the conversion result DB 15, and uses the aggregated measurement results to evaluate the evaluation value. Is calculated. Then, the section evaluation unit 23 generates the DB shown in FIG. 6 and stores it in the section aggregation result DB 16.

For example, the data type A shown in FIGS. 3 to 6 will be used for explanation. The section evaluation unit 23 specifies the start point position (latitude A, longitude A) and end point position (latitude B, longitude B) of "route ID = 1, section ID = 1" from the definition information DB 13. Then, the section evaluation unit 23 refers to each position information of the data type and extracts the measurement result of the angular velocity of the data type A included from the start point position to the end point position. Then, the section evaluation unit 23 calculates an evaluation value from the measured result of the extracted angular velocity. After that, the section evaluation unit 23 generates a data type A (aggregation result) in which the aggregation date and time, "route ID = 1, section ID = 1", and the evaluation value are associated with each other, and stores the data type A (aggregation result) in the section aggregation result DB 16. do. In this way, the section evaluation unit 23 can aggregate the measurement results of the angular velocity for each combination of "route ID, section ID".

At this time, the section evaluation unit 23 sets "time = t1" when extracting the measurement result of the angular velocity of the data type A included from the start point position to the end point position of "route ID = 1, section ID = 1". The measurement result can also be extracted. In this case, the section evaluation unit 23 generates a data type A (aggregation result) in which "time = t1", "route ID = 1, section ID = 1", and "evaluation value at time t1" are associated with each other. Then, it is stored in the section aggregation result DB 16. That is, the section evaluation unit 23 can also focus on the measurement results of the angular velocities measured at the same time and totalize.

The period totaling unit 24 is a processing unit that aggregates data in a period such as a date. Specifically, the period aggregation unit 24 aggregates the measurement results of the angular velocity for each data type stored in the conversion result DB 15 at each time when the date and time can be specified, and evaluates using the aggregated measurement results of the angular velocity. Calculate the value. Then, the section evaluation unit 23 generates the DB shown in FIG. 7 and stores it in the period aggregation result DB 17.

For example, the data type A shown in FIGS. 3 to 7 will be used for description. From the data type A stored in the conversion result DB 15, the period totaling unit 1224 obtains the measurement result corresponding to the period "2016/1/1" and the position information "position α = (latitude A, longitude A)". Tally. Then, the period totaling unit 24 calculates the evaluation value from the measured result of the extracted angular velocity. After that, the period totaling unit 24 generates a data type A (aggregation result) in which "period = 2016/1/1", "position information = position α (latitude A, longitude A)" and the evaluation value are associated with each other. Then, it is stored in the period aggregation result DB 17. In this way, the period totaling unit 24 can totalize the measurement results of the angular velocity for each combination of "period and position information".

The generation unit 25 is a processing unit that generates changes over time according to conditions specified by the administrator. Specifically, the generation unit 25 extracts information that matches the conditions specified by the administrator from each information stored in the section aggregation result DB 16 and the period aggregation result DB 17, and various types shown in FIGS. 8 and 9. Information is generated and stored in the time-dependent change DB 18.

FIG. 11 is a diagram illustrating an example of extracting a change over time at a specific position. As shown in FIG. 11, when the generation unit 25 receives the condition specification of "data type = data type B, period = 2016/1/1 to 2016/1/3, position = position α" from the administrator, the conversion unit 25 converts. Data "evaluation 3, evaluation 6, evaluation 9" corresponding to the period "2016/1/1 to 2016/1/3" and the position "position α" are extracted from the data type B stored in the result DB 15. Then, the generation unit 25 is set to "2016/1/1, position α, evaluation 3", "2016/1/2, position α, evaluation 6", "2016/1/3, position α, evaluation 9". Generate changes over time.

FIG. 12 is a diagram illustrating an example of extracting changes over time from section aggregation. As shown in FIG. 12, the generation unit 25 receives from the administrator "data type = data type A, route ID = 1, section ID = 1 to 3, period = 2016/1/1 to 2016/1/3". , "Data type = data type B, route ID = 1, section ID = 1 to 3, period = 2016/1/1 to 2016/1/3" is accepted.

Then, from the data type A stored in the conversion result DB 15, the generation unit 25 has "2016/1/1 to 2016/1/1" among the measurement results of the angular velocities corresponding to "route ID = 1, section ID = 1". The measurement result measured during "3" is extracted. Further, the generation unit 25 is a measurement result of the angular velocity measured between "2016/1/1 and 2016/1/3" among the measurement results of the angular velocity corresponding to "route ID = 1, section ID = 2". And, among the measurement results of the angular velocity corresponding to "route ID = 1, section ID = 3", the measurement result of the angular velocity measured between "2016/1/1 and 2016/1/3" is extracted. After that, the generation unit 25 generates a DB in which the extraction results are arranged in chronological order for each section as a change with time for the data type A.

Similarly, from the data type B stored in the conversion result DB 15, the generation unit 25 has "2016/1/1 to 2016/1/3" among the measurement results corresponding to "route ID = 1, section ID = 1". The measurement results measured during "" are extracted. Further, the generation unit 25 includes the measurement results measured between "2016/1/1 and 2016/1/3" among the measurement results corresponding to "route ID = 1, section ID = 2" and the "route". Among the measurement results corresponding to "ID = 1, section ID = 3", the measurement results measured between "2016/1/1 and 2016/1/3" are extracted. After that, the generation unit 25 generates a DB in which the extraction results are arranged in chronological order for each section as a change with time for the data type B.

As another example, when the generation unit 25 receives and extracts the condition designation of "period = 2016/1/1, interval ID = 1 to 3, data type = data type A and data type B", FIG. 8 The information shown in (a) of (a) can be extracted. Further, the generation unit 25 accepts the condition designation of "period = 2016/1/1, 2016/2/1, 2016/3/1, section ID = 1, data type = data type A and data type B". When extracted, the information shown in FIG. 8B can be extracted.

Further, the generation unit 25 has "route ID = 1, section ID = 1 to 3, period = 2016/1/1 and data type = data type A and data type B, period = 2016/2/1 and data type =. When the conditions of "data type A and data type B, period = 2016/3/1 and data type = data type A and data type B" are accepted and extracted, the information shown in FIG. 9A is extracted. be able to. Further, the generation unit 25 is "route ID = 1, section ID = 1 to 3, data type = data type A and period = 2016/1/1 and 2016/2/1, data type = data type B and period = When the condition designation of "2016/1/1 and 2016/2/1" is accepted and extracted, the information shown in FIG. 9B can be extracted.

The display control unit 26 is a processing unit that displays changes over time. Specifically, when a section on the road is selected by the administrator, the display control unit 26 displays the change over time associated with the section. For example, the display control unit 26 can display the change over time on the administrator terminal or the operation management server, and transmits the change over time corresponding to the vehicle traveling in the selected section and displays it on the in-vehicle device. You can also.

FIG. 13 is a diagram illustrating an example of result display. As shown in FIG. 13, when the display control unit 26 detects that the section of the road on the map displayed on the display or the like is clicked, the selected road corresponds to the route ID = 1 and is selected. It is specified that the specified section corresponds to the section ID = 1. Then, the display control unit 26 extracts the time-dependent change associated with "route ID = 1 and section ID = 1" from the time-dependent change DB 18 and superimposes it on the map for display.

The displayed temporal change is a database showing the temporal change that is generated in advance by the generation unit 25 and stored in the temporal change DB 18. Further, when a plurality of time-dependent changes are stored in the time-dependent change DB 18, the display control unit 26 displays the conditions when the time-dependent changes are generated first, or accepts the designation in advance to display the time-dependent changes. You can also let the administrator choose the change. Further, the display control unit 26 can specify the route ID and the section ID of the clicked road by associating the "route ID" and the "section ID" with each road on the map.

[Processing flow]
Next, the tabulation process and the display process will be described with reference to FIGS. 14 and 15. FIG. 14 is a flowchart illustrating the flow of the aggregation process.

As shown in FIG. 14, when the conversion storage unit 21 receives the processing start instruction (S101: Yes), it selects one angular velocity data type from the measurement result DB 14 (S102), and the position information of the selected data type. (S103).

Subsequently, when the position information of the selected data type is latitude / longitude (S104: Yes), the conversion storage unit 21 stores the selected data type in the conversion result DB 15 as it is (S105). On the other hand, when the position information of the selected data type is not latitude / longitude (S104: No), the conversion storage unit 21 converts the position information into latitude / longitude (S106), and stores the converted data type in the conversion result DB 15. (S107).

Then, when the processing from S102 to S107 is completed for all the data types (S108: Yes), S109 and subsequent steps are executed. On the other hand, when there is an unprocessed data type (S108: No), S102 and subsequent steps are repeated for the unprocessed data type.

After that, the extraction unit 22 changes the position information of each data type into an interval according to the definition information stored in the definition information DB 13 (S109). Subsequently, when the extraction unit 22 receives the evaluation condition and the generation condition (S110: Yes), the extraction unit 22 generates the section aggregation, the period aggregation, the time-dependent change, and the like from the data type after the section change according to the accepted condition (S111). ..

FIG. 15 is a flowchart showing the flow of the display process. As shown in FIG. 15, when the map display instruction is received (S201: Yes), the display control unit 26 displays the map (S202) and determines whether or not the road selection is accepted on the map (S203). ).

Then, when the display control unit 26 accepts the selection of the road (S203: Yes), the display control unit 26 specifies the section on the accepted road (S204), and determines whether the period is specified in advance or at any timing. (S205).

When the period is designated (S205: Yes), the display control unit 26 specifies and displays the change with time of the designated period (S206). On the other hand, when the period is not specified (S205: No), the display control unit 26 identifies and displays the latest change with time (S207), and ends the process.

[effect]
As described above, the road management server 10 can manage data in a unified unit even if the measurement data has a different range as a unit. Even if there are multiple types of data input in units of different distances and times, by converting to a unified unit and storing it, it is possible to output analysis results in the range corresponding to the range input by the customer. .. For example, a route search using data managed in different units can be performed, an optimum route search can be realized, and user satisfaction can be improved. Therefore, the introduction of a road management platform including the road management server 10 can be promoted.

For example, in the first embodiment, an example in which each of the data type A and the data type B is converted into latitude / longitude and then associated with the section ID has been described, but the present invention is not limited to this, and the data type A and the data type B are not limited to this and are not converted into latitude / longitude. It can also be associated with the section ID.

More specifically, each data type stored in the measurement result DB 14 shown in FIG. 4 is changed to a data type associated with the section according to the definition information stored in the definition information DB 13 shown in FIG. Can be done. For example, the data type A can be associated by the same method as in the first embodiment. FIG. 16 is a diagram illustrating an example of associating a link with an interval. As shown in FIG. 16, section 1 indicates the range from latitude A longitude A to latitude B longitude B, section 2 indicates latitude C longitude C-latitude D longitude D, and the range corresponding to section 1 is the link ID =. When straddling 1 and link ID = 2, the measurement result is divided according to the straddling ratio and associated with the section.

Specifically, when 2/3 of the link with the link ID = 1 and 2/3 of the link with the link ID = 2 correspond to the section 1, 2/3 of the measurement result of the link ID = 1 and the link ID = The value obtained by adding 2/3 of the measurement result of 2 is taken as the measurement result of the section 1. Further, when the link with the link ID = 3 and the link with the link ID = 4 are included in the section 2, the measurement results of the respective links are combined. Not only the measurement result but also the position information can be divided or combined according to the section.

Another example of division and combination will be described. FIG. 17 is a diagram illustrating an example of associating the data before conversion with an interval. As shown in FIG. 17, the data type A holds the measurement result in the position information in the unit of 100 m, the data type B holds the measurement result in the link in the unit of 25 m, and the section is managed by the position information in the unit of 50 m.

In this case, for the data type A, the road management server 10 divides the position information into units of 50 m according to the section, and also divides the measurement result according to this division. For example, the road management server 10 divides "1m to 100m" into "1m to 50m" and "51m to 100m", and divides the measurement result "A" of "1m to 100m" into "A / 2". .. Similarly, the road management server 10 divides "101m to 200m" into "101m to 150m" and "151m to 200m", and divides the measurement result "B" of "101m to 200m" into "B / 2". do. Then, the road management server 10 associates "location information = 1 to 50, measurement result = A / 2" with the section 1, and corresponds to "location information = 51 to 100, measurement result = A / 2" with the section 2. Attached, "position information = 101 to 150, measurement result = B / 2" is associated with the section 3, and "position information = 151 to 200, measurement result = B / 2" is associated with the section 4.

Further, for the data type B, the road management server 10 combines the position information so as to be in units of 50 m according to the section, and also combines the measurement results in accordance with this combination. For example, the road management server 10 combines "1 m to 25 m" and "26 m to 50 m", and also combines the measurement results "C1" of "1 m to 25 m" and the measurement results "C2" of "26 m to 50 m". Join. Similarly, the road management server 10 combines "51m to 75m" and "76m to 100m", and the measurement results "C3" of "51m to 75m" and the measurement results "C4" of "76m to 100m". To combine.

Further, the road management server 10 combines "101 m to 125 m" and "126 m to 150 m", and also combines the measurement results "C5" of "101 m to 125 m" and the measurement results "C6" of "126 m to 150 m". Join. Similarly, the road management server 10 combines "151 m to 175 m" and "176 m to 200 m", and the measurement results "C7" of "151 m to 175 m" and the measurement results "C8" of "176 m to 200 m". To combine.

Then, the road management server 10 associates "position information = 1 to 50, measurement result = C1 + C2" with the section 1, and associates "position information = 51 to 100, measurement result = C3 + C4" with the section 2, and the section 3 "Position information = 101 to 150, measurement result = C5 + C6" is associated with, and "position information = 151 to 200, measurement result = C7 + C8" is associated with section 4.

By doing so, the road management server 10 can integrate DBs of different management systems based on the same standard without converting latitude and longitude. The above division example is an example, and the ratio and the like are changed according to the ratio at the time of division or combination. For example, when the position information of the data type A is divided into 2/3 and 1/3, the measurement result is also divided by the ratio. When 2/3 of 1 m to 50 m and 1/3 of 51 m to 100 m are combined as one section, the added value of 2A / 3 and B / 3 is the measurement result. Such ratios are similar for binding.

By the way, although the examples of the present invention have been described so far, the present invention may be carried out in various different forms other than the above-mentioned examples.

[Select information]
In the above embodiment, the data type having both the position information and the time has been described, but the data type having only one of them can be processed in the same manner. For example, when the range is specified by the time instead of the interval in the definition information, each data type is divided or combined using the time.

[Specification conditions]
The conditions for extracting the display target can be arbitrarily changed. For example, the data type to be extracted, the period, the unit of the period (for example, the unit of the day), the position, the evaluation, the route, and the section can be arbitrarily combined.

[location information]
In the above embodiment, latitude and longitude are exemplified as position information, but the present invention is not limited to this, and even a narrow range such as a mesh can be similarly processed. Further, the conditions accepted by the generation unit 25 can also be accepted within a range such as a mesh. Even in this case, the same processing as the above processing can be performed. Further, the position information is not limited to latitude and longitude, but altitude and the like can be processed in the same manner.

[Association of lines and areas]
In the above embodiment, an example of associating line information such as distance and link with line information such as a section has been described, but the present invention is not limited to this, and an area specified by a plurality of latitudes and longitudes is associated with a section. be able to. For example, by associating the measurement result measured in the area with the road existing in the area, the measurement result of the area can be converted into the measurement result of the road, and then the same processing as the above processing can be executed. ..

[Distribute and integration]
Further, each component of each of the illustrated devices does not necessarily have to be physically configured as shown in the figure. That is, the specific form of distribution / integration of each device is not limited to the one shown in the figure, and all or part of them may be functionally or physically distributed / physically in arbitrary units according to various loads and usage conditions. Can be integrated and configured. For example, the conversion storage unit 21, the extraction unit 22, and the display control unit 26 may be connected via a network as an external device of the road management server 10. Further, another device may have the conversion storage unit 21, the extraction unit 22, and the display control unit 26, respectively, and may realize the function of the road management server 10 by being connected to a network and cooperating with each other. ..

Further, among the processes described in this embodiment, all or a part of the processes described as being automatically performed can be performed manually. Alternatively, all or part of the process described as being performed manually can be automatically performed by a known method. In addition, the processing procedure, control procedure, specific name, and information including various data and parameters shown in the above document and drawings can be arbitrarily changed unless otherwise specified.

[hardware]
The road management server 10 can be realized by, for example, a computer having the following hardware configuration. FIG. 18 is a diagram illustrating a hardware configuration example. As shown in FIG. 18, the road management server 10 includes a communication interface 10a, a display device 10b, an HDD (Hard Disk Drive) 10c, a memory 10d, and a processor 10e.

An example of the communication interface 10a is a network interface card or the like. An example of the display device 10b is a display, a touch panel, or the like. The HDD 10c is a storage device for storing programs, data, and the like.

Examples of the memory 10d include a RAM (Random Access Memory) such as SDRAM (Synchronic Dynamic Random Access Memory), a ROM (ReadOnly Memory), a flash memory, and the like. Examples of the processor 10e include a CPU, a DSP (Digital Signal Processor), an FPGA (Field Programmable Gate Array), a PLD (Programmable Logic Device), and the like.

Further, the road management server 10 operates as an information processing device that executes a data generation method by reading and executing a program. That is, the road management server 10 executes a program that executes the same functions as the conversion storage unit 21, the extraction unit 22, and the display control unit 26. As a result, the road management server 10 can execute a process of executing the same functions as the conversion storage unit 21, the extraction unit 22, and the display control unit 26. The program referred to in the other embodiment is not limited to being executed by the road management server 10. For example, the present invention can be similarly applied when another computer or server executes a program, or when they execute a program in cooperation with each other.

This program can be distributed over networks such as the Internet. In addition, this program is recorded on a computer-readable recording medium such as a hard disk, flexible disk (FD), CD-ROM, MO (Magnet-Optical disk), DVD (Digital Versaille Disc), and is recorded from the recording medium by the computer. It can be executed by being read.

Further, the following additional notes will be disclosed with respect to the above embodiments.
(Appendix 1)
Accepts the first data in which the position of the road, the first range based on the position, and the value of the measurement result of the angular velocity for the first range are associated with each other.
The first range is divided and / or combined so as to match the position of the road and the second range with respect to the position, and each ratio of the first range to be divided and / or combined. Correspondingly, the values of the measurement results of the roads associated with each of the first ranges are divided and / or combined.
Each of the second ranges is associated with the result of dividing and / or combining the measurement result values of the road.
A data generation program characterized by having a computer execute a process of storing the associated results in a storage unit.
(Appendix 2)
A processing result obtained by dividing and / or combining the position of the road, the measurement result of the road in the second range, and the measurement result of the angular velocity in the first range stored in the storage unit. Extracts the processing result associated with the specified specified range from
The data generation program according to Appendix 1, which calculates an evaluation value for evaluating a road in the designated range by using the extracted processing result.
(Appendix 3)
The first range of the first data is converted into a latitude / longitude corresponding to the reference, and the range is specified by using the latitude / longitude. The data generation program according to Appendix 1, which generates a value of the measurement result of the road corresponding to the second range from the value of the measurement result of the angular velocity.
(Appendix 4)
When the latitude / longitude of the start point that specifies the first range of the first data and the latitude / longitude of the end point are separated by a predetermined distance or more, a plurality of division distances obtained by dividing the start point to the end point by a predetermined distance. And a plurality of divided values obtained by dividing the value of the measurement result of the angular velocity according to the number of divisions of the plurality of division distances.
A division distance matching the second range is selected from the plurality of division distances, and a division value associated with the matching division distance is selected from the plurality of division values, and each of the second ranges is selected. The data generation program according to Appendix 1, which executes the association with the data.
(Appendix 5)
The position of the road, the third range different from the first range and the second range based on the position, and the value of the measurement result for the third range are associated with each other. Accepting 2 data,
The third range is divided and / or combined so as to match the second range, and each of the third ranges is divided and / or combined according to the respective ratios of the third range. Divide and / or combine the measured values of the associated roads
Each of the second ranges is associated with the result of dividing and / or combining the measurement result values of the road.
A predetermined display unit displays the value of the measurement result of the angular velocity obtained from the first range and the value of the measurement result of the road obtained from the third range, which are associated with each of the second ranges. The data generation program according to Appendix 1 to be displayed in.
(Appendix 6)
Accepts the first data in which the position of the road, the value of the measurement result of the angular velocity measured at the position, and the first range based on the time when the measurement is performed are associated with each other.
The first range is divided and / or combined so as to match the position of the road and the second range based on a predetermined time, and each ratio of the first range to be divided and / or combined. The values of the measurement results of the roads associated with each of the first ranges are divided and / or combined accordingly.
Each of the second ranges is associated with the result of dividing and / or combining the measurement result values of the road.
A data generation program characterized by having a computer execute a process of storing the associated results in a storage unit.
(Appendix 7)
A reception process that accepts the first data in which the position of the road, the first range based on the position, and the value of the measurement result of the angular velocity for the first range are associated with each other.
The first range is divided and / or combined so as to match the position of the road and the second range with respect to the position, and each ratio of the first range to be divided and / or combined. A data processing step of dividing and / or combining the values of the measurement results of the roads associated with each of the first ranges accordingly.
An association step of associating the result of dividing and / or combining the measurement result values of the road with each of the second ranges.
A storage process that stores the associated results in the storage unit,
A data generation method characterized by including.
(Appendix 8)
A reception unit that receives the first data in which the position of the road, the first range based on the position, and the value of the measurement result of the angular velocity for the first range are associated with each other.
The first range is divided and / or combined so as to match the position of the road and the second range relative to the position, and at each ratio of the first range to be divided and / or combined. A data processing unit that divides and / or combines the values of the measurement results of the roads associated with each of the first ranges accordingly.
A mapping unit that associates the results of dividing and / or combining the measurement result values of the road with each of the second ranges.
A storage unit that stores the associated results in the storage unit,
A data generator characterized by having.

10 Road management server 11 Communication unit 12 Storage unit 13 Definition information DB
14 Measurement result DB
15 Conversion result DB
16 Section aggregation result DB
17 Period aggregation result DB
18 Time change DB
20 Control unit 21 Conversion storage unit 22 Extraction unit 23 Section evaluation unit 24 Period aggregation unit 25 Generation unit 26 Display control unit

Claims (8)

Accepts the first data in which the position of the road, the first range relative to the position, and the value of the measurement result of the road including the angular velocity for the road corresponding to the first range are associated with each other.
The first range is divided and / or combined so as to match the position of the road and the second range with respect to the position, and each ratio of the first range to be divided and / or combined. The values of the measurement results of the road associated with each of the first ranges are divided and / or combined accordingly.
Each of the second ranges is associated with the result of dividing and / or combining the measurement result values of the road.
A data generation program characterized by having a computer execute a process of storing the associated results in a storage unit. A processing result obtained by dividing and / or combining the position of the road, the measurement result of the road in the second range, and the measurement result of the angular velocity in the first range stored in the storage unit. Extracts the processing result associated with the specified specified range from
The data generation program according to claim 1, wherein an evaluation value for evaluating a road in the designated range is calculated using the extracted processing result. The first range of the first data is converted into a latitude / longitude corresponding to the reference, and the range is specified by using the latitude / longitude. The data generation program according to claim 1, wherein the value of the measurement result of the road corresponding to the second range is generated from the value of the measurement result of the road. When the latitude / longitude of the start point that specifies the first range of the first data and the latitude / longitude of the end point are separated by a predetermined distance or more, a plurality of division distances obtained by dividing the start point to the end point by a predetermined distance. And a plurality of division values obtained by dividing the value of the measurement result of the road including the angular velocity according to the number of divisions of the plurality of division distances.
A division distance matching the second range is selected from the plurality of division distances, and a division value associated with the matching division distance is selected from the plurality of division values, and each of the second ranges is selected. The data generation program according to claim 1, which executes the association with the data. The position of the road, the third range different from the first range and the second range based on the position, and the value of the measurement result of the road for the third range are associated with each other. Accept the second data,
The third range is divided and / or combined so as to match the second range, and each of the third ranges is divided and / or combined according to the respective ratios of the third range. Divide and / or combine the measured values of the associated road to
Each of the second ranges is associated with the result of dividing and / or combining the measurement result values of the road associated with each of the third ranges.
A predetermined display unit displays the value of the measurement result of the road obtained from the first range and the value of the measurement result of the road obtained from the third range, which are associated with each of the second ranges. The data generation program according to claim 1. Receives first data in which the position of the road, the value of the measurement result of the road including the angular velocity measured at the position, and the first range based on the time when the measurement is performed are associated with each other.
The first range is divided and / or combined so as to match the position of the road and the second range based on a predetermined time, and each ratio of the first range to be divided and / or combined. The values of the measurement results of the road associated with each of the first ranges are divided and / or combined accordingly.
Each of the second ranges is associated with the result of dividing and / or combining the measurement result values of the road.
A data generation program characterized by having a computer execute a process of storing the associated results in a storage unit. Reception that accepts the first data in which the position of the road, the first range based on the position, and the value of the measurement result of the road including the angular velocity for the road corresponding to the first range are associated with each other. Process and
The first range is divided and / or combined so as to match the position of the road and the second range with respect to the position, and each ratio of the first range to be divided and / or combined. A data processing step of dividing and / or combining the measurement result values of the road associated with each of the first ranges accordingly.
An association step of associating the result of dividing and / or combining the measurement result values of the road with each of the second ranges.
A storage process that stores the associated results in the storage unit,
A data generation method characterized by including. Reception that accepts the first data in which the position of the road, the first range based on the position, and the value of the measurement result of the road including the angular velocity for the road corresponding to the first range are associated with each other. Department and
The first range is divided and / or combined so as to match the position of the road and the second range relative to the position, and at each ratio of the first range to be divided and / or combined. A data processing unit that divides and / or combines the measurement result values of the road associated with each of the first ranges accordingly.
A mapping unit that associates the results of dividing and / or combining the measurement result values of the road with each of the second ranges.
A storage unit that stores the associated results in the storage unit,
A data generator characterized by having.

Images