JP7623919B2 - DATA PROCESSING APPARATUS AND DATA PROCESSING METHOD - Google Patents

Description

The present invention relates to a data processing device and a data processing method for processing water pipe update data, and the structure of attribute data used in the device or method.

Patent Document 1 discloses a water pipe renewal management system that enables water utilities to create water pipe renewal plans. The water pipe renewal management system calculates evaluation information that indicates the priority of water pipe renewal, and outputs a list of water pipe information linked to the evaluation information.

JP 2018-63471 A

Water pipe replacement based on a replacement plan is managed by creating a diagram (renewal plan diagram) and table (renewal plan table) showing the replacement plan, as well as a diagram (renewal performance diagram) and table (renewal performance table) showing the performance of the replacement. If the replacement does not progress as planned, the planner compares the replacement plan diagram with the replacement performance diagram, as well as the replacement plan table with the replacement performance table, and manually tallys up the progress and reviews the plan. This can lead to errors in the tally. Also, because reviewing the plan depends on the skill of the planner, uniform management is difficult.

One aspect of the present invention aims to realize a data processing device that can appropriately manage water pipe renewal.

In order to solve the above problem, a data processing device according to one aspect of the present invention includes an update plan creation unit that creates an update plan showing the planned update periods of the multiple water pipes on a map showing the installation locations of the multiple water pipes based on attribute data showing at least the installation location, pipe type, diameter, pipeline length, planned update period, and installation state for each of the multiple water pipes; an update plan table creation unit that creates an update plan table showing the total pipeline length of the multiple water pipes to be updated during the planned update period for each planned update period and for each pipe type and diameter based on the attribute data; and an update plan table revision unit that, when the installation state of any of the multiple water pipes is changed, reflects the change in the attribute data and revises the update plan table by inputting the pipeline length after the installation state is changed based on the reflected attribute data.

According to the above configuration, in the data processing device, the update plan drawing creation unit creates an update plan drawing based on the attribute data. Also, the update plan table creation unit creates an update plan table based on the attribute data. When the installation state of the water pipe shown in the update plan drawing is changed, the update plan table revision unit automatically revises the update plan table based on the pipe length of the water pipe whose installation state has been changed. This prevents users from making mistakes in compiling the update record, and allows uniform management that is independent of the user. In other words, water pipe updates can be managed appropriately.

In addition, in a data processing device according to one aspect of the present invention, the update plan table revision unit may compile the pipeline lengths of the water pipes whose installation state has been changed for each pipe type and diameter, and input the pipeline lengths into the update plan table to revise the update plan table.

With the above configuration, the progress based on the pipeline length can be easily understood by inputting the changed pipeline length for each pipe type and diameter.

The data processing device according to one aspect of the present invention further includes an update performance diagram creation unit that creates an update performance diagram that reflects the change in the installation status of the water pipe in the update plan diagram based on the attribute data after the installation status has been changed, and the attribute data further includes an installation status change time that indicates the time when the installation status was changed, and the update performance diagram creation unit displays the water pipe whose installation status in the attribute data has been changed in a display mode according to the installation status change time, regardless of the installation status after the change.

According to the above configuration, the user can know the water pipes whose installation status has been changed by the year in which the installation status was changed, regardless of the installation status after the change.

In addition, in a data processing device according to one aspect of the present invention, the update history diagram creation unit may create the update history diagram by making the display mode of the water pipe whose installation state has been changed to an updated state different from the display mode of the water pipe whose installation state has not been updated.

With the above configuration, the water pipes before and after the renewal can be easily identified at a glance in the renewal performance diagram.

In addition, in a data processing device according to one aspect of the present invention, when an arbitrary planned update period is set as a first planned update period and an update period subsequent to the first planned update period is set as a second planned update period, the update plan table creation unit may revise the total pipe length for each pipe type and caliber for the water pipes scheduled for update in the second planned update period based on the difference between (i) the total pipe length for each pipe type and caliber for the water pipes scheduled for update in the first planned update period and (ii) the total pipe length for each pipe type and caliber included in the update record for the first planned update period.

According to the above configuration, for water pipes scheduled for renewal in a second renewal schedule period that is later than the first renewal schedule period, the total pipe length can be ascertained for each pipe type and diameter, thereby reducing the work involved in revising water pipe renewal plans.

The data processing device according to one aspect of the present invention may further include a budget calculation unit that calculates the budget required to lay the water pipe by multiplying the pipeline length of the water pipe by a coefficient corresponding to the pipe type and the diameter of the water pipe.

The above configuration can reduce the labor required to calculate the budget required for water pipe renewal.

In addition, a data processing method according to one aspect of the present invention includes an update plan drawing step of drawing an update plan drawing showing the planned update periods of the multiple water pipes on a map showing the locations of the multiple water pipes based on attribute data showing at least the installation location, pipe type, diameter, pipeline length, planned update period, and installation state for each of the multiple water pipes; an update plan table drawing step of drawing an update plan table showing the total pipeline length of the multiple water pipes to be updated during the planned update period for each planned update period and for each pipe type and diameter based on the attribute data; and an update plan table revising step of reflecting the change in the attribute data when the installation state of any of the multiple water pipes is changed, and revising the update plan table by inputting the pipeline length after the installation state is changed based on the reflected attribute data into the update plan table.

The above configuration provides the same effects as the above data processing device.

In addition, the attribute data according to one aspect of the present invention is attribute data of water pipes used in a data processing device that creates an update plan showing the planned update period for each of a plurality of water pipes on a map showing the installation location of each of the plurality of water pipes, the attribute data indicating at least the installation location, pipe type, diameter, pipeline length, planned update period, and installation status for each of the plurality of water pipes, the update plan table creation unit of the data processing device is used in a process of creating an update plan table showing the total pipeline length of the plurality of water pipes to be updated during the planned update period for each planned update period and for each pipe type and diameter, and the update plan table revision unit of the data processing device is used in a process of revising the update plan table by inputting the pipeline length after the installation status has been changed into the update plan table when the installation status of any of the plurality of water pipes has been changed.

The attribute data according to one embodiment of the present invention further includes a laying condition change time indicating the time when the laying condition was changed, and is used by the update performance chart creation unit of the data processing device in a process of creating an update performance chart in which the change in the laying condition of the water pipe is reflected in the update plan chart, and the water pipe whose laying condition has been changed is displayed in a display mode according to the laying condition change time, regardless of the changed laying condition.

The data processing device, data processing method, and attribute data according to one aspect of the present invention allow for proper management of water pipe updates.

1 is a block diagram showing an example of a configuration of a main part of a data processing device; FIG. 13 is a diagram showing an example of an update plan. FIG. 13 is a diagram showing an example of display of attribute data. FIG. 13 is a diagram illustrating an example of an update plan table. FIG. 13 is a diagram showing an example of an update record diagram. 13 is a flowchart illustrating an example of a process performed by a control unit.

[Embodiment]
Hereinafter, one embodiment of the present invention will be described in detail.

FIG. 1 is a block diagram showing an example of the configuration of the main parts of a data processing device 1 according to an embodiment of the present invention. As shown in FIG. 1, the data processing device 1 includes a control unit 10, an input receiving unit 20, a display unit 30, and a storage unit 40.

The control unit 10 controls the operation of the data processing device 1. The control unit 10 includes an update plan drawing creation unit 11, an update plan table creation unit 12, and an update plan table revision unit 13. The control unit 10 further includes an update performance drawing creation unit 14 and a cost calculation unit 15 (budget calculation unit).

The renewal plan creation unit 11 creates a renewal plan based on attribute data for each of the multiple water pipes. The attribute data indicates at least the installation location, pipe type, diameter, pipeline length, planned renewal period, and installation status for each of the multiple water pipes. Of these, the installation status indicates whether the water pipe is before renewal, has been renewed, or has been removed. The renewal plan shows the planned renewal period for the multiple water pipes on a map showing the installation locations of the multiple water pipes.

Figure 2 is a diagram showing an example of an update plan diagram. In the update plan diagram, multiple water pipes are displayed in different display modes for each planned update period. For example, in the update plan diagram, multiple water pipes are displayed in different colors for each planned update period. However, for convenience in FIG. 2, the difference in color is shown by a different pattern. In the example shown in FIG. 2, the planned update period is a fiscal year. Specifically, the planned update period for water pipe P1 extending approximately north-south and water pipe P2 extending approximately east-west is shown to be fiscal year 2021. Note that in the example shown in FIG. 2, water pipes with a planned update period of fiscal year 2022 or later are only shown in the legend.

However, in the renewal plan drawing, multiple water pipes may be shown with different line types or patterns for each planned renewal period. In addition, the planned renewal period does not have to be an annual period, but may be any period such as six months or two years.

Figure 3 is a diagram showing an example of the display of attribute data. Figure 3 is also a diagram showing the structure of attribute data used in the data processing device 1. When a user selects any water pipe in the update plan diagram shown in Figure 2, a window showing attribute data is displayed as shown in Figure 3. In the window shown in Figure 3, the "unique key" shown in column C11 and the "FID_KEY" shown in column C12 are data unique to each water pipe. The "unique key" and "FID_KEY" are linked to the graphic attributes of the water pipe. The graphic attributes include coordinate data indicating the location of the water pipe on the map. That is, in the attribute data, the "unique key" and "FID_KEY" indicate the location of the water pipe.

In the window shown in FIG. 3, the "Pipe type" shown in column C13 indicates the type of water pipe. The "Diameter" shown in column C14 indicates the diameter of the water pipe. The "Plane extension" shown in column C15 indicates the pipe length of the water pipe.

In addition, in the window shown in FIG. 3, the "Initial Planned Year" shown in column C16 indicates the year of the planned update period in the attribute data. The "Last Updated Year" shown in column C17 indicates the year in which the water pipe was updated. The "Actual Update Year" shown in column C18 indicates the year in which the water pipe was removed. The state of input values in the "Last Updated Year" and "Actual Update Year" indicates the installation state of the water pipe.

In the "initial planning year", a value indicating the planned renewal period at the time when the renewal plan was first created is input. In the "last renewal year", the same value as the value of the "initial planning year" is input as the initial value. When the fiscal year changes, for water pipes that have not been renewed, the value of the "last renewal year" is updated to a value indicating the new fiscal year. Therefore, when the value of the "last renewal year" indicates the current fiscal year, the installation state of the water pipe is before renewal. On the other hand, when the fiscal year changes, the value of the "last renewal year" is not updated for water pipes that have been renewed. Therefore, when the value of the "last renewal year" indicates a fiscal year prior to the current fiscal year, the installation state of the water pipe has been updated. In the "actual renewal year", a value is input only when the water pipe has been removed. Therefore, when a value is input in the "actual renewal year", the installation state of the water pipe has been removed. The updating of these attribute data may be performed by an operator. In addition, the control unit 10 may have a separate function for updating these attribute data.

In addition, "Last update year" when the installation status has been updated, and "Year of previous update" when the installation status has been removed, indicate the time when the installation status was changed. Therefore, in the example shown in Figure 3, it can be said that the attribute data includes the installation status change time, which indicates the time when the installation status was changed.

The renewal plan table creation unit 12 creates a renewal plan table for each of the multiple water pipes based on the attribute data configured as shown in FIG. 3 above. The renewal plan table shows the total pipeline length of the multiple water pipes to be renewed during each planned renewal period for each water pipe type and diameter, and will be described in more detail below.

Figure 4 is a diagram showing an example of a renewal plan table. In the example shown in Figure 4, area R1 is an area showing the type of work, pipe type, and diameter. In the example shown in Figure 4, the pipe type is called "product type." Also, in the example shown in Figure 4, the diameter is called "shape and dimension." In area R1, the type of work for water pipe renewal is shown as "water distribution pipe installation." Also, in the example shown in Figure 4, in addition to water pipe renewal, types of work other than water pipe renewal, such as renewal of fire hydrant equipment or water supply hydrants, are also shown. Pipe type indicates the type derived from the material or method of the water pipe. Pipe types include classifications such as ductile iron pipe and polyethylene pipe.

Region R2 indicates the length of the water pipes for each pipe type and caliber, and the budget required for updating the length of the pipes (hereinafter, sometimes referred to as the "water pipe budget" or "budget"). Region R2 also indicates the quantity and budget for each type of work other than the above-mentioned water pipe renewal. For simplicity, in FIG. 4, the region indicating the length or quantity of the water pipes in region R2 is simply referred to as "quantity". The length of the water pipes in region R2 is the total of the pipe lengths to be renewed over the entire period of the renewal plan, for each pipe type and caliber. The budget of the water pipes in region R2 is the total of the budget required for renewal over the entire period of the renewal plan, for each pipe type and caliber. The budget of the water pipes is calculated by multiplying the length of the water pipes by a predetermined coefficient. The predetermined coefficient is preset for each type of work and for each pipe type and caliber.

Area R3 is an area showing the pipeline length of the water pipe and the budget for the water pipe for each pipe type and caliber. The budget for the water pipe in area R3 is calculated in the same manner as the budget for the water pipe in area R2 described above. The renewal plan table creation unit 12 inputs the sum of the pipeline lengths in the attribute data for multiple water pipes for each planned renewal period in the attribute data and for each pipe type and caliber, and the budget calculated based on the sum. For example, column C21 in area R3 is a column showing the pipeline length for a ductile iron pipe with a caliber of 200 mm in fiscal year 2021. Column C22 in area R3 is a column showing the budget for a ductile iron pipe with a caliber of 200 mm in fiscal year 2021.

In addition, in region R3, a column showing the actually updated pipeline length is provided below the column showing the pipeline length of the water pipe to be updated. Furthermore, a column showing the actual cost required for the update is provided below the column showing the budget for the water pipe to be updated. For example, column C23 in region R3 is a column showing the pipeline length for a ductile iron pipe with a diameter of 200 mm that was actually updated in fiscal year 2021. Also, column C24 in region R3 is a column showing the cost required for the update of a ductile iron pipe with a diameter of 200 mm that was actually updated in fiscal year 2021. The column showing the actually updated pipeline length and the cost required is revised by the update plan table revision unit 13 described later according to the progress of the update. Therefore, the pipeline length and budget to be updated and the actually updated pipeline length and the cost required can be easily compared for each planned update period and for each pipe type and diameter.

The update plan table creation unit 12 may also revise the update plan table according to the progress of the update. Specifically, an arbitrary scheduled update period is set as the first scheduled update period, and a scheduled update period after the first scheduled update period is set as the second scheduled update period. At this time, the update plan table creation unit 12 calculates the difference between (i) the total pipe length for each pipe type and diameter for the water pipes scheduled for update in the first scheduled update period, and (ii) the total pipe length for each pipe type and diameter included in the update record in the first scheduled update period. Here, "included in the update record in the first scheduled update period" means that the time of change in the laying state in the attribute data, that is, the above-mentioned "latest update year" or "update record year", is the first scheduled update period. Then, the update plan table creation unit 12 revise the total pipe length for each pipe type and diameter for the water pipes scheduled for update in the second scheduled update period based on the calculated difference. That is, the renewal plan table creation unit 12 calculates the total pipe length for each pipe type and diameter for water pipes whose attribute data indicates that the planned renewal period is the first planned renewal period and that no values have been entered in the "Latest renewal year" and "Renewal performance year". Furthermore, the renewal plan table creation unit 12 adds the calculated total to the total pipe length for water pipes whose pipe type and diameter are the same and whose planned renewal period is the second planned renewal period. This allows the user to grasp the total pipe length for each pipe type and diameter for water pipes that are scheduled to be renewed in the second planned renewal period, which is later than the first planned renewal period. This makes it possible to reduce the work involved in revising the renewal plan for water pipes.

For example, for a certain pipe type and caliber, the total pipeline length included in the renewal results for fiscal year 2021 is 5 m shorter than the total pipeline length scheduled for renewal in fiscal year 2021. In this case, the renewal plan table creation unit 12 adds 5 m to the pipeline length of that pipe type and caliber that is scheduled to be renewed in a year after fiscal year 2021, for example, fiscal year 2026 or later. The renewal plan table creation unit 12 may add 5 m to the pipeline length that is scheduled to be renewed in a single fiscal year. The renewal plan table creation unit 12 may also add to the pipeline length that is scheduled to be renewed in each of multiple fiscal years so that the total comes to 5 m.

When the installation state of any of the multiple water pipes is changed, the update plan table revising unit 13 reflects the change in the attribute data. In addition, the update plan table revising unit 13 revises the update plan table by inputting the pipeline length after the installation state has been changed into the update plan table based on the attribute data reflecting the change in the installation state.

For example, if the water pipe P1 shown in the renewal plan diagram shown in FIG. 2 is renewed in fiscal year 2021, the user selects the water pipe P1 in the renewal plan diagram to display the attribute data window shown in FIG. 3. In the window, the user inputs the value 2021 in the "Last renewal year" field. At this time, the renewal plan table revising unit 13 reflects the input value in the attribute data of the water pipe P1. Furthermore, the renewal plan table revising unit 13 adds the pipe length of the water pipe P1 to the pipe length entered in the fiscal year 2021 field for the pipe type and caliber of the water pipe P1 in the renewal plan diagram shown in FIG. 4.

Specifically, the renewal plan table revising unit 13 tally up the pipe lengths of water pipes whose installation status has been changed by pipe type and diameter, and inputs the results into the renewal plan table to revise the renewal plan table. This allows the user to easily grasp the progress of the water pipe renewal plan based on the pipe length.

The update performance diagram creation unit 14 creates an update performance diagram based on the attribute data after the laying state has been changed. The update performance diagram is a diagram that reflects the change in the laying state of the water pipe in the update plan diagram. The update performance diagram creation unit 14 displays the water pipe whose laying state has been changed in the update performance diagram in a display mode according to the time of the laying state change, regardless of the laying state after the change. Specifically, the update performance diagram creation unit 14 determines the display mode of the water pipe in the update performance diagram by referring to the time of the laying state change in the attribute data. For example, the update performance diagram creation unit 14 displays the water pipe that was updated in 2021 and the water pipe that was removed in 2021 in the same color. Therefore, the user can grasp the water pipe whose laying state has been changed for each year in which the laying state was changed, regardless of whether the laying state was changed to updated or removed.

The update history diagram creation unit 14 creates the update history diagram by making the display mode of water pipes whose installation state has been changed to an updated state different from the display mode of water pipes whose installation state has not been updated. This allows the user to easily visually identify the water pipes before the update and the water pipes that have been updated in the update history diagram.

Figure 5 is a diagram showing an example of an update performance diagram. In the example shown in Figure 5, the update performance diagram creation unit 14 creates the update performance diagram by making the color of water pipes whose installation state has been changed to an updated state different from the color of water pipes whose installation state has not been updated.

In the example shown in FIG. 5, water pipe P1 and water pipe P21, which is a part of water pipe P2, have been updated. On the other hand, water pipe P22, which is a part of water pipe P2 other than water pipe P21, has not been updated. For this reason, water pipes P1 and P21 and water pipe P22 are shown in different colors in the update performance diagram. However, in the example shown in FIG. 5, water pipes P1 and P21 and water pipe P22 are shown in different patterns for the sake of convenience. In addition, in the example shown in FIG. 5, an area R4 is provided in the update performance diagram that shows the pipe length of water pipes for which updates have been completed by diameter. If the water pipes for which updates have been completed include multiple water pipes of different pipe types, the pipe length for each pipe type is also shown in area R4.

The update history map creation unit 14 can also hide water pipes whose installation status is "removed" in the update history map. When the update history map creation unit 14 hides water pipes whose installation status is "removed," the update history map can be used as a normal map that displays only existing water pipes.

The cost calculation unit 15 calculates the budget required for laying the water pipe by multiplying the pipeline length of the water pipe to be updated by a coefficient corresponding to the pipe type and diameter of the water pipe. The cost calculation unit 15 outputs the calculated budget to the update plan table creation unit 12. The update plan table creation unit 12 reflects the budget calculated by the cost calculation unit 15 in the update plan table. This makes it possible to reduce the labor required for calculating the budget required for updating the water pipe.

The cost calculation unit 15 also calculates the cost required to lay the water pipe by multiplying the updated pipeline length of the water pipe by a coefficient corresponding to the pipe type and diameter of the water pipe. The cost calculation unit 15 outputs the calculated cost to the update plan table revising unit 13. The update plan table revising unit 13 reflects the cost calculated by the cost calculation unit 15 in the revision of the update plan table. Therefore, the user can easily grasp the progress of the update plan not only in terms of pipeline length but also in terms of cost.

The input reception unit 20 is an input device that receives user input to the data processing device 1. The input reception unit 20 may be one or more of a touch panel, a mouse, and a keyboard. The display unit 30 is an output device that outputs information to the user by means of images. The display unit 30 may be a liquid crystal display or an organic EL (Electro Luminescence) display.

The storage unit 40 is a storage device that stores information necessary for processing in the data processing device 1. The storage unit 40 stores, for example, the attribute data described above. However, the data processing device 1 does not necessarily need to include the storage unit 40, and may be configured to be able to communicate with an external storage device that stores information equivalent to that of the storage unit 40.

The data processing device 1 may further include an output unit that outputs the above-mentioned update plan table and/or update performance diagram to the outside as a form. The output unit may output the update plan table and/or update performance diagram as an actual form, or may output them as electronic data.

Figure 6 is a flowchart showing an example of processing (data processing method) by the control unit 10. In the example shown in Figure 6, first the update plan drawing creation unit 11 creates an update plan drawing (S1, update plan drawing creation step). In addition, the update plan table creation unit 12 creates an update plan table (S2, update plan table creation step). The update plan drawing and the update plan table do not necessarily need to be created in this order, and may be created in parallel or in the reverse order.

The update plan table revising unit 13 judges whether the installation state of any water pipe has been changed (S3). If the installation state has not been changed (NO in S3), the update plan table revising unit 13 repeats the above judgment until the installation state is changed. If the installation state has been changed (YES in S3), the update plan table revising unit 13 reflects the change in the installation state in the attribute data (S4, update plan table revising step). Furthermore, the update plan table revising unit 13 revises the update plan table (S5, update plan table revising step). Furthermore, the update performance diagram creating unit 14 creates an update performance diagram (S6).

In step S2, the cost calculation unit 15 calculates the budget for each planned renewal period and for each pipe type and diameter. The renewal plan table creation unit 12 reflects the budget calculated by the cost calculation unit 15 in the renewal plan table. In addition, in step S5, the cost calculation unit 15 calculates the cost required to renew or remove the water pipe whose installation state has been changed. The renewal plan table revision unit 13 reflects the cost calculated by the cost calculation unit 15 in the renewal plan table.

As described above, according to the data processing device 1, when a user changes the installation status of a water pipe shown in the update plan drawing, the update plan table revision unit 13 automatically revises the update plan table based on the pipe length of the water pipe whose installation status has been changed. This prevents users from making mistakes in compiling the update results, and enables uniform management that is independent of the user. In other words, it becomes possible to properly manage the updates of water pipes.

In addition, this configuration allows for proper management of water pipe renewal, which contributes to creating livable cities. This will contribute to achieving Goal 13 of the Sustainable Development Goals (SDGs), "Making cities and towns sustainable."

The data processing device 1 does not have to include the update performance map creation unit 14 and/or the cost calculation unit 15. Even if the data processing device 1 does not include the update performance map creation unit 14 and/or the cost calculation unit 15, the update plan table revising unit 13 automatically revises the update plan table as described above, thereby making it possible to appropriately manage the renewal of water pipes.

[Software implementation example]
The functions of the data processing device 1 (hereinafter referred to as the "device") can be realized by a program for causing a computer to function as the device, and a program for causing a computer to function as each control block of the device (particularly each part included in the control unit 10).

In this case, the device includes a computer having at least one control device (e.g., a processor) and at least one storage device (e.g., a memory) as hardware for executing the program. The control device and storage device execute the program, thereby realizing each of the functions described in each of the above embodiments.

The program may be recorded on one or more computer-readable recording media, not on a temporary basis. The recording media may or may not be included in the device. In the latter case, the program may be provided to the device via any wired or wireless transmission medium.

In addition, some or all of the functions of each of the above control blocks can be realized by a logic circuit. For example, an integrated circuit in which a logic circuit that functions as each of the above control blocks is formed is also included in the scope of the present invention. In addition, it is also possible to realize the functions of each of the above control blocks by, for example, a quantum computer.

The processes described in each of the above embodiments may be executed by AI (Artificial Intelligence). In this case, the AI may run on the control device, or on another device (such as an edge computer or a cloud server).

The present invention is not limited to the above-described embodiments, and various modifications are possible within the scope of the claims. The technical scope of the present invention also includes embodiments obtained by appropriately combining the technical means disclosed in different embodiments.

Reference Signs List 1 Data processing device 11 Renewal plan drawing creation unit 12 Renewal plan table creation unit 13 Renewal plan table revision unit 14 Renewal performance drawing creation unit 15 Cost calculation unit (budget calculation unit)

Claims (7)

an update plan drawing creating unit that creates an update plan drawing showing the planned update periods of the plurality of water pipes on a map showing the installation locations of the plurality of water pipes based on attribute data showing at least the installation location, pipe type, diameter, pipeline length, planned update period, and installation state of each of the plurality of water pipes;
An update schedule creation unit that creates an update schedule indicating the total pipe length of the plurality of water pipes to be updated during the update schedule period for each of the planned update periods and for each of the pipe types and diameters based on the attribute data;
and an update plan table revising unit that, when the installation state of any of the plurality of water pipes is changed, reflects the change in the attribute data and revises the update plan table by inputting the pipeline length after the installation state is changed based on the reflected attribute data. The data processing device according to claim 1, wherein the renewal plan table revision unit compiles the pipe lengths of the water pipes whose installation state has been changed for each pipe type and diameter, and inputs the pipe lengths into the renewal plan table to revise the renewal plan table. A renewal performance diagram creation unit creates a renewal performance diagram in which the renewal plan diagram reflects the change in the laying condition of the water pipe based on the attribute data after the laying condition has been changed,
The attribute data further includes a laying state change time indicating a time when the laying state was changed,
3. The data processing device according to claim 1, wherein the update performance diagram creation unit displays the water pipe whose installation state in the attribute data has been changed in a display mode according to the time when the installation state was changed, regardless of the installation state after the change. The data processing device according to claim 3, wherein the update history diagram creation unit creates the update history diagram by making the display mode of the water pipes whose installation state has been changed to an updated state different from the display mode of the water pipes whose installation state has not been updated. If an arbitrary scheduled renewal period is set as a first scheduled renewal period and a scheduled renewal period after the first scheduled renewal period is set as a second scheduled renewal period,
5. The data processing device according to claim 1, wherein the update plan table creation unit modifies the sum of the pipeline lengths for the pipe types and the diameters for the water pipes scheduled for update in the second planned update period based on a difference between (i) the sum of the pipeline lengths for the pipe types and the diameters for the water pipes scheduled for update in the first planned update period and (ii) the sum of the pipeline lengths for the pipe types and the diameters included in the update results for the first planned update period. The data processing device according to any one of claims 1 to 5, further comprising a budget calculation unit that calculates the budget required for laying the water pipe by multiplying the pipeline length of the water pipe by a coefficient corresponding to the pipe type and the diameter of the water pipe. A data processing method performed by a data processing device, comprising:
An update plan drawing step of drawing an update plan drawing showing the planned update periods of the plurality of water pipes on a map showing the installation locations of the plurality of water pipes based on attribute data showing at least the installation location, pipe type, diameter, pipeline length, planned update period, and installation state of each of the plurality of water pipes;
An update schedule creation step of creating an update schedule showing the total pipe length of the plurality of water pipes to be updated during the update schedule period for each of the planned update periods and for each of the pipe types and diameters based on the attribute data;
and an update plan table revising step of, when the installation state of any of the plurality of water pipes is changed, reflecting the change in the attribute data, and revising the update plan table by inputting the pipeline length after the installation state has been changed based on the reflected attribute data.

Images