Skip to main content
Solved

Reading a CSV file with multiple coordinates in one attribute


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?

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.

View original
Did this help you find an answer to your question?

3 replies

dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • April 8, 2019

Use an AttributeSplitter based on ";" to breakout each coordinate.


erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • Best Answer
  • April 8, 2019

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.


  • Author
  • April 10, 2019
erik_jan wrote:

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.

Thanks for the response.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings