I'm using the Data Interoperability extension and I'm attempting to read in a csv file that has a column with a string of coordinates in it. I've tried loading it into the Spatial ETL Tool CSV reader, using the coordinate concatenator and then the area builder. I get a rejected feature warning when I try running the tool. Can anyone offer some pointers for this?
Solved
Reading a CSV file with multiple coordinates in one attribute
Best answer by erik_jan
Use a AttributeCreator to concatenate the coordinate string into this format:
POLYGON ((0 0,10 0,10 10,0 10,0 0))
Then use the GeometryReplacer (OGC Well Known Text) to read the attribute as geometry.
Hope this helps.
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
- Best Answer
Use a AttributeCreator to concatenate the coordinate string into this format:
POLYGON ((0 0,10 0,10 10,0 10,0 0))
Then use the GeometryReplacer (OGC Well Known Text) to read the attribute as geometry.
Hope this helps.
Use a AttributeCreator to concatenate the coordinate string into this format:
POLYGON ((0 0,10 0,10 10,0 10,0 0))
Then use the GeometryReplacer (OGC Well Known Text) to read the attribute as geometry.
Hope this helps.