MY LAST PROJECT
The business needs a real-time tracking software with advanced features. The second goal is to provide visibility of vehicles working for a subcontractor or specials customer.
To design a software based on various technologies, I used my experience and I acquired some new skills on the spot...
PRODUCT SCOPING
The new application allows you to track, in real time or retrospectively, the position of all vehicles, the routes taken, the trucks passed near a given point and to use any other basic functionality of OpenStreetMap or Google Earth maps...
The application is a divided window with a map on one side and three tables on the other. These tables are filled in using queries from the vehicle database and the map is updated according to the display options selected.
RESEARCH & DESIGN
- Search for a offline map tool that can be managed from A to Z (without Internet connection)
- Design of a Linux environment hosting several OpenStreetMap GIS databases under PostgreSQL databases
- Searching for an API to manipulate OpenStreetMap map in a web application
- Quick POC made under Apache2/PHP5 web server to validate my choices with the business
- Research and implementation of a Reverse Geocoding tool based on the server implemented above
- Design of a Windows service to extract tracking data from SAP (RFC calls using function modules under SAP)
- Windows Service developed under Visual Studio 2012 (VB.net)
- Design of a web tracking software with an interface including a "user friendly" map
- Web solution developed under Visual Studio 2017 (ASP.net MVC5)
SKILLS TO ACQUIRE FOR THIS PROJECT
- Handling a PostgreSQL database under linux OS
- Handling OpenStreetMap maps for storage in offline databases
- Usage of javascript API for the integration/operations of a OSM map to a web application
- Implementation of a reverse geocoding tool using databases
- Web development in general
- Development under ASP.net MVC5
- Understanding the MVC philosophy
- IT security rules and good practices to deploy a public website
Result design
Result end-user web software
