Technology stack
Customer’s challenges
The project addressed several key challenges:
Unreliable valuations by different entities
(Orange and contractors) due to inconsistent parameters like coverage, number of homes, and mileage.
Negotiation processes
relying on fragmented documentation.
Manual network route drawing
by surveyors in GIS programs, leading to errors and inefficiencies.
GIS data sourced from different systems
(e.g., OpenStreetMap, IGN) with varying quality standards and time periods.
Lack of automation
in drawing optical fiber routes and standardizing rules for valuation.
Solution
The solution involved leveraging advanced technologies such as Google Cloud Platform (GCP), PostgreSQL with PostGIS, C++, and Python to optimize the architecture and reduce costs significantly. Instead of relying on BigQuery and managed SQL instances, the team transitioned to self-managed instances on virtual machines. PostGIS replaced GeoPandas for faster processing, while core functionalities were developed in C++ for better performance compared to Python. The system centralized infrastructure data (addresses, roads, shadow copies/twins) and automated rules for laying optical fiber routes.
Benefits
Monthly cost reduced
from $20k to $600 with higher throughput.
Automatic drawing
of optical fiber traces.
Reduced disruption to public spaces
during installation processes.
Increased flexibility for parameter changes,
such as adjusting the distance of boxes from houses.
Cost savings
during fiber installation by utilizing existing infrastructure (e.g., manholes) and optimizing fiber optic length.
Automated enforcement of area-specific rules
for laying fiber optics instead of manual checks by surveyors.
Detailed reporting
of costs, areas, addresses, material expenses down to the centimeter of each cable.
Simplified engineering
and topology optimization of fiber optic infrastructure.
Enhanced area coverage
by base transceiver stations (BTS).
Optimized use of private versus public spaces
to minimize costs for both Orange and its customers.
Discover the possibilities that data platforms offer for your business