CN117687343B - Rural environment monitoring and management system based on Internet of things - Google Patents
Rural environment monitoring and management system based on Internet of things Download PDFInfo
- Publication number
- CN117687343B CN117687343B CN202410137575.1A CN202410137575A CN117687343B CN 117687343 B CN117687343 B CN 117687343B CN 202410137575 A CN202410137575 A CN 202410137575A CN 117687343 B CN117687343 B CN 117687343B
- Authority
- CN
- China
- Prior art keywords
- monitoring
- monitoring sensor
- coordinate
- record
- change
- 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
- 238000012544 monitoring process Methods 0.000 title claims abstract description 160
- 230000008859 change Effects 0.000 claims abstract description 47
- 238000013507 mapping Methods 0.000 claims abstract description 20
- 238000012806 monitoring device Methods 0.000 claims abstract description 9
- 230000002159 abnormal effect Effects 0.000 claims abstract description 7
- 230000004044 response Effects 0.000 claims description 11
- 238000004458 analytical method Methods 0.000 claims description 10
- 238000000034 method Methods 0.000 claims description 10
- 238000003860 storage Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 2
- 230000006855 networking Effects 0.000 claims 1
- 230000007613 environmental effect Effects 0.000 description 5
- 241000238631 Hexapoda Species 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 4
- 241000607479 Yersinia pestis Species 0.000 description 3
- 230000007547 defect Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000013459 approach Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 239000002689 soil Substances 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 238000012351 Integrated analysis Methods 0.000 description 1
- 230000005856 abnormality Effects 0.000 description 1
- 238000012271 agricultural production Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005265 energy consumption Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006698 induction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000001932 seasonal effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/04—Programme control other than numerical control, i.e. in sequence controllers or logic controllers
- G05B19/042—Programme control other than numerical control, i.e. in sequence controllers or logic controllers using digital processors
- G05B19/0428—Safety, monitoring
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B2219/00—Program-control systems
- G05B2219/20—Pc systems
- G05B2219/24—Pc safety
- G05B2219/24024—Safety, surveillance
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Automation & Control Theory (AREA)
- Alarm Systems (AREA)
Abstract
The application discloses a rural environment monitoring and management system based on the Internet of things, which comprises the following components: the system comprises a server terminal, various monitoring sensors, various monitoring devices and a client; the monitoring sensor is used for executing a monitoring task, and the monitoring equipment and the monitoring sensor can be subjected to position matching setting so as to be used for receiving abnormal data sent by the monitoring sensor in real time and responding in time; the server terminal comprises a database for storing historical data collected by the monitoring sensor or the monitoring equipment; the database also comprises a coordinate updating table which is used for recording the change of each monitoring sensor; wherein the fields of the coordinate update table include: the mapping value is obtained based on the coordinate position mapping, and is used as a main key together with the updating time, and the position label represents the IDs of all monitoring sensors in the coordinate position.
Description
Technical Field
The invention belongs to the field of the Internet of things, and particularly relates to a rural environment monitoring and management system based on the Internet of things.
Background
The rural internet of things (Rural Internet of Things, ioT) refers to a series of technologies and practices that apply the internet of things technology in rural areas to improve agricultural production efficiency, optimize resource management, enhance environmental monitoring, and improve the quality of life of rural residents. The technology relates to various aspects of sensors, data communication, automation and intelligent equipment and the like so as to realize real-time acquisition, processing and analysis of data.
However, the existing environment monitoring and management system of the rural internet of things has the defects of use, and particularly, problems of clamping, data return errors and the like easily occur when a comprehensive analysis query function is executed for analyzing environment conditions. Based on this, how to change the interface response speed and improve the robustness of the interface is low, so that the improvement of the user experience is a problem to be solved.
Disclosure of Invention
In order to solve the defects in the prior art, the invention aims to solve the defects, and further provides a rural environment monitoring and management system based on the Internet of things.
The invention adopts the following technical scheme.
The first aspect of the invention discloses a rural environment monitoring and management system based on the Internet of things, which comprises the following components: the system comprises a server terminal, various monitoring sensors, various monitoring devices and a client; the monitoring sensor is used for executing a monitoring task, and the monitoring equipment and the monitoring sensor can be subjected to position matching setting so as to be used for receiving abnormal data sent by the monitoring sensor in real time and responding in time;
The server terminal comprises a database for storing historical data collected by the monitoring sensor or the monitoring equipment;
The database also comprises a coordinate updating table which is used for recording the change of each monitoring sensor; wherein the fields of the coordinate update table include: the mapping value is obtained based on the coordinate position mapping, and is used as a main key together with the updating time, and the position label represents the IDs of all monitoring sensors in the coordinate position.
Further, the database also comprises a plurality of equipment type tables, an equipment historical data table and a plurality of equipment historical data sub-tables, wherein each equipment type table is used for recording basic information of all monitoring sensors under the type, including coordinate positions, equipment numbers and other monitoring sensor IDs matched with the positions, and the equipment historical data table is used for storing names of all equipment historical data sub-tables; each device history data sub-table is used for storing history data collected by all monitoring sensors in the category at different times.
Further, the device history data tables of different monitoring sensors are combined in one device history data table.
Further, the system comprises an execution device management function, including step S201 to step S204;
step S201, in response to the change of the monitoring sensor, updating the device type table;
Step S202, calculating a corresponding mapping value based on the coordinate position before the update of the monitoring sensor, and searching a first record with the latest update time in a coordinate update table;
Step S203, modifying the first record based on the change of the monitoring sensor, and storing the first record in a coordinate update table;
Step S204, if the change of the monitoring sensor comprises coordinate position change, calculating a corresponding mapping value based on the updated coordinate position of the monitoring sensor, and searching a second record with the latest updating time in a coordinate updating table; and modifying the second record based on the change of the monitoring sensor, and storing the second record into a coordinate updating table.
Further, the map value mapID is calculated based on the following formula:
wherein, Is a parameter threshold value,/>To round down the sign,/>Representing the coordinate position.
Further, the device type table further comprises a reference ID, the reference ID is obtained based on the unique identification mapping of the monitoring sensor, and the position label of the coordinate updating table and the ID of the device history data sub-table are both reference IDs.
Further, the system comprises a step A201 to a step A205 for executing equipment management functions;
step A201, if the change of the monitoring sensor does not include the change of the coordinate position, ending the step;
Step A202, updating a device type table in response to a change of the monitoring sensor;
Step A203, calculating a corresponding mapping value based on the coordinate position before the update of the monitoring sensor, and searching a first record with the latest update time in a coordinate update table;
Step A204, modifying the first record based on the change of the monitoring sensor, and storing the first record in a coordinate updating table;
Step A205, calculating a corresponding mapping value based on the updated coordinate position of the monitoring sensor, and searching a second record with the latest updating time in a coordinate updating table; and modifying the second record based on the change of the monitoring sensor, and storing the second record into a coordinate updating table.
Further, the method also comprises the step of executing a comprehensive analysis query function, comprising the steps A101 to A103;
Step A101, responding to a coordinate position input by a receiving user, and searching a monitoring sensor ID corresponding to the coordinate position in a coordinate updating table;
step A102, responding to the receiving start time and the ending time, and acquiring the table name of the corresponding equipment history data sub-table from the equipment history data table by combining the monitoring sensor ID;
Step A103, based on the starting time, the ending time and the monitoring sensor ID, corresponding historical data is obtained from the device historical data sub-table.
The second aspect of the invention discloses a terminal, which comprises a processor and a storage medium; the method is characterized in that:
The storage medium is used for storing instructions;
The processor is configured to operate in accordance with the instructions to perform the steps of the method of the first aspect.
A third aspect of the invention discloses a computer-readable storage medium on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the steps of the method according to the first aspect.
Compared with the prior art, the invention has the following advantages:
In the general technique, the history data of each monitoring sensor is stored in the database in the form of an ID, but management confusion is easily caused by each equipment change, for example, an ID change or a coordinate position change. More importantly, as the server terminal adopts a distributed system and adopts a conventional method for management, data merging errors are easy to cause, and the robustness is poor. In addition, when the comprehensive analysis query function is executed, the query speed is low and errors are easy to occur. The method and the system have the advantages that the equipment change table is creatively established for managing equipment change conditions, and the coordinate position is used as a main key, so that the query efficiency is improved, and meanwhile, the robustness of the system is improved.
Drawings
Fig. 1 is a schematic diagram of an application interface of a rural environment monitoring and management system based on the internet of things according to an embodiment of the present invention.
Fig. 2 is a schematic diagram of a database of a rural internet of things system.
Fig. 3 is a schematic diagram of a rural environment monitoring and management system based on the internet of things according to an embodiment of the present invention.
Detailed Description
The application is further described below with reference to the accompanying drawings. The following examples are only for more clearly illustrating the technical aspects of the present application, and are not intended to limit the scope of the present application.
The main roles of the rural internet of things can include: agricultural optimization, for example: the monitoring tasks, such as monitoring the growth condition of crops, the soil humidity, the temperature and the like, are executed through the monitoring sensor, so that accurate agriculture is realized; resource management, for example: effectively managing water resources, land use and energy consumption; environmental monitoring, for example: air quality, water quality, and other environmental factors are monitored to protect the rural environment. Accordingly, a rural environmental monitoring and management system based on the internet of things may include: server terminal, multiple monitoring sensor, multiple monitoring equipment and customer end. Among other things, the various monitoring sensors may include the following types: insect pest monitoring sensors (e.g., light induction sensors, vibration sensors), spore monitoring sensors (wind direction and wind speed sensors, biochemical sensors), environmental monitoring sensors (e.g., temperature sensors, soil humidity sensors), and the like. The various monitoring devices may include: the video monitoring equipment and the alarm monitoring equipment are used for receiving the abnormal data sent by the monitoring sensor in real time and responding in time (for example, recording video or sending an alarm).
Within the map of the application interface of fig. 1, 1 insect pest monitoring sensor 607, 2 spore monitoring sensors 321 and 352, 2 video monitoring devices 202 and 212 are shown.
In general, the monitoring sensor and the monitoring device can be arranged in a position matching manner, so that abnormal data sent by the monitoring sensor can be received in real time, and the site situation can be fed back in time. In this scenario, when the value of a certain type of monitoring sensor is abnormal, the reasons of the abnormality can be analyzed together with the values of the sensors matched with other positions. As shown in fig. 1. The insect condition monitoring sensor 607 may be matched to the video monitoring device 202; the video monitoring device 202 can match the spore monitoring sensor 321 with the insect pest monitoring sensor 607.
In the general technology, the server terminal includes a database and an interface end, and the interface end is used for receiving the historical data collected by the monitoring sensor or the monitoring device and storing the historical data in the database, so that when the client accesses, the data is presented on an application interface as shown in fig. 1 through the interface end.
In some embodiments, the database may be a mysql database or an oracle database, including at least: the multiple device type table, the device history data table, and the multiple device history data sub-table are shown in fig. 2.
It should be noted that the number of device history data sub-tables corresponding to one device type table may be plural. For example: in fig. 2, the device history data corresponding to the device type table sn_ LightInducedSensor of the light-induced sensor is divided into 3 pieces, i.e., his_ LightInducedSensor20221123, his_ LightInducedSensor20230217 and his_ LightInducedSensor20230924, respectively. The data formats of the device type table, the device history data table histable _ LightInducedSensor, and the device history data sub-table of the light-induced sensor may be shown in tables 1,2, and 3, respectively.
TABLE 1
TABLE 2
TABLE 3 Table 3
In table 1, the device type tables take IDs as primary keys, and each device type table is used for recording basic information of all monitoring sensors in the category, for example, the corresponding device number snID, which is a unique identifier of one monitoring sensor; the coordinate position is generally uniquely determined by x, y and the region scene where it is located; the location match ID, RELEVANTID, indicates that the other monitoring sensor IDs for which the monitoring sensor ID locations match, are separated by a semicolon. refID is the reference ID.
It can be appreciated that the scenes in table 1 are passed through the compartmentalization to reduce complexity, as the rural internet of things jurisdiction is too large.
Typically, snID is not a direct replacement for the ID. This is because rural internet of things can be associated with various task modes at random. For example, in the inspection task, a lot of photo-induced sensors need to be selected to collect data at a specific frequency (usually a higher frequency) in a specific daily time, and at this time, for convenience in management, the IDs are renumbered, for example, the IDs of the photo-induced sensors in the inspection task are redefined as 681-685 numbers, so that centralized management is facilitated. Furthermore, snID may be strings that are not suitable for use as primary keys.
In table 2, tableName is used to store the names of the respective device history data sub-tables so that the respective device history data sub-tables can be retrieved. Typically, the data of each device history data sub-table will set an upper limit, and when data overflows, the database can automatically generate a corresponding sub-table according to the script to store new data. Therefore, endTime of the last device history data sub-table is always empty, meaning that its data never overflows, otherwise a new sub-table will be opened up automatically.
In some embodiments, the device history data summary of the different monitoring sensors may be combined in one device history data summary.
In table 3, each device history data sub-table uses ID and timestamp as common main key, and stores the history data collected by all monitoring sensors under the category at different times in real time under the data field.
Based on the multiple device type tables, the device history data table and the multiple device history data sub-tables, a search function may be performed, including steps S101 to S103.
Step S101, in response to receiving the coordinate position input by the user, searching a monitoring sensor ID corresponding to the coordinate position in a device type table.
Step S102, in response to receiving the starting time and the ending time, and in combination with the monitoring sensor ID, the table name of the corresponding device history data sub-table is obtained from the device history data table.
Step S103, based on the starting time, the ending time and the monitoring sensor ID, corresponding historical data is obtained from the device historical data sub-table.
However, under the rural internet of things system, the number of monitoring sensors is rare and the price is high. These monitoring sensors need to be constantly moved and reconfigured according to seasonal changes, crop growth cycles, and specific agricultural activities. Therefore, the spatial positions of the monitoring sensors can be changed along with tasks of each stage, and at the moment, the matching settings among the monitoring sensors can be continuously updated, and further, when the historical data are analyzed later, the historical data corresponding to other monitoring sensors with matched positions can not be searched. On the other hand, different agricultural personnel may often commonly use a certain monitoring sensor, and thus, for convenience in management, one monitoring sensor may correspond to a plurality of IDs, and when different agricultural personnel are on different tasks, the corresponding monitoring sensor may be turned on to perform the task.
It can be understood that when one monitoring sensor performs a plurality of tasks simultaneously, the data backed up in the database, namely, the data backed up by the device history data in the sub-table, is only one piece.
For example, suppose that the user finds that the data of the light-induced sensor is abnormal in the last ten days of the month, and for analysis reasons, it is necessary to perform analysis in combination with the historical data of other monitoring sensors whose positions are matched. As shown in fig. 1, a user of a client may click on a location in a map and choose to jump into the analysis-by-synthesis query interface. The query conditions of the comprehensive analysis query interface at least comprise: start time, end time, and sensor type. At this time, according to the general technical means, only the history data of each monitoring sensor at the current position can be obtained, and in the range of the start time and the end time, whether the positions of the monitoring sensors are changed is unknown, so that the returned history data is inconsistent with the requirements of the user.
Based on this, the device type table may be modified in the database to record changes in the ID or coordinate position of each monitoring sensor. The modified device type table may be as shown in table 4.
TABLE 4 Table 4
It will be appreciated that the modified device type table differs from table 1 only in that: the newly added field time indicates the update time, and the coordinate position of the spore monitoring sensor 321 is changed in table 4.
However, this approach is poorly robust because when modifying the device type table, it also requires synchronized updates of other data in the device type table represented by each RELEVANTID as a primary key. It will be appreciated that the data of ID 202 and ID 607 must also exist in the device type table, and when the coordinate position of the spore monitoring sensor 321 is changed, the data RELEVANTID of ID 202 and ID 607 must also be deleted 321, otherwise, the data will not match. In fact, since the server terminals are often distributed, this means that once a situation occurs in which at least 2 sub-servers (e.g., sub-server a or sub-server B) synchronously modify the device type table, and then unify the modified data to the total server terminal, the device type table in the server terminal is prone to merging errors.
In addition, when a user performs an integrated analysis query, this approach requires traversing the entire device type table, filtering out the data associated with the device type, spatial location, and time, and performing a segment lookup in the device history data sub-table based thereon. This greatly reduces query efficiency.
Based on this, as shown in fig. 3, the present invention overcomes the above-mentioned problems by adding a coordinate update table for recording each change of the ID or the coordinate position of the monitoring sensor. The coordinate update table may be as shown in table 5.
TABLE 5
Wherein the map value mapID and the update time are used as a main key of a coordinate update table, mapID is mapped based on a coordinate position, and position index IDs represent IDs of all monitoring sensors at the coordinate position, and a plurality of the map values are separated by a semicolon.
In some embodiments, the map value mapID may be calculated based on the following formula:
wherein, Is a parameter threshold, typically set to be greater than or equal to 100,/>To round down the sign,/>For sum symbol subscripts.
In order to maintain the coordinate update table, a rural environment monitoring and management system based on the internet of things should further include performing a device management function, including steps S201 to S204.
Step S201, in response to the change of the monitoring sensor, updates the device type table.
It is understood that the change in the monitoring sensor may include an ID change or a coordinate position change.
Step S202, calculating a corresponding mapping value based on the coordinate position before the update of the monitoring sensor, and searching a first record with the latest update time in a coordinate update table.
Step S203, modifying the first record based on the change of the monitoring sensor, and storing the first record in a coordinate update table.
Step S204, if the change of the monitoring sensor comprises coordinate position change, calculating a corresponding mapping value based on the updated coordinate position of the monitoring sensor, and searching a second record with the latest updating time in a coordinate updating table; and modifying the second record based on the change of the monitoring sensor, and storing the second record into a coordinate updating table.
That is, if a coordinate position change is involved, 2 pieces of data need to be inserted in the coordinate update table, otherwise only the first record needs to be updated. Because the coordinate position is used as a primary key, the change of the monitoring sensor is meant, the ID of other monitoring sensors is not required to be concerned, and the robustness of the system is improved.
At this time, when the user performs the comprehensive analysis query, it is only necessary to generate a mapping value based on the coordinate position and search IDs in the coordinate update table in a range from the start time to the end time. However, this has the disadvantage that multiple segment lookups still need to be performed. Taking table 4 as an example, when the start time is set to 1674623456 and the end time is set to 1686328452, and when the searched area is located at (x=246, y=97, scene=2), then only for the monitoring sensor snID being "24fg3g7", it is necessary to perform searching at least twice, and each search needs to be performed for one pass of steps S102 to S103. More specifically, the start time, end time, and monitoring sensor ID of the first query are 1674623456, 1686328452, 607, respectively; the start time, end time, and monitoring sensor ID of the second query are 1682640176, 1686328452, 609, respectively. In fact, the reading performance of the database is largely wasted in the process of opening the table, and secondly in the process of reading the data.
Thus, in some embodiments, the device type table further includes a reference ID, the reference ID is mapped based on a unique identification of the monitoring sensor, and the location index of the coordinate update table and the ID of the device history data sub-table are both reference IDs.
By setting the reference ID, the method avoids segment searching, and the equipment management function can also comprise the steps A201-A205.
Step a201, if the change of the monitoring sensor does not include the change of the coordinate position, the step is ended.
Step a202, in response to a change in the monitoring sensor, updates the device type table.
Step a203, calculating a corresponding mapping value based on the coordinate position before the update of the monitoring sensor, and searching a first record with the latest update time in the coordinate update table.
Step a204, modifying the first record based on the change of the monitoring sensor, and storing the first record in a coordinate update table.
Step A205, calculating a corresponding mapping value based on the updated coordinate position of the monitoring sensor, and searching a second record with the latest updating time in a coordinate updating table; and modifying the second record based on the change of the monitoring sensor, and storing the second record into a coordinate updating table.
It can be seen that when the reference ID is used instead of the ID, if the change of the monitoring sensor does not include the coordinate position change, the device management function does not need to be performed.
Finally, the rural environment monitoring and management system based on the Internet of things disclosed by the invention also comprises a comprehensive analysis query function, which comprises the steps A101-A103.
Step A101, in response to receiving the coordinate position input by the user, searching a monitoring sensor ID corresponding to the coordinate position in a coordinate update table.
Step A102, in response to receiving the start time and the end time, and in combination with the monitoring sensor ID, the table name of the corresponding device history data sub-table is obtained from the device history data table.
Step A103, based on the starting time, the ending time and the monitoring sensor ID, corresponding historical data is obtained from the device historical data sub-table.
While the applicant has described and illustrated the embodiments of the present invention in detail with reference to the drawings, it should be understood by those skilled in the art that the above embodiments are only preferred embodiments of the present invention, and the detailed description is only for the purpose of helping the reader to better understand the spirit of the present invention, and not to limit the scope of the present invention, but any improvements or modifications based on the spirit of the present invention should fall within the scope of the present invention.
Claims (8)
1. Rural environment monitoring and management system based on thing networking, characterized by comprising: the system comprises a server terminal, various monitoring sensors, various monitoring devices and a client; the monitoring sensor is used for executing a monitoring task, and the monitoring equipment and the monitoring sensor are subjected to position matching setting so as to be used for receiving abnormal data sent by the monitoring sensor in real time and responding in time;
The server terminal comprises a database for storing historical data collected by the monitoring sensor or the monitoring equipment;
The database also comprises a coordinate updating table which is used for recording the change of each monitoring sensor; wherein the fields of the coordinate update table include: mapping values, updating time and position labels, wherein the mapping values are obtained based on the coordinate positions and are used as a main key together with the updating time, and the position labels represent the IDs of all monitoring sensors in the coordinate positions;
The database also comprises a plurality of equipment type tables, equipment historical data summary tables and a plurality of equipment historical data sub-tables, wherein each equipment type table is used for recording basic information of all monitoring sensors under the type, including coordinate positions, equipment numbers and other monitoring sensor IDs with matched positions, and the equipment historical data summary tables are used for storing names of the equipment historical data sub-tables; each device history data sub-table is used for storing history data collected by all monitoring sensors under the type at different times;
the system comprises a device management executing function, comprising steps S201 to S204;
step S201, in response to the change of the monitoring sensor, updating the device type table;
Step S202, calculating a corresponding mapping value based on the coordinate position before the update of the monitoring sensor, and searching a first record with the latest update time in a coordinate update table;
Step S203, modifying the first record based on the change of the monitoring sensor, and storing the first record in a coordinate update table;
Step S204, if the change of the monitoring sensor comprises coordinate position change, calculating a corresponding mapping value based on the updated coordinate position of the monitoring sensor, and searching a second record with the latest updating time in a coordinate updating table; and modifying the second record based on the change of the monitoring sensor, and storing the second record into a coordinate updating table.
2. The system of claim 1, wherein the summary of device history data for different monitoring sensors is incorporated into a single summary of device history data.
3. The rural environment monitoring and management system based on the internet of things according to claim 1, wherein the map value mapID is calculated based on the following formula:
Where D is a parameter threshold, [ ] is a downward rounding symbol and scale, x, y represents the coordinate position.
4. The system for monitoring and managing the rural environment based on the internet of things according to claim 1, wherein the device type table further comprises a reference ID, the unique identification map based on the monitoring sensor is obtained, and the position label of the coordinate update table and the ID of the device history data sub-table are both reference IDs.
5. The rural environment monitoring and management system based on the internet of things according to claim 4, wherein the system comprises a device management function, comprising steps a201 to a205;
step A201, if the change of the monitoring sensor does not include the change of the coordinate position, ending the step;
Step A202, updating a device type table in response to a change of the monitoring sensor;
Step A203, calculating a corresponding mapping value based on the coordinate position before the update of the monitoring sensor, and searching a first record with the latest update time in a coordinate update table;
Step A204, modifying the first record based on the change of the monitoring sensor, and storing the first record in a coordinate updating table;
Step A205, calculating a corresponding mapping value based on the updated coordinate position of the monitoring sensor, and searching a second record with the latest updating time in a coordinate updating table; and modifying the second record based on the change of the monitoring sensor, and storing the second record into a coordinate updating table.
6. The rural environment monitoring and management system based on the internet of things according to claim 5, further comprising a comprehensive analysis query function, comprising steps a101 to a103;
Step A101, responding to a coordinate position input by a receiving user, and searching a monitoring sensor ID corresponding to the coordinate position in a coordinate updating table;
step A102, responding to the receiving start time and the ending time, and acquiring the table name of the corresponding equipment history data sub-table from the equipment history data table by combining the monitoring sensor ID;
Step A103, based on the starting time, the ending time and the monitoring sensor ID, corresponding historical data is obtained from the device historical data sub-table.
7. A terminal comprising a processor and a storage medium; the method is characterized in that:
The storage medium is used for storing instructions;
the processor is operative to perform a system according to any one of claims 1-6 in accordance with the instructions.
8. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the system according to any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410137575.1A CN117687343B (en) | 2024-02-01 | 2024-02-01 | Rural environment monitoring and management system based on Internet of things |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410137575.1A CN117687343B (en) | 2024-02-01 | 2024-02-01 | Rural environment monitoring and management system based on Internet of things |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117687343A CN117687343A (en) | 2024-03-12 |
| CN117687343B true CN117687343B (en) | 2024-05-17 |
Family
ID=90139322
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410137575.1A Active CN117687343B (en) | 2024-02-01 | 2024-02-01 | Rural environment monitoring and management system based on Internet of things |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117687343B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105978978A (en) * | 2016-05-16 | 2016-09-28 | 太湖流域管理局水文局（信息中心） | System for achieving real-time exchange of outdoor monitoring data of hydrological environment |
| AU2020101595A4 (en) * | 2020-07-31 | 2020-09-10 | Goel, Neha DR | Digital signal processing technique in wireless sensor and actuator networks for long-range environmental monitoring |
| CN111965321A (en) * | 2020-09-11 | 2020-11-20 | 长沙紫宸科技开发有限公司 | Multifunctional monitoring system for tracking and monitoring large-area marine environment in real time |
| CN112446536A (en) * | 2020-11-19 | 2021-03-05 | 海南省林业科学研究院(海南省红树林研究院) | Ecological environment monitoring gridding system based on big data architecture and monitoring method thereof |
| CN116380236A (en) * | 2023-04-06 | 2023-07-04 | 浙江丰汇恒信息科技有限公司 | Intelligent park environment monitoring management method and system |
| CN117007112A (en) * | 2023-07-13 | 2023-11-07 | 苏州圣蒙莱科技有限公司 | Digital twinning-based intelligent city ecological environment monitoring system |
| CN117405178A (en) * | 2023-12-15 | 2024-01-16 | 成都电科星拓科技有限公司 | Mobile monitoring platform and method for automatically detecting indoor environment parameters |
-
2024
- 2024-02-01 CN CN202410137575.1A patent/CN117687343B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105978978A (en) * | 2016-05-16 | 2016-09-28 | 太湖流域管理局水文局（信息中心） | System for achieving real-time exchange of outdoor monitoring data of hydrological environment |
| AU2020101595A4 (en) * | 2020-07-31 | 2020-09-10 | Goel, Neha DR | Digital signal processing technique in wireless sensor and actuator networks for long-range environmental monitoring |
| CN111965321A (en) * | 2020-09-11 | 2020-11-20 | 长沙紫宸科技开发有限公司 | Multifunctional monitoring system for tracking and monitoring large-area marine environment in real time |
| CN112446536A (en) * | 2020-11-19 | 2021-03-05 | 海南省林业科学研究院(海南省红树林研究院) | Ecological environment monitoring gridding system based on big data architecture and monitoring method thereof |
| CN116380236A (en) * | 2023-04-06 | 2023-07-04 | 浙江丰汇恒信息科技有限公司 | Intelligent park environment monitoring management method and system |
| CN117007112A (en) * | 2023-07-13 | 2023-11-07 | 苏州圣蒙莱科技有限公司 | Digital twinning-based intelligent city ecological environment monitoring system |
| CN117405178A (en) * | 2023-12-15 | 2024-01-16 | 成都电科星拓科技有限公司 | Mobile monitoring platform and method for automatically detecting indoor environment parameters |
Non-Patent Citations (1)
| Title |
|---|
| 地理信息系统(GIS)在环境保护中的应用;杨帆;孙水裕;;科协论坛(下半月);20091025(10);第134-135页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117687343A (en) | 2024-03-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106446278B (en) | A kind of search method to data object based on space-time database | |
| CN106060174A (en) | Data analysis based agricultural guidance system | |
| CN105278373A (en) | Method for realizing comprehensive information processing system of transformer substation | |
| US10769104B2 (en) | Block data storage system in an event historian | |
| CN113849483A (en) | Real-time database system architecture for intelligent factory | |
| CN110442791B (en) | Data pushing method and system | |
| CN105577411A (en) | Cloud service monitoring method and device based on service origin | |
| CN111222226A (en) | EMS (energy management system) to GIS (geographic information System) model conversion and access system and method based on scheduling application visual angle | |
| CN113988794A (en) | Multi-data integrated rural agricultural information system and method | |
| CN113297196A (en) | Intelligent agricultural AIOT distributed big data storage platform | |
| CN109408331A (en) | Log alarming system based on user individual feature | |
| CN111061802B (en) | Power data management processing method, device and storage medium | |
| CN104765766A (en) | Method and device for updating monitoring video | |
| TW201525917A (en) | Method and device for marking in interrelated applications with operable icons | |
| CN111563759A (en) | Agricultural product traceability process identification and analysis system based on AI technology | |
| CN117687343B (en) | Rural environment monitoring and management system based on Internet of things | |
| CN107247721A (en) | Visualize collecting method | |
| CN104683870A (en) | Digital television channel search and updating system and application method of digital television channel search and updating system | |
| CN109189873A (en) | A kind of Meteorological Services big data monitoring analysis system platform | |
| KR20230054350A (en) | A Server Platform for Managing a Smart Farm | |
| CN115658642A (en) | Data processing method based on power grid resource data | |
| CN105550326B (en) | Electricity consumption querying method, device | |
| CN114996289A (en) | Uniform data driven zero code construction system and method for informatization service of colleges and universities | |
| CN114897501A (en) | Intelligent rural industry digital treatment service platform | |
| CN104317879B (en) | A kind of telemetry real-time exhibition method based on real-time data base |
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 |