CN113111790A - Intelligent community management system, method and storage medium based on time sequence database - Google Patents
Intelligent community management system, method and storage medium based on time sequence database Download PDFInfo
- Publication number
- CN113111790A CN113111790A CN202110407226.3A CN202110407226A CN113111790A CN 113111790 A CN113111790 A CN 113111790A CN 202110407226 A CN202110407226 A CN 202110407226A CN 113111790 A CN113111790 A CN 113111790A
- Authority
- CN
- China
- Prior art keywords
- information
- community
- terminal
- garbage
- value
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims description 27
- 239000010813 municipal solid waste Substances 0.000 claims abstract description 137
- 238000007726 management method Methods 0.000 claims abstract description 47
- 238000012544 monitoring process Methods 0.000 claims abstract description 24
- 238000011084 recovery Methods 0.000 claims abstract description 24
- 238000004364 calculation method Methods 0.000 claims description 24
- 239000000463 material Substances 0.000 claims description 23
- 238000006243 chemical reaction Methods 0.000 claims description 18
- 230000003044 adaptive effect Effects 0.000 claims description 6
- 238000001914 filtration Methods 0.000 claims description 6
- 238000013507 mapping Methods 0.000 claims description 3
- BULVZWIRKLYCBC-UHFFFAOYSA-N phorate Chemical compound CCOP(=S)(OCC)SCSCC BULVZWIRKLYCBC-UHFFFAOYSA-N 0.000 claims description 3
- 238000004590 computer program Methods 0.000 claims description 2
- 230000007547 defect Effects 0.000 abstract description 2
- 208000027418 Wounds and injury Diseases 0.000 abstract 1
- 230000006378 damage Effects 0.000 abstract 1
- 208000014674 injury Diseases 0.000 abstract 1
- 239000011521 glass Substances 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 230000001815 facial effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 206010063385 Intellectualisation Diseases 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000008092 positive effect Effects 0.000 description 1
Images
Classifications
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V20/00—Scenes; Scene-specific elements
- G06V20/60—Type of objects
- G06V20/62—Text, e.g. of license plates, overlay texts or captions on TV images
- G06V20/63—Scene text, e.g. street names
-
- G—PHYSICS
- G07—CHECKING-DEVICES
- G07C—TIME OR ATTENDANCE REGISTERS; REGISTERING OR INDICATING THE WORKING OF MACHINES; GENERATING RANDOM NUMBERS; VOTING OR LOTTERY APPARATUS; ARRANGEMENTS, SYSTEMS OR APPARATUS FOR CHECKING NOT PROVIDED FOR ELSEWHERE
- G07C9/00—Individual registration on entry or exit
- G07C9/20—Individual registration on entry or exit involving the use of a pass
- G07C9/27—Individual registration on entry or exit involving the use of a pass with central registration
-
- G—PHYSICS
- G07—CHECKING-DEVICES
- G07C—TIME OR ATTENDANCE REGISTERS; REGISTERING OR INDICATING THE WORKING OF MACHINES; GENERATING RANDOM NUMBERS; VOTING OR LOTTERY APPARATUS; ARRANGEMENTS, SYSTEMS OR APPARATUS FOR CHECKING NOT PROVIDED FOR ELSEWHERE
- G07C9/00—Individual registration on entry or exit
- G07C9/20—Individual registration on entry or exit involving the use of a pass
- G07C9/28—Individual registration on entry or exit involving the use of a pass the pass enabling tracking or indicating presence
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V20/00—Scenes; Scene-specific elements
- G06V20/60—Type of objects
- G06V20/62—Text, e.g. of license plates, overlay texts or captions on TV images
- G06V20/625—License plates
Landscapes
- Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Multimedia (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to the technical field of community management, and discloses an intelligent community management system and a storage medium based on a time sequence database, which are used for collecting community resident information, community resident vehicle license plate information, community garbage classification management information, community vehicle parking management information and community express delivery management information; monitoring the collected community information through a camera, and identifying the identity of community personnel through an identification program; and displaying the acquired information through a display. The invention avoids the defect that the opening of the access lock cannot be controlled based on face recognition in the prior art, and improves the accuracy of identity recognition of the access in the intelligent community; through the rubbish classification module when realizing classifying the recovery to bottle rubbish, reduce or even eliminate to the rubbish in the intelligent garbage bin once only clear up the recovery and lead to bottle rubbish to cause the risk of injury to the staff of community, improve the protection to the staff of community.
Description
Technical Field
The invention belongs to the technical field of community management, and particularly relates to an intelligent community management system, method and storage medium based on a time sequence database.
Background
Community management refers to a series of self-management or administrative management activities performed by various organizations, groups or organizations in a certain community in order to maintain the normal order of the community, promote the development and prosperity of the community, and meet specific needs of community residents such as material and cultural activities. The intelligent community management system divides artificially divided city management districts into unit grids in the system according to a certain standard by relying on a unified city management and digital platform. By means of the system to strengthen the inspection of unit grid parts and events, a separate management mode for supervision and treatment is established. However, in the existing smart community management system based on the time sequence database, although the access control system adopting a biological recognition mode such as fingerprint recognition and facial recognition meets the requirement of intellectualization, when the makeup of a female user is thick, or a user wears a mask or a hat in winter, the access control system cannot recognize the face of the user, so that the accuracy of identity recognition of the access control in the smart community is low; meanwhile, the community garbage classification is that the intelligent garbage can is generally cleaned and recovered at one time and is subjected to classification treatment when the intelligent garbage can is filled or filled to a certain degree, and for bottle type garbage, such as glass bottle garbage with a large quantity in household garbage, pop-top can garbage and the like, the method for classifying and recovering at one time can easily cause risks of glass bottle breakage, pop-top can scratch workers and the like due to too many cleaned quantities, so that the workers are injured.
In summary, the problems of the prior art are as follows: in the existing intelligent community management system based on the time sequence database, although the access control system adopting biological identification modes such as fingerprint identification and facial identification meets the intelligent requirement, when the makeup of female users is thick or the users are dry in winter and wear masks or hats, the access control system cannot identify the faces of the users, so that the accuracy of the identification of the access control in the intelligent community is low; meanwhile, the community garbage classification is that the intelligent garbage can is generally cleaned and recovered at one time and is subjected to classification treatment when the intelligent garbage can is filled or filled to a certain degree, and for bottle type garbage, such as glass bottle garbage with a large quantity in household garbage, pop-top can garbage and the like, the method for classifying and recovering at one time can easily cause risks of glass bottle breakage, pop-top can scratch workers and the like due to too many cleaned quantities, so that the workers are injured.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a time sequence database-based intelligent community management system, a time sequence database-based intelligent community management method and a storage medium.
The invention is realized in this way, and a smart community management method based on a time sequence database comprises the following steps:
collecting community resident information, community resident vehicle license plate information, community garbage classification management information, community vehicle parking management information and community express delivery management information;
monitoring the collected community information through a camera, and identifying the identity of community personnel through an identification program;
step two, releasing community information through a release program; the community information is consulted online through a consultation program, and the consultation method comprises the following steps: obtaining published community information, orderN(t) Which represents the time (0,t) The data size of internal release is as follows:
n (0) = 0, i.e., no data is published within 0 s;
{N(t) t 0 has no memory, and the data issued in disjoint time intervals are independent of each other, i.e. arbitraryn A time 0< t1<t2 < ……< tnRandom variableN(t1) - N(0)，N(t2) - N(t1)，……，N(tn) -N(tn-1) are independent of each other;
{N(t) t 0 has a steady increment of (A), (B), (C), (Dt，t + △t) The amount of data released in-flight is only related to the time interval deltat In relation to timet Irrelevant;
after login is successful, consulting information is operated through a touch screen; the touch screen adopts a self-adaptive filtering method to filter the consultation information, and specifically comprises the following steps:
in the formula: x (k) is the input of the adaptive filter, y (k) is the output of the adaptive filter, d (k) is the reference signal, e (k) is the error, WiIs the weight coefficient of the filter, mu is the step length, M is the order of the filter;
after filtering, multi-state distribution characteristic calculation is carried out on the advisory data, continuous iteration updating is introduced, noise characteristics are extracted, and the noise and the real advisory data are separated to obtain accurate information output by a bit sequence, wherein the bit sequence is as follows:
dividing bit sequence of random code separated data into
The bit rate is fast, and the length to be detected is defined as
Has a bit sequence of
(ii) a Obtaining directional dimensions of different mapping iteration vector features
；
And step three, displaying the monitoring video, the resident information, the license plate information, the identity identification information, the garbage classification information, the parking information, the express delivery information, the release information and the consultation information through a display.
Another objective of the present invention is to provide a smart community management system based on a time-series database, which comprises:
the system comprises a video monitoring module, a resident information acquisition module, a license plate information acquisition module, a central control module, an identity recognition module, a garbage classification module, a parking module, an express delivery module, an information release module, a consultation module and a display module;
the video monitoring module is connected with the central control module and used for monitoring the community video through the camera;
the household information acquisition module is connected with the central control module and is used for acquiring community household information;
the license plate information acquisition module is connected with the central control module and is used for acquiring the license plate information of the vehicles of the community households;
the central control module is connected with the video monitoring module, the resident information acquisition module, the license plate information acquisition module, the identity recognition module, the garbage classification module, the parking module, the express delivery module, the information release module, the consultation module and the display module and is used for controlling each module to work normally;
the identity recognition module is connected with the central control module and is used for carrying out identity recognition on community personnel through a recognition program;
the garbage classification module is connected with the central control module and is used for performing classification management on community garbage;
the parking module is connected with the central control module and is used for managing the parking of the community vehicles;
the express delivery module is connected with the central control module and is used for managing community express delivery;
the information publishing module is connected with the central control module and used for publishing community information through a publishing program;
the consultation module is connected with the central control module and is used for carrying out online consultation on the community information through a consultation program;
and the display module is connected with the central control module and used for displaying the monitoring video, the resident information, the license plate information, the identity recognition information, the garbage classification information, the parking information, the express delivery information, the release information and the consultation information through a display.
Further, the identification method of the identity identification module is as follows:
1) sending a geographic position information filling instruction to the intelligent terminal through the identification program; acquiring a terminal geographical position where the intelligent terminal is located and filled in by the intelligent terminal based on the geographical position information filling instruction, wherein the terminal geographical position comprises a terminal longitude value and a terminal latitude value;
2) acquiring a pre-acquired entrance guard geographic position of a target entrance guard in the intelligent community, wherein the entrance guard geographic position comprises an entrance guard longitude value and an entrance guard latitude value; converting the terminal longitude value and the terminal latitude value in the terminal geographic position into a terminal three-dimensional coordinate value of the terminal geographic position; converting the entrance guard longitude value and the entrance guard latitude value in the entrance guard geographic position into an entrance guard three-dimensional coordinate value of the entrance guard geographic position;
3) inputting the terminal three-dimensional coordinate value and the entrance guard three-dimensional coordinate value into a linear distance calculation formula to obtain a linear distance between the intelligent terminal and the target entrance guard;
the linear distance calculation formula is specifically as follows:
wherein D is the linear distance, XiIs the X-axis coordinate value, Y-axis coordinate value of the geographic position of the entrance guard in a spherical coordinate systemiFor in the spherical coordinate system the entrance guard placeY-axis coordinate value of physical position, ZiIs the Z-axis coordinate value, X, of the geographic position of the access control in the spherical coordinate systemjIs the X-axis coordinate value, Y-axis coordinate value of the geographic position of the entrance guard in a spherical coordinate systemjIs the Y-axis coordinate value, Z of the geographic position of the entrance guard in the spherical coordinate systemjThe coordinate value of the Z axis of the geographic position of the access control in the spherical coordinate system is obtained, and the spherical coordinate system is a coordinate system which is formed by taking the center of the sphere of the earth as an original point, the west direction of the earth as an X axis, the north direction as a Y axis and the direction vertical to the X axis and the Y axis as the Z axis;
4) acquiring the earth radius of the earth; inputting the linear distance and the earth radius into an included angle calculation formula to obtain a cosine value of a terminal entrance guard included angle formed by a connecting line between the intelligent terminal and the original point and a connecting line between the target entrance guard and the original point;
the included angle calculation formula specifically includes:
wherein,
the cosine value of the terminal entrance guard included angle is shown, D is the linear distance, and R is the radius of the earth;
5) acquiring a target included angle corresponding to the cosine value of the terminal entrance guard included angle as a terminal entrance guard included angle based on the cosine value angle corresponding relation; inputting the value of the terminal access control included angle and the earth radius into an earth distance calculation formula to obtain the earth distance between the intelligent terminal and the target access control;
the earth distance calculation formula specifically comprises:
wherein L is the distance from the earth,
the circumference ratio is R, the earth radius and theta are the value of the terminal entrance guard included angle;
6) and if the earth distance is less than or equal to the preset unlocking distance, the target entrance guard opens the entrance guard lock.
Further, the converting the terminal longitude value and the terminal latitude value in the terminal geographic position into a terminal three-dimensional coordinate value of the terminal geographic position comprises:
inputting the earth radius, the terminal longitude value and the terminal latitude value into a first coordinate conversion formula to obtain an X-axis coordinate value of the geographic position of the terminal in the spherical coordinate system;
the first coordinate conversion formula is specifically:
wherein, X is an X-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, Longtide is the longitude value of the terminal, and Latitude is the Latitude value of the terminal;
inputting the earth radius, the terminal longitude value and the terminal latitude value into a second coordinate conversion formula to obtain a Y-axis coordinate value of the geographic position of the entrance guard in the spherical coordinate system;
the second coordinate conversion formula is specifically:
wherein Y is a Y-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, Longtide is the longitude value of the terminal, and Latitude is the Latitude value of the terminal;
inputting the earth radius and the terminal latitude value into a third coordinate conversion formula to obtain a Z-axis coordinate value of the geographic position of the access control in the spherical coordinate system;
the third coordinate conversion formula is specifically:
wherein Z is a Z-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, and Latitude is the Latitude value of the terminal.
Further, the garbage classification module classification method comprises the following steps:
(1) configuring parameters of a community server, wherein the community server receives to-be-detected information sent by an intelligent garbage can, and the to-be-detected information comprises a garbage image of the to-be-detected garbage;
(2) the community server judges whether the garbage to be detected is bottle-shaped garbage or not according to the garbage image of the garbage to be detected; if so, the community server sends a collection instruction to the intelligent garbage can so that the intelligent garbage can collects acoustic characteristic parameters of the garbage to be detected;
(3) the community server determines the material of the garbage to be detected according to the acoustic characteristic parameters of the garbage to be detected;
(4) and the community server sends recovery reminding information to a reminding terminal, wherein the recovery reminding information comprises the material of the garbage to be detected.
Further, the acoustic characteristic parameters are reflected ultrasonic parameters of the garbage to be detected, and the step of determining the material of the garbage to be detected by the community server according to the acoustic characteristic parameters of the garbage to be detected comprises the following steps:
and (3.1) the community server searches the material related to the preset ultrasonic parameters matched with the reflected ultrasonic parameters in a material database.
Further, the information to be detected further comprises the equipment information of the intelligent garbage can, and the step that the community server sends the recovery reminding information to the reminding terminal comprises:
(4.1) the community server searches the personnel information associated with the equipment information in a personnel database so as to send recovery reminding information to the corresponding personnel terminal.
Further, the step of sending the recovery reminding information to the reminding terminal by the community server comprises:
and the community server searches the personnel information associated with the material in a personnel database so as to send recovery reminding information to the corresponding personnel terminal.
Further, the step that the community server judges whether the garbage to be detected is bottle-shaped garbage according to the garbage image of the garbage to be detected comprises the following steps:
and the community server judges whether the matching degree of the garbage image and the bottle-shaped image in the image database is greater than or equal to a threshold value.
The invention provides a computer-readable storage medium storing a computer program which, when executed by a processor, causes the processor to execute the method for smart community management based on a time series database.
The invention has the advantages and positive effects that: the method comprises the steps of firstly, accurately obtaining a terminal longitude value and a terminal latitude value of a terminal geographic position of an intelligent terminal through an identity recognition module, obtaining an entrance guard longitude value and an entrance guard latitude value of an entrance guard geographic position of a target entrance guard in a smart community, then converting the terminal longitude value and the terminal latitude value of the terminal geographic position into a terminal three-dimensional coordinate value of the terminal geographic position, converting the entrance guard longitude value and the entrance guard latitude value of the entrance guard geographic position into an entrance guard three-dimensional coordinate value of the entrance guard geographic position, and then inputting the terminal three-dimensional coordinate value and the entrance guard three-dimensional coordinate value into a linear distance calculation formula to quickly obtain the linear distance between the intelligent terminal and the target entrance guard; then inputting the linear distance and the radius of the earth into an included angle calculation formula, quickly obtaining a cosine value of a terminal entrance guard included angle formed by a connecting line between the intelligent terminal and the original point and a connecting line between the target entrance guard and the original point, accurately obtaining a target included angle corresponding to the cosine value of the terminal entrance guard included angle as the terminal entrance guard included angle based on the corresponding relation of the cosine value and the angle, then inputting the terminal entrance guard included angle and the radius of the earth into the earth distance calculation formula, accurately obtaining the earth distance between the intelligent terminal and the target entrance guard, and finally opening the entrance guard lock by the target entrance guard if the earth distance is less than or equal to a preset unlocking distance, so that the entrance guard lock can be quickly controlled to be opened only by detecting that the distance between the intelligent terminal and the entrance guard meets a preset condition, and the defect that the entrance guard lock cannot be controlled to be opened based on face identification in the prior art is avoided, the accuracy of the identity recognition of the entrance guard in the intelligent community is improved; meanwhile, receiving to-be-detected information sent by the intelligent garbage can through a garbage classification module according to a community server, wherein the to-be-detected information comprises a garbage image of to-be-detected garbage; the community server judges whether the garbage to be detected is bottle-shaped garbage or not according to the garbage image of the garbage to be detected; if so, the community server sends a collection instruction to the intelligent garbage can so that the intelligent garbage can collects acoustic characteristic parameters of the garbage to be detected; the community server determines the material of the garbage to be detected according to the acoustic characteristic parameters of the garbage to be detected; the community server sends the recovery reminding information to the reminding terminal, the recovery reminding information comprises a method for detecting the material of garbage to be detected, so that community workers can recover bottle-shaped garbage made of different materials in time according to the reminding information, classification and recovery of the bottle-shaped garbage are realized, the risk that the bottle-shaped garbage is damaged to the community workers due to the fact that the garbage in the intelligent garbage can is recovered by one-time cleaning is reduced or even eliminated, and protection of the community workers is improved.
Drawings
FIG. 1 is a block diagram of a system for managing smart communities based on a time-series database according to an embodiment of the present invention;
FIG. 2 is a flow chart of a method for identifying an identity module according to an embodiment of the present invention;
FIG. 3 is a flowchart of a garbage classification module classification method according to an embodiment of the present invention;
fig. 4 is a flowchart of a method in which the acoustic characteristic parameter provided in the embodiment of the present invention is a reflected ultrasonic parameter of the to-be-detected trash, and the community server determines a material of the to-be-detected trash according to the acoustic characteristic parameter of the to-be-detected trash;
fig. 5 is a flowchart of a method for sending, by a community server, recovery reminding information to a reminding terminal, where information to be detected further includes device information of the intelligent trash can according to the embodiment of the present invention;
in fig. 1: 1. a video monitoring module; 2. a resident information acquisition module; 3. the license plate information acquisition module; 4. a central control module; 5. an identity recognition module; 6. a garbage classification module; 7. a parking module; 8. an express delivery module; 9. an information release module; 10. a consultation module; 11. and a display module.
Detailed Description
In order to further understand the contents, features and effects of the present invention, the following embodiments are illustrated and described in detail with reference to the accompanying drawings.
The invention provides a time sequence database-based intelligent community management method, which comprises the following steps:
n (0) = 0, i.e., no data is published within 0 s;
{N(t) t 0 has no memory, and the data issued in disjoint time intervals are independent of each other, i.e. arbitraryn A time 0< t1<t2 < ……< tnRandom variableN(t1) - N(0)，N(t2) - N(t1)，……，N(tn) -N(tn-1) are independent of each other;
{N(t) t 0 has a steady increment of (A), (B), (C), (Dt，t + △t) The amount of data released in-flight is only related to the time interval deltat In relation to timet Irrelevant;
in the formula: x (k) is the input of the adaptive filter, y (k) is the output of the adaptive filter, d (k) is the reference signal, e (k) is the error, WiIs the weight coefficient of the filter, mu is the step length, M is the order of the filter;
dividing bit sequence of random code separated data into
The bit rate is fast, and the length to be detected is defined as
Has a bit sequence of
(ii) a Obtaining directional dimensions of different mapping iteration vector features
；
And 6, displaying the monitoring video, the resident information, the license plate information, the identity identification information, the garbage classification information, the parking information, the express delivery information, the release information and the consultation information through a display.
The structure of the present invention will be described in detail below with reference to the accompanying drawings.
As shown in fig. 1, the intelligent community management system based on a time-series database according to an embodiment of the present invention includes: the system comprises a video monitoring module 1, a resident information acquisition module 2, a license plate information acquisition module 3, a central control module 4, an identity recognition module 5, a garbage classification module 6, a parking module 7, an express delivery module 8, an information release module 9, a consultation module 10 and a display module 11.
The video monitoring module 1 is connected with the central control module 4 and used for monitoring community videos through a camera;
the household information acquisition module 2 is connected with the central control module 4 and is used for acquiring community household information;
the license plate information acquisition module 3 is connected with the central control module 4 and is used for acquiring the license plate information of the vehicles of the community households;
the central control module 4 is connected with the video monitoring module 1, the resident information acquisition module 2, the license plate information acquisition module 3, the identity recognition module 5, the garbage classification module 6, the parking module 7, the express delivery module 8, the information release module 9, the consultation module 10 and the display module 11 and is used for controlling the normal work of each module;
the identity recognition module 5 is connected with the central control module 4 and is used for carrying out identity recognition on community personnel through a recognition program;
the garbage classification module 6 is connected with the central control module 4 and is used for carrying out classification management on the community garbage;
the parking module 7 is connected with the central control module 4 and is used for managing the parking of the community vehicles;
the express delivery module 8 is connected with the central control module 4 and is used for managing community express delivery;
the information publishing module 9 is connected with the central control module 4 and is used for publishing community information through a publishing program;
the consultation module 10 is connected with the central control module 4 and is used for carrying out online consultation on the community information through a consultation program;
and the display module 11 is connected with the central control module 4 and used for displaying the monitoring video, the resident information, the license plate information, the identity identification information, the garbage classification information, the parking information, the express delivery information, the release information and the consultation information through a display.
As shown in fig. 2, the identification method of the identity module 5 provided by the present invention is as follows:
s101, sending a geographic position information filling instruction to the intelligent terminal through an identification program; acquiring a terminal geographical position where the intelligent terminal is located and filled in by the intelligent terminal based on the geographical position information filling instruction, wherein the terminal geographical position comprises a terminal longitude value and a terminal latitude value;
s102, acquiring a pre-acquired entrance guard geographical position of a target entrance guard in the intelligent community, wherein the entrance guard geographical position comprises an entrance guard longitude value and an entrance guard latitude value; converting the terminal longitude value and the terminal latitude value in the terminal geographic position into a terminal three-dimensional coordinate value of the terminal geographic position; converting the entrance guard longitude value and the entrance guard latitude value in the entrance guard geographic position into an entrance guard three-dimensional coordinate value of the entrance guard geographic position;
s103, inputting the terminal three-dimensional coordinate value and the entrance guard three-dimensional coordinate value into a linear distance calculation formula to obtain a linear distance between the intelligent terminal and the target entrance guard;
the linear distance calculation formula is specifically as follows:
wherein D is the linear distance, XiIs the X-axis coordinate value, Y-axis coordinate value of the geographic position of the entrance guard in a spherical coordinate systemiIs the Y-axis coordinate value, Z of the geographic position of the entrance guard in the spherical coordinate systemiIs the Z-axis coordinate value, X, of the geographic position of the access control in the spherical coordinate systemjIs the X-axis coordinate value, Y-axis coordinate value of the geographic position of the entrance guard in a spherical coordinate systemjIs the Y-axis coordinate value, Z of the geographic position of the entrance guard in the spherical coordinate systemjThe coordinate value of the Z axis of the geographic position of the access control in the spherical coordinate system is obtained, and the spherical coordinate system is a coordinate system which is formed by taking the center of the sphere of the earth as an original point, the west direction of the earth as an X axis, the north direction as a Y axis and the direction vertical to the X axis and the Y axis as the Z axis;
s104, acquiring the earth radius of the earth; inputting the linear distance and the earth radius into an included angle calculation formula to obtain a cosine value of a terminal entrance guard included angle formed by a connecting line between the intelligent terminal and the original point and a connecting line between the target entrance guard and the original point;
the included angle calculation formula specifically includes:
wherein,
the cosine value of the terminal entrance guard included angle is shown, D is the linear distance, and R is the radius of the earth;
s105, acquiring a target included angle corresponding to the cosine value of the terminal entrance guard included angle as the terminal entrance guard included angle based on the cosine value angle corresponding relation; inputting the value of the terminal access control included angle and the earth radius into an earth distance calculation formula to obtain the earth distance between the intelligent terminal and the target access control;
the earth distance calculation formula specifically comprises:
wherein L is the distance from the earth,
the circumference ratio is R, the earth radius and theta are the value of the terminal entrance guard included angle;
and S106, if the earth distance is less than or equal to a preset unlocking distance, the target entrance guard opens the entrance guard lock.
The method for converting the terminal longitude value and the terminal latitude value in the terminal geographic position into the terminal three-dimensional coordinate value of the terminal geographic position comprises the following steps:
inputting the earth radius, the terminal longitude value and the terminal latitude value into a first coordinate conversion formula to obtain an X-axis coordinate value of the geographic position of the terminal in the spherical coordinate system;
the first coordinate conversion formula is specifically:
wherein, X is an X-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, Longtide is the longitude value of the terminal, and Latitude is the Latitude value of the terminal;
inputting the earth radius, the terminal longitude value and the terminal latitude value into a second coordinate conversion formula to obtain a Y-axis coordinate value of the geographic position of the entrance guard in the spherical coordinate system;
the second coordinate conversion formula is specifically:
wherein Y is a Y-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, Longtide is the longitude value of the terminal, and Latitude is the Latitude value of the terminal;
inputting the earth radius and the terminal latitude value into a third coordinate conversion formula to obtain a Z-axis coordinate value of the geographic position of the access control in the spherical coordinate system;
the third coordinate conversion formula is specifically:
wherein Z is a Z-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, and Latitude is the Latitude value of the terminal.
As shown in fig. 3, the classification method of the garbage classification module 6 provided by the present invention is as follows:
s201, configuring parameters of a community server, wherein the community server receives to-be-detected information sent by an intelligent garbage can, and the to-be-detected information comprises a garbage image of the to-be-detected garbage;
s202, the community server judges whether the garbage to be detected is bottle-shaped garbage according to the garbage image of the garbage to be detected; if so, the community server sends a collection instruction to the intelligent garbage can so that the intelligent garbage can collects acoustic characteristic parameters of the garbage to be detected;
s203, the community server determines the material of the garbage to be detected according to the acoustic characteristic parameters of the garbage to be detected;
s204, the community server sends recovery reminding information to a reminding terminal, and the recovery reminding information comprises the material of the garbage to be detected.
As shown in fig. 4, the acoustic characteristic parameters provided by the present invention are reflected ultrasonic parameters of the garbage to be detected, and the step of determining the material of the garbage to be detected by the community server according to the acoustic characteristic parameters of the garbage to be detected includes:
s301, the community server searches materials related to the preset ultrasonic parameters matched with the reflected ultrasonic parameters in a material database.
As shown in fig. 5, the information to be detected provided by the present invention further includes device information of the intelligent trash can, and the step of sending the recovery reminding information to the reminding terminal by the community server includes:
s401, the community server searches the personnel information associated with the equipment information in a personnel database so as to send recovery reminding information to the corresponding personnel terminal.
The steps of the community server provided by the invention for sending the recovery reminding information to the reminding terminal comprise:
and the community server searches the personnel information associated with the material in a personnel database so as to send recovery reminding information to the corresponding personnel terminal.
The community server provided by the invention judges whether the garbage to be detected is bottle-shaped garbage according to the garbage image of the garbage to be detected, and the steps comprise:
and the community server judges whether the matching degree of the garbage image and the bottle-shaped image in the image database is greater than or equal to a threshold value.
When the system works, firstly, a video monitoring module 1 monitors community videos by using a camera; community resident information is collected through the resident information collecting module 2; the license plate information of the community resident vehicles is collected through the license plate information collecting module 3; secondly, the central control module 4 identifies the identities of community personnel through the identity identification module 5 by using an identification program; carrying out classification management on community garbage through a garbage classification module 6; the parking module 7 is used for managing the parking of the community vehicles; managing community express delivery through an express delivery module 8; community information is released by a releasing program through an information releasing module 9; then, the community information is consulted online by the consultation module 10 by utilizing a consultation program; finally, the display module 11 is used for displaying the monitoring video, the resident information, the license plate information, the identification information, the garbage classification information, the parking information, the express delivery information, the release information and the consultation information.
The above description is only for the preferred embodiment of the present invention, and is not intended to limit the present invention in any way, and all simple modifications, equivalent changes and modifications made to the above embodiment according to the technical spirit of the present invention are within the scope of the technical solution of the present invention.
Claims (10)
1. A smart community management method based on a time sequence database is characterized by comprising the following steps:
collecting community resident information, community resident vehicle license plate information, community garbage classification management information, community vehicle parking management information and community express delivery management information;
monitoring the collected community information through a camera, and identifying the identity of community personnel through an identification program;
step two, releasing community information through a release program; the community information is consulted online through a consultation program, and the consultation method comprises the following steps: obtaining published community information, orderN(t) Which represents the time (0,t) The data size of internal release is as follows:
n (0) = 0, i.e., no data is published within 0 s;
{N(t) t 0 has no memory, and the data issued in disjoint time intervals are independent of each other, i.e. arbitraryn A time 0< t1<t2 < ……< tnRandom variableN(t1) - N(0)，N(t2) - N(t1)，……，N(tn) -N(tn -1) are independent of each other;
{N(t) t 0 has a steady increment of (A), (B), (C), (Dt，t + △t) The amount of data released in-flight is only related to the time interval deltat In relation to timet Irrelevant;
after login is successful, consulting information is operated through a touch screen; the touch screen adopts a self-adaptive filtering method to filter the consultation information, and specifically comprises the following steps:
in the formula: x (k) is the input of the adaptive filter, y (k) is the output of the adaptive filter, d (k) is the reference signal, e (k) is the error, WiIs the weight coefficient of the filter, mu is the step length, M is the order of the filter;
after filtering, multi-state distribution characteristic calculation is carried out on the advisory data, continuous iteration updating is introduced, noise characteristics are extracted, and the noise and the real advisory data are separated to obtain accurate information output by a bit sequence, wherein the bit sequence is as follows:
dividing bit sequence of random code separated data into
The bit rate is fast, and the length to be detected is defined as
Has a bit sequence of
(ii) a Obtaining directional dimensions of different mapping iteration vector features
；
And step three, displaying the monitoring video, the resident information, the license plate information, the identity identification information, the garbage classification information, the parking information, the express delivery information, the release information and the consultation information through a display.
2. The intelligent community management method based on time-series database as claimed in claim 1, wherein said step of an identity recognition method comprises:
1) sending a geographic position information filling instruction to the intelligent terminal through the identification program; acquiring a terminal geographical position where the intelligent terminal is located and filled in by the intelligent terminal based on the geographical position information filling instruction, wherein the terminal geographical position comprises a terminal longitude value and a terminal latitude value;
2) acquiring a pre-acquired entrance guard geographic position of a target entrance guard in the intelligent community, wherein the entrance guard geographic position comprises an entrance guard longitude value and an entrance guard latitude value; converting the terminal longitude value and the terminal latitude value in the terminal geographic position into a terminal three-dimensional coordinate value of the terminal geographic position; converting the entrance guard longitude value and the entrance guard latitude value in the entrance guard geographic position into an entrance guard three-dimensional coordinate value of the entrance guard geographic position;
3) inputting the terminal three-dimensional coordinate value and the entrance guard three-dimensional coordinate value into a linear distance calculation formula to obtain a linear distance between the intelligent terminal and the target entrance guard;
the linear distance calculation formula is specifically as follows:
wherein D is the linear distance, XiIs the X-axis coordinate value, Y-axis coordinate value of the geographic position of the entrance guard in a spherical coordinate systemiIs the Y-axis coordinate value, Z of the geographic position of the entrance guard in the spherical coordinate systemiIs the Z-axis coordinate value, X, of the geographic position of the access control in the spherical coordinate systemjIs the X-axis coordinate value, Y-axis coordinate value of the geographic position of the entrance guard in a spherical coordinate systemjIs the Y-axis coordinate value of the geographic position of the entrance guard in the spherical coordinate system，ZjThe coordinate value of the Z axis of the geographic position of the access control in the spherical coordinate system is obtained, and the spherical coordinate system is a coordinate system which is formed by taking the center of the sphere of the earth as an original point, the west direction of the earth as an X axis, the north direction as a Y axis and the direction vertical to the X axis and the Y axis as the Z axis;
4) acquiring the earth radius of the earth; inputting the linear distance and the earth radius into an included angle calculation formula to obtain a cosine value of a terminal entrance guard included angle formed by a connecting line between the intelligent terminal and the original point and a connecting line between the target entrance guard and the original point;
the included angle calculation formula specifically includes:
wherein,
the cosine value of the terminal entrance guard included angle is shown, D is the linear distance, and R is the radius of the earth;
5) acquiring a target included angle corresponding to the cosine value of the terminal entrance guard included angle as a terminal entrance guard included angle based on the cosine value angle corresponding relation; inputting the value of the terminal access control included angle and the earth radius into an earth distance calculation formula to obtain the earth distance between the intelligent terminal and the target access control;
the earth distance calculation formula specifically comprises:
wherein L is the distance from the earth,
the circumference ratio is R, the earth radius and theta are the value of the terminal entrance guard included angle;
6) and if the earth distance is less than or equal to the preset unlocking distance, the target entrance guard opens the entrance guard lock.
3. The method as claimed in claim 2, wherein the converting the terminal longitude value and the terminal latitude value in the terminal geographical location into a terminal three-dimensional coordinate value of the terminal geographical location comprises:
inputting the earth radius, the terminal longitude value and the terminal latitude value into a first coordinate conversion formula to obtain an X-axis coordinate value of the geographic position of the terminal in the spherical coordinate system;
the first coordinate conversion formula is specifically:
wherein, X is an X-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, Longtide is the longitude value of the terminal, and Latitude is the Latitude value of the terminal;
inputting the earth radius, the terminal longitude value and the terminal latitude value into a second coordinate conversion formula to obtain a Y-axis coordinate value of the geographic position of the entrance guard in the spherical coordinate system;
the second coordinate conversion formula is specifically:
wherein Y is a Y-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, Longtide is the longitude value of the terminal, and Latitude is the Latitude value of the terminal;
inputting the earth radius and the terminal latitude value into a third coordinate conversion formula to obtain a Z-axis coordinate value of the geographic position of the access control in the spherical coordinate system;
the third coordinate conversion formula is specifically:
wherein Z is a Z-axis coordinate value of the geographic position of the terminal in the spherical coordinate system, and Latitude is the Latitude value of the terminal.
4. The intelligent community management method based on time series database as claimed in claim 1, wherein the garbage classification module comprises the following classification methods:
(1) configuring parameters of a community server, wherein the community server receives to-be-detected information sent by an intelligent garbage can, and the to-be-detected information comprises a garbage image of the to-be-detected garbage;
(2) the community server judges whether the garbage to be detected is bottle-shaped garbage or not according to the garbage image of the garbage to be detected; if so, the community server sends a collection instruction to the intelligent garbage can so that the intelligent garbage can collects acoustic characteristic parameters of the garbage to be detected;
(3) the community server determines the material of the garbage to be detected according to the acoustic characteristic parameters of the garbage to be detected;
(4) and the community server sends recovery reminding information to a reminding terminal, wherein the recovery reminding information comprises the material of the garbage to be detected.
5. The intelligent community management method based on the time-series database according to claim 4, wherein the acoustic characteristic parameters are reflected ultrasonic parameters of the garbage to be detected, and the step of the community server determining the material of the garbage to be detected according to the acoustic characteristic parameters of the garbage to be detected comprises:
and (3.1) the community server searches the material related to the preset ultrasonic parameters matched with the reflected ultrasonic parameters in a material database.
6. The intelligent community management method based on the time sequence database as claimed in claim 4, wherein the information to be detected further comprises device information of the intelligent trash can, and the step of sending the recovery reminding information to the reminding terminal by the community server comprises:
(4.1) the community server searches the personnel information associated with the equipment information in a personnel database so as to send recovery reminding information to the corresponding personnel terminal.
7. The intelligent community management method based on the time-series database as claimed in claim 4, wherein the step of sending the recovery reminding information to the reminding terminal by the community server comprises:
and the community server searches the personnel information associated with the material in a personnel database so as to send recovery reminding information to the corresponding personnel terminal.
8. The intelligent community management method based on the time sequence database as claimed in claim 4, wherein the step of the community server determining whether the garbage to be detected is bottle-shaped garbage according to the garbage image of the garbage to be detected comprises:
and the community server judges whether the matching degree of the garbage image and the bottle-shaped image in the image database is greater than or equal to a threshold value.
9. A time sequence database-based intelligent community management system is characterized in that the time sequence database-based intelligent community management system comprises:
the video monitoring module is connected with the central control module and used for monitoring the community video through the camera;
the household information acquisition module is connected with the central control module and is used for acquiring community household information;
the license plate information acquisition module is connected with the central control module and is used for acquiring the license plate information of the vehicles of the community households;
the central control module is connected with the video monitoring module, the resident information acquisition module, the license plate information acquisition module, the identity recognition module, the garbage classification module, the parking module, the express delivery module, the information release module, the consultation module and the display module and is used for controlling each module to work normally;
the identity recognition module is connected with the central control module and is used for carrying out identity recognition on community personnel through a recognition program;
the garbage classification module is connected with the central control module and is used for performing classification management on community garbage;
the parking module is connected with the central control module and is used for managing the parking of the community vehicles;
the express delivery module is connected with the central control module and is used for managing community express delivery;
the information publishing module is connected with the central control module and used for publishing community information through a publishing program;
the consultation module is connected with the central control module and is used for carrying out online consultation on the community information through a consultation program;
and the display module is connected with the central control module and used for displaying the monitoring video, the resident information, the license plate information, the identity recognition information, the garbage classification information, the parking information, the express delivery information, the release information and the consultation information through a display.
10. A computer-readable storage medium storing a computer program which, when executed by a processor, causes the processor to execute the method for smart community management based on a time-series database according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110407226.3A CN113111790A (en) | 2021-04-15 | 2021-04-15 | Intelligent community management system, method and storage medium based on time sequence database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110407226.3A CN113111790A (en) | 2021-04-15 | 2021-04-15 | Intelligent community management system, method and storage medium based on time sequence database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113111790A true CN113111790A (en) | 2021-07-13 |
Family
ID=76717411
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110407226.3A Pending CN113111790A (en) | 2021-04-15 | 2021-04-15 | Intelligent community management system, method and storage medium based on time sequence database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113111790A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114022984A (en) * | 2021-09-29 | 2022-02-08 | 中国移动通信集团浙江有限公司杭州分公司 | Intelligent community personnel supervision and logistics service system based on wireless communication |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109326238A (en) * | 2018-10-22 | 2019-02-12 | 张珈瑞 | One kind being used for enterprise e-commerce consultation service control system and method |
| CN110766844A (en) * | 2019-12-30 | 2020-02-07 | 恒大智慧科技有限公司 | Identity recognition method and equipment for entrance guard in intelligent community and readable storage medium |
| CN111191504A (en) * | 2019-11-26 | 2020-05-22 | 恒大智慧科技有限公司 | Community garbage classification processing and system and computer readable storage medium |
| US20200184521A1 (en) * | 2018-12-11 | 2020-06-11 | Ravi Bhanabhai | Method and system for initiating an interface concurrent with generation of a transitory sentiment community |
-
2021
- 2021-04-15 CN CN202110407226.3A patent/CN113111790A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109326238A (en) * | 2018-10-22 | 2019-02-12 | 张珈瑞 | One kind being used for enterprise e-commerce consultation service control system and method |
| US20200184521A1 (en) * | 2018-12-11 | 2020-06-11 | Ravi Bhanabhai | Method and system for initiating an interface concurrent with generation of a transitory sentiment community |
| CN111191504A (en) * | 2019-11-26 | 2020-05-22 | 恒大智慧科技有限公司 | Community garbage classification processing and system and computer readable storage medium |
| CN110766844A (en) * | 2019-12-30 | 2020-02-07 | 恒大智慧科技有限公司 | Identity recognition method and equipment for entrance guard in intelligent community and readable storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114022984A (en) * | 2021-09-29 | 2022-02-08 | 中国移动通信集团浙江有限公司杭州分公司 | Intelligent community personnel supervision and logistics service system based on wireless communication |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107742099A (en) | A kind of crowd density estimation based on full convolutional network, the method for demographics | |
| Michalak | GIS in land use change analysis: integration of remotely sensed data into GIS | |
| CN103593654B (en) | A kind of method and apparatus of Face detection | |
| CN109117745A (en) | Cloud face recognition and positioning method based on building information model | |
| CN108495095B (en) | Haze diffusion monitoring system based on unmanned aerial vehicle | |
| CN109670449B (en) | Vehicle illegal judgment method based on vertical snapshot mode | |
| CN112241844B (en) | Method and device for determining and updating environmental risk source background list of drinking water source area | |
| CN113111790A (en) | Intelligent community management system, method and storage medium based on time sequence database | |
| CN111523776A (en) | Smart city system and method based on illegal target risk assessment | |
| CN114229279B (en) | Intelligent garbage room capable of realizing garbage classification behavior supervision | |
| Lu et al. | An efficient network for multi-scale and overlapped wildlife detection | |
| CN117284663B (en) | Garden garbage treatment system and method | |
| CN114038049A (en) | Driver behavior feature extraction and discrimination method based on edge calculation | |
| CN116384844B (en) | Decision method and device based on geographic information cloud platform | |
| CN115691140B (en) | Analysis and prediction method for space-time distribution of automobile charging demand | |
| CN117115728A (en) | Risk identification method and system applied to field operation of transformer substation | |
| CN110765900A (en) | DSSD-based automatic illegal building detection method and system | |
| Galba et al. | Public transportation bigdata clustering | |
| Liu et al. | The classification of airborne LiDAR building point clouds based on multi‐scale and multi‐level cloth simulation | |
| CN109282791A (en) | For surveying and drawing the method and information system in section | |
| CN103870815A (en) | Mancar structural description method and system for dome camera video monitoring | |
| Pendyala et al. | Comparative Study of Automatic Urban Building Extraction Methods from Remote Sensing Data | |
| Chen et al. | FedRME: Federated Road Markings Extraction from Mobile LiDAR Point Clouds | |
| Hao et al. | Real-time data-driven trajectory reconstruction based on rough set theory. | |
| CN113419140B (en) | Distribution network line fault diagnosis method and device considering human-computer-object cooperation |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210713 |