The City of Coquitlam is one of the fastest growing municipalities in the province of British Columbia, Canada. With over 150,000 residents, the city is dedicated to enhancing its programs and services, business operations, and customer experience through smart city initiatives and technology driven strategies.
为城市的信息和通信技术（ICT）司，data integration initiativesare one of the main pillars in improving operational efficiency and productivity, business process optimization, and connecting data across the city. To date, the ICT division has used FME to integrate over 15 business applications and web services, including IBM Maximo, AMANDA, Tempest, Oracle eBusiness Suite, Amazon S3, and more.
With data existing in silos and disparate systems, this limited teams from using the best-for-fit applications. Time and effort spent on manual and labor-intensive processes such as data cleaning and validation meant that operational efficiency suffered. By automating several data integration and application integration processes and removing these data silos, teams are now freed from repetitive manual work and the risk of human error is eliminated.
让我们来看看众多城市项目中的五个他们实施FME的地方：
Project: Garbage and organics cart collection
多个系统之间的城市综合数据，以提高其回收和废物收集计划的知名度，并提高客户体验。
The city partners with a third-party vendor for the exchange and delivery of garbage and organics carts. They needed to integrate data betweenIBM Maximo.（企业资产管理平台），暴风雨(utility billing system), and spreadsheets sent and received by the vendor, in order to process service requests in a timely manner.
Using FME, the workflow parses Maximo for service requests, such as calls, issues, and new or updated requests, and creates a report containing a work order list sent to the vendor as a spreadsheet. The vendor will update and return this spreadsheet based on the work completed that day, and internal staff will update Maximo based on this information. FME then automatically extracts these updates and loads this information into Tempest to reflect any changes in the resident’s utility bill. As there are different costs associated with the various sizes of carts, ensuring an accurate update in Tempest is crucial to minimizing manual billing errors.
By implementing FME, this resulted in a significant reduction in the work order turnaround time, eliminating potential manual errors, while streamlining the data sharing process between city staff and their external vendor.
项目：自助空间数据目录
该市管理公众可供公众使用的各种数据，例如公园，运输和规划，他们希望通过自助门户轻易进入这些信息。
Coquitlam的空间数据目录是一个自助门户，允许用户浏览和下载可用数据，包括属性边界，道路，公用事业和大数据集，如orthophotos和lidar。用于通过电子邮件，个人或通过电话来发出的传入请求。有时需要发票，因为员工必须手动提取和包装文件（其作为Shapefile，地理数据库或CAD共享）。典型的数据请求用于花2-4小时完成;现在这一切都是使用FME自动化的。用户知道在哪里获取此数据，并可以使用FME自动化此传送过程请求自己。
此自动化从多个数据库中提取空间数据并存储Amazon S3中的文件。所有作业故障通信都将发送给GIS管理员组和迄今为止，此特定节点从未执行过。注意：EPW代表工程与公共工程，PRC代表公园，娱乐与文化服务。
Locating an individual LiDAR data file is one example of how users can find and download the data they need.
Project: LED streetlights conversion program
This program aims to replace 2,500-3,000 lights per year by 2022 and to reduce energy consumption by 57%. The city needed to maintain high quality and accurate data between its contractor and internal teams.
With a project at this scale, manually keeping up with the number of inspections and work completed by the external contractor proved to be challenging and time consuming.
此前，工程与公共工程的工作人员和管理队团队从承包商接收了电子表格，并面临着差的数据完整性和劳动密集型数据处理。对于员工来说，它成为一个苛刻的任务，找到并处理他们所需要的数据，并准确管理结算和发票Oracle eBusiness Suite。
使用FME，工作人员现在可以执行各种改进的操作任务，包括质量保证和数据清理，创建员工分配，构建报告，实时查看数据，并确保可靠的计费过程。
项目：散装包装的制造绘图请求
Using their own in-house FME Server App, the city created an automated way to bulk process, package, and respond to as-built drawing requests.
ICT部门已为其自己的FME服务器应用程序建立内部使用，以便在员工和承包商之间共享有效和透明的数据共享。外部承包商和内部资本建设人员可以通过应用程序提出请求，定义所需的区域并下载相关的竣工图。
要求可能涉及康复项目，建设，新发展或各种道路和公用事业改进项目的图纸。提交请求时，内部工作人员将使用FME服务器查询其文档管理系统，OpenText，准备和包装下载文件。
项目：自动牌照读者停车违规和票务
这座城市需要一种因公共停车场扩张而集中允许章程官员的允许信息。
When the local SkyTrain system was extended into city centres, parking permitting and management staff needed to find a more efficient way to enforce parking regulations. The city mounted several bylaw enforcement vehicles with an Automated License Plate Reader (ALPR) to monitor new parking hotspots near stations.
此前，章程官员必须手动输入并从多个系统查找牌照。现在，数据整合过程由FME自动化。FME工作流阻亚搏在线止停车许可证板信息AMANDA(permitting platform) and makes it available to the ALPR system. As a result, bylaw officers can now quickly pull information and efficiently manage busy parking areas.
T: An ALPR unit mounted onto a bylaw enforcement vehicle;
B：章程官员审查牌照和允许ALPR系统提供的信息。
FME for the entire city government
With the adoption of FME as the backbone in bringing systems together, data can now flow freely to get the job done. The ICT division has seen significant improvement in data integrity and accessibility between its internal teams and external vendors.
“FME启用数字转换中City. We could not achieve our goals without the products and support from Safe Software,” says Sean Watson, Business Systems Analyst. By leveraging the FME platform and scaling this across their entire city government, the value of data is truly maximized and staff can access and share data using the best fit-for-purpose applications. Sean and his colleagues are continuously working on data integration initiatives across the city and new projects are already underway for 2020 to help bring more quality programs and services to staff and citizens.
要了解有关当地政府如何从数据集成中受益的了解，请观看我们最新的网络研讨会，地方政府如何通过数据集成工作流程改进操作亚搏在线。
蒂娜沙
Tina is a product marketer at Safe Software. When she isn’t sharing the amazing stories of our customers, you can find her at local coffee shops, discovering a new noodle dish, or working on her next DIY project.
There are some really fascinating applications of as-built drawings and scanning data in this article. I’d love to see how adding intelligent meshes of as-built data and LiDAR scans could augment this service.