Purpose & Objectives

This workspace demonstrates identifying street food vendor points that may be impacted by upcoming road construction projects. It illustrates several common spatial and tabular data processing steps.

Key Transformers

Bufferer: buffering line segments (representing noise impact areas from road construction)

AttributeValidator: validating attribute values

SpatialFilter: finding points that intersect polygons (the buffered construction areas)

Tester: filtering features based on attribute values

FeatureJoiner: joining features based on a shared key

AttributeManager: removing and renaming attributes

Data Source(s) - Reader Feature Type

road-ahead-upcoming-projects.shp Esri Shapefile - road-ahead-upcoming-projects worksheet

food-vendors CSV - CSV

business-licences SQLite - business-licences table

Data Output - Writer Feature Type

AffectedVendors Microsoft Excel - Newly created AffectedVendors worksheet

Parameters:

Overwrite Existing File set to Yes (the workbook will be recreated each time the workspace is run)

Customization

To customize this workspace, try changing the value of Buffer Distance when you run the workspace. This user parameter allows the end user to affect how the workspace runs. Increasing the distance will mean more food vendors are included in AffectedVendors.

Additional Resources

Sign up for the free, interactive FME Accelerator workshop to learn more about this workspace and learn the basics of automating your data integration workflows and connecting to 450+ formats.

For help with this workspace, please contact Safe Software Support and reference Roadwork Impact: Construction Alert Gallery Example.