Extracting XYZ for linestring and writing to excel
Best answer by vijai
Thanks for your suggestions, I could reach more than half way of my required output.
I ended in extracting vertex coordinates attributes for each line string with unique ID, I still need to give ID for first and last vertex for each line string . Any more suggestions??
Thanks
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.
You can use the VertexExtractor from the FME Store, it will convert a polyline into points, preserving all the input attributes.
David
+11- Contributor
Regarding layer name and color:
A format attribute called "fme_feature_type" stores the layer name. You can expose this attribute in the "Format Attributes" tab of the reader feature type properties dialog.
For color, see the "fme_color" (pen color) and "fme_fill_color" (fill color), or format specific attributes which store color information. e.g. "igds_color" and "igds_fill_color" for the DGN format.
If you need to extract only coordinates of first and end points, you can also use two CoordinateExtractors in a series. Set 0 to the Index parameter for the first point, -1 for the end point.
Takashi
Thanks for your suggestions, I could reach more than half way of my required output.
I ended in extracting vertex coordinates attributes for each line string with unique ID, I still need to give ID for first and last vertex for each line string . Any more suggestions??
Thanks
Thanks for your suggestions, I could reach more than half way of my required output.
I ended in extracting vertex coordinates attributes for each line string with unique ID, I still need to give ID for first and last vertex for each line string . Any more suggestions??
Thanks
I'm not sure I understand the question, could you please give an example?
+59- Safer
Thanks for your suggestions, I could reach more than half way of my required output.
I ended in extracting vertex coordinates attributes for each line string with unique ID, I still need to give ID for first and last vertex for each line string . Any more suggestions??
Thanks
I wonder if this question provides the solution?
https://knowledge.safe.com/questions/19945/database-schema-to-custom-writer-format-ev-extensi.html
I'm not sure I understand the question, could you please give an example?
vertex-id-placer.jpg
David,
Hope the above image explains my need, I did some workout , but could not get a result just like above
Regards
Vijai
vertex-id-placer.jpg
David,
Hope the above image explains my need, I did some workout , but could not get a result just like above
Regards
Vijai
Try inserting a CoordinateCounter before the VertexExtractor. After the VertexExtractor, if _vertex_number = 0 then it's your first coordinate. If _vertex_number = (_coordcount -1) then it's your last coordinate. You can then set the text for the UID column accordingly.
Hope this helps.
I found the way to extract the Vertex (first, last, mid) for a line string with UID and other attributes.
Vijai