I have a text file extracted from an Oracle Spatial Object containing an ID field and ST_GEOMETRY with a pipe delimiter between the fields. I would like to create a polygon shapefile from it using PointConnector, or any other transformer. PointConnector does not recognize the ST_GEOMETRY field.
Question
Using PointConnector to create polygon shapefile from text file
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.
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.
+26- Contributor
Could you restructure the geometry attribute to something like this ( POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)) ) using the StringReplacer and feed that to the GeometryReplacer usng the WKT encoding?
+46- Influencer
I've done it before but it's not straightforward. When I've had to do this it involves extracting the coordinates from the string and sending them into a vertex creator before using the point connector Donut geometries and other more complex shapes also need special treatment.
Could you post a line from your file here so we can see exactly what it looks like? The most important bit is the geometry, of course.
+59- Safer
Yes, either an AttributeSplitter/VertexCreator combo or try to restructure it in a form (like WKT) that FME can decipher. Alternatively (a long shot) try reading the file with the CSV reader using a pipe delimiter? Not sure how far that would get you but I throw it out as a suggestion.