Skip to main content
Question

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

  • December 13, 2019
  • 9 replies
  • 27 views

Forum|alt.badge.img

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

 

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

9 replies

takashi
Celebrity
  • 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

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

example.xlsxpie_maker.fmw roads_part.zip


takashi
Celebrity
  • 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

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
Celebrity
  • 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.

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


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

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

So, here is the picture.


takashi
Celebrity
  • 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

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.