Skip to main content
Question

Clip lines and add more attributes values in one cell in attribute table of lines from attributes of pies


Forum|alt.badge.img

I want to get this. I upload shp, xls and fmw. Can you give me some idea. Thanks a lot.

 

 

9 replies

takashi
Evangelist
  • December 14, 2019

The uploaded files are broken for some reason. Please upload them again.


Forum|alt.badge.img
  • Author
  • December 14, 2019
I'm not able to upload until Monday. Then I will.

Forum|alt.badge.img
  • Author
  • December 16, 2019
takashi wrote:

The uploaded files are broken for some reason. Please upload them again.

example.xlsxpie_maker.fmw roads_part.zip


takashi
Evangelist
  • December 16, 2019

Hi @maloks, I think you need to modify the workspace at these two points.

First, you have to create point geometry based on LAT and LON with a VertexCreator before reprojection, since features read from Excel dataset don't have any geometry.

Second, you cannot use coordinate system name "HTRS96" in the Reprojector setting, since FME doesn't support it. You need to select an appropriate coordinate system from the FME Coordinate System Gallery.


Forum|alt.badge.img
  • Author
  • December 16, 2019
takashi wrote:

Hi @maloks, I think you need to modify the workspace at these two points.

First, you have to create point geometry based on LAT and LON with a VertexCreator before reprojection, since features read from Excel dataset don't have any geometry.

Second, you cannot use coordinate system name "HTRS96" in the Reprojector setting, since FME doesn't support it. You need to select an appropriate coordinate system from the FME Coordinate System Gallery.

Making pie shapes is ok, I made custom coordinate system HTRS96. My problem is in the next step where I have to get id from pie in the attribute table of roads like on the picture above.


takashi
Evangelist
  • December 16, 2019
takashi wrote:

Hi @maloks, I think you need to modify the workspace at these two points.

First, you have to create point geometry based on LAT and LON with a VertexCreator before reprojection, since features read from Excel dataset don't have any geometry.

Second, you cannot use coordinate system name "HTRS96" in the Reprojector setting, since FME doesn't support it. You need to select an appropriate coordinate system from the FME Coordinate System Gallery.

I cannot see the picture. Could you please post it again?


Forum|alt.badge.img
  • Author
  • December 16, 2019
takashi wrote:

I cannot see the picture. Could you please post it again?

So, here is the picture.


takashi
Evangelist
  • December 16, 2019

You can use the AreaOnAreaOverlayer to overlay the pie-shape areas and populate Cell IDs of overlapped areas into a list attribute. Then, concatenate the list elements (i.e. Cell IDs) with the ListConcatenator delimited by your preferred separator and transfer it to clipped lines with the Clipper.

Hope this helps.


Forum|alt.badge.img
  • Author
  • December 16, 2019
takashi wrote:

You can use the AreaOnAreaOverlayer to overlay the pie-shape areas and populate Cell IDs of overlapped areas into a list attribute. Then, concatenate the list elements (i.e. Cell IDs) with the ListConcatenator delimited by your preferred separator and transfer it to clipped lines with the Clipper.

Hope this helps.

Thanks a lot.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings