Skip to main content
Question

I have an excel with several rows and one column contains several lat/long for a polygon for each row. How to convert those lat/long of points into polygon?

  • October 18, 2018
  • 1 reply
  • 19 views
R

I have an excel with several rows and one column contains several lat/long for a polygon for each row. How to convert those lat/long of points into polygon?

e.g. one column contains

[100.61279296875, 13.9141845703125], [100.61279296875, 13.919677734375], [100.623779296875, 13.919677734375], [100.623779296875, 13.9141845703125], [100.61279296875, 13.9141845703125]

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.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • October 18, 2018

One solution is to wrap it up in some simple GeoJSON boilerplate and use the GeometryReplacer.

Let's say your column is called 'geometry'. Create a new attribute 'geojson' that has the following defintion (use the Text Editor):

{"type":"Polygon","coordinates":[[@Value(geometry)]]}

Then pass it through a GeometryReplacer:

0684Q00000ArLIOQA3.png

Community Stats

32,084
Posts
121,835
Replies
39,721
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.