Hello community,
I'm very new to python and try to rebuild/optimize workflows I've done in Modelbuilder.
My current problem set:
I have an xls containing multiple rows and collum's. one of them is a Coordinate Field, containing MGRS coordinates.
Each row represents either a Point, Line or Polygon (dedicated by a Field called "Type").
For Lines and Polygons, the Coordinate field contains multiple MGRS coordinates, separate by a semicolon.
Up to now I always separated the sheet manually by point Line and Area and convert the multiple coordinates into multiple rows using power queries in xls and a model in ArcPro to create the features.
What I'm looking for is a pythonic way to create the point features (from here I get it on my own to lines and polygons) from the xls, using the MGRS as CoordString directly and not using the ConvertCoordinate Tool. I thought about the combination of Search- and InsertCursors plus the FromCoordString function because I don't have xy formatted coordinates, but I don't find a starting point.
If anyone has experience in using MGRS(or simmilar cordString) to create features, I would be very thankful for any suggestions!
ArcPro Version is 2.6.1