We work with you closely to design the best data flow solution for your organisation and application requirements. Thanks to our wealth of experience we are in a position to provide you with comprehensive advice in terms of the tools’ individual strengths and weaknesses. Alternatively we work with tools for the transformation of special spatial formats, such as FME by “Safe Software”. Depending on the requirements, we use modern data integration tools such as Talend with Disy’s extension “ GeoSpatial Integration”. We design and model the necessary ETL jobs or directly develop respective routines in the database. Partial result of the report is shown in Table 1.In order for your data to be always up-to-date and quality assured in the future, we automate these data flows with the help of ETL processes (extraction, transformation and loading). The following workspace shows the simple workflow for this challenge: This capability is already implemented in LinearBench® Analyze still we decided to also offer it as an FME custom transformer, and LRS_EventSummarizer was born. The second challenge came from Dave Blackstone, GIS Manager of Ohio DOT, who would like to summarize a subject event data set over a reference data set for key statistics, including length-predominate stats, among other things. With the help of LinearBench® custom transformers such as LRS_EventMerger, LRS_EventJoiner, LRS_Geocoder, and LRS_RevGeoCoder, the process was made clean, friendly and adaptable to changes. Out of the box, FME does not provide a direct solution. Optionally, remove sliver project segments as a result of discrepancies between the data layers.LRS reverse geocode the result from Step 4 so each feature will have the correct From Measure and To Measure values in its attributes.Overlay line features from Step 3 with boundary features to get the attributes from the boundaries.
LRS geocode the events resulting from Step 2 to turn it into a feature dataset.Join (overlay) project events with the events resulting from Step 1.
Merge HPMS segments based on functional classification and NHS code.A deeper look into the requirements and data sets resulted in the following multi-step process:
Moreover, it provides a platform to design, test, develop and document your workflow which is highly adaptable to changes in requirements as well as data sources.Īt the GIS-T 2016 Symposium in Raleigh NC, Dave Campanas of Safe Software and I jointly presented FME & ARNOLD: Superman to the Rescue! After the session, Kyle Konterwitz, GIS Manager of Kansas DOT, approached me for generating a report using FME, something they had attempted for some time now – a project feature report segmented by Functional Classification and NHS designation, as well as several administrative and political boundaries.Īt first glance, this commonly-requested report is conceptually simple. Why not? At its core, FME provides a comprehensive set of data ETL tools that extend beyond the spatial domain. Whether you are glad that the HPMS season will be ending soon, or stressed that the deadline is looming, or both, you owe it to yourself to check out FME-based tools for HPMS.