Dear all,
I have a large list of geojson polygons in excel. Each cell contains a geojson polygon, such as this:
{"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[111.389514,-0.461461],[111.389468,-0.461498],[111.389487,-0.461534],[111.389488,-0.46158],[111.389479,-0.461618],[111.389477,-0.461673],[111.389459,-0.461752],[111.389452,-0.46183],[111.389451,-0.461893],[111.389436,-0.461941],[111.389427,-0.462026],[111.389426,-0.462087],[111.389381,-0.46211],[111.389515,-0.46146]]]}}]}
See also attached file. I want to check if the polygon is closed. This means that the first coordinate [111.389514,-0.461461] must be the same as the last [111.389515,-0.46146]. In the upper example, this is not the case. I would like to find the cell's where this problem occurs: either by indicate correct polygons (where the first coordinate = last coordinate) or by looking for incorrect cells. To me it makes more sense to search on correct polygons (so cells that have 2 duplicate coordinate strings). Any idea what function I can use for this? I supose it should look for 2 duplicates in a string. If it find 2 duplicate strings, than the polygon is correct. Thanks in advance!
Bookmarks