Overview
UMS Group automated the collection of elevation data for ~100,000 transmission structures. Elevation data is important for asset management analyses and strategies needed by the LOBs, e.g. linking to climate variations, max expected wind speeds, and impact on asset insulation values and design standards, operating practices and Maintenance strategies.
Methodology
Google’s Application Programming Interface (API) allows connection or integration with Google Services and can provide access to data such as elevation records.
Simplistically, the lat-long coordinates from all transmission structures in the database were loaded and cross referenced against the lat-long coordinates, and the corresponding elevations recorded in the Google dataset utilizing the API.
We were able to process ~30,000 structures per day, which resulted in a 5-day run time (after the upfront coding and setup).
Data Utilized
- Structure database including lat-long coordinates
- Google public elevation data
Challenges
General data quality issues.
Success
Successful development and deployment of a process to calculate fields utilizing a large dataset through a 3rd party API, with very accurate results.
Elevation profiles as seen in the UMS Group analysis platform.
Talk to Our Experts Today
Insights In Your Inbox
Receive perspectives on the industries and issues that matter.
