Utility companies, including small utilities and cooperatives, work with a huge range of data systems, from legacy databases, to spatial information collected in the field, to business records. All of this data is vastly different in nature and structure, but all of it needs to work together in order to enable business operations and decisions. Here at Safe Software, we see utility companies使用FME.to integrate and distribute data for:
- design and planning,
- operational efficiency and cross-team communication,
- 资产管理，
- 中断和泄漏管理，
- 分销网络维护，
- sharing data with the public and stakeholders,
- 以及更多。
让我们来看看5主数据工作流程亚搏在线we see for utilities, along with real-world examples of these workflows in practice.
1. Synchronize data across systems and formats
To form a complete picture of all available information and facilitate decision-making, data needs to be integrated from various systems – including across teams, from external sources, and from both geospatial and business software like Esri, Autodesk,Smallworld，宾利，oracle，ERP软件等。此外，所有这些系统都需要保持最新状态。
这就是很多公用事业机构实施的原因数据集成工作流程亚搏在线，是否将来自各种源的数据带入一个中央存储库，或确保所有不同的系统保持同步。一个application integration亚搏在线工作流使每个团队都能够使用最适合的适用应用程序，包括数据库，工程，操作和金融，同时保持所有连接。
Fordistribution network maintenance and operations,它是有用的数据集中到单个哒tabase, making it easier to analyze the data, share it with stakeholders, generate reports, and more. Running this data integration workflow on a schedule or as new data arrives ensures the central database is updated on an ongoing basis and critical network information is always available.
Here are some examples of utilities that use data integration workflows to centralize information.
- 汉普顿道路卫生区implemented an online data contribution service to help centralize wastewater collection data from 14 localities. Data is automatically validated and loaded into the repository’s data model for use by the GIS team.
- 遍历城市光线和力量uses FME to move core business data between several disparate databases and applications, including Outage Management (OMS), work order system, utility billing/CIS, Integrated Voice Response (IVR) system, and an energy efficiency application.
- Grant PUDuses FME to automate data integration across all departments of their organization, including building a connection between finance and engineering, facilitating communication with their Customer Information System, data validation for accounting, and more.
- Forsmark Power Groupworked with our partner, Sweco, to integrate nuclear power plant data into a single database and share the results with authorized users via a secure web map. Data is integrated from AutoCAD, Shapefile, Excel, Revit, and IFC, and stored in an Oracle Spatial database. The system meets security standards and regulatory requirements.
2. Data validation and quality control
Data integrity is critical, and so implementing an automated quality control workflow is a common task for utility companies. FME has transformers to identify, repair, and filter out bad data, like the GeometryValidator and AttributeValidator. Validation reports can be generated as PDFs, spreadsheets, HTML pages, or in other formats, and automatically sent to stakeholders.
- Learn how:Data validation and QA tutorial
它有助于通过创建一个通过创建进入系统之前验证数据self-serve data validation portalfor field crews to upload and validate their submissions. Running data validation workflows regularly also ensures the integrity of all datasets.
Quality control is a critical part of every data integration workflow. Here are two examples of companies who use FME for their everyday tasks, with data validation being a key part of it.
格鲁吉亚力量uses FME to automate many everyday data integration tasks, from simple format conversions to data validation and analysis. Automating these processes saves hours of time and ensures data is accurate. TheirMetering Services teamalso uses FME for several tasks, like to locate specific installed meters that need replacement, to compare several databases and detect financial discrepancies, to process a large database and use business intelligence to generate a “Morning Report”, to detect anomalies in databases, and more.
PNMuses FME to automate many data integration tasks in their GIS department, including data conversion, extraction, reporting, analysis, and quality control. Many workflows are run on a schedule to ensure stakeholders always have access to up-to-date data.
3.迁移GIS，CAD和其他系统之间的数据
Data migration is a common task, not just to move data from legacy systems, but also to convert and integrate new data that arrives every day. For example, many utilities need toconvert data from CAD to GIS要么from GIS to CADon a regular basis.
FME is also great at facilitating the process ofmigrating to the Esri Utility Network. Learn how to do this in our tutorial, “Esri ArcGIS Pro Utility Network Migration Tools”, and in thisESRI实用网络迁移培训课程.
中央反哥斯达卫生区migrated their GIS data model into the Esri Local Government Information Model. FME helped them manage and transform the data model without losing data integrity, including attributes, line segments, and sewer main features.
Enstar天然气公司和阿拉斯加地图科学使用FME将AutoCAD图纸迁移到新的GIS映射系统（ESRI Arcsde地理数据库）中。FME启用此CAD-to-GIS转换而不会丢失任何信息。
路易斯维尔燃气和电动integrated pipeline design data from CAD into their GE Smallworld database. They used FME to integrate the incoming data, perform quality control, rubber sheet the data to a common landbase, and insert it into GE Smallworld.
4. Deliver and distribute critical information
It’s important to make information accessible by sharing data in various formats, empowering the end user to get data in whatever format they need – whether that’s an easily shared PDF, a rich GIS data model, a spreadsheet, or a dataset for loading into business intelligence software. We often see companies creatingdata portals对于public, design groups, contractors, or other clients to access. For example,Sunesys builtaoneCall.Automated Response System.
- FME examples: Learn how to build adata distribution service在fme。
Foremergency and risk management, making data accessible means responders and agents can be equipped with critical information no matter where they are. This empowers them to deal with weather emergencies, outages, leaks, and maintenance using the most up-to-date information. For example, you can configure a data integration workflow to receive incoming data from sensors and field personnel and respond according to business rules to alert the right people.
关键信息也可以发送给客户，喜欢通知他们中断并预计在易于访问的网站地图上的地区的升高。例如，Manitoba Hydromade power outage data available to customers through an interactive web map.
FortisBC使用FME评估对天然气和电力资产的野火威胁，使他们的运营经理能够立即采取行动。工作流程亚搏在线涉及在持续的基础上将野火数据与他们的小型环境集成，并以各种格式为应急响应者进行访问。
5.拥抱新技术 - 无人机，AR，智能网格等
One of the most exciting things about FME is how easy it is to experiment with cutting-edge technology and data types. It’s straightforward to integrate new sources like drone imagery, or to reroute your data to different output formats like game systems, or to apply various analytics and transformations to your data, like machine learning algorithms.
Here are a few new technologies that utilities are experimenting with, plus some ideas and inspiration:
- Connect to imagery from无人机/无人机， 像什么Alabama Power Companyis doing.
- Connect tosatellite imagery和数据喜欢Landsat, Sentinel, and Planet.
- Output data to增强现实在移动设备上可视化地下基础架构。
- 建立一个interactivevisualizationthat can be explored in a browser.
- Output data to agame environment喜欢Unreal Engineto let stakeholders walk around and explore infrastructure in a virtual world.
- Connect to传感器数据to build a智能电网，促进网络监控，管理，分析和规划。
Connect to认知服务to gather intelligence from your data, like natural language processing and computer vision algorithms.
更尖锐的形状uses FME to build solutions for their power distribution clients, for example, to identify and prioritize the removal of vegetation and other objects that could impede client networks. When the European Space Agency (ESA) wanted to identify the value of satellite data for power distribution asset management, Sharper Shape employed FME for the task.
*
Hopefully you found these examples inspiring as we explored what utilities around the world are accomplishing using data integration workflows. Automatic quality control, analysis, data conversions, report generation, data distribution, and so much more can be accomplished when data is harmonized, information is made accessible, and new technology is embraced. By running these powerful workflows on schedule or in response to an event, these companies are automating tasks that used to take hours, days, or even weeks of manual effort. This not only reduces the risk of human error, but also frees up staff to focus on building innovative solutions.
To learn more about data integration for Utilities, watch our webinar,“Meeting the Demand for Quality Utility Data”. Our小型公用事业subscription modelis designed specifically to help small utilities and cooperatives deploy FME, while ourEnterprise subscription modelis a good option for larger utilities.联系我们to learn more.
Further reading:
- [Blog]8令人振奋的方式实用程序是自动化数据工作流程亚搏在线
- [Blog]6电气，天然气和水实用程序的数据集成提示
In addition, stay tuned for a new utilities webinar on June 3rd. Registration coming soon on our网络研讨会s page.
天安华纳
Tiana is a Senior Marketing Specialist at Safe Software. Her background in computer programming and creative hobbies led her to be one of the main producers of creative content for Safe Software. Tiana spends her free time writing fantasy novels, riding her horse, and exploring nature with her rescue pup, Joey.
发表评论