The Challenge
A leading Power Line Transmission Development company was working with multiple land vendors, each using different systems, Irth and OneVizion, to manage critical land data such as survey and acquisition statuses.
Because data was not centralized and the company relied on vendor-provided data extracts, the data flow between Land and GIS teams was fragmented. Teams had to exchange numerous files via email to piece together a complete picture of tract status across the company’s various transmission line projects.
This fragmented setup resulted in:
- Inconsistent and siloed data, limiting visibility across projects.
- Reporting bottlenecks, as updates relied on a third-party provider.
- Manual coordination and delays stemming from repetitive data sharing between teams.
- Difficulty tracking land progress and aligning information across vendors and systems.
Faced with these challenges, the company began evaluating whether to invest in a new, unified land management system to streamline consultant workflows and improve oversight.
The Solution
As part of an ongoing digital transformation initiative, Sullexis was already building an enterprise data platform on Microsoft Fabric. The team was brought in to help unify and modernize the land data ecosystem.
Data Integration
- Ingested and reconciled data from Irth and OneVizion into the Fabric-based data platform.
- Performed data conversions and schema alignment to standardize information across both systems.
- Delivered a single, consistent view of land data, enabling cross-project benchmarking and new performance metrics not available in source systems.
Reporting Modernization
- Transitioned all reporting to Power BI, offering real-time access to land progress across projects.
- Integrated GIS mapping, allowing users to visualize and drill into parcels and transmission lines.
- Applied color-coded status indicators to highlight survey and acquisition progress at a glance.
Land & GIS Automation
- Created a combined Land and GIS workflow, automating tract status identification and updates.
- Reduced manual file exchanges between Land and GIS teams by enabling the data platform to automatically push updates to both Land systems and GIS.
- Streamlined coordination, ensuring that all teams had real-time, accurate insights into the status of tracts and intersections across transmission line projects.
The Outcome
The company gained a unified, data-driven view of its land operations, eliminating silos, improving collaboration, and avoiding costly system replacement.
Business Impact
- Cost Savings: Avoided a major capital investment by eliminating the need for a new land management system.
- Operational Efficiency: Automated data synchronization between Land and GIS, significantly reducing manual updates and coordination time.
- Visibility & Governance: Delivered a single source of truth for land progress across all transmission projects.
- Agility: Reduced third-party dependency for reporting, improving timeliness and control.