Oslandia and Mappy embrace OpenSource

-For more than two years, Oslandia has been working with Mappy for its transition towards OpenSource. The first step is represented by the database migration project of the cartographic backoffice, from Oracle to PostGIS. This has just been finalized and is currently running in production.

Mappy, a french leador on map services, offers routing and cartography services. Supporting several billions of requests per month, the LBS platform (Location Based Services) is at the heart of Mappy's activity and serves as a base for new products such as Web To Store.

Oslandia works together with Mappy to migrate this cartographic platform from a solution developped in-house, to a new solution based entirely on free and opensource softwares, in order to prepare forthcoming technical and operational challenges.

Data preparation and cartographic map creation backoffices have been migrated successfully.
This software stack was initially based on Oracle Spatial, SQL Server, and other non-standard internal tools to create the map. It only runs opensource components by now.

Oracle and SQL Server have completely been replaced by PostgreSQL and PostGIS, which is the key component for spatial data storage and preprocessing. Mapnik, Python, Tornado, Varnish, MemCached, Debian are other Opensource components used in this architecture.

The migration to OpenSource softwares allowed Mappy to rationalize and optimize the architecture of their "map" component :


  • Reduced data processing time


  • API and data format Standardization


  • Strong reduction of the technical debt


  • Reduced amount of lines of code


  • Cost reduction for the platform, and cost-effective scaling


  • Technical skills improvements for the team and stronger motivation


  • Full technical mastership of their tools


    Oslandia helped Mappy to integrate the Opensource culture and methods into their teams, and provided them with the technical skills required to implement this high-load architecture. Oslandia's competences in geographical information systems, and its high expertise on PostGIS let the project be achieved successfully.

    Mappy benefited from the latest OpenSource technologies, at the state of the art, and was also able to contribute back to some free software, like Mapnik.

    PostGIS, the database supporting the whole infrastructure, allowed to reach very high performances and a rich functional level.
    The database - 75GB - benefits from all latest enhancements of PostgreSQL and PostGIS, such as streaming replication, PostGIS new geographical functions, recursive CTEs, JSON native support and much more.

    Audrey Malherbe (@AudreyMalherbe ), project manager at Mappy, stresses that choosing PostgreSQL and PostGIS was obvious "We wanted to dive into OpenSource, leaning on reknown and performant technologies like PostGIS. It was important for us to contribute to OpenSource, and Oslandia's expertise and its implication in the community has allowed us to rush into this adventure with full confidence."

    Mappy intends to go on with this OpenSource orientation and extend this migration method to the other services of the cartographic platform.

    About Mappy

    Routing and cartographic services specialist, Mappy is reknown as the leader for local search through maps, on internet, tablets, mobiles and GPS.

    Mappy offers three kinds of search to its users : map search, which allows to visualize a neighborhood, to experience city immersion thanks to 360° views in 320 french cities, but also to open the door of several thousands of shops ; the routing service available for cars, public transportation, bicycle and pedestrian mode ; and product search, allowing to locate a specific product in a given geographical zone, to know its price and availability.

    As a major actor of urban transportation, Mappy offers to advertisers a geolocated solution on the whole country, facilitating web-to-store applications and trafic generation to their retail centers.
    Mappy counts as of now more than 10 millions users on Internet, tablets and mobile (Mappy and MappyGPS Free).

    Mappy is a subsidiary of the Solocal Group.


    About Oslandia

    Oslandia is a French OpenSource SME, specialized in OpenSource Geographical Information Systems. Oslandia has a strong expertise on spatial databases, OGC web services and desktop QGIS (PostGIS, QGIS…), and designs and implements GIS architectures.
    Oslandia provides a full range of services : consulting, development, training, support.

    Contact : infos@oslandia.com

    Published Wednesday, March 12th, 2014

    Published in

    Open Source

    © 2017 Directions Media. All Rights Reserved.