1 Street lamps in urban lighting are an important part and important part of urban infrastructure. With the acceleration of urbanization, power consumption and electricity costs are rising day by day, and China's energy problems are becoming more and more tense. Saving energy and improving utilization efficiency are one of the main tasks of domestic energy development. Through the integration of the prior art to achieve energy-saving effects and improve the management level of the street lamp system, energy saving, comfort and environmental protection effects are achieved. This is very important to alleviate the tension in energy supply and protect the environment.
At present, the development of street lighting monitoring systems in most cities in China is not perfect. The application of GIS is less and less. In view of this, this paper focuses on the application and key technologies of GIS in street lighting energy-saving monitoring system, and uses GIS technology to establish urban street lights. The geographic information subsystem combines the geographical space information of the street lamp with the text information. The user can directly operate the street light object (such as query and analysis) on the map interface, and can grasp the running status of the lighting system in real time and manage the working street lamp monitoring device. Remote control of street light brightness, change the backward manual inspection mode, unattended, quickly find street lamp failure, theft, etc. and can actively alarm, the control center station can notify the staff to handle the fault in time, with higher intuitiveness, do Go to the city's street lights "under your grasp."
2 Overview of GIS and SupermapOb-jects
Geographic Information System (GIS) is a newly developed emerging edge discipline that integrates computer science, geography, surveying and mapping, environmental science, urban science, space science, information science, and management science. It is a computer system that uses modern computer graphics and database technology to process space and its related data. Its greatest feature is that it can digitally and organically map various information and spatial locations, spatial distributions and spatial relationships of natural processes and human social activities. Combined, and visually displayed through the screen image, this feature makes GIS more widely used. This paper is a typical application of GIS in urban facilities.
The development of GIS technology has experienced the process of component GIS in the software mode through functional modules, package software and core software. Component GIS refers to a component-based platform with a standard interface that allows cross-language applications, thus making GIS software more configurable, scalable, and open, more flexible to use, and more convenient for secondary development.
The domestic GIS software SupermapObjects is an open component-based platform for secondary development. It consists of a series of ActiveX components, including core components, layout components, 3D components and other detachable component libraries. This component is easy to integrate and expand, and has strong scalability. It can be easily integrated with office automation, management information system and other professional software technologies to integrate GIS technology into common information technology.
System Design of 3GIS in the Application of Street Lamp Energy-saving Monitoring System
3.1 Design ideas
Using the GIS subsystem as part of the main monitoring program, the GIS component, Delphi7.0 and database SQLServer2000 in Supmap Objects5 are used as development tools. The function is to combine the street lamp device information with its location to make the graphics and database integrated. , to achieve various functions in the monitoring subsystem.
3.2 data implementation
3.2.1 Data organization and establishment
The data mainly refers to several layer information corresponding to the electronic map, including attribute information and spatial information. Because the city has a number of street lights, the amount of data is large, in order to process large amounts of data, while sharing data with other modules, this subsystem uses SQL Server relational database to store and manage all data, including spatial data, attribute data and metadata, completely out of the file system It also got rid of the limitations imposed by the file system management model.
3.2.2 Data Access
See 1 to access the SQL Server spatial database directly using the SDX+ spatial database engine. This access method has the following advantages:
First, it ensures the security of the application of data GIS in the street lamp energy-saving monitoring system; secondly, it has achieved a long transaction management mode. This mode has all the advantages of common transactions and avoids the limitations of common transactions. Third, it has the ability of online concurrent operation, sharing data among multiple modules, browsing and editing data at the same time, and transmitting data to each other in time, which not only greatly improves work efficiency, but also ensures better data integrity. .
3.2.3 Data modification
Directly operate the street light or controller object in the electronic map, change its corresponding attribute or space information, it will automatically modify the contents of the database to achieve data modification.
3.3 module diagram
(see 2)
2 subsystem module diagram
3.4 Functional Description
As an important part of the main monitoring system, subsystems, in addition to the basic functions of GIS, focus on combining GIS technology with environmental protection and energy saving business (mainly for street lamp energy saving and monitoring), and realize the full-view browsing function of Hawkeye. , a variety of information integration functions and the function of two-way query between database and graphics, SMS short message service, fault alarm, fast positioning, buffer analysis, spatial statistical analysis, etc., as follows:
(1) Map operation:
Complete the functions of zooming in, zooming out, roaming, full picture, eagle eye, selection and editing of the electronic map.
(2) Inquiry:
Attribute search and graph check attributes, the corresponding attribute information can be queried by retrieving spatial data; the same attribute data can be retrieved to query corresponding spatial information.
(3) Attributes:
The attribute data of the street lamp and the terminal controller can be viewed and modified, and clicking an item will be displayed in the map.
(4) Tools:
Buffer analysis and distance measurement, buffer analysis can display street light information in the vicinity of the selected object, giving the user a reference; and distance measurement indicates the distance between the two selected points.
(5) Alarm handling:
There are two functions of SMS function and fast positioning. SMS is the short message service function, which informs the staff of the fault type and information by SMS. The fast positioning is the location where the fault information is accurately displayed in the electronic map.
(6) Statistical printing:
GIS can provide various statistical data. Through fault geographic graphs and attribute analysis, it can visually display the type, specific content and location of the fault, so that the staff can know the operation of the equipment in time. The subsystem runs the main interface (see 3).
4 key technologies
4.1 Data Sharing Technology
This subsystem is only a sub-module in the street lamp energy-saving monitoring system, as well as other modules such as data acquisition, which has data sharing problems. The data exists in the SqlServer database. How to realize the data sharing and real-time communication technology between the system and other subsystems is a key technical issue of this subsystem.
To do this, take the view method (4) and create a view that associates the main fields of several tables, such as voltage and current, with the streetlight layer table (unique by ID number), as shown in Figure 4, in the street light diagram. Select LightID, location, etc. in the layer table, and select Curren in the ammeter, select Voltage and time in the voltmeter, filter the time field, select the latest data, selecttop1*from table name whereid=xyz orderbydatedesc, in the streetlight layer The SmTableName table name is taken as the LampView (view name), so that the data in the current and voltage table is associated, and the data can be seen when viewing the street lamp attribute data in the electronic map.
Because the view method is adopted, any module modifies the data, and it will be reflected in the table in time. That is, when the current voltmeter is changed, the data in the LampView will be updated in time; in turn, the street light is modified in the electronic map. The attribute value, it can also immediately save the changed data in the current and voltage meter, so that the two sides maintain real-time data communication.
4.2 short message service
At present, the application of mobile short messages is more and more widely. One of the features of this subsystem is to apply this technology to the short message alarm function of mobile phones. As long as the mobile phone and the computer are connected to the serial port through the infrared port or by using the mobile phone data cable, the short message can be sent through the self-programmed short message sending software.
Design ideas:
The thread is used to send and receive short messages, and the short message to be sent is saved in a linked list. The thread sends out the short message to be sent, and calls the short message type. This type of short message is organized into a short message in pdu format, and the AT command is used to communicate with the GSM device. The GSM device sends and reads text messages. The key to this type is the encoding and decoding of text messages with reference to the GSM standard, as well as the communication of GSM devices.
Introduction to the GSMAT Directive:
The directive is a set of instructions developed by Nokia, Ericsson, Motorola and HP for the GSM system, including control of SMS (ShortMessageService). There are three ways to control SMS: BlockMode; TextMode based on AT command; PDU Mode based on AT command. Currently, PDU has replaced BlockMode. This document mainly discusses PDU mode. AT+CMGF=0 means set to PDU mode.
PDU Profile: PDU mode is a method of sending or receiving SMS messages from mobile phones.
The message body is transmitted after hexadecimal encoding.
The PDU commands are AT+CMGR, AT+CMGL, AT+CMGS. For example, if all unread SMS messages on the phone are read, AT+CMGL=0; and AT+CMGL=4 means that all SMS messages are read.
Encoding: The content to be sent is generally "Chinese short message", while Chinese characters are represented by Unicode code. Chinese characters must be converted to Unicode code before sending Chinese short messages.
In Delphi7.0, you can use the WideString type to subtly implement GB2312 to Unicode encoding conversion, which is done by the function gsmEncodeUcs2().
Decoding: Compared to encoding, decoding is to convert the received Unicode code into Chinese characters, which is done by the function gsmDecodeUcs2().
Serial communication: In Delphi, you can use the serial port control "mscomm" to send AT commands to the mobile phone modem. There are several key points in this control. First, set the SMS center number, comm.output:='AT+CSCA=+8613800xxxx00'+cnReturn; Then check if the SMS service is supported, comm.output:='AT+CSMS=0'+cnReturn; then set the modem to PDU mode, comm.
Output:='AT+CMGF=0'+cnReturn; Finally set the character set and send the command cmd:='AT+CSCS=GSM'+cnReturn;comm.output:='AT+CMGS=length'+cnReturn.
5 Conclusion
This subsystem makes full use of GIS technology to realize the functions of street lamp and line time monitoring, remote switch, fault location, automatic alarm, etc. Through remote switch, energy saving can be achieved. It is characterized by low operating costs and can be run on only one computer; it is easy to maintain and expand. If you want to check the running status of the streetlights if you are on a business trip, you can extend the existing stand-alone version to the Internet version. This subsystem can be applied to the street lamp management office of each city, and can be modified according to the needs of actual users. Its solution is suitable for more fields, such as equipment management in the power telecommunications sector, engineering design of road traffic, water supply, emergency repair, daily maintenance, etc., with the help of GIS, it can greatly improve work efficiency.
The author of this article is innovative: unattended, fault location, SMS short message automatic alarm.
Home and indoor or building air filters remove unwanted particles like dust, pollen, pet dander and mold and ensure even the most allergy prone can breathe easily year–round. However, choosing the right filter for your home can be a rather involved process. To help, here are the most common indoor air filters and what each of them provides. The filters are the simplest basic component for air filtration solution through your heating and cooling system ,It is important that you constantly monitor the buildup of debris on these filters as well because it can easily be recycled into the air supply. It is easy change and maintain.
Indoor Air Purification Filter & Air purifier filter
Air Filter, Indoor Air Purification Filter,Building Air Purification Filter,Panel Air Filter
Donguan Bronco Filter Co., Ltd , https://www.broncofilter-cn.com