Building a Smarter Network Planning
and Management Tool

From scattered tools to streamlined optical cable
network management

Introduction

Team Telecom needed a unified solution to plan and manage optical cable networks more efficiently.

Previously, different tools were used in isolation - Google Earth and AutoCAD for mapping, and Excel for storing details. This fragmented process made planning and management time-consuming and prone to inefficiencies.

The challenge was clear: bring everything together into one smart system.

Challenge

Fragmented workflows across multiple platforms created inefficiencies, errors, and barriers
to managing complex network infrastructure.

Multiple tools required for different tasks
GIS mapping done separately in Google Earth and AutoCAD
Splicing information scattered across Excel sheets
Objects in planning stage show on the map with little distinction
Difficulty in analyzing fiber paths and impacts of splices or cuts
Limited ability to scale and manage large, complex networks

Solution

The development team designed and implemented a comprehensive platform that integrates mapping,
data storage, and fiber management in one place.

Key components

PostgreSQL with PostGIS: stores and manages network objects.
  • Point objects: manholes, poles, addresses, jumpers, closures, termination boxes, cabinets, data centers, GPONs
  • Line objects: routes, tubes, microducts, cables, risers
  • Polygon objects: buildings, districts, cities, regions, communities, layers
Neo4j: manages fiber-level information.
  • Tracks cable start/end nodes, splicing, splitters, and availability
  • Enables quick pathfinding, loss calculations, and impact analysis
OpenLayers & Custom SVG: provide intuitive, interactive visualization.

Smart features & solutions

  • Impact analysis
  • determine which connections are affected by a splice or cut

  • Loss calculation
  • assess signal loss over long paths with accuracy

  • Polygons for cities/villages
  • used address data + DBSCAN clustering to group unlabeled areas and match them with nearest settlements

  • Regional search
  • integrated cadastre data with PostGIS to locate objects within specific communitie

  • Integrated data
  • all network details in a single system

  • Task management
  • plan, coordinate, and track construction processes from start to finish

  • Regional backups
  • generate localized backups of specific areas to simplify task planning and execution

  • Fast pathfinding
  • instantly trace the entire path of a fiber

Results & benefits

Reduced reliance on multiple external tools
Improved speed and accuracy in planning
Easier management of large-scale networks
More reliable operations for both internal teams and clients
Flexible foundation to add new features and scale further
Limited ability to scale and manage large, complex networks

Conclusion

By consolidating fragmented tools into one Network Planning Tool, the team delivered
a platform that makes telecom infrastructure planning smarter, faster, and more reliable.