JPH1150408A - Management system of civil engineering work data and computer-readable memory storing program for the system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the operability, by making a voucher model from a working kind obtained from a specified table and a prefecture name and inputting surveyed results to prepare a document for submission. SOLUTION: A structure list is graphically indicated on a display by CPU 1 in reference to a plan view table and a structural drawing table of a data base 4. Then, a selected input of the structure is checked and if there is a selected input, the working kind is decided while referring the plan view table from the selected structural drawing and then, a prefectural name is decided from the working name table of the data base 4. And a voucher model is decided from the working kind and the prefectural name and it is indicated on a display 6. And further, the surveyed result input is checked and a document for submission is made on the basis of the input information, if there is an input and printed through an output device 10. In this way, data can be easily managed and a document for submission can be easily prepared without technical knowledge. And the use efficiency of the memory constituting the data base can be increased.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data management system for civil engineering work and a computer-readable storage medium storing a program used for the system.

[0002]

2. Description of the Related Art Conventionally, management of civil construction data is manual document management. For example, a design document and various documents to be submitted for construction are bound in a single binder, and an index tag is bound together with the document so that the document can be easily removed, and the name of the document is written in this tag. Also, the name of the construction was written on the spine of the binder and placed on the bookshelf.

[0003]

However, in such manual document management, data management becomes complicated.
In addition, there is a problem in that it takes much time and further, in order to create a design document and a document to be submitted, specialized knowledge on civil engineering is required.

[0004] Therefore, the invention according to claim 1 makes it easy to manage data, and it is possible for a person who does not have specialized knowledge to create submission documents by simple work, and furthermore, the use efficiency of the storage device constituting the database. Provide a data management system for civil engineering work that can enhance

[0005] The invention according to claim 2 can easily manage data, and can prepare a document to be submitted by a simple operation even if there is no expert knowledge, and furthermore, use of a storage device constituting a database. Provided is a computer-readable storage medium storing a program for constructing a data management system for civil engineering work capable of improving efficiency.

[0006]

According to the first aspect of the present invention,
A construction name table that holds information such as the construction name, construction location, ordering party, and construction period, an index table that holds information such as program names, arguments, and browsing data. A vertical section table that holds information such as a positional relationship with a roadside structure, a plan view table that is divided for each roadside structure and holds information about the type of the structure, a section to be constructed, and the like, for each structure And a structure that stores information such as the shape of the structure and the dimensions of each part, which is divided for each development view measuring point existing therein and stores information on the height of the structure and the like, and is divided for each structure diagram. A first database with a diagram table, a second database with a structural diagram template table that is divided for each structural diagram and holds model information of the structure, and a submission document that differs depending on the type of work or prefecture A third database provided with a template table for submitting documents holding model information, a display device, an input device for inputting various data and instructions, and data input from the input device such as elevation, curve element, width and the like. When there is a longitudinal view input means that stores data by dividing it into test points in the longitudinal view table, and when there is data input such as construction type, position, starting point, end point, extension, etc. from the input device, Plan view input means for storing data separately for each structure, and when there is data input such as height, upper altitude, lower altitude, recorded altitude, and lower altitude from the input device, the development map is displayed in the development map table. A development view input means for storing data by dividing the data into points, and a means for reading out a model of the structure diagram from the structure diagram model table and displaying it on the display device when an instruction for displaying the structure diagram model is input from the input device. And this means When the dimensional data is input from the input device to the model of the displayed structure diagram, the structure diagram input means for storing the data separately for each structure diagram in the structure diagram table, and the reference point and connection from the input device. When there are data inputs such as points, horizontal distances, vertical distances, etc., when there is a cross section input means for storing data in the vertical section table divided for each inspection point, and an instruction input of a presentation template display from the input device. A means for reading out the template of the submitted document from the submitted document template table and displaying it on the display device, and for inputting the actual survey result from the input device to the template of the submitted document displayed by this means, the submitted document And a data management system for civil engineering work, comprising a means for creating and printing out a document to be submitted created by this means.

[0007] The invention according to claim 2 is a construction name table which holds information such as construction name, construction place, orderer, construction period, etc.
An index table that holds information such as program names, arguments, and browsing data; a vertical section table that holds information such as road widths and heights, and positional relationships with roadside structures that are divided for each inspection point; A plan view table that is divided for each roadside structure and holds information on the type of the structure, the section to be constructed, and the like, and is divided for each development-use measurement point that exists for each structure, and relates to the height of the structure and the like. A first database provided with a structural drawing table that holds information such as a development drawing table and a structural drawing, and holds information such as the shape of the structure and dimensions of each part; and a structure that is divided for each structural drawing. Second database having a structural drawing template table for holding the model information of the first and third data having a submitted document template table for holding the template information of the submitted document which varies depending on the type of work or prefecture. A computer-controlled civil engineering data management system that includes a source, a display device, an input device for inputting various data and instructions, and an output device for printing out the submitted documents. When there is data input such as curve element, width, etc., there is a means to store data in the vertical section table by dividing it for each inspection point, and when there is data input such as construction type, position, start point, end point, extension from input device Means to store data by dividing each roadside structure in the floor plan table, and expand to the development map table when there is data input such as height, upper altitude, lower altitude, recorded altitude, total altitude from the input device Means for storing data separately for each figure measuring point, and means for reading out a model of a structural diagram from a structural diagram template table and displaying the same on a display device when an instruction for displaying a structural diagram template is input from an input device. And this hand Means for storing data by dividing each structural diagram to do the structure diagram table input dimension data from the input device based on the display by,
When there is data input such as a reference point, a connection point, a horizontal distance, a vertical distance, etc. from the input device, a means for storing the data in the longitudinal view table for each inspection point, and an instruction to display a template of the submitted document from the input device. Means for reading out the model of the submitted document from the submitted document template table when there is an input, and displaying it on the display device, and inputting the actual survey result from the input device based on the display by this means, creates the submitted document. And a computer readable storage medium storing a program for executing the means.

[0008]

Embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram showing the configuration of the entire system, and a CPU (central processing unit) constituting a control unit main body.
1, a storage device 2 and an input / output control unit 3 are provided, and these are connected by a bus line. The storage device 2 is provided with a database 4. The input / output control unit 3 is connected with an input device 5 for inputting various data and instructions, a display device 6, and an output device 7 for performing print output of a submission document and the like.

As shown in FIG. 2, the database 4 includes first databases 81, 82,..., 8n which hold information on specific works of the works (1), (2),.
It comprises a second database 9 for holding the shape of the structure and a third database 10 for holding the submission document format for each prefecture.

[0010] Each of the first databases 81 to 8n includes:
As shown in FIG. 3, respectively, the construction name table 111,
Index table 112 divided for each index (1) to (n), inspection points (positions used as reference for construction and surveying)
(1) to (n) are divided into vertical section tables 113, roadside structures (1) to (n) are divided into plan view tables 11
4. It has a developed view table 115 which is divided as a developed view of the structures (1) to (n) and a structural view table 116 which is divided for each of the structural views (1) to (n).

As shown in FIG. 4, the construction name table 111 holds construction name, construction place (prefecture), orderer, traffic class, site agent, chief engineer, and construction period information. . As shown in FIG. 5, the indexes (1) to (n) of the index table 112 respectively include:
Information on the program name, arguments, and browsing data is stored.

Each inspection point (1) in the vertical section table 113
As shown in FIG. 6, there are road heights, curve elements, widths, reference points, connection points, horizontal distances, vertical distances of road widths and heights, and roadside structures, respectively, as shown in FIG. Information on the positional relationship and the like is stored. The plan view table 1
As shown in FIG. 7, each of the 14 structures (1) to (n) holds information on the type of construction, position, starting point, end point, type of extended structure, section to be constructed, and the like. .

Each structure (1) in the development view table 115
As shown in FIG. 8, the development views of (n) to (n) are measurement points for development views (where the relative position from the inspection point is the measurement point).
As shown in FIG. 9, each of the development map measuring points (1) to (n) has a height, an upper elevation, a lower elevation, a calculated elevation, Information about the height of the structure at the elevation is stored. Each of the structural diagrams (1) to (n) of the structural diagram table 116 holds information on the shape of the structure, dimensions of each part, and the like. The design document submitted by the ordering party, the survey result submitted by the contractor, and the like are managed based on the inspection points or relative distances from the inspection points.

The second database 9 is provided with a structural diagram template table, and the structural diagram template table is designed to hold model information of structures classified for each structural diagram. I have. Then, the actual size information is input to the model information of the structure to form a structural diagram table.

The third database 10 is provided with a submission document template table, and this table stores submission document template information that is different for each type of work or prefecture and is classified for each submission document template. By inputting the information of the survey result and the like while reading and displaying the stored submission document template information, a submission document to the orderer is created.

The input device 5 includes a keyboard, a mouse, and the like. Various data are input by the keyboard, and the contents displayed on the display device 6 are moved by a mouse or the like to click or double-click. Various instructions are input.
The instruction input by a mouse or the like is performed, for example, on a book menu screen displayed by a book menu program. On this screen, an internal image of the civil engineering office is first graphically displayed. In this graphic display, a plurality of binders with the construction name on the spine are displayed side by side on the bookshelf, and when this binder is selected with a mouse or the like, the screen switches, and the screen opens with the selected binder opened, and the index is displayed. Is displayed. The index contains the names of various submissions.

When an index is selected with a mouse or the like, a program for creating or editing the selected document is started. The program to be started includes a design document input program for inputting a floor plan, an exploded view, a structural drawing, a cross-sectional view, a longitudinal section, and the like, and a submission document creation program for creating a submission document. be able to. Further, depending on the selection method, only the contents of the document can be browsed.

FIG. 10 is a flowchart showing a book menu process performed by the CPU 1. First, in S1, a directory of the construction (1) to (n) database, which is the first database, is searched and found on the display device 6. A binder with the construction name in the construction database as the spine is displayed on the bookshelf in the book menu as a graphic screen. Then, S
In step 2, it is checked whether or not a binder is selected. If the binder is selected by clicking the mouse, information is read from the index table 112 of the selected construction and the index is displayed on the display device 6 in step S3. Then, S4
In step S5, it is checked whether or not an index has been selected. If an index has been selected, a start program is determined in step S5 by referring to the corresponding index table 112, and the program is started.

FIG. 11 is a flow chart showing a vertical section input process in the design document input program executed by the CPU 1.
In step S12, it is checked whether or not the inspection point has been registered. If the inspection point has been registered, in S12, numbering is performed according to the position of the inspection point. The number of inspection points registered here is the number of records in the vertical section table 113.

In this state, in S13, data input such as elevation, curve element, width and the like is checked.
Set the data in 13.

FIG. 12 is a flowchart showing a plan view input process in the design document input program executed by the CPU 1.
At 21, it is checked whether or not there is input of construction type, position, starting point, end point, and extension data. If there is data input, at S22, the structures are numbered in the order of input, and planes are arranged in the order of the number of the structure. Data is set in the figure table 114.

FIG. 13 is a flow chart showing the structure diagram input processing in the design document input program executed by the CPU 1. First, FIG.
At 31, it is checked whether or not to divert an existing structural drawing. If the existing structural drawing is to be diverted, at S32 the second
Refer to the structural diagram template table, which is the database of
A list of the held CAD data is graphically displayed. Thus, the user selects a structure from the list.

In step S33, it is checked whether or not a model has been selected. If a model has been selected, in step S34, dimensions are input to the model of the structural drawing, and a structural drawing is created. At this time, data is set in the structural diagram data in the order of the numbers of the structures.

If the existing structural drawing is not to be used, that is, if a new structural drawing is to be created, the CA
Start the D program and create a model of the structure diagram. The template of the structural drawing created here is reflected on the structural drawing template table, and can be referred to in other works.

FIG. 14 is a flowchart showing the cross-sectional view input processing in the design document input program executed by the CPU 1.
At 41, the presence / absence of data input such as a reference point, a connection point, a horizontal distance, a vertical distance, etc. is checked for each inspection point. Set data in the order of numbers.

FIG. 15 is a flow chart showing the completed form creation process in the submission document creation program executed by the CPU 1. First, in S51, a list of structures is displayed by referring to the plan view table 114 and the structure view table 116. 6 is displayed graphically. Subsequently, in S52, the selection input of the structure is checked. If there is a selection input, in S53, the construction type is determined from the selected structural drawing by referring to the plan view table 114.

Subsequently, in S54, the construction name table 11
From 1, determine the prefecture. Subsequently, in S55, a form template is determined according to the type of work and the prefecture, and is displayed on the display device 6. Then, in S56, the input of the survey result is checked, and if there is an input of the survey result, in S57,
Complete the submission based on the input information. The completed submission document can be printed out by the output device 7.

In such a configuration, first, on the book menu screen on which the internal image of the civil engineering office is graphically displayed on the display device 6, a relevant binder is selected from the binders arranged on the bookshelf with the mouse. , The screen of the display device 6 is switched to the index display screen. In this state, when a corresponding index is selected by a selection operation using a mouse, a corresponding program is started, and creation and editing of a document can be performed. For example, a plan view,
When an index for inputting a design document such as a development diagram, a structural diagram, a cross-sectional view, or a vertical section is selected, a corresponding design document input program is started. Also, if the user selects an index for preparing a submission document, a corresponding submission document creation program is activated.

For example, when a program for inputting a longitudinal section is started, by registering inspection points, numbering is performed according to the positions of the registered inspection points. Then, by inputting data such as the altitude, the curve element, and the width, the data is set in the longitudinal view table 113 in the order of the number of the inspection point. In this way, data setting for the vertical section table 113 can be simplified. When the program for inputting the floor plan is started, the structures are numbered by inputting data such as the type of work, the position, the starting point, the end point, the extension, and the like. The corresponding data is set. In this way, data setting for the plan view table 114 can be simplified.

When the program for inputting the structure diagram is started, the processing is determined depending on whether or not to use the existing structure diagram. When the existing structure diagram is used, a list of CAD data, which is model information of the structure stored in the structure diagram template table of the second database 9, is first displayed on the display device 6. In this state, the model of the corresponding structure is selected with the mouse, and further, the dimension data is key-inputted to the model of the selected structural diagram, whereby the structural diagram can be easily created. Also, when creating a new structural drawing,
First, a CAD program is activated to create a model of a structural diagram. Then, by inputting the dimension data into the template of the created structure drawing, a structure drawing can be easily created.

When a program for inputting a cross-sectional view is started, data such as a reference point, a connection point, a horizontal distance, a vertical distance, and the like are input by a key for each inspection point, so that the vertical view table 1 is input.
Data is set to 13 in the order of the inspection point numbers. In this way, data setting for the vertical section table 113 can be simplified.

In addition, a submission document creation program is started,
For example, when preparing a completed form, first, a list of structures is graphically displayed on the display device 6 with reference to the plan view table 114 and the structural view table 116. When a structure is selected with the mouse, the type of construction is determined by referring to the plan view table 114 based on the selected structural drawing, and the prefecture is determined by the construction name table 111. Then, the template of the form is determined based on the determined type of work and prefecture, and is displayed on the display device 6.

In this state, when data of a survey result is input, a completed form document is created based on the input data. Then, the created completed form is printed out by the output device 7. In this way, a person who has no specialized knowledge can create a document to be submitted by a simple operation of inputting data in a predetermined order.

In this case, as an example of the preparation of the submission documents, the creation of a completed form has been described as an example. However, the types of the submission documents vary widely depending on the type of work and the prefecture. Therefore, in this embodiment, it is possible to easily cope with the creation of a wide variety of submission documents by preparing the template information of a large number of submission documents of the types of works and prefectures in the third database. . Then, only by inputting the data of the result of the survey for the template of the submission document, the actual submission document can be easily created, and the submission document can be created in a short time.

All necessary data of each document is stored in various tables of a database. When a document is created, necessary data may be sequentially read from each table to perform a predetermined data input operation. Data management is easier than management. Since the documents can be arranged in the book menu screen, the documents can be easily managed for each construction and the space can be saved.

Also, as a database, a construction name table 111, an index table 112, a vertical section table 113, a plan view table 114, a development view table 11
A first database 81 to 8n for storing specific construction information, and a second database 9 having a structural diagram template table for retaining model information of structures. The construction database of the first database is divided into three databases, each of which has a submission database template table that holds template information of submission documents that differ depending on the type of work or prefecture. The second,
The template information table held by the third database can be used in common for each construction, so that there is no need to provide a template information table for each construction, thereby improving the use efficiency of the storage device forming the database. Can be.

Further, since the structure database 9 for holding the model information of the structural drawing is made independent of the construction databases 81 to 8n, the structural drawing data created in one construction can be used in another construction. Versatility can be enhanced. Further, since the database is divided by the optimum keys of the inspection points and the structures, it is possible to promptly cope with the case where the data is referenced or changed.

[0038]

According to the first aspect of the present invention, data can be easily managed, and a document to be submitted can be created by a person who does not have specialized knowledge by a simple operation. It is possible to provide a data management system for civil engineering work that can increase the use efficiency of construction.

According to the second aspect of the present invention, data can be easily managed, and a document to be submitted can be created by a person who has no specialized knowledge by a simple operation. And a computer-readable storage medium storing a program for constructing a data management system for civil engineering work capable of improving the use efficiency of the computer.

[Brief description of the drawings]

FIG. 1 is a block diagram of an entire system showing an embodiment of the present invention.

FIG. 2 is a diagram showing a configuration of a database in the embodiment.

FIG. 3 is a diagram showing a configuration of a first database in the embodiment.

FIG. 4 is a diagram showing a configuration of a construction name table in a first database.

FIG. 5 is a diagram showing a configuration of an index table in the first database.

FIG. 6 is a diagram showing a configuration of a vertical section table in a first database.

FIG. 7 is a diagram showing a configuration of a plan view table in a first database.

FIG. 8 is a view showing a configuration of a development view table in the first database.

9 is a diagram showing a configuration of each development view measurement point in the development view table of FIG. 8;

FIG. 10 is a flowchart showing book menu processing by the CPU according to the embodiment;

FIG. 11 is a flowchart showing longitudinal section input processing by the CPU according to the embodiment;

FIG. 12 is a flowchart showing a plan view input process by the CPU of the embodiment.

FIG. 13 is a flowchart showing a structure diagram input process by the CPU according to the embodiment;

FIG. 14 is a flowchart showing cross-sectional view input processing by the CPU according to the embodiment;

FIG. 15 is a flowchart showing a work result form creation process by the CPU according to the embodiment;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... CPU (Central processing unit) 4 ... Database 5 ... Input device 6 ... Display device 7 ... Output device 81-8n ... Construction database (1st database) 9 ... Structure database (2nd database) 10 ... Submission documents Database (third database)

Claims (2)

[Claims] A construction name table for storing information such as construction name, construction place, ordering party, and construction period; an index table for retaining information such as program names, arguments, and browsing data;
A vertical section table that is divided by inspection points and holds information such as the width and height of the road, the positional relationship with the roadside structure, etc., the type of structure, the section to be constructed that is divided by each roadside structure A plan view table that holds information about the structures, etc., is divided for each development view measuring point that exists for each structure, and a development view table that holds information about the heights of the structures and the like, and divided for each structure diagram. A first database provided with a structural diagram table that holds information such as the shape of each part and dimensions of each part, and a second database provided with a structural diagram template table that is divided for each structural diagram and holds model information of a structure. And a third database having a submission document template table for holding template information of submission documents that differ depending on the type of work or prefecture, a display device, an input device for inputting various data and instructions, and the like. Input device When there is data input such as elevation, curve element, width, etc., a vertical section input means for storing data in the vertical section table for each inspection point, and a work type, position, starting point, end point, extension from the input device. When there is data input such as, a plan view input means for storing data in the plan view table for each roadside structure separately, and a height, an upper elevation, a lower elevation, a recorded elevation, and a total elevation from the input device. And the like. When there is a data input such as, for example, a development view input means for storing data by dividing the development view table for each development view measurement point, Means for reading the model of the structural drawing from the model table and displaying it on the display device; and inputting dimensional data from the input device to the model of the structural diagram displayed by the means, the structure diagram table To structural drawing A structural diagram input means for storing data by dividing the data into reference points, connection points, horizontal distances, vertical distances, etc. from the input device; Means for reading a submitted document template from the input document template table and displaying the submitted document template on the display device when the instruction input for displaying the submitted document template is input from the input device. Means for creating a submitted document when an actual survey result is input from the input device with respect to the template of the submitted document displayed by the above, and an output device for printing out the submitted document created by this means. A data management system for civil engineering work. 2. A construction name table for retaining information such as construction name, construction place, ordering party, construction period, and an index table for retaining information such as program names, arguments, browsing data, and the like.
A vertical section table that is divided by inspection points and holds information such as the width and height of the road, the positional relationship with the roadside structure, etc., the type of structure, the section to be constructed that is divided by each roadside structure A plan view table that holds information about the structures, etc., is divided for each development view measuring point that exists for each structure, and a development view table that holds information about the heights of the structures and the like, and divided for each structure diagram. A first database provided with a structural diagram table that holds information such as the shape of each part and dimensions of each part, and a second database provided with a structural diagram template table that is divided for each structural diagram and holds model information of a structure. A database, a third database having a submission document template table holding template information of submission documents that differ depending on the type of work or prefecture, a display device, an input device for inputting various data and instructions, and submission. Documents For a computer-controlled civil engineering data management system having an output device for printing out, when there is data input from the input device such as elevation, curve element, width, etc., the profile table is provided for each inspection point. Means for storing data in a divided manner; means for storing data separately for each roadside structure in the plan view table when there is data input such as construction type, position, starting point, end point, and extension from the input device. Means for storing data by dividing the data into the development map table for each development measurement point when there is data input such as height, upper elevation, lower elevation, calculated elevation, and total elevation from the input device; Means for reading a structure diagram template from the structure diagram model table when there is an instruction input of a structure diagram model display from an input device, and displaying the model on the display device; and Means for storing dimension data for each structural diagram in the structural diagram table when the dimension data is input from; and when there is data input such as a reference point, a connection point, a horizontal distance, and a vertical distance from the input device, Means for storing data in the longitudinal section table by classifying each inspection point, and when there is an instruction input of display of a submitted document template from the input device, reads a template of the submitted document from the submitted document template table and reads the template. A computer-readable storage storing a program for executing a means for displaying on a display device, and a means for creating a document to be submitted when an actual survey result is input from the input device based on the display by the means; Medium.