Fiber / Optical Cable GIS Database

Production-grade geospatial data layer for optical network planning, auditing, and operational reporting.

Scope

Designed a normalized GIS data model covering projects, layers, cable segments, splice nodes, zones, attachments, and audit trails. Built migration-safe schemas for long-term operations and incremental change.

PostgreSQL PostGIS SQLAlchemy GeoAlchemy2 Alembic FastAPI-ready

Project Visuals

GIS topology overlay and line geometry preview — GIS topology view with node connectivity and geometry layers.

Field context image used for cable routing and cabinet mapping workflows — Field context reference used for route and cabinet mapping workflows.

Technical Breakdown

Challenge

Fragmented optical planning data across spreadsheets and ad hoc files.
Inconsistent geometry types and missing auditability of edits.
No reliable way to synchronize derived cable length metrics.

Implementation

Defined constrained geometry columns with explicit SRID handling.
Added GIST indexing strategy for spatial lookup and map operations.
Implemented migration/version discipline with Alembic revision flow.
Introduced automated cable-length synchronization path to reduce manual drift.

Operational Value

Cleaner planning-to-execution handoff for field and office teams.
Higher confidence in reported lengths and area-based summaries.
Better foundation for future API/reporting layers.

Delivery Notes

Schema built to be consumed by service/API layers without re-modeling.
Audit-ready structures for long-term change tracking.
Detailed stack and live access can be shared during interviews.