I am trying to determine which transformers to use in FME that perform the same tasks in ArcGIS. (I am working with the 2015 version.)
Two polygon layers representing parcels and elevation are intersected to form parcel elevations.
- ArcGIS dissolve: to aggregate duplicate Intervals based on the Parcel ID.
- Select by attribute and calculate field: to select specific Intervals and populate a corresponding field with the calculated acreage.
Example with just one record:
Intersected Table: Multiple duplicate intervals.
PARCEL_ID
INTERVAL
ELEV_00to01
ELEV_01to02
ELEV_02to03
ELEV_03to04
ELEV_04to05
SHAPE_Length
SHAPE_Area
1773860530R
0-1
571.09
5248.08
1773860530R
0-1
39.86
19.24
1773860530R
1-2
1313.86
14638.28
1773860530R
1-2
180.39
64.99
1773860530R
2-3
2376.04
39618.10
1773860530R
2-3
627.33
130.58
1773860530R
2-3
165.69
952.03
1773860530R
3-4
1208.54
11412.15
1773860530R
3-4
179.26
48.36
1773860530R
3-4
168.57
554.17
1773860530R
4-5
54.19
63.21
1773860530R
4-5
139.79
612.06
Dissolved Table: No duplicate intervals,then each elevation range is calculated based on interval.
PARCEL_ID
INTERVAL
ELEV_00to01
ELEV_01to02
ELEV_02to03
ELEV_03to04
ELEV_04to05
SHAPE_Length
SHAPE_Area
1773860530R
0-1
0.12
610.95
5267.33
1773860530R
1-2
0.34
1494.25
14703.26
1773860530R
2-3
0.93
3169.06
40700.72
1773860530R
3-4
0.28
1556.37
12014.67
1773860530R
4-5
0.02
193.98
2024.03
Desired Result: All elevation ranges are aggregated to a single Parcel ID. (Achieved with the Aggregator Transformer.)
PARCEL_ID
ELEV_00to01
ELEV_01to02
ELEV_02to03
ELEV_03to04
ELEV_04to05
SHAPE_Length
SHAPE_Area
1773860530R
0.12
0.34
0.93
0.28
0.02
7024.61
74710.01
The problem is that I’m trying to achieve all of these steps in FME rather than bouncing back and forth from ArcGIS. Transformers that I've found don't quite get me the desired results. Any pointers would be greatly appreciated.
