database on municipal street lighting system - software...

Database on

Municipal Street Lighting System -

Software Tool

03.05.2011 Seite 1

GIZ Project “Strengthening Local Self-Government”

Software Tool

Podgorica, April 2011.

Activities of GIZ Serbia related to street lighting

� Implemented 9 projects of modernization of the municipal street lighting system, 3000 lights were replaced, GTZ MMS (2006-2008)

� Implemented one on-line street lighting monitoring system and system for public display of savings of electricity achieved after modernization,

03.05.2011 Seite 2

for public display of savings of electricity achieved after modernization, GTZ MMS (2008)

� Developed contract and tender models for implementation of performance contracting in street lighting (ESCO model), GTZ MMS (2006)

� Developed municipal model ordinance on improving energy efficiency in street lighting and indoor lighting in public buildings, GTZ SLS (2006)

� Developed software tool for elaboration of the municipal electronic data base on street lighting, GTZ MMS i GTZ SLS (2008-2010)

� Total electricity consumption in street lighting system in Serbia in 2009. was 479 GWh, app. 1.76% of total electricity consumption in Serbia

� Total number of meters is 23736

� Estimated installed capacity is app. 100 MW

Technical and legal framework

03.05.2011 Seite 3

� Estimated installed capacity is app. 100 MW

� Number of operating hours is 4000-4015

� Public lighting is categorized as a separate category of consumption in the tariff system

� Tariff element is active energy with one tariff rate

� Current price is 5.15 din/kWh (~5 €¢/kWh) without VAT

� Serbia has one large domestic manufacturer of street lighting equipment operating on country-wide and international market

Street lighting is a typical municipal service in Serbian and ex-Yugoslav legal framework.

However, the monopoly in the production and distribution ofelectricity imposed dualism regarding the responsibility for thestreet lighting service:

Technical and legal framework

03.05.2011 Seite 4Page 4

� Electricity distribution company de facto provides the service andmaintains the system.

� Municipality has the obligation to allocate certain funds, to coverthe cost for electricity and maintenance, without actual chance tosupervise expenditure and often even without the possibility todevelop, design and extend the street lighting system.

After the 2000, reforms have started in Serbia towards decentralization and de-monopolization, which contributed to a clearer insight into the situation regarding the street lighting, as well as to a different interpretation of the enactment of regulations.

Local electric power distribution companies desist more and more frequently from the activity of maintaining and designing the street lighting. Consequently, municipalities are facing difficulties in organizing

03.05.2011 Seite 5Page 5

lighting. Consequently, municipalities are facing difficulties in organizing maintenance, modernization and further development of the street lighting.

Solutions encountered in practice consist of:

� contracting those activities with private companies

� undertaking those activities by various municipal service companies

� undertaking no activities, which results in fast deterioration of the system

General assessment of the condition of street lighting in the majority of Serbian municipalities is negative, due to:

� Obsolete status and poor technical condition of the system,

especially lights

� Unsatisfactory quality of the SL (inadequate designing, no

03.05.2011 Seite 6Page 6

� Unsatisfactory quality of the SL (inadequate designing, no categorization of the roads, chaotic expansion of the system, poor quality of equipment, voltage fluctuation in the grid and irregular maintenance)

� Relatively high costs for electricity

� Relatively high costs of maintenance

� Illegal consumption in some municipalities

� Negative environmental impact, due to the use of mercury bulbs

and their illegal disposal, as well as due to the light pollution

� Low price of electricity� Low price of labor

ConsequenceLow cost effectiveness of modernization and implementation of energy efficiency measures in public lighting system

Obstacles to modernization of the street lighting in Serbia:

03.05.2011 Seite 7Page 7

efficiency measures in public lighting system SPB for a typical simple measure of replacing outdated lights with incandesc.

or Hg hp light sources, with modern lights with the Na hp light sources, is 6-8

years

� Lack of comprehensive and uniform records on the SL system at the municipality level, including the evidence on ownership over its elements, particularly over the lights themselves

ConsequencesPoor insight into the actual status of the systemDifficulties in identifying and preparing projectsDifficulties in designing and performing construction works

Elaboration of electronic data base of the municipal streetlighting system, aimed at:

� Recording data necessary to create separate GIS layer of the street lighting system

� Integration with web applications of the municipal service companies

� Identification of ownership over the parts of the street lighting system

Expected results

03.05.2011 Seite 8Page 8

� Identification of ownership over the parts of the street lighting system

� Identification of the street lighting system structure

� Identification of the street lighting system deficiencies (quality of lighting, of the system maintenance, system structure etc.)

� Identification of the energy efficiency projects and the possibility of savings in the SL system expenditures

� Facilitating of design work – street lighting system adaptation, modernization, reconstruction or extension

� Establishing of the records on the street lighting system maintenance and cost for electricity

Basic information on software tool -what, when, who…

� Comprehensive software tool including the data base on municipal street lighting system structured on the Microsoft Access platform and the software application for entering, processing and

03.05.2011 Seite 9Page 9

and the software application for entering, processing and presenting data along with statistical analysis in the form of simplified tables and charts.

� Data are entered into the electronic data base on the basis of direct insight into the condition of each system element in the field.

Basic information on software tool -what, when, who…

� Developed and tested in 2008 within the scope of GTZ MMS Project

� Upgraded in 2010 within the scope of GTZ SLS Project

� Methodology and algorithm: Maja Matejic, GTZ MMS

03.05.2011 Seite 10Page 10

� Methodology and algorithm: Maja Matejic, GTZ MMS

� Technical data on street lighting: Bojan Lazarevic, ED Krusevac, Sladjana Jevremovic, Varvarin

� Testing: Sladjana Jevremovic, Varvarin

� Software developer: Softek, Uzice

� Further testing: NGO CRI and 8 municipalities

� Upgrading: Maja Matejic GTZ SLS

� Testing of the upgraded version: Sladjana Jevremovic, Varvarin

Electronic data base is a set of identification,technical and operational data on the street lightingsystem at the municipal territory, arranged along thehierarchical sequence

What is an electronic data base?

03.05.2011 Seite 11Page 11

hierarchical sequence

The data hierarchy follows the structure of electricitydistribution and technical structure of the streetlighting system

Electricity distribution structure

� Electricity distribution corporate enterprises of EPS(Electric Power Company of Serbia)

03.05.2011 Seite 12Page 12

� Electricity distribution companies

ED corporate enterprises of EPS

03.05.2011 Seite 13Page 13

ED Corporate Enterprise Elektrosrbija

Electricity Distribution Company Krusevac

03.05.2011 Seite 14Page 14

Technical structure

� Transformer stations

� Street lighting outputs per transformer unit

� Electricity supply lines

� Connection points

03.05.2011 Seite 15Page 15

� Connection points

� Lights

� Maintenance of the connection point

Technical structure

03.05.2011 Seite 16Page 16

The electronic data base is fully compatible with the GIS applications of the Ministry of Infrastructure and Energy and GIS applications of the relevant municipality and it is prepared in the format which can be used as one of the layers of the future geographical information system (GIS) of the municipality, based on available grounds of the

03.05.2011 Seite 17Page 17

system (GIS) of the municipality, based on available grounds of the municipality and the Ministry of Infrastructure and Energy .

Possible use of electronic data base for GIS application

03.05.2011 Seite 18Page 18

Main menu window

03.05.2011 Seite 19Page 19

Data on transformer stations

03.05.2011 Seite 20Page 20

Data on street lighting outputs

03.05.2011 Seite 21Page 21

Data on electricity supply lines

03.05.2011 Seite 22Page 22

Data on connecting points

03.05.2011 Seite 23Page 23

Data on lights

03.05.2011 Seite 24Page 24

Data on maintenance of the specific elements of the system

03.05.2011 Seite 25Page 25

Invoices for maintenance of the system

03.05.2011 Seite 26Page 26

List of maintenance operations

03.05.2011 Seite 27Page 27

List of contractors for maintenance

03.05.2011 Seite 28Page 28

Invoices for electricity consumption

03.05.2011 Seite 29Page 29

Records on electr. consumption per meter

03.05.2011 Seite 30Page 30

Analyses – tables

03.05.2011 Seite 31Page 31

Analyses – charts

03.05.2011 Seite 32Page 32

Statistics of supply lines – tables

03.05.2011 Seite 33Page 33

Statistics of connecting points – tables

03.05.2011 Seite 34Page 34

Statistics of lights – tables

03.05.2011 Seite 35Page 35

Statistics of lights – charts

03.05.2011 Seite 36Page 36

First testing

� Testing was carried out in the period from 1 August to 30 November 2008 in collaboration with the NGO “Center for Regional Research”

� In the first phase, pilot municipalities were selected. Based on the similar size, number of inhabitants, neighboring position and technical features important for the implementation of the project, selected municipalities were:

03.05.2011 Seite 37Page 37

selected municipalities were:

Paracin, Cuprija, Varvarin, Trstenik and Vrnjacka Banja.

� During the selection of municipalities local consultants on the project were also selected.

� Implementation of the project started by collection of written approvals for the project execution and acceptance of its objectives from the mayors of all pilot municipalities as response to the inquiry by the project implementer.

� The preparatory phase was finalized by the gathering of all project participants, held on 7 August in Varvarin, where the project was presented in detail.

� During the same event the local consultants were trained in the use of software, which was also handed over to them, and on 20 August they received the equipment

� Total estimated number of the connecting points of the street

03.05.2011 Seite 38Page 38

� Total estimated number of the connecting points of the street lighting in the pilot municipalities was 25000.

� Good communication of the local consultants with the electric power distribution companies in the pilot municipalities was of great importance for the successful execution of the project.

� Project implementation was monitored monthly.

� During the project implementation high level of cooperation with the electric power companies managing the street lighting in their municipalities was achieved.

� In total, 27617 of connection points were processed, i.e.110% of the estimated number.

� The following performance was achieved:

� 1. In Paracin, the estimated number of the street lighting connecting points was 7000, while the data base comprised 8591.

� 2. In Cuprija, the estimated number was 3800, while 4709 connecting points were processed in the cadastre

03.05.2011 Seite 39Page 39

� 3. In Varvarin, the estimated number of connecting points was 3 500, while the data base comprised 4289.

� 4. In Trstenik, the estimated number was 6000, while 7 391 connecting points were processed in the cadastre

� 5. In Vrnjacka Banja, the estimated number was 4600, while the data base comprised 2637 connecting points.

� Local consultants confirmed that the project was well accepted by the municipal leaders and the representatives of other relevant organizations and companies.

Second testing

� Testing was implemented in the period from 20 September to 30 November 2009 in collaboration with the NGO “Center for Regional Research”

� Selected municipalities were:

Rekovac, Cicevac, Pecinci

03.05.2011 Seite 40Page 40

Rekovac, Cicevac, Pecinci

� The following performance was achieved:

� 1. In Pecinci, data base comprised 1111 lights and 1641 connecting points

� 2. In Rekovac, data base comprised 2692 lights and 4395 connecting points

� 3. In Cicevac, data base comprised 1891 lights and 2510 connecting points

After the analysis of results, further upgrading of the software was undertaken. That upgrade comprises modules for monitoring electricity and maintenance cost, as well as the option of storing historical data on the changes on every system element.

Follow up

03.05.2011 Seite 41Page 41

changes on every system element.

It is possible to continue upgrading and improving of the software tool. For this purpose, all the comments, suggestions and initiatives for cooperation are welcome.

With a few small adjustments, the software tool is also applicable in other ex-YU republics

� Three training courses for municipal technicians from 25 municipalities from Vojvodina were held in November 2010 (Novi Sad, Kanjiza and Ruma)

Trainings of the new users of the software tool

03.05.2011 Seite 42Page 42

Installation of the software

� Starting from 06 10 2010 download on www.sls.rsor www.softek.rs

� Free demo version with limited number of input data (up to 10 transformer stations), aimed for trial and learning

03.05.2011 Seite 43Page 43

trial and learning

� Integral version of the software tool is free, provided that the municipality is registered as user of the program

� Application for registration: maja.matejic@giz.de

� Each municipality receives only one license, that is valid only for one computer

Thank you for your attentionThank you for your attention!!

03.05.2011 Seite 44Page 44

Maja Matejić, MSc Mech.Eng.Maja Matejić, MSc Mech.Eng.EE--mail:mail: maja.matejicmaja.matejic@@gizgiz.de.de011 33 44 342, 062 330 724011 33 44 342, 062 330 724

Slañana Jevremović, Slañana Jevremović, ElEl. . EEng.ng.EE--mail: mail: sladja.jevremovic@yahoo.comsladja.jevremovic@yahoo.com

037 787 178, 063 8949 443037 787 178, 063 8949 443