No results found
Environment and Climate Change Canada (ECCC) supports authoritative data publishing to the Federal Geospatial Platform (FGP) and Canada’s Open Government Portal. The OCIO Data Catalogue Service team leverages FME to build streamlined workflows to transform data of hundreds of formats, harvest from GeoNetwork and OGC Catalogue Service via APIs, catalogue metadata, perform QA/QC, and provide feedback to program areas on data improvement. ECCC has been contributing to Open Government with thousands of published datasets that meet open standards. Automated data validation with no coding enables the team to improve work efficiency, eliminate human errors, and support more open data publishing. This ultimately helps improve authoritative data sharing among federal departments and agencies and increase government transparency. Environment and Climate Change Canada informs Canadians about protecting and conserving natural heritage, and ensuring a clean, safe and sustainable environment for present and future generations. This project was done in partnership with Consortech.
Enugu Electricity Distribution Company (EEDC) was working with an old database system with outdated information about electrical assets, inaccurate information on the location of illegal consumers, and was prone to electricity theft. To solve the issues they faced, they set out to index all consumers within their network, geo-reference all existing customers and expand the billing database by regularizing all illegal consumers into the billing net, and leveraging a comprehensive GIS based Electrical Assets Mapping and Consumer Indexing Project. They used FME to implement QA and QC on multiple sources of data, resulting in the street-based map linked below. FME was also used to extract, transform, and load spatial and non-spatial data captured in the field into a geospatial database, matching geospatial customer data with non-spatial counterparts in the billing database. With FME, they could ensure the accuracy of coordinates, and automatically generate 26-digit CIN codes for about 5,000,000 building footprints using Natural Area coding algorithms. EEDC is now able to quickly see the number of buildings they supply and the length of roads in their franchise area, which has helped in the development of the EEDC Base Map that is more data-rich than Google Maps. They can also evaluate the coordinates and status of electrical assets in their network for seamless fault reporting, tracking, tracing, and in-depth analysis. Without FME, they could not have realigned, delineated, or identified the connected and unconnected transformers and location, number, or spread of various materials, critical in developing their asset information system. With a more modern and streamlined process, EEDC has been able to increase their customer base, grow their revenue, mitigate theft and leakages, and now have a greater ability to market their services by geography and transformer. EEDC distributes electricity across the five South Eastern States of Nigeria, covering about 30,000km sq. The company has about 1,000,000 electricity subscribers administered through 18 Business Districts (BD) spread across the franchise area. The work done by the EEDC was done in partnership with Progis Geospatial Limited.
London Underground needed a data integration process to support flood risk mitigation for their 270 stations. To determine which assets were at highest risk, the team collected 5,000 datasets including terrain, groundwater, and water main location information. They chose FME to automate the complex integration process, and 1Spatial to deliver FME training and consultancy. By using FME, they reduced data processing time by 13 weeks per year and delivered a more accurate output, while saving £15,000 in survey work. When future updates are required, workflows can be re-run to deliver accurate and reliable information to users and decision makers in their preferred system, freeing the GIS team from repetitive data integration tasks. Transport for London is a local government body responsible for operation of transportation networks, including the London Underground rapid transit system, in London, England.
The City of Bozeman, Montana, needed a better system for managing their water conservation rebate program in order to meet increasing demand for water from the growing community. By using FME with Geocortex, they developed a Rebate Viewer that enables the project team to enter and track multiple attributes for each rebate, and view rebate information and location on an interactive map. FME automates the calculation of the full rebate amount and visualization of the corresponding geospatial location. Choosing FME to automate rebate processing helps the City of Bozeman improve program efficiency, replace manual processes, and make data driven decisions. Water conservation staff can easily access and manage rebate information, and export it for specialized analysis. The rebate location map provides useful data to inform decision making regarding program growth. The City of Bozeman is the fastest growing micropolitan city in the United States with a population growth rate of 4.25%.
UDOT wanted to implement e-Ticketing for materials data to streamline inspection, enhance safety, and improve project administration. They used FME alongside ArcGIS Online and Survey123 to create a system that enables materials suppliers to send e-Tickets in real time and allows inspectors to access and edit ticket information on mobile devices. In the background, FME enables suppliers to send material information whenever a ticket is created and automatically integrates ticket data into an enterprise geodatabase. UDOT has now implemented a statewide e-Ticketing system with four big suppliers covering a majority of asphalt materials. Digitized workflows standardized the collection and sharing of materials data for project coordination, documentation, and billing with substantial cost savings. Instead of handling paper tickets, inspectors and office managers can process e-Tickets with increased safety, efficiency, and accuracy, reducing processing time by almost 80%. With positive feedback from all stakeholders, UDOT is looking to implement e-Ticketing for more materials and assets. UDOT provides transportation choices through a multimodal transportation system that strengthens the economy and enhances quality of life in communities throughout the state.
After the establishment of the Nanjing Municipal Bureau of Planning and Natural Resources, it was necessary to carry out coordinate transformations for massive, multi-format data in a short time. This data is used daily in multiple business systems. An online coordinate conversion system was built using FME Server for coordinate conversion between multiple data formats with multiple coordinate systems. The conversion of massive DGN, image, database and other data were completed in batches. They used the online coordinate conversion system to transform coordinate systems on 208 GB of vector data, 3.66 TB of raster data, and 207 GB of oracle-spatial data. FME offered benefits such as multi-format support, batch deployment, and automation Nanjing Municipal Bureau of Planning and Natural Resources is a department established by Nanjing Municipal Organization Reform and is a working department of Nanjing Municipal People’s Government. The work done by the Nanjing Municipal Bureau of Planning and Natural Resources was done in partnership with Beijing Antu.
Health authorities and public health workers in Central Norway urgently needed a tool to get a better overview of the current situation and potential spread of the COVID-19 virus. The resulting dashboard from this project indicates the number of current patients at all hospitals in the region, and a prognosis for potential new patients and those requiring intensive care based on different r-values. This provided a better basis for planning where and how to allocate resources in the Helse Midt-Norge region. FME is used to continuously integrate updated COVID-19 data between several APIs provided by the health authorities and ArcGIS Online Services running behind the dashboard. The workspaces developed run every day to update the ArcGIS Online Services with updated information. FME made it quick and easy to develop the integration between the different APIs and the ArcGIS Online Services. The solution is easy to maintain and runs smoothly. Helse Midt-Norge is responsible for providing specialized health services including physical and mental health to residents of Central Norway. The work done by Helse Nidt-Norge was done in partnership with Geodata AS.
The City of Delémont needed to set up a workflow where data capture from the field would automatically trigger certain processes when recorded. With a very limited budget, solutions had to be very simple, based on existing components, and costs had to be minimal. Thus, they turned to FME to optimize their data capture and follow-up maintenance processes. The solution consisted of a mobile app based on ESRI's product Survey123. This application lets the administrator set up a geo-located survey through an Excel spreadsheet. The field captured features are stored on the ArcGIS Online cloud platform. FME took care of the workflow itself. Once a new record was saved on ArcGIS Online, it triggered FME to read the associated data and generate a PDF report. This report included all necessary attributes and related images. Next, FME sends an email with the PDF report attached. FME was very accessible and ran the whole process at very low cost. It took out the need to do things manually. Field observations are now efficiently transmitted in almost real-time to the engineer in charge. The City of Delémont has about 12,000 inhabitants and is the capital city of the Swiss canton of Jura. The GIS-Dept has two employees, in charge of all utility networks, such as water, wastewater, electricity, and gas. The work done by the City of Delémont was done in partnership with INSER.
Waterschap Limburg conducts many mowing activities in the summer and cares for 216 protected species at risk, each of which is vulnerable at a different time. They needed to have a mowing plan that took into account the protection of flora and fauna and that a number of species of plants and animals were legally protected. Through FME, various data sets were linked to established “rules”. Based on the analysis that was then done, a mowing plan was set up with FME. The process became much more efficient. Analysis now takes only a few minutes and data is brought together without changing the source data. The mowing schedule was adjusted at many locations. Measures are now being taken at these locations to protect species as much as possible. FME workspaces are expected to be used for a long time to help manage them. Waterschap Limburg ensures safe dikes, dry feet, and clean and sufficient water in the province of Limburg. Their policy is determined by an elected board.
With social distancing playing a key role in the national response to COVID-19, UKMap users became interested in data on pavement widths. Geomni UK needed to quickly develop a method to analyse the database and deliver a pavement width map. It would contain crucial information to those planning and implementing government guidelines. Using FME Desktop with support from 1Spatial,Geomni UK was able to analyse and calculate the average width of pavements, quickly supplying the data as a value-add to UKMap. Users can now clearly and quickly identify the space available thanks to a colour-coded system: green indicates a width of more than three metres, yellow indicates pavements of between two and three metres, and red indicates an average width of less than two metres. FME Desktop and consultancy were key ingredients in this project’s success. FME’s rapid prototyping and processing capabilities, in addition to its friendly user interface, were also key benefits. Now, colour coded data quickly and clearly shows distances on Greater London pavements. Geomni UK uses remote sensing and machine learning technologies to gather, store, process and deliver highly accurate geographic and spatially referenced information. The work done by Geomni UK was done in partnership with 1Spatial.
Yarra Valley Water’s challenge was to efficiently manage the constant changes in their information systems database. Managing precise descriptions of water, sewerage, and recycled water that are accurate enough to be used for commercial and engineering decisions is a major undertaking. The physical network constantly changes as it expands and accommodates new demands from customers. Moreover, much of the work is conducted by sub-contractors, who do not have access to the Yarra Valley Water information system. Yarra Valley Water worked with 1Spatial to develop a new and advanced Development Industry Translator (DIT), specifically to manage updates to the system. The DIT application uses FME Server to transform complex spatial data and translate data from one format to another. It allows systems designers and external contractors to load their engineering drawing in DGN or DXF format. The data is then automatically validated, ensuring they meet engineering drawing standards and then transferred to the G/Technology system with minimal effort. The Development Industry Translator is built around the FME Server product developed by Safe Software. The DIT application is used to validate changes to the database that are presented as CAD files and to publish them in G/Technology with minimal human intervention. FME also helps verify the attributes in files and recognizes any geometry or attribute errors, which are compiled into an HTML report and given back to the user that submitted the review request. When this is finished, FME transforms the CAD drawing file into a geometry that can be understood by the G/Technology geographic information system and uploads the new data to the database. The entire process, from the creation of the drawings through to posting them as changes to the database, is automated. Yarra Valley Water is the largest of three retail water organisations owned by the Victorian Government. It provides water, sewerage, and recycled water services to more than 1.7 million people and over 50,000 businesses in the northern and eastern suburbs of Victoria’s largest city, Melbourne. Yarra Valley Water retails this water to households and businesses located as far north as Wallan and as far east as Warburton, an area of about 4000 square kilometres. The work done by Yarra Valley Water was done in partnership with 1Spatial Australia.
Each year, Eau 17 receives more than 200 km of topographic maps for quality control and integration into various databases. Eau 17 needed to optimize pre-integration quality control operations by automating and improving existing steps. The objective was to implement a tool compatible with a web map for data control, while automating the process to save time for surveyors. Submitted maps also had to be in a new format: shapefiles. To meet these needs, Eau 17 turned towards FME and a web mapping solution from Sirap called X’Map. This is what their old procedure looked like:
- Geometers would carry out field work
- They would send Eau 17 their maps that comply with the EDIGEO standard
- An Eau 17 agent checks the quality of the batches with respect to the requirements of the specific technical specifications
- If valid, the integration batches are activated in the business software and "reconciles'' the newly imported maps with the maps already integrated.
- Additionally, a weekly scheduled task exports the data in SQL and reimports them into the PostgreSQL/PostGIS database for use in a web map
The Verbund AG subsidiaries manage a total of 22 hydropower plants, including 8 Inn power plants and border power plants along the Inn from Tyrol to Passau. The objective was to develop a cross-border map with all necessary geodata using a unified coordinate system in a single web map. There were two major challenges in Verbund AG’s project that FME helped solve: digitizing cable layout plans and changing from the old Gauß-Krüger coordinate system to the UTM system in Bavaria. FME allowed for the transformation of geodata into a common reference system, georeferencing of analogue plans, digitization of cable routing, and integration of data into a web map. The scanned cable plans were georeferenced based on the cadastral data and world files were created. Control cables, cable distributors and ducts, and any protective pipers and terminations were digitized in sections for each power plant. The data model was delivered with the geo-referenced raster data and the recorded data in a geographic database. FME helped save time by making data available in one centralized system. Information is only collected once, can be found quickly, and easily passed across departments. The workflow is mapped in one system and there is only one web interface needed. Verbund AG is Austria’s largest electricity provider and covers around 40 percent of electricity demands in Austra and generates 90 percent from hydro power. In addition, Verbund operates the supraregional power grid through its subsidiary APG. The work done by Verbund AG was done in partnership with Axmann.
The municipality of Bergen op Zoom wanted to deploy parking attendants more efficiently by using a scan car. The scan car was able to scan individual license plates, but were not able to display their results on the corresponding parking maps. Additionally, the maps that they had of the parking areas weren’t all up to date. The software used by the scan car wasn’t able to use the provided shapefiles with multiple codes in different columns. By using FME, Bergen op Zoom was able to transform their data and link the proper attributes containing the main codes to the proper shapes. FME was also able to help update the parking maps to group parking meters in designated parking zones according to their needs. By using FME, parking attendants can use their time more efficiently and to perform other important tasks. Now, parking areas can be effectively monitored several times a day. Bergen op Zoom is a city in the Dutch province of Noord-Brabant.
Alingsås kommun wanted to connect their existing eService platform (Open ePlatform) with FME to help employees by making geodata available and easy to access for every one of them. To allow all employees to use different types of geodata in different formats, the GIS unit was commissioned to create several eServices to be used by all employees. The Alingsås municipality mainly uses eServices to simplify processes and gain a better overview of their tasks. To do this, they used FME. Their eService sends an email to FME Server after a data request has been placed, then FME Server handles the email, reads if an XML file is attached, and translates the content to process the request. Once the process is completed, an email is sent to the customer with a ZIP file of their requested data that the customer can download. With Automations in FME Server, it’s possible to trigger this workflow automatically (Fig. 1). Figure 1. The Automation in FME ServerFigure 3. Mail containing the link In the Alingsås municipality, almost 4,000 employees work to provide good community service every day to residents, visitors, companies and associations in accordance with their values: commitment, openness and respect. Geodata Order transition: selection of datasets. 4 different points need to be placed in the map The work done by Alingsås kommun was done in partnership with Sweco.
Here's how the Automation works. The Automation first tests if a valid XML file is attached in the email. If not, an email will be sent to the customer. If there is a valid attachment, the attachment will trigger the workspace to run (Fig. 2). If something goes wrong within the Automation, an email will be sent to the customer. Once the workspace has ended without any problem, an email from the GIS unit will be sent to the customer containing the link to download the requested file (Fig. 3).
BlueDot needed an enterprise integration solution to bring data into their global early warning system for disease outbreaks. Challenged with a huge array of data sources, they leverage FME to automate complex data and application integration workflows, build enterprise integration patterns, and synchronize processed data with their products. By leveraging Dynamic Engines in FME Server, they are able to spin up as many engines as needed across multiple machines to manage peaks in data processing demands. BlueDot is able to monitor 200 infectious diseases around the world on a daily basis in order to identify disease activities and contextualize disease outbreaks. By automating web scraping for disease related data, they were able to issue an alert through their Insights platform about COVID-19 seven days earlier than the World Health Organization. FME also enables them to deliver data and analytics insights to their clients’ preferred cloud data storage locations, such as Amazon S3, ArcGIS Online and Snowflake. BlueDot empowers responses to infectious disease risks around the world using human and artificial intelligence, helping governments, businesses, and healthcare organizations safeguard lives and livelihoods.
Powerlink wanted to create a fully automated, data-driven Emergency Management system for bushfires, cyclones, flooding, thunderstorms, and earthquakes. This involved consolidating infrastructure data, monitoring for severe weather events, performing impact analysis, and sending informative reports to stakeholders when infrastructure is at risk. Using FME, they built a connected series of workflows to monitor for events, such as when a meteorology website posts a weather alert, and analyze the potential risk and impact. When emergency criteria are met, FME automatically delivers reports to stakeholders in accessible formats like PDF, which contain layered maps that enable decision-making. The fully automated, FME-powered system runs an average of 2500 jobs per day, monitoring for events, sending notifications, and generating mapping products. With their automated Emergency Readiness system in place, Powerlink’s staff can make decisions based on informative datasets. Since notifications are only sent if emergency criteria are met, stakeholders can focus on critical information, reducing the time spent on emergency event handling from days to hours. Powerlink Queensland owns and operates a high-voltage electricity transmission network servicing 4 million customers across Eastern Queensland, Australia.
The Child Abduction Response Team (CART) in the City of Oshkosh wanted to enable real-time mapping and spatial data processing to help quickly deploy targeted search and rescue resources. They use FME to automatically process and map incidents, leads, and assets. For example, FME connects the lead tracking SQL database to ArcGIS Online, and keeps the map up to date with new information reported by the public. The map shows the Place Last Seen and a quarter-mile buffer, enabling the team to focus initial search efforts within that area. Automatically generating maps frees the GIS team to focus on tasks that depend on human judgment, like verifying leads before they get mapped. Using FME ensures the spatial data is mapped more accurately and efficiently. Data is processed and sent to ArcGIS Online within seconds, giving CART members real-time information and enabling fast decision making. The City of Oshkosh is the 9th largest city in Wisconsin, USA, with a population of about 67,000.
NamPower wanted to build a Supervisory Control and Data Acquisition (SCADA) Dashboard to enable staff to view and analyse live powerline activity. They used FME to integrate spatial data from multiple sources, including powerline voltage and power plants from their existing microSCADA system, network data from Smallworld GIS, and vehicle GPS data from a cloud database API. FME displays this on an HTML web page with an interactive Google Map and keeps it up to date with new information. This dashboard provides an integrated view of all information and enables staff to see power flows via the web. Engineers can view critical data and make decisions in the field. Following the success of this project, NamPower is also using FME to connect asset data collected in the field with their master GIS. FME automatically validates data from Azure Cosmos before adding it to Smallworld on a weekly cadence, ensuring staff have access to current information. NamPower is Namibia’s national power utility, with a world-class transmission system and one of the longest networks of overhead power lines in the world.
FME enables the City of Coquitlam to solve diverse data integration challenges across multiple departments and contributes to the delivery of quality programs and services. Building on the success of existing FME use cases, the City of Coquitlam now needed to integrate data between IBM Maximo, Tempest (the city’s utility billing system), and a third-party recycling and garbage cart vendor to process service requests in a timely manner. Using FME, the workflow parses Maximo for requests that need to be addressed, such as the exchange of garbage or organics carts or the delivery of new carts, and creates a work order spreadsheet that’s sent to the vendor. Once updated work orders are returned from the vendor and entered into Maximo, FME automatically modifies the resident’s utility bill in Tempest to reflect changes in cost. By fully automating integration processes and removing data silos, the City of Coquitlam sees significant improvement in data integrity and accessibility between its internal teams and external vendors. They are also equipped with actionable insight that enables service requests to be addressed quickly while minimizing potential manual errors in billing. With FME, the time taken by staff to complete cart transactions has been greatly reduced. Coquitlam is the 6th largest city in British Columbia with over 150,000 residents and more than 80 municipal parks.
The Insurance Bureau of Canada tasked Tesera Systems with creating a web app to help analyse the risk of residential sanitary sewer backup to municipal infrastructure. Tesera built their solution using FME Cloud as the data processing infrastructure, Amazon Web Services (AWS) S3 for data storage, and AWS SQS for task queuing. They set up FME to watch for SQS messages, process GIS data submitted via the app, perform data validation, and output model indicators for further analysis. They performed machine learning on the resulting datasets, which integrated insurance claims with infrastructure data, to help predict the risk of a sewer backup. Using FME Cloud for this AWS-based project enabled Tesera to automatically process huge volumes of data in the cloud while keeping infrastructure costs low. Since FME Cloud is hosted in AWS, they were able to leverage data gravity and create a performant solution. Municipalities using this web application can take action to improve infrastructure in high-risk areas and identify which areas require flooding emergency plans, resulting in valuable risk mitigation and cost savings for the Insurance Bureau of Canada. Tesera Systems is a Canadian consulting services company that integrates FME into their innovative data driven solutions and geospatial applications.
The City of Burnaby needed to provide a “Call Before You Dig” service to ensure the protection of underground utilities from excavation in a timely manner. Due to an exponential increase in new development throughout the city, the volume of applications to dig increased by more than 6,000% within the past two decades and continue to grow. Bound by a provincial requirement to provide underground information packages within three days, the city implemented FME to power an automated service to meet this demand. Applicants now receive their underground information package within three minutes, without staff intervention. This allows city staff to maximize their time towards other high-impact services and alleviates the risk of manual errors. FME has enabled the GIS team to transform the way requests are processed at the city and set a leading example for operational efficiency in North America. Burnaby is the 3rd largest city in British Columbia, located at the geographic centre of the Metro Vancouver Regional District.
The City of Lévis wanted to optimize the data sharing and delivery process for managing pothole repair requests. The goal was to deliver greater transparency and efficiency to the way potholes repairs are reported, managed, and communicated. The city partnered with Consortech to implement an automated workflow in FME that would trigger the repair process once a pothole has been reported online. Based on incoming geolocation data submitted through a web application, this trigger automatically kickstarts a work order, sends a series of status notifications to the resident once the repair begins, and delivers a weekly maintenance report to the city's stakeholders. FME enables the city to keep systems updated and synchronized, and delivers actionable and timely insight to on-site crews, residents, and key stakeholders, with little to no manual intervention. The result is an optimized and effective reporting service that increased public engagement, collaboration, and operational efficiency. The city has seen a reduction in call reports by 80% and significant time savings equivalent to 23 days of work, which enabled staff to allocate resources towards other high-value services. The ability to share information as fast as possible has also allowed the city to effectively target routes that require the most attention while keeping the public informed and up-to-date. Lévis is the 7th largest city in Quebec, Canada with a population of 145,000.
Santa Clara County had the goal of improving their emergency services response time and location accuracy. To do this, their IT department wanted to build a dynamic map of city-sourced address points for their 911 dispatch system, which predated GIS. Using FME, they aggregated 15 city datasets and supplemented them with public safety layers. FME helped to identify issues like duplicate addresses, as well as generate multiple output formats, like GeoJSON, within the same workflow. They were able to create this standardized address dataset while allowing each city to maintain their existing schemas and workflows. The result was the Regional Address Map for Public Safety (RAMPS) and the Regional Address Map (RAM; for non-public safety), which empower cities to contribute addresses on a quarterly basis. This system has increased the number of known addresses by 50% and helped improve the county’s emergency services. The County of Santa Clara is California's 6th most populous county, with a population of nearly 2 million.
The City of Henderson partnered with Consortech to simplify and automate CAD to GIS conversion as part of their digital plan submission process for new construction projects. At the heart of this challenge was time spent on manual data entry and processing, duplicate work, and the risk of errors. With Consortech’s experience in helping municipalities optimize similar submission standards, FME was chosen as a data integration, validation, and automation platform to integrate CAD data into the city’s GIS and asset management systems. Through one automated workflow, FME delivered a reduction in data integration time by 75%. FME helped the city improve operational efficiencies, save time, and ensured CAD data validation before converting to GIS, while preserving the integrity of the source data. Today, land developers submit their drawings through the city’s web portal and instantly receive an email confirmation or an error report. The City of Henderson is the second largest city in Nevada and is home to over 300,000 residents in the Las Vegas Valley.
Warwickshire County Council wanted a broader understanding of the county’s health and social care needs to enable decision making, plus to measure the effectiveness of services. To do this, they needed to automate the retrieval of public health data from multiple online sources, including Hospital Episode Statistics (HES), data.gov.uk, Fingertips, and NaPTAN. Previously, new data was downloaded manually on a monthly or nightly basis. Using FME, they built workflows to download new data from APIs, extract a full history of data, generate schemas, analyze the data, and send it to their PSQL relational database. They leveraged FME’s repeatable workflows to reduce the effort of manually refreshing datasets, plus to minimize network traffic through batch calls and bulk downloads. They used HTTP, JSON, and SQL scripting functionality to connect a variety of REST APIs to their relational database. FME was able to handle massive ~60 GB text files and gather schema information from HES data where other software wasn’t. Warwickshire County Council now has multiple sources of health data loaded into their PSQL infrastructure in a formatted, user-friendly structure. With a few straightforward workflows, FME has automated hundreds of hours of manual effort, freeing their analysts to work on more important tasks. Warwickshire County Council governs five districts and boroughs in England. The council manages roads, social services, education, libraries, and other local government services.
GHD wanted to gather business intelligence from financial data by performing natural language processing to find abnormalities and investment diversification opportunities. This data science project involved text mining on massive amounts of unstructured data from an online archive. Using FME, they built an API to collect over 21 million U.S. Security & Exchange Commission (SEC) quarterly filings from the Electronic Data Gathering, Analysis, and Retrieval (EDGAR) website. This workflow involves reading column-aligned text, unstructured text, and HTML/XML. FME is used to clean the text data, parse it into financial information, analyze it using natural language processing, and perform sentiment analysis to find changes in language over time. The data is then written to SAP HANA for further BI tasks. The resulting FME workflow performed data enrichment and analysis on large amounts of unstructured text data. GHD was able to create a database of companies who use the EDGAR system, collate financial data in SAP HANA, and execute machine learning algorithms in an automated process. GHD provides architecture, engineering, construction, advisory and digital services to private and public sector clients.
Denver International Airport has to manage facilities and building information models (BIM) that change daily, including many active construction projects. Using FME, they update and convert Revit and Civil 3D models to endpoints like GIS, PDF, and AutoCAD, which can then be shared across teams. Automating these conversions ensures all departments are working with the latest data models. To generate their interactive online map, DEN Maps, they integrate floor plans, assets, and infrastructure from IBM Maximo and other sources. Airport staff and passengers can use this map to see information about the airport’s spaces and infrastructure. Denver is the largest airport in North America by land area and has received dozens of international awards for excellence, including by SKYTRAX and ACI.
Finavia worked with Spatialworld to improve the safety and operations of Finland’s airports through obstacle avoidance, airspace planning, and automating processes that were previously manual and time-consuming. Using FME, they automatically generate PDF maps for security, ports, police, and fire, by processing topography data from DGN and PostGIS. They also build topographic, cadastral, and basemap databases by retrieving data from National Land Survey and writing to PostGIS. Flight obstacle maps are generated by integrating Finland’s LAS (point cloud) datasets, analyzing the data, and identifying high elevations. To manage water monitoring data from sensors, they automate the process of checking the XML file provided by consultants, performing QA, triggering an email, then transforming and converting the data to PostGIS. Their workflows for flight obstacles involve reading from Excel and HTML, generating an HTML report, and writing to Oracle with a map and feature information. With these workflows that extract data from various sources and convert them for sharing and analysis, Finavia is able to reduce tedious manual processes, enhance data quality, and improve the operations of all 21 Finnish airports. Finavia manages Finland’s airports, which consistently rank among the top airports in Europe for their smooth and efficient operations.
The City of Surrey is removing data silos between systems, enabling staff to use the best fit-for-purpose applications while exchanging valuable data between departments. The city’s IT department chose FME to replace database level integrations and manual workflows in their Water Meter Improvement Project with near real-time API based updates. Now when someone wants a water meter installed, they request a permit using AMANDA, and FME orchestrates live communications between AMANDA for permitting, Cityworks for Asset Management, and Esri for GIS. Meter status can now be viewed by the public prior to installation, and coordination between inspectors, contractors, city engineers, taxation staff, and surveyors is handled automatically. Once installed, meters are immediately marked as in-service, rather than weeks or even months’ delay. Surrey is the 2nd largest city in British Columbia, and is ranked one of the youngest and most culturally diverse cities in Canada. The city has been selected by the Government of Canada a finalist in the Smart Cities Challenge.
Victoria International Airport (YYJ) wanted to improve passenger experience by enabling indoor mapping via Apple Maps. Using FME, they integrated their floor plans and facility information from Esri Geodatabase, and transformed it to meet strict IMDF (Indoor Mapping Data Format) requirements. After georeferencing, schema mapping, validation, and data conversion, the airport can now be navigated in Apple Maps. Passenger experience has been improved with this innovative wayfinding technology, and airport staff can easily track changing infrastructure on an up-to-date map. Victoria International Airport is the 11th busiest airport in Canada with over 2.04 million passengers per year. Victoria is well served with more than 100 daily flights throughout North America. YYJ was rated among one of the top ten most-loved airports in the world by CNN Travel and was twice named ‘Best Regional Airport in North America’ by Airports Council International (ACI).
With many projects related to Data informatization in China, Antu helps their clients use FME to quickly solve data integration, data warehousing and distribution, and data quality control challenges. When China’s Ministry of Land Resources required each province to reduce map scales in the 2nd Land Survey, Antu was tasked to help Chongqing Department of Land Resources reduce the size of their maps from 1:10000 to 1:50000 and 1:100000. The direct outcome was that the initial work done by one FME data engineer not only met the client’s requirements, but also greatly reduced data processing time. By using FME, Antu saved the client 2 months of 40 people’s work. Beijing Antu I2M Corporation Ltd. has several FME experts and trainers who work alongside FME users. They are dedicated to FME localization and have used FME to solve data problems in various industries and localized many FME training materials.
McDonald's China needed to integrate data to power business decisions such as new restaurant site selection, growth modeling, and delivery modeling. They chose FME for data integration, and worked with Safe Software Partner Beijing Antu to implement their projects. Using FME, data is now integrated between multiple business systems, including population, income, customer traffic, base maps, and other data. The workflow is automated, enabling the movement of data in real time, in response to events, and to perform spatial analysis. By implementing FME for data integration, they greatly improved efficiency and decreased their costs. They now have complete insights into important business data for drafting development strategies, new location assessments, delivery optimization, customer analysis, and reviewing and modeling current business growth. McDonald's is one of the largest restaurant brands in the world.
HERE Technologies needed to make their maps attractive, showing the correct level of detail to make regions easily identifiable by locals. The team used FME to process more than 4 million features that represent almost 300 million vertices, and can run this workflow volume in one day. For example, they calculate river widths and discard the smallest rivers that won’t have good representation. The team builds automated, dynamic, fast data transformation processes with FME, without writing any code. The maps they output are readable, showing the correct level of information to make them easily identifiable by their region to those who know the area. The maps can then be successfully used to empower HERE’s business intelligence research. HERE Technologies has the mission to create a digital representation of reality to radically improve the way everyone and everything lives, moves and interacts.
Alabama Power Company wanted to use UAVs to save cost and increase staff safety for inspections and storm evaluations for inaccessible feeders. They are using FME to pre-identify inaccessible feeders as potential drone friendly corridors. They are developing a solution using FME to plan and visualize 3D flight paths to have a better picture before they fly. After the flights, they use FME to post-process index, catalog and deliver imagery that their UAVs capture. FME gives the team flexibility to plan flights according to their requirements and governing regulations, reducing human error. This saves time and helps dispatchers across the state to know where to send drone crews. It also enables them to quickly post-process the data, automating data collection, storage, metadata extraction, cataloging and distribution. FME then automates making the missions available in a web map, visualized on a dashboard, and catalogued in reports. Alabama Power Company is a subsidiary of Southern Company, and provides electrical power to 1.4 million customers in the USA.
CAE needs to create the imagery that pilots see outside the window in aeronautical simulations for training purposes. The CAE team uses FME to transform data in many ways. For example, they’ve created light maps, which are simulated night scene imagery that uses free OpenStreetMaps (OSM) data. They’ve also created winter scenes from summer scenes, using FME to composite the OSM data street data with the summer scenes to virtually plow roads. FME regularly saves the team time and makes complex data manipulation challenges possible to overcome, quickly. For example, they have reduced manual data transformation tasks that took 2-3 days, replacing them with a series of chain workspace in FME Server: now one person drops a file in once a month, and FME will process it five different ways, send emails to the relevant people, and post the results to a database. CAE is a worldwide leader in training for the civil aviation, defence and security, and healthcare markets.
The Vancouver International Airport (YVR) wanted to provide passengers with indoor mapping data via their mobile app. Using FME, they combined source data from Maximo with CAD. The FME workspaces standardized and performed quality assurance and validation checks (QA/QC) before converting the data into an ArcSDE GIS database. They published FME workspaces to FME Server to nightly filter, convert, and aggregate floor spaces into new datasets (ArcSDE) that only contain public spaces of the airport, and convert this dataset into GeoJSON for delivery into the YVR Digital Gateway, an enterprise service bus deployed on the Microsoft Azure cloud platform. This dataset is then used for the creation of three final products: the 3D interactive indoor map in their app, an AVF (now IMDF) dataset they submitted to Apple, and a leaflet indoor basemap for yvr.ca. YVR is one of the first to provide its indoor mapping data to Apple Maps, and its GIS team has proven their innovation by providing a variety of ways to navigate the public indoor spaces of the airport using digital technology. Vancouver International Airport, Canada, serves over 22 million passengers per year, and has won the SKYTRAX Best Airport in North America award for eight years running.
1Spatial was challenged to come up with an automated way of delivering live vessel positions to an online mapping system, with no available infrastructure and the solution needed to be live in a week. Supplied with the customer’s vessel position data from an API, 1Spatial deployed a solution using FME Cloud in conjunction with ArcGIS Online to create a live fleet positioning system that would update vessel locations every two minutes. With the source data and target platform; ArcGIS Online, already in the cloud, an FME Cloud approach gave the customer a cost effective and infrastructure free way to solve their problem. Logging and automated email notifications were added to ensure that both 1Spatial and the customer were notified if any of the system components failed. In addition, the locations of all the tracked vessels were archived, also in the cloud, so that any day’s activity could be replayed at any time from the archive. 1Spatial are global leaders in managing geospatial data and build long term partnerships with their clients, delivering real value to them through automated, rules-based solutions that are grounded in a deep understanding of their needs and challenges.
Barnsley Metropolitan Borough Council needed to migrate more than 10 years worth of data into Microsoft SharePoint. The team, supported by 1Spatial created FME workflows that migrated the data while maintaining access permissions and complex metadata. They were able to build and test the workflows quickly themselves. The main advantage was that they could adjust the routines many times: they could handle different parameters, add permissions, and even build a folder hierarchy within SharePoint to sit above a migrated document. FME was flexible to resolve all of the unique and complex document migration issues the project presented. Barnsley Metropolitan Borough Council represents 230,000 residents in South Yorkshire, United Kingdom.
FortisBC needed a more efficient way to assess the current wildfire threat to its gas and electric assets, including its customers so that their Operations Managers could take immediate action. The GIS team created an FME workflow that integrates active wildfire data (obtained from the provincial government BC Wildfire Branch via DataBC) into their GE Smallworld environment. The FME Server runs automatically every two hours to match the frequency that the source dataset is updated. The output is made available on the server for Operations Managers and Emergency Responders to access via VPN as drawings, reports, plots, Excel files, and KMZ files. The system makes this integrated view of wildfires and assets available for better decision making, while saving time gathering data for both the first responders and the GIS team. FortisBC is the largest natural gas utility and second largest electrical utility in the province of British Columbia, Canada. FortisBC has 1,000,000 gas customers and 170,000 electric customers.
FACTO GEO needed to prepare hundreds of maps daily to help their surveyors in the field do their work more efficiently. Using FME, the team build a single workflow that reads text and XML input files, databases via PostGIS, and WFS-services, and then transforms this data using pre-built transformers (filters, coercers, choppers, mappers, extractors, stylers, clippers, and sorters), converting them into three types of output files: DWG, DXF, and PDF. By hand, this process would have taken 45 minutes per 1 combination of the 3 output files, but using this FME workflow in an automated batch process, it now takes less than one minute. As a result of this efficiency, they are now building more workflows to automate other processes within their organization. "Our overall impression of FME is that it is very intuitive to work with. The GUI and log are helpful tools to find out were a problem might be. Furthermore, if you are thinking about implementing a certain operation, it is almost certain already an existing transformer within FME. FME fits like a glove," says Ronny van Laarschot of FACTO GEO. FACTO GEO employs the largest number of surveyors in the Netherlands. They offer services to the Government, The Netherlands Cadastre, the Petrochemical Industry and the Construction Industry.
Bonava needed to migrate teraybtes of files from various legacy systems in eight countries and multiple languages into A360. They worked with Sweco to use FME to automate the migration. They used its graphical user interface and library of pre-built transformers - including the AutodeskA360Connector, build using the Autodesk Forge API - to create the three workflows they required, without writing code. The first workflow restructured data file systems into a single A360-compatible file structure. The next uploaded the data to the cloud in the correct order for A360 to recognize iterations of the same file. The final workflow verified the success of data uploads and provided quality control. Bonava now has a unified system on the Autodesk A360 cloud data sharing platform. Bonava is a subsidiary of the leading Northern European residential land developer NCC. Sweco’s vision is to become Europe’s most respected knowledge company in the fields of engineering, environmental technology and architecture.
Comporium needed to migrate to GE Smallworld from Esri ArcGIS and Bentley Microstation. They worked with Ubisense to perform the migration. They built FME workflows that imported Shape and DGN data into Smallworld. By merging three serving areas and databases into one GIS, they will be able to better manage their facilities and make better informed business decisions. They can now trace over their entire network, including fiber, copper, and RF facilities, and have increased visibility of their GIS data across the enterprise. This will improve accuracy and bring benefits that are not fully realized at present. Comporium, one of the largest telecommunications companies in the USA, has been in business for over 120 years. Ubisense is a global leader in Enterprise Location Intelligence solutions.
New York City’s Department of Information Technology and Telecommunications (DoITT) needed a 3D building massing model for the City’s 1,000,000 buildings. AppGeo worked with DoITT to define the approach and data model, manage the effort, and provide QA/QC. AppGeo modeled all buildings in 3D according to the Open Geospatial Consortium (OGC) CityGML specification. AppGeo then designed an FME workflow to analyze and automate CityGML data and generate reports, efficiently checking variables including: closed 3D objects, direction of 3D walls, and validity of CityGML types associated with each building. The 3D building models, alongside the planimetric data recently updated by AppGeo, support new ways to model and analyze the built environment and City landscape, such as this extensive study published by The New York Times that mapped shadows across the City. Access to the 3D data along with viewing tools is provided by the City. DoIT provides the IT services, infrastructure, and telecommunications for New York City, USA. Applied Geographics (AppGeo) is a Safe Software Partner and provides consulting services and innovative solutions to solve specific geospatial IT needs.
Stad Lier wanted to analyze a wide range of data in QlikView using efficient techniques. They wanted to integrate data from 18 suppliers, 46 applications, and more than 2,500 datasets. These datasets were varied and included CAD, GIS, raster, office data, web data, and more. In their research for a solution, the team ran a comparison of 13 different ETL products and in the end concluded that FME was the only perfect match for their needs. The team uses FME to extract all of this raw data and perform quality control and corrections as required. By using FME they manage their integrations in a clear, documented, and expandable fashion. Scheduled FME processes send the integrated data to PostGIS, which QlikView is connected to. As a result, their analysts are able to visualize all of the data they need in Qlik. Stad Lier is a municipality located in the Antwerp province of Belgium.
The Metering Services team at Georgia Power uses FME to compile and analyse data. For example, they used FME to locate 1,000 installed meters with a factory defect, enabling field personnel to replace them in 1 week compared to the previous 4 months. Another FME workspace was designed to compare several systems at the database level, which found a discrepancy that had resulted in 2.5 million dollars in unbilled revenue since 2004. FME processes large database to populate a “Morning Report” using business intelligence to provide data updates to individuals only if their action is required. It also models databases from many sources to detect meter tampering; looks for anomalies in databases that applications can’t see; translates data from legacy systems; and feeds data to dashboards such as the Automated Metering Infrastructure (AMI) and Meter Equipment Tracking System (METS), various SQL, Access, and Oracle databases, and internal web sites including Microsoft BI, Tableau, and ArcGIS Server / Portal.
MapData Services needed to help client Geoscience Australia (GA) deliver terabytes of elevation data more efficiently. They chose FME Cloud and AWS (S3) to provide an automated system for data delivery that was scalable as new datasets were added. Named the Elevation Information System (ELVIS), it provides users the ability to download data for their area of interest in both the format and coordinate system of their preference. Implementing the data delivery system in the cloud has improved reliability and allowed requests for information to be handled automatically. Government, academia and the public can now access GA’s elevation data holdings by email in 5 minutes, and large orders can be downloaded within the hour. The project has reduced costs by 600%, manual effort by 80%, and delivery speed by 98%. Geoscience Australia is the country’s national geological survey. MapData Services is a premium specialist in the digital mapping and data market.
Increasingly, clients of DeepOcean are asking for Seabed Survey Data Model (SSDM) compliant data as recent GIS requirements for data delivery in seabed survey projects become more standardized. STATOIL was among the first. DeepOcean created an FME data workflow that is invoked in the background as users work in the DeepOcean DBMS system while processing data on a marine vessel. It integrates data from various sources including EIVA, AutoCAD, Esri Shape, Microsoft SQL and Excel, and ASCII, and converts them to comply with SSDM. By building FME workflows, they were able to keep their existing database and workflow intact, and simply transform and reformat data automatically for delivery in SSDM. The process is easy enough for personnel without GIS knowledge. FME also opened many other possibilities including on-the-fly visualization of data and automated quality control procedures. Implementing FME removed the need to invest in development time to implement client requirements. DeepOcean provides services and technologies for the subsea industry.
The adoption of more cloud-based solutions like Salesforce and Amazon Web Services would provide the Surrey Heath Borough Council with operational benefits, but they wanted to ensure they could integrate with legacy on-premises databases when necessary. They also wished to automatically synchronize data in systems across the organization. With the help of Sterling Geo they used FME technology to connect applications through automated data transformation workflows and achieve enterprise data integration.
Sterling Geo needed to demonstrate the value of earth observation (EO) data by delivering between 1 and 100 applications in one year, to 1-100 public sector and government organizations, under a grant from the UK Space Agency. The team needed to stand up as many applications as possible under a short deadline, without a pool of developers to create functionality. They chose FME to create APIs and rapidly deliver web services without writing code. They deployed FME Cloud, meeting the satellite data where it was housed, on AWS under Amazon’s Open Data Program. So far, 20 apps have been built for over 150 government organizations. Prototyping was quick and inexpensive, with servers on the cloud only paid during demonstrations, and no infrastructure changes upon deployment into production. The apps have enabled users to understand first hand how EO monitoring can be fed into strategic planning cycles. Sterling Geo is a geosolutions company that specializes in finding innovative approaches to engineering geography.
Iowa DOT wanted to build APIs to make their real time public data more accessible, and open it to innovative applications. The team created near-real time FME workflows that read traffic operations XML feeds like cameras, DMS, 511 events, and Waze. The Iowa DOT also created a custom API library along with Esri Road & Highways. These workflows transform the data through filters and formatters, and provide it to the public in a variety of usable formats including Oracle Spatial, ArcGIS Online REST Services, email, and JSON/XML. Examples include: ArcGIS Online REST services and Feature Collections provide the ability to create map mashups with little effort; local TV stations use the KML data streaming service, powered by FME, to integrate plows, plow cams, and road conditions with their on-air weather software; and a transformation API called SkyFire, built on Oracle and Esri Roads & Highways, provides “One Call, That’s All” returning results in XML or JSON. Iowa DOT maintains over 9,400 miles of roadway and 4,092 bridges to serve the transportation needs of the state’s citizens.
The University of Oxford is mapping the human eye with GIS & FME to assess the progression of genetic eye diseases and the effectiveness of trial treatments. FME & GIS map and analyse the human eye to measure how diseases change cells, and to monitor experimental treatments. For one clinical trial, FME georeferenced raster images, generated polygons, and overlapped them to identify disease progression. For another, FME performed various analyses including creation of terrain profiles, classifications, and axial lines, which were used to quantify changes in the disease processes. Outputs have also included digitised CSV files, extruded 3D models, and 3D PDFs. As ophthalmic imaging contains spatial features, using software designed for spatial data has allowed the team to draw more information from their data and develop innovative ways to analyse it. They plan to expand the work to other diseases, and have interest from others in the field. Oxford University Hospitals is a world renowned centre of clinical excellence and one of the largest NHS teaching trusts in the UK.
Georgetown Utility Systems needed to migrate asset management data to their new system and ensure ongoing data integrity. The team used FME to populate the system of record in their Esri database for their electric distribution assets. With FME, they created ongoing migration tasks from Milsoft WindMil to their GIS, with workflows that receive edits, mark assets as retired if they are deleted, and active if they are new. The workflows also detect duplicate, unsynced assets, connect scheduled events to addresses, and update the status of assets based on the Electric Circuit Model. The project enabled the team to implement their new Enterprise Asset Management System, and both ensures that the data is correctly maintained and that the workflows to synchronize assets are functioning properly. They are now building additional functionality into the workflows, and integrating FME Server to increase automation. Georgetown Utility Systems is a community owned public utility in Georgetown, Texas.
Since 2002, PNM’s GIS department has used FME for many data automation tasks including conversion, extracts, reports, analyses, data quality and improvement, and error checking. Of these FME workflows, at least 25 workflows are run on a schedule. They perform tasks such as providing outage data every 10 minutes, and daily processes including generating point features indicating bird related outages for the Environment Department, checking for accidentally deleted power poles in the database, new service delivery data error checking, and backing up ArcGIS Online street light data. FME also performs bi-annual franchise fee reports, monthly NM One Call distribution line buffering, and many more data automation tasks. Using FME has resulted in improved, more accurate, and value-added data, allowing for better decision making and addressing new issues. It saves members of the GIS department time and the company money. Moreover, FME has become the GIS software of choice for automation and analysis at PNM for its power, speed, and reliability. PNM is the largest electricity provider in the state of New Mexico, USA.
Golder Associates needed to summarize air emissions of various chemicals due to residential and transportation factors into a fishnet of grid cells. The results would be used alongside other sources for an air quality assessment report supporting their client’s industrial approval application. They used FME to perform the required calculations, from building a fishnet of 50 km by 50 km 5 km2 grid cells, to populating it with census dissemination areas, transportation GIS data, and emissions data from their Air Group for 8 pollutants. Using FME, they then performed calculations estimating emissions by scaling residential division emissions using population density and length of highways. The resulting output provided the required fishnet of cells with ID and coordinates, air emissions for each grid cell and pollutant, and the average elevation for each grid cell. FME performed these complex calculations at the click of a button, using a documented, repeatable process that included quality assurance checks. Golder Associates is a global, employee-owned organisation providing independent consulting, design and construction services in their specialist areas of earth, environment and energy.
The City of San Jose used FME to integrate city silos, and easily adjusted their workflow when Google Maps Engine (GME) was deprecated, and replaced with CartoDB. They created automated workflows using the pre-built tools in FME’s visual interface to integrate data from disparate datasets, including the conversion of data into a standard model. They then set up FME to incrementally update data in GME nightly. After GME’s deprecation, they were able to tweak these workflows for their new environment rather than starting over. San Jose offers a light-weight, mobile friendly, self service interactive map gallery for the City’s staff and citizens. Best of all, their switch from GME to CartoDB went un-noticed by end users of the data. San Jose is the 10th largest city in the USA, located in the Silicon Valley, California.
Georgia Power uses FME to automate everyday data tasks, such as location comparisons, site analysis, and site update emails for their Community and Economic Development Group. To perform location comparisons, the team created FME workflows that convert spreadsheets and text files into usable information in an MS Access database and reports. For site analysis, they used FME to find nearby facilities and utilities, calculate usable acres for a given site, and perform additional spatial calculations to convert county parcels into a parcel score layer in their Access database. They also created FME workflows to identify sites that had not been updated in a year, compile information about them from their SDE Oracle database, and email records to the applicable representative to easily update and return. By automating these processes, the team saves hours of work compiling data, ensuring its accuracy, and delivering it to the end users. The email notification project also saw an increase of site updated in the last year. Georgia Power is the largest of four electric utilities within Southern Company.
Arup needed to convert raw survey data into a rich, spatially-enabled database for their client, who conducts an annual commuter travel survey which collects extremely detailed information about their staff and regular visitors. The data was presented to the team as a 250-column Excel spreadsheet with confusingly coded questions and answers, and baffling geographic data. They used FME Desktop to create workflows that cleaned up non-geographical data, and created spatial points for the locations in survey answers. They then output this information to a PostgreSQL database, QGIS, and a dashboard. The resulting output is a rich, usable dataset that provides the client with interactive insights from the survey results. They can use this intelligence to effectively address the limited vehicle access to their campus. Arup is an independent global practice, offering services for all aspects of the built environment. The firm is responsible for the innovative engineering of world-renowned projects such as the Sydney Opera House, the Øresund Link between Denmark and Sweden, and the Beijing Olympic venues.
The City and County of San Francisco needed to expand the automated publication of data to its open data portal. The Department of Technology staff used FME to perform ETL tasks in building their original Socrata-based SF OpenData portal. With the goal of increasing the number, and timeliness, of published datasets, they once again turned to FME. New FME workspaces include: the consumption of data from additional departments and agencies, the establishment of generalized notification services, and the automation of daily updates to key datasets. As part of a new system architecture, a new staging ETL job server provides workspace authors the ability to qualify their work under development. The enhanced ETL Job Platform improves the availability and timeliness of data that are available on the portal, providing better service to citizens while allowing staff to focus on more complex activities, and not spend time attending to the mechanics of publishing open data. San Francisco is the cultural, commercial, and financial center of Northern California, and the second-most densely populated major city in the United States.
LOGIC Solutions Group needed to resolve, load, and distribute data from numerous commercial, contracted, and internal data sets for their client, BP Lower 48 Onshore (BPX). They used FME to automate the integration and loading of this data, including cumbersome IHS and Drillinginfo data, to create an enriched dataset in Esri Geodatabase. They also used FME to calculate new fields and data sets to identify trends and competitor activity based on spatial attributes. As part of the QA / QC processing with FME, spatial and non-spatial quality checks were performed during the extract, transform, and load (ETL) process to ensure that wells are geographically located correctly in the database. The resulting dataset enriches and enhances the available information for improved decision making while saving time and money by automating and simplifying repetitive tasks. LOGIC Solutions Group works to create, manage and integrate information management and geospatial assets to provide insight into the oil and gas lifecycle. BP is the world’s sixth largest oil and gas company.
CCCSD needed to clean up and transform the data model of their sanitary sewer GIS into the Esri Local Government Information Model. The team has used FME for years to migrate data between systems and perform data quality control. Years of various systems had created a wide array of attributes, mini line segments, and sewer main features that were stored n:1. In adopting the new data model, they used FME to create workflows that simplified their model of sewer pipes and their associated attributes and migrate it to their new data model without losing any information. CCCSD views FME as an integral part of their data migration process. The pre-built tools in the visual interface and the flexibility to join them to create custom transformations saves the team time, and allows them to automate their data transformation processes. Central Contra Costa Sanitary District (CCCSD) provides wastewater collection and treatment services to approximately 471,000 people in the eastern part of the San Francisco Bay Area, California, USA.
Devon Energy needed to convert directional survey data for their wells from surface offset values (given in angles and depths) to Cartesian coordinates. They used FME to perform the calculations for the conversion, from azimuth, inclination, and measured depth, to XYZ coordinates. Well surveys processed with this workflow are then written back to the geoscience database with XY offsets and lat/lon offsets for each station. These processed surveys can then be used to map all directional surveys in the database, in 2 and 3 dimensions. Devon Energy is able to calculate coordinates directly from raw survey data using FME, which minimizes reliance on questionable calculations from other sources. Jerrod explains, “This can also be run in batch mode (functionality that is currently lacking in our geoscience application).” Devon Energy is one of the largest independent natural gas and oil producers headquartered in the United States, specializing in onshore exploration and production in North America.
Ottawa created their city in Minecraft to engage with the next generation of citizens. They used pre-built tools in FME’s graphical user interface to transform their GIS data into a Minecraft world they named GeoOttaWOW. Without access to the Minecraft game or server, they were able to create a Minecraft world in less than 3 hours using FME, and using their digital elevation model (DEM) dataset as input. They then received feedback from youth testers, and created subsequent FME workflows to tweak the results and create a more rich world customized to suit their needs. By taking an innovative look at their data and transforming it into the gaming world, they caught the attention of local media and many of the youth in their city. They are excited that the project holds the possibility of getting young citizens more involved, and helping youth understand why and how they do things at the City. Ottawa is the capital city of Canada, and home to over 1 million people.
we-do-IT extended the format support for their ERP Mobility System LatLonGO® using FME®. The team created the LatLonGO® Writer using the FME® SDK Toolkit, enabling data from any system supported by FME® to be integrated into the LatLonGO® application in encrypted and highly compressed form for secure and efficient mobile use. LatLonGO® users can now use FME® to import data from all 325+ FME®-supported formats into their system. This solves a crucial need specifically for the company’s telco and utilities clients, who maintain several CAD and GIS systems which need to interchange and overlay data between them. we-do-IT is a global provider of Geospatial and SmartGrid IT solutions.
The City of New Orleans needed to automatically retrieve economic indicator data from government APIs like the Census to track their progress on a variety of performance measures and benchmark themselves against comparable cities. New Orleans worked with Socrata on the project, who created FME workflows to automate indicator data retrieval. For example, FME pulls data from the US Census API, BLS, and BEA, translates the data into a flat, machine readable table, converts it into the required data model, performs calculations, and writes the data to the city’s open data portal. The project allows the City to not only tell their story, but compare themselves with other localities, and comply with the Bloomberg Fund requirements. The workflow is easy to maintain and share, making future updates simple. Socrata is a cloud software company focusing on open data and other solutions for digital government to improve society. The City of New Orleans is the largest metropolitan area in the state of Louisiana, USA.
Forsyth County needed to make their parcel fabric data, which changes dramatically daily, accessible and meaningful to end users. FME Desktop became a critical tool to help populate published tax parcel features specific to their Tax Assessors CAMA system into their Esri Local Government model, and to update other department systems. They published their FME workspaces to FME Server to run automatically, as “set it and forget it” workflows. By automating this process with FME, they can provide consistent updated information to the Tax Assessor department, other county employees, and citizens of Forsyth County. Forsyth County, Georgia, is consistently one of the fastest growing counties in the USA. Since 2000, its population has doubled from 100,000 to 200,000 residents.
The City of Calgary needed to calculate building elevation points from a LiDAR scan of 400,000 buildings to provide to inspectors in the case of a flooding event. Using FME, the team converted the LiDAR into a DEM. They then created an FME workflow that integrated the DEM with a multipatch geodatabase derived from the same LiDAR dataset. The workflow then performed calculations to gather the lowest elevation, highest ground elevation, and highest elevation of each building. The team saved time and effort by using FME to accomplish this project. Their inspectors are now equipped with the lowest elevation point of buildings in the city so they can quickly check them during a flood to determine if they have been impacted. Calgary is the largest city in Alberta, Canada, and home to over 1 million people.
The City of Oak Ridge needed to import AutoCAD data into their GIS because their Electric Department was phasing out the use of CAD for mapping. First-time FME user Kenric McCay watched webinars and visited the FME Knowledge Center forum to identify his ideal workflow. Then he created a workspace that would migrate his team’s CAD data into a Shape file for import into their GIS, while maintaining the critical anchor points during the import. The FME workflow automated what would have otherwise been a manually-intensive process involving many repetitive steps. It can be reused as needed, and performs the import while ensuring that the integrity of the original CAD dataset arrives intact. The City of Oak Ridge is located in the state of Tennessee in the USA.
GeoManitoba needed to take geotagged photos and produce KMZ files with the photos embedded. They used FME to create a simple process that displays photos in Google Earth and produces a complete KMZ file for distribution. They also enhanced the process to label photo points, organize different types of photos into folders, and use unique icons to represent each type. The project was a success, and the team is now using FME to develop a process for moving data into the Government of Manitoba SDI. GeoManitoba, and it’s predecessor, The Surveys and Mapping Branch of Manitoba have been using FME since 1998 for processing and translating geospatial data.
Partnering with the Police Foundation, analysts at Socrata needed to automate the ingress and centralization of various police data sources into an open data portal for the Task Force on 21st Century Policing. They used FME Desktop to design workflows that pull data from disparate APIs and transform the data into more standardized formats. They then automated these workflows with FME Cloud, which is FME Server technology deployed in an AWS cloud environment. This project represents an important step in the White House Police Data Initiative with the intent of increasing access and availability of important police data. As such, FME plays an integral role in achieving the goals of the Police Foundation to provide open data to increase police transparency, which remains a growing public policy topic. Socrata is a cloud software company focusing on open data and other solutions for digital government to improve society. Police Foundation is a Washington, D.C. based non-profit dedicated to advancing policing through innovation and science.
The City of Auburn needed to convert raw crimes data from their proprietary Linux system for use in their ArcGIS SDE environment for online mapping applications. Their crimes data does not have a coordinate system or any other spatial data aside from addresses. Using FME Desktop, they created a workflow that adds the spatial component to the data, transforms the data for public viewing, performs quality assurance and control checks, renames attributes, and translates the output for the destination system. They then implemented FME Server to automate the process to run nightly, and provide email notifications regarding the workflow’s success. Implementing FME was a major improvement over their Python scripts. They can easily updates codes and field changes, others can edit the workflows even with minimal knowledge of FME, FME Server logs and alerts task success and failure, and the friendly user interface makes setup easy. The City of Auburn is located in the state of Washington, USA.
The Surveyor General Branch of NRCan uses FME to automate their workflows, running them overnight without intervention. By the time they arrive for work in the morning, FME has pulled together data from diverse datasets across the country, de-normalized database information for business intelligence, and identified all the errors that have spilled into the databases the previous day. They use FME Desktop to create the workflows and to automate sending success/failure details. Using FME, they produce KML files for Google Earth, DWG files for AutoCAD, Shape files for many users, keep web applications up-to-date, and provide data to map services. The Surveyor General Branch (SGB) of National Resources Canada (NRCan) operates dynamic data from 48 databases in 32 projections with 60,000 features in SHP, ArcSDE, DWG, and SQL Server.
The City of Austin annually updates the multitude of maps impacted by annexation. By automating this process with FME, they now save 900 hours each year. The parcels of land that the City annexes must be reflected in the city’s maps and spatial database. The team implemented FME and ArcGIS Workflow Manager to automatically edit the five affected data layers, update their ArcSDE database, create their 21 standard maps, and publish them to the City’s FTP site and open data portal. In less time than it took to run their previous process, their FME workflows were operational. The simplicity of FME has also made it possible for anyone on the team to kick off the workflows. The success has inspired plans for expanding FME’s reach to run the project’s workflows on a schedule, automate notifications, and apply inspector boundaries. The state capital of Texas, USA, the City of Austin has a population of nearly 1 million people, with another million residents in its surrounding metropolitan area.
California Earthquake Authority (CEA) needs to know immediately when an earthquake occurs with the potential to impact their policyholders. The USGS collates earthquake data into its Shakemap dataset and offers an email notification service, which CEA monitors using FME Cloud. When new maps become available, FME Cloud triggers an FME Desktop workflow to read the Shakemap GeoJSON feed and identify if earthquakes in California are of significant magnitude to cause property damage. If so, the workflow extracts applicable shaking intensity data from relevant Shakemap Shapefiles, places it into an Excel report, and emails this to stakeholders, all within minutes of the earthquakes being detected. The claims department now receives near real-time reports of any earthquakes that may damage policyholders’ residences. By choosing to deploy FME technology in the cloud, CEA saves the costs of maintaining in-house servers and only pays for what they use. CEA is a publicly managed, privately funded non-profit insurance company offering affordable earthquake coverage for residential properties in California.
York Region needed to enable their nine municipalities to submit their own water and wastewater data into the region’s All Pipes program while automating QC and conversion of the data into the common schema. They worked with Spatial DNA to create FME workflows tailored to each municipality’s dataset. The end users submit their data via their web GIS application, Geocortex, which triggers FME Server to call the applicable FME workspace. This performs quality checks and transforms the data schema before loading it into the Esri SDE database. By implementing FME, York Region has automated the maintenance of their dataset. The visual nature of FME workflows make changes and enhancements easy to manage. York Region is now planning ways they can expand this project to suit storm water, parks, sidewalks, and street lights data. York Region, also called the Regional Municipality of York, is home to over 1 million residents in the Greater Toronto Area of Ontario, Canada.
Dotted Eyes needed to provide UK boundary reference geographies, ready for use in Tableau, via their data download portal. To prepare these datasets, they had to perform pre-processing on the data, including generalization and re-projection. Using the graphical user interface in FME, they were able to perform these tasks by applying pre-programmed transformers, rather than writing custom code. Because of its support for writing Tableau data, FME enabled them to automate this process, building workflows that allow data to be extracted regularly. This integration enables additional use cases and provides better integration of both tools for their clients. Dotted Eyes is a Platinum partner of Safe Software and also a Tableau partner. For over 20 years, they have continued to deliver advanced services in GIS technologies to help improve the mapping and data capabilities of organisations.
Athena Intelligence needed to transform data for integration into Tableau to power decision support for strategic & sustainable food supply chain clients. The ability to filter through multiple contexts with a single click requires an enormous amount of data blending, something that requires transformation prior to the data entering Tableau. They achieved this by using the pre-programmed tools called transformers in FME’s visual interface to build workflows that integrate and massage data from disparate sources including Esri Shapefile, KML, GeoTIFF, CSV, Excel, and dozens more. Replacing their expectations of building a myriad of database scripts and functions, these FME workflows, designed without writing any code, now prepare the data for Tableau. Customers can then interact with the aggregated information to reveal business intelligence. FME already speeds the process of on-boarding and investment, and Athena plans to apply FME Cloud in the future to automate data loading on a scheduled basis. Athena Intelligence provides dynamic business intelligence to the food supply network and associated stakeholders.
Esri, Mount Vernon, and Quinn Evans Architects collaborated to build a blended BIM-GIS 3D world with the assistance of the FME-based ArcGIS Data Interoperability Extension. They used FME technology to blend numerous rich datasets for the mansion and the estate’s outbuildings into one seamless world. The workflow added coordinates to Revit (IFC format) data and then entered the rotation from project north and true north. With BIM content geo-referenced, the workflow then exported the data to a spreadsheet, imported it into ArcGIS and connected it back to the attribution. The results provide stakeholders an incredibly detailed view of site and structure data and history for planning and web maintenance, via a web browser. Contextual analyses can now be performed, such as viewshed analyses which ensures that the vista across the Potomac River remains pristine. Mount Vernon was the residence of George Washington, the first president of the United States. The estate is preserved as true-to-form as possible.
Bohannan Huston needed to perform 3D modeling of culverts to create a flowline network for their client, Santa Fe County. Their challenge was to cut down into the model’s surface to allow accumulation to flow across man-made features. Having used FME at their firm for 10 years, they knew that rather than manually reviewing all 3,000+ sites, the could create a simple FME workflow to review the data in 3D. Using the built-in tools in FME, they constructed a 3D scene by integrating orthographic imagery, DEM surface data, reference data, and the hydro model, and then manipulated it to create both TIN and 3D model outputs. Using FME enabled them to create powerful visualizations out of the data they already had, dramatically reducing the manual effort of flowline reviews. Bohannan Huston is an award-winning firm specializing in engineering, spatial data, and advanced technologies in the USA.
The City of Edmonton’s Sustainable Development department used FME to assign redevelopment potential factors to parcels within the 104 Avenue Corridor as part of the Area Redevelopment Plan (ARP). Without prior knowledge of FME, one staff member used the pre-built tools in FME to design repeatable workflows that collect and analyze parcel data, identify potential spots for redevelopment, and create zones specific to those areas. The conditions analysis was performed on land use, existing zoning, building ages, residential tenure, existing dwelling counts and residential density, tax assessed values, and commercial square footage. Each parcel’s development potential was then measured using numeric analysis. The results provided intelligence for decision making by outputting maps of each analysis factor and assigning a redevelopment potential factor for each parcel. FME will also be used for the next phase, which involves creating and testing zones to see how they affect the surrounding area. The City of Edmonton is the 6th largest city in Canada, and the capital of the province of Alberta.
Vertex3 is helping universities create a campus-wide, seamless Geodatabase from CAD drawings. They created FME Desktop workflows and related scripts, enabling Facility Managers to integrate floorplans, outlines, basemaps, and archives to create simple 3D maps. Scheduled updates maintain synchronization, enabling CAD changes to be loaded into a SQL Server staging area, quality checked, and then incrementally updated in the GIS. Future plans include the option to run the Floorplan Sync Engine on FME Cloud. This innovative solution has been implemented at three universities to date, enabling the University of Washington, for example, to map 1700 floors and 24 million square feet of interior space. Vertex3 is now creating web applications and automated routing systems whereby the primary route lines are drawn in CAD, the 3D model is created using FME, and results are applied in a Geodatabase Network Dataset. Since 2009, Vertex3 has successfully implemented projects for more than 50 clients worldwide with GIS and related technologies. From short-term consulting support to high-end solution development, Vertex3 is known for quality work and creative solutions.
After developing a national 3D standard, Geonovum needed to make their open source tools for creation and validation of 3D data easily accessible to non-developers. Using FME, they created workspaces for public distribution of these tools to pre-process source data. With the selection of a few parameters like data type, theme and level of detail, the 3D geometry is automatically generated from 2D input data and high resolutions LiDAR data. Generated geometries and attributes are output according to the standard with minimal user intervention. FME provides the user interface and makes the tools more accessible, facilitating widespread adoption of the standard, and thereby 3D analysis. Urban planning for this intensely populated country can now be enhanced with a more accurate understanding of elements such as shadow casing, noise, rooftop gardening potential, and more. Geonovum is the Netherlands’ National Spatial Data Infrastructure Executive Committee. This project was a joint effort with the Kadaster, the Netherlands Geodetic Commission, and the Dutch Ministry of Infrastructure and Environment, with involvement from Safe Software and its partners con terra, Vicrea, and Red Geographics.
MeteoSwiss wanted to deliver a map view of the aviation special alerts set out by the ICAO to aviation professionals. Responsible for producing and distributing this information, MeteoSwiss worked alongside INSER to create FME workflows that convert these SIGMET and AIRMET text-based reports to maps. They developed an FME workflow that parses and interprets the report text, then builds the geometry, and finally creates a PDF output. FME Server automatically runs the workflow every five minutes. These PDF maps are made available by MeteoSwiss to end users via an FME Server data streaming service, making their way into the hands of airlines, flight planners, and pilots within minutes, now provided as a mapped interpretation alongside the report for clearer communications and better decision making both on the ground and in the air. The workflow is also easily extendable to other regions of the globe. MeteoSwiss is the national provider for weather and climate services in Switzerland.
The Iowa Department of Transportation (Iowa DOT) wanted to deliver the near-real-time situational awareness they already accessed internally via a public-facing plowcam portal. Using FME alongside ArcGIS Online (AGOL), Oracle, KML, and Microsoft Azure, they now provide plow data and cam imagery via a web portal. In the background, FME Server retrieves the active plow data from Oracle once per minute, and creates a KML file that is uploaded to Windows Azure. AGOL accesses that KML to build the online representation, refreshed at regular intervals. Using the public site, individuals can visually check conditions before setting out on the road, making for safer driving. Media and weather outlets are taking advantage of this near-real-time situational awareness too, tweeting out plow images to their audiences. Iowa DOT maintains over 9,400 miles of roadway and 4,092 bridges to serve the transportation needs of the state's citizens.
The Arkansas Geographic Information Systems Office (AGISO) migrated their open data portal to the cloud to accommodate increasing web traffic and save money. They used FME Desktop to migrate their 7+ terabytes of data to Amazon, which now also hosts the web server front end and FME Cloud physically in the same region for optimal performance. User requests in the new system, called Arkansas GIS Office, are performed in the background by FME Cloud, where a collection of FME workspaces automatically tackle the data extraction and delivery workflows requested by end users. By eliminating in-house infrastructure, they gained robustness and saved money. Fault tolerant data storage at Amazon and FME Cloud’s monitoring removed one set of uncertainties, and the security provided by both is excellent. Finally, the cost savings are unimaginable: their three-year financial projection for in-house vs. cloud indicated the elimination of $220,000 in cost, a staggering 73.4% savings. The Arkansas Geographic Information Systems Office coordinates Geographic Information Systems (GIS) programs for the State of Arkansas in the USA.
The Municipality of Arnhem decided to close the gap between their geo and IT departments, gathering all of their ETL processes onto one platform. The team selected FME to take on these tasks. They used FME Desktop to create workflows, creating 30 geospatial tasks and another 25 non-spatial business intelligence (BI) workflows which included Slowly Changing Dimensions (SCDs). They implemented FME Server to take care care of the automation. The project has been an absolute success, both technically and in aligning different working groups on a single platform and bringing them together. FME maintains enterprise geospatial databases, performs data integration tasks, and populates the BI data warehouse. Municipality of Arnhem is one of the larger cities in the Netherlands. They worked with FME Certified Professional Itay Bar-on of ETL Solution on this project.
Donegal County created a system that delivers storm alerts, road gritting routes, and weather reports via geocoded tweets, a GeoRSS feed, and a public online map. Using FME Desktop, they created workflows that geocode tweets based on parsed route numbers, and generate a GeoRSS feed available in an online map for easy interpretation by the public. The engineers responsible for tweeting simply re-use pre-defined tweets. With the success of gritting data delivery, they expanded their map to offer local weather information by gathering data from the Norwegian Met office’s XML feed of public, world-wide weather information. They then added even more value by setting up an FME workspace to check all feeds for forecasted conditions, to tweet storm alerts when bad weather is predicted within 12 hours. This information is delivered twice a day in winter, and once a day the rest of the year, using FME Desktop scheduled with Task Manager. Donegal County borders the Atlantic Ocean in northwestern Ireland.
Upon the pending depreciation of the Google Earth plug-in, KDOT’s Division of Aviation needed re-design their Kansas Airspace Awareness Tool to instead use Cesium as the user interface. They took the opportunity to widen both the functionality and available data. The FME Desktop workspaces and FME Server configuration which handled much of the heavy lifting in the original system were easily repurposed. The newly named KDOT Aviation Portal enables users to visualize and browse datasets, most notably 3D polygons of various types of controlled airspace. They can interactively place structures – a proposed wind farm, for example – to perform preliminary checks regarding whether FAA regulations will come into play. FME Server handles user requests, updates the FAA obstruction data every night, and was used to build out the data layers including the airspace polygons. There is a mix of formats involved – data resides on Amazon in GeoJSON, CZML, KML, Collada, and WMS. KDOT manages highway, rail, air, bike/pedestrian and public transit transportation in the state of Kansas, USA.
Kartverket started out with a fun project for a kids’ annual hackathon which turned into a real-world test bed for an upcoming cloud-based open data portal rollout. In collaboration with Safe partner Sweco, Kartverket built an on-demand FME Cloud-based Minecraft world provider for the hackathon. The source data, including terrain and supporting datasets in PostGIS sat in the cloud on Amazon, were converted into Minecraft by FME Cloud on-demand. When they made the service public after the hackathon, it received media attention and traffic exploded. At the peak, they generated 1,000 worlds in an hour. The team now knows what it takes in terms of support and burst capacity to keep things performing. This real-life but non-critical test of the service was a successful trial run, and offered a foundation for delivering official data to the public via a cloud-based open data portal. Kartverket (Norwegian Mapping Authority) bears nationwide responsibility for geographical information, operates the national property registry and undertakes all property registration in Norway.
The Agency for Planning and Building Services in Oslo wanted to create a 3D printed model of the city at a scale of 1:1,000, representing 34.8 square kilometers. They used FME to filter out terrain from LiDAR data and drape it with a geoTIFF, then convert buildings into proper 3D geometry and attach them to the terrain. They printed the physical 3D model, measuring 7.6 by 4.5 meters, comprised of 360 tiled blocks, each approximately A3 size. Each block of the model can be removed and reprinted with updated information in a matter of days. Future plans include creating a smaller, portable version of the model for events like public consultations, in combination with a projection system that overlays thematic maps on models. Their work with FME now extends to many digital data products, 3D included. Oslo is the economic and governmental center of Norway and the fastest growing major city in Europe, currently home to over 650,000 people.
GeoLOGIC needed to remove road allowance gaps from the Western Canada Dominion Land Survey System (DLS) grid covering 1.5 million kilometres. They used FME Desktop to automate closing the gaps between almost 10 million polygons. Through extensive testing, they also designed a section of the workflow to automatically correct for polygons that don’t conform to the standard DLS sizes. Finally, they used FME to test the final road-free DLS grid, ensuring that all gaps were correctly closed and no slivers existed. The resulting complete system enables users to complete additional geostatistical analysis, especially in the area of production allocation for horizontal wells. The workflows can be re-run as needed. Based in Calgary, Canada, GeoLOGIC is a widely recognized developer of high quality databases and premium software products that offer comprehensive, relevant solutions to the Oil and Gas industry.
The Malmö City Planning Office wanted to make a 3D printed model of their city. Rather than purchasing this data, they wanted more control over it, so they made their 3D model from scratch. They used FME Desktop to integrate disparate datasets such as orthophotos, ASCII grids, extrude building footprints, survey trees and other details, and combine these into a 3D data model. The workflow then tiled the dataset according to their requirements and output it in an Autodesk format that can feed right into the printer. They now have a complete 3D printed model of their city. When a building proposal is presented, they can switch out a complete tile of that section of the model and replace it with the proposed structure for the public to view. The city of Malmö is the third largest city in Sweden and is a world leader in sustainable development.
Lantmäteriet (Swedish Land Survey) provided funding to Sveriges Lantbruksuniversitet (SLU; the Swedish University of Agricultural Sciences) to make the country’s geographical data available for free to its researchers. This data is not free to the public, which had been a disadvantage to researchers, particularly those at universities without funding to purchase it. Even when purchased, data distribution had been awkward, often involving USB drives being passed around a team. SLU used FME Desktop to build data distribution workflows, and applied the REST API in FME Server to make these processes available to researchers through a secure, user-friendly map-based web application. The country’s researchers now have free, centralized access to the Sweden’s geographical datasets. FME technology made it possible to implement the online data distribution service, and deliver on the project’s one month deadline. It also provides the security to ensure that the data is only accessed by authorized researchers. The Swedish University of Agricultural Sciences is a university with comprehensive knowledge of the sustainable use of biological natural resources, as well as of the environmental and life sciences.
T. Baker Smith needed to create a company-wide, standardized data store for information collected in the field to make it more accessible. They used FME Desktop to build workflows that import and map data to the centralized data schema and format, perform quality assurance checks, manipulate the data for storage, and extract the data from the data store. With FME Server, they were able to automate these processes and make them available to both the field crews that collect the data and the end users of the data. The data is now easily available to users both inside and outside the company. The central data store is updated about once a month and replaces individual project folders, so everyone can access the most current version of the data from a single place. The automation of the FME processes save the team a great deal of time and manual effort. Started in 1913, T. Baker Smith has grown into one of the top 500 engineering, architectural, and environmental design firms in the USA.
Nottingham City Council needed to automate the production of open datasets in response to the large growth in requests from citizens under the Freedom of Information Act 2000 (FOI). With support and training from 1Spatial, the Council used FME to easily automate the generation, updating and publication of a wide variety of datasets, both geospatial and non-spatial. For example, FME’s rules-based processes were ideal for automating the redaction of private personal information in council spend reports as required by law, and then publishing them as open data. Rather than consuming a full-time staff member’s time, the process is reduced to just one hour - checking 50-100 exceptions flagged by FME rather than the full 15,000 records each month. Additionally, FOI requests are simply directed to Open Data Nottingham rather than fulfilled manually. Nottingham is now meeting its response-time targets for FOI requests, despite the steady increase in overall request volumes. Nottingham City Council (Nottingham) is a local authority organization in the UK that serves a population of an estimated 314,000 residents.
Rambøll needed to manipulate digital terrain models (DTMs) for input into their overland terrain flow system (DHI MIKE 21) for flood calculation, and postprocess flood results. An FME Desktop workflow was designed to bring buildings from Shape files into the DTMs for flood calculations. Then another workflow post processes flood results, calculating the volume of the flooded water and the flooded areas. The output is both an Excel statistical file and a Shape file where the flood volumes for different areas can be found. FME made it possible to quickly implement these processes without writing any code. Rambøll is an engineering consultancy company from Denmark, with 200 offices in 28 different countries.
Con terra wanted to provide an integration kit into map.apps as a product for their customers to use to produce focused apps that provide required information after one or two clicks. They used a REST based integration of FME Server, map.apps, and ArcGIS to create bundles for focused and simple apps that connect functionality with content. The strategy was to keep it simple, creating user friendly apps for specific users, not include all of the functionality possible. By using FME Server or FME Cloud to power the spatial ETL (extract, transform, and load) in these apps, they were able to provide workflows that can be configured and updated quickly to provide apps that perform file upload, file download, database import, database export, and web connections. FME provided significant time savings, enabling ETL functionality to be integrated into apps in minutes. Founded in 1993, con terra GmbH is a member of Esri Germany and a Value-Added Reseller of FME.
Avista Utilities needed to perform large-scale network analysis with their Esri Geometric Network beyond what it was originally set up for. They used the Network Typology Calculator in FME to perform these additional traces on their large ArcSDE dataset, such as finding the number of meters served by each gas pressure zone, finding emergency shut-off islands, finding isolated steel pipes, and performing network health checks. FME made it possible to perform these traces without writing code. For tracing projects that were previously possible, it reduced the time required. For example, the steel pipe trace used to take 12 hours, but with FME it now takes only 15 minutes. Established in 1889, Avista Utilities provides electric and gas transmission and distribution to about 680,000 customers in the Northwestern USA.
Affecto Estonia worked with Spatialworld to use FME for validating and integrating geodetic survey data into their GeoArchive product. FME workflows enable geodetic surveys to be uploaded as Microstation DGN or Autodesk DWG files, and then validated against Estonian regulations. Rejected datasets are returned with an error report providing details of required corrections. Accepted datasets are integrated and can be exported on demand as CAD files. With FME, processing speed has increased from 3-5 weeks to 2-3 days per project. Also, data can be traced and is more reliable. Multiple data sources can also now be viewed at the same time. The workload can be balanced between staff as required because project progress is easily visible, and by automating the validation process, bills are only paid when documentation is accepted. Affecto is a Finnish company of 1,100 staff operating in the Nordic and Baltic countries, providing information management and GIS solutions.
Consortech needed to migrate client data from various systems into the AutoCAD Map 3D template they built specifically for Quebec, Canada, called SOLO Network. They used FME to perform the extract, transform, and load functionality, migrating sewer lines and points, water lines, road centerlines, and road surfaces into the destination GIS. This involved tasks such as migrating geometry and attributes from the same into different tables; going from English to French; transforming domain tables with character values to those with numeric values; moving from a simpler schema to a more complex schema; and validating the integrity of the data once it had been migrated. The results are clean data written to the new schema. Domain values are copied, date values are formatted, and geometry is separated from attribute data. The output from the validation workflows provide areas of possible discrepancy for manual examination. Consortech has been providing analysis, implementation, and training on the best data management and design processes and solutions for 25 years.
Barnsley Metropolitan Borough Council was facing reduced funding and staffing while seeing increased challenges with their GIS. Data was in separate siloes and processes were often manual and in some cases more laborious than they needed to be. With training and consultancy from 1Spatial, the Council used FME to develop many new, automated processes that replaced repetitive manual tasks. The Council also used FME to improve data sharing, dissolving the boundaries between departments and driving greater collaboration and insight. FME has enabled Barnsley’s GIS experts to spend more time developing new solutions and less on fixing old problems. What once took a day, can now be delivered in half an hour. More seamless data sharing has also improved the Council’s service to citizens while also enabling greater insight and more informed decision-making all across the Council. Barnsley Metropolitan Borough Council represents 230,000 residents in South Yorkshire, United Kingdom.
London Fire Brigade (LFB) needed to optimize travel times to provide efficient routing for their 6,000 staff as they respond to emergencies and distribute appliances and human resources between their 102 fire stations. They had experienced the efficiency of FME Desktop when they worked alongside 1Spatial to streamline their data management into a single, authoritative geospatial database. They then chose FME to automate the process of updating inter-station travel times. The results were compelling: 95% faster processing of 12,000 route queries, which run automatically on a schedule, eliminating manual error risks and freeing experts to devote time to other important tasks. LFB has since implemented FME in many additional areas, including automating repetitive data management tasks, translating data to provide stakeholders with greater insights, sharing data to support local initiatives like Southwark Council’s Arson Task Force, and to simplify the task of responding to Freedom of Information requests. London Fire Brigade (LFB) is one of the largest firefighting and rescue organisations in the world.
Sacramento Area Sewer District (SASD) needed to continuously synchronize data between multiple disparate systems to manage their sewer data. They worked with CAD Masters, and chose FME Desktop to automate these tasks. The base maps from Esri ArcSDE are now synchronized with AutoCAD Map 3D Enterprise, their front end application for creating and editing their sewer data, which uses Oracle as the database management system. FME workflows also synchronize new sewer features and their unique identifier which have been created in Maximo, their asset management system, with Map 3D. These workflows were created using the graphical user interface of FME Desktop, which provides pre-built data transformation tools in a drag-and-drop environment while visually showing the flow of data from start to finish. They also used the Logger tool to provide a paper trail of the synchronizations made. SASD is a sewer utility providing service to more than one million people in the Sacramento region.
Geodatastyrelsen, The Danish Geodata Agency, needed to create cartographic labels for their cadastral system. Already using FME to make their data available to the public in 10 formats and a number of projections, they leveraged integration between FME and MapText for this project. They simply inserted the MapTextLabeler and MapTextStyler transformers, MapText plug-ins that had been created to integrate into the FME Desktop Transformer Gallery, alongside other transformers in their workflow. This automated process can now label the whole country’s data in 20 hours, resulting in 2.8 million labels, proving this automation to be much more efficient than manual labeling. They continue to use the workflow daily for updates, and designed a separate workflow to email monitoring reports. The Danish Geodata Agency, Geodatastyrelsen (GST), is the state owned agency responsible for surveying, mapping, and land registering Denmark, Greenland, and the Faroe Islands.
Sterling Power Utilities needed a map portal for their wooden power pole inspection project. Sister company Sterling Geo, which provides their GIS services, created data transformation workflows in FME Desktop’s graphical user interface and published them to FME Server hosted in the cloud. FME was integral in managing the data backend of the OpenLayers portal, enabling data access, printable map production, PDF creation, and pole identification to be performed by end users with no knowledge of the data transformation process. Using FME, the project was accomplished within their tight two week deadline. Administrators, project managers, and condition inspectors were able to access the portal via a web browser or mobile device app. High quality of the data ensure safety of field crews operating under high voltage electricity. Sterling Geo and Sterling Power Utilities are sister companies under the Sterling Power Group, which specialises in engineering services for the utility and wider markets.
WhiteStar Corporation uses FME Server to supply key geographic data layers to the energy industry from a large GIS store via subscription model. They used FME Desktop to create the data extraction and transformation workflows, and published them to FME Server where customers could perform these actions on-demand using a friendly web interface. Clients select an area of interest and choose the desired data layers and destination format. Upon validating the client’s email and subscription status, the system processes the request, providing either a price quotation or the requested dataset. The system provides the company with the ability to monitor customer data usage, expand the types of subscriptions that can be offered, and support a wide variety of output formats including ArcGIS Online, various Esri formats, and various Geological and Geophysical application platforms. WhiteStar Corporation provides a seamless, dynamic data library under strict accuracy standards to help exploration professionals make confident decisions and avoid expensive mistakes.
Global Information Systems used FME to design a system that creates purpose-built alignment sheets for clients. The pre-built tools in FME Desktop’s graphical user interface were used to create a workflow that reads data from Geodatabase, performs the required manipulating and formatting, and pushes the results to AutoCAD Map, allowing for any desired touch-ups. FME provides a highly accurate, automated system to replace time consuming manual CAD drafting, expensive GIS options, and complex, proprietary applications. FME allowed the team to leverage best of breed technologies - both CAD and GIS - and provided a customized, maintainable, reproducible solution. Global Information Systems provides the pipeline industry with solutions to manage asset data, business workflows, and regulatory compliance.
INSER uses FME Cloud to provide its clients with common geodata transformation and quality assurance services. INSER recognized that when geodata is exchanged between stakeholders, it never seems to come in the right format, coordinate system, data model, and / or quality. They decided to help clients solve these problems by using FME Desktop to design common workflows, and published them as a service using FME Cloud on the backend of a customized, documented web user interface. Their services equip non-specialists to perform the data transformation processes they require. The pay-as-you-go model is cost effective for INSER, allowing them to offer this as a free service with a limited number of objects that can be processed, and to also enable clients to scale up to a premium subscription as pay-per-use. INSER is a GIS consulting company based in Lausanne, Switzerland.
CAE used FME to generate global lightmap overlays for realistic night scene simulation for civil aviation training. Using the graphical user interface in FME Desktop, they created a workspace that clipped roads from OpenStreetMap to illumination zones from DMSP-OLS Nighttime Lights, populated points along the road, converted it to raster which they processed with ImageMagick, restored the georeferencing, and combined the tiles. FME replaced the old manual, time consuming process which would not have been achievable within the project’s 6 week deadline. It also increased the accuracy of the output, replacing randomized lighting with realistic night view of cities, and roads accurately lit and usable for aeronautic navigation purposes. Founded in Canada in 1947, CAE has the largest installed base of flight simulators globally, training 100,000 pilots and crewmembers annually, with an annual revenue of $2.1 Billion.
Geodatastyrelsen, The Danish Geodata Agency, uses FME to make use of an atom feed for notifying users when new data is available for a given area. The agency publishes most of their cadastral data for free to the public, which includes 2.4 million parcels and 45 million features, for 9033 districts, with changes in 20-100 districts per day. To notify users when changes are available for a given area, they use an atom feed, which is an XML file with an index to news. FME reads this feed and fetches data based on criteria such as date, area, and format, for access in 10 formats including GML, MapInfo, and Esri Shapefiles. FME reads and writes this data for easy access, and the process is automated using FME Server. The Danish Geodata Agency, Geodatastyrelsen (GST), is the state owned agency responsible for surveying, mapping, and land registering Denmark, Greenland, and the Faroe Islands.
Cunning Running Software uses FME in their situational awareness solution for law enforcement response to terrorists and active shooters. Their Rocket and Mortar Position Ranking and Analysis System (RAM-PRAS) uses FME technology to power the data transformation tasks of their custom coded solution. Using FME Objects, they leverage FME workflows to create raster backdrops as BMP, vectors as Shapefiles, and coverages as PNG, and then sort and merge this data to create layered PDFs for easy distribution - all behind the scenes. The integration of FME technology was so successful that they decided to leverage it for additional purposes, such as performing geoprocessing, and converting incoming mapping to suit their needs. And because FME workspace outputs are just text files, they can be updated to suit on-the-fly needs without requiring the months of accreditation required when hand coded programming is updated. Cunning Running Software develops high quality software solutions globally for defence and homeland security markets.
SWECO found an innovative and unusual FME-based solution to their invoicing challenge. SWECO’s accounting systems are designed to bill per-hour for the 9,000 employees and 37,000 consulting projects they perform each year amounting to annual sales of EUR 990 million. However, as a Value-Added FME reseller, they needed to be able to invoice FME licenses at a fixed amount. Using FME Desktop, they designed a workflow that reads data from the PostGIS license database and the customer information database, extracts the specific information required, and writes it out using the Excel template provided by their Department of Economics to create the invoice. While this is certainly not a common FME workflow, their knowledge of FME made them realize that a simple FME workflow could solve their problem, save them time, and was much more fun to use than the accounting system. SWECO’s vision is to become Europe’s most respected knowledge company in the fields of engineering, environmental technology and architecture.
virtualcitySYSTEMS uses FME in urban information modeling to perform complex data transformation tasks for smart cities. They use FME Desktop to create reusable workflows that perform integrated planning, analysis, and simulation tasks. For example, they create CityGML from heterogeneous input data such as AutoCAD 3ds, Sketchup, and IFC, and catalogue the data. They then use FME Server to publish FME Desktop workflows that distribute the data, offering users the option to transform CityGML into industry standards such as Esri file geodatabase and AutoCAD 3ds. FME completes virtualcitySYSTEMS’ 3D SDI solution by performing required data integration services and providing value-added services such as download and streaming, cataloguing and validation, and data import/export. With many years in the market as an innovative pioneer for creating digital cities, virtualcitySYSTEMS supports clients according to their needs with products and customized systems for the creation, management, and publication of virtual city models.
WSP views FME as “THE” problem solving tool. They are using it to address a wide range of production and workflow issues that were too difficult to solve with CAD or GIS software. Using FME Desktop to build workflows and FME Server for automation and sharing, they have conceptualized 3D site plans; performed coordinate system reprojections on LiDAR data; moved data between CAD & GIS systems while performing QC; and made archival data from all projects available in a single KML file where Trimble Job Book data, Georeferenced photos, Garmin GPX data, and more can be tracked and visualized by map navigation in Google Earth or via hot links in their Excel project management spreadsheet. FME has made these projects possible, efficient to accomplish, and once the workflows are set up they run automatically. WSP is ranked among the top 10 professional services firms in the world.
Metria needed to create automated quality control services, enabling clients to gain the full value from geographic datasets that have been shared via open data and SDI initiatives, such as INSPIRE. Using FME Desktop to create workflows and FME Server to perform the automation, Metria measures and describes data quality in a standardized and traceable way. This provides vital information to power the process of selecting the right dataset for the right purpose, and allows data to be used for purposes those that the producer could have envisioned. By creating FME Server validation services, QC can be performed anywhere. In a recent project for the Swedish EPA, a single, flexible service that makes use of ISO standards to specify quality demands provided cost efficiency by eliminating the need for multiple validation processes. Based in Sweden, Metria develops intelligent geographic solutions to streamline business, providing a link between the map and reality.
FME customer since 1997, Condesys Consulting recently solved sequence analysis challenges for clients using FME. They’ve designed workflows with the pre-built tools in the FME Desktop graphical user interface that analyse static juxtaposition of objects. In one project, police vehicles’ real-time GPS coordinates were required to to predict arrival time and help avoid congestion en route. However, real-time GPS data was not accurate enough to determine the road and speed of travel. Using FME, sequence patterns provided real-time route prediction. In another project, similar workflows were built to connect the sequence of a utility company’s assets as they migrated two systems’ data together. FME made it possible to overcome these data challenges, without investing in dynamic simulation tools. Condesys Consulting is committed to make geographic information serviceable and to integrate it into business and administration processes.
Ponderosa uses FME to perform GIS queries and automate data conversion of their telecom infrastructure data. Ponderosa initially implemented FME Desktop to replace their manual conversion of AutoCAD to MS SQL Server Spatial with an automated, scheduled job, saving 6-8 hours of daily effort. When regulatory requirements began relying more on GIS queries, the GIS tools in AutoCAD were inefficient. Performing ad-hoc GIS analysis in FME proved faster (30x faster in just one example), replaced the need to implement a new GIS system, and allowed changes on the fly. FME demonstrated its ROI by winning Ponderosa 4/5 grant approvals. In addition to saving immense time in automating data conversion tasks, FME has provided the ability to perform queries outside of a GIS. Ponderosa is a telecommunications company in California, USA, operating 2,000 miles of copper and 460 miles of fiber.
Sharper Shape uses FME to help its power distribution clients achieve their goals. They initially implemented FME to build a solution that identifies, visualizes, and prioritizes removal of vegetation and other objects that could impede client networks, but FME has proven valuable for many other projects. For example, when the European Space Agency (ESA) commissioned a study to identify the value of satellite data for power distribution asset management, they used FME to compare changes in raster imagery against business rules. They also built an FME workflow to create a cross-section of a client’s network, and use FME to regularly perform data translations, such as those from customer NIS systems to their own. For Sharper Shape, the value of FME is its ability to create solutions for clients, and to do so very quickly. Their network cross-section workspace was designed in a mere 30 minutes. Sharper Shape provides turn-key solutions for the efficient planning of maintenance and vegetation management.
Auckland Council needed to measure the vacant, redevelopment, and infill development capacity across residential, business and rural-residential land use designations. Michael Oberdries, working for Critchlow Ltd, was engaged by Auckland Council to create the spatial data modelling algorithms using FME. In the graphical user interface, they applied pre-built tools to design 40 complex modeling workflows. The resulting dataset will help them better understand the quantity and location of development capacity as they seek to meet their growth projections, requiring 400,000 new dwellings available by 2041. Because the FME workflows are self-documenting and highly annotated, they can be submitted as evidence of the modeling logic to the environment court, and senior planning staff can interpret them without programming knowledge. The workflows also allowed flexibility for changing planning provisions while avoiding unintentional algorithm changes by referencing Excel spreadsheets in which staff could update zone specific rules (ie. building setbacks). Auckland Council is the largest in Australasia, encompassing about one third of New Zealand’s residents and the nation’s GDP.
RIEGL uses FME to process LiDAR data to leverage the depth of knowledge made available by the waveform data available in point cloud datasets, beyond xyz information. FME Desktop workflows read RIEGL Database (RDB) data, including waveform attributes. This detail is available for post-processing, such as filtering point clouds by pulse shape deviation, removing points that fall within a certain threshold of an attribute, or removing unwanted echoes. For example, one workflow RIEGL has created for a forestry application performs surface extraction, normalizes the heights of the dataset, calculates mean tree heights and point cloud statistics, and outputs 3D tiles in a shapefile. FME makes it possible to make use of waveform data and integrate these attributes into processing projects and daily work. With more than 30 years experience in the research, development and production of laser rangefinders, distancemeters and scanners RIEGL delivers proven innovations in 3D.
In preparation for the Sydney Light Rail System expansion, a team of 8 engineers at Arup were tasked with manual 3D clash detection of underground utilities affecting the route. With FME, they created a workflow that integrated existing data from GIS and CAD sources, and used pre-built FME tools to build custom formats for the integration of survey & design data from 12d solutions (12da and 4d). The automated data transformation process outputs clash detection to both a 3D solids model and a web interface. Using FME not only saved time, but utilities assets owners were so pleased with the high quality output that they requested the enhanced data to improve their own internal systems. Arup is an independent global practice, offering services for all aspects of the built environment. The firm is responsible for the innovative engineering of world-renowned projects such as the Sydney Opera House, the Øresund Link between Denmark and Sweden, and the Beijing Olympic venues.
Ordnance Survey uses FME to implement a wide range of spatial data products. The product development team, in particular, has recently used FME to deliver two projects. The first, a Gazetteer, allows emergency services customers to quickly locate access points to prominent spaces such as schools and airports. FME enabled the team to bring many data sources together, perform complex spatial tasks, and write out to numerous data formats. The second, a 3D model, allowed a customer to see what their data looked like in 3D space before work on a national data model was undertaken. The rapid prototyping of new and improved projects that FME’s graphical user interface makes possible are key to Ordnance Survey being able to understand and respond to customer feedback and create ever more innovative products. Ordnance Survey is the UK government agency responsible for the official, definitive topographic survey and mapping of Great Britain.
San Jose Water Company needed to create a low-cost solution to mimic the enterprise GIS they had in-house for sister company Canyon Lake Water Service. However, they were limited to open source solutions that could operate on underpowered machines with slow internet connectivity. They used FME Desktop & FME Server to build automated workflows that nightly replicate their Oracle Spatial database into a PostGIS hosted locally at the sister company’s site. They also used FME to transform the data for clean display in an QGIS viewer. They integrated information from additional sources, such as engineering as-builds, tax assessor data, and customer information into the solution. These transformations have provided the means to implement the solution with immense cost savings. Additionally, providing data from multiple sources provides a broader, spatialized view of datasets from other departments, providing a single reference point for the customer service and accounting teams as well.
The Bureau of Land Management National Operations Center (NOC) needed to exercise quality control over standardized spatial data, which it harvests and maintains from 12 administrative state offices, to improve data integrity and build confidence for critical business decisions. Using the pre-built quality control tools in FME Desktop’s graphical user interface, NOC built a reusable workflow that assesses the accuracy of data and then delivers QC reports which describe the errors for correction directly to the state offices. Once required adjustments are performed, the dataset is replicated and reconciled with the NOC’s version of that state’s data. This FME workflow has expedited the process for both the NOC and the state offices while helping staff deliver high quality spatial data to internal and external customers.
Silkeborg Municipality, Denmark has applied FME in many areas over the last 7 years, from automated daily processes that download and transform GIS data, to complex one-off data integration and manipulation projects. Using FME Desktop’s graphical user interface, they design workflows for many purposes without writing code. For example, they used FME to create a 3D city model for presenting future construction projects. They cleaned terrain data from CAD files, converted it to both triangulated irregular network (TIN) and digital elevation model (DEM), and saved the output to GeoTIFF. Using FME, they can perform individual data manipulations as needed; re-use workflows, enabling them to routinely accept data from suppliers and partners without worrying if the data is sent in the correct file format or coordinate system; and schedule critical daily chores, saving a great deal of human effort. Silkeborg Municipality covers 850 km2 and is inhabited by 90,000 citizens.
Sterling Geo has combined the strengths of FME Desktop and ERDAS Imagine into powerful image processing routines that provide intelligent business products from a multitude of data inputs. Sterling Geo uses a few lines of Python to combine workflows from the two technologies. For example, when an electrical substation flooded, causing 40,000 people to lose power, they built a single process that used ERDAS Imagine to perform flood detection on multi-band Landsat imagery; then applied FME to integrate vector data, remove existing water bodies, and identify flooded assets such as roads; and finally provided a quality output image to provide intelligent information to field crews. This efficient combining of technologies enables each specialist (raster; vector) to build and maintain ownership of their own processes and couple them to achieve a single goal, minimising training costs and increasing ease of maintenance. Sterling Geo engineers solutions that transform spaceborne, airborne and terrestrial data into accurate, actionable information.
Natural Resources Canada (NRCan) has used FME software since 1998. Initially, it was used as a translation tool, but as they gained experience they began to integrate it within their cartographic production processes. Today, FME is a centerpiece for validation, integration, and dissemination of NRCan’s spatial data, including their GeoBase/Geogratis and WMS services which last year alone powered 8.5 million public downloads. The staff used the graphical user interface in FME Desktop to build over 700 data transformation workflows. They also leveraged the Custom Transformer functionality to combine multiple pre-built tools into processes that could be used in multiple workflows. Their current project is to simplify their custom coded batch processing jobs by implementing FME Server. FME is enabling NRCan to integrate data from multiple departments for sharing with the public in a way that is federal government compliant while streamlining the process and saving money. Natural Resources Canada (NRCan) is a federal government agency that seeks to enhance the responsible development and use of Canada’s natural resources and the competitiveness of Canada’s natural resources products.
The Community Mapping Network needed to create a 1:50,000 watershed atlas for the Yukon in order to create a Fisheries Information Summary System (FISS). They had previously accomplished this for the province of British Columbia through years of manual work. Using pre-built tools in FME Desktop’s graphical user interface, they were able to automate validation and error correction of provincial and federal base data to create the atlas for the Yukon. The resulting hydrological network is now available online, in a fraction of the time and cost required for the British Columbia atlas. Fisheries data can now be populated by trained, authorized locals to maintain a FISS for the region.
exactEarth wanted to leverage the marine vessel automatic identification system (AIS) to create a service providing near real-time ship location data globally. Prior to the project, the location of ships was not known on land beyond line-of-sight, as AIS data was only leveraged for nearby ship-to-ship navigation safety. Using FME Desktop, they connected the TCP/IP data stream of AIS data from their five satellites for the 100,000+ ships globally, and transformed millions of lines of binary coded text into grid data, for streaming via OGC WMS and WFS. They set up FME Server to automate these workflows to run 5,000,000 times a day, ensuring that the data is always up-to-date. exactEarth clients, including the Canadian DND, the Coast Guard, Transport Canada, and their international equivalents, now have access to ship route information which can be historically tracked, improving safety for those at sea and national defense. Based in Ontario, Canada, exactEarth is a leading organisation in the field of global AIS vessel tracking, collecting the most comprehensive ship monitoring data and delivering the highest quality information to customers around the world.
With more people abandoning land lines for cell phones, municipalities are faced with a difficult challenge in making targeted emergency broadcasts (Reverse 911) to citizens. California CAD helped their municipal client increase quantity of usable mobile numbers for reverse 911 from 65% to 99.5% (100% for records with valid addresses). Using FME Desktop, they replaced their traditional geocoding methods that performed slowly and had unacceptably low accuracy rates with automated, accurate, cost-effective workflows. They overcame challenges of normalizing and merging data from different vendors while validating accuracy, discovering unmatched addresses, and documenting the entire process. The new workflow is batch processed, it’s quick and easy to incorporate any address exceptions as they are found, and the original source data is unaltered, thereby enabling a viable audit trail of information. California CAD Solutions, Inc. has been in the Automated Mapping, Facilities Management, and Geographic Information Systems industry since 1987, specializing in doing what was said to be impossible.
Spatial DNA helped client NAV CANADA implement FME for managing aeronautical data. Using FME Desktop’s graphical user interface, they created workflows to perform tasks including: creating XML-based transactional update messages for NAV Canada’s national aeronautical data management system; ingesting several hundred flight path designs used in aircraft auto-navigation systems; and restructuring 3D airspace descriptions and communications services associated with each airspace for several thousand features in Canada. The FME workflows also help them improve the overall quality of the data as it is processed. Spatial DNA provides strategic insight and perspective to the integration of spatial data and technology into corporate information systems.
1Spatial recently optimized their client Ordnance Survey’s database checkout procedure. Using FME Desktop, the required subset of Ordnance Survey’s 500 million feature dataset can be checked out by 650+ editors on mobile, desktop, and web mapping editing suites. A single complex workflow designed using FME’s pre-built tools powers the required data model transformations that run 4,000+ times a day. Because FME Desktop’s graphical user interface replaces hand coding with self-documenting workspaces, it was possible for the new contractor to examine and optimize the existing data transformation process. This increased flexibility makes future updates to data transformations, such as this project, much more efficient. It also enables clients to own their workflows, regardless of contractor involvement. Ordnance Survey is the UK government agency responsible for the official, definitive topographic survey and mapping of Great Britain. 1Spatial provides the software solutions and services that manage the world’s largest spatial big data.
The GIS group at Alpine Shire Council wanted to improve accuracy of bushfire risk assessments for building permits following the devastation of Black Saturday. Using FME Desktop & FME Cloud, they designed a solution called BAL Plan that equips property assessors with trustworthy fire risk assessments drawn from real-time analyses of datasets such as topography, vegetation, and property boundaries. Designed to operate on mobile devices, it enables assessments to take place directly on the property beside the land owner making the safest place to build more easily identified. In just a few weeks, the entire FME portion of the project was planned and implemented. When an eleventh hour change to the algorithm change was required, the team was confident that they could update BAL Plan in under an hour because it's designed visually in a user interface, with no coding or developer involvement. Alpine Shire is located in the Australian state of Victoria, where the 2009 Black Saturday bushfires claimed 173 lives and over 2,000 properties.
Louisville Gas & Electric needed to integrate pipeline design data from multiple CAD applications into their corporate GE Smallworld database for record keeping. 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. Louisville Gas & Electric (LG&E) is a Fortune 500 diversified energy resources company with 1 million retail customers in the US and internationally.
After earthquakes demolished 70% of the downtown buildings in Christchurch, New Zealand, SCIRT - the city’s horizontal structures rebuild team - is using FME to integrate data from multitudes of disparate sources and analyse it. FME Server is being used to progress aspects of the rebuild including data acquisition, scoping and damage assessment, design, construction, transport, commercial, management reporting and GIS, as well as multi-organisation programmes regarding forward works. Spatial and non-spatial data from 20+ organizations is integrated using FME Server to form a 600+ layer GIS and provides both data and analytics-powered location intelligence for the city’s rebuild. The integration & analyses of horizontal rebuild data went so smoothly that FME has been implemented outside spatial data projects such as in finance and scheduling, and is being explored for scopes beyond the city’s rebuild. Stronger Christchurch Infrastructure Rebuild Team (SCIRT), is the organisation working to rebuild horizontal infrastructure in Christchurch, New Zealand following the 2010-2011 earthquakes.
The Brazilian Institute of Geography and Statistics (IBGE) was tasked with mapping Brazil at a scale of 1:250,000 to power strategic and environmental planning. FME Desktop & Server were used to consolidate the data from five disparate sources, transform it into the required models, perform data validation, and share the resulting map with people across the country. The workflows run automatically, keeping the data up-to-date in two separate database - one formatted to meet government requirements, the other to meet industry requirements. IBGE estimates that they would have required 30 staff instead of 3 to complete this project, had they not leveraged FME’s automation capabilities. Additionally, they anticipate replicating the project to other scales such as 1:1,000,000 or 1:1,000 easily with just a small change to the workflow. IBGE is the agency responsible for statistical, geographic, geodetic, cartographic, and environmental information in Brazil.
HOK was faced with the complex task to build a virtual representation of a real world 130 square mile city. Rather than hand modeling the 2 million buildings, HOK used FME Desktop to automatically generate the 3D buildings from existing data without writing any code. Using FME, they transformed and integrated BIM, GIS, CAD, and raster data, extracted subsets of data, added attribute information, and carried out calculations along the way. FME’s library of tools allowed them to execute data manipulations that weren’t possible using BIM and GIS applications. The resulting workflows saved immense time and effort, while retaining intelligence from existing information. HOK is a global design, architecture and planning firm with 1600 employees and a total of 24 offices located in North America, Europe and Asia. Its mission as an organization is to deliver exceptional design ideas and solutions for clients through the creative blending of human need, environmental stewardship, value creation, science and art.
Korem’s telecommunications client needed to provide an easy way for their internal data users to manipulate and extract databases, spatially enable it, and produce maps and reports. They built FME workflows that can be re-used as needed, providing the users with autonomy and flexibility. These users can integrate data from multiple sources, such as a customer call log, integrate that with network coverage, external data such as demographics or traffic, and create analyses and reports that can be used for business decision making. The telecommunications client now uses FME to manage aspects of the wireless network including call drops, where signals are, where newest customers are, customer churn, where to put new wireless technologies and towers, and other spatially relevant business decisions. As a specialist in geospatial technologies since 1993, Korem provides a complete range of services, software solutions and spatial data to optimize their clients’ business and strategic decisions. They are mainly from the telecommunications, insurance, retail, infrastructure management and public sectors.
Stadtwerke Münster’s goal was to be the first public transit agency on Google Transit in Germany. They worked with con terra GmbH to use FME for translating bus timetable information into the GTFS format. FME automated the data conversion process, helping them accomplish their goals 8 times faster than the neighbouring city which used custom coding. Data from timetable applications was converted to Google Transit and quality assurance checked using a single FME workspace that can be re-used whenever information changes. Owned by the citizens of the city, Stadtwerke Münster provides a variety of public services, including transportation of more than 120,000 people on their bus system every day.
The GIS team at Arup uses FME in nearly every project they work on. From data translation and manipulation to the challenge of finding data they already have. Arup gathers immense volumes of data from its projects globally. To make this information available for future endeavors, Arup implemented FME to spider through drives, cataloguing reusable data into a GIS database and converting it into a web map for easy access by colleagues. Desired data can then be quickly manipulated to suit the application in which it’s presently required. FME’s automation has dramatically reduced the GIS team’s effort. They feel that many of their accomplishments might have been impossible without FME. Arup is an independent global practice, offering services for all aspects of the built environment. The firm is responsible for the innovative engineering of world-renowned projects such as the Sydney Opera House, the Øresund Link between Denmark and Sweden, and the Beijing Olympic venues.
The city of Surrey provides 400 datasets for the public to download, empowering citizens, helping small businesses, and enabling socio-economic development. FME Server offers data downloads in formats beyond the few supported by open data portal CKAN, and allows users to select the precise subsets of data they desire using a map preview. Current data is now accessed by the public directly from the production database in all desired formats, including LAS, JSON, KML, File Geodatabase, DWG, CSV, MrSID, and PDF. FME provided immense time and cost savings for staff and the public. Surrey is the 2nd largest city in British Columbia, and is ranked one of the youngest and most culturally diverse cities in Canada.
Grand Lyon, France, uses FME to make their city’s data available to the public, empowering a variety of valuable services for citizens and businesses. Internal city data and that from partners are compiled and made available in real-time on a public data portal. FME Desktop and FME Server are easily scalable and provide an economically viable way to gather data from sensors, accident reports, data managers, web services, and distribute this time-sensitive information. Originally designed to simply provide data to the public, the impact of this project has gone beyond, providing innovative companies in the city a technical foundation for developing new services which optimize their operations and ultimately benefit citizens and tourists. One example is Renault Trucks and the implementation of their Urban Freights software to help reduce fuel consumption. Grand Lyon, France's second biggest city and capital of the Rhône-Alpes region, is situated at the crossroads of Europe's major lines of transport, at the heart of France between Paris and the French Riviera.
Forsmark and Sweco used FME to integrate nuclear power plant data into a single database. The results are made available in a web map platform that maintains high security of information. Disparate data including AutoCAD, Shapefile, Excel, Revit, and IFC are automatically integrated and transformed by FME Desktop & FME Server for storage in an Oracle Spatial database. Existing Microsoft Active Directory security settings are leveraged, allowing only authorized persons to view the data in various levels of detail in the new GeoServer web map platform on a computer or mobile device. Data is stored in both the original local coordinate system and the Swedish national to meet regulatory requirements. FME has automated the process, making up-to-date interior and exterior power plant data readily available to authorized individuals. Forsmark Power Group is a Swedish company that owns and operates the nuclear power plant Forsmark north of Stockholm.
Helsingin Energia uses FME to automate the integration, analysis, and delivery of energy consumption information, combining Excel files with city district geometries. This information is delivered in PDF maps which provide click-through access to details that show how electricity consumption behaves. The resulting outputs provide decision makers with location intelligence while offering significant time and budget savings for the company. Helsingin Energia is one of Finland's largest energy companies, selling electricity to about 400,000 customers and heat to over 90% of properties in Helsinki. They worked alongside Spatialworld on this project.
Devon Energy uses FME to centralize spatial system stores and display SCADA (supervisory control and data acquisition) data on a map for easy access. FME workflows automatically synchronize data from multiple disparate sources, replacing tedious manual effort. Transformation and validation processes in the workflows ensure that information is accurate and complete regardless of where or how it was originally stored. End users can now quickly access identical information, regardless of whether they’re using a computer in the office or a mobile device in the field. Devon Energy is one of the largest independent natural gas and oil producers headquartered in the United States, specializing in onshore exploration and production in North America.
FME restored work-life balance for administrators by automating incremental data updates and providing remote monitoring with mobile notifications. Flexible, generic data integration workflows meet a wide range of data update scenarios without custom workflow designs or data standardization. This saves time and dramatically reduces manual intervention in keeping data up-to-date. Incremental database updates do not require the additional hardware or tied up server time that complete dataset rewrites used to consume. Notifications enable administrators to remediate problems remotely from mobile devices in just minutes. Talisman Energy is one of Canada’s largest independent oil & gas companies, operating exploration and production globally.
Global Information Systems drastically reduced time required to perform quality control before data is entered into their client’s GIS. FME’s out-of-the-box tools made it easy to set up automated workflows that audit and validate incoming GIS drawings against an established standard before data is imported. The workflows are scalable for performance on a desktop or in large batches on a server. These automated quality assurance checks have replaced costly and time consuming manual effort. The solution is customizable and can easily evolve to meet changing business processes, provide notifications, and offer detailed error reports to speed data correction. Global Information Systems has provided the Pipeline Industry with solutions and software products to manage asset data, business workflows, and regulatory compliance since 2006. They worked on this project with client George Crowe, whose company delivers 100 million gallons of petroleum products daily through it’s US pipeline network.
UMass Amherst has improved facilities and campus planning efforts using FME to create a comprehensive common operating picture. Data from the campus’ many physical sub-systems, such as buildings, outdoor spaces, utilities, and transportation, which are maintained by several divisions using multiple IT tools and different formats, are automatically combined and maintained in a campus wide data warehouse. 2D data is even combined to create 3D visualizations of the campus. FME makes it possible to provide campus-wide analytics, bringing all these data elements and different formats (CAD, GIS, BIM) together for analysis in Tableau without changing existing workflows. Instead, technology enhances the workflows. UMass Amherst in Massachusetts is one of the major public research universities of the USA. The campus is spread over 1,450 acres and operates 12.8 million gross square feet of space in 200+ buildings and utilities facilitating 28,000+ students and over 5,000 employees.
Stadt Augsburg needed to provide timely access to city model data for their entire organization. They integrated FME Server into their web mapping platform as a download service, which delivers data stored in Esri Geodatabase as 3D PDFs on-demand. Now everyone has self-serve access to 3D visualization for city planning. This automation has improved productivity for the GIS team, sparing them of ongoing manual data delivery efforts. Located in Germany, the City of Augsburg is one of the country's three oldest cities and has a population of 270,000.
The University of Washington needed to implement an automated process for accurately updating AutoCAD floor plan drawings into a seamless, 2.5D, multi-campus Geodatabase. Using FME Desktop they were able to efficiently translate the CAD files into their GIS and validate that changes were processed correctly. This automated system saves time, allowing them to focus on developing ways to use the GIS, and also ensures decisions are based on the most accurate information. Located on 643 acres in Seattle, the University of Washington educates approximately 50,000 students annually. The facilities maintenance team is responsible for managing over 500 buildings.
CN’s GIS group required extraction of precise track centrelines from LiDAR datasets to help create accurate representations and provide detailed information that affect decisions regarding safety. FME offered a means of efficiently extracting accurate track centerlines from LiDAR datasets for precision mapping required for the Positive Train Control (PTC) safety mandate. FME’s breadth of format support enabled easy data sharing between systems and groups. Its automated workflows provided time savings and resulted in greater accuracy, critical for decisions affecting safety. CN is a transportation company offering integrated rail, trucking, freight forwarding, warehousing and distribution services across Canada and the USA.
FME Cloud enables GraftonTech to create data transformation workflows that address their aviation clients’ needs while eliminating the added costs of hardware, software, IT support and training. Workflows perform a variety of data conversions, calculations and validation tasks with different data sources and output requirements. For example, they can automatically validate and transform data into the US FAA standardized format and other formats, applications, and protocols. Tasks that once took hours or days are now completed in minutes, allowing airports to allocate resources to more critical activities. Grafton Technologies Inc. implements Geographic Information Systems and other spatial technologies for the aviation industry.
The State of Indiana used FME to streamline the integration of GIS data from 92 counties into a central repository, which is then made available through an online GIS data portal. The data is now readily available to assist with initiatives and emergency response activities across the state. FME Server was used to integrate and share data from the various GIS systems of 80+ counties. Each delivered their data via OGC WFS streams where FME Server took over, transforming and homogenizing it into a central Esri ArcSDE repository from which it was made available through the IndianaMap online GIS portal. FME provided the GIS team plenty of time and cost savings while ensuring that individual counties did not have to implement new process or spend any of their own budgets. The State of Indiana serves 6.5 million people across 92 counties.
The Athens-Clarke County Police Department reduced critical 9-1-1 map production time from two weeks to two hours using FME. First responders now have access to accurate, up-to-date information in a timely manner. Using FME technology, the ACCPD’s Information Management Division team developed a streamlined, repeatable system that automatically transforms and integrates data into information that is readily usable for 9-1-1 map production while keeping all data intact and accurate. The increased productivity of using FME saves the team time and effort, enabling them to focus on other important projects like contribution to Next Gen 9-1-1. The Athens-Clarke County Police Department (ACCPD) serves a diverse population of about 117,000 people in Athens, Georgia, about 65 miles northeast of Atlanta.
The RCMP in B.C.’s geomatics team is saving time and improving accuracy by using FME to create automated and streamlined data remodeling processes. Automated workflows designed in FME Desktop’s graphical user interface streamline recurring data remodeling processes. This data is used in mapping systems that are vital to the RCMP’s ability to police the province effectively. By implementing FME, the geomatics team has saved hours of time in providing officers and dispatchers accurate and timely maps for maximum effectiveness in policing efforts. The RCMP in B.C. or RCMP E Division, is the largest division of the Canadian national police service.
The Iowa DOT (IADOT) needed to automate the integration of business and road related data from three disparate sources. Using FME, repeatable workflows were built to clean up, validate, and integrate the data. Now assets are more accurately mapped in a spatial data management system, powering richer analysis and better informed decisions for roadway project planning. The GIS team is seeing increased productivity thanks to the automated integration. The Iowa Department of Transit (IADOT) maintains over 9,400 miles of roadway and 4,092 bridges to serve the transportation needs of the state's citizens.
BC Transit uses FME to integrate disparate databases into one, interconnected system that powers decision making and innovation. Data from multiple sources was integrated, validated, and transformed using FME to create a unified spatial data management system. The intelligence derived from the integrated data gives personnel new insight into the relationships between assets, ridership, time and location - in a timely manner - allowing them to innovate and implement new initiatives for a better transit system for everyone. The project has resulted in better intelligence for enhanced analytics, resulting in improved service and increased ridership. By implementing FME, the team has also seen an overall increase in efficiency and productivity of the organization. Tasks that once took days now take mere minutes. BC Transit manages 81 transit systems in more than 50 communities across the province, serving a ridership of over 50 million annually.
Williamson County used FME to quickly prepare their GIS data for contribution to Esri's Community Maps Program without writing any code. To participate in the Esri Community Maps Program, the Williamson County GIS and Addressing Department needed to quickly transform their GIS data to the required format, model and coordinate system. They created these data transformation workflows with the Data Interoperability Extension for ArcGIS, powered by FME. FME made it possible to contribute to this initiative without massive expenditures of time and money. The resulting project made GIS data more widely available for the benefit of everyone in the region. Willamson County's close proximity to Austin, high quality of life, and availability of land make it one of the fastest growing counties in Texas.
Shell Canada used FME to make important 3D spatial data available to non-technical stakeholders who do not have access to a GIS. Anyone at Shell Canada can now visualize detailed 3D models of assets in order to make decisions that are heavily dependent on spatial information, without using a GIS. After users select their area of interest through a webmap interface, FME Server retrieves the data content from ArcSDE and delivers it to them as a highly usable 3D PDF. FME’s automated worklows ensure that users get information they need without straining the GIS team. No additional software or training is required for non-technical personnel, while providing them access to rich 3D visual information for improved decision making. Shell Canada is part of a global group of companies and plays a key role in meeting the worlds energy demand in economically, environmentally and socially responsible ways.
Pelmorex Corp. used FME to create the Pelmorex Lightning Detection Network (PLDN). With FME Server’s data streaming and data download services, lightning strike data from their sensors is restructured from non-spatial lat/long queries into a styled KML file. It is then made accessible via Google Earth™, an ArcGIS® Flex™ Viewer, email alerts, and more. This required only 3 weeks to set up, and now runs automatically. Both real-time and archived strike data is immediately accessible for critical decision making to Pelmorex clients, including insurance companies, government agencies, transportation companies, and public utilities. Known as “The Weather Network” & “MétéoMédia”, Pelmorex is a Canadian broadcaster that produces leading multi-platform weather and traveler information services.
The San Antonio Water System (SAWS) created a web-enabled GIS to provide a seamless view of its service area and assets to power better decision making. Repeatable transformation workflows automatically connect disparate data sources, performing tasks such as adding location components to CAD and business data for visual analysis in a GIS. Personnel now experience uninhibited access to key information for better planning and improved productivity. FME technology dramatically reduced the effort to implement and maintain this system, providing SAWS an estimated $1 million savings in the first year alone. The San Antonio Water System provides water and wastewater services to about one million customers and maintains more than 9,000 miles of water and sewer mains.
HRSD uses FME to provide web-based data validation and loading services which facilitate the centralization of data from 14 localities. HRSD implemented an online data contribution service to collect pipeline and pump station data from 14 localities into a single repository. This information is used in planning to lower the environmental impact of their wastewater systems. Through its automated validation and loading capabilities, FME Server facilitated the contribution of data and ensured that it conformed to the repository's data model. FME saves the GIS team time and effort in keeping the repository up-to-date by making it easy for contributors to upload revised data. The automated upload, validation and transformation process has saved weeks of time over manual data collection and processing. The end product, a centralized, accurate view of wastewater collection system, helps identify areas that need improvement. The Hampton Roads Sanitation District (HRSD) is a utility that was created to prevent pollution, protect public health and support community development by providing wastewater collection and treatment.
Swisstopo has implemented FME to streamline map production and data management processes. Swisstopo moved from a disjointed, labour-intensive, CAD-based map production system to a sophisticated GIS system. FME Server provided a central spatial ETL interface to the datasets housed in ArcGIS Server's infrastructure delivering data to users in the format they need. FME eliminated manual data translation tasks, improving the team’s productivity. Access to any dataset is now available however it's needed, in a matter of seconds. Switzerland's Federal Office of Topography - swisstopo - is the map source for geodetic, topographic and geological data of any part of the country.
GeoGR Inc. uses FME to provide online, self-serve access to spatial data that is delivered to the user in their preferred format. The project’s success improves planning for professionals and the general public. GeoGR Inc. centralized the Graubünden area spatial data using FME's integration capabilities to interweave disparate source datasets and load them into a PostGIS database. Through FME Server's automated data delivery service, users can view, order and download this data, in the format they require through an online portal. Implementing FME’s automated workflow eliminated time-consuming manual translation and administrative tasks for data authors, while allowing them to continue working in their preferred environments. GeoGR Inc. was formed by Graubünden, the largest canton in Switzerland, along with private surveyors and planners to address the need for access to the area's spatial data.
Enstar Natural Gas Company & Alaska Map Science used FME to perform the rapid migration of a large volume of AutoCAD drawings into an Esri ArcSDE Geodatabase. Enstar migrated 5,000 AutoCAD drawings of their natural gas lines into a new GIS mapping system. FME allowed them to accomplish the complex data transformation while maintaining important associated data, all within a tight deadline. FME’s data conversion and transformation capabilities enabled Enstar to use information that was previously inaccessible in the CAD files and ensured that no information was lost during translation. Enstar Natural Gas Company provides natural gas service to approximately 340,000 customers in South Central Alaska via 3,000 miles of distribution lines and 450 miles off high-pressure transmission lines.