Question

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

  • 13 December 2019
  • 9 replies
  • 0 views
M
Badge

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

 

 

9 replies

takashi
Rank
Userlevel 2
Badge +17

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

M
Badge 
I'm not able to upload until Monday. Then I will.
M
Badge

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

example.xlsxpie_maker.fmw roads_part.zip

takashi
Rank
Userlevel 2
Badge +17

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.

M
Badge

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
Rank
Userlevel 2
Badge +17

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?

M
Badge

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

So, here is the picture.

takashi
Rank
Userlevel 2
Badge +17

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.

M
Badge

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.

Reply


Community Stats

28,723
Posts
109,511
Replies
36,559
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.