CN116882826B - Highway engineering quality management system and method based on Internet of things - Google Patents
Highway engineering quality management system and method based on Internet of things Download PDFInfo
- Publication number
- CN116882826B CN116882826B CN202310864805.XA CN202310864805A CN116882826B CN 116882826 B CN116882826 B CN 116882826B CN 202310864805 A CN202310864805 A CN 202310864805A CN 116882826 B CN116882826 B CN 116882826B
- Authority
- CN
- China
- Prior art keywords
- data
- equipment
- mixing station
- universal
- data source
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000003326 Quality management system Methods 0.000 title claims abstract description 17
- 238000002156 mixing Methods 0.000 claims abstract description 83
- 239000010426 asphalt Substances 0.000 claims abstract description 46
- 238000012360 testing method Methods 0.000 claims abstract description 36
- 238000004519 manufacturing process Methods 0.000 claims abstract description 28
- 238000007405 data analysis Methods 0.000 claims abstract description 4
- 238000003466 welding Methods 0.000 claims description 24
- 238000012544 monitoring process Methods 0.000 claims description 21
- 238000007726 management method Methods 0.000 claims description 19
- 238000010276 construction Methods 0.000 claims description 17
- 229910000831 Steel Inorganic materials 0.000 claims description 14
- 239000010959 steel Substances 0.000 claims description 14
- 239000004568 cement Substances 0.000 claims description 12
- 238000004458 analytical method Methods 0.000 claims description 10
- 238000003756 stirring Methods 0.000 claims description 10
- 239000000203 mixture Substances 0.000 claims description 9
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 9
- 239000003973 paint Substances 0.000 claims description 8
- 230000008569 process Effects 0.000 claims description 7
- 238000005488 sandblasting Methods 0.000 claims description 7
- 238000005507 spraying Methods 0.000 claims description 7
- 230000005540 biological transmission Effects 0.000 claims description 5
- 230000035515 penetration Effects 0.000 claims description 4
- 238000007619 statistical method Methods 0.000 claims description 4
- 238000005096 rolling process Methods 0.000 claims description 3
- 239000011083 cement mortar Substances 0.000 claims description 2
- 239000004567 concrete Substances 0.000 claims description 2
- 238000009864 tensile test Methods 0.000 claims description 2
- 229910001294 Reinforcing steel Inorganic materials 0.000 claims 1
- 238000002485 combustion reaction Methods 0.000 claims 1
- 230000006641 stabilisation Effects 0.000 claims 1
- 238000011105 stabilization Methods 0.000 claims 1
- 230000007246 mechanism Effects 0.000 abstract description 2
- 238000005516 engineering process Methods 0.000 description 10
- 239000000463 material Substances 0.000 description 7
- 230000006855 networking Effects 0.000 description 6
- 238000012937 correction Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 239000007788 liquid Substances 0.000 description 4
- 238000003860 storage Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000007599 discharging Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000006835 compression Effects 0.000 description 2
- 238000007906 compression Methods 0.000 description 2
- 238000013523 data management Methods 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012800 visualization Methods 0.000 description 2
- 241000876443 Varanus salvator Species 0.000 description 1
- 238000007792 addition Methods 0.000 description 1
- 230000004888 barrier function Effects 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000012669 compression test Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 239000000428 dust Substances 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 238000002474 experimental method Methods 0.000 description 1
- 238000010438 heat treatment Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000009533 lab test Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 239000004570 mortar (masonry) Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000001303 quality assessment method Methods 0.000 description 1
- 239000002994 raw material Substances 0.000 description 1
- 230000000391 smoking effect Effects 0.000 description 1
- 239000007921 spray Substances 0.000 description 1
- 238000007592 spray painting technique Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000008961 swelling Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06395—Quality analysis or management
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01D—MEASURING NOT SPECIALLY ADAPTED FOR A SPECIFIC VARIABLE; ARRANGEMENTS FOR MEASURING TWO OR MORE VARIABLES NOT COVERED IN A SINGLE OTHER SUBCLASS; TARIFF METERING APPARATUS; MEASURING OR TESTING NOT OTHERWISE PROVIDED FOR
- G01D21/00—Measuring or testing not otherwise provided for
- G01D21/02—Measuring two or more variables by means not covered by a single other subclass
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/26—Government or public services
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V20/00—Scenes; Scene-specific elements
- G06V20/50—Context or environment of the image
- G06V20/52—Surveillance or monitoring of activities, e.g. for recognising suspicious objects
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Tourism & Hospitality (AREA)
- Educational Administration (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Game Theory and Decision Science (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Multimedia (AREA)
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a highway engineering quality management system and method based on the Internet of things, which belong to the technical field of highway engineering and comprise the following steps: respectively creating universal data source templates of the universal machine, the press and the mixing station equipment according to the universal machine database mechanism, the asphalt index database structure and the mixing station database structure; integrating the universal data source template into laboratory and mixing station equipment software, and writing test data and mixing station production data into the universal data source; deploying an acquisition client, selecting a universal data source in the acquisition client, and acquiring and synchronizing test data and mixing station production data; and visually displaying the test data and the mixing station production data by using a data analysis tool. The method realizes a cross-database platform, so that the speed of accessing the database is faster, the functionality is stronger, the application of the spatial data is more flexible, and the problems that the acquisition client cannot be compatible and the data cannot be integrated are solved.
Description
Technical Field
The invention belongs to the technical field of highway engineering, and particularly relates to a highway engineering quality management system and method based on the Internet of things.
Background
The construction of expressways relates to projects such as roadbeds, pavements, bridges and tunnels, the quality of the project construction determines the level of the whole highway project construction, and in order to improve the quality of the highway project construction, a highway project quality management system capable of monitoring indexes such as roadbed firmness, pavement thickness flatness, steel box girder firmness and the like through the technology of the Internet of things is needed.
The following two problems generally exist in the conventional highway engineering quality management system for monitoring on-site management equipment: firstly, the singlechip cannot monitor through networking, can only perform data acquisition in a single test machine and mixing station equipment, and cannot interconnect and communicate data of various on-site sensors, GPS (global positioning system) locators, RFID (radio frequency identification) and other Internet of things equipment, so that the networking monitoring cannot be realized; secondly, different test software of a testing machine and intelligent control software of mixing station equipment exist in equipment of different manufacturers, compatible collection cannot be achieved, in the construction of a laboratory and the mixing station, manufacturers of purchased universal machines, presses, mixing station equipment and the like are different, the test software of the equipment is different from the intelligent control software of the mixing station equipment, and a set of data collection client-side is not capable of being matched with the test software and the intelligent control software of the mixing station at the same time.
The invention discloses a highway engineering quality management informatization system based on a cloud platform, which is characterized in that networking integrated software, data acquisition equipment, pavement construction monitoring equipment and remote video monitoring integrated equipment are connected together by using the cloud platform to realize collaborative management. However, the method cannot solve the problem that the acquisition clients cannot be compatible due to different equipment manufacturers; the problem that data of various sensors and GPS locators cannot be integrated on site is not solved.
Disclosure of Invention
In order to solve the technical problems that the acquisition clients cannot be compatible due to different equipment manufacturers and the data of various sensors and GPS positioners cannot be integrated in the field in the background technology, the invention provides a highway engineering quality management method based on the Internet of things, which comprises the following steps:
respectively creating universal data source templates of the universal machine, the press and the mixing station equipment according to the universal machine database mechanism, the asphalt index database structure and the mixing station database structure;
Integrating the universal data source template into laboratory and mixing station equipment software, and writing test data and mixing station production data into the universal data source;
Deploying an acquisition client, selecting a universal data source in the acquisition client, and acquiring and synchronizing test data and mixing station production data;
And visually displaying the test data and the mixing station production data by using a data analysis tool.
Further, the method integrates the universal data source template into the equipment software of the laboratory and the mixing station, and writes test data and mixing station production data into the universal data source, and specifically comprises the following steps:
Renaming the universal data source template to be Database Common.mdb, and placing the renamed data source template file under a device software data directory;
The device data is written to the databaseCommon. Mdb file in real time according to the structural specification document of the generic data source template.
Further, the method comprises the steps of selecting a universal data source in the acquisition client, acquiring and synchronizing test data and mixing station production data, and specifically comprising the following steps:
Starting an acquisition client, selecting corresponding equipment, and selecting corresponding equipment to select a corresponding equipment data universal data source template;
Selecting a databaseCommon.mdb file as a data source path;
Automatically collecting and synchronizing data to a data processing center.
Further, the general data source is a relational database, and the relational database is combined with a spatial database engine to manage data.
Further, the relational database manages attribute data tables in the data, and the spatial database engine organizes spatial data in the management data.
The invention also provides a highway engineering quality management system based on the Internet of things, which executes the highway engineering quality management method based on the Internet of things, and comprises the following steps:
gather customer end, data processing center, thing networking equipment server and database server, website server and user terminal, gather the customer end and be connected with laboratory equipment and mixing station, wherein:
the laboratory equipment comprises a universal machine, a press, a curing box and asphalt index equipment;
the mixing station comprises a cement mixing station, a water-stable mixing station and an asphalt mixing station;
The internet of things equipment server is connected with the internet of things equipment, and the internet of things equipment comprises: road surface management and control equipment, steel box girder automatic welding robots, environment-friendly water conservation equipment, tensioning grouting equipment, intelligent tunnel equipment and modified asphalt are production and transportation equipment, pile machine equipment and laboratory video monitoring equipment.
Furthermore, the acquisition client is embedded into the microcomputer of the laboratory and mixing station equipment, and simultaneously acquires and synchronizes real-time data of the laboratory equipment and the mixing station equipment.
Further, the data processing center performs statistical analysis and early warning judgment on data transmitted back by the acquisition client and the Internet of things equipment, so as to generate equipment state data, statistical data and early warning information.
Further, the pile machine equipment comprises a pipe pile and a stirring pile, and depth, flow, pressure, density, current, verticality and time in the construction process of the pipe pile and the stirring pile are automatically uploaded to a data processing center through a flow sensor, an inclination sensor, a depth sensor and a current sensor, and then a data report of the pipe pile and the stirring pile and early warning information are generated through judgment and analysis.
Further, steel box girder automatic weld robot includes sandblast robot, spray painting robot, diaphragm welding robot, roof U intra-rib welding machine ware people, bottom plate U inter-rib welding robot and roof U inter-rib welding robot, installs temperature and humidity sensor in the robot, flow pressure sensor and current voltage sensor for gather the sand blasting atmospheric pressure, the flow of spraying paint, operating speed, temperature, humidity, electric current, the index value of voltage, through judging whether the index value is in the within range of regulation, realize the control to steel box girder sandblast, spray paint and welding quality.
The invention has the beneficial effects that:
According to the highway engineering quality management method based on the Internet of things, the universal data source templates of the universal machine, the press machine and the mixing station equipment are created, the relational database is used as a data container, the data is managed by combining the spatial database engine, and the spatial database engine is used as a conversion tool for data to enter and exit the relational database, so that a cross-database platform is realized, the speed of accessing the database is higher, the functionality is stronger, and the application of the spatial data is more flexible.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of method steps of a highway engineering quality management method based on the Internet of things;
fig. 2 is a functional block diagram of the highway engineering quality management system based on the internet of things.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The application provides a highway engineering quality management system based on the Internet of things, which is characterized in that the informatization of highway engineering construction equipment is enhanced, the data barriers among the equipment are opened, the data interconnection and intercommunication are realized, the information such as equipment state and early warning is fed back to clients in real time in a short message and micro-message public number mode, and the data acquisition method of the novel highway engineering quality management system is convenient for users to butt against the data of equipment of different manufacturers, and has the effects of realizing one-time development, multiple general purposes, simplifying operation and improving the data acquisition efficiency.
As shown in fig. 2, the highway engineering quality management system based on the internet of things comprises an acquisition client, a data processing center, an internet of things equipment server, a database server, a site server and a user terminal, wherein the acquisition client is connected with laboratory equipment and a mixing station, and the highway engineering quality management system comprises the following components:
the laboratory equipment comprises a universal machine, a press, a curing box and asphalt index equipment;
the mixing station comprises a cement mixing station, a water-stable mixing station and an asphalt mixing station;
The internet of things equipment server is connected with the internet of things equipment, and the internet of things equipment comprises: road surface management and control equipment, steel box girder automatic welding robots, environment-friendly water conservation equipment, tensioning grouting equipment, intelligent tunnel equipment and modified asphalt are production and transportation equipment, pile machine equipment and laboratory video monitoring equipment.
The real-time data in the laboratory and the mixing station equipment are collected and synchronized simultaneously by embedding the collecting client into the equipment microcomputer of the laboratory and the mixing station.
Further, in a preferred embodiment of the application, the technologies of 5G technology, radio frequency identification technology, sensor technology, global positioning technology, intelligent embedding and the like are adopted to orderly connect and integrate a transport vehicle, a paver, a road roller, an automatic welding robot, an environment-friendly water monitor, a tensioning grouting controller, a tunnel personnel and vehicle, a modified asphalt production controller and transport vehicle, a pipe pile and stirring pile monitor and a laboratory video monitor, so that data interconnection and intercommunication are realized.
And aiming at the data transmitted back by the acquisition client and the Internet of things equipment, generating equipment state data, statistical data and early warning information through statistical analysis and early warning judgment, and further storing the data into a database.
The user terminal comprises a mobile phone, a PC and a large screen end, and can display the running states, the production data, the statistical data and the early warning information of various highway engineering construction equipment.
Further, in an embodiment of the present application, the laboratory device, the mixing station device, and the collection terminal include a universal machine, a press, a curing box, and an asphalt indicator device in a laboratory, where the laboratory device specifically further includes: asphalt penetration gauge, asphalt softening point gauge, asphalt ductility gauge, marshall stability gauge, asphalt mixture burner, asphalt mixture rut gauge and geosynthetic material tester;
The mixing station equipment is divided into an asphalt mixer, a cement mixer and a water-stable mixer; the acquisition client is independently developed acquisition software, so that unattended operation is realized, real-time equipment data is automatically acquired and transmitted to the data processing center in real time, and the functions of one-time deployment and subsequent automatic upgrading are realized.
Further, in the embodiment of the application, the internet of things equipment and data transmission comprise pavement management and control equipment, a steel box girder automatic welding robot, environment-friendly water conservation equipment, stretching grouting equipment, intelligent tunnel equipment, modified asphalt production and transportation equipment, pile machine equipment and laboratory video monitoring equipment.
In order to realize the control of mixing station equipment, in the embodiment of the application, a temperature sensor is arranged on a discharge hole of a mixing machine, an RFID tag and a GPS (global positioning system) locator are arranged on a mixing material transport vehicle, and an infrared temperature sensor, a speed sensor and the GPS locator are arranged on a paver and a road roller.
The RFID tag can record the time for starting the material receiving of the mixing material transport vehicle and the time for reaching the paving site; the temperature of the discharge port of the mixer and the temperature of the mixture on the road surface when the paver is used for paving and the temperature of the mixture on the road surface when the road roller is used can be acquired in real time through the infrared temperature sensor; the running speeds of the paver and the road roller can be obtained through the speed sensor. The GPS localizer is used for recording real-time coordinates of the transport vehicle, the paver and the road roller, generating a track of the transport vehicle, judging whether the transport vehicle is yawed or not, generating a running track of the paver and the road roller, drawing a paving and rolling route and calculating the rolling times.
Further, in the embodiment of the application, the automatic welding robot for the steel box girder is divided into a sand blasting robot, a paint spraying robot, a diaphragm welding robot, a top plate U-rib inner welding robot, a bottom plate U-rib outer welding robot and a top plate U-rib outer welding robot. The robot is internally provided with a temperature and humidity sensor, a flow pressure sensor and a current and voltage sensor, and is used for collecting index values such as sand blasting air pressure, paint spraying flow, running speed, temperature, humidity, current, voltage and the like, and monitoring on the sand blasting, paint spraying and welding quality of the steel box girder is realized by judging whether the index values are in a specified range.
The environment-friendly water-protecting equipment comprises environment monitoring equipment and water quality monitoring equipment. The environmental monitoring equipment transmits the PM2.5, PM10, dust TSP, noise, temperature, wind speed, wind force and air pressure values to the data processing center through the sensor. The water quality monitoring equipment uploads the PH value and NTU turbidity value of the water body in real time through the sensor, and analyzes and judges the uploaded index value in the data processing center.
The tensioning grouting equipment comprises beam tensioning monitoring equipment and beam grouting monitoring equipment, and performs real-time data acquisition on the intelligent tensioning grouting process through a GPRS wireless communication technology, a sensing technology and a computer network technology, so that intelligent control, dynamic acceptance, timely remedy and the like of tensioning grouting construction quality management are achieved, and construction quality and equipment safety are ensured.
The intelligent tunnel associated devices include intelligent helmets, base stations, personnel and vehicle RFID tags, and the like. Recording the time of entering and exiting the tunnel by personnel and vehicle RFID tags; by arranging the base station in the tunnel, the full coverage of the wireless network in the tunnel and the data transmission in the tunnel are realized; through being equipped with location formula intelligent safety helmet, gather tunnel constructor's real-time position, realize position control and danger early warning.
The modified asphalt production and transportation equipment comprises: modified asphalt production equipment and modified asphalt transportation vehicles. Acquiring the temperatures in the asphalt swelling tank and the asphalt finished product tank in real time through a temperature sensor; monitoring the liquid level before discharging and the liquid level after discharging through a liquid level sensor, thereby obtaining the liquid level height of each discharging; meanwhile, the feeding start time, the feeding end time and the transportation track of the transportation vehicle can be acquired through the RFID tag and the GPS positioner which are arranged on the modified asphalt transportation vehicle, so that the real-time monitoring of the transportation vehicle track is realized.
The pile machine equipment comprises a pipe pile and a stirring pile, and parameters such as depth, flow, pressure, density, current, verticality, time and the like in the construction process of the pipe pile and the stirring pile are automatically uploaded to a data processing center through a flow sensor, an inclination sensor, a depth sensor and a current sensor, and then a data report of the pipe pile and the stirring pile and early warning information are generated through judgment and analysis.
The laboratory video monitoring equipment is a camera and data transmission equipment which are arranged in a laboratory of a highway engineering construction site, and can realize snapshot and video recording of a test process through the Internet, identify dangerous behaviors such as smoking in the laboratory, not wearing a safety helmet and the like, and send out early warning.
Furthermore, the data processing center disclosed by the application can receive the data submitted by the acquisition client and the Internet of things equipment and can also return the information requested by the acquisition client. Through gathering customer end and thing networking equipment, can be with laboratory, mixing station and various thing networking data, according to the interval time that sets for, upload data processing center automatically to in data processing center, through statistics, analysis judges, obtain equipment state, production, statistics data, and early warning information, finally demonstrate in user's cell-phone, PC computer or large screen end. Meanwhile, when the acquisition client executes user login, a piece of login request data is sent to the data processing center, the data processing center verifies login information, a message of success or failure of login is returned to the acquisition client, and if the login is successful, information of items, standard segments, laboratories, equipment types, equipment names and the like associated with the user is returned.
Further, in a preferred embodiment of the present application, the user terminal includes a mobile phone, a PC computer, and a large screen terminal. The user can view the integrated interface of the laboratory test data and the test process video at the terminal by viewing the test data, mixing the production data, various Internet of things equipment data and video monitoring data in real time and view the early warning information on the mobile phone in a short message and WeChat public number mode.
Further, in the embodiment of the present application, the general data source is a relational database, and the relational database manages data in combination with a spatial database engine (SpatialDatabaseEngine, abbreviated as SDE). The attribute data table is managed by a conventional relational database, and the spatial data is organized independently of SDEs outside the database. When the user needs to access the data, the system recalls the SDE to take the data from the relational database, and the data is converted and provided for the user to use. For spatial data, the relational database is a container, and the SDE is a translation tool into and out of the container.
A spatial database engine is a database engine that processes spatial data. The method can perform operations such as storage inquiry, analysis and visualization on the space data, and provides corresponding tools and methods. The spatial database engine typically includes the functionality of:
spatial data storage: the spatial data may be stored in the database in the form of spatial objects. The spatial object may be a geographic element such as a point, line, plane, or a more complex map, layer, or the like.
Spatial data query: various types of queries may be performed on spatial data in the database, such as range queries, distance queries, attribute queries, and the like. The query result may be the space object itself, or a corresponding map, layer, or the like.
And (3) spatial data analysis: various analysis operations such as space statistical analysis, space interpolation analysis and the like can be carried out on the space data, and analysis results can be used for making decisions in the aspects of engineering planning, ecological environment protection and the like.
Visualization of spatial data: the spatial data can be visually displayed in the form of a map, a layer and the like, so that a user is helped to better understand and use the spatial data. The visual presentation may employ a generic map service, such as GoogleMaps, baiduMaps, etc.
Spatial data management: spatial data in the database can be managed, including data import, data backup, data update, data maintenance, and the like. Meanwhile, the authority of the data can be managed and limited, and the access and modification authorities of different users to the space data can be limited.
Specifically, the overall working principle of the highway engineering quality management system based on the Internet of things is as follows:
The highway engineering quality management system integrates the acquisition client and various highway engineering construction Internet of things equipment, gathers the data automatically acquired by the acquisition client and the data transmitted by the Internet of things equipment such as a sensor, a GPS (global positioning system) locator, an RFID (radio frequency identification) tag and the like, and performs statistic analysis, calculation and judgment on the gathered data in a centralized manner through a data processing center to obtain information such as a statistic report, production data, early warning and the like, and stores the information in a database server. The internet of things equipment server is a bridge between the internet of things equipment and the data processing center, collects various equipment data of the internet of things, transmits the data to the data processing center, and achieves interconnection and intercommunication between the internet of things equipment with different interfaces of various different types and the data processing center. The acquisition client is used for acquiring experimental data of a universal machine, a press, a curing box, asphalt penetration, asphalt ductility, asphalt softening point, asphalt mixture rutting, an asphalt mixture heating furnace, marshall stability and geosynthetic material experiments in a laboratory, and mixing production data of a cement mixing station, a water stability mixing station and an asphalt mixing station. And then the data processing center gathers the data collected by the equipment server and the collecting client of the Internet of things, the data gathered and processed by the data processing center is stored by the database server, and then the data in the database server and the classification function module are processed by the site server. Finally, the mobile phone, the PC and the large screen end are used for displaying to a user.
In addition, in order to solve the problems of different equipment manufacturers and different data source structures of a laboratory and a mixing station provided in the background art, the embodiment of the application also discloses a highway engineering quality management system data acquisition method based on the Internet of things, as shown in fig. 1, which specifically comprises the following steps:
Step S1, creating a universal data source template of a universal machine, a press machine and mixing station equipment;
A data source template is a template for storing and managing data, defining the structure and attributes of a data source, and providing a method of manipulating and managing data, and in an embodiment of the present application, the data source template comprises the following parts: data structure, data attribute and data operation and management method. Specifically, the data structure defines the structure of the data source, including field names, data types, lengths, etc., and determines the types and formats of data that can be stored in the data source; the data attribute defines the attribute of the data source, such as the access right of the data, the visibility of the data, the updating mode of the data and the like, and determines the functions and the limits that the data source can provide for other systems or application programs; the data operation and management method defines logic for operating and managing the data source, including data input rules, query logic, update conditions, data deletion and the like, and determines the capability and limitation of performing various operations on the data source.
In addition, the data source template can unify and standardize the structure and the attribute of the data source, so that the interaction of the data between different systems and application programs is more convenient and flexible, the data source template can also improve the safety and maintainability of the data, and data errors and redundancy are reduced.
Further, in the embodiment of the present application, a relational database template is used as a universal data source template of a universal machine, a press and a mixing station device, and the relational database template can provide highly reliable data storage and management capability, and in highway engineering quality management, the data source template can define the following contents:
The system comprises a main entity, a data processing unit and a data processing unit, wherein the main entity mainly comprises laboratory equipment, mixing station equipment and Internet of things equipment, and specific information and attributes of the equipment are stored in a relational database;
The implementation progress data of highway engineering can be defined, including construction plans, actual construction conditions and the like;
In addition, the problem and the correction data are defined and used for storing the problems and the correction conditions in the engineering, including information such as problem description, correction measures, correction feedback and the like;
also included are reports and documents: the method is used for storing various reports and documents, including engineering acceptance reports, quality assessment reports and the like.
Through the relational database template, the association relation among the entities can be established, and the data query and analysis are convenient. Meanwhile, the access authority of the data and the updating mode of the data can be defined, and the safety and the integrity of the data are ensured.
In addition to relational database templates, other data source templates, such as NoSQL database templates or file system templates, may be considered for use, with appropriate data source templates being selected according to particular needs.
Further, in the embodiment of the present application, step S1 further includes the following steps:
Step S110, creating a universal data source of a universal machine part according to a database structure of the universal machine (a steel bar raw material tensile test, a steel bar welding test and a steel bar mechanical connection test);
Step S120, creating a general data source of a press part according to a database structure of a press (cement concrete compression test, cement mortar compression and fracture test, cement paste compression and fracture test, building mortar test);
Step S130, creating a general data source of three indexes of asphalt according to a database structure of three indexes of asphalt (penetration, ductility and softening point);
Step S140, creating a general data source of the mixing station part according to the database structure of the mixing station (cement mixing station, water-stable mixing station, asphalt mixing station).
Step S2, integrating a universal data source template into laboratory and mixing station equipment software, and writing test data and mixing station production data into the universal data source;
Further, in the embodiment of the present application, step S2 further includes the following steps:
step S210, renaming the general data source template to be DatabaseCommon.mdb, and putting the file under a device software data directory;
And step S220, transmitting the structural description document of the universal data source template to a device manufacturer technician, and writing the device data into the databaseCommon.mdb file by the manufacturer technician in real time.
And step S3, deploying an acquisition client, selecting a general data source in the acquisition client, and acquiring and synchronizing data.
Further, in the embodiment of the present application, step S3 further includes the following steps:
step S310, opening an acquisition client, selecting corresponding equipment such as a press, and selecting a general version of the press;
step S320, selecting a databaseCommon.mdb file by a data source path;
and step S330, installing a service, and automatically collecting and synchronizing data to a data processing center.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices, and methods may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a random access memory (RAM, randomaccess memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
In the description of the present specification, the descriptions of the terms "one embodiment," "example," "specific example," and the like, mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present invention. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiments or examples. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The foregoing is merely illustrative of the structures of this invention and various modifications, additions and substitutions for those skilled in the art can be made to the described embodiments without departing from the scope of the invention or from the scope of the invention as defined in the accompanying claims.
Claims (1)
1. The highway engineering quality management method based on the Internet of things is characterized by comprising a highway engineering quality management system, wherein the highway engineering quality management system comprises a collection client, a data processing center, an Internet of things equipment server, a database server, a site server and a user terminal;
the collection client is connected with laboratory equipment and a mixing station, wherein:
the laboratory equipment comprises a universal machine, a press, a curing box and asphalt index equipment;
the mixing station comprises a cement mixing station, a water-stable mixing station and an asphalt mixing station;
The internet of things equipment server is connected with the internet of things equipment, and the internet of things equipment comprises: road surface control paving and rolling speed, temperature and longitude and latitude sensor equipment, a steel box girder automatic welding robot, environment-friendly water protection equipment, tensioning grouting equipment, intelligent tunnel equipment, modified asphalt production and transportation equipment, pile machine equipment and laboratory video monitoring equipment;
the acquisition client is embedded into a microcomputer of the laboratory and mixing station equipment, and simultaneously acquires and synchronizes real-time data of the laboratory equipment and the mixing station equipment;
The data processing center performs statistical analysis and early warning judgment on data transmitted back by the acquisition client and the Internet of things equipment so as to generate equipment state data, statistical data and early warning information; meanwhile, the data processing center responds to a login request of the acquisition client, and requests for acquiring information of items, benchmarks, laboratories, equipment types and equipment names to acquire the latest acquisition program;
the highway engineering quality management method comprises the following steps:
Creating a universal machine universal data source template according to the data structures of the tensile test, the mechanical connection test and the welding test of the reinforcing steel bars of the universal machine in the laboratory; creating a universal data source template of the press according to the data structure of the press concrete compressive strength test, the cement mortar compressive fracture test and the cement paste compressive fracture test; creating an asphalt universal data source template according to the data structure of an asphalt penetration test, an asphalt ductility test, an asphalt softening point test, an asphalt mixture rutting test, an asphalt mixture Marshall test and an asphalt mixture combustion furnace test; respectively creating a general data source template of the cement mixing station, the water-stable mixing station and the asphalt mixing station according to the structure of the production data of the cement mixing station, the water-stable mixing station and the asphalt mixing station, and creating a corresponding general data source template according to the data structure of other engineering test business and the engineering production data structure;
all the universal machine universal data source template, the press universal data source template, the asphalt universal data source template, the cement mixing station universal data source template, the water stabilization mixing station universal data source template, the asphalt mixing station universal data source template and other universal data source templates are combined into a data source template file and named as databaseCommon.
Integrating the universal data source template into laboratory and mixing station equipment software, and writing test data and mixing station production data into the universal data source;
deploying an acquisition client, selecting a universal data source in the acquisition client, acquiring and synchronizing test data and mixing station production data, supporting real-time data synchronization and offline data transmission, and automatically performing iterative upgrade;
using a data analysis tool to visually display the test data and the mixing station production data;
Integrating a universal data source template into laboratory and mixing station equipment software, and writing test data and mixing station production data into the universal data source, wherein the method specifically comprises the following steps of:
Putting a universal data source template Database Common. Mdb file under a device software data directory;
writing the device data into a databaseCommon.mdb file in real time according to the structural description document of the universal data source template;
The method comprises the steps of selecting a universal data source in an acquisition client, acquiring and synchronizing test data and mixing station production data, supporting real-time data synchronization and offline data transmission, and automatically and iteratively upgrading the data, wherein the method specifically comprises the following steps of:
Starting an acquisition client, logging in the acquisition client by using an account of laboratory equipment or mixing station equipment, and selecting a data type to be acquired;
Selecting a universal data source template Database Common.mdb file as a data source path;
starting an automatic acquisition and synchronization service, and automatically acquiring and synchronizing data to a data processing center in real time;
When the equipment is offline, automatically acquired data are firstly stored in a local sqlite database, and when the equipment is online again, the synchronization program continuously uploads all data after offline;
starting an automatic iterative upgrade service, automatically comparing and acquiring the latest program from a data service center, and automatically executing the upgrade of the acquisition program;
The general data source is a relational database, and the relational database is combined with a spatial database engine to manage data;
the attribute data table in the relational database management data, and the spatial database engine organizes spatial data in the management data;
The pile machine equipment comprises a pipe pile and a stirring pile, wherein the depth, the flow, the pressure, the density, the current, the verticality and the time in the construction process of the pipe pile and the stirring pile are uploaded to a data processing center through a flow sensor, an inclination sensor, a depth sensor and a current sensor, and then a data report of the pipe pile and the stirring pile and early warning information are generated through judgment and analysis;
The steel box girder automatic welding robot comprises a sand blasting robot, a paint spraying robot, a diaphragm plate welding robot, a top plate U rib inner welding robot, a bottom plate U rib outer welding robot and a top plate U rib outer welding robot, wherein a temperature and humidity sensor, a flow pressure sensor and a current and voltage sensor are arranged in the robots and are used for collecting index values of sand blasting air pressure, paint spraying flow, running speed, temperature, humidity, current and voltage, and the monitoring of sand blasting, paint spraying and welding quality of the steel box girder is realized by judging whether the index values are in a specified range or not.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310864805.XA CN116882826B (en) | 2023-07-14 | 2023-07-14 | Highway engineering quality management system and method based on Internet of things |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310864805.XA CN116882826B (en) | 2023-07-14 | 2023-07-14 | Highway engineering quality management system and method based on Internet of things |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116882826A CN116882826A (en) | 2023-10-13 |
| CN116882826B true CN116882826B (en) | 2024-05-03 |
Family
ID=88267499
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310864805.XA Active CN116882826B (en) | 2023-07-14 | 2023-07-14 | Highway engineering quality management system and method based on Internet of things |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116882826B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109302487A (en) * | 2018-10-30 | 2019-02-01 | 广西交投科技有限公司 | Highway project quality administration information system based on cloud platform |
| CN112327781A (en) * | 2020-11-16 | 2021-02-05 | 镇江畅硕信息科技有限公司 | Asphalt mixing station production quality remote monitoring management system based on internet of things technology |
| CN112925767A (en) * | 2021-03-03 | 2021-06-08 | 浪潮云信息技术股份公司 | Multi-data-source dynamic data synchronization management method and system based on internet supervision |
| CN113722747A (en) * | 2021-11-02 | 2021-11-30 | 湖北交投智能检测股份有限公司 | Road water transport engineering test detection big data system and early warning method |
| CN114398231A (en) * | 2021-12-30 | 2022-04-26 | 中国水利水电第七工程局有限公司 | Asphalt mixing station quality monitoring system and monitoring method thereof |
| KR20220061573A (en) * | 2020-11-06 | 2022-05-13 | (주)피플앤드테크놀러지 | Integration management system for pavement quality management based on iot |
-
2023
- 2023-07-14 CN CN202310864805.XA patent/CN116882826B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109302487A (en) * | 2018-10-30 | 2019-02-01 | 广西交投科技有限公司 | Highway project quality administration information system based on cloud platform |
| KR20220061573A (en) * | 2020-11-06 | 2022-05-13 | (주)피플앤드테크놀러지 | Integration management system for pavement quality management based on iot |
| CN112327781A (en) * | 2020-11-16 | 2021-02-05 | 镇江畅硕信息科技有限公司 | Asphalt mixing station production quality remote monitoring management system based on internet of things technology |
| CN112925767A (en) * | 2021-03-03 | 2021-06-08 | 浪潮云信息技术股份公司 | Multi-data-source dynamic data synchronization management method and system based on internet supervision |
| CN113722747A (en) * | 2021-11-02 | 2021-11-30 | 湖北交投智能检测股份有限公司 | Road water transport engineering test detection big data system and early warning method |
| CN114398231A (en) * | 2021-12-30 | 2022-04-26 | 中国水利水电第七工程局有限公司 | Asphalt mixing station quality monitoring system and monitoring method thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116882826A (en) | 2023-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110147417B (en) | Highway engineering construction supervision integration platform | |
| CN108681781B (en) | Subway operation and maintenance management information system and method based on three-dimensional Internet of things technology | |
| Xu et al. | Adaptive quality control and acceptance of pavement material density for intelligent road construction | |
| Peyret et al. | The computer integrated road construction project | |
| CN103229197B (en) | The integrated pipe wire management system of use information means of identification and method | |
| CN109302487A (en) | Highway project quality administration information system based on cloud platform | |
| US20020045986A1 (en) | Display device for work machine | |
| CN105652835B (en) | A kind of intelligence system that monitoring is intelligently compacted for road foundation road surface | |
| CN111612405A (en) | Rock and soil dynamic information processing system and method based on cloud GIS platform | |
| CN107272534A (en) | A kind of intelligence compacting monitoring system | |
| Han et al. | A BIM-IoT and intelligent compaction integrated framework for advanced road compaction quality monitoring and management | |
| CN103544556A (en) | Life-cycle management system and method for tunnels | |
| CN111401746A (en) | Intelligent construction site informatization management system | |
| CN106803149B (en) | Bridge construction information acquisition and management method | |
| CN110275932A (en) | A kind of laying of roadway dynamic supervision apparatus based on BIM+GIS technology | |
| Liu et al. | A real-time monitoring system for lift-thickness control in highway construction | |
| CN109711645B (en) | Pipeline construction data management system and method based on two-dimensional code | |
| CN106534323A (en) | Mobile patrol system and patrol method based on protection of historical relics | |
| CN111008810B (en) | System and method for monitoring paving system components | |
| CN109918810A (en) | Based on BIM technology to the method and system of expressway construction management | |
| CN112712300A (en) | BIM + GIS construction project management system based on B/S information system | |
| CN103632198A (en) | Visualized and full-life measurement asset management system based on intelligent mobile terminal | |
| CN111399403A (en) | Remote cooperative monitoring system and method for earthwork leveling operation suitable for inclined roadbed | |
| US20070005412A1 (en) | Electronic requirement management system with checklists on a handheld computer | |
| KR102445847B1 (en) | Road pavement construction management system for connecting transport and construction of pavement material, and method for the same |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |