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
  • 18 views

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]

1 reply

david_r
Evangelist
  • 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


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