JP4412719B2 - Budget request / subsidy grant application support system in public sewerage projects - Google Patents

Description

The present invention relates to a method and system for supporting a budget request / subsidy grant application in a public sewer business.
In addition, the public sewer business in this application includes a specific environmental conservation public sewer business and a basin-related public sewer business.

The outline of the design and management work in the public sewer business is as shown in FIG. In the authorized design, the entire business volume over many years is designed, and a basic design document (design drawing, quantity calculation document, construction cost statement, design specifications) is prepared based on the annual plan.
The budget request will be submitted by accumulating the construction cost for the business volume scheduled for construction in the next fiscal year. In budget requests, the amount of business may be calculated from the budget request amount, but in any case, it is necessary to make repeated calculations.

  The flow of the conventional construction cost estimation work in the public sewer business is as shown in FIG. First, enter the number of sections and locations in the pre-assumed area as the work area split quantity data (STEP 41), total the quantity for each work type and part name (STEP 42), and enter the design unit price data (STEP 43). Calculate the construction cost from the results of STEP42 and STEP43 (STEP45), check whether it is the target construction cost (STEP45), and output the result if the target construction cost is achieved . However, it is rare that the target construction cost can be achieved at one time. In this case, it is necessary to repeat the steps 41 to 44 again.

FIG. 5 shows the flow of “budget request” and “subsidy grant application” in the public sewer business. The budget request is made once a year, and a rough design of the work to be done in that year will be done by November of the previous year, and the necessary budget request will be created and submitted to the government office. In response to the budget request, a notification is made in April of the following year.
Subsidy grant applications are made four times a year, and subsidies are issued as needed by applying in May, June, September, and December. Since the total work accompanying the subsidy application is four times a year, it is desired to improve the work efficiency.

  On the other hand, a method for constructing and managing public facilities using a computer system has been proposed (Patent Document 1).

JP 2001-338130 A

  Previously, the number of parts used was calculated based on the drawing data created by CAD software and other drawing data, and integration was performed. However, design work using such a method requires many drawings and many quantity calculations. However, there is a problem that it is necessary to extract materials from the pre-established work area and add them up, which takes a lot of labor.

  In addition, in the construction cost estimation work at the time of budget request / subsidy application, i) use only rough design, ii) use only detailed design, iii) use both rough design and detailed design. There is a case. Until now, rough design and detailed design have been performed separately, and there is a problem that work efficiency has not been improved.

  This invention is made | formed in view of such a situation, Comprising: It aims at providing the method and system for reducing the effort of the budget request and subsidy grant application work in a public sewer business.

  The present invention is characterized in that a unique composite diagram is used as a control diagram in a budget request / subsidy grant application for a public sewer business. The composite drawing used in the present invention is a drawing composed of a licensed blueprint, an implementation control blueprint, and a production blueprint, enabling the results of design work in the public sewer business to be reflected in a timely manner, and Estimate construction costs easily.

That is, the first invention is a support system for budget request / subsidy grant application in public sewerage business using GIS, and is a schematic design diagram in which processing zones and work zones are set, and processing zones and work zones are set. The drawing storage means for storing the detailed design drawing, the schematic design drawing and the detailed design drawing are read from the drawing storage means, a composite drawing in which the processing zone and the work zone are linked is created, and the composite drawing is stored in the drawing storage means. Composite chart creating means, control chart creating means for reading a composite chart from the drawing storage means, creating a plurality of control charts for each year from the composite chart, and storing them in the drawing storage means, and a display for displaying the control chart Means for selecting a work area on the created control chart, a selected work area coloring display means for displaying the work area selected on the control chart in a color different from other work areas, and a design unit price data. Unit storage means for storing data, construction cost integration means for integrating the construction cost of the work area selected on the control chart based on the design unit price data read from the unit price storage means, and reading the control chart from the drawing storage means A yearly work area coloring display means for displaying the work areas for each year in different colors on the control chart, and the control chart creating means reads out a plurality of control charts from the drawing storage means and performs detailed design in each control chart It is the support system of the budget request and subsidy grant application in the public sewer business characterized by being able to make the related figure which colored the part which consists of the drawing which relates to the part which consists of the drawing which relates to outline design with the color which differs.

The second invention according to the first invention, the composite diagram drawing means reads a schematic design diagrams and detailed design drawing from a drawing memory means, synthesized diagram and remove duplicate information in more detail blueprint from schematic design drawing It is characterized by creating .

A third invention is characterized in that, in the first or second invention, the schematic design drawing includes an authorized design drawing, and the detailed design drawing includes an execution design drawing and a volume design drawing .

According to the present invention, it is not necessary to create a control chart for a budget request / subsidy grant application, and it is possible to significantly reduce the number of work steps in the budget request / subsidy grant application work. Become.
That is, the present invention has the following three effects.
1) By using a composite diagram as a control diagram using GIS, it is possible to automatically output business volume, project cost, forms, and coloring diagrams.
2) By sharing a plurality of control charts required for budget request / subsidy grant application work, it will be possible to significantly reduce the number of man-hours for drawing in the work concerned.
3) It can be used as the final maintenance chart by modifying the composite chart from the annual volume. As a result, maintenance charts can be created only with very limited operations such as adding some trader names and the like, and man-hours can be greatly reduced.

FIG. 1 is a system configuration diagram of the present invention. The system according to the present invention includes a personal computer 2 connected to an input device 1 and an output device 3. The input device 1 is an input device such as drawing data such as a digitizer or a scanner. The output device 3 is an output device such as a dot printer, a laser printer, or an inkjet plotter. The personal computer 2 includes a GIS 21, database software 22, CAD software 23, spreadsheet software 24, surveying software 25, a cooperation program 26 for integrating these software, and an integration program 27. The programs 26 and 27 are programs created in a general-purpose development language such as Visual Basic (registered trademark) of Microsoft Corporation. The other softwares 21 to 25 are commercially available general-purpose software.
Note that the present invention can be realized without both the input device 1 and the output device 3 when data can be exchanged via a network, an electronic storage medium, or the like.

FIG. 2 shows a processing procedure of the system of the present invention.
In the system of the present invention, first, a target business name is selected (STEP 1). Examples of business names to be selected include public sewerage projects, specific environmental conservation public sewerage projects, and basin-related public sewerage projects.
When a business name is selected, a control chart of the location that is the target of the budget request / subsidy grant application is displayed (STEP 2). The control chart is a drawing in which the construction plan for each fiscal year is colored on the facility floor plan (usually scale 1/2500), and it shows the construction completion routes in the previous fiscal year and the routes from the following fiscal year. When the user inputs the name of a processing zone, a control chart of the corresponding processing zone is displayed on the screen. (STEP3). In addition, the name representing the area is generally used as the name of the treatment ward, and in many cases, the name of a character or the name of an old town is used.

Next, select a work area and add up the construction costs of the work area to be applied in sequence (STEP 4).
When the user inputs a work area number, the work area on the control chart corresponding to the number is colored. When a selected section is clicked in the control chart displayed on the screen, the clicked selected section is further colored with a different color, and it can be visually confirmed that the construction cost has been added. Until the selection of all selected sections is completed, the same work is performed in the corresponding section in order (STEP 5). After completion of the work area selection work, when the construction cost is automatically accumulated in the selected work area, the business name, processing area name, work area number, business amount, and business cost are entered in various forms (STEP 6). It is also filled in and colored in the designated drawing format. As a result, various forms and drawings can be output (STEP 7, 8).

  The system according to the present invention is characterized in that a unique composite diagram is used as a GIS control diagram in the above processing. The composite drawing used in the present invention is a drawing composed of an authorized design drawing, an implementation control drawing, and a volume drawing, and the results of the design work in the public sewer business are reflected in a timely manner, and from the input numerical data It is possible to automatically calculate the construction cost of the selected part.

  The flow of creating a composite diagram used in the system according to the present invention will be described with reference to an example in FIG. The vertical axis in FIG. 6 shows the flow of time, and the table on the left of the drawing shows the work in the public sewerage project, the drawing used to perform the work (Input), and the drawing created as the result of the work (Output) It is shown.

  Explaining in time series, first, in the authorized design (1), a rough design for all routes 7,000m is performed, and (A) an authorized design drawing is created. In survey request (2) and grant application (3), (B) budget request management chart and (C) subsidy grant application management chart are created using the approved design drawing as input. As mentioned above, the budget request is November and the subsidy application is for the next year, so work (2) will be done in the second year, and work (3) will be done in the third year. For convenience of explanation, the budget request for the second year shall be applied for 1,000m at a time from 0 to 1,000m in the following year.

In the implementation design (4), (A) an authorized design drawing is used as an input. The timing of the implementation design varies depending on the construction, and may be a rough design or an implementation design due to time factors.
In budget request (5) and grant application (6) for construction costs, (E) budget request management chart and (F) grant application management chart are created using (D) implementation plan as input. In the example of FIG. 6, the operations (4) and (5) are performed in the third year, and the operation (6) is performed in the fourth year.
In the contract design / implementation design (7), (D) the construction plan is used as an input, (G) the construction implementation control chart is created, the volume design (8) is performed from the place where the construction is completed, and (H) the volume A control chart is created.

  In maintenance management (9), it is customary to create a new maintenance control chart and operate the work products, but in the present invention (A), (D), (H) A composite chart is created from the drawing and used as a maintenance chart. By setting the same processing zone and work zone for each drawing by GIS, it is possible to create such a composite drawing.

  As shown on the right side of Fig. 6, in the 6th year, the section from 0 to 2,000m is composed of (H) volume design, and the section from 2,000 to 3,000m is composed of (D) implementation design, 3,000 to 7,000m A composite diagram in which the section of (A) is configured by the schematic design is created. In each work after the seventh year, it is possible to improve work efficiency by using the composite drawing as an input.

  Hereinafter, details of the present invention will be described by way of examples. The present invention is not limited in any way by this example.

FIG. 7 is a related diagram of various control charts according to the first embodiment. The lower part of Fig. 7 shows the colored parts of "I. Budget Request Management Chart", "II. Grant Application Management Chart", and "III. Construction Implementation Control Chart" used in the 2002 work. The upper part shows the colored parts of “IV. Budget Request Control Chart”, “V. Grant Application Control Chart”, and “VI. Construction Implementation Control Chart” used in the 2003 work. Has been. In these drawings, the colored portion on the line is composed of the drawings related to the detailed design, and the black portion is composed of the drawings related to the schematic design.
Drawings created in the previous year are stored on the GIS, and when working from the following year onwards, only the changes to the corresponding drawing need be updated. For example, in order to create the IV. Budget Request Management Chart for 2003, the I. Budget Request Management Chart for 2002 should be edited.

FIG. 8 is a composite diagram according to the first embodiment. In the composite diagram shown in FIG. 8, the left section of the work area is a detailed section that is associated with the detailed design data based on the detailed design, and the right section is the schematic section that is associated with the schematic design data based on the schematic design. It is.
When creating a composite drawing, in order to avoid inconsistencies between the data in the schematic design DB and the detailed design DB, the corresponding schematic design DB data is deleted in the detailed section, and the corresponding detailed design in the schematic design section. A composite DB is created by combining the deleted DB data. By using the composite drawing, it is possible to significantly reduce the man-hours in the budget request / subsidy grant application work.

System configuration diagram of the present invention Flow chart of processing procedure of the present invention Outline flow chart of design and management work in public sewer business Flow chart of conventional construction cost estimation work Flow of "budget request" and "subsidy grant application" in public sewer business Flow chart of composite drawing according to the present invention Related chart of various control charts according to the first embodiment Composition diagram according to Example 1

Explanation of symbols

2 Personal computer

Claims (3)

It is a support system for budget request and subsidy grant application in public sewer business using GIS ,
A schematic design drawing in which the processing zone and the work zone are set, and a drawing storage means for storing a detailed design drawing in which the processing zone and the work zone are set;
A schematic drawing and a detailed design drawing are read from the drawing storage means, a composite drawing in which the processing zone and the work zone are linked is created, and a composite drawing creation means for storing the composite drawing in the drawing storage means;
A composite chart is read from the drawing storage means, a plurality of control charts for each year are created from the composite chart, and a control chart creating means for storing in the drawing storage means;
Display means for displaying a control chart;
A work area selection means for selecting a work area on the created control chart,
Selected section color display means for displaying the section selected on the control chart in a different color from other sections,
Unit price storage means for storing design unit price data;
Construction cost accumulating means for accumulating the construction cost of the work area selected on the control chart based on the design unit price data read from the unit price storage means ;
Read the control chart from the drawing storage means, and on the control chart, the year work area coloring display means for coloring and displaying the work area for each year in a different color,
Equipped with a,
The control chart creation means reads a plurality of control charts from the drawing storage means, and creates a related chart in which each part of the control chart is made up of a part related to the detailed design and another part of the schematic design is colored in a different color. Support system for budget request and subsidy grant application in public sewerage business characterized by being able to do. The composite diagram drawing means reads a schematic design diagrams and detailed design drawing from a drawing memory means, according to claim 1, characterized in that by removing redundant information in more detail blueprint from schematic plan creating a composite view Support system for budget request / subsidy grant application. 3. The budget request / subsidy grant application support system according to claim 1, wherein the schematic design drawing includes an approval design drawing, and the detailed design drawing includes an execution design drawing and a volume design drawing .