
Explore data transformation with FME and its transformers for spatial and non-spatial data. Design workspaces, read from diverse sources, analyze UK vehicle accidents, and publish results to PostGIS.
Discover how FME enables spatial and non-spatial data transformation and integration using readers, transformers, and writers for ETL workflows. Learn the download and installation steps and licensing basics.
Learn how to apply for the FME trial license through charitable, university, student, or evaluation options, with processing times and activation instructions.
Import data from excel, csv, shapefile, and geojson using the reader, merge sheets, and map results, then inspect the translation log and base maps.
Import data from GeoJSON and PostGIS into FME, rename attributes with the Attribute rename transformer, and export to CSV, shape file, and KML.
Export data from a GeoJSON reader to CSV, KML, and shapefile formats using attribute transformers such as remover, renamer, or manager to map and clean fields.
Reproject data with the reprojector to assign the correct crs and align coordinates. Use test filter and spatial filter to select centers, add annotation and bookmarks, and export formats.
Explore AFM workflows with readers, writers, and transformers, including automatic versus dynamic schema, and practical use of test filter, tester, dissolver, and buffer for data from Excel, GeoJSON, and PostGIS.
Learn how to build and connect FME transformers, such as terminator, creator, projector, area calculator, and length calculator, to end processes and extract areas.
Master designing organized FME workspaces with bookmarks, apply sampler and junction transformers, and use point-on-area layer transformers for spatial analysis and data summarization across regions.
Demonstrate conditional value, feature reader, and feature writer transformers, and overlay operations such as point on area and area on area, with population density calculations and data export examples.
Learn to use FME transformers to count features, assign serial numbers, and split attributes in geospatial data. Explore Counter, FeatureCounter, Sorter, and AttributeSplitter for practical data handling.
Master FME transformers for concatenating strings into a complete address, changing string case to uppercase, and merging or joining attributes with inline queries.
Explore FME transformers string replacer, junction, and html report generator to replace text, distribute data, and generate html reports with charts for province population and area.
Learn to read tiff rasters, merge them with a raster mosaicker, overlay vector features on the raster using a vector on raster overlay, and zip the output.
Read and transform UK traffic accidents from CSV and KML, map vehicle types, reproject to EPSG 27700, sample data, identify nulls, and export to CSV, KML, shapefile, GeoJSON, and Postgres.
Clean data by checking nulls and duplicates, merge CSV and KML attributes with a feature merger, and map vehicle type codes to names for clearer reports.
Learn how to merge Excel, CSV, and KML data in FME with attribute manager steps, rename fields, convert day-of-week numbers to names, run statistics, and generate Excel reports.
Apply FME to analyze UK road traffic accidents, group by date and time to reveal peak incidents and casualties, and export results to CSV, KML, Shapefile, GeoJSON, and PostGIS.
Learn how to convert 3D spatial data to 2D for PostGIS, using vertex three, assign correct CRS, handle missing attributes and duplicates, and push cleaned data to PostGIS.
Advance data integration in the FME UK RTA project by debugging KML and CSV writers, extracting reports, and visualizing traffic accident insights with Esri dashboards.
Explore the essentials of fme for etl workflows, mastering readers, writers, and transformers to clean, join, and analyze spatial and non-spatial data, and export results to postgis and common formats.
Learn the essentials of the feature manipulation engine and read the course materials; the instructor invites you to leave a kind comment to support the learning process.
Embark on a transformative two-section journey in our course, "FME Essentials: Forging a Strong Ground for Spatial and Non-Spatial ETL Workflows." In the First Section, kickstart your FME exploration by downloading the tool and securing a trial license from SafeSoftware Company (note that an official email address is required for this step). This immersive experience begins with an in-depth navigation of the user interface, guiding you through the intricacies of handling various data formats using FME readers. Delve into the art of data transformation, mastering a diverse array of transformers, and acquiring proficiency in efficiently writing or exporting data into multiple formats utilizing FME writers.
As you seamlessly transition into the Second Section, dive into a hands-on project that delves into the complexities of real-world data challenges. Take on uncleaned non-spatial and spatial data, skillfully combining and transforming these datasets for a meticulous cleanup. Conduct a comprehensive data analysis, extracting valuable insights that unravel the narrative hidden within the information. The project's culmination involves exporting the refined data into various formats and showcasing your newfound skills, including proficiency in exporting to PostGIS.
This course not only imparts fundamental skills but also provides a holistic understanding through a real-world project experience. By seamlessly blending theory with practical application, you will emerge not just knowledgeable but proficient in leveraging FME for intricate spatial and non-spatial ETL workflows, setting the stage for a successful and impactful journey in data transformation.