Mobile and web solution for municipal garbage collection

This is version 2.0 of my mobile and web solution for municipal garbage collection. The idea is the following: There is the municipal garbage collection vehicle with a supervisor on it. All garbage items that can not be collected either because of their size or type (e.g. office desk, mattresses, bulky items) are marked on the map, without having to type their address.

At the end of the garbage collection procedure, the number of items marked by the supervisors is shown on the internet.The municipal office which is responsible for garbage collection can select the garbage type and send a special vehicle to collect them according to the best route given from the web map. The solution also provides a reporting tool based on dates and item properties.

After the collection of the special items, these can be removed from the map.

So far, three municipalities have shown great interest for the solution and ready to sign a contract.

Using Google Maps JavaScript API for municipal Street Lights

Hey guys, fantastic news! Within three months since the launch of the first version of my web application, two municipalities (Palaio Faliro and Alimos) in Athens – Greece have already signed a contract to rent it and use it as a tool for surveying and registering complaints regarding municipal street lights. Very encouraging signs show that more municipalities are about to use it in Athens and abroad. Keep you posted!

For more info contact me at +306943476333 or send an email at

PHP – MS SQL Server – Greek Encoding

timetableThis is a guide that will assist you display Greek letters while exporting data from an SQL Server Database using PHP.

I recently had to develop an application that will show the reserved University halls according to the timetable. The data were stored in an MS SQL Server 2012 database with Greek_CI_AI Collation.

Continue reading “PHP – MS SQL Server – Greek Encoding”

SQL Server Configuration Manager – WMI error


Hey guys, does SQL Server Configuration Manager give “Invalid class [0x80041010]” error? Most probably you will encounter this problem after upgrading to Windows 10 and run SQLServerManager11.msc or SQLServerManager12.msc depending on the SQL Server version you have installed.


Here is the Solution, it worked for me and hopefully for most of you too.

Continue reading “SQL Server Configuration Manager – WMI error”

Querying a Layer using an ArcGIS Online Map

ArcGIS-OnlineWhile exploring the possibilities of ArcGIS API for JavaScript, I was wondering how to query a web map that has been created through ArcGIS Online.

I spent quite a lot of time trying to figure out how to pass my Web Map created through ArcGIS Online as a URL. Especially for “var MapServiceToDisplay” and “var MapServiceToSearch”.

So here is the answer:

Continue reading “Querying a Layer using an ArcGIS Online Map”

Useful tips for installation of Oracle Business Intelligence on a Linux machine

obiee-linuxThis guide assumes you already have installed Oracle on your Linux machine and you now want to install Oracle Business Intelligence. It also assumes you are working on a 64-bit Linux machine. Before proceeding to the installation of OBIEE do the following:





Tip #1

– Open your terminal window and type: “sqlplus / as sysdba”

– Wait for a while and type “startup”

– Type “exit” in your terminal and again type “lsnrctl start”. Continue reading “Useful tips for installation of Oracle Business Intelligence on a Linux machine”

Android Studio or Eclipse?

Android StudioEclipse IDE has been active for at least a decade now and it is the dominant IDE for Java developers. Google on the other hand decided to release Android Studio IDE based on IntelliJ IDEA as an alternative for Eclipse ADT plugin, required for Android development. When it comes to select the integrated development environment for your Android apps which one would you choose?

Lets start from the installation itself. I started using Eclipse IDE to practice with Android Development, however I found the Android Studio more intuitive in terms of installation and kick-off. They are both handy but Android Studio offers Advanced Android code completion and refactoring, an improved and faster user interface designer, Unit Testing.

Continue reading “Android Studio or Eclipse?”

PHPUnit Installation Tips regarding tests in Zend Framework

Hi there, I spent quite a bit of time trying to figure out how to install PHPUnit and run tests with it. All the buzz comes from the fact that XAMPP can contain PHPUnit in its php\pear folder.  First I would recommend to uninstall the PHPUnit under your PEAR folder, so open command prompt from your XAMPP control panel and run:


Continue reading “PHPUnit Installation Tips regarding tests in Zend Framework”

How to install Zend Framework 2 on XAMPP

zf2Hey guys, I spent quite a bit of time trying to find a proper way of how to install Zend Framework 2 on XAMPP. Here are my tips about how to tackle and get started with Zend Framework 2.


1)      Go to C:\xampp\apache\conf\extra and modify httpd-vhosts.conf

Insert lines like:

<VirtualHost *:80>

ServerName zf.localhost

DocumentRoot C:\xampp\htdocs\zf\public

#ErrorLog “logs/”

#CustomLog “logs/” common

SetEnv APPLICATION_ENV “development”

<Directory C:\xampp\htdocs\zf\public>

DirectoryIndex index.php

AllowOverride All

Order allow,deny

Allow from all



Continue reading “How to install Zend Framework 2 on XAMPP”