| Flood Risk Project: Simple Filtering Method | |
| Start Workspace | C:\FMEData2016\Workspaces\DesktopAdvanced\Attributes-Ex2-Begin.fmw |
| End Workspace | C:\FMEData2016\Workspaces\DesktopAdvanced\Attributes-Ex2a-Complete.fmw |
This simple filtering method is a two-step process involving an AttributeFilter and several AttributeRangeMapper transformers. You should already have the start workspace open.
1) Place AttributeFilter
Place an AttributeFilter connected to the AttributeRenamer:
Open the parameters dialog. Select Zone as the attribute to filter by. In the Attribute Values field enter the values 100, 200, and 300:
You could use the Import function, but for so few values it’s hardly worth it.
Click OK to close the dialog and you’ll see a new output port added for each value you specified.
2) Add AttributeRangeMapper
Add an AttributeRangeMapper transformer and connect it to the 100 output port of the AttributeFilter:
Open the parameters dialog. As you’ll see this is a lookup table that involves ranges. We should be able to map the elevation range to a final flood risk using the information in the original table.
So, select Elevation as the Source Attribute. Enter FloodRisk as the Output Attribute:
In the Range Lookup Table, enter the From-To values as follows:
| From | To | Output Value |
|---|---|---|
| 0 | 10 | 1 |
| 10 | 25 | 2 |
| 25 | 60 | 3 |
If an elevation falls exactly on one value (for example 25) it will be counted in the lower band (i.e. 10-25). Enter 999 as the Default, so that any features whose elevation does not match, for whatever reason, is flagged appropriately:
Click OK to close the dialog.
| Miss Vector says... |
| Hopefully you see that the Output Value numbers come from the flood risk table in the introduction to this exercise! |
3) Duplicate AttributeRangeMapper
Now we need to do the same thing for each of the other AttributeFilter output ports. Rather than set them up manually – as above – the easiest method is to copy the AttributeRangeMapper transformer that we just set up.
So, click on the existing AttributeRangeMapper and press Ctrl+D to duplicate it. Repeat and connect each duplicate to a different AttributeFilter output port.
The workspace will now look like this:
Now open the parameters dialog for each of the new AttributeRangeMapper transformers in turn and set up the correct Output Values in accordance with the original table of calculations.
The values will be:
| 100m Zone | 1 | 2 | 3 |
| 200m Zone | 2 | 3 | 4 |
| 300m Zone | 3 | 4 | 5 |
4) Add Inspector
Place a single Inspector transformer and connect each AttributeRangeMapper output to it.
Open the Inspector parameters dialog and under Group-By select the newly created attribute called FloodRisk.
| .1 UPDATE |
| In 2016.1 the quickest way to do this is select all of the AttributeRangeMapper transformers and then add an Inspector using Quick Add. This will automatically connect all three transformers and is a new piece of functionality for this version of FME. You'll still need to manually set the group-by setting on the Inspector. |
5) Save and Run Workspace
Save and run the workspace. You should see each address colored to match its flood risk. You can also turn off each zone in turn to see which addresses are most/least at risk.
| Professor Lynn Guistic says… |
| If you’re sharp today, you’ll have noticed you could do this process in the reverse order. Instead of handling zone then elevation, you could handle elevation then zone using a combination of AttributeRangeFilter and AttributeValueMapper transformers. |
| CONGRATULATIONS |
By completing this exercise you have learned how to:
|